diff options
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, 2 insertions, 3 deletions
diff --git a/rt/etc/upgrade/3.1.0/schema.Pg b/rt/etc/upgrade/3.1.0/schema.Pg index 94c3fe70d..67ea73827 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, + ObjectId integer, -- foreign key to anything 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 1dd466fa7..87a1cc47f 100644 --- a/rt/etc/upgrade/3.1.0/schema.SQLite +++ b/rt/etc/upgrade/3.1.0/schema.SQLite @@ -13,8 +13,7 @@ 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); --- }}} |