--
-- Table structure for table `catalog`
--
CREATE TABLE `catalog` (
`rowId` tinyint(4) NOT NULL auto_increment,
`catalog` varchar(30) NOT NULL default '',
PRIMARY KEY (`rowId`)
) TYPE=MyISAM AUTO_INCREMENT=5 ;
--
-- Dumping data for table `catalog`
--
INSERT INTO `catalog` VALUES (1, 'fruits');
INSERT INTO `catalog` VALUES (2, 'vehicles');
INSERT INTO `catalog` VALUES (3, 'names');
INSERT INTO `catalog` VALUES (4, 'countries');
-- --------------------------------------------------------
--
-- Table structure for table `inventory`
--
CREATE TABLE `inventory` (
`productId` tinyint(4) NOT NULL auto_increment,
`catalogId` tinyint(4) NOT NULL default '0',
`product` varchar(20) NOT NULL default '',
`decription` varchar(40) NOT NULL default '',
PRIMARY KEY (`productId`)
) TYPE=MyISAM AUTO_INCREMENT=17 ;
--
-- Dumping data for table `inventory`
--
INSERT INTO `inventory` VALUES (1, 1, 'banana', 'yellow fruit');
INSERT INTO `inventory` VALUES (2, 1, 'apple', 'red fruit');
INSERT INTO `inventory` VALUES (3, 1, 'orange', 'delicious fruit');
INSERT INTO `inventory` VALUES (4, 1, 'watermelon', 'my favorite fruit');
INSERT INTO `inventory` VALUES (5, 2, 'car', 'I have a car');
INSERT INTO `inventory` VALUES (6, 2, 'bus', 'a large car');
INSERT INTO `inventory` VALUES (7, 2, 'airplane', 'my private airplane');
INSERT INTO `inventory` VALUES (8, 2, 'motorcycle', 'i dont like this');
INSERT INTO `inventory` VALUES (9, 3, 'cesar', 'my friend');
INSERT INTO `inventory` VALUES (10, 3, 'edward', 'my ugly friend');
INSERT INTO `inventory` VALUES (11, 2, 'Luis', 'cesar''s brother');
INSERT INTO `inventory` VALUES (12, 2, 'tamika', 'my dog');
INSERT INTO `inventory` VALUES (13, 4, 'Mexico', 'I live here');
INSERT INTO `inventory` VALUES (14, 4, 'Chile', 'a nice place');
INSERT INTO `inventory` VALUES (15, 4, 'Germany', 'I like this place');
INSERT INTO `inventory` VALUES (16, 4, 'Brazil', 'the best asses');
|