/* MySQL Data Transfer */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for shopexample -- ---------------------------- DROP TABLE IF EXISTS `shopexample`; CREATE TABLE `shopexample` ( `id` int(11) NOT NULL auto_increment, `label` varchar(40) default NULL, `parent_id` int(11) default NULL, `tooltip` varchar(40) default NULL, `orderby` int(11) default NULL, `URL` varchar(60) default NULL, `visibility` int(11) default '1', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=latin1; -- ---------------------------- -- Records -- ---------------------------- INSERT INTO `shopexample` VALUES ('1', 'welcome', '0', 'welcome to our site', '1', '#', '1'); INSERT INTO `shopexample` VALUES ('2', 'about us', '0', 'about us', '2', '#', '1'); INSERT INTO `shopexample` VALUES ('3', 'our terms', '0', 'our terms', '3', '#', '1'); INSERT INTO `shopexample` VALUES ('4', 'our products', '0', 'our products', '4', '#', '1'); INSERT INTO `shopexample` VALUES ('5', 'buy now', '0', 'buy now', '5', '#', '1'); INSERT INTO `shopexample` VALUES ('6', 'shoes', '4', 'shoes', '6', '#', '1'); INSERT INTO `shopexample` VALUES ('7', 'coats', '4', 'coats', '7', '#', '1'); INSERT INTO `shopexample` VALUES ('8', 'scarves', '4', 'scarves', '8', '#', '1'); INSERT INTO `shopexample` VALUES ('9', 'umbrellas', '4', 'umbrellas', '9', '#', '1'); INSERT INTO `shopexample` VALUES ('10', 'black shoes', '6', 'black shoes', '10', '#', '1'); INSERT INTO `shopexample` VALUES ('11', 'brown shoes', '6', 'brown shoes', '11', '#', '1'); INSERT INTO `shopexample` VALUES ('12', 'summer coats', '7', 'summer coats', '12', '#', '1'); INSERT INTO `shopexample` VALUES ('13', 'winter coats', '7', 'winter coats', '13', '#', '1'); INSERT INTO `shopexample` VALUES ('14', 'silk scarves', '8', 'silk scarves', '14', '#', '1'); INSERT INTO `shopexample` VALUES ('15', 'wool scarves', '8', 'wool scarves', '15', '#', '1'); INSERT INTO `shopexample` VALUES ('16', 'patterned scraves', '8', 'patterned scarves', '16', '#', '1'); INSERT INTO `shopexample` VALUES ('17', 'ladies umbrellas', '9', 'ladies umbrellas', '17', '#', '1'); INSERT INTO `shopexample` VALUES ('18', 'gents unmbrellas', '9', 'gents umbrellas', '18', '#', '1');