test.script

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

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,HTML VARCHAR(100),PAGE_SIZE INTEGER,PAGE_TYPE INTEGER,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))
CREATE MEMORY TABLE A_SECURITY_REGION(ID BIGINT NOT NULL PRIMARY KEY,DESCN VARCHAR(200),NAME VARCHAR(50),THE_SORT INTEGER,PARENT_ID BIGINT,CONSTRAINT SYS_CT_142 UNIQUE(ID),CONSTRAINT FK7CAEBCD59C267A7B FOREIGN KEY(PARENT_ID) REFERENCES A_SECURITY_REGION(ID))
CREATE MEMORY TABLE A_SECURITY_DICTIONARY(ID BIGINT NOT NULL PRIMARY KEY,DESCN VARCHAR(200),NAME VARCHAR(50),THE_SORT INTEGER,PARENT_ID BIGINT,CONSTRAINT SYS_CT_164 UNIQUE(ID),CONSTRAINT FKC5F51617CFF5909D FOREIGN KEY(PARENT_ID) REFERENCES A_SECURITY_DICTIONARY(ID))
CREATE MEMORY TABLE A_ERP_CUSTOMER(ID BIGINT NOT NULL PRIMARY KEY,ADDRESS VARCHAR(50),CITY VARCHAR(50),CODE VARCHAR(50),DESCN LONGVARCHAR,EMAIL VARCHAR(50),FAX VARCHAR(50),HOMEPAGE VARCHAR(50),INPUT_MAN VARCHAR(50),INPUT_TIME TIMESTAMP,LEADER VARCHAR(50),LINK_MAN VARCHAR(50),NAME VARCHAR(50),PROVINCE VARCHAR(50),RANK VARCHAR(50),SOURCE VARCHAR(50),STATUS VARCHAR(50),TEL VARCHAR(50),TOWN VARCHAR(50),TYPE VARCHAR(50),ZIP VARCHAR(50),CONSTRAINT SYS_CT_186 UNIQUE(ID))
CREATE MEMORY TABLE A_ERP_MATERIAL(ID BIGINT NOT NULL PRIMARY KEY,DESCN LONGVARCHAR,INPUT_MAN VARCHAR(50),INPUT_TIME TIMESTAMP,NAME VARCHAR(50),PRICE DOUBLE,SOURCE VARCHAR(50),STATUS VARCHAR(50),SUPPLIER VARCHAR(50),UNIT VARCHAR(50),CONSTRAINT SYS_CT_190 UNIQUE(ID))
CREATE MEMORY TABLE A_ERP_ORDER(ID BIGINT NOT NULL PRIMARY KEY,AMOUNT VARCHAR(50),CODE VARCHAR(50),CUSTOMER VARCHAR(50),DELIVERY VARCHAR(50),DESCN LONGVARCHAR,HAND_MAN VARCHAR(50),INPUT_MAN VARCHAR(50),INPUT_TIME TIMESTAMP,LINK_MAN VARCHAR(50),ORDER_DATE TIMESTAMP,PAYMENT VARCHAR(50),STATUS VARCHAR(50),TEL VARCHAR(50),CONSTRAINT SYS_CT_194 UNIQUE(ID))
CREATE MEMORY TABLE A_ERP_ORDER_INFO(ID BIGINT NOT NULL PRIMARY KEY,AMOUNT VARCHAR(50),AREA VARCHAR(50),HEIGHT VARCHAR(50),NUM VARCHAR(50),PRICE VARCHAR(50),PRODUCT VARCHAR(50),STATUS VARCHAR(50),TYPE VARCHAR(50),UNIT VARCHAR(50),UNIT_TYPE VARCHAR(50),WIDTH VARCHAR(50),ORDER_ID BIGINT,CONSTRAINT SYS_CT_198 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,BUY_PRICE DOUBLE,CODE VARCHAR(50),DESCN LONGVARCHAR,INPUT_MAN VARCHAR(50),INPUT_TIME TIMESTAMP,NAME VARCHAR(50),PIC VARCHAR(50),SALE_PRICE DOUBLE,STATUS VARCHAR(50),TYPE VARCHAR(50),UNIT VARCHAR(50),CONSTRAINT SYS_CT_202 UNIQUE(ID))
CREATE MEMORY TABLE A_ERP_RATION(ID BIGINT NOT NULL PRIMARY KEY,DESCN LONGVARCHAR,INPUT_MAN VARCHAR(50),INPUT_TIME TIMESTAMP,MATERIAL VARCHAR(50),PRODUCT VARCHAR(50),RATE VARCHAR(50),STATUS VARCHAR(50),UNIT VARCHAR(50),CONSTRAINT SYS_CT_206 UNIQUE(ID))
CREATE MEMORY TABLE A_ERP2_PRODUCT(ID BIGINT NOT NULL PRIMARY KEY,DESCN LONGVARCHAR,FACTORY VARCHAR(50),MATERIAL VARCHAR(50),NAME VARCHAR(50),NUM INTEGER,PRICE DOUBLE,TOTAL DOUBLE,TYPE INTEGER,UNIT INTEGER,SUPPLIER_ID BIGINT,CONSTRAINT SYS_CT_222 UNIQUE(ID))
CREATE MEMORY TABLE A_ERP2_SUPPLIER(ID BIGINT NOT NULL PRIMARY KEY,ADDRESS VARCHAR(50),AREA VARCHAR(50),CODE VARCHAR(50),DESCN LONGVARCHAR,EMAIL VARCHAR(50),FAX VARCHAR(50),HOMEPAGE VARCHAR(50),LINKMAN VARCHAR(50),NAME VARCHAR(50),RANK INTEGER,TEL VARCHAR(50),TYPE INTEGER,ZIP VARCHAR(50),REGION_ID BIGINT,LEAD VARCHAR(50),CONSTRAINT SYS_CT_226 UNIQUE(ID),CONSTRAINT FK70F2953E252E3FF1 FOREIGN KEY(REGION_ID) REFERENCES A_SECURITY_REGION(ID))
CREATE MEMORY TABLE A_ERP2_BID(ID BIGINT NOT NULL PRIMARY KEY,CODE VARCHAR(50),DESCN LONGVARCHAR,END_DATE TIMESTAMP,OPEN_DATE TIMESTAMP,PARAMETER VARCHAR(200),PRODUCT_NUM INTEGER,START_DATE TIMESTAMP,PRODUCT_ID BIGINT,CONSTRAINT SYS_CT_250 UNIQUE(ID),CONSTRAINT FK88EB762BCB310305 FOREIGN KEY(PRODUCT_ID) REFERENCES A_ERP2_PRODUCT(ID))
CREATE MEMORY TABLE A_ERP2_INVITE_BID(ID BIGINT NOT NULL PRIMARY KEY,ADDRESS VARCHAR(50),BID_DATE TIMESTAMP,DESCN LONGVARCHAR,EMAIL VARCHAR(50),PRICE DOUBLE,TEL VARCHAR(50),BID_ID BIGINT,SUPPLLIER_ID BIGINT,CONSTRAINT SYS_CT_274 UNIQUE(ID),CONSTRAINT FK705A3D99E8F95E07 FOREIGN KEY(SUPPLLIER_ID) REFERENCES A_ERP2_SUPPLIER(ID),CONSTRAINT FK705A3D99411FEDC5 FOREIGN KEY(BID_ID) REFERENCES A_ERP2_BID(ID))
CREATE MEMORY TABLE A_ERP2_SUCCESS_BID(ID BIGINT NOT NULL PRIMARY KEY,DESCN LONGVARCHAR,PRICE DOUBLE,PUBLISH_DATE TIMESTAMP,INVITE_BID_ID BIGINT,BID_CONTENT VARCHAR(50),CONSTRAINT SYS_CT_296 UNIQUE(ID),CONSTRAINT FKA74D99CFC301B3B2 FOREIGN KEY(INVITE_BID_ID) REFERENCES A_ERP2_INVITE_BID(ID))
CREATE MEMORY TABLE A_ERP2_BUY_ORDER(ID BIGINT NOT NULL PRIMARY KEY,AUDIT INTEGER,CODE VARCHAR(50),LINKMAN VARCHAR(50),ORDER_DATE TIMESTAMP,PRICE DOUBLE,PROVIDE_DATE TIMESTAMP,STATUS INTEGER,TOTAL_PRICE DOUBLE,USERNAME VARCHAR(50),SUPPLIER_ID BIGINT,NAME VARCHAR(50),CONSTRAINT SYS_CT_320 UNIQUE(ID),CONSTRAINT FKCAB3D2E3AF5697EF FOREIGN KEY(SUPPLIER_ID) REFERENCES A_ERP2_SUPPLIER(ID))
CREATE MEMORY TABLE A_ERP2_BUY_ORDER_INFO(ID BIGINT NOT NULL PRIMARY KEY,DESCN LONGVARCHAR,NUM INTEGER,PARAMETER VARCHAR(50),PRICE DOUBLE,TOTAL_PRICE DOUBLE,PRODUCT_ID BIGINT,BUY_ORDER_ID BIGINT,CODE VARCHAR(50),CONSTRAINT SYS_CT_324 UNIQUE(ID),CONSTRAINT FKCF98988ACB310305 FOREIGN KEY(PRODUCT_ID) REFERENCES A_ERP2_PRODUCT(ID),CONSTRAINT FKCF98988AB850EF62 FOREIGN KEY(BUY_ORDER_ID) REFERENCES A_ERP2_BUY_ORDER(ID))
CREATE MEMORY TABLE A_ERP2_BUY_CONTRACT(ID BIGINT NOT NULL PRIMARY KEY,CODE VARCHAR(50),CONTRACT_DATE TIMESTAMP,LINKMAN VARCHAR(50),NAME VARCHAR(50),PROVIDE_DATE TIMESTAMP,RECEIPT VARCHAR(50),STATUS VARCHAR(50),SUPPLIER_ID BIGINT,USERNAME VARCHAR(50),CONSTRAINT SYS_CT_351 UNIQUE(ID),CONSTRAINT FK48EE253DAF5697EF FOREIGN KEY(SUPPLIER_ID) REFERENCES A_ERP2_SUPPLIER(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)
ALTER TABLE A_ERP2_PRODUCT ADD CONSTRAINT FK914C771DAF5697EF FOREIGN KEY(SUPPLIER_ID) REFERENCES A_ERP2_SUPPLIER(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,NULL,1000,0)
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,NULL,1000,0)
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,NULL,1000,0)
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,NULL,1000,0)
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,NULL,1000,0)
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,NULL,1000,0)
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,NULL,1000,0)
INSERT INTO A_NEWS VALUES(8,' sadf','\u7ba1\u7406\u5458',NULL,NULL,NULL,'sadf','\u539f\u521b',0,'sdaf','asdf','2007-10-22 00:00:00.000000000',NULL,NULL,1000,0)
INSERT INTO A_NEWS VALUES(9,' sadf','\u7ba1\u7406\u5458',NULL,NULL,NULL,'sadf','\u539f\u521b',0,'sdaf','asdf','2007-10-22 00:00:00.000000000',NULL,NULL,1000,0)
INSERT INTO A_NEWS VALUES(10,' sadf','\u7ba1\u7406\u5458',NULL,NULL,NULL,'sadf','\u539f\u521b',0,'sdaf','asdf','2007-10-22 00:00:00.000000000',NULL,NULL,1000,0)
INSERT INTO A_NEWS VALUES(11,' sadf','\u7ba1\u7406\u5458',NULL,NULL,NULL,'sadf','\u539f\u521b',0,'sdaf','asdf','2007-10-22 00:00:00.000000000',NULL,NULL,1000,0)
INSERT INTO A_NEWS VALUES(12,' asdf','\u7ba1\u7406\u5458',NULL,NULL,'/anews/html/1/2007/10/22/12.html','adf','\u539f\u521b',0,NULL,'asfd','2007-10-22 00:00:00.000000000',1,NULL,1000,0)
INSERT INTO A_NEWS VALUES(13,' asdf','\u7ba1\u7406\u5458',NULL,NULL,'/anews/html/1/2007/10/22/13.html','dsf','\u539f\u521b',0,NULL,'sdf','2007-10-22 00:00:00.000000000',1,NULL,1000,0)
INSERT INTO A_NEWS VALUES(14,' asdf','\u7ba1\u7406\u5458',NULL,NULL,'/anews/html/1/2007/10/22/14.html','dsf','\u539f\u521b',0,NULL,'sdf','2007-10-22 00:00:00.000000000',1,NULL,1000,0)
INSERT INTO A_NEWS VALUES(15,' asdf','\u7ba1\u7406\u5458',NULL,NULL,'/anews/html/1/2007/10/22/15.html','dsf','\u539f\u521b',0,NULL,'sdf','2007-10-22 00:00:00.000000000',1,NULL,1000,0)
INSERT INTO A_NEWS VALUES(16,' asdf','\u7ba1\u7406\u5458',NULL,NULL,'/anews/html/1/2007/10/22/16.html','dsf','\u539f\u521b',0,NULL,'sdf','2007-10-22 00:00:00.000000000',1,NULL,1000,0)
INSERT INTO A_NEWS VALUES(17,' asdf','\u7ba1\u7406\u5458',NULL,NULL,'/anews/html/1/2007/10/22/17.html','dsf','\u539f\u521b',0,NULL,'sdf','2007-10-22 00:00:00.000000000',1,NULL,1000,0)
INSERT INTO A_NEWS VALUES(18,' asdf','\u7ba1\u7406\u5458',NULL,NULL,'/anews/html/1/2007/10/22/18.html','dsf','\u539f\u521b',0,NULL,'sdf','2007-10-22 00:00:00.000000000',1,NULL,1000,0)
INSERT INTO A_NEWS VALUES(19,' asdf','\u7ba1\u7406\u5458',NULL,NULL,'/anews/html/1/2007/10/22/19.html','dsf','\u539f\u521b',0,NULL,'sdf','2007-10-22 00:00:00.000000000',1,NULL,1000,0)
INSERT INTO A_NEWS VALUES(20,' asdf','\u7ba1\u7406\u5458',NULL,NULL,'/anews/html/1/2007/10/22/20.html','sdf','\u539f\u521b',0,NULL,'dsf','2007-10-22 00:00:00.000000000',1,NULL,1000,0)
INSERT INTO A_NEWS VALUES(21,' asdf','\u7ba1\u7406\u5458',NULL,NULL,'/anews/html/1/2007/10/22/21.html','sdf','\u539f\u521b',0,NULL,'sadf','2007-10-22 00:00:00.000000000',1,NULL,1000,0)
INSERT INTO A_NEWS VALUES(22,' asdf','\u7ba1\u7406\u5458',NULL,'uploadfiles/news/images//1193021223421r_jasper0404.jpg','/anews/html/1/2007/10/22/22.html','fds','\u539f\u521b',0,NULL,'adf','2007-10-22 00:00:00.000000000',1,NULL,1000,0)
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_NEWSTAG VALUES(6,12)
INSERT INTO A_NEWS_NEWSTAG VALUES(7,13)
INSERT INTO A_NEWS_NEWSTAG VALUES(7,14)
INSERT INTO A_NEWS_NEWSTAG VALUES(7,15)
INSERT INTO A_NEWS_NEWSTAG VALUES(7,16)
INSERT INTO A_NEWS_NEWSTAG VALUES(7,17)
INSERT INTO A_NEWS_NEWSTAG VALUES(7,18)