bookstore.script

spring+acegi编写的网上书城

CREATE SCHEMA PUBLIC AUTHORIZATION DBA
CREATE MEMORY TABLE T_ACCOUNT(USERNAME VARCHAR(20) NOT NULL PRIMARY KEY,EMAIL VARCHAR(50),PRIVILEGE INTEGER NOT NULL,CREATEDDATE TIMESTAMP NOT NULL,ZIP VARCHAR(10),TELEPHONE VARCHAR(20),MOBILE VARCHAR(20),ADDRESS VARCHAR(100),NAME VARCHAR(10),PASSWORD VARCHAR(32) NOT NULL)
CREATE MEMORY TABLE T_BOOK(ID VARCHAR(32) NOT NULL PRIMARY KEY,AUTHOR VARCHAR(50) NOT NULL,CATEGORYID INTEGER NOT NULL,PUBLISHER VARCHAR(50) NOT NULL,ORIGINALNAME VARCHAR(50),DISCOUNT INTEGER NOT NULL,ISBN VARCHAR(50) NOT NULL,PUBDATE DATE NOT NULL,PRICE FLOAT NOT NULL,RATING INTEGER NOT NULL,RATINGCOUNT INTEGER NOT NULL,SOLD INTEGER NOT NULL,STOCK INTEGER NOT NULL,NAME VARCHAR(50) NOT NULL,LANGUAGE VARCHAR(10) NOT NULL,STATE INTEGER NOT NULL,DESCRIPTION VARCHAR(2000) NOT NULL)
CREATE MEMORY TABLE T_CATEGORY(ID INTEGER NOT NULL PRIMARY KEY,CATEGORYORDER INTEGER NOT NULL,NAME VARCHAR(20) NOT NULL)
CREATE MEMORY TABLE T_COMMENT(ID VARCHAR(32) NOT NULL PRIMARY KEY,CREATEDDATE TIMESTAMP NOT NULL,RATING INTEGER NOT NULL,CONTENT VARCHAR(2000) NOT NULL,ACCOUNT_USERNAME VARCHAR(20) NOT NULL,BOOK_ID VARCHAR(32) NOT NULL,CONSTRAINT FKF437E1948F008451 FOREIGN KEY(BOOK_ID) REFERENCES T_BOOK(ID),CONSTRAINT FKF437E1948767163E FOREIGN KEY(ACCOUNT_USERNAME) REFERENCES T_ACCOUNT(USERNAME))
CREATE MEMORY TABLE T_FAV_BOOK(ID VARCHAR(32) NOT NULL PRIMARY KEY,CREATEDDATE TIMESTAMP NOT NULL,BOOK_ID VARCHAR(32) NOT NULL,ACCOUNT_USERNAME VARCHAR(20) NOT NULL,CONSTRAINT FKF46594F88F008451 FOREIGN KEY(BOOK_ID) REFERENCES T_BOOK(ID),CONSTRAINT FKF46594F88767163E FOREIGN KEY(ACCOUNT_USERNAME) REFERENCES T_ACCOUNT(USERNAME))
CREATE MEMORY TABLE T_ORDER(ID VARCHAR(32) NOT NULL PRIMARY KEY,CREATEDDATE TIMESTAMP NOT NULL,ZIP VARCHAR(10),TELEPHONE VARCHAR(20),MOBILE VARCHAR(20),DELIVER INTEGER NOT NULL,PAYMENT INTEGER NOT NULL,ADDRESS VARCHAR(200) NOT NULL,NAME VARCHAR(20) NOT NULL,STATE INTEGER NOT NULL,ACCOUNT_USERNAME VARCHAR(20) NOT NULL,CONSTRAINT FKA0C0C3C38767163E FOREIGN KEY(ACCOUNT_USERNAME) REFERENCES T_ACCOUNT(USERNAME))
CREATE MEMORY TABLE T_ORDERITEM(ID VARCHAR(32) NOT NULL PRIMARY KEY,NUMBER INTEGER NOT NULL,ORDER_ID VARCHAR(32) NOT NULL,BOOK_ID VARCHAR(32) NOT NULL,CONSTRAINT FK78619768F008451 FOREIGN KEY(BOOK_ID) REFERENCES T_BOOK(ID),CONSTRAINT FK786197623D906A3 FOREIGN KEY(ORDER_ID) REFERENCES T_ORDER(ID))
CREATE USER SA PASSWORD ""
GRANT DBA TO SA