test.script

来自「anewssystem新闻发布系统集成使用了spring hibernate f」· SCRIPT 代码 · 共 178 行 · 第 1/2 页

CREATE SCHEMA PUBLIC AUTHORIZATION DBA
CREATE MEMORY TABLE A_NEWS(ID BIGINT NOT NULL PRIMARY KEY,CONTENT LONGVARCHAR,EDITOR VARCHAR(50),HIT INTEGER,IMAGE VARCHAR(50),LINK VARCHAR(100),NAME VARCHAR(100),SOURCE VARCHAR(50),STATUS INTEGER,SUBTITLE VARCHAR(100),SUMMARY VARCHAR(255),UPDATE_DATE TIMESTAMP,CATEGORY_ID BIGINT,CONSTRAINT SYS_CT_46 UNIQUE(ID))
CREATE MEMORY TABLE A_NEWS_CATEGORY(ID BIGINT NOT NULL PRIMARY KEY,BIT_CODE BIGINT,CHAR_CODE VARCHAR(255),NAME VARCHAR(50),STATUS INTEGER,THE_SORT INTEGER,PARENT_ID BIGINT,CONSTRAINT SYS_CT_50 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,CONTENT LONGVARCHAR,IP VARCHAR(20),NAME VARCHAR(100),STATUS INTEGER,UPDATE_DATE TIMESTAMP,USERNAME VARCHAR(50),NEWS_ID BIGINT,CONSTRAINT SYS_CT_54 UNIQUE(ID),CONSTRAINT FK5CDABC117E0115E4 FOREIGN KEY(NEWS_ID) REFERENCES A_NEWS(ID))
CREATE MEMORY TABLE A_NEWS_CONFIG(ID BIGINT NOT NULL PRIMARY KEY,CATEGORY_STRATEGY INTEGER,COMMENT_NEED_AUDIT INTEGER,COULD_COMMENT INTEGER,NEWS_NEED_AUDIT INTEGER,TEMPLATE_NAME VARCHAR(50),CONSTRAINT SYS_CT_58 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,NAME VARCHAR(50),THE_SORT INTEGER,CONSTRAINT SYS_CT_64 UNIQUE(ID))
CREATE MEMORY TABLE A_SECURITY_DEPT(ID BIGINT NOT NULL PRIMARY KEY,DESCN VARCHAR(200),NAME VARCHAR(50),THE_SORT INTEGER,PARENT_ID BIGINT,CONSTRAINT SYS_CT_68 UNIQUE(ID),CONSTRAINT FK33849C668034938C FOREIGN KEY(PARENT_ID) REFERENCES A_SECURITY_DEPT(ID))
CREATE MEMORY TABLE A_SECURITY_MENU(ID BIGINT NOT NULL PRIMARY KEY,DESCN VARCHAR(200),URL VARCHAR(50),IMAGE VARCHAR(50),NAME VARCHAR(50),THE_SORT INTEGER,QTIP VARCHAR(50),PARENT_ID BIGINT,CONSTRAINT SYS_CT_72 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_RESOURCE(ID BIGINT NOT NULL PRIMARY KEY,DESCN VARCHAR(200),NAME VARCHAR(50),RES_STRING VARCHAR(200),RES_TYPE VARCHAR(50),CONSTRAINT SYS_CT_78 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),CONSTRAINT SYS_CT_84 UNIQUE(ID))
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,BIRTHDAY TIMESTAMP,CODE VARCHAR(50),DESCN VARCHAR(200),DUTY VARCHAR(50),EMAIL VARCHAR(100),MOBILE VARCHAR(50),PASSWORD VARCHAR(50),SEX TINYINT,STATUS TINYINT,TEL VARCHAR(50),TRUENAME VARCHAR(50),USERNAME VARCHAR(50),DEPT_ID BIGINT,CONSTRAINT SYS_CT_90 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,ADD_TIME TIMESTAMP,ASSIGN_TO VARCHAR(50),CONTENT LONGVARCHAR,FILE VARCHAR(100),NAME VARCHAR(50),PRIORITY INTEGER,SEVERITY INTEGER,STATUS INTEGER,SUBMIT_BY VARCHAR(50),UPDATE_DATE TIMESTAMP,PROJECT_ID BIGINT,CONSTRAINT SYS_CT_118 UNIQUE(ID))
CREATE MEMORY TABLE A_TRACKER_PROJECT(ID BIGINT NOT NULL PRIMARY KEY,NAME VARCHAR(100),SUMMARY LONGVARCHAR,THE_SORT INTEGER,FOUNDER VARCHAR(50),CONSTRAINT SYS_CT_122 UNIQUE(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
INSERT INTO A_NEWS VALUES(1,'dd','',NULL,'','/anews/html/3/2007/09/17/1.html','dd','\u3010\u672c\u7ad9\u539f\u521b\u3011',2,'ddd','dd','2007-09-17 00:00:00.000000000',3)
INSERT INTO A_NEWS VALUES(2,'sadf','',NULL,'','/anews/html/2/2007/10/06/2.html','tt','\u3010\u672c\u7ad9\u539f\u521b\u3011',3,'est','tset','2007-10-06 00:00:00.000000000',1)
INSERT INTO A_NEWS VALUES(3,' 654','',NULL,NULL,'','1454','\u3010\u672c\u7ad9\u539f\u521b\u3011',NULL,'45','4541','2007-10-06 00:00:00.000000000',NULL)
INSERT INTO A_NEWS VALUES(4,' 54','',NULL,NULL,'','12','\u3010\u672c\u7ad9\u539f\u521b\u3011',NULL,'1','564','2007-10-06 00:00:00.000000000',NULL)
INSERT INTO A_NEWS VALUES(5,' 656','',NULL,NULL,'','6','\u3010\u672c\u7ad9\u539f\u521b\u3011',3,'54','54','2007-10-06 00:00:00.000000000',1)
INSERT INTO A_NEWS VALUES(6,' \u5510\u5c71\u7279\u522b\u7279\u522b\u597d','',NULL,NULL,'/anews/html/3/2007/10/12/6.html','\u5510\u5c71\u597d','\u3010\u672c\u7ad9\u539f\u521b\u3011',3,'\u5510\u5c71\u5f88\u597d','\u5510\u5c71\u7279\u522b\u597d','2007-10-12 00:00:00.000000000',3)
INSERT INTO A_NEWS VALUES(7,' tse','\u4e34\u8fdc',NULL,NULL,'/anews/html/3/2007/10/12/7.html','test','\u3010\u672c\u7ad9\u539f\u521b\u3011',3,'tset','tset','2007-10-12 00:00:00.000000000',3)
INSERT INTO A_NEWS_CATEGORY VALUES(1,72057594037927936,NULL,'\u5730\u65b9\u65b0\u95fb',NULL,0,NULL)
INSERT INTO A_NEWS_CATEGORY VALUES(2,72339069014638592,NULL,'\u6cb3\u5317\u65b0\u95fb',NULL,1,1)
INSERT INTO A_NEWS_CATEGORY VALUES(3,72340168526266368,NULL,'\u5510\u5c71\u65b0\u95fb',NULL,2,2)
INSERT INTO A_NEWS_CONFIG VALUES(1,0,0,0,0,'extjs')
INSERT INTO A_NEWS_NEWSTAG VALUES(2,2)
INSERT INTO A_NEWS_NEWSTAG VALUES(3,2)
INSERT INTO A_NEWS_NEWSTAG VALUES(4,2)
INSERT INTO A_NEWS_NEWSTAG VALUES(5,7)
INSERT INTO A_NEWS_TAG VALUES(2,'222',NULL)
INSERT INTO A_NEWS_TAG VALUES(3,'2',NULL)
INSERT INTO A_NEWS_TAG VALUES(4,'444',NULL)
INSERT INTO A_NEWS_TAG VALUES(5,'test',NULL)
INSERT INTO A_SECURITY_DEPT VALUES(1,'','\u6280\u672f\u90e8',0,NULL)
INSERT INTO A_SECURITY_DEPT VALUES(2,'\u5e02\u573a','\u5e02\u573a\u90e8',4,NULL)
INSERT INTO A_SECURITY_DEPT VALUES(3,'\u9500\u552e\u7684\u90e8\u95e8\uff0c\u5356\u4e0d\u51fa\u53bb\u53ef\u4e0d\u884c\u554a','\u9500\u552e\u90e8',5,NULL)
INSERT INTO A_SECURITY_DEPT VALUES(4,NULL,'\u7814\u53d1\u90e8',2,1)
INSERT INTO A_SECURITY_DEPT VALUES(5,'','\u4ea7\u54c1\u90e8',1,1)
INSERT INTO A_SECURITY_MENU VALUES(44,'11','./','set.gif','sandbox',13,'1',NULL)
INSERT INTO A_SECURITY_MENU VALUES(45,'','../newstag2/dialogManage.htm','user.gif','\u4f53\u9a8cdialog',24,'',44)
INSERT INTO A_SECURITY_MENU VALUES(46,'','../newstag2/inlineManage.htm','user.gif','\u4f53\u9a8ceditor',23,'',44)
INSERT INTO A_SECURITY_MENU VALUES(47,'','./','set.gif','\u65b0\u95fb\u53d1\u5e03',0,'',NULL)
INSERT INTO A_SECURITY_MENU VALUES(48,'','../newscategory/index.htm','user.gif','\u65b0\u95fb\u5206\u7c7b\u7ba1\u7406',2,'',47)
INSERT INTO A_SECURITY_MENU VALUES(50,'\u7ba1\u7406\u65b0\u95fb','../news/index.htm','user.gif','\u7ba1\u7406\u65b0\u95fb',3,'\u7ba1\u7406\u65b0\u95fb',47)
INSERT INTO A_SECURITY_MENU VALUES(52,'','../newstag/index.htm','user.gif','\u7ba1\u7406\u5173\u952e\u5b57',4,'',47)
INSERT INTO A_SECURITY_MENU VALUES(53,'\u65b0\u95fb\u5c5e\u6027\u8bbe\u7f6e','../newsconfig/index.htm','user.gif','\u65b0\u95fb\u5c5e\u6027\u8bbe\u7f6e',5,'\u65b0\u95fb\u5c5e\u6027\u8bbe\u7f6e',47)
INSERT INTO A_SECURITY_MENU VALUES(54,'','../template/dd.htm','user.gif','\u8bbe\u7f6e\u6a21\u677f',22,'',44)
INSERT INTO A_SECURITY_MENU VALUES(56,'','./','set.gif','\u6743\u9650\u8bbe\u7f6e',6,'',NULL)
INSERT INTO A_SECURITY_MENU VALUES(57,'','../user/index.htm','user.gif','\u7ba1\u7406\u7528\u6237',12,'',56)
INSERT INTO A_SECURITY_MENU VALUES(58,'','../resource/index.htm','user.gif','\u7ba1\u7406\u8d44\u6e90',11,'',56)
INSERT INTO A_SECURITY_MENU VALUES(59,'','../role/index.htm','user.gif','\u7ba1\u7406\u89d2\u8272',10,'',56)
INSERT INTO A_SECURITY_MENU VALUES(60,'','../menu/index.htm','user.gif','\u7ba1\u7406\u83dc\u5355',7,'',56)
INSERT INTO A_SECURITY_MENU VALUES(61,'','../sandbox/datagrid.htm','user.gif','DataGrid',21,'',44)
INSERT INTO A_SECURITY_MENU VALUES(62,'\u90e8\u95e8','../dept/index.htm','user.gif','\u7ba1\u7406\u90e8\u95e8',8,'\u90e8\u95e8',56)
INSERT INTO A_SECURITY_MENU VALUES(63,'','../widgets/lingo/jsontree/Ext.lingo.JsonTree.html','user.gif','Ext.lingo.JsonTree',19,'',44)
INSERT INTO A_SECURITY_MENU VALUES(64,'','../widgets/lingo/jsongrid/Ext.lingo.JsonGrid.html','user.gif','Ext.lingo.JsonGrid',18,'',44)
INSERT INTO A_SECURITY_MENU VALUES(65,'\u5e26\u9009\u62e9\u6846\u7684\u6811','../widgets/lingo/checkboxtree/checkboxtree.html','user.gif','CheckBoxTree',20,'\u5e26\u9009\u62e9\u6846\u7684\u6811',44)
INSERT INTO A_SECURITY_MENU VALUES(66,'\u4e24\u4e2a\u8868\u683c\u95f4\u62d6\u52a8','../widgets/lingo/form/ddgrid.html','user.gif','grid\u62d6\u62fd',17,'\u4e24\u4e2a\u8868\u683c\u95f4\u62d6\u52a8',44)
INSERT INTO A_SECURITY_MENU VALUES(67,'\u5207\u6362\u8f93\u5165\u6846','../widgets/lingo/form/switchField.html','user.gif','\u5207\u6362\u8f93\u5165\u6846',16,'\u5207\u6362\u8f93\u5165\u6846',44)
INSERT INTO A_SECURITY_MENU VALUES(68,'tree\u4e0egrid\u62d6\u62fd','../widgets/lingo/form/ddtree2.html','user.gif','tree\u4e0egrid\u62d6\u62fd',26,'tree\u4e0egrid\u62d6\u62fd',44)
INSERT INTO A_SECURITY_MENU VALUES(69,'tree\u4e0egrid\u62d6\u62fd\uff0c\u4e0d\u77e5\u9053\u4e3a\u5565\u5931\u8d25','../widgets/lingo/form/ddtree.html','user.gif','tree\u4e0egrid\u62d6\u62fd\uff0c\u4e0d\u77e5\u9053\u4e3a\u5565\u5931\u8d25',25,'tree\u4e0egrid\u62d6\u62fd\uff0c\u4e0d\u77e5\u9053\u4e3a\u5565\u5931\u8d25',44)
INSERT INTO A_SECURITY_MENU VALUES(70,'\u7ec4\u7ec7\u7ed3\u6784\u56fe','../dept/orgmap.htm','user.gif','\u7ec4\u7ec7\u7ed3\u6784\u56fe',9,'\u7ec4\u7ec7\u7ed3\u6784\u56fe',56)
INSERT INTO A_SECURITY_MENU VALUES(71,'\u6811\u5f62\u4e0b\u62c9\u6846','../widgets/lingo/form/treeField.html','user.gif','\u6811\u5f62\u4e0b\u62c9\u6846',15,'\u6811\u5f62\u4e0b\u62c9\u6846',44)
INSERT INTO A_SECURITY_MENU VALUES(72,'\u7ea7\u8054combobox','../widgets/lingo/form/room.html','user.gif','\u7ea7\u8054combobox',14,'\u7ea7\u8054combobox',44)
INSERT INTO A_SECURITY_MENU VALUES(73,'\u5ba1\u6838\u65b0\u95fb','../news/manage.htm','user.gif','\u5ba1\u6838\u65b0\u95fb',1,'\u5ba1\u6838\u65b0\u95fb',47)
INSERT INTO A_SECURITY_MENU_ROLE VALUES(47,2)
INSERT INTO A_SECURITY_MENU_ROLE VALUES(48,2)
INSERT INTO A_SECURITY_MENU_ROLE VALUES(50,2)
INSERT INTO A_SECURITY_MENU_ROLE VALUES(56,2)
INSERT INTO A_SECURITY_MENU_ROLE VALUES(57,2)
INSERT INTO A_SECURITY_MENU_ROLE VALUES(58,2)
INSERT INTO A_SECURITY_MENU_ROLE VALUES(47,3)
INSERT INTO A_SECURITY_MENU_ROLE VALUES(48,3)
INSERT INTO A_SECURITY_MENU_ROLE VALUES(50,3)
INSERT INTO A_SECURITY_MENU_ROLE VALUES(52,3)
INSERT INTO A_SECURITY_MENU_ROLE VALUES(53,3)