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`);