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


1
2
3
4
5
6
7
8
9
10

CREATE TABLE groups_tmp (
	groupid		bigint DEFAULT '0'	NOT NULL,
	name		varchar(64)		DEFAULT ''	NOT NULL,
	PRIMARY KEY (groupid)
);
CREATE INDEX groups_1 on groups_tmp (name);

insert into groups_tmp select * from groups;
drop table groups;
alter table groups_tmp rename to groups;