# MySQL-Front Dump 2.4
#
# Host: localhost   Database: 503roomdata
#--------------------------------------------------------
# Server version 3.23.40


#
# Table structure for table 'shop_admin'
#

CREATE TABLE `shop_admin` (  `aid` int(10) unsigned NOT NULL auto_increment,  `name` varchar(30) NOT NULL default '',  `pwd` varchar(40) NOT NULL default '',  `level` tinyint(3) unsigned NOT NULL default '0',  PRIMARY KEY  (`aid`)) TYPE=MyISAM;



#
# Dumping data for table 'shop_admin'
#
INSERT INTO shop_admin VALUES("1", "admin", "21232F297A57A5A743894A0E4A801FC3", "1");
INSERT INTO shop_admin VALUES("8", "aa", "4124BC0A9335C27F086F24BA207A4912", "0");
INSERT INTO shop_admin VALUES("7", "qq", "D41D8CD98F00B204E9800998ECF8427E", "1");


#
# Table structure for table 'shop_catalog'
#

CREATE TABLE `shop_catalog` (  `id` int(10) unsigned NOT NULL auto_increment,  `parentid` int(10) unsigned NOT NULL default '0',  `title` varchar(200) NOT NULL default '',  PRIMARY KEY  (`id`)) TYPE=MyISAM;



#
# Dumping data for table 'shop_catalog'
#
INSERT INTO shop_catalog VALUES("1", "0", "音樂");
INSERT INTO shop_catalog VALUES("2", "0", "禮品");
INSERT INTO shop_catalog VALUES("59", "0", "存儲器");
INSERT INTO shop_catalog VALUES("4", "0", "數碼");
INSERT INTO shop_catalog VALUES("31", "3", "手機");
INSERT INTO shop_catalog VALUES("32", "4", "MP3");
INSERT INTO shop_catalog VALUES("33", "4", "數碼相機");
INSERT INTO shop_catalog VALUES("38", "2", "飾品");
INSERT INTO shop_catalog VALUES("35", "4", "電腦整機");
INSERT INTO shop_catalog VALUES("36", "3", "電話機");
INSERT INTO shop_catalog VALUES("37", "3", "對講機");
INSERT INTO shop_catalog VALUES("39", "2", "商務");
INSERT INTO shop_catalog VALUES("40", "2", "玩具");
INSERT INTO shop_catalog VALUES("41", "1", "流行");
INSERT INTO shop_catalog VALUES("42", "1", "POP");
INSERT INTO shop_catalog VALUES("43", "1", "民族");
INSERT INTO shop_catalog VALUES("44", "1", "歌劇");
INSERT INTO shop_catalog VALUES("45", "0", "音像");
INSERT INTO shop_catalog VALUES("46", "0", "書籍");
INSERT INTO shop_catalog VALUES("48", "46", "科技");
INSERT INTO shop_catalog VALUES("49", "46", "編程");
INSERT INTO shop_catalog VALUES("50", "46", "系統");
INSERT INTO shop_catalog VALUES("51", "45", "港臺");
INSERT INTO shop_catalog VALUES("53", "45", "歐美");
INSERT INTO shop_catalog VALUES("54", "45", "動作");
INSERT INTO shop_catalog VALUES("55", "45", "喜劇");
INSERT INTO shop_catalog VALUES("56", "4", "電腦配件");
INSERT INTO shop_catalog VALUES("57", "4", "電腦外設");
INSERT INTO shop_catalog VALUES("58", "4", "家電");
INSERT INTO shop_catalog VALUES("60", "59", "USB");
INSERT INTO shop_catalog VALUES("61", "59", "硬盤");
INSERT INTO shop_catalog VALUES("62", "59", "軟盤");
INSERT INTO shop_catalog VALUES("63", "0", "電腦");
INSERT INTO shop_catalog VALUES("64", "63", "聯想");
INSERT INTO shop_catalog VALUES("65", "63", "七喜");
INSERT INTO shop_catalog VALUES("66", "63", "長城");


#
# Table structure for table 'shop_gbook_info'
#

CREATE TABLE `shop_gbook_info` (  `id` int(10) unsigned NOT NULL auto_increment,  `product_id` int(10) unsigned NOT NULL default '0',  `content` text NOT NULL,  `author` varchar(100) NOT NULL default '',  `level` tinyint(4) NOT NULL default '0',  `date_time` datetime NOT NULL default '0000-00-00 00:00:00',  PRIMARY KEY  (`id`)) TYPE=MyISAM;



