From 89e9b7ee6e68f6fd2a6535039ef708828a346bdd Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Thu, 30 Aug 2012 22:26:37 +0800 Subject: [PATCH] DataObjects/core.sql --- DataObjects/core.sql | 9 ++++++--- 1 file changed, 6 insertions(+), 3 deletions(-) diff --git a/DataObjects/core.sql b/DataObjects/core.sql index 06db0289..2fe61469 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -106,12 +106,15 @@ ALTER TABLE core_event_audit ADD COLUMN old_audit_id int(11) NOT NULL DEF ALTER TABLE core_event_audit ADD COLUMN newvalue BLOB NOT NULL DEFAULT ''; ALTER TABLE core_event_audit ADD INDEX lookup(event_id, name, old_audit_id); -CREATE TABLE Group_Members ( +RENAME TABLE Group_Members group_members; +CREATE TABLE group_members ( id int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (id) ); -ALTER TABLE Group_Members ADD COLUMN group_id int(11) default NULL; -ALTER TABLE Group_Members ADD COLUMN user_id int(11) NOT NULL default 0; +ALTER TABLE group_members ADD COLUMN group_id int(11) default NULL; +ALTER TABLE group_members ADD COLUMN user_id int(11) NOT NULL default 0; + + CREATE TABLE Group_Rights ( id int(11) NOT NULL AUTO_INCREMENT, -- 2.39.2