Comment:
Migration of unmigrated content due to installation of a new plugin
Section
Column
width
33%
Groups
Wiki Markup
{float:left|width=200px|background=lightgrey|border=solid blue 2px|margin=1px|padding=0px}
{children:page=Rator DB ER Diagram Navigator|depth=1|excerpt=trueindent=1px}
{float}
Column
width
33%
WF_GROUP_OBJECT_DEF
Col #
Column Name
Data Type
Field Length
Not Null?
Data Def.
Comments
1
ID
NUMBER
22
N
Primary key
2
WF_GROUP_DEF_ID
NUMBER
22
N
3
WF_OBJECT_DEF_ID
NUMBER
22
N
4
WF_OBJECT_DEF_TYPE
VARCHAR2
40
N
Code Block
language
sql
alter table wf_group_object_def add version_start number default 0 not null;
alter table wf_group_object_def add version_end number default 0;
alter table wf_group_object_def add constraint group_object_def_chk_version CHECK (nvl(version_start, 0)>=0
AND (nvl(version_end,version_start)>=version_start OR nvl(version_end,0)=0));
declare
lsql varchar2(1000);
lcons_name varchar2(100);
begin
-- Drop a primary key constraint for a given table
-- This script needs to be run as a rator user. Also, please be aware that data dictionaries are case sensitive,
-- ie. uppercase table name
select constraint_name into lcons_name from user_constraints where TABLE_NAME = 'WF_GROUP_OBJECT_DEF' and
constraint_type = 'P';
lsql := 'alter table wf_group_object_def drop constraint ' || lcons_name || ' cascade drop index';
dbms_output.put_line(lsql);
execute immediate lsql;
end;
Code Block
language
sql
alter table wf_group_object_def add constraint wf_group_object_id_version_pk primary key(id,version_start);
alter table wf_group_object_def add constraint wf_group_object_id_versionEnd unique(id, version_end);
alter table wf_group_def add version_start number default 0 not null;
alter table wf_group_def add version_end number default 0;
alter table wf_group_def add constraint wf_group_def_chk_version CHECK (nvl(version_start, 0)>=0 AND
(nvl(version_end,version_start)>=version_start OR nvl(version_end,0)=0));
declare
lsql varchar2(1000);
lcons_name varchar2(100);
begin
-- Drop a primary key constraint for a given table
-- This script needs to be run as a rator user. Also, please be aware that data dictionaries are case sensitive,
-- ie. uppercase table name
select constraint_name into lcons_name from user_constraints where TABLE_NAME = 'WF_GROUP_DEF' and
constraint_type = 'P';
lsql := 'alter table wf_group_def drop constraint ' || lcons_name || ' cascade drop index';
dbms_output.put_line(lsql);
execute immediate lsql;
end;