WF_FLOW_REG 增加4个字段 MAIN_TYPE SUB_TYPE PARENT_ID JAXB_TEXT

-- 备份 WF_FLOW_REG
drop table temp001;
create table temp001 as select * from WF_FLOW_REG;


-- 重新创建 WF_FLOW_REG

alter table WF_FLOW_BUILD
drop constraint FK_WF_FLOW__INHERITAN_WF_FLOW_;

alter table WF_FLOW_VER
drop constraint FK_WF_FLOW__INHERITAN_WF_FLOW_;

drop index "Relationship_13_FK";

drop index "Inheritance_109_FK";

drop table WF_FLOW_REG cascade constraints;

create table WF_FLOW_REG  (
DOMAIN_ID            INTEGER                         not null,
FLOW_ID              INTEGER                         not null,
FLOW_PATH            VARCHAR2(200),
FLOW_NAME            VARCHAR2(100)                   not null,
FLOW_LABEL           VARCHAR2(100)                   not null,
FUNC                 VARCHAR2(100),
MAIN_TYPE            VARCHAR2(20),
SUB_TYPE             VARCHAR2(20),
PARENT_ID            INTEGER,
JAXB_TEXT            BLOB,
ICON                 BLOB,
DEF_EDITING_VER      INTEGER,
DEF_RUNNING_VER      INTEGER,
ACTIVE_FLAG          INTEGER,
VALIDITY_PERIOD_START DATE,
VALIDITY_PERIOD_END  DATE,
NOTE                 CLOB,
constraint PK_WF_FLOW_REG primary key (DOMAIN_ID, FLOW_ID)
);

comment on table WF_FLOW_REG is
'flowID:全路径。e.g. com.bonc.test.Test01';

create index "Relationship_13_FK" on WF_FLOW_REG (
FLOW_PATH ASC
);

create index "Inheritance_109_FK" on WF_FLOW_REG (
DOMAIN_ID ASC
);


-- 恢复数据 WF_FLOW_REG
insert into wf_flow_reg
(domain_id, flow_id, flow_path, flow_name, flow_label, func, main_type, sub_type, parent_id, jaxb_text, icon, def_editing_ver, def_running_ver, active_flag, validity_period_start, validity_period_end, note)
select t.domain_id, t.flow_id, t.flow_path, t.flow_name, t.flow_label, t.func, 'M', '', 0, NULL, NULL, t.def_editing_ver, t.def_running_ver, t.active_flag, t.validity_period_start, t.validity_period_end, t.note from temp001 t;

commit;