jspshop.sql

来自「基于jsp+javabean+access(mysql)三层结构的动态购物网站」· SQL 代码 · 共 347 行 · 第 1/5 页

# MySQL-Front Dump 2.5
#
# Host: localhost   Database: jspshop
# --------------------------------------------------------
# Server version 4.0.15-nt


#
# Table structure for table 'ad'
#

DROP TABLE IF EXISTS ad;
CREATE TABLE ad (
  id int(10) unsigned NOT NULL auto_increment,
  url varchar(50) default 'img/noimg.gif',
  wordlink varchar(50) default 'http://www.freedown.net',
  content varchar(50) default NULL,
  bs int(11) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;



#
# Dumping data for table 'ad'
#

INSERT INTO ad (id, url, wordlink, content, bs) VALUES("2", "http://www.99web.net", "99商务网", "dfgsdf", "2");
INSERT INTO ad (id, url, wordlink, content, bs) VALUES("3", "http://www.freedown.net/design/order.asp?id=44", "购物系统", "dfgsdf", "3");
INSERT INTO ad (id, url, wordlink, content, bs) VALUES("4", "http://www.freedown.net/design/read.asp?id=39", "邮件群发系统", "dfgsdf", "4");
INSERT INTO ad (id, url, wordlink, content, bs) VALUES("5", "http://www.freedown.net/design/read.asp?id=38", "完美音乐系统", "dfgsdf", "5");
INSERT INTO ad (id, url, wordlink, content, bs) VALUES("12", "http://www.freedown.net/design/read.asp?id=40", "在线定购系统", "rr", "10");
INSERT INTO ad (id, url, wordlink, content, bs) VALUES("13", "http://www.freedown.net/design/read.asp?id=42", "精美购物系统", "dfdfd", "8");
INSERT INTO ad (id, url, wordlink, content, bs) VALUES("18", "http://10.68.4.78:8080", "我的网站", "", "1");


#
# Table structure for table 'admin'
#

DROP TABLE IF EXISTS admin;
CREATE TABLE admin (
  admin_id int(10) unsigned NOT NULL auto_increment,
  admin_name varchar(50) default NULL,
  admin_pass varchar(50) default NULL,
  PRIMARY KEY  (admin_id)
) TYPE=MyISAM;



#
# Dumping data for table 'admin'
#

INSERT INTO admin (admin_id, admin_name, admin_pass) VALUES("7", "admin", "admin");
INSERT INTO admin (admin_id, admin_name, admin_pass) VALUES("9", "管理员", "管理员管理员");


#
# Table structure for table 'basket'
#

DROP TABLE IF EXISTS basket;
CREATE TABLE basket (
  basket_id int(10) unsigned NOT NULL auto_increment,
  hw_id varchar(50) default NULL,
  user_name varchar(50) default NULL,
  basket_count varchar(50) default NULL,
  basket_date datetime default '0000-00-00 00:00:00',
  basket_check enum('True','False') default 'False',