perms_groups.sql

-- auto generated by mc8051.de
SET FOREIGN_KEY_CHECKS = 0;
-- delete existing data
TRUNCATE permission_group_commands;
TRUNCATE permission_group_rights;
TRUNCATE permission_groups;
-- clear legacy permissions for support of autocms
TRUNCATE permissions;
-- permission group Member
INSERT INTO permission_groups (id, name, description, level, prefix, prefix_color, badge, room_effect, log_enabled) VALUES ('1', 'Member', '', '1', '', '', '', '0', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_add_youtube_playlist', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_alert', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_allow_trading', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_badge', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_ban', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_block_alert', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_bots', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_bundle', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_calendar', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_changename', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_chatcolor', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_control', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_coords', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_credits', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_diagonal', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_disconnect', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_duckets', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_ejectall', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_empty', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_empty_bots', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_empty_pets', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_enable', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_event', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_faceless', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_fastwalk', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_filterword', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_freeze', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_freeze_bots', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_gift', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_give_rank', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_ha', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_hal', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_hand_item', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_happy_hour', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_hide_wired', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_invisible', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_ip_ban', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_machine_ban', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_mass_badge', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_mass_credits', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_mass_duckets', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_mass_gift', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_mass_points', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_mimic', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_moonwalk', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_multi', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_mute', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_pet_info', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_pick_all', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_points', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_promote_offer', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_pull', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_push', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_redeem', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_reload_room', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_required_custom', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_rights', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_room_alert', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_room_badge', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_room_credits', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_room_dance', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_room_duckets', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_room_effect', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_room_gift', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_room_item', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_room_kick', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_room_mute', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_room_points', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_say', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_say_all', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_set_max', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_set_poll', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_set_speed', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_shout', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_shout_all', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_shutdown', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_sitdown', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_soft_kick', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_staff_alert', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_staff_online', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_staff_summon', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_stalk', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_subscription', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_summon', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_super_ban', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_super_pull', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_take_badge', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_talk', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_teleport', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_transform', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_unban', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_unload', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_unmute', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_update_achievements', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_update_bots', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_update_catalogue', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_update_config', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_update_guildparts', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_update_hotel_view', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_update_items', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_update_navigator', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_update_permissions', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_update_pet_data', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_update_plugins', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_update_polls', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_update_texts', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_update_wordfilter', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_user_info', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('1', 'cmd_word_quiz', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('1', 'acc_ads_background', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('1', 'acc_ambassador', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('1', 'acc_anychatcolor', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('1', 'acc_anyroomowner', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('1', 'acc_calendar_force', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('1', 'acc_camera', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('1', 'acc_can_stalk', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('1', 'acc_catalog_ids', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('1', 'acc_chat_no_filter', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('1', 'acc_chat_no_flood', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('1', 'acc_chat_no_limit', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('1', 'acc_empty_others', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('1', 'acc_enable_others', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('1', 'acc_enteranyroom', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('1', 'acc_floorplan_editor', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('1', 'acc_fullrooms', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('1', 'acc_guildgate', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('1', 'acc_guild_admin', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('1', 'acc_helper_give_guide_tours', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('1', 'acc_helper_judge_chat_reviews', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('1', 'acc_helper_use_guide_tool', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('1', 'acc_hide_ip', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('1', 'acc_hide_mail', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('1', 'acc_infinite_credits', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('1', 'acc_infinite_friends', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('1', 'acc_infinite_pixels', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('1', 'acc_infinite_points', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('1', 'acc_mimic_unredeemed', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('1', 'acc_modtool_room_info', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('1', 'acc_modtool_room_logs', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('1', 'acc_modtool_ticket_q', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('1', 'acc_modtool_user_alert', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('1', 'acc_modtool_user_ban', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('1', 'acc_modtool_user_logs', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('1', 'acc_moverotate', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('1', 'acc_nomute', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('1', 'acc_not_mimiced', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('1', 'acc_no_mute', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('1', 'acc_placefurni', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('1', 'acc_see_tentchat', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('1', 'acc_see_whispers', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('1', 'acc_staff_pick', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('1', 'acc_superwired', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('1', 'acc_supporttool', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('1', 'acc_trade_anywhere', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('1', 'acc_unkickable', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('1', 'acc_unlimited_bots', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('1', 'acc_unlimited_pets', '0');
-- legacy table
INSERT INTO permissions (id, rank_name, prefix, prefix_color) VALUES ('1', 'Member', '', '');


-- permission group VIP
INSERT INTO permission_groups (id, name, description, level, prefix, prefix_color, badge, room_effect, log_enabled) VALUES ('2', 'VIP', '', '2', '', '', '', '0', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_add_youtube_playlist', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_alert', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_allow_trading', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_badge', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_ban', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_block_alert', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_bots', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_bundle', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_calendar', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_changename', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_chatcolor', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_control', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_coords', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_credits', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_diagonal', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_disconnect', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_duckets', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_ejectall', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_empty', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_empty_bots', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_empty_pets', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_enable', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_event', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_faceless', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_fastwalk', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_filterword', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_freeze', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_freeze_bots', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_gift', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_give_rank', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_ha', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_hal', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_hand_item', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_happy_hour', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_hide_wired', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_invisible', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_ip_ban', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_machine_ban', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_mass_badge', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_mass_credits', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_mass_duckets', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_mass_gift', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_mass_points', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_mimic', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_moonwalk', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_multi', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_mute', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_pet_info', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_pick_all', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_points', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_promote_offer', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_pull', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_push', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_redeem', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_reload_room', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_required_custom', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_rights', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_room_alert', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_room_badge', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_room_credits', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_room_dance', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_room_duckets', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_room_effect', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_room_gift', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_room_item', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_room_kick', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_room_mute', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_room_points', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_say', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_say_all', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_set_max', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_set_poll', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_set_speed', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_shout', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_shout_all', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_shutdown', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_sitdown', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_soft_kick', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_staff_alert', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_staff_online', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_staff_summon', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_stalk', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_subscription', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_summon', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_super_ban', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_super_pull', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_take_badge', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_talk', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_teleport', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_transform', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_unban', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_unload', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_unmute', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_update_achievements', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_update_bots', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_update_catalogue', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_update_config', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_update_guildparts', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_update_hotel_view', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_update_items', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_update_navigator', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_update_permissions', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_update_pet_data', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_update_plugins', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_update_polls', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_update_texts', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_update_wordfilter', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_user_info', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('2', 'cmd_word_quiz', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('2', 'acc_ads_background', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('2', 'acc_ambassador', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('2', 'acc_anychatcolor', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('2', 'acc_anyroomowner', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('2', 'acc_calendar_force', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('2', 'acc_camera', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('2', 'acc_can_stalk', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('2', 'acc_catalog_ids', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('2', 'acc_chat_no_filter', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('2', 'acc_chat_no_flood', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('2', 'acc_chat_no_limit', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('2', 'acc_empty_others', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('2', 'acc_enable_others', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('2', 'acc_enteranyroom', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('2', 'acc_floorplan_editor', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('2', 'acc_fullrooms', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('2', 'acc_guildgate', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('2', 'acc_guild_admin', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('2', 'acc_helper_give_guide_tours', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('2', 'acc_helper_judge_chat_reviews', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('2', 'acc_helper_use_guide_tool', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('2', 'acc_hide_ip', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('2', 'acc_hide_mail', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('2', 'acc_infinite_credits', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('2', 'acc_infinite_friends', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('2', 'acc_infinite_pixels', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('2', 'acc_infinite_points', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('2', 'acc_mimic_unredeemed', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('2', 'acc_modtool_room_info', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('2', 'acc_modtool_room_logs', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('2', 'acc_modtool_ticket_q', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('2', 'acc_modtool_user_alert', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('2', 'acc_modtool_user_ban', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('2', 'acc_modtool_user_logs', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('2', 'acc_moverotate', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('2', 'acc_nomute', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('2', 'acc_not_mimiced', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('2', 'acc_no_mute', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('2', 'acc_placefurni', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('2', 'acc_see_tentchat', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('2', 'acc_see_whispers', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('2', 'acc_staff_pick', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('2', 'acc_superwired', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('2', 'acc_supporttool', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('2', 'acc_trade_anywhere', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('2', 'acc_unkickable', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('2', 'acc_unlimited_bots', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('2', 'acc_unlimited_pets', '0');
-- legacy table
INSERT INTO permissions (id, rank_name, prefix, prefix_color) VALUES ('2', 'VIP', '', '');


-- permission group Placeholder
INSERT INTO permission_groups (id, name, description, level, prefix, prefix_color, badge, room_effect, log_enabled) VALUES ('3', 'Placeholder', '', '3', '', '', '', '0', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_add_youtube_playlist', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_alert', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_allow_trading', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_badge', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_ban', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_block_alert', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_bots', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_bundle', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_calendar', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_changename', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_chatcolor', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_control', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_coords', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_credits', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_diagonal', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_disconnect', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_duckets', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_ejectall', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_empty', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_empty_bots', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_empty_pets', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_enable', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_event', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_faceless', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_fastwalk', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_filterword', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_freeze', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_freeze_bots', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_gift', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_give_rank', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_ha', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_hal', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_hand_item', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_happy_hour', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_hide_wired', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_invisible', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_ip_ban', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_machine_ban', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_mass_badge', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_mass_credits', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_mass_duckets', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_mass_gift', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_mass_points', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_mimic', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_moonwalk', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_multi', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_mute', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_pet_info', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_pick_all', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_points', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_promote_offer', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_pull', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_push', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_redeem', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_reload_room', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_required_custom', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_rights', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_room_alert', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_room_badge', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_room_credits', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_room_dance', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_room_duckets', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_room_effect', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_room_gift', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_room_item', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_room_kick', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_room_mute', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_room_points', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_say', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_say_all', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_set_max', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_set_poll', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_set_speed', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_shout', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_shout_all', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_shutdown', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_sitdown', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_soft_kick', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_staff_alert', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_staff_online', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_staff_summon', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_stalk', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_subscription', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_summon', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_super_ban', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_super_pull', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_take_badge', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_talk', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_teleport', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_transform', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_unban', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_unload', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_unmute', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_update_achievements', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_update_bots', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_update_catalogue', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_update_config', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_update_guildparts', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_update_hotel_view', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_update_items', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_update_navigator', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_update_permissions', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_update_pet_data', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_update_plugins', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_update_polls', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_update_texts', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_update_wordfilter', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_user_info', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('3', 'cmd_word_quiz', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('3', 'acc_ads_background', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('3', 'acc_ambassador', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('3', 'acc_anychatcolor', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('3', 'acc_anyroomowner', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('3', 'acc_calendar_force', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('3', 'acc_camera', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('3', 'acc_can_stalk', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('3', 'acc_catalog_ids', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('3', 'acc_chat_no_filter', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('3', 'acc_chat_no_flood', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('3', 'acc_chat_no_limit', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('3', 'acc_empty_others', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('3', 'acc_enable_others', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('3', 'acc_enteranyroom', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('3', 'acc_floorplan_editor', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('3', 'acc_fullrooms', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('3', 'acc_guildgate', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('3', 'acc_guild_admin', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('3', 'acc_helper_give_guide_tours', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('3', 'acc_helper_judge_chat_reviews', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('3', 'acc_helper_use_guide_tool', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('3', 'acc_hide_ip', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('3', 'acc_hide_mail', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('3', 'acc_infinite_credits', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('3', 'acc_infinite_friends', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('3', 'acc_infinite_pixels', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('3', 'acc_infinite_points', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('3', 'acc_mimic_unredeemed', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('3', 'acc_modtool_room_info', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('3', 'acc_modtool_room_logs', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('3', 'acc_modtool_ticket_q', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('3', 'acc_modtool_user_alert', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('3', 'acc_modtool_user_ban', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('3', 'acc_modtool_user_logs', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('3', 'acc_moverotate', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('3', 'acc_nomute', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('3', 'acc_not_mimiced', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('3', 'acc_no_mute', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('3', 'acc_placefurni', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('3', 'acc_see_tentchat', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('3', 'acc_see_whispers', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('3', 'acc_staff_pick', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('3', 'acc_superwired', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('3', 'acc_supporttool', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('3', 'acc_trade_anywhere', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('3', 'acc_unkickable', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('3', 'acc_unlimited_bots', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('3', 'acc_unlimited_pets', '0');
-- legacy table
INSERT INTO permissions (id, rank_name, prefix, prefix_color) VALUES ('3', 'Placeholder', '', '');


-- permission group Support
INSERT INTO permission_groups (id, name, description, level, prefix, prefix_color, badge, room_effect, log_enabled) VALUES ('4', 'Support', '', '4', 'SUP', '', '', '0', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_add_youtube_playlist', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_alert', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_allow_trading', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_badge', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_ban', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_block_alert', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_bots', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_bundle', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_calendar', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_changename', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_chatcolor', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_control', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_coords', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_credits', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_diagonal', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_disconnect', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_duckets', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_ejectall', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_empty', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_empty_bots', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_empty_pets', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_enable', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_event', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_faceless', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_fastwalk', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_filterword', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_freeze', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_freeze_bots', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_gift', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_give_rank', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_ha', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_hal', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_hand_item', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_happy_hour', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_hide_wired', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_invisible', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_ip_ban', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_machine_ban', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_mass_badge', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_mass_credits', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_mass_duckets', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_mass_gift', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_mass_points', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_mimic', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_moonwalk', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_multi', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_mute', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_pet_info', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_pick_all', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_points', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_promote_offer', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_pull', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_push', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_redeem', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_reload_room', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_required_custom', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_rights', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_room_alert', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_room_badge', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_room_credits', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_room_dance', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_room_duckets', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_room_effect', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_room_gift', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_room_item', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_room_kick', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_room_mute', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_room_points', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_say', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_say_all', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_set_max', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_set_poll', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_set_speed', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_shout', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_shout_all', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_shutdown', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_sitdown', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_soft_kick', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_staff_alert', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_staff_online', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_staff_summon', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_stalk', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_subscription', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_summon', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_super_ban', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_super_pull', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_take_badge', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_talk', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_teleport', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_transform', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_unban', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_unload', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_unmute', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_update_achievements', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_update_bots', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_update_catalogue', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_update_config', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_update_guildparts', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_update_hotel_view', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_update_items', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_update_navigator', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_update_permissions', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_update_pet_data', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_update_plugins', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_update_polls', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_update_texts', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_update_wordfilter', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_user_info', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('4', 'cmd_word_quiz', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('4', 'acc_ads_background', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('4', 'acc_ambassador', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('4', 'acc_anychatcolor', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('4', 'acc_anyroomowner', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('4', 'acc_calendar_force', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('4', 'acc_camera', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('4', 'acc_can_stalk', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('4', 'acc_catalog_ids', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('4', 'acc_chat_no_filter', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('4', 'acc_chat_no_flood', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('4', 'acc_chat_no_limit', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('4', 'acc_empty_others', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('4', 'acc_enable_others', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('4', 'acc_enteranyroom', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('4', 'acc_floorplan_editor', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('4', 'acc_fullrooms', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('4', 'acc_guildgate', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('4', 'acc_guild_admin', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('4', 'acc_helper_give_guide_tours', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('4', 'acc_helper_judge_chat_reviews', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('4', 'acc_helper_use_guide_tool', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('4', 'acc_hide_ip', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('4', 'acc_hide_mail', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('4', 'acc_infinite_credits', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('4', 'acc_infinite_friends', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('4', 'acc_infinite_pixels', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('4', 'acc_infinite_points', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('4', 'acc_mimic_unredeemed', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('4', 'acc_modtool_room_info', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('4', 'acc_modtool_room_logs', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('4', 'acc_modtool_ticket_q', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('4', 'acc_modtool_user_alert', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('4', 'acc_modtool_user_ban', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('4', 'acc_modtool_user_logs', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('4', 'acc_moverotate', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('4', 'acc_nomute', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('4', 'acc_not_mimiced', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('4', 'acc_no_mute', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('4', 'acc_placefurni', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('4', 'acc_see_tentchat', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('4', 'acc_see_whispers', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('4', 'acc_staff_pick', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('4', 'acc_superwired', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('4', 'acc_supporttool', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('4', 'acc_trade_anywhere', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('4', 'acc_unkickable', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('4', 'acc_unlimited_bots', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('4', 'acc_unlimited_pets', '0');
-- legacy table
INSERT INTO permissions (id, rank_name, prefix, prefix_color) VALUES ('4', 'Support', 'SUP', '');


-- permission group Moderator
INSERT INTO permission_groups (id, name, description, level, prefix, prefix_color, badge, room_effect, log_enabled) VALUES ('5', 'Moderator', '', '5', 'MOD', '#d620b8', 'ADM', '0', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_add_youtube_playlist', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_alert', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_allow_trading', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_badge', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_ban', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_block_alert', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_bots', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_bundle', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_calendar', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_changename', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_chatcolor', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_control', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_coords', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_credits', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_diagonal', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_disconnect', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_duckets', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_ejectall', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_empty', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_empty_bots', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_empty_pets', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_enable', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_event', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_faceless', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_fastwalk', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_filterword', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_freeze', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_freeze_bots', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_gift', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_give_rank', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_ha', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_hal', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_hand_item', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_happy_hour', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_hide_wired', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_invisible', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_ip_ban', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_machine_ban', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_mass_badge', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_mass_credits', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_mass_duckets', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_mass_gift', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_mass_points', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_mimic', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_moonwalk', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_multi', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_mute', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_pet_info', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_pick_all', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_points', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_promote_offer', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_pull', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_push', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_redeem', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_reload_room', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_required_custom', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_rights', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_room_alert', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_room_badge', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_room_credits', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_room_dance', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_room_duckets', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_room_effect', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_room_gift', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_room_item', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_room_kick', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_room_mute', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_room_points', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_say', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_say_all', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_set_max', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_set_poll', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_set_speed', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_shout', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_shout_all', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_shutdown', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_sitdown', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_soft_kick', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_staff_alert', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_staff_online', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_staff_summon', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_stalk', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_subscription', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_summon', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_super_ban', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_super_pull', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_take_badge', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_talk', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_teleport', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_transform', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_unban', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_unload', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_unmute', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_update_achievements', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_update_bots', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_update_catalogue', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_update_config', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_update_guildparts', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_update_hotel_view', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_update_items', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_update_navigator', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_update_permissions', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_update_pet_data', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_update_plugins', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_update_polls', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_update_texts', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_update_wordfilter', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_user_info', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('5', 'cmd_word_quiz', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('5', 'acc_ads_background', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('5', 'acc_ambassador', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('5', 'acc_anychatcolor', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('5', 'acc_anyroomowner', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('5', 'acc_calendar_force', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('5', 'acc_camera', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('5', 'acc_can_stalk', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('5', 'acc_catalog_ids', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('5', 'acc_chat_no_filter', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('5', 'acc_chat_no_flood', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('5', 'acc_chat_no_limit', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('5', 'acc_empty_others', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('5', 'acc_enable_others', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('5', 'acc_enteranyroom', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('5', 'acc_floorplan_editor', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('5', 'acc_fullrooms', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('5', 'acc_guildgate', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('5', 'acc_guild_admin', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('5', 'acc_helper_give_guide_tours', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('5', 'acc_helper_judge_chat_reviews', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('5', 'acc_helper_use_guide_tool', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('5', 'acc_hide_ip', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('5', 'acc_hide_mail', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('5', 'acc_infinite_credits', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('5', 'acc_infinite_friends', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('5', 'acc_infinite_pixels', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('5', 'acc_infinite_points', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('5', 'acc_mimic_unredeemed', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('5', 'acc_modtool_room_info', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('5', 'acc_modtool_room_logs', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('5', 'acc_modtool_ticket_q', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('5', 'acc_modtool_user_alert', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('5', 'acc_modtool_user_ban', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('5', 'acc_modtool_user_logs', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('5', 'acc_moverotate', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('5', 'acc_nomute', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('5', 'acc_not_mimiced', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('5', 'acc_no_mute', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('5', 'acc_placefurni', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('5', 'acc_see_tentchat', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('5', 'acc_see_whispers', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('5', 'acc_staff_pick', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('5', 'acc_superwired', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('5', 'acc_supporttool', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('5', 'acc_trade_anywhere', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('5', 'acc_unkickable', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('5', 'acc_unlimited_bots', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('5', 'acc_unlimited_pets', '0');
-- legacy table
INSERT INTO permissions (id, rank_name, prefix, prefix_color) VALUES ('5', 'Moderator', 'MOD', '#d620b8');


-- permission group Super Mod
INSERT INTO permission_groups (id, name, description, level, prefix, prefix_color, badge, room_effect, log_enabled) VALUES ('6', 'Super Mod', '', '6', 'ADM', '#4220d6', 'ADM', '0', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_add_youtube_playlist', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_alert', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_allow_trading', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_badge', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_ban', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_block_alert', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_bots', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_bundle', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_calendar', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_changename', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_chatcolor', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_control', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_coords', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_credits', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_diagonal', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_disconnect', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_duckets', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_ejectall', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_empty', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_empty_bots', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_empty_pets', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_enable', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_event', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_faceless', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_fastwalk', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_filterword', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_freeze', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_freeze_bots', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_gift', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_give_rank', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_ha', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_hal', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_hand_item', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_happy_hour', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_hide_wired', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_invisible', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_ip_ban', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_machine_ban', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_mass_badge', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_mass_credits', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_mass_duckets', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_mass_gift', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_mass_points', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_mimic', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_moonwalk', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_multi', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_mute', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_pet_info', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_pick_all', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_points', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_promote_offer', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_pull', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_push', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_redeem', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_reload_room', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_required_custom', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_rights', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_room_alert', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_room_badge', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_room_credits', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_room_dance', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_room_duckets', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_room_effect', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_room_gift', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_room_item', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_room_kick', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_room_mute', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_room_points', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_say', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_say_all', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_set_max', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_set_poll', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_set_speed', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_shout', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_shout_all', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_shutdown', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_sitdown', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_soft_kick', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_staff_alert', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_staff_online', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_staff_summon', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_stalk', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_subscription', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_summon', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_super_ban', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_super_pull', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_take_badge', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_talk', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_teleport', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_transform', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_unban', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_unload', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_unmute', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_update_achievements', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_update_bots', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_update_catalogue', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_update_config', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_update_guildparts', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_update_hotel_view', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_update_items', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_update_navigator', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_update_permissions', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_update_pet_data', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_update_plugins', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_update_polls', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_update_texts', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_update_wordfilter', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_user_info', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('6', 'cmd_word_quiz', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('6', 'acc_ads_background', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('6', 'acc_ambassador', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('6', 'acc_anychatcolor', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('6', 'acc_anyroomowner', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('6', 'acc_calendar_force', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('6', 'acc_camera', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('6', 'acc_can_stalk', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('6', 'acc_catalog_ids', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('6', 'acc_chat_no_filter', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('6', 'acc_chat_no_flood', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('6', 'acc_chat_no_limit', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('6', 'acc_empty_others', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('6', 'acc_enable_others', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('6', 'acc_enteranyroom', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('6', 'acc_floorplan_editor', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('6', 'acc_fullrooms', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('6', 'acc_guildgate', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('6', 'acc_guild_admin', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('6', 'acc_helper_give_guide_tours', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('6', 'acc_helper_judge_chat_reviews', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('6', 'acc_helper_use_guide_tool', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('6', 'acc_hide_ip', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('6', 'acc_hide_mail', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('6', 'acc_infinite_credits', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('6', 'acc_infinite_friends', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('6', 'acc_infinite_pixels', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('6', 'acc_infinite_points', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('6', 'acc_mimic_unredeemed', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('6', 'acc_modtool_room_info', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('6', 'acc_modtool_room_logs', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('6', 'acc_modtool_ticket_q', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('6', 'acc_modtool_user_alert', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('6', 'acc_modtool_user_ban', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('6', 'acc_modtool_user_logs', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('6', 'acc_moverotate', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('6', 'acc_nomute', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('6', 'acc_not_mimiced', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('6', 'acc_no_mute', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('6', 'acc_placefurni', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('6', 'acc_see_tentchat', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('6', 'acc_see_whispers', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('6', 'acc_staff_pick', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('6', 'acc_superwired', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('6', 'acc_supporttool', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('6', 'acc_trade_anywhere', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('6', 'acc_unkickable', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('6', 'acc_unlimited_bots', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('6', 'acc_unlimited_pets', '1');
-- legacy table
INSERT INTO permissions (id, rank_name, prefix, prefix_color) VALUES ('6', 'Super Mod', 'ADM', '#4220d6');


-- permission group Admin
INSERT INTO permission_groups (id, name, description, level, prefix, prefix_color, badge, room_effect, log_enabled) VALUES ('7', 'Admin', '', '7', 'ADM', '#de1f1f', 'ADM', '0', '0');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_add_youtube_playlist', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_alert', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_allow_trading', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_badge', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_ban', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_block_alert', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_bots', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_bundle', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_calendar', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_changename', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_chatcolor', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_control', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_coords', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_credits', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_diagonal', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_disconnect', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_duckets', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_ejectall', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_empty', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_empty_bots', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_empty_pets', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_enable', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_event', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_faceless', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_fastwalk', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_filterword', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_freeze', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_freeze_bots', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_gift', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_give_rank', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_ha', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_hal', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_hand_item', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_happy_hour', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_hide_wired', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_invisible', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_ip_ban', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_machine_ban', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_mass_badge', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_mass_credits', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_mass_duckets', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_mass_gift', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_mass_points', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_mimic', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_moonwalk', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_multi', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_mute', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_pet_info', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_pick_all', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_points', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_promote_offer', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_pull', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_push', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_redeem', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_reload_room', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_required_custom', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_rights', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_room_alert', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_room_badge', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_room_credits', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_room_dance', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_room_duckets', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_room_effect', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_room_gift', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_room_item', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_room_kick', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_room_mute', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_room_points', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_say', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_say_all', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_set_max', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_set_poll', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_set_speed', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_shout', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_shout_all', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_shutdown', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_sitdown', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_soft_kick', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_staff_alert', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_staff_online', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_staff_summon', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_stalk', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_subscription', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_summon', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_super_ban', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_super_pull', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_take_badge', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_talk', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_teleport', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_transform', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_unban', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_unload', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_unmute', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_update_achievements', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_update_bots', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_update_catalogue', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_update_config', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_update_guildparts', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_update_hotel_view', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_update_items', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_update_navigator', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_update_permissions', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_update_pet_data', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_update_plugins', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_update_polls', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_update_texts', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_update_wordfilter', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_user_info', '1');
INSERT INTO permission_group_commands (group_id, command_name, setting_type) VALUES ('7', 'cmd_word_quiz', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('7', 'acc_ads_background', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('7', 'acc_ambassador', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('7', 'acc_anychatcolor', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('7', 'acc_anyroomowner', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('7', 'acc_calendar_force', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('7', 'acc_camera', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('7', 'acc_can_stalk', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('7', 'acc_catalog_ids', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('7', 'acc_chat_no_filter', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('7', 'acc_chat_no_flood', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('7', 'acc_chat_no_limit', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('7', 'acc_empty_others', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('7', 'acc_enable_others', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('7', 'acc_enteranyroom', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('7', 'acc_floorplan_editor', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('7', 'acc_fullrooms', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('7', 'acc_guildgate', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('7', 'acc_guild_admin', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('7', 'acc_helper_give_guide_tours', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('7', 'acc_helper_judge_chat_reviews', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('7', 'acc_helper_use_guide_tool', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('7', 'acc_hide_ip', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('7', 'acc_hide_mail', '0');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('7', 'acc_infinite_credits', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('7', 'acc_infinite_friends', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('7', 'acc_infinite_pixels', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('7', 'acc_infinite_points', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('7', 'acc_mimic_unredeemed', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('7', 'acc_modtool_room_info', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('7', 'acc_modtool_room_logs', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('7', 'acc_modtool_ticket_q', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('7', 'acc_modtool_user_alert', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('7', 'acc_modtool_user_ban', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('7', 'acc_modtool_user_logs', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('7', 'acc_moverotate', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('7', 'acc_nomute', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('7', 'acc_not_mimiced', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('7', 'acc_no_mute', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('7', 'acc_placefurni', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('7', 'acc_see_tentchat', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('7', 'acc_see_whispers', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('7', 'acc_staff_pick', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('7', 'acc_superwired', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('7', 'acc_supporttool', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('7', 'acc_trade_anywhere', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('7', 'acc_unkickable', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('7', 'acc_unlimited_bots', '1');
INSERT INTO permission_group_rights (group_id, right_name, setting_type) VALUES ('7', 'acc_unlimited_pets', '1');
-- legacy table
INSERT INTO permissions (id, rank_name, prefix, prefix_color) VALUES ('7', 'Admin', 'ADM', '#de1f1f');


SET FOREIGN_KEY_CHECKS = 1;