From bb9c5eefae5cf0cd38bb4b663b2719e35e74b873 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Thu, 30 Aug 2012 22:30:11 +0800 Subject: [PATCH] DataObjects/core.sql --- DataObjects/core.sql | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/DataObjects/core.sql b/DataObjects/core.sql index c46c0561..6171a190 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -120,13 +120,13 @@ ALTER TABLE group_members ADD COLUMN user_id int(11) NOT NULL default 0; RENAME TABLE Group_Members TO group_rights; -CREATE TABLE 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 ''; +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