diff options
Diffstat (limited to 'upgrades/dbpatches/1.3/postgresql/patch/usrgrp.sql')
-rw-r--r-- | upgrades/dbpatches/1.3/postgresql/patch/usrgrp.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/upgrades/dbpatches/1.3/postgresql/patch/usrgrp.sql b/upgrades/dbpatches/1.3/postgresql/patch/usrgrp.sql new file mode 100644 index 00000000..b9a9b9f6 --- /dev/null +++ b/upgrades/dbpatches/1.3/postgresql/patch/usrgrp.sql @@ -0,0 +1,10 @@ +CREATE TABLE usrgrp_tmp ( + usrgrpid bigint unsigned DEFAULT '0' NOT NULL, + name varchar(64) DEFAULT '' NOT NULL, + PRIMARY KEY (usrgrpid) +) ENGINE=InnoDB; +CREATE INDEX usrgrp_1 on usrgrp_tmp (name); + +insert into usrgrp_tmp select * from usrgrp; +drop table usrgrp; +alter table usrgrp_tmp rename usrgrp; |