summaryrefslogtreecommitdiffstats
path: root/upgrades/dbpatches/1.3/postgresql/patch/screens.sql
blob: f3c4207426e7083cb65c77bfe93894bc29be172e (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)
);

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