JSPGui (L1 trigger key configurator)
Runregistry
YUI
ORACLE database
CREATE SEQUENCE global_key_seq
MINVALUE 1
START WITH 1
INCREMENT BY 1
NOCACHE
;
- creating the data taking period table:
CREATE TABLE RUNTYPE
(
NAME varchar2(128) PRIMARY KEY NOT NULL
);
- adding the data taking period into the global TS configuration table:
ALTER TABLE CMS_TRG_L1_CONF.TRIGGERSUP_CONF ADD RUNTYPE varchar2(128);
ALTER TABLE CMS_TRG_L1_CONF.TRIGGERSUP_CONF
ADD CONSTRAINT FK_RUNTYPE
FOREIGN KEY (RUNTYPE)
REFERENCES RUNTYPE(NAME) ;
- adding the column LAST_MADE_CURRENT_DATE:
ALTER TABLE CMS_TRG_L1_CONF.TRIGGERSUP_CONF ADD (LAST_MADE_CURRENT_DATE timestamp default NULL);
--
AndreHolzner - 12 Jul 2008