论坛首页新手上路 签到
查看: 175|回复: 0

金智报表 老版本数据库初始化脚本

[复制链接]
金智教育-熊俊

该用户从未签到

40

主题

40

帖子

120

积分

版主

Rank: 7Rank: 7Rank: 7

积分
120
发表于 2020-11-24 14:11:54 | 显示全部楼层 |阅读模式
本帖最后由 xiongjun 于 2020-11-24 14:14 编辑
  1. CREATE TABLE "SCHEME" ("ID" NUMBER(19,0), "BY1" VARCHAR2(4000 CHAR), "BY2" VARCHAR2(4000 CHAR), "BY3" VARCHAR2(4000 CHAR), "BY4" VARCHAR2(4000 CHAR), "CUSTOM_ATTRIBUTE" VARCHAR2(4000 CHAR), "CUSTOM_SETTINGS" VARCHAR2(4000 CHAR), "DATA_SOURCE_NAME" VARCHAR2(30 CHAR), "DEFAULT_SELECTION" VARCHAR2(4000 CHAR), "DESCRIPTION" VARCHAR2(4000 CHAR), "FIELD_GROUP_SETTING" VARCHAR2(4000 CHAR), "FIXED_QUERY_SETTING" VARCHAR2(4000 CHAR), "PAGESETTINGS" VARCHAR2(4000 CHAR), "REPORT_TYPE" VARCHAR2(100 CHAR), "SCHEME_NAME" VARCHAR2(300 CHAR), "STARTED" NUMBER(1,0), "TABLE_NAME" VARCHAR2(30 CHAR), "TAG" VARCHAR2(300 CHAR), "TITLES" VARCHAR2(4000 CHAR), "CAPTION" VARCHAR2(100 CHAR), "LAST_UPDATE_TIME" NUMBER(19,0) DEFAULT 0);
  2. COMMENT ON COLUMN "SCHEME"."LAST_UPDATE_TIME" IS '最后修改时间';
  3. ALTER TABLE "SCHEME" MODIFY ("ID" NOT NULL ENABLE);
  4. ALTER TABLE "SCHEME" MODIFY ("REPORT_TYPE" NOT NULL ENABLE);
  5. ALTER TABLE "SCHEME" MODIFY ("SCHEME_NAME" NOT NULL ENABLE);
  6. ALTER TABLE "SCHEME" MODIFY ("LAST_UPDATE_TIME" NOT NULL ENABLE);


  7. CREATE TABLE "SCHEME_DATA_FIELD" ("ID" NUMBER(19,0), "FIELD_GROUP_INDEXES" VARCHAR2(600 CHAR), "FIELD_GROUP_TYPES" VARCHAR2(600 CHAR), "FIELD_NAME" VARCHAR2(100 CHAR), "STATISTIC_METHODS" VARCHAR2(600 CHAR), "SCHEME_ID" NUMBER(19,0));
  8. ALTER TABLE "SCHEME_DATA_FIELD" MODIFY ("ID" NOT NULL ENABLE);
  9. ALTER TABLE "SCHEME_DATA_FIELD" MODIFY ("FIELD_NAME" NOT NULL ENABLE);


  10. CREATE SEQUENCE  "SCHEMEINFO_SEQUENCE"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20;
  11. CREATE SEQUENCE  "SCHEMEDATAFIELD_SEQUENCE"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20;
复制代码

您需要登录后才可以回帖 登录 | 加入我们

本版积分规则

Archiver|手机版|小黑屋|江苏金智教育信息股份有限公司 ( 系统管理员:binmeng@wisedu.com  

GMT+8, 2021-3-3 03:47

Powered by Discuz! X3.2

© 2015 Design: www.wisedu.com

快速回复 返回顶部 返回列表