upgrades/dbpatches/1.3/postgresql/patch/rights.sql


1
2
3
4
5
6
7
8
9
10
11
12
13

CREATE TABLE rights_tmp (
	rightid		bigint DEFAULT '0'	NOT NULL,
	groupid		bigint DEFAULT '0'	NOT NULL,
	type		integer		DEFAULT '0'	NOT NULL,
	permission	integer		DEFAULT '0'	NOT NULL,
	id		bigint,
	PRIMARY KEY (rightid)
);
CREATE INDEX rights_1 on rights_tmp (groupid);

--insert into rights_tmp select rightid,groupid,type::integer,permission,id from rights;
drop table rights;
alter table rights_tmp rename to rights;