CREATE table IF NOT EXISTS `permissions_ranks` (
`rank` int(1) unsigned NOT NULL,
`floodtime` int(2) NOT NULL DEFAULT '30',
`support_tool` enum('0','1') NOT NULL DEFAULT '0',
`ambassadeur` enum('0','1') NOT NULL DEFAULT '0',
`moderator` enum('0','1') NOT NULL DEFAULT '0',
`manager` enum('0','1') NOT NULL DEFAULT '0',
`admin` enum('0','1') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
`staff_chat` enum('0','1') NOT NULL DEFAULT '0',
`user_is_staff` enum('0','1') NOT NULL DEFAULT '0',
`user_not_kickable` enum('0','1') NOT NULL DEFAULT '0',
`user_can_change_name` enum('0','1') NOT NULL DEFAULT '0',
`user_enter_full_rooms` enum('0','1') NOT NULL DEFAULT '0',
`user_enter_any_room` enum('0','1') NOT NULL DEFAULT '0',
`user_can_read_whisper` enum('0','1') NOT NULL DEFAULT '0',
`user_room_staff_pick` enum('0','1') NOT NULL DEFAULT '0',
`cmd_global_refresh_permissions` enum('0','1') NOT NULL DEFAULT '0',
`cmd_user_can_give_currency` enum('0','1') NOT NULL DEFAULT '0',
`modtool_can_read_chatlog` enum('0','1') NOT NULL DEFAULT '0',
`modtool_can_send_alert` enum('0','1') NOT NULL DEFAULT '0',
`modtool_can_ban_user` enum('0','1') NOT NULL DEFAULT '0',
`modtool_can_kick_user` enum('0','1') NOT NULL DEFAULT '0',
`user_control_any_room` enum('0','1') NOT NULL DEFAULT '0',
PRIMARY KEY (`rank`),
UNIQUE KEY `rank` (`rank`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `permissions_ranks` (`rank`, `floodtime`, `support_tool`, `ambassadeur`, `moderator`, `manager`, `admin`, `staff_chat`, `user_is_staff`, `user_not_kickable`, `user_can_change_name`, `user_enter_full_rooms`, `user_enter_any_room`, `user_can_read_whisper`, `user_room_staff_pick`, `cmd_global_refresh_permissions`, `cmd_user_can_give_currency`, `modtool_can_read_chatlog`, `modtool_can_send_alert`, `modtool_can_ban_user`, `modtool_can_kick_user`, `user_control_any_room`) VALUES
(1, 30, '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0'),
(2, 30, '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0'),
(3, 30, '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0'),
(4, 30, '1', '1', '1', '0', '0', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0'),
(5, 30, '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1'),
(6, 30, '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1'),
(7, 30, '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1'),
(8, 30, '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1'),
(9, 30, '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1');