blob: efafc4e5a7a65a406be089b5785c9f96a40f7ef1 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
CREATE TABLE services_tmp (
serviceid bigint DEFAULT '0' NOT NULL,
name varchar(128) DEFAULT '' NOT NULL,
status integer DEFAULT '0' NOT NULL,
algorithm integer DEFAULT '0' NOT NULL,
triggerid bigint ,
showsla integer DEFAULT '0' NOT NULL,
goodsla numeric(5,2) DEFAULT '99.9' NOT NULL,
sortorder integer DEFAULT '0' NOT NULL,
PRIMARY KEY (serviceid)
);
insert into services_tmp select * from services;
drop table services;
alter table services_tmp rename to services;
|
