summaryrefslogtreecommitdiffstats
path: root/upgrades/dbpatches/1.3/mysql/patch/history_uint.sql
diff options
context:
space:
mode:
authoralex <alex@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2007-02-01 14:46:14 +0000
committeralex <alex@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2007-02-01 14:46:14 +0000
commitc516c57fc707c8078edc2938b35e1bc5934637d3 (patch)
treec7649a7e09bd38878fed72af317a67dcdaf74a80 /upgrades/dbpatches/1.3/mysql/patch/history_uint.sql
parent8d6e9646fb189323340a61e6dcf614ee4b1bc43b (diff)
downloadzabbix-c516c57fc707c8078edc2938b35e1bc5934637d3.tar.gz
zabbix-c516c57fc707c8078edc2938b35e1bc5934637d3.tar.xz
zabbix-c516c57fc707c8078edc2938b35e1bc5934637d3.zip
Improvements of WEB monitoring and MySQL upgrade patches.
git-svn-id: svn://svn.zabbix.com/trunk@3784 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'upgrades/dbpatches/1.3/mysql/patch/history_uint.sql')
-rw-r--r--upgrades/dbpatches/1.3/mysql/patch/history_uint.sql2
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;