blob: 87a1cc47fa5a2bd75ad699e339eac2647a024351 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
|
--- {{{ Attributes
CREATE TABLE Attributes (
id INTEGER PRIMARY KEY ,
Name varchar(255) NOT NULL ,
Description varchar(255) NULL ,
Content LONGTEXT NULL ,
ContentType varchar(16),
ObjectType varchar(25) NOT NULL ,
ObjectId INTEGER default 0,
Creator integer NULL ,
Created DATETIME NULL ,
LastUpdatedBy integer NULL ,
LastUpdated DATETIME NULL
) ;
CREATE INDEX Attributes1 on Attributes(Name)
CREATE INDEX Attributes2 on Attributes(ObjectType, ObjectId);
--- }}}
|
