blob: 722eb70b3557418929c9e6d88a4a6bd700b569c1 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
CREATE TABLE Attributes (
id SERIAL,
Name VARCHAR(255) DEFAULT '' NOT NULL,
Description VARCHAR(255) DEFAULT NULL,
Content BYTE,
ContentType VARCHAR(16),
ObjectType VARCHAR(25) NOT NULL,
ObjectId INTEGER DEFAULT 0 NOT NULL,
Creator INTEGER DEFAULT 0 NOT NULL,
Created DATETIME YEAR TO SECOND,
LastUpdatedBy INTEGER DEFAULT 0 NOT NULL,
LastUpdated DATETIME YEAR TO SECOND,
PRIMARY KEY (id)
);
CREATE INDEX Attributes1 on Attributes(Name);
CREATE INDEX Attributes2 on Attributes(ObjectType, ObjectId);
|
