CREATE TABLE `ts2_server_privileges` (
  `i_sp_id` int(8) NOT NULL auto_increment,
  `i_sp_server_id` int(8) default NULL,
  `s_sp_usergroup` varchar(32) default NULL,
  `b_sp_AccessWebAdminServer` tinyint(1) default NULL,
  `b_sp_AccessTcpServer` tinyint(1) default NULL,
  `b_sp_AccessVoice` tinyint(1) default NULL,
  `b_sp_AdminRegisterPlayer` tinyint(1) default NULL,
  `b_sp_AdminSetServerPermissions` tinyint(1) default NULL,
  `b_sp_AdminAddServer` tinyint(1) default NULL,
  `b_sp_AdminDeleteServer` tinyint(1) default NULL,
  `b_sp_AdminEditServerIpPort` tinyint(1) default NULL,
  `b_sp_AdminEditServerWebpostUrl` tinyint(1) default NULL,
  `b_sp_AdminEditServerName` tinyint(1) default NULL,
  `b_sp_AdminEditServerWelcomeMessage` tinyint(1) default NULL,
  `b_sp_AdminEditServerPassword` tinyint(1) default NULL,
  `b_sp_AdminEditServerType` tinyint(1) default NULL,
  `b_sp_AdminEditServerAllodCodecs` tinyint(1) default NULL,
  `b_sp_AdminBanIp` tinyint(1) default NULL,
  `b_sp_AdminMovePlayer` tinyint(1) default NULL,
  `b_sp_AdminListDBUsers` tinyint(1) default NULL,
  `b_sp_AdminChangeOwnPassword` tinyint(1) default NULL,
  `b_sp_AdminChangeUserPassword` tinyint(1) default NULL,
  `b_sp_AdminListDBServers` tinyint(1) default NULL,
  `b_sp_AdminEditServerMaxUsers` tinyint(1) default NULL,
  `b_sp_AdminStopServer` tinyint(1) default NULL,
  `b_sp_AdminStartServer` tinyint(1) default NULL,
  `b_sp_ChannelJoinRegisterred` tinyint(1) default NULL,
  `b_sp_ChannelCreateRegisterred` tinyint(1) default NULL,
  `b_sp_ChannelCreateUnregisterred` tinyint(1) default NULL,
  `b_sp_ChannelCreateDefault` tinyint(1) default NULL,
  `b_sp_ChannelCreateSubchannels` tinyint(1) default NULL,
  `b_sp_ChannelCreateModerated` tinyint(1) default NULL,
  `b_sp_ChannelDelete` tinyint(1) default NULL,
  `b_sp_ChannelEditName` tinyint(1) default NULL,
  `b_sp_ChannelEditPassword` tinyint(1) default NULL,
  `b_sp_ChannelEditTopic` tinyint(1) default NULL,
  `b_sp_ChannelEditDescription` tinyint(1) default NULL,
  `b_sp_ChannelEditOrder` tinyint(1) default NULL,
  `b_sp_ChannelEditMaxUsers` tinyint(1) default NULL,
  `b_sp_ChannelEditCodec` tinyint(1) default NULL,
  `b_sp_ChannelJoinChannelWithoutPassword` tinyint(1) default NULL,
  `b_sp_PrivilegeGrantSA` tinyint(1) default NULL,
  `b_sp_PrivilegeGrantCA` tinyint(1) default NULL,
  `b_sp_PrivilegeGrantAutoOp` tinyint(1) default NULL,
  `b_sp_PrivilegeGrantOp` tinyint(1) default NULL,
  `b_sp_PrivilegeGrantAutoV` tinyint(1) default NULL,
  `b_sp_PrivilegeGrantV` tinyint(1) default NULL,
  `b_sp_PrivilegeGrantAllowRegistration` tinyint(1) default NULL,
  `b_sp_PrivilegeRevokeSA` tinyint(1) default NULL,
  `b_sp_PrivilegeRevokeCA` tinyint(1) default NULL,
  `b_sp_PrivilegeRevokeAutoOp` tinyint(1) default NULL,
  `b_sp_PrivilegeRevokeOp` tinyint(1) default NULL,
  `b_sp_PrivilegeRevokeAutoV` tinyint(1) default NULL,
  `b_sp_PrivilegeRevokeV` tinyint(1) default NULL,
  `b_sp_PrivilegeRevokeAllowRegistration` tinyint(1) default NULL,
  `b_sp_PrivilegeAdminPlayerRegister` tinyint(1) default NULL,
  `b_sp_PrivilegePlayerDelete` tinyint(1) default NULL,
  `b_sp_PrivilegeRegisterSelfByDefault` tinyint(1) default NULL,
  `b_sp_SendTextToAll` tinyint(1) default NULL,
  `b_sp_SendTextToOwnChannel` tinyint(1) default NULL,
  `b_sp_SendTextToAllChannel` tinyint(1) default NULL,
  `b_sp_SendTextToPlayer` tinyint(1) default NULL,
  `b_sp_KickPlayerFromServer` tinyint(1) default NULL,
  `b_sp_KickPlayerFromChannel` tinyint(1) default NULL,
  `b_sp_AllowChannelCommanderStatus` tinyint(1) default NULL,
  PRIMARY KEY  (`i_sp_id`),
  KEY `i_sp_server_id` (`i_sp_server_id`),
  KEY `s_sp_usergroup` (`s_sp_usergroup`)
) ENGINE=MyISAM ;
