summaryrefslogtreecommitdiffstats
path: root/upgrades/dbpatches/1.4/postgresql/patch/screens.sql
blob: effc524ab413cc6c305dd7c38d55d596e8f218a4 (plain)
1
2
3
4
5
6
7
8
9
10
11
CREATE TABLE screens_tmp (
	screenid	bigint DEFAULT '0'	NOT NULL,
	name		varchar(255)		DEFAULT 'Screen'	NOT NULL,
	hsize		integer		DEFAULT '1'	NOT NULL,
	vsize		integer		DEFAULT '1'	NOT NULL,
	PRIMARY KEY (screenid)
) with OIDS;

insert into screens_tmp select * from screens;
drop table screens;
alter table screens_tmp rename to screens;