X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=rt%2Fetc%2Fupgrade%2F3.1.0%2Fschema.mysql;h=e4f02c278c68a845ab6d93ad00197104a5e524d4;hb=43a06151e47d2c59b833cbd8c26d97865ee850b6;hp=c4a345d3e003094da51abd2acc241a259177cf1e;hpb=6587f6ba7d047ddc1686c080090afe7d53365bd4;p=freeside.git diff --git a/rt/etc/upgrade/3.1.0/schema.mysql b/rt/etc/upgrade/3.1.0/schema.mysql index c4a345d3e..e4f02c278 100755 --- a/rt/etc/upgrade/3.1.0/schema.mysql +++ b/rt/etc/upgrade/3.1.0/schema.mysql @@ -1,4 +1,3 @@ -# {{{ Attributes CREATE TABLE Attributes ( id INTEGER NOT NULL AUTO_INCREMENT, @@ -13,9 +12,8 @@ CREATE TABLE Attributes ( LastUpdatedBy integer NOT NULL DEFAULT 0 , LastUpdated DATETIME NULL , PRIMARY KEY (id) -) TYPE=InnoDB; +) ENGINE=InnoDB; CREATE INDEX Attributes1 on Attributes(Name); CREATE INDEX Attributes2 on Attributes(ObjectType, ObjectId); -# }}}