· 8 years ago · Mar 02, 2018, 02:52 PM
1DROP TABLE IF EXISTS `fm_people`;
2CREATE TABLE `fm_people` (
3 `id` int(10) unsigned NOT NULL auto_increment,
4 `name` varchar(255) NOT NULL default 'Not entered',
5 `test` text NOT NULL,
6 `group_id` int(10) unsigned NOT NULL,
7 PRIMARY KEY (`id`),
8 KEY `fk_group_id` (`group_id`),
9 CONSTRAINT `fk_group_id` FOREIGN KEY (`group_id`) REFERENCES `fm_groups` (`id`)
10) ENGINE=InnoDB DEFAULT CHARSET=utf8;