DROP TABLE IF EXISTS `t_contacts`;
CREATE TABLE `t_contacts` (
`id` int(10) unsigned NOT NULL auto_increment,
`groupid` int(11) unsigned NOT NULL default '0',
`name` varchar(128) NOT NULL default '',
`email` varchar(128) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
INSERT INTO `t_contacts` (`id`, `groupid`, `name`, `email`) VALUES (1, 1, 'name1', 'email1@aaa.com'),
(2, 1, 'name2', 'name2@bbb.com'),
(3, 3, 'name3', 'name3@ccc.com'),
(4, 0, 'name4', 'name4@ddd.com');
DROP TABLE IF EXISTS `t_groups`;
CREATE TABLE `t_groups` (
`groupid` int(10) unsigned NOT NULL auto_increment,
`name` varchar(128) NOT NULL default '',
PRIMARY KEY (`groupid`)
) TYPE=MyISAM;
INSERT INTO `t_groups` (`groupid`, `name`) VALUES (1, 'Group Nr 1'),
(2, 'Group Nr 2'),
(3, 'Group Nr 3');