mysqldata

基于jsp+javabean+mysql三层结构的动态购物网站。网站用户接口（即界面）由jsp完成

# 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", "[e-mail]", "13", "2002-12-11 11:09:25");
INSERT INTO shop_member_info VALUES("19", "basic", "099B3B060154898840F0EBDFB46EC78F", "帅哥1", "1", "2", "深圳市1", "1", "[e-mail]", "25", "2003-07-04 16:47:00");
INSERT INTO shop_member_info VALUES("23", "jimy", "07CDC8109C2E07FC33962305D73F2CB2", "砖洞高手", "28", "1", "广东省肇庆市端洲区体育路12号305", "13333333", "[e-mail]", "9", "2003-07-10 21:22:17");
INSERT INTO shop_member_info VALUES("24", "q", "7694F4A66316E53C8CDD9D9954BD611D", "q", "44", "2", "qfgd", "456456", "[e-mail]", "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;