"Fossies" - the Fresh Open Source Software Archive

Member "RT-Extension-Assets-1.05/etc/schema.Oracle" (24 May 2013, 1287 Bytes) of package /linux/misc/RT-Extension-Assets-1.05.tar.gz:


As a special service "Fossies" has tried to format the requested text file into HTML format (style: standard) with prefixed line numbers. Alternatively you can here view or download the uninterpreted source code file.

    1 CREATE SEQUENCE RTxAssets_seq;
    2 CREATE TABLE RTxAssets (
    3     id              NUMBER(11,0)    CONSTRAINT RTxAssets_key PRIMARY KEY,
    4     Name            varchar2(255)   DEFAULT '',
    5     Catalog         NUMBER(11,0)    DEFAULT 0 NOT NULL,
    6     Status          varchar2(64)    DEFAULT '',
    7     Description     varchar2(255)   DEFAULT '',
    8     Creator         NUMBER(11,0)    DEFAULT 0 NOT NULL,
    9     Created         DATE,
   10     LastUpdatedBy   NUMBER(11,0)    DEFAULT 0 NOT NULL,
   11     LastUpdated     DATE
   12 );
   13 
   14 CREATE INDEX RTxAssetsName ON RTxAssets (LOWER(Name));
   15 CREATE INDEX RTxAssetsStatus ON RTxAssets (Status);
   16 CREATE INDEX RTxAssetsCatalog ON RTxAssets (Catalog);
   17 
   18 CREATE SEQUENCE RTxCatalogs_seq;
   19 CREATE TABLE RTxCatalogs (
   20     id              NUMBER(11,0)    CONSTRAINT RTxCatalogs_key PRIMARY KEY,
   21     Name            varchar2(255)   DEFAULT '',
   22     Lifecycle       varchar2(32)    DEFAULT 'assets',
   23     Description     varchar2(255)   DEFAULT '',
   24     Disabled        NUMBER(11,0)    DEFAULT 0 NOT NULL,
   25     Creator         NUMBER(11,0)    DEFAULT 0 NOT NULL,
   26     Created         DATE,
   27     LastUpdatedBy   NUMBER(11,0)    DEFAULT 0 NOT NULL,
   28     LastUpdated     DATE
   29 );
   30 
   31 CREATE INDEX RTxCatalogsName ON RTxCatalogs (LOWER(Name));
   32 CREATE INDEX RTxCatalogsDisabled ON RTxCatalogs (Disabled);