test.script

来自「anewssystem新闻发布系统集成使用了spring hibernate f」· SCRIPT 代码 · 共 51 行

CREATE SCHEMA PUBLIC AUTHORIZATION DBA
CREATE MEMORY TABLE A_ERP2_BID(ID BIGINT NOT NULL PRIMARY KEY,DESCN LONGVARCHAR,CODE VARCHAR(50),PRODUCT_NUM INTEGER,START_DATE TIMESTAMP,END_DATE TIMESTAMP,OPEN_DATE TIMESTAMP,PARAMETER VARCHAR(200),PRODUCT_ID BIGINT,CONSTRAINT SYS_CT_46 UNIQUE(ID))
CREATE MEMORY TABLE A_ERP2_BUY_CONTRACT(ID BIGINT NOT NULL PRIMARY KEY,USERNAME VARCHAR(50),CODE VARCHAR(50),LINKMAN VARCHAR(50),PROVIDE_DATE TIMESTAMP,RECEIPT VARCHAR(50),CONTRACT_DATE TIMESTAMP,NAME VARCHAR(50),STATUS VARCHAR(50),SUPPLIER_ID BIGINT,CONSTRAINT SYS_CT_50 UNIQUE(ID))
CREATE MEMORY TABLE A_ERP2_BUY_ORDER(ID BIGINT NOT NULL PRIMARY KEY,USERNAME VARCHAR(50),PRICE DOUBLE,CODE VARCHAR(50),ORDER_DATE TIMESTAMP,LINKMAN VARCHAR(50),PROVIDE_DATE TIMESTAMP,AUDIT INTEGER,TOTAL_PRICE DOUBLE,NAME VARCHAR(50),STATUS INTEGER,SUPPLIER_ID BIGINT,CONSTRAINT SYS_CT_54 UNIQUE(ID))
CREATE MEMORY TABLE A_ERP2_BUY_ORDER_INFO(ID BIGINT NOT NULL PRIMARY KEY,PRICE DOUBLE,DESCN LONGVARCHAR,CODE VARCHAR(50),NUM INTEGER,TOTAL_PRICE DOUBLE,PARAMETER VARCHAR(50),BUY_ORDER_ID BIGINT,PRODUCT_ID BIGINT,CONSTRAINT SYS_CT_58 UNIQUE(ID),CONSTRAINT FKCF98988AB850EF62 FOREIGN KEY(BUY_ORDER_ID) REFERENCES A_ERP2_BUY_ORDER(ID))
CREATE MEMORY TABLE A_ERP2_INVITE_BID(ID BIGINT NOT NULL PRIMARY KEY,EMAIL VARCHAR(50),PRICE DOUBLE,DESCN LONGVARCHAR,TEL VARCHAR(50),BID_DATE TIMESTAMP,ADDRESS VARCHAR(50),SUPPLLIER_ID BIGINT,BID_ID BIGINT,CONSTRAINT SYS_CT_62 UNIQUE(ID),CONSTRAINT FK705A3D99411FEDC5 FOREIGN KEY(BID_ID) REFERENCES A_ERP2_BID(ID))
CREATE MEMORY TABLE A_ERP2_PRODUCT(ID BIGINT NOT NULL PRIMARY KEY,PRICE DOUBLE,UNIT INTEGER,DESCN LONGVARCHAR,MATERIAL VARCHAR(50),NUM INTEGER,NAME VARCHAR(50),FACTORY VARCHAR(50),TYPE INTEGER,TOTAL DOUBLE,SUPPLIER_ID BIGINT,CONSTRAINT SYS_CT_66 UNIQUE(ID))
CREATE MEMORY TABLE A_ERP2_SUCCESS_BID(ID BIGINT NOT NULL PRIMARY KEY,PRICE DOUBLE,DESCN LONGVARCHAR,PUBLISH_DATE TIMESTAMP,BID_CONTENT VARCHAR(50),INVITE_BID_ID BIGINT,CONSTRAINT SYS_CT_70 UNIQUE(ID),CONSTRAINT FKA74D99CFC301B3B2 FOREIGN KEY(INVITE_BID_ID) REFERENCES A_ERP2_INVITE_BID(ID))
CREATE MEMORY TABLE A_ERP2_SUPPLIER(ID BIGINT NOT NULL PRIMARY KEY,EMAIL VARCHAR(50),DESCN LONGVARCHAR,CODE VARCHAR(50),ZIP VARCHAR(50),FAX VARCHAR(50),TEL VARCHAR(50),HOMEPAGE VARCHAR(50),AREA VARCHAR(50),LINKMAN VARCHAR(50),LEAD VARCHAR(50),ADDRESS VARCHAR(50),NAME VARCHAR(50),TYPE INTEGER,RANK INTEGER,REGION_ID BIGINT,CONSTRAINT SYS_CT_74 UNIQUE(ID))
CREATE MEMORY TABLE A_ERP_CUSTOMER(ID BIGINT NOT NULL PRIMARY KEY,EMAIL VARCHAR(50),DESCN LONGVARCHAR,INPUT_MAN VARCHAR(50),INPUT_TIME TIMESTAMP,CODE VARCHAR(50),ZIP VARCHAR(50),LEADER VARCHAR(50),FAX VARCHAR(50),LINK_MAN VARCHAR(50),TEL VARCHAR(50),HOMEPAGE VARCHAR(50),PROVINCE VARCHAR(50),CITY VARCHAR(50),TOWN VARCHAR(50),ADDRESS VARCHAR(50),NAME VARCHAR(50),TYPE VARCHAR(50),SOURCE VARCHAR(50),RANK VARCHAR(50),STATUS VARCHAR(50),CONSTRAINT SYS_CT_78 UNIQUE(ID))
CREATE MEMORY TABLE A_ERP_MATERIAL(ID BIGINT NOT NULL PRIMARY KEY,SUPPLIER VARCHAR(50),PRICE DOUBLE,UNIT VARCHAR(50),DESCN LONGVARCHAR,INPUT_MAN VARCHAR(50),INPUT_TIME TIMESTAMP,NAME VARCHAR(50),SOURCE VARCHAR(50),STATUS VARCHAR(50),CONSTRAINT SYS_CT_82 UNIQUE(ID))
CREATE MEMORY TABLE A_ERP_ORDER(ID BIGINT NOT NULL PRIMARY KEY,DESCN LONGVARCHAR,INPUT_MAN VARCHAR(50),INPUT_TIME TIMESTAMP,CODE VARCHAR(50),LINK_MAN VARCHAR(50),TEL VARCHAR(50),ORDER_DATE TIMESTAMP,CUSTOMER VARCHAR(50),AMOUNT VARCHAR(50),HAND_MAN VARCHAR(50),PAYMENT VARCHAR(50),DELIVERY VARCHAR(50),STATUS VARCHAR(50),CONSTRAINT SYS_CT_86 UNIQUE(ID))
CREATE MEMORY TABLE A_ERP_ORDER_INFO(ID BIGINT NOT NULL PRIMARY KEY,PRICE VARCHAR(50),UNIT VARCHAR(50),PRODUCT VARCHAR(50),AMOUNT VARCHAR(50),AREA VARCHAR(50),NUM VARCHAR(50),UNIT_TYPE VARCHAR(50),TYPE VARCHAR(50),HEIGHT VARCHAR(50),WIDTH VARCHAR(50),STATUS VARCHAR(50),ORDER_ID BIGINT,CONSTRAINT SYS_CT_90 UNIQUE(ID),CONSTRAINT FKD9550759BEBEA05B FOREIGN KEY(ORDER_ID) REFERENCES A_ERP_ORDER(ID))
CREATE MEMORY TABLE A_ERP_PRODUCT(ID BIGINT NOT NULL PRIMARY KEY,UNIT VARCHAR(50),DESCN LONGVARCHAR,INPUT_MAN VARCHAR(50),INPUT_TIME TIMESTAMP,CODE VARCHAR(50),BUY_PRICE DOUBLE,SALE_PRICE DOUBLE,PIC VARCHAR(50),NAME VARCHAR(50),TYPE VARCHAR(50),STATUS VARCHAR(50),CONSTRAINT SYS_CT_94 UNIQUE(ID))
CREATE MEMORY TABLE A_ERP_RATION(ID BIGINT NOT NULL PRIMARY KEY,UNIT VARCHAR(50),DESCN LONGVARCHAR,INPUT_MAN VARCHAR(50),INPUT_TIME TIMESTAMP,PRODUCT VARCHAR(50),MATERIAL VARCHAR(50),RATE VARCHAR(50),STATUS VARCHAR(50),CONSTRAINT SYS_CT_98 UNIQUE(ID))
CREATE MEMORY TABLE A_NEWS(ID BIGINT NOT NULL PRIMARY KEY,SUBTITLE VARCHAR(100),LINK VARCHAR(100),HTML VARCHAR(100),PAGE_TYPE INTEGER,PAGE_SIZE INTEGER,HIT INTEGER,SUMMARY VARCHAR(255),UPDATE_DATE TIMESTAMP,NAME VARCHAR(100),CONTENT LONGVARCHAR,SOURCE VARCHAR(50),IMAGE VARCHAR(100),EDITOR VARCHAR(50),STATUS INTEGER,CATEGORY_ID BIGINT,CONSTRAINT SYS_CT_102 UNIQUE(ID))
CREATE MEMORY TABLE A_NEWS_CATEGORY(ID BIGINT NOT NULL PRIMARY KEY,DESCN VARCHAR(255),THE_SORT INTEGER,BIT_CODE BIGINT,CHAR_CODE VARCHAR(255),NAME VARCHAR(50),STATUS INTEGER,PARENT_ID BIGINT,CONSTRAINT SYS_CT_106 UNIQUE(ID),CONSTRAINT FK6567A56CAF1C28CB FOREIGN KEY(PARENT_ID) REFERENCES A_NEWS_CATEGORY(ID))
CREATE MEMORY TABLE A_NEWS_COMMENT(ID BIGINT NOT NULL PRIMARY KEY,USERNAME VARCHAR(50),UPDATE_DATE TIMESTAMP,IP VARCHAR(20),NAME VARCHAR(100),CONTENT LONGVARCHAR,STATUS INTEGER,NEWS_ID BIGINT,CONSTRAINT SYS_CT_110 UNIQUE(ID),CONSTRAINT FK5CDABC117E0115E4 FOREIGN KEY(NEWS_ID) REFERENCES A_NEWS(ID))
CREATE MEMORY TABLE A_NEWS_CONFIG(ID BIGINT NOT NULL PRIMARY KEY,NEWS_NEED_AUDIT INTEGER,COMMENT_NEED_AUDIT INTEGER,COULD_COMMENT INTEGER,CATEGORY_STRATEGY INTEGER,TEMPLATE_NAME VARCHAR(50),CONSTRAINT SYS_CT_114 UNIQUE(ID))
CREATE MEMORY TABLE A_NEWS_NEWSTAG(NEWSTAG_ID BIGINT NOT NULL,NEWS_ID BIGINT NOT NULL,PRIMARY KEY(NEWS_ID,NEWSTAG_ID),CONSTRAINT FK923EAD997E0115E4 FOREIGN KEY(NEWS_ID) REFERENCES A_NEWS(ID))
CREATE MEMORY TABLE A_NEWS_TAG(ID BIGINT NOT NULL PRIMARY KEY,THE_SORT INTEGER,NAME VARCHAR(50) NOT NULL,CONSTRAINT SYS_CT_120 UNIQUE(ID),CONSTRAINT SYS_CT_121 UNIQUE(NAME))
CREATE MEMORY TABLE A_SECURITY_DEPT(ID BIGINT NOT NULL PRIMARY KEY,DESCN VARCHAR(200),THE_SORT INTEGER,NAME VARCHAR(50),PARENT_ID BIGINT,CONSTRAINT SYS_CT_126 UNIQUE(ID),CONSTRAINT FK33849C668034938C FOREIGN KEY(PARENT_ID) REFERENCES A_SECURITY_DEPT(ID))
CREATE MEMORY TABLE A_SECURITY_DICTIONARY(ID BIGINT NOT NULL PRIMARY KEY,DESCN VARCHAR(200),THE_SORT INTEGER,NAME VARCHAR(50),PARENT_ID BIGINT,CONSTRAINT SYS_CT_130 UNIQUE(ID),CONSTRAINT FKC5F51617CFF5909D FOREIGN KEY(PARENT_ID) REFERENCES A_SECURITY_DICTIONARY(ID))
CREATE MEMORY TABLE A_SECURITY_MENU(ID BIGINT NOT NULL PRIMARY KEY,URL VARCHAR(50),DESCN VARCHAR(200),THE_SORT INTEGER,QTIP VARCHAR(50),NAME VARCHAR(50),IMAGE VARCHAR(50),PARENT_ID BIGINT,CONSTRAINT SYS_CT_134 UNIQUE(ID),CONSTRAINT FK3388B3808038AAA6 FOREIGN KEY(PARENT_ID) REFERENCES A_SECURITY_MENU(ID))
CREATE MEMORY TABLE A_SECURITY_MENU_ROLE(MENU_ID BIGINT NOT NULL,ROLE_ID BIGINT NOT NULL,PRIMARY KEY(ROLE_ID,MENU_ID),CONSTRAINT FK14BCADD53D7765D1 FOREIGN KEY(MENU_ID) REFERENCES A_SECURITY_MENU(ID))
CREATE MEMORY TABLE A_SECURITY_REGION(ID BIGINT NOT NULL PRIMARY KEY,DESCN VARCHAR(200),THE_SORT INTEGER,NAME VARCHAR(50),PARENT_ID BIGINT,CONSTRAINT SYS_CT_140 UNIQUE(ID),CONSTRAINT FK7CAEBCD59C267A7B FOREIGN KEY(PARENT_ID) REFERENCES A_SECURITY_REGION(ID))
CREATE MEMORY TABLE A_SECURITY_RESOURCE(ID BIGINT NOT NULL PRIMARY KEY,DESCN VARCHAR(200),RES_TYPE VARCHAR(50),RES_STRING VARCHAR(200),NAME VARCHAR(50),CONSTRAINT SYS_CT_144 UNIQUE(ID))
CREATE MEMORY TABLE A_SECURITY_RESOURCE_ROLE(RESOURCE_ID BIGINT NOT NULL,ROLE_ID BIGINT NOT NULL,PRIMARY KEY(ROLE_ID,RESOURCE_ID),CONSTRAINT FK6FD185064E5B1FF1 FOREIGN KEY(RESOURCE_ID) REFERENCES A_SECURITY_RESOURCE(ID))
CREATE MEMORY TABLE A_SECURITY_ROLE(ID BIGINT NOT NULL PRIMARY KEY,DESCN VARCHAR(200),NAME VARCHAR(50) NOT NULL,CONSTRAINT SYS_CT_150 UNIQUE(ID),CONSTRAINT SYS_CT_151 UNIQUE(NAME))
CREATE MEMORY TABLE A_SECURITY_ROLE_USER(ROLE_ID BIGINT NOT NULL,USER_ID BIGINT NOT NULL,PRIMARY KEY(USER_ID,ROLE_ID),CONSTRAINT FK83C6047356E5FA71 FOREIGN KEY(ROLE_ID) REFERENCES A_SECURITY_ROLE(ID))
CREATE MEMORY TABLE A_SECURITY_USER(ID BIGINT NOT NULL PRIMARY KEY,USERNAME VARCHAR(50),EMAIL VARCHAR(100),DESCN VARCHAR(200),CODE VARCHAR(50),TEL VARCHAR(50),TRUENAME VARCHAR(50),SEX TINYINT,BIRTHDAY TIMESTAMP,MOBILE VARCHAR(50),DUTY VARCHAR(50),PASSWORD VARCHAR(50),STATUS TINYINT,DEPT_ID BIGINT,CONSTRAINT SYS_CT_158 UNIQUE(ID),CONSTRAINT FK338C89EC6176F411 FOREIGN KEY(DEPT_ID) REFERENCES A_SECURITY_DEPT(ID))
CREATE MEMORY TABLE A_TRACKER_ISSUE(ID BIGINT NOT NULL PRIMARY KEY,UPDATE_DATE TIMESTAMP,SEVERITY INTEGER,ASSIGN_TO VARCHAR(50),SUBMIT_BY VARCHAR(50),ADD_TIME TIMESTAMP,NAME VARCHAR(50),PRIORITY INTEGER,FILE VARCHAR(100),CONTENT LONGVARCHAR,STATUS INTEGER,PROJECT_ID BIGINT,CONSTRAINT SYS_CT_162 UNIQUE(ID))
CREATE MEMORY TABLE A_TRACKER_PROJECT(ID BIGINT NOT NULL PRIMARY KEY,SUMMARY LONGVARCHAR,THE_SORT INTEGER,FOUNDER VARCHAR(50),NAME VARCHAR(100),CONSTRAINT SYS_CT_166 UNIQUE(ID))
ALTER TABLE A_ERP2_BID ADD CONSTRAINT FK88EB762BCB310305 FOREIGN KEY(PRODUCT_ID) REFERENCES A_ERP2_PRODUCT(ID)
ALTER TABLE A_ERP2_BUY_CONTRACT ADD CONSTRAINT FK48EE253DAF5697EF FOREIGN KEY(SUPPLIER_ID) REFERENCES A_ERP2_SUPPLIER(ID)
ALTER TABLE A_ERP2_BUY_ORDER ADD CONSTRAINT FKCAB3D2E3AF5697EF FOREIGN KEY(SUPPLIER_ID) REFERENCES A_ERP2_SUPPLIER(ID)
ALTER TABLE A_ERP2_BUY_ORDER_INFO ADD CONSTRAINT FKCF98988ACB310305 FOREIGN KEY(PRODUCT_ID) REFERENCES A_ERP2_PRODUCT(ID)
ALTER TABLE A_ERP2_INVITE_BID ADD CONSTRAINT FK705A3D99E8F95E07 FOREIGN KEY(SUPPLLIER_ID) REFERENCES A_ERP2_SUPPLIER(ID)
ALTER TABLE A_ERP2_PRODUCT ADD CONSTRAINT FK914C771DAF5697EF FOREIGN KEY(SUPPLIER_ID) REFERENCES A_ERP2_SUPPLIER(ID)
ALTER TABLE A_ERP2_SUPPLIER ADD CONSTRAINT FK70F2953E252E3FF1 FOREIGN KEY(REGION_ID) REFERENCES A_SECURITY_REGION(ID)
ALTER TABLE A_NEWS ADD CONSTRAINT FK744A3C118F5E23F7 FOREIGN KEY(CATEGORY_ID) REFERENCES A_NEWS_CATEGORY(ID)
ALTER TABLE A_NEWS_NEWSTAG ADD CONSTRAINT FK923EAD9963BB8EF0 FOREIGN KEY(NEWSTAG_ID) REFERENCES A_NEWS_TAG(ID)
ALTER TABLE A_SECURITY_MENU_ROLE ADD CONSTRAINT FK14BCADD556E5FA71 FOREIGN KEY(ROLE_ID) REFERENCES A_SECURITY_ROLE(ID)
ALTER TABLE A_SECURITY_RESOURCE_ROLE ADD CONSTRAINT FK6FD1850656E5FA71 FOREIGN KEY(ROLE_ID) REFERENCES A_SECURITY_ROLE(ID)
ALTER TABLE A_SECURITY_ROLE_USER ADD CONSTRAINT FK83C60473FC10BE51 FOREIGN KEY(USER_ID) REFERENCES A_SECURITY_USER(ID)
ALTER TABLE A_TRACKER_ISSUE ADD CONSTRAINT FK20F791548D35A05B FOREIGN KEY(PROJECT_ID) REFERENCES A_TRACKER_PROJECT(ID)
CREATE USER SA PASSWORD ""
GRANT DBA TO SA
SET WRITE_DELAY 10
SET SCHEMA PUBLIC