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 TRIGGERSUP_CONF ADD RUNTYPE varchar2(128);

ALTER TABLE TRIGGERSUP_CONF
ADD CONSTRAINT FK_RUNTYPE
FOREIGN KEY (RUNTYPE)
REFERENCES RUNTYPE(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: r6 - 2008-08-12 - AndreHolzner
 
    • 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