TeamSpeak with MySQL

Материал из wiki.otstrel.ru.

Перейти к: навигация, поиск
-- phpMyAdmin SQL Dump
-- version 2.7.0-rc1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Nov 27, 2007 at 10:14 PM
-- Server version: 4.1.11
-- PHP Version: 5.2.4
-- 
-- Database: `ts2`
-- 
-- --------------------------------------------------------
-- 
-- Table structure for table `ts2_bans`
-- 
CREATE TABLE IF NOT EXISTS `ts2_bans` (
 `i_ban_id` int(11) NOT NULL auto_increment,
 `i_ban_server_id` int(11) default NULL,
 `s_ban_ip` varchar(40) default NULL,
 `s_ban_by` varchar(40) default NULL,
 `dt_ban_created` varchar(20) default NULL,
 `i_ban_minutes` int(11) default NULL,
 PRIMARY KEY  (`i_ban_id`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1251;
-- --------------------------------------------------------
-- 
-- Table structure for table `ts2_channel_privileges`
-- 
CREATE TABLE IF NOT EXISTS `ts2_channel_privileges` (
 `i_cp_id` int(11) NOT NULL auto_increment,
 `i_cp_server_id` int(11) default NULL,
 `i_cp_channel_id` int(11) default NULL,
 `i_cp_client_id` int(11) default NULL,
 `b_cp_flag_admin` int(11) default NULL,
 `b_cp_flag_autoop` int(11) default NULL,
 `b_cp_flag_autovoice` int(11) default NULL,
 PRIMARY KEY  (`i_cp_id`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1251;
-- --------------------------------------------------------
-- 
-- Table structure for table `ts2_channels`
-- 
CREATE TABLE IF NOT EXISTS `ts2_channels` (
 `i_channel_id` int(11) unsigned NOT NULL auto_increment,
 `i_channel_server_id` int(11) default NULL,
 `i_channel_parent_id` int(11) default NULL,
 `b_channel_flag_moderated` int(11) default NULL,
 `b_channel_flag_hierarchical` int(11) default NULL,
 `b_channel_flag_default` int(11) default NULL,
 `i_channel_codec` int(11) default NULL,
 `i_channel_order` int(11) default NULL,
 `i_channel_maxusers` int(11) default NULL,
 `s_channel_name` varchar(40) default NULL,
 `s_channel_topic` varchar(40) default NULL,
 `s_channel_description` text,
 `s_channel_password` varchar(80) default NULL,
 `dt_channel_created` varchar(20) default NULL,
 PRIMARY KEY  (`i_channel_id`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1251;
-- --------------------------------------------------------
-- 
-- Table structure for table `ts2_clients`
-- 
CREATE TABLE IF NOT EXISTS `ts2_clients` (
 `i_client_id` int(11) NOT NULL auto_increment,
 `i_client_server_id` int(11) default NULL,
 `b_client_privilege_serveradmin` int(11) default NULL,
 `s_client_name` varchar(40) default NULL,
 `s_client_password` varchar(80) default NULL,
 `dt_client_created` varchar(20) default NULL,
 `dt_client_lastonline` varchar(20) default NULL,
 PRIMARY KEY  (`i_client_id`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1251;
-- --------------------------------------------------------
-- 
-- Table structure for table `ts2_server_privileges`
-- 
CREATE TABLE IF NOT EXISTS `ts2_server_privileges` (
 `i_sp_id` int(11) NOT NULL auto_increment,
 `i_sp_server_id` int(11) default NULL,
 `s_sp_usergroup` varchar(40) default NULL,
 `b_sp_AccessWebAdminServer` int(11) default NULL,
 `b_sp_AccessTcpServer` int(11) default NULL,
 `b_sp_AccessVoice` int(11) default NULL,
 `b_sp_AdminRegisterPlayer` int(11) default NULL,
 `b_sp_AdminSetServerPermissions` int(11) default NULL,
 `b_sp_AdminAddServer` int(11) default NULL,
 `b_sp_AdminDeleteServer` int(11) default NULL,
 `b_sp_AdminEditServerIpPort` int(11) default NULL,
 `b_sp_AdminEditServerWebpostUrl` int(11) default NULL,
 `b_sp_AdminEditServerName` int(11) default NULL,
 `b_sp_AdminEditServerWelcomeMessage` int(11) default NULL,
 `b_sp_AdminEditServerPassword` int(11) default NULL,
 `b_sp_AdminEditServerType` int(11) default NULL,
 `b_sp_AdminEditServerAllodCodecs` int(11) default NULL,
 `b_sp_AdminBanIp` int(11) default NULL,
 `b_sp_AdminMovePlayer` int(11) default NULL,
 `b_sp_AdminListDBUsers` int(11) default NULL,
 `b_sp_AdminChangeOwnPassword` int(11) default NULL,
 `b_sp_AdminChangeUserPassword` int(11) default NULL,
 `b_sp_AdminListDBServers` int(11) default NULL,
 `b_sp_AdminEditServerMaxUsers` int(11) default NULL,
 `b_sp_AdminStopServer` int(11) default NULL,
 `b_sp_AdminStartServer` int(11) default NULL,
 `b_sp_ChannelJoinRegisterred` int(11) default NULL,
 `b_sp_ChannelCreateRegisterred` int(11) default NULL,
 `b_sp_ChannelCreateUnregisterred` int(11) default NULL,
 `b_sp_ChannelCreateDefault` int(11) default NULL,
 `b_sp_ChannelCreateSubchannels` int(11) default NULL,
 `b_sp_ChannelCreateModerated` int(11) default NULL,
 `b_sp_ChannelDelete` int(11) default NULL,
 `b_sp_ChannelEditName` int(11) default NULL,
 `b_sp_ChannelEditPassword` int(11) default NULL,
 `b_sp_ChannelEditTopic` int(11) default NULL,
 `b_sp_ChannelEditDescription` int(11) default NULL,
 `b_sp_ChannelEditOrder` int(11) default NULL,
 `b_sp_ChannelEditMaxUsers` int(11) default NULL,
 `b_sp_ChannelEditCodec` int(11) default NULL,
 `b_sp_ChannelJoinChannelWithoutPassword` int(11) default NULL,
 `b_sp_PrivilegeGrantSA` int(11) default NULL,
 `b_sp_PrivilegeGrantCA` int(11) default NULL,
 `b_sp_PrivilegeGrantAutoOp` int(11) default NULL,
 `b_sp_PrivilegeGrantOp` int(11) default NULL,
 `b_sp_PrivilegeGrantAutoV` int(11) default NULL,
 `b_sp_PrivilegeGrantV` int(11) default NULL,
 `b_sp_PrivilegeGrantAllowRegistration` int(11) default NULL,
 `b_sp_PrivilegeRevokeSA` int(11) default NULL,
 `b_sp_PrivilegeRevokeCA` int(11) default NULL,
 `b_sp_PrivilegeRevokeAutoOp` int(11) default NULL,
 `b_sp_PrivilegeRevokeOp` int(11) default NULL,
 `b_sp_PrivilegeRevokeAutoV` int(11) default NULL,
 `b_sp_PrivilegeRevokeV` int(11) default NULL,
 `b_sp_PrivilegeRevokeAllowRegistration` int(11) default NULL,
 `b_sp_PrivilegeAdminPlayerRegister` int(11) default NULL,
 `b_sp_PrivilegePlayerDelete` int(11) default NULL,
 `b_sp_PrivilegeRegisterSelfByDefault` int(11) default NULL,
 `b_sp_SendTextToAll` int(11) default NULL,
 `b_sp_SendTextToOwnChannel` int(11) default NULL,
 `b_sp_SendTextToAllChannel` int(11) default NULL,
 `b_sp_SendTextToPlayer` int(11) default NULL,
 `b_sp_KickPlayerFromServer` int(11) default NULL,
 `b_sp_KickPlayerFromChannel` int(11) default NULL,
 `b_sp_AllowChannelCommanderStatus` int(11) default NULL,
 PRIMARY KEY  (`i_sp_id`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1251;
-- --------------------------------------------------------
-- 
-- Table structure for table `ts2_servers`
-- 
CREATE TABLE IF NOT EXISTS `ts2_servers` (
 `i_server_id` int(11) NOT NULL auto_increment,
 `s_server_name` varchar(40) default NULL,
 `s_server_welcomemessage` varchar(80) default NULL,
 `i_server_maxusers` int(11) default NULL,
 `i_server_udpport` int(11) default NULL,
 `s_server_password` varchar(80) default NULL,
 `b_server_clan_server` int(11) default NULL,
 `b_server_allow_codec_celp51` int(11) default NULL,
 `b_server_allow_codec_celp63` int(11) default NULL,
 `b_server_allow_codec_gsm148` int(11) default NULL,
 `b_server_allow_codec_gsm164` int(11) default NULL,
 `b_server_allow_codec_celp52` int(11) default NULL,
 `b_server_allow_codec_speex2150` int(11) default NULL,
 `b_server_allow_codec_speex3950` int(11) default NULL,
 `b_server_allow_codec_speex5950` int(11) default NULL,
 `b_server_allow_codec_speex8000` int(11) default NULL,
 `b_server_allow_codec_speex11000` int(11) default NULL,
 `b_server_allow_codec_speex15000` int(11) default NULL,
 `b_server_allow_codec_speex18200` int(11) default NULL,
 `b_server_allow_codec_speex24600` int(11) default NULL,
 `s_server_webposturl` varchar(200) default NULL,
 `s_server_weblinkurl` varchar(200) default NULL,
 `b_server_active` int(11) default NULL,
 `dt_server_created` varchar(20) default NULL,
 `s_server_description` varchar(100) default NULL,
 PRIMARY KEY  (`i_server_id`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1251;
Личные инструменты