create table T_TEMPLATEEVENT
(
ID NUMBER(16) not null,
EVENTNAME VARCHAR2(50)
);
create table T_TEMPLATE_TEMPLATEEVENT
(
ID NUMBER(16) not null,
TEMPLATEID NUMBER(16),
TEMPLATEEVENTID NUMBER(16)
);
alter table T_TEMPLATEEVENT
add constraint PK_T_TEMPLATEEVENT primary key (ID);
alter table T_TEMPLATE_TEMPLATEEVENT
add constraint PK_TEMPLATE_TEMPLATEEVENT primary key (ID);
create sequence T_TEMPLATEEVENT_SEQ
minvalue 1
maxvalue 999999999999999999999999999
start with 550
increment by 1
cache 20;
create sequence T_TEMPLATE_TEMPLATEEVENT_SEQ
minvalue 1
maxvalue 999999999999999999999999999
start with 550
increment by 1
cache 20;