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