Upgrade 4.0.17 clean.
[usit-rt.git] / etc / upgrade / 3.1.0 / schema.Oracle
CommitLineData
01e3b242
MKG
1CREATE SEQUENCE ATTRIBUTES_seq;
2CREATE 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
16CREATE INDEX Attributes1 on Attributes(Name);
17CREATE INDEX Attributes2 on Attributes(ObjectType, ObjectId);