diff options
Diffstat (limited to 'upgrades/dbpatches/1.3/mysql/patch/history_uint.sql')
-rw-r--r-- | upgrades/dbpatches/1.3/mysql/patch/history_uint.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/upgrades/dbpatches/1.3/mysql/patch/history_uint.sql b/upgrades/dbpatches/1.3/mysql/patch/history_uint.sql index aa65ae28..1b451a73 100644 --- a/upgrades/dbpatches/1.3/mysql/patch/history_uint.sql +++ b/upgrades/dbpatches/1.3/mysql/patch/history_uint.sql @@ -2,7 +2,7 @@ CREATE TABLE history_uint_tmp ( itemid bigint unsigned DEFAULT '0' NOT NULL, clock integer DEFAULT '0' NOT NULL, value bigint unsigned DEFAULT '0' NOT NULL -); +) ENGINE=InnoDB; CREATE INDEX history_uint_1 on history_uint_tmp (itemid,clock); insert into history_uint_tmp select * from history_uint; |