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