blob: 1dd466fa72743ab31ae705f920bda9ac50805d21 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
--- {{{ 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);
--- }}}
|