电子商城sql脚本（一）

/*==============================================================*/
/* DBMS name: ORACLE Version 11g */
/* Created on: 2011-8-11 11:53:06 */
/*==============================================================*/

alter table tbl_cart
drop constraint FK_TBL_CART_REFERENCE_TBL_CUST;

alter table tbl_goods
drop constraint FK_TBL_GOOD_REFERENCE_TBL_CATE;

alter table tbl_order
drop constraint FK_TBL_ORDE_REFERENCE_TBL_CUST;

alter table tbl_order_goods
drop constraint FK_TBL_ORDE_REFERENCE_TBL_ORDE;

alter table tbl_order_goods
drop constraint FK_TBL_ORDE_REFERENCE_TBL_GOOD;

drop table tbl_cart cascade constraints;

drop table tbl_category cascade constraints;

drop table tbl_customer cascade constraints;

drop table tbl_goods cascade constraints;

drop table tbl_order cascade constraints;

drop table tbl_order_goods cascade constraints;

/*==============================================================*/
/* Table: tbl_cart */
/*==============================================================*/
create table tbl_cart
(
cartId varchar(10) not null,
account varchar(20),
goodNum int,
totalAmount NUMBER,
cartState int,
constraint PK_TBL_CART primary key (cartId)
);

/*==============================================================*/
/* Table: tbl_category */
/*==============================================================*/
create table tbl_category
(
cateId int not null,
cateName varchar(50),
remark varchar(500),
constraint PK_TBL_CATEGORY primary key (cateId)
);