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


This topic: Main > TWikiUsers > AndreHolzner > AndreHolznerTTC > AndreHolznerJspGui
Topic revision: r8 - 2008-09-17 - AndreHolzner
 
This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2019 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback