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