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