blob: 9a9861d2c4d90533875cec67c352915ca1be2ffd (
plain)
1
2
3
4
5
6
7
8
9
10
11
|
CREATE TABLE autoreg_tmp (
id bigint unsigned DEFAULT '0' NOT NULL,
priority integer DEFAULT '0' NOT NULL,
pattern varchar(255) DEFAULT '' NOT NULL,
hostid bigint unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB;
insert into autoreg_tmp select * from autoreg;
drop table autoreg;
alter table autoreg_tmp rename autoreg;
|