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
35
36
37
38
39
40
41
42
43
44
45
46
|
CREATE TABLE hosts_templates_tmp (
hosttemplateid bigint unsigned NOT NULL auto_increment,
hostid bigint unsigned DEFAULT '0' NOT NULL,
templateid bigint unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (hosttemplateid)
) ENGINE=InnoDB;
CREATE UNIQUE INDEX hosts_templates_1 on hosts_templates_tmp (hostid,templateid);
insert into hosts_templates_tmp select NULL,hostid,templateid from hosts where templateid<>0;
drop table hosts_templates;
alter table hosts_templates_tmp rename hosts_templates;
CREATE TABLE hosts_templates_tmp (
hosttemplateid bigint unsigned DEFAULT '0' NOT NULL,
hostid bigint unsigned DEFAULT '0' NOT NULL,
templateid bigint unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (hosttemplateid)
) ENGINE=InnoDB;
CREATE UNIQUE INDEX hosts_templates_1 on hosts_templates_tmp (hostid,templateid);
insert into hosts_templates_tmp select * from hosts_templates;
drop table hosts_templates;
alter table hosts_templates_tmp rename hosts_templates;
-- hosts.sql
CREATE TABLE hosts_tmp (
hostid bigint unsigned 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)
) ENGINE=InnoDB;
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 hosts;
|
