jeecgboot积木报表（jimuReport）Oracle切换

准备数据库
执行Oracle SQL，或使用MySQL的SQL代码创建库后，使用DBeaver或navicat等工具转换为Oracle库（官方最新）

修改数据库链接字符串
url: jdbc:oracle:thin:@192.168.1.1:1521:ORCL
username: root
password: root
driver-class-name: oracle.jdbc.OracleDriver
数据库脚本

CREATE TABLE jimu_dict  (
  id varchar2(32)  NOT NULL,
  dict_name nvarchar2(100)  NULL,
  dict_code varchar2(100)  NULL,
  description nvarchar2(255)  NULL,
  del_flag number(1) NULL,
  create_by varchar2(32)  NULL ,
  create_time DATE NULL ,
  update_by varchar2(32)  NULL  ,
  update_time DATE NULL ,
  type number(1)  NULL  ,
  PRIMARY KEY (ID)
);

COMMENT ON COLUMN jimu_dict.dict_name IS '字典名称';
COMMENT ON COLUMN jimu_dict.dict_code IS '字典编码';
COMMENT ON COLUMN jimu_dict.description IS '描述';
COMMENT ON COLUMN jimu_dict.del_flag IS '删除状态';
COMMENT ON COLUMN jimu_dict.type IS '字典类型0为string,1为number';

CREATE TABLE  JIMU_DICT_ITEM(
ID VARCHAR(32) NOT NULL,
DICT_ID VARCHAR(32),
ITEM_TEXT NVARCHAR2(100) NOT NULL,
ITEM_VALUE NVARCHAR2(100) NOT NULL,
DESCRIPTION NVARCHAR2(255),
SORT_ORDER DECIMAL,
STATUS DECIMAL,
CREATE_BY VARCHAR(32),
CREATE_TIME DATE,
UPDATE_BY VARCHAR(32),
UPDATE_TIME DATE,
PRIMARY KEY (ID)
);

CREATE TABLE "JIMU_REPORT"
   ( "ID" VARCHAR2(32),
"CODE" VARCHAR2(50),
"NAME" VARCHAR2(50),
"NOTE" VARCHAR2(255),
"STATUS" VARCHAR2(10),
"TYPE" VARCHAR2(10),
"JSON_STR" CLOB,
"API_URL" VARCHAR2(255),
"THUMB" VARCHAR2(4000),
"CREATE_BY" VARCHAR2(50),
"CREATE_TIME" TIMESTAMP (6),
"UPDATE_BY" VARCHAR2(50),
"UPDATE_TIME" TIMESTAMP (6),
"DEL_FLAG" NUMBER(3,0),
"API_METHOD" VARCHAR2(255),
"API_CODE" VARCHAR2(255),
"TEMPLATE" NUMBER(3,0),
"VIEW_COUNT" NUMBER(19,0)
   )  ;
ALTER TABLE JIMU_REPORT ADD (css_str nclob);
COMMENT ON COLUMN JIMU_REPORT.css_str IS 'css增强';
ALTER TABLE JIMU_REPORT ADD (js_str nclob);
COMMENT ON COLUMN JIMU_REPORT.js_str IS 'js增强';  

CREATE TABLE "JIMU_REPORT_DATA_SOURCE"
   ( "ID" VARCHAR2(36),
"NAME" VARCHAR2(100),
"REPORT_ID" VARCHAR2(100),
"CODE" VARCHAR2(100),
"REMARK" VARCHAR2(200),
"DB_TYPE" VARCHAR2(10),
"DB_DRIVER" VARCHAR2(100),
"DB_URL" VARCHAR2(500),
"DB_USERNAME" VARCHAR2(100),
"DB_PASSWORD" VARCHAR2(100),
"CREATE_BY" VARCHAR2(50),
"CREATE_TIME" TIMESTAMP (6),
"UPDATE_BY" VARCHAR2(50),
"UPDATE_TIME" TIMESTAMP (6)
   )  ;
ALTER TABLE jimu_report_data_source ADD (connect_times integer);
COMMENT ON COLUMN jimu_report_data_source.connect_times IS '连接失败次数';  

CREATE TABLE "JIMU_REPORT_DB"
   ( "ID" VARCHAR2(36),
"JIMU_REPORT_ID" VARCHAR2(32),
"CREATE_BY" VARCHAR2(50),
"UPDATE_BY" VARCHAR2(50),
"CREATE_TIME" TIMESTAMP (6),
"UPDATE_TIME" TIMESTAMP (6),
"DB_CODE" VARCHAR2(32),
"DB_CH_NAME" VARCHAR2(50),
"DB_TYPE" VARCHAR2(32),
"DB_TABLE_NAME" VARCHAR2(32),
"DB_DYN_SQL" VARCHAR2(4000),
"DB_KEY" VARCHAR2(32),
"TB_DB_KEY" VARCHAR2(32),
"TB_DB_TABLE_NAME" VARCHAR2(32),
"JAVA_TYPE" VARCHAR2(32),
"JAVA_VALUE" VARCHAR2(255),
"API_URL" VARCHAR2(255),
"API_METHOD" VARCHAR2(255),
"IS_LIST" NUMBER(10,0),
"IS_PAGE" VARCHAR2(10),
"DB_SOURCE" VARCHAR2(255),
"DB_SOURCE_TYPE" VARCHAR2(50)
   )  ;
