【SQL开源代码栏目提醒】:本文主要为网学会员提供006_create_order.sql,希望对需要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),
CUSTOMER_EMAIL VARCHAR(200),
CUSTOMER_PHONE VARCHAR(50),
SHIPPING_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);
INSERT INTO T_ORDER(ID,USERNAME,CREATE_TIME,STATUS,SUB_TOTAL,SHIPPING_NAME,SHIPPING_ADDRESS,SHIPPING_POSTCODE,
SHIPPING_CITY,SHIPPING_PROVINCE,CUSTOMER_EMAIL,CUSTOMER_PHONE) VALUES
(2,'huang','2009-09-07 04:59:11.063',0,900.00,123,123,123,'北京','北京','123@13.net',123);
INSERT INTO T_ORDER(ID,USERNAME,CREATE_TIME,STATUS,SUB_TOTAL,SHIPPING_NAME,SHIPPING_ADDRESS,SHIPPING_POSTCODE,
SHIPPING_CITY,SHIPPING_PROVINCE,CUSTOMER_EMAIL,CUSTOMER_PHONE) VALUES
(3,'huang','2009-09-07 04:59:46.267',0,26500.00,123,123,123,'北京','北京','123@13.net',123);
--//@UNDO
DROP TABLE T_ORDER;