"Fossies" - the Fresh Open Source Software Archive

Member "RT-Extension-Assets-1.05/etc/schema.Pg" (24 May 2013, 1575 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_id_seq;
    2 CREATE TABLE RTxAssets (
    3     id                integer                  DEFAULT nextval('rtxassets_id_seq'),
    4     Name              varchar(255)    NOT NULL DEFAULT '',
    5     Catalog           integer         NOT NULL DEFAULT 0,
    6     Status            varchar(64)     NOT NULL DEFAULT '',
    7     Description       varchar(255)    NOT NULL DEFAULT '',
    8     Creator           integer         NOT NULL DEFAULT 0,
    9     Created           timestamp                DEFAULT NULL,
   10     LastUpdatedBy     integer         NOT NULL DEFAULT 0,
   11     LastUpdated       timestamp                DEFAULT NULL,
   12     PRIMARY KEY (id)
   13 );
   14 
   15 CREATE INDEX RTxAssetsName ON RTxAssets (LOWER(Name));
   16 CREATE INDEX RTxAssetsStatus ON RTxAssets (Status);
   17 CREATE INDEX RTxAssetsCatalog ON RTxAssets (Catalog);
   18 
   19 CREATE SEQUENCE rtxcatalogs_id_seq;
   20 CREATE TABLE RTxCatalogs (
   21     id                integer                  DEFAULT nextval('rtxcatalogs_id_seq'),
   22     Name              varchar(255)    NOT NULL DEFAULT '',
   23     Lifecycle         varchar(32)     NOT NULL DEFAULT 'assets',
   24     Description       varchar(255)    NOT NULL DEFAULT '',
   25     Disabled          integer         NOT NULL DEFAULT 0,
   26     Creator           integer         NOT NULL DEFAULT 0,
   27     Created           timestamp                DEFAULT NULL,
   28     LastUpdatedBy     integer         NOT NULL DEFAULT 0,
   29     LastUpdated       timestamp                DEFAULT NULL,
   30     PRIMARY KEY (id)
   31 );
   32 
   33 CREATE INDEX RTxCatalogsName ON RTxCatalogs (LOWER(Name));
   34 CREATE INDEX RTxCatalogsDisabled ON RTxCatalogs (Disabled);