CREATE TABLE `plus2_cat` ( `cat_id` int(3) NOT NULL auto_increment, `cat_name` varchar(50) NOT NULL default '', UNIQUE KEY `cat_id` (`cat_id`) ) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ; -- -- Dumping data for table `plus2_cat` -- INSERT INTO `plus2_cat` VALUES (1, 'Asia'); INSERT INTO `plus2_cat` VALUES (2, 'Africa'); INSERT INTO `plus2_cat` VALUES (3, 'Europe'); INSERT INTO `plus2_cat` VALUES (4, 'N America'); INSERT INTO `plus2_cat` VALUES (5, 'Australia'); INSERT INTO `plus2_cat` VALUES (6, 'S America'); -- -------------------------------------------------------- -- -- Table structure for table `plus2_subcat` -- CREATE TABLE `plus2_subcat` ( `subcat_id` int(6) NOT NULL auto_increment, `subcat_name` varchar(80) NOT NULL default '', `cat_id` int(3) NOT NULL default '0', UNIQUE KEY `subcat_id` (`subcat_id`) ) ENGINE=MyISAM AUTO_INCREMENT=39 DEFAULT CHARSET=latin1 AUTO_INCREMENT=39 ; -- -- Dumping data for table `plus2_subcat` -- INSERT INTO `plus2_subcat` VALUES (1, 'Afganistan', 1); INSERT INTO `plus2_subcat` VALUES (2, 'Baharin', 1); INSERT INTO `plus2_subcat` VALUES (3, 'Bangaladesh', 1); INSERT INTO `plus2_subcat` VALUES (4, 'Burma', 1); INSERT INTO `plus2_subcat` VALUES (5, 'Bhutan', 1); INSERT INTO `plus2_subcat` VALUES (6, 'Brunei', 1); INSERT INTO `plus2_subcat` VALUES (7, 'Algeria', 2); INSERT INTO `plus2_subcat` VALUES (8, 'Angolo', 2); INSERT INTO `plus2_subcat` VALUES (9, 'Benin', 2); INSERT INTO `plus2_subcat` VALUES (10, 'Botswana', 2); INSERT INTO `plus2_subcat` VALUES (11, 'Burkina', 2); INSERT INTO `plus2_subcat` VALUES (12, 'Burundi', 2); INSERT INTO `plus2_subcat` VALUES (13, 'Albania', 3); INSERT INTO `plus2_subcat` VALUES (14, 'Andorra', 3); INSERT INTO `plus2_subcat` VALUES (15, 'Armenia', 3); INSERT INTO `plus2_subcat` VALUES (16, 'Austria', 3); INSERT INTO `plus2_subcat` VALUES (17, 'Azerbizan', 3); INSERT INTO `plus2_subcat` VALUES (18, 'Belarus', 3); INSERT INTO `plus2_subcat` VALUES (19, 'Antigua and Barbuda', 4); INSERT INTO `plus2_subcat` VALUES (20, 'Bahamas', 4); INSERT INTO `plus2_subcat` VALUES (21, 'Belize', 4); INSERT INTO `plus2_subcat` VALUES (22, ' Barbados', 4); INSERT INTO `plus2_subcat` VALUES (23, 'Canada', 4); INSERT INTO `plus2_subcat` VALUES (24, 'Costa Rica', 5); INSERT INTO `plus2_subcat` VALUES (25, 'Cuba', 4); INSERT INTO `plus2_subcat` VALUES (26, 'Dominica', 4); INSERT INTO `plus2_subcat` VALUES (27, 'Australia', 5); INSERT INTO `plus2_subcat` VALUES (28, 'Fiji', 5); INSERT INTO `plus2_subcat` VALUES (29, 'Kiribati', 5); INSERT INTO `plus2_subcat` VALUES (30, 'Marshall Islands', 5); INSERT INTO `plus2_subcat` VALUES (31, 'Micronesia', 5); INSERT INTO `plus2_subcat` VALUES (32, 'Nauru', 5); INSERT INTO `plus2_subcat` VALUES (33, 'Argentina', 6); INSERT INTO `plus2_subcat` VALUES (34, 'Bolivia', 6); INSERT INTO `plus2_subcat` VALUES (35, 'Brazil', 6); INSERT INTO `plus2_subcat` VALUES (36, 'Chile', 6); INSERT INTO `plus2_subcat` VALUES (37, 'Colombia', 6); INSERT INTO `plus2_subcat` VALUES (38, 'Ecuador', 6);