diff options
Diffstat (limited to 'rt/etc/schema.Oracle')
-rw-r--r-- | rt/etc/schema.Oracle | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/rt/etc/schema.Oracle b/rt/etc/schema.Oracle index 95cfda2fd..9b53cf7ac 100644 --- a/rt/etc/schema.Oracle +++ b/rt/etc/schema.Oracle @@ -345,6 +345,25 @@ CREATE TABLE CustomFieldValues ( CREATE INDEX CustomFieldValues1 ON CustomFieldValues (CustomField); +CREATE SEQUENCE ATTRIBUTES_seq; +CREATE TABLE Attributes ( + id NUMBER(11,0) PRIMARY KEY, + Name VARCHAR2(255) NOT NULL, + Description VARCHAR2(255), + Content CLOB, + ContentType VARCHAR(16), + ObjectType VARCHAR2(25) NOT NULL, + ObjectId NUMBER(11,0) DEFAULT 0 NOT NULL, + Creator NUMBER(11,0) DEFAULT 0 NOT NULL, + Created DATE, + LastUpdatedBy NUMBER(11,0) DEFAULT 0 NOT NULL, + LastUpdated DATE +); + +CREATE INDEX Attributes1 on Attributes(Name); +CREATE INDEX Attributes2 on Attributes(ObjectType, ObjectId); + + CREATE TABLE sessions ( id VARCHAR2(32) CONSTRAINT Sessions_Key PRIMARY KEY, |