blob: bd115f0875444a054550440ea19860259edee37c (
plain)
1
2
3
4
5
6
7
8
9
10
11
|
CREATE TABLE housekeeper_tmp (
housekeeperid bigint DEFAULT '0' NOT NULL,
tablename varchar(64) DEFAULT '' NOT NULL,
field varchar(64) DEFAULT '' NOT NULL,
value bigint DEFAULT '0' NOT NULL,
PRIMARY KEY (housekeeperid)
) with OIDS;
insert into housekeeper_tmp select * from housekeeper;
drop table housekeeper;
alter table housekeeper_tmp rename to housekeeper;
|
