"Fossies" - the Fresh Open Source Software Archive

Member "RT-Extension-Assets-1.05/etc/schema.mysql" (24 May 2013, 1517 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 TABLE RTxAssets (
    2     id                int(11)         NOT NULL AUTO_INCREMENT,
    3     Name              varchar(255)    NOT NULL DEFAULT '',
    4     Catalog           int(11)         NOT NULL DEFAULT 0,
    5     Status            varchar(64)     NOT NULL DEFAULT '',
    6     Description       varchar(255)    NOT NULL DEFAULT '',
    7     Creator           int(11)         NOT NULL DEFAULT 0,
    8     Created           datetime                 DEFAULT NULL,
    9     LastUpdatedBy     int(11)         NOT NULL DEFAULT 0,
   10     LastUpdated       datetime                 DEFAULT NULL,
   11     PRIMARY KEY (id)
   12 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
   13 
   14 CREATE INDEX RTxAssetsName ON RTxAssets (Name);
   15 CREATE INDEX RTxAssetsStatus ON RTxAssets (Status);
   16 CREATE INDEX RTxAssetsCatalog ON RTxAssets (Catalog);
   17 
   18 CREATE TABLE RTxCatalogs (
   19     id                int(11)         NOT NULL AUTO_INCREMENT,
   20     Name              varchar(255)    NOT NULL DEFAULT '',
   21     Lifecycle         varchar(32)     NOT NULL DEFAULT 'assets',
   22     Description       varchar(255)    NOT NULL DEFAULT '',
   23     Disabled          int2            NOT NULL DEFAULT 0,
   24     Creator           int(11)         NOT NULL DEFAULT 0,
   25     Created           datetime                 DEFAULT NULL,
   26     LastUpdatedBy     int(11)         NOT NULL DEFAULT 0,
   27     LastUpdated       datetime                 DEFAULT NULL,
   28     PRIMARY KEY (id)
   29 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
   30 
   31 CREATE INDEX RTxCatalogsName ON RTxCatalogs (Name);
   32 CREATE INDEX RTxCatalogsDisabled ON RTxCatalogs (Disabled);