4 -- IF you are working on an old system... - copy the changes to Groups.sql...
6 CREATE TABLE core_group (
7 id int(11) NOT NULL auto_increment,
11 ALTER TABLE core_group ADD COLUMN name varchar(128) NOT NULL DEFAULT '';
12 ALTER TABLE core_group ADD COLUMN display_name varchar(128) NOT NULL DEFAULT '';
13 ALTER TABLE core_group ADD COLUMN type int(11) NOT NULL DEFAULT 0;
14 ALTER TABLE core_group ADD COLUMN leader int(11) NOT NULL default 0;
15 ALTER TABLE core_group ADD COLUMN is_system int(2) NOT NULL default 0;
17 UPDATE core_group SET display_name = name WHERE display_name = '';
18 UPDATE core_group SET is_system = 1 WHERE name = 'Administrators';
20 ALTER TABLE core_group ADD INDEX lookup_leader (leader);