summaryrefslogtreecommitdiffstats
path: root/upgrades/dbpatches/1.4/postgresql/patch/sessions.sql
blob: 7f96d1714aa3227f1c8a337a7bc1d918f030aa71 (plain)
1
2
3
4
5
6
7
8
9
10
CREATE TABLE sessions_tmp (
	sessionid	varchar(32)		DEFAULT ''	NOT NULL,
	userid		bigint DEFAULT '0'	NOT NULL,
	lastaccess	integer		DEFAULT '0'	NOT NULL,
	PRIMARY KEY (sessionid)
) with OIDS;

insert into sessions_tmp select * from sessions;
drop table sessions;
alter table sessions_tmp rename to sessions;