CREATE TABLE `rfc` ( `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, `remote_id` varchar(50) DEFAULT NULL, `created` DATETIME NOT NULL, `updated` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=`InnoDB`; ALTER TABLE `rfc` ADD CONSTRAINT `rfc_user_fk` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);