blob: 0eadfb2a90cd606485fd7cd3fe9de463b667c249 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
|
CREATE TABLE services_links_tmp (
linkid bigint unsigned DEFAULT '0' NOT NULL,
serviceupid bigint unsigned DEFAULT '0' NOT NULL,
servicedownid bigint unsigned DEFAULT '0' NOT NULL,
soft integer DEFAULT '0' NOT NULL,
PRIMARY KEY (linkid)
) ENGINE=InnoDB;
CREATE INDEX services_links_links_1 on services_links_tmp (servicedownid);
CREATE UNIQUE INDEX services_links_links_2 on services_links_tmp (serviceupid,servicedownid);
insert into services_links_tmp select * from services_links;
drop table services_links;
alter table services_links_tmp rename services_links;
|
