jspshop.sql

Struts+Spring+Hibernate在线购物系统

INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("384", "190", "123456123456", "5", NULL, NULL, NULL, "摩托罗拉C300", "1120", NULL, NULL);
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("388", "175", "123456123456", "7", "0000-00-00 00:00:00", "True", "False", "诺基亚7650", "3750", "123456123456200418114217303307", NULL);
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("387", "190", "123456123456", "7", "0000-00-00 00:00:00", "True", "False", "摩托罗拉C300", "1120", "123456123456200418114217303307", NULL);
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("389", "204", "123456123456", "4", "0000-00-00 00:00:00", "True", "False", "索尼爱立信T300", "2980", "123456123456200418114217303307", NULL);
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("390", "201", "123456123456", "7", "0000-00-00 00:00:00", "True", "False", "摩托罗拉V70", "2480", "123456123456200418114217305303", NULL);
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("391", "175", "123456123456", "4", "0000-00-00 00:00:00", "True", "False", "诺基亚7650", "3750", "123456123456200418114217334305", NULL);
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("392", "201", "123456123456", "5", "0000-00-00 00:00:00", "True", "False", "摩托罗拉V70", "2480", "123456123456200418114217337308", NULL);
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("393", "204", "123456123456", "7", "0000-00-00 00:00:00", "True", "False", "索尼爱立信T300", "2980", "123456123456200418114217338340", NULL);
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("394", "163", "123456123456", "8", "0000-00-00 00:00:00", "True", "False", "诺基亚7210", "3950", "123456123456200418114217346312", NULL);
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("395", "201", "123", "6", "0000-00-00 00:00:00", "True", "False", "摩托罗拉V70", "2480", "123200418114217351301", NULL);


#
# Table structure for table 'company'
#

DROP TABLE IF EXISTS company;
CREATE TABLE company (
  id int(10) unsigned NOT NULL auto_increment,
  com_name varchar(50) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;



#
# Dumping data for table 'company'
#



#
# Table structure for table 'dlpf'
#

DROP TABLE IF EXISTS dlpf;
CREATE TABLE dlpf (
  id int(10) unsigned NOT NULL auto_increment,
  user varchar(50) default NULL,
  pass varchar(50) default NULL,
  tel varchar(50) default NULL,
  code varchar(50) default NULL,
  fax varchar(50) default NULL,
  company varchar(50) default NULL,
  mobile varchar(50) default NULL,
  type varchar(50) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;



#
# Dumping data for table 'dlpf'
#



#
# Table structure for table 'guest'
#

DROP TABLE IF EXISTS guest;
CREATE TABLE guest (
  id int(10) unsigned NOT NULL auto_increment,
  name varchar(50) default NULL,
  mail varchar(50) default NULL,
  title varchar(50) default NULL,
  content varchar(50) default NULL,
  date varchar(50) default NULL,
  PRIMARY KEY  (id)