diff options
Diffstat (limited to 'upgrades/dbpatches/1.3/postgresql/patch/rights.sql')
| -rw-r--r-- | upgrades/dbpatches/1.3/postgresql/patch/rights.sql | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/upgrades/dbpatches/1.3/postgresql/patch/rights.sql b/upgrades/dbpatches/1.3/postgresql/patch/rights.sql new file mode 100644 index 00000000..d009ecf2 --- /dev/null +++ b/upgrades/dbpatches/1.3/postgresql/patch/rights.sql @@ -0,0 +1,13 @@ +CREATE TABLE rights_tmp ( + rightid bigint unsigned DEFAULT '0' NOT NULL, + groupid bigint unsigned DEFAULT '0' NOT NULL, + type integer DEFAULT '0' NOT NULL, + permission integer DEFAULT '0' NOT NULL, + id bigint unsigned , + PRIMARY KEY (rightid) +) ENGINE=InnoDB; +CREATE INDEX rights_1 on rights_tmp (groupid); + +insert into rights_tmp select * from rights; +drop table rights; +alter table rights_tmp rename rights; |