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 DATA_TAKING_PERIOD
(
   PERIOD_NAME varchar2(128) PRIMARY KEY NOT NULL
);
  • adding the data taking period into the global TS configuration table:
ALTER TABLE TRIGGERSUP_CONF ADD PERIOD varchar2(128);

ALTER TABLE TRIGGERSUP_CONF
ADD CONSTRAINT FK_PERIOD
FOREIGN KEY (PERIOD)
REFERENCES DATA_TAKING_PERIOD(PERIOD_NAME) ;

-- AndreHolzner - 12 Jul 2008

Edit | Attach | Watch | Print version | History: r8 < r7 < r6 < r5 < r4 | Backlinks | Raw View | Raw edit | More topic actions...
Topic revision: r5 - 2008-08-04 - unknown
 
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    Main All webs login

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