cdstore.sql

用jsp,tomcat,mysql

# EMS MySQL Manager Pro 3.2.0.1
# ---------------------------------------
# Host     : localhost
# Port     : 3306
# Database : cdstore


SET FOREIGN_KEY_CHECKS=0;

CREATE DATABASE `cdstore`
    CHARACTER SET 'latin1'
    COLLATE 'latin1_swedish_ci';

USE `cdstore`;

#
# Structure for the `account` table : 
#

CREATE TABLE `account` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(20) default NULL,
  `cdname` varchar(20) default NULL,
  `saleAmount` int(11) default NULL,
  `thedate` varchar(20) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

#
# Structure for the `cd` table : 
#

CREATE TABLE `cd` (
  `id` varchar(8) NOT NULL default '',
  `name` varchar(24) default NULL,
  `title` varchar(96) default NULL,
  `price` float default NULL,
  `yr` int(11) default NULL,
  `description` varchar(30) default NULL,
  `saleAmount` int(11) default NULL,
  `saletype` varchar(20) default NULL,
  `warehouse` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

#
# Structure for the `cdorder` table : 
#

CREATE TABLE `cdorder` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(20) default NULL,
  `name` varchar(30) default NULL,
  `amount` varchar(20) default NULL,
  `thedate` varchar(20) default NULL,
  `isorder` varchar(20) default '0',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

#
# Structure for the `customer` table : 
#

CREATE TABLE `customer` (
  `username` varchar(20) NOT NULL default '',
  `password` varchar(20) default NULL,
  `isadmin` int(8) default '0',
  `tel` varchar(20) default NULL,
  `email` varchar(20) default NULL,
  PRIMARY KEY  (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

#
# Data for the `account` table  (LIMIT 0,500)
#

INSERT INTO `account` (`id`, `username`, `cdname`, `saleAmount`, `thedate`) VALUES 
  (7,'root','午夜凶铃',2,'Tue May 30 19:55:53'),
  (8,'root','警察故事',1,'Tue May 30 19:55:53'),
  (9,'null','风姿物语',1,'Tue May 30 20:02:54'),
  (10,'null','电车之狼',1,'Tue May 30 20:05:04'),
  (11,'root','辐射',1,'Tue May 30 20:09:56');

COMMIT;

#
# Data for the `cd` table  (LIMIT 0,500)
#

INSERT INTO `cd` (`id`, `name`, `title`, `price`, `yr`, `description`, `saleAmount`, `saletype`, `warehouse`) VALUES 
  ('1','麻志毅','面向对象方法基础教程',26,2004,'经典',1000000,'program',9),
  ('10','gates','windows',9999,2000,'我真的不是盗版',900,'program',333),
  ('11','illusion','电车之狼',10,2006,'大家都知道',4447,'game',197),
  ('2','星爷','大话西游',30.99,1995,'后现代主义解构大师',300,'movie',300),
  ('3','松岛菜菜子','午夜凶铃',100,2000,'某部鬼片,看了会困',202,'movie',108),
  ('4','星爷','喜剧之王',33.75,1999,'俄国戏剧理论大师',119,'movie',100),
  ('5','黑岛','辐射',20,1992,'核战后的颓废世界',43,'game',197),
  ('6','罗大','风姿物语',1000,2006,'我的偶像',6669,'game',197),
  ('7','成龙','警察故事',30,1990,'一个警察',124,'movie',49),
  ('8','黑岛','辐射II',40,2003,'经典力作,不用介绍了吧!',1000,'game',886),
  ('9','linus','Linux',0,1991,'让人又爱又恨的OS',888,'program',200);

COMMIT;

#
# Data for the `cdorder` table  (LIMIT 0,500)
#

INSERT INTO `cdorder` (`id`, `username`, `name`, `amount`, `thedate`, `isorder`) VALUES 
  (5,'小猫','我不是猫','9999','Tue May 30 18:35:38','1');

COMMIT;

#
# Data for the `customer` table  (LIMIT 0,500)
#

INSERT INTO `customer` (`username`, `password`, `isadmin`, `tel`, `email`) VALUES 
  ('root','1234',0,'119','[e-mail]'),
  ('admin','admin',1,'110','[e-mail]');

COMMIT;