【SQL开源代码栏目提醒】:网学会员,鉴于大家对SQL开源代码十分关注,论文会员在此为大家搜集整理了“db.sql”一文,供大家参考学习!
-- Change script: #1: 001_create_user.sql
CREATE TABLE T_USER(
ID BIGINT,
USERNAME VARCHAR(200),
PASSWORD VARCHAR(128),
REALNAME VARCHAR(200),
ADDRESS VARCHAR(500),
EMAIL VARCHAR(100),
PHONE VARCHAR(100),
DESCRIPTION VARCHAR(800)
);
ALTER TABLE T_USER ADD CONSTRAINT PK_USER PRIMARY KEY(ID);
ALTER TABLE T_USER ALTER COLUMN ID BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1);
-- Change script: #2: 002_create_news.sql
CREATE TABLE T_NEWS(
ID BIGINT,
TITLE VARCHAR(200),
CONTENT VARCHAR(4000),
CREATE_TIME DATETIME
);
ALTER TABLE T_NEWS ADD CONSTRAINT PK_NEWS PRIMARY KEY(ID);
ALTER TABLE T_NEWS ALTER COLUMN ID BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1);
-- Change script: #3: 003_create_category.sql
CREATE TABLE T_CATEGORY(
ID VARCHAR(200),
TITLE VARCHAR(200),
DESCRIPTION VARCHAR(500)
);
ALTER TABLE T_CATEGORY ADD CONSTRAINT PK_CATEGORY PRIMARY KEY(ID);
-- Change script: #4: 004_create_product.
sql CREATE TABLE T_PRODUCT(
ID BIGINT,
TITLE VARCHAR(200),
CATEGORY_ID VARCHAR(200),
MANUFACTURES VARCHAR(200),
MODEL VARCHAR(200),
UNIT_PRICE DOUBLE,
MARKET_PRICE DOUBLE,
STOKE INTEGER,
DESCRIPTION VARCHAR(4000),
SPECIFICATION VARCHAR(4000),
WARRANTY VARCHAR(4000),
SMALL_IMAGE_URL VARCHAR(200),
LARGET_IMAGE_URL VARCHAR(200),
TOTAL_RATING INTEGER,
CREATE_TIME DATETIME
);
ALTER TABLE T_PRODUCT ADD CONSTRAINT PK_PRODUCT PRIMARY KEY(ID);
ALTER TABLE T_PRODUCT ALTER COLUMN ID BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1);
ALTER TABLE T_PRODUCT ADD CONSTRAINT FK_PRODUCT_CATEGORY FOREIGN KEY(CATEGORY_ID) REFERENCES T_CATEGORY(ID);
-- Change script: #5: 005_create_comment.sql
CREATE TABLE T_COMMENT(
ID BIGINT,
PRODUCT_ID BIGINT,
USERNAME VARCHAR(200),
TITLE VARCHAR(200),
DESCRIPTION VARCHAR(4000),
RATING DOUBLE,
CREATE_TIME DATETIME
);
ALTER TABLE T_COMMENT ADD CONSTRAINT PK_COMMENT PRIMARY KEY(ID);
ALTER TABLE T_COMMENT ALTER COLUMN ID BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1);
ALTER TABLE T_COMMENT ADD CONSTRAINT FK_COMMENT_PRODUCT FOREIGN KEY(PRODUCT_ID) REFERENCES T_PRODUCT(ID);
-- Change script: #6: 006_create_order.sql
CREATE TABLE T_ORDER(
ID BIGINT,
USERNAME VARCHAR(200),
CREATE_TIME DATETIME,
STATUS INTEGER,
SUB_TOTAL DOUBLE,
SHIPPING_NAME VARCHAR(200),
SHIPPING_ADDRESS VARCHAR(200),
SHIPPING_POSTCODE VARCHAR(200),
SHIPPING_CITY VARCHAR(50),
SHIPPING_PROVINCE VARCHAR(50),
SHIPPING_EMAIL VARCHAR(200),
SHIPPING_PHONE VARCHAR(50),
SHIPING_DATE DATETIME
);
ALTER TABLE T_ORDER ADD CONSTRAINT PK_ORDER PRIMARY KEY(ID);
ALTER TABLE T_ORDER ALTER COLUMN ID BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1);
-- Change script: #7: 007_create_order_item.sql
CREATE TABLE T_ORDER_ITEM(
ID BIGINT,
CREATE_TIME DATETIME,
ORDER_ID BIGINT,
PRODUCT_ID BIGINT,
TITLE VARCHAR(200),
UNIT_PRICE DOUBLE,
QUANTITY INTEGER
);
ALTER TABLE T_ORDER_ITEM ADD CONSTRAINT PK_ORDER_ITEM PRIMARY KEY(ID);
ALTER TABLE T_ORDER_ITEM ALTER COLUMN ID BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1);
ALTER TABLE T_ORDER_ITEM ADD CONSTRAINT FK_ORDER_ITEM_ORDER FOREIGN KEY(ORDER_ID) REFERENCES T_ORDER(ID);
ALTER TABLE T_ORDER_ITEM ADD CONSTRAINT FK_ORDER_ITEM_PRODUCT FOREIGN KEY(PRODUCT_ID) REFERENCES T_PRODUCT(ID);