diff options
| author | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2001-08-13 05:52:44 +0000 |
|---|---|---|
| committer | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2001-08-13 05:52:44 +0000 |
| commit | 2d42de62ddd7faf462a1f5850fa80bedeb8d48d1 (patch) | |
| tree | cafce5b4da06223b882c5208760f243258707ad7 /upgrades | |
| parent | cf2559acb311684a357fe7babdeebab265a3e820 (diff) | |
| download | zabbix-2d42de62ddd7faf462a1f5850fa80bedeb8d48d1.tar.gz zabbix-2d42de62ddd7faf462a1f5850fa80bedeb8d48d1.tar.xz zabbix-2d42de62ddd7faf462a1f5850fa80bedeb8d48d1.zip | |
One of indexes of table functions was incorrectly defined as unique.
git-svn-id: svn://svn.zabbix.com/trunk@165 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'upgrades')
| -rw-r--r-- | upgrades/dbpatches/1.0alpha8_to_1.0alpha9/mysql/patch.sql | 3 | ||||
| -rw-r--r-- | upgrades/dbpatches/1.0alpha8_to_1.0alpha9/postgresql/patch.sql | 3 |
2 files changed, 6 insertions, 0 deletions
diff --git a/upgrades/dbpatches/1.0alpha8_to_1.0alpha9/mysql/patch.sql b/upgrades/dbpatches/1.0alpha8_to_1.0alpha9/mysql/patch.sql new file mode 100644 index 00000000..37309bd5 --- /dev/null +++ b/upgrades/dbpatches/1.0alpha8_to_1.0alpha9/mysql/patch.sql @@ -0,0 +1,3 @@ +alter table functions drop index itemid; +alter table functions drop index itemidfunctionparameter; +alter table functions add index itemidfunctionparameter (itemid,function,parameter); diff --git a/upgrades/dbpatches/1.0alpha8_to_1.0alpha9/postgresql/patch.sql b/upgrades/dbpatches/1.0alpha8_to_1.0alpha9/postgresql/patch.sql new file mode 100644 index 00000000..801849b9 --- /dev/null +++ b/upgrades/dbpatches/1.0alpha8_to_1.0alpha9/postgresql/patch.sql @@ -0,0 +1,3 @@ +drop index functions_i_f_p; +drop index functions_items; +create index functions_i_f_p on functions (itemid,function,parameter); |