-- phpMyAdmin SQL Dump -- version 3.2.5 -- http://www.phpmyadmin.net -- -- Хост: localhost -- Время создания: Фев 15 2010 г., 22:43 -- Версия сервера: 5.0.51 -- Версия PHP: 5.2.6-1+lenny4 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- База данных: `gg_stats` -- -- -------------------------------------------------------- -- -- Структура таблицы `gg_players` -- CREATE TABLE IF NOT EXISTS `gg_players` ( `id` tinyint(4) NOT NULL default '0', `authid` varchar(31) NOT NULL, `name` varchar(31) NOT NULL, `team` tinyint(4) default '0', `level` tinyint(4) default '0', `weapon` varchar(23) NOT NULL, `flags` tinyint(4) default '0', `wins` smallint(5) default '0', `points` mediumint(9) default '0', `new_points` mediumint(9) default '0', `record_streak` smallint(6) default '0', `current_streak` smallint(6) default '0', `stats_position` smallint(5) unsigned default '0', `teamtime_winning` smallint(5) unsigned default '0', `teamtime_losing` smallint(5) unsigned default '0', `timestamp` int(10) unsigned default '0', `serverip` varchar(21) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251; -- -- Дамп данных таблицы `gg_players` -- -- -------------------------------------------------------- -- -- Структура таблицы `gg_stats` -- CREATE TABLE IF NOT EXISTS `gg_stats` ( `authid` varchar(24) NOT NULL, `wins` int(6) NOT NULL, `lastname` varchar(32) NOT NULL, `timestamp` int(12) NOT NULL, `points` int(8) NOT NULL, `serverip` varchar(21) NOT NULL, PRIMARY KEY (`authid`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251; -- -- Дамп данных таблицы `gg_stats` -- -- -------------------------------------------------------- -- -- Структура таблицы `gg_streaks` -- CREATE TABLE IF NOT EXISTS `gg_streaks` ( `type` enum('0C','0R','1C','1R') default NULL, `authid` varchar(31) NOT NULL, `streak` smallint(6) default '0', `name` varchar(31) NOT NULL, `timestamp` int(10) unsigned default '0', `serverip` varchar(21) NOT NULL, KEY `authid` (`authid`,`serverip`), KEY `type` (`type`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251; -- -- Дамп данных таблицы `gg_streaks` -- INSERT INTO `gg_streaks` (`type`, `authid`, `streak`, `name`, `timestamp`, `serverip`) VALUES ('0C', 'STEAM_ID_LAN', 2, 'universals>Rokki*', 1266262841, '127.0.1.1:27018'), ('0R', 'STEAM_ID_LAN', 2, 'universals>Rokki*', 1266264251, '127.0.1.1:27018');