CREATE TABLE `orders` ( `id` bigint(20) NOT NULL default '0', `description` text, `exclusive` enum('yes','no') NOT NULL default 'yes', PRIMARY KEY (`id`) ) TYPE=MyISAM; INSERT INTO `orders` VALUES (1, 'test', 'yes'); CREATE TABLE `products` ( `id` bigint(20) NOT NULL default '0', `order_id` bigint(20) NOT NULL default '0', `name` varchar(255) default NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM;