- fixed upgrade script to correctly process host-template linkage (Alexei)

   [svn merge -r4535:4538 svn://svn.zabbix.com/branches/1.4.2]


git-svn-id: svn://svn.zabbix.com/trunk@4539 97f52cf1-0a1b-0410-bd0e-c28be96e8082

1 files changed, 20 insertions, 9 deletions

diff --git a/upgrades/dbpatches/1.4/postgresql/patch/hosts_templates.sql b/upgrades/dbpatches/1.4/postgresql/patch/hosts_templates.sql
index 02ef63d6..a98cc764 100644
--- a/upgrades/dbpatches/1.4/postgresql/patch/hosts_templates.sql
+++ b/upgrades/dbpatches/1.4/postgresql/patch/hosts_templates.sql
@@ -6,18 +6,29 @@ CREATE TABLE hosts_templates_tmp (
 ) with OIDS;
 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;
+insert into hosts_templates_tmp select hostid,hostid,templateid from  hosts where templateid<>0;
 drop table  hosts_templates;
 alter table hosts_templates_tmp rename  to hosts_templates;
 
-CREATE TABLE hosts_templates_tmp (
-	hosttemplateid	bigint DEFAULT '0'	NOT NULL,
+-- hosts
+
+CREATE TABLE hosts_tmp (
 	hostid		bigint DEFAULT '0'	NOT NULL,
-	templateid	bigint DEFAULT '0'	NOT NULL,
-	PRIMARY KEY (hosttemplateid)
+	host		varchar(64)		DEFAULT ''	NOT NULL,
+	dns		varchar(64)		DEFAULT ''	NOT NULL,
+	useip		integer		DEFAULT '1'	NOT NULL,
+	ip		varchar(15)		DEFAULT '127.0.0.1'	NOT NULL,
+	port		integer		DEFAULT '0'	NOT NULL,
+	status		integer		DEFAULT '0'	NOT NULL,
+	disable_until	integer		DEFAULT '0'	NOT NULL,
+	error		varchar(128)		DEFAULT ''	NOT NULL,
+	available	integer		DEFAULT '0'	NOT NULL,
+	errors_from	integer		DEFAULT '0'	NOT NULL,
+	PRIMARY KEY (hostid)
 ) with OIDS;
-CREATE UNIQUE INDEX hosts_templates_1 on hosts_templates_tmp (hostid,templateid);
+CREATE INDEX hosts_1 on hosts_tmp (host);
+CREATE INDEX hosts_2 on hosts_tmp (status);
 
-insert into hosts_templates_tmp select * from  hosts_templates;
-drop table  hosts_templates;
-alter table hosts_templates_tmp rename to hosts_templates;
+insert into hosts_tmp select hostid,host,host,useip,ip,port,status,disable_until,error,available,errors_from from hosts;
+drop table hosts;
+alter table hosts_tmp rename to hosts;