date.sql

来自「网上书店后台管理源码基于struts1.2+oracle数据库」· SQL 代码 · 共 68 行

CREATE TABLE sorts(	
	id		INTEGER      	PRIMARY KEY,
	name		VARCHAR (40) 	NOT NULL
);
CREATE TABLE book(	
	id		INTEGER      	PRIMARY KEY,
	sortid		INTEGER      	NOT NULL,		
	name		VARCHAR (50) 	NOT NULL,
	price		DECIMAL		NOT NULL,
	saleprice	DECIMAL		NOT NULL,
	descript	CLOB  		NOT NULL,
	contents	CLOB	 	NULL,
	saledate	DATE		NOT NULL,
	salecount	INTEGER         NULL,
	image		VARCHAR (50)  	NULL
);
CREATE TABLE member(	
	id		INTEGER      	PRIMARY KEY,
	username	VARCHAR (20) 	NOT NULL,
	password	VARCHAR (20) 	NOT NULL,
	realname	VARCHAR (20) 	NULL,
	tel		VARCHAR (20)  	NULL,
	address		VARCHAR (100)  	NULL,
	zip		VARCHAR (6)  	NULL,
	email		VARCHAR (50)   	NULL
);
insert into member values(1,'leisure','123','黄理斯','0451-88641860','哈尔滨','150001','[e-mail]');
CREATE TABLE orders(	
	id		INTEGER         PRIMARY KEY,
	orderno		VARCHAR (50)    NOT NULL,
	userid		INTEGER         NOT NULL,
	realname	VARCHAR (20) 	NOT NULL,
	address		VARCHAR (100)  	NOT NULL,
	zip		VARCHAR (6)   	NULL,
	tel		VARCHAR (20)  	NULL,
	payment		VARCHAR (20)   	NULL, 
	email		VARCHAR (50)   	NULL,
	memo		CLOB	   	NULL, 
	price		DECIMAL		NULL,
	time		VARCHAR (20) 	NULL,
	tag		INTEGER         NULL
);
CREATE TABLE shopcart(	
	id		INTEGER      	PRIMARY KEY,
	orderid		INTEGER         NOT NULL,
	productid	INTEGER      	NOT NULL,		
	price		INTEGER      	NOT NULL
);
insert into sort  values(1,'IBM');
insert into sort  values(2,'SONY');
insert into sort  values(3,'HP');
insert into sort  values(4,'TOSHIBA');
insert into sort  values(5,'联想');
insert into sort  values(6,'同方');

insert into book values(1,1,'IBM-T43',14500,13500,'CPU处理器:Intel Pentium-M(Dothan 760)2.0GHz','芯片组：Intel 915PM系统主频：533 MHz 二级缓存：2M 图形显示卡：ATI Mobility Radeon X300,PCI-Express 显示内存：64MB DDR2802.11B+G无线网卡,内置蓝牙技术。',to_date('20060322','YYYYMMDD'),110,'images/IBMT43CH8.jpg');

insert into book values(2,3,'HP-NC4200',13500,13000,'CPU处理器:Intel Pentium-M(Dothan 760)2.0GHz','芯片组：Intel 915PM系统主频：533 MHz 二级缓存：2M 图形显示卡：ATI Mobility Radeon X300,PCI-Express 显示内存：64MB DDR2802.11B+G无线网卡,内置蓝牙技术。',to_date('20060426','YYYYMMDD'),109,'images/HPNC4200.jpg');

insert into book values(3,2,'SONY-A21C',16500,15000,'CPU处理器:Intel Pentium-M(Dothan 760)2.0GHz','芯片组：Intel 915PM系统主频：533 MHz 二级缓存：2M 图形显示卡：ATI Mobility Radeon X300,PCI-Express 显示内存：64MB DDR2802.11B+G无线网卡,内置蓝牙技术。',to_date('20060501','YYYYMMDD'),108,'images/SONYA21C.jpg');
drop table adminuser;
CREATE TABLE adminuser(
	id		INTEGER      	PRIMARY KEY,
	username	VARCHAR (20) 	NOT NULL,
	password	VARCHAR (20) 	NOT NULL	
);
insert into adminuser  values(1,'manager','manager');
commit;