Upgrade to 4.2.8
[usit-rt.git] / etc / upgrade / 3.1.0 / schema.Oracle
1 CREATE SEQUENCE ATTRIBUTES_seq;
2 CREATE TABLE Attributes (
3         id                      NUMBER(11,0) PRIMARY KEY,
4         Name                    VARCHAR2(255) NOT NULL,
5         Description             VARCHAR2(255),
6         Content         CLOB,
7     ContentType VARCHAR(16),
8         ObjectType      VARCHAR2(25) NOT NULL,
9         ObjectId        NUMBER(11,0) DEFAULT 0 NOT NULL,
10         Creator                 NUMBER(11,0) DEFAULT 0 NOT NULL,
11         Created                 DATE,
12         LastUpdatedBy           NUMBER(11,0) DEFAULT 0 NOT NULL,
13         LastUpdated             DATE
14 );
15
16 CREATE INDEX Attributes1 on Attributes(Name);
17 CREATE INDEX Attributes2 on Attributes(ObjectType, ObjectId);