blob: a05cb02485ad2f647b6c3206abd129c597f757b8 (
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 integer DEFAULT '0' NOT NULL,
PRIMARY KEY (housekeeperid)
);
insert into housekeeper_tmp select * from housekeeper;
drop table housekeeper;
alter table housekeeper_tmp rename to housekeeper;
|
