1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
|
CREATE TABLE hosts_templates_tmp (
hosttemplateid bigint DEFAULT '0' NOT NULL,
hostid bigint DEFAULT '0' NOT NULL,
templateid bigint DEFAULT '0' NOT NULL,
PRIMARY KEY (hosttemplateid)
) with OIDS;
CREATE UNIQUE INDEX hosts_templates_tmp_1 on hosts_templates_tmp (hostid,templateid);
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;
-- hosts
CREATE TABLE hosts_tmp (
hostid bigint DEFAULT '0' NOT NULL,
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 INDEX hosts_1 on hosts_tmp (host);
CREATE INDEX hosts_2 on hosts_tmp (status);
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;
|
