summaryrefslogtreecommitdiff
path: root/rt/etc/upgrade/3.1.0/schema.SQLite
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);

--- }}}