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