summaryrefslogtreecommitdiffstats
path: root/upgrades/dbpatches/1.3/postgresql/patch/groups.sql
diff options
context:
space:
mode:
Diffstat (limited to 'upgrades/dbpatches/1.3/postgresql/patch/groups.sql')
-rw-r--r--upgrades/dbpatches/1.3/postgresql/patch/groups.sql6
1 files changed, 3 insertions, 3 deletions
diff --git a/upgrades/dbpatches/1.3/postgresql/patch/groups.sql b/upgrades/dbpatches/1.3/postgresql/patch/groups.sql
index 87ad39b2..8a94be71 100644
--- a/upgrades/dbpatches/1.3/postgresql/patch/groups.sql
+++ b/upgrades/dbpatches/1.3/postgresql/patch/groups.sql
@@ -1,10 +1,10 @@
CREATE TABLE groups_tmp (
- groupid bigint unsigned DEFAULT '0' NOT NULL,
+ groupid bigint 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;
+alter table groups_tmp rename to groups;