blob: ca347713964eff8fcf2ce54f4050897f38fb34bb (
plain)
1
2
3
4
5
6
7
8
9
10
|
CREATE TABLE help_items_tmp (
itemtype integer DEFAULT '0' NOT NULL,
key_ varchar(255) DEFAULT '' NOT NULL,
description varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (itemtype,key_)
) ENGINE=InnoDB;
insert into help_items_tmp select * from help_items;
drop table help_items;
alter table help_items_tmp rename help_items;
|