RSS Git Download  Clone
Raw Blame History
CREATE TABLE `rfcs` (
  `id` int NOT NULL auto_increment,
  `reason` varchar(50) NOT NULL,
  `details` TEXT NOT NULL,
  `status` varchar(50) NOT NULL,
  `user_id` smallint NOT NULL,
  `timestamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, 
  PRIMARY KEY  (`id`)
) ENGINE=`InnoDB`;

ALTER TABLE `rfcs`
ADD CONSTRAINT `rfcs_user_fk` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);