?? informix.sql
字號:
drop table os_propertyentry;
create table OS_PROPERTYENTRY
(
ID serial primary key,
GLOBAL_KEY varchar(250),
ITEM_KEY varchar(250),
ITEM_TYPE smallint,
STRING_VALUE varchar(255),
DATE_VALUE date,
DATA_VALUE byte,
FLOAT_VALUE float,
NUMBER_VALUE decimal
);
drop table os_wfentry;
create table OS_WFENTRY
(
ID integer,
NAME varchar(60),
INITIALIZED integer,
primary key (ID)
);
drop table os_currentstep;
create table OS_CURRENTSTEP
(
ID integer,
ENTRY_ID integer,
STEP_ID integer,
ACTION_ID integer,
OWNER varchar(35),
START_DATE date,
FINISH_DATE date,
DUE_DATE date,
STATUS varchar(40),
CALLER varchar(35),
primary key (ID),
foreign key (ENTRY_ID) references OS_WFENTRY(ID)
);
-- create index os_current_entry on os_currentstep (entry_id);
create index os_current_owner on os_currentstep (owner);
create index os_current_caller on os_currentstep (caller);
drop table os_historystep;
create table OS_HISTORYSTEP
(
ID integer,
ENTRY_ID integer,
STEP_ID integer,
ACTION_ID integer,
OWNER varchar(35),
START_DATE date,
FINISH_DATE date,
DUE_DATE date,
STATUS varchar(40),
CALLER varchar(35),
primary key (ID),
foreign key (ENTRY_ID) references OS_WFENTRY(ID)
);
-- create index os_history_entry on os_historystep (entry_id);
create index os_history_owner on os_historystep (owner);
create index os_history_caller on os_historystep (caller);
drop table OS_CURSTEP_PREV;
create table OS_CURSTEP_PREV
(
ID integer,
PREVIOUS_ID integer,
primary key (ID, PREVIOUS_ID),
foreign key (ID) references OS_CURRENTSTEP(ID),
foreign key (PREVIOUS_ID) references OS_HISTORYSTEP(ID)
);
-- create index os_curstep_prev on os_curstep_prev (previous_id);
create table OS_HISTSTEP_PREV
(
ID integer,
PREVIOUS_ID integer,
primary key (ID, PREVIOUS_ID),
foreign key (ID) references OS_HISTORYSTEP(ID),
foreign key (PREVIOUS_ID) references OS_HISTORYSTEP(ID)
);
-- create index os_historystep_previous on os_historystep_prev (previous_id);
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -