55 UPDATE {{TABLE_PREFIX}}users SET old_encryption=1; |
55 UPDATE {{TABLE_PREFIX}}users SET old_encryption=1; |
56 UPDATE {{TABLE_PREFIX}}users SET user_level=9 WHERE user_level=2; |
56 UPDATE {{TABLE_PREFIX}}users SET user_level=9 WHERE user_level=2; |
57 UPDATE {{TABLE_PREFIX}}users SET user_level=5 WHERE user_level=1; |
57 UPDATE {{TABLE_PREFIX}}users SET user_level=5 WHERE user_level=1; |
58 UPDATE {{TABLE_PREFIX}}users SET user_level=2 WHERE user_level=0; |
58 UPDATE {{TABLE_PREFIX}}users SET user_level=2 WHERE user_level=0; |
59 UPDATE {{TABLE_PREFIX}}users SET user_level=1 WHERE user_level=-1; |
59 UPDATE {{TABLE_PREFIX}}users SET user_level=1 WHERE user_level=-1; |
|
60 INSERT INTO {{TABLE_PREFIX}}acl(target_type,target_id,page_id,namespace,rules) VALUES(1,2,NULL,NULL,'read=4;post_comments=4;edit_comments=4;edit_page=4;view_source=4;mod_comments=4;history_view=4;history_rollback=4;history_rollback_extra=4;protect=4;rename=4;clear_logs=4;vote_delete=4;vote_reset=4;delete_page=4;tag_create=4;tag_delete_own=4;tag_delete_other=4;set_wiki_mode=4;password_set=4;password_reset=4;mod_misc=4;edit_cat=4;even_when_protected=4;upload_files=4;upload_new_version=4;create_page=4;php_in_pages={{ADMIN_EMBED_PHP}};edit_acl=4;'); |
60 -- Group system |
61 -- Group system |
61 CREATE TABLE {{TABLE_PREFIX}}groups( group_id mediumint(5) UNSIGNED NOT NULL auto_increment, group_name varchar(64), group_type tinyint(1) NOT NULL DEFAULT 1, PRIMARY KEY ( group_id ) ); |
62 CREATE TABLE {{TABLE_PREFIX}}groups( group_id mediumint(5) UNSIGNED NOT NULL auto_increment, group_name varchar(64), group_type tinyint(1) NOT NULL DEFAULT 1, PRIMARY KEY ( group_id ) ); |
62 CREATE TABLE {{TABLE_PREFIX}}group_members( member_id int(12) UNSIGNED NOT NULL auto_increment, group_id mediumint(5) UNSIGNED NOT NULL, user_id int(12) NOT NULL, is_mod tinyint(1) NOT NULL DEFAULT 0, pending tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY ( member_id ) ); |
63 CREATE TABLE {{TABLE_PREFIX}}group_members( member_id int(12) UNSIGNED NOT NULL auto_increment, group_id mediumint(5) UNSIGNED NOT NULL, user_id int(12) NOT NULL, is_mod tinyint(1) NOT NULL DEFAULT 0, pending tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY ( member_id ) ); |
63 INSERT INTO {{TABLE_PREFIX}}groups(group_id,group_name,group_type) VALUES(1, 'Everyone', 3),(2,'Administrators',3); |
64 INSERT INTO {{TABLE_PREFIX}}groups(group_id,group_name,group_type) VALUES(1, 'Everyone', 3),(2,'Administrators',3); |
64 -- Sidebar updates |
65 -- Sidebar updates |