summaryrefslogtreecommitdiffstats
path: root/upgrades/dbpatches
diff options
context:
space:
mode:
authoralex <alex@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2007-03-26 16:49:03 +0000
committeralex <alex@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2007-03-26 16:49:03 +0000
commit9c1c47f8e0f724fa887f6f4949374acf2022eb4e (patch)
tree205e493cc19c75697be8199b4dc4a5dec6ace897 /upgrades/dbpatches
parent7cd552914e890df489dfe4032ed79f0841db96ff (diff)
downloadzabbix-9c1c47f8e0f724fa887f6f4949374acf2022eb4e.tar.gz
zabbix-9c1c47f8e0f724fa887f6f4949374acf2022eb4e.tar.xz
zabbix-9c1c47f8e0f724fa887f6f4949374acf2022eb4e.zip
Minor fixes.
git-svn-id: svn://svn.zabbix.com/trunk@3931 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'upgrades/dbpatches')
-rw-r--r--upgrades/dbpatches/1.3/mysql/patch/events.sql2
-rw-r--r--upgrades/dbpatches/1.3/postgresql/patch/events.sql2
2 files changed, 2 insertions, 2 deletions
diff --git a/upgrades/dbpatches/1.3/mysql/patch/events.sql b/upgrades/dbpatches/1.3/mysql/patch/events.sql
index ff2036d6..14bc669f 100644
--- a/upgrades/dbpatches/1.3/mysql/patch/events.sql
+++ b/upgrades/dbpatches/1.3/mysql/patch/events.sql
@@ -8,7 +8,7 @@ CREATE TABLE events (
acknowledged integer DEFAULT '0' NOT NULL,
PRIMARY KEY (eventid)
) ENGINE=InnoDB;
-CREATE INDEX events_1 on events (source,object,objectid,clock);
+CREATE INDEX events_1 on events (object,objectid,clock);
CREATE INDEX events_2 on events (clock);
insert into events select alarmid,0,0,triggerid,clock,value,acknowledged from alarms;
diff --git a/upgrades/dbpatches/1.3/postgresql/patch/events.sql b/upgrades/dbpatches/1.3/postgresql/patch/events.sql
index 18b6c5ee..95ef6320 100644
--- a/upgrades/dbpatches/1.3/postgresql/patch/events.sql
+++ b/upgrades/dbpatches/1.3/postgresql/patch/events.sql
@@ -7,7 +7,7 @@ CREATE TABLE events (
acknowledged integer DEFAULT '0' NOT NULL,
PRIMARY KEY (eventid)
);
-CREATE INDEX events_1 on events (source,object,objectid,clock);
+CREATE INDEX events_1 on events (object,objectid,clock);
CREATE INDEX events_2 on events (clock);
insert into events select alarmid,0,triggerid,clock,value,acknowledged from alarms;