2 CREATE TABLE Attributes (
3 id INTEGER PRIMARY KEY ,
4 Name varchar(255) NOT NULL ,
5 Description varchar(255) NULL ,
6 Content LONGTEXT NULL ,
7 ContentType varchar(16),
8 ObjectType varchar(25) NOT NULL ,
9 ObjectId INTEGER default 0,
10 Creator integer NULL ,
11 Created DATETIME NULL ,
12 LastUpdatedBy integer NULL ,
13 LastUpdated DATETIME NULL
17 CREATE INDEX Attributes1 on Attributes(Name);
18 CREATE INDEX Attributes2 on Attributes(ObjectType, ObjectId);