shoppingcart.sql

购物车源码

drop table if exists cart_user;
drop table if exists cart_product;
drop table if exists cart_order;
drop table if exists cart_order_item;

create table cart_user(
	id integer auto_increment primary key,
	name varchar(32) not null unique,
	password varchar(32) not null,
	address varchar(512),
	postcode varchar(10),
	email varchar(32),
	homePhone varchar(32),
	cellPhone varchar(32),
	officePhone varchar(32)
);
insert into cart_user values(1,'charles','446678','江苏省如东县','226463','[e-mail]','0513-84879725','0512-88888888','13485171648');

create table cart_product(
	id integer auto_increment primary key,
	name varchar(32) not null,
	description varchar(64),
	price double not null
);
insert into cart_product values(1,'pencil','pencil',2.00);
insert into cart_product values(2,'gluewater','gluewater',5.00);
insert into cart_product values(3,'pencilcase','pencilcase',10.00);
insert into cart_product values(4,'ballpen','ballpen',2.00);

create table cart_order(
	id integer auto_increment primary key,
	status integer,
	uid integer not null,
	cost double,
	foreign key(uid) references cart_user(id)
);
create table cart_order_item(
	id integer auto_increment primary key,
	amount integer,
	cost double,
	pid integer not null references cart_product(id),
	oid integer not null references cart_order(id)
);