【SQL开源代码栏目提醒】:网学会员--在 SQL开源代码编辑为广大网友搜集整理了: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);
INSERT INTO T_COMMENT(ID,PRODUCT_ID,USERNAME,TITLE,DESCRIPTION,RATING,CREATE_TIME)
VALUES(1,16,'huang','测试','*','2.5','2009-09-08 00:01:32.223');
--//@UNDO
DROP TABLE T_COMMENT;