blob: 3a26b069a43cdc91e4e93dc3a35a4446416fc98b (
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)
) with OIDS;
insert into services_tmp select * from services;
drop table services;
alter table services_tmp rename to services;
|
