iYjgmu12

1DROP TABLE IF EXISTS `fm_groups`;
2CREATE TABLE `fm_groups` (
3  `id` int(10) unsigned NOT NULL auto_increment,
4  `name` varchar(50) NOT NULL,
5  PRIMARY KEY  (`id`)
6) ENGINE=MyISAM DEFAULT CHARSET=utf8;
7
8INSERT INTO `fm_groups` (`id`,`name`) VALUES (1,'test');
9
10DROP TABLE IF EXISTS `fm_people`;
11CREATE TABLE `fm_people` (
12  `id` int(10) unsigned NOT NULL auto_increment,
13  `name` varchar(255) NOT NULL default 'Not entered',
14  `test` text NOT NULL,
15  `group_id` int(10) unsigned NOT NULL,
16  PRIMARY KEY  (`id`),
17  CONSTRAINT `fk_group_id` FOREIGN KEY (`group_id`) REFERENCES `fm_groups` (`id`) ON DELETE CASCADE
18) ENGINE=InnoDB DEFAULT CHARSET=utf8;
19
20INSERT INTO `fm_people` VALUES (1,'Stephen Ball','',1);