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


1
2
3
4
5
6
7
8
9
10

CREATE TABLE usrgrp_tmp (
	usrgrpid	bigint DEFAULT '0'	NOT NULL,
	name		varchar(64)		DEFAULT ''	NOT NULL,
	PRIMARY KEY (usrgrpid)
);
CREATE INDEX usrgrp_1 on usrgrp_tmp (name);

insert into usrgrp_tmp select * from usrgrp;
drop table usrgrp;
alter table usrgrp_tmp rename to usrgrp;