From db199e5f0bee3d2624a497c758961ce24a3a0ada Mon Sep 17 00:00:00 2001
From: Alan Knowles <alan@roojs.com>
Date: Fri, 3 Jun 2016 16:07:03 +0800
Subject: [PATCH] sql/group_rights.sql

---
 sql/group_rights.sql | 14 ++++++++++++++
 1 file changed, 14 insertions(+)
 create mode 100644 sql/group_rights.sql

diff --git a/sql/group_rights.sql b/sql/group_rights.sql
new file mode 100644
index 00000000..054deff4
--- /dev/null
+++ b/sql/group_rights.sql
@@ -0,0 +1,14 @@
+RENAME TABLE Group_Rights TO group_rights;
+
+
+CREATE TABLE  group_rights  (
+    id int(11)  NOT NULL AUTO_INCREMENT,
+    PRIMARY KEY (id)
+);
+ALTER TABLE group_rights ADD COLUMN    rightname varchar(64)  NOT NULL DEFAULT '';
+ALTER TABLE group_rights ADD COLUMN     group_id int(11) NOT NULL DEFAULT 0;
+ALTER TABLE group_rights ADD COLUMN   accessmask varchar(10)  NOT NULL DEFAULT '';
+
+#old mysql.
+ALTER TABLE group_rights CHANGE COLUMN AccessMask accessmask varchar(10)  NOT NULL DEFAULT '';
+
-- 
2.39.2