login.sql

网上购物系统的简易代码

create table t_user
(
id Integer primary key,
username varchar(20),
passwd varchar(20),
addr varchar(30),
phone varchar(20),
email varchar(30)
);

INSERT INTO t_user VALUES(1,'tom','123','tomcat','1234556','[e-mail]');
create table t_order(
orderid Integer(3) primary key,
ordername varchar(30),
payway varchar(20),
createdata date,
state varchar(10),
cost double(10,3)
);
create table t_product(
pid Integer(3) primary key,
name varchar(20),
discription varchar(64),
price double(10,3),
author varchar(20),
images varchar(20)
);
create table e_orderline(
orderlineid Integer(3) primary key,
orderid Integer(3),
pid Integer(3),
count Integer(3)
);