# 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商務(wù)網(wǎng)", "dfgsdf", "2");
INSERT INTO ad (id, url, wordlink, content, bs) VALUES("3", "http://www.freedown.net/design/order.asp?id=44", "購物系統(tǒng)", "dfgsdf", "3");
INSERT INTO ad (id, url, wordlink, content, bs) VALUES("4", "http://www.freedown.net/design/read.asp?id=39", "郵件群發(fā)系統(tǒng)", "dfgsdf", "4");
INSERT INTO ad (id, url, wordlink, content, bs) VALUES("5", "http://www.freedown.net/design/read.asp?id=38", "完美音樂系統(tǒng)", "dfgsdf", "5");
INSERT INTO ad (id, url, wordlink, content, bs) VALUES("12", "http://www.freedown.net/design/read.asp?id=40", "在線定購系統(tǒng)", "rr", "10");
INSERT INTO ad (id, url, wordlink, content, bs) VALUES("13", "http://www.freedown.net/design/read.asp?id=42", "精美購物系統(tǒng)", "dfdfd", "8");
INSERT INTO ad (id, url, wordlink, content, bs) VALUES("18", "http://10.68.4.78:8080", "我的網(wǎng)站", "", "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',