"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);