blob: 718279c5bbd73871885ce13446418a6caf487a5a (
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_)
);
insert into help_items_tmp select * from help_items;
drop table help_items;
alter table help_items_tmp rename help_items;
|