1 CREATE TABLE Attributes (
3 Name VARCHAR(255) DEFAULT '' NOT NULL,
4 Description VARCHAR(255) DEFAULT NULL,
6 ContentType VARCHAR(16),
7 ObjectType VARCHAR(25) NOT NULL,
8 ObjectId INTEGER DEFAULT 0 NOT NULL,
9 Creator INTEGER DEFAULT 0 NOT NULL,
10 Created DATETIME YEAR TO SECOND,
11 LastUpdatedBy INTEGER DEFAULT 0 NOT NULL,
12 LastUpdated DATETIME YEAR TO SECOND,
16 CREATE INDEX Attributes1 on Attributes(Name);
17 CREATE INDEX Attributes2 on Attributes(ObjectType, ObjectId);