#
# Dumping data for table 'shop_gbook_info'
#
INSERT INTO shop_gbook_info VALUES("10", "52", "hjkfghk", "fhkfh", "4", "2003-07-11 02:41:28");
INSERT INTO shop_gbook_info VALUES("9", "55", "hjkhjk", "hjkg", "1", "2003-07-11 02:41:13");
INSERT INTO shop_gbook_info VALUES("8", "59", "jkljk", "kjl", "4", "2003-07-11 02:40:55");
INSERT INTO shop_gbook_info VALUES("11", "53", "ghjghj", "ghj", "3", "2003-07-11 02:41:46");
INSERT INTO shop_gbook_info VALUES("12", "57", "ghjfghj", "fgjhfghj", "3", "2003-07-11 02:42:01");
INSERT INTO shop_gbook_info VALUES("13", "60", "dyjdj", "fgjfgh", "2", "2003-07-11 02:42:19");
INSERT INTO shop_gbook_info VALUES("14", "56", "gjdfgdf", "fdghfd", "2", "2003-07-11 02:43:05");
INSERT INTO shop_gbook_info VALUES("15", "58", "hfjgh", "hgjgf", "4", "2003-07-11 02:43:59");
INSERT INTO shop_gbook_info VALUES("16", "54", "ghjghj", "ghjgh", "3", "2003-07-11 02:44:26");
INSERT INTO shop_gbook_info VALUES("17", "58", "ghjgh", "hgjg", "2", "2003-07-11 02:45:41");


#
# Table structure for table 'shop_member_favorite'
#

CREATE TABLE `shop_member_favorite` (  `id` int(10) unsigned NOT NULL auto_increment,  `MName` varchar(20) NOT NULL default '',  `Pid` int(10) unsigned NOT NULL default '0',  `date_time` datetime NOT NULL default '0000-00-00 00:00:00',  PRIMARY KEY  (`id`)) TYPE=MyISAM;



#
# Dumping data for table 'shop_member_favorite'
#


#
# Table structure for table 'shop_member_info'
#

CREATE TABLE `shop_member_info` (  `id` int(10) unsigned NOT NULL auto_increment,  `account` varchar(20) NOT NULL default '',  `pwd` varchar(50) NOT NULL default '',  `name` varchar(20) NOT NULL default '',  `age` tinyint(4) NOT NULL default '0',  `sex` tinyint(4) NOT NULL default '0',  `address` varchar(255) NOT NULL default '',  `tel` varchar(100) NOT NULL default '',  `email` varchar(100) NOT NULL default '',  `log_times` int(11) NOT NULL default '0',  `date_time` datetime NOT NULL default '0000-00-00 00:00:00',  PRIMARY KEY  (`id`)) TYPE=MyISAM;



#
# Dumping data for table 'shop_member_info'
#
INSERT INTO shop_member_info VALUES("18", "leobasic", "07CDC8109C2E07FC33962305D73F2CB2", "趙", "24", "1", "各個各個各個各個", "133333333333333", "rr@rr.com", "13", "2002-12-11 11:09:25");
INSERT INTO shop_member_info VALUES("19", "basic", "099B3B060154898840F0EBDFB46EC78F", "帥哥1", "1", "2", "深圳市1", "1", "1fdgk@d.com", "25", "2003-07-04 16:47:00");
INSERT INTO shop_member_info VALUES("23", "jimy", "07CDC8109C2E07FC33962305D73F2CB2", "磚洞高手", "28", "1", "廣東省肇慶市端洲區體育路12號305", "13333333", "fuck@21cn.com", "9", "2003-07-10 21:22:17");
INSERT INTO shop_member_info VALUES("24", "q", "7694F4A66316E53C8CDD9D9954BD611D", "q", "44", "2", "qfgd", "456456", "q@sefd.com", "4", "2003-07-10 22:56:19");


#
# Table structure for table 'shop_news_imgs'
#

CREATE TABLE `shop_news_imgs` (  `id` int(10) unsigned NOT NULL auto_increment,  `info_id` int(10) unsigned NOT NULL default '0',  `img_name` varchar(50) NOT NULL default '',  PRIMARY KEY  (`id`)) TYPE=MyISAM;