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