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);
-RENAME TABLE Group_Members group_members;
+-- BC name..
+RENAME TABLE Group_Members TO 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;
+-- BC name..
+RENAME TABLE Group_Rights 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 '';
+ALTER TABLE group_rights CHANGE COLUMN AccessMask accessmask varchar(10) NOT NULL DEFAULT '';
);
-alter table core_enum ADD COLUMN etype varchar(32) NOT NULL DEFAULT '';
+alter table core_enum ADD COLUMN etype varchar(32) NOT NULL DEFAULT '';
alter table core_enum ADD COLUMN name varchar(255) NOT NULL DEFAULT '';
-alter table core_enum ADD COLUMN active int(2) NOT NULL DEFAULT 1;
+alter table core_enum ADD COLUMN active int(2) NOT NULL DEFAULT 1;
alter table core_enum ADD COLUMN seqid int(11) NOT NULL DEFAULT 0;
alter table core_enum ADD COLUMN seqmax int(11) NOT NULL DEFAULT 0;
+alter table core_enum ADD COLUMN display_name varchar(255) NOT NULL DEFAULT '';
alter table core_enum ADD INDEX lookup(seqid, active, name, etype);
-
+
+UPDATE core_enum SET display_name = name WHERE display_name = '';