05-10-2011 07:06 AM
create table ACT_RU_EXECUTION (
ID_ varchar(64) not null,
REV_ integer,
PROC_INST_ID_ varchar(64),
BUSINESS_KEY_ varchar(255),
PARENT_ID_ varchar(64),
PROC_DEF_ID_ varchar(64),
SUPER_EXEC_ varchar(64),
ACT_ID_ varchar(255),
IS_ACTIVE_ smallint check(IS_ACTIVE_ in (1,0)),
IS_CONCURRENT_ smallint check(IS_CONCURRENT_ in (1,0)),
IS_SCOPE_ smallint check(IS_SCOPE_ in (1,0)),
UNI_BUSINESS_KEY varchar (255) not null generated always as (case when "BUSINESS_KEY_" is null then "ID_" else "BUSINESS_KEY_" end),
UNI_PROC_DEF_ID varchar (64) not null generated always as (case when "PROC_DEF_ID_" is null then "ID_" else "PROC_DEF_ID_" end),
primary key (ID_)
);
05-12-2011 02:56 AM
05-16-2011 11:49 PM
create unique where not null index ACT_UNIQ_RU_BUS_KEY on ACT_RU_EXECUTION(PROC_DEF_ID_, BUSINESS_KEY_);
05-19-2011 08:24 AM
insert into ACT_ID_USER (ID_, REV_, FIRST_, LAST_, EMAIL_, PWD_)
values (
#{id ,jdbcType=VARCHAR},
1,
#{firstName ,jdbcType=VARCHAR},
#{lastName ,jdbcType=VARCHAR},
#{email ,jdbcType=VARCHAR},
#{password ,jdbcType=VARCHAR}
)
insert into ACT_ID_USER (ID_, REV_, FIRST_, LAST_, EMAIL_, PWD_)
values ( #{id ,jdbcType=VARCHAR}, 1, #{firstName ,jdbcType=VARCHAR}, #{lastName ,jdbcType=VARCHAR}, #{email ,jdbcType=VARCHAR}, #{password ,jdbcType=VARCHAR} )
05-29-2013 11:58 AM
05-31-2013 03:27 AM
01-14-2014 02:35 PM
01-14-2014 03:41 PM
Tags
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.