ALTER TABLE jimu_report_db ADD (api_convert varchar2(255));
COMMENT ON COLUMN jimu_report_db.api_convert IS 'api转换器';  

CREATE TABLE "JIMU_REPORT_DB_FIELD"
   ( "ID" VARCHAR2(36),
"CREATE_BY" VARCHAR2(50),
"CREATE_TIME" TIMESTAMP (6),
"UPDATE_BY" VARCHAR2(50),
"UPDATE_TIME" TIMESTAMP (6),
"JIMU_REPORT_DB_ID" VARCHAR2(32),
"FIELD_NAME" VARCHAR2(80),
"FIELD_TEXT" VARCHAR2(50),
"WIDGET_TYPE" VARCHAR2(50),
"WIDGET_WIDTH" NUMBER(10,0),
"ORDER_NUM" NUMBER(10,0),
"SEARCH_FLAG" NUMBER(10,0),
"SEARCH_MODE" NUMBER(10,0),
"DICT_CODE" VARCHAR2(255)
   )   ;
ALTER TABLE jimu_report_db_field ADD (search_format varchar2(50));
COMMENT ON COLUMN jimu_report_db_field.search_format IS '查询时间格式化表达式';

ALTER TABLE jimu_report_db_field ADD (ext_json nclob);
COMMENT ON COLUMN jimu_report_db_field.ext_json IS '参数配置';  

CREATE TABLE "JIMU_REPORT_DB_PARAM"
   ( "ID" VARCHAR2(36),
"JIMU_REPORT_HEAD_ID" VARCHAR2(36),
"PARAM_NAME" VARCHAR2(32),
"PARAM_TXT" VARCHAR2(32),
"PARAM_VALUE" VARCHAR2(32),
"ORDER_NUM" NUMBER(10,0),
"CREATE_BY" VARCHAR2(50),
"CREATE_TIME" TIMESTAMP (6),
"UPDATE_BY" VARCHAR2(50),
"UPDATE_TIME" TIMESTAMP (6)
   )  ;

ALTER TABLE jimu_report_db_param ADD (search_flag NUMBER(1));
COMMENT ON COLUMN jimu_report_db_param.search_flag IS '查询标识0否1是 默认0';

ALTER TABLE jimu_report_db_param ADD (widget_type varchar2(50));
COMMENT ON COLUMN jimu_report_db_param.widget_type IS '查询控件类型';

ALTER TABLE jimu_report_db_param ADD (search_mode NUMBER(1));
COMMENT ON COLUMN jimu_report_db_param.search_mode IS '查询模式1简单2范围';

ALTER TABLE jimu_report_db_param ADD (dict_code varchar2(255));
COMMENT ON COLUMN jimu_report_db_param.dict_code IS '字典';

ALTER TABLE jimu_report_db_param ADD (search_format varchar2(50));
COMMENT ON COLUMN jimu_report_db_param.search_format IS '查询时间格式化表达式';

ALTER TABLE jimu_report_db_param ADD (ext_json nclob);
COMMENT ON COLUMN jimu_report_db_param.ext_json IS '参数配置';



ALTER TABLE jimu_report_link ADD (link_chart_id varchar2(50));
COMMENT ON COLUMN jimu_report_link.link_chart_id IS '联动图表的ID';

ALTER TABLE jimu_report_link ADD (expression varchar2(255));
COMMENT ON COLUMN jimu_report_link.expression IS '表达式';

ALTER TABLE jimu_report_link ADD (requirement varchar2(255));
COMMENT ON COLUMN jimu_report_link.requirement IS '条件';

CREATE TABLE "JIMU_REPORT_MAP"
   ( "ID" VARCHAR2(64),
"LABEL" VARCHAR2(125),
"NAME" VARCHAR2(125),
"data" CLOB,
"CREATE_BY" VARCHAR2(32),
"CREATE_TIME" TIMESTAMP (6),
"UPDATE_BY" VARCHAR2(32),
"UPDATE_TIME" TIMESTAMP (6),
"DEL_FLAG" VARCHAR2(1),
"SYS_ORG_CODE" VARCHAR2(64)
   ) ;  
  
CREATE TABLE JIMU_REPORT_SHARE (
ID VARCHAR2(32),
REPORT_ID VARCHAR2(32),
PREVIEW_URL VARCHAR2(1000),
PREVIEW_LOCK VARCHAR2(4),
LAST_UPDATE_TIME DATE,
TERM_OF_VALIDITY VARCHAR2(1),
STATUS VARCHAR2(1)
);
COMMENT ON COLUMN JIMU_REPORT_SHARE.report_id IS '在线excel设计器id';
COMMENT ON COLUMN JIMU_REPORT_SHARE.preview_url IS '预览地址';
COMMENT ON COLUMN JIMU_REPORT_SHARE.preview_lock IS '密码锁';
COMMENT ON COLUMN JIMU_REPORT_SHARE.last_update_time IS '最后更新时间';
COMMENT ON COLUMN JIMU_REPORT_SHARE.term_of_validity IS '有效期(0:永久有效，1:1天，2:7天)';
COMMENT ON COLUMN JIMU_REPORT_SHARE.status IS '是否过期(0未过期，1已过期)';