blob: 457d6ffb762f2174c4efa2597d260264b2b8254c (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
|
CREATE TABLE hosts_groups_tmp (
hostgroupid bigint unsigned NOT NULL auto_increment,
hostid bigint unsigned DEFAULT '0' NOT NULL,
groupid bigint unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (hostgroupid)
) ENGINE=InnoDB;
CREATE INDEX hosts_groups_groups_1 on hosts_groups_tmp (hostid,groupid);
insert into hosts_groups_tmp select NULL,hostid,groupid from hosts_groups;
drop table hosts_groups;
alter table hosts_groups_tmp rename hosts_groups;
CREATE TABLE hosts_groups_tmp (
hostgroupid bigint unsigned DEFAULT '0' NOT NULL,
hostid bigint unsigned DEFAULT '0' NOT NULL,
groupid bigint unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (hostgroupid)
) ENGINE=InnoDB;
CREATE INDEX hosts_groups_groups_1 on hosts_groups_tmp (hostid,groupid);
insert into hosts_groups_tmp select * from hosts_groups;
drop table hosts_groups;
alter table hosts_groups_tmp rename hosts_groups;
|
