1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67
|
CREATE TABLE ts2_server_privileges (
i_sp_id integer PRIMARY KEY,
i_sp_server_id integer,
s_sp_usergroup varchar(40),
b_sp_AccessWebAdminServer integer,
b_sp_AccessTcpServer integer,
b_sp_AccessVoice integer,
b_sp_AdminRegisterPlayer integer,
b_sp_AdminSetServerPermissions integer,
b_sp_AdminAddServer integer,
b_sp_AdminDeleteServer integer,
b_sp_AdminEditServerIpPort integer,
b_sp_AdminEditServerWebpostUrl integer,
b_sp_AdminEditServerName integer,
b_sp_AdminEditServerWelcomeMessage integer,
b_sp_AdminEditServerPassword integer,
b_sp_AdminEditServerType integer,
b_sp_AdminEditServerAllodCodecs integer,
b_sp_AdminBanIp integer,
b_sp_AdminMovePlayer integer,
b_sp_AdminListDBUsers integer,
b_sp_AdminChangeOwnPassword integer,
b_sp_AdminChangeUserPassword integer,
b_sp_AdminListDBServers integer,
b_sp_AdminEditServerMaxUsers integer,
b_sp_AdminStopServer integer,
b_sp_AdminStartServer integer,
b_sp_ChannelJoinRegisterred integer,
b_sp_ChannelCreateRegisterred integer,
b_sp_ChannelCreateUnregisterred integer,
b_sp_ChannelCreateDefault integer,
b_sp_ChannelCreateSubchannels integer,
b_sp_ChannelCreateModerated integer,
b_sp_ChannelDelete integer,
b_sp_ChannelEditName integer,
b_sp_ChannelEditPassword integer,
b_sp_ChannelEditTopic integer,
b_sp_ChannelEditDescription integer,
b_sp_ChannelEditOrder integer,
b_sp_ChannelEditMaxUsers integer,
b_sp_ChannelEditCodec integer,
b_sp_ChannelJoinChannelWithoutPassword integer,
b_sp_PrivilegeGrantSA integer,
b_sp_PrivilegeGrantCA integer,
b_sp_PrivilegeGrantAutoOp integer,
b_sp_PrivilegeGrantOp integer,
b_sp_PrivilegeGrantAutoV integer,
b_sp_PrivilegeGrantV integer,
b_sp_PrivilegeGrantAllowRegistration integer,
b_sp_PrivilegeRevokeSA integer,
b_sp_PrivilegeRevokeCA integer,
b_sp_PrivilegeRevokeAutoOp integer,
b_sp_PrivilegeRevokeOp integer,
b_sp_PrivilegeRevokeAutoV integer,
b_sp_PrivilegeRevokeV integer,
b_sp_PrivilegeRevokeAllowRegistration integer,
b_sp_PrivilegeAdminPlayerRegister integer,
b_sp_PrivilegePlayerDelete integer,
b_sp_PrivilegeRegisterSelfByDefault integer,
b_sp_SendTextToAll integer,
b_sp_SendTextToOwnChannel integer,
b_sp_SendTextToAllChannel integer,
b_sp_SendTextToPlayer integer,
b_sp_KickPlayerFromServer integer,
b_sp_KickPlayerFromChannel integer,
b_sp_AllowChannelCommanderStatus integer
) ;
|