diff options
| author | ivan <ivan> | 2005-10-15 09:11:20 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2005-10-15 09:11:20 +0000 |
| commit | d4d0590bef31071e8809ec046717444b95b3f30a (patch) | |
| tree | ee1236da50578390d2642114f28eaed99a5efb18 /rt/etc/upgrade/3.1.0 | |
| parent | d39d52aac8f38ea9115628039f0df5aa3ac826de (diff) | |
import rt 3.4.4
Diffstat (limited to 'rt/etc/upgrade/3.1.0')
| -rwxr-xr-x | rt/etc/upgrade/3.1.0/schema.Pg | 2 | ||||
| -rw-r--r-- | rt/etc/upgrade/3.1.0/schema.SQLite | 3 |
2 files changed, 3 insertions, 2 deletions
diff --git a/rt/etc/upgrade/3.1.0/schema.Pg b/rt/etc/upgrade/3.1.0/schema.Pg index 67ea73827..94c3fe70d 100755 --- a/rt/etc/upgrade/3.1.0/schema.Pg +++ b/rt/etc/upgrade/3.1.0/schema.Pg @@ -9,7 +9,7 @@ CREATE TABLE Attributes ( Content text, ContentType varchar(16), ObjectType varchar(64), - ObjectId integer, -- foreign key to anything + ObjectId integer, Creator integer NOT NULL DEFAULT 0 , Created TIMESTAMP NULL , LastUpdatedBy integer NOT NULL DEFAULT 0 , diff --git a/rt/etc/upgrade/3.1.0/schema.SQLite b/rt/etc/upgrade/3.1.0/schema.SQLite index 87a1cc47f..1dd466fa7 100644 --- a/rt/etc/upgrade/3.1.0/schema.SQLite +++ b/rt/etc/upgrade/3.1.0/schema.SQLite @@ -13,7 +13,8 @@ CREATE TABLE Attributes ( LastUpdated DATETIME NULL ) ; -CREATE INDEX Attributes1 on Attributes(Name) + +CREATE INDEX Attributes1 on Attributes(Name); CREATE INDEX Attributes2 on Attributes(ObjectType, ObjectId); --- }}} |