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

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