import rt 3.2.2

[freeside.git] / rt / etc / schema.Oracle

diff --git a/rt/etc/schema.Oracle b/rt/etc/schema.Oracle
index 95cfda2..9b53cf7 100644 (file)
--- 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,