diff options
Diffstat (limited to 'upgrades/dbpatches/1.4/postgresql/patch/hosts_templates.sql')
| -rw-r--r-- | upgrades/dbpatches/1.4/postgresql/patch/hosts_templates.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/upgrades/dbpatches/1.4/postgresql/patch/hosts_templates.sql b/upgrades/dbpatches/1.4/postgresql/patch/hosts_templates.sql index fa1cb9a2..02ef63d6 100644 --- a/upgrades/dbpatches/1.4/postgresql/patch/hosts_templates.sql +++ b/upgrades/dbpatches/1.4/postgresql/patch/hosts_templates.sql @@ -4,7 +4,7 @@ CREATE TABLE hosts_templates_tmp ( templateid bigint DEFAULT '0' NOT NULL, PRIMARY KEY (hosttemplateid) ) with OIDS; -CREATE UNIQUE INDEX hosts_templates_1 on hosts_templates_tmp (hostid,templateid); +CREATE UNIQUE INDEX hosts_templates_tmp_1 on hosts_templates_tmp (hostid,templateid); insert into hosts_templates_tmp select NULL,hostid,templateid from hosts_templates; drop table hosts_templates; |