X-Git-Url: http://git.roojs.org/?a=blobdiff_plain;f=DataObjects%2Fcore.sql;h=2fe6146941f7422a5b37385cc89fdc019f3bdae7;hb=89e9b7ee6e68f6fd2a6535039ef708828a346bdd;hp=06db02898990d31d988326f039279055da5cfeea;hpb=e0b9ac3385638553b9597588fd43becb3f4bab17;p=Pman.Core 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,