summaryrefslogtreecommitdiffstats
path: root/upgrades/dbpatches/1.4/postgresql/patch/help_items.sql
blob: 87d2965950e23d6701e1c1cb7913e2bd8184b37c (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_)
) with OIDS;

insert into help_items_tmp select * from help_items;
drop table help_items;
alter table help_items_tmp rename to help_items;