-- Время создания: Фев 26 2008 г., 14:31
-- Структура таблицы `banksys`
CREATE TABLE `banksys` (
`bankid` mediumint(9)UNSIGNED NOT NULL auto_increment,
`bankto` char(30) NOT NULL,
`bankfrom` char(30) NOT NULL,
`bankmoney` int(7)UNSIGNED NOT NULL default '0',
`bankmoneyreal` int(7)UNSIGNED NOT NULL default '0',
`banktime` int(20)UNSIGNED NOT NULL default '0',
`banksts` char(30) NOT NULL,
PRIMARY KEY (`bankid`)
) ENGINE=InnoDB AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Структура таблицы `chater`
CREATE TABLE `chater` (
`chatid` mediumint(8) UNSIGNED NOT NULL auto_increment,
`namec` char(30) NOT NULL,
`timec` int(20) UNSIGNED NOT NULL default '0',
`sidec` int(20) UNSIGNED NOT NULL default '0',
`sideu` int(20) UNSIGNED NOT NULL default '0',
`textc` text NOT NULL,
PRIMARY KEY (`chatid`)
) ENGINE=InnoDB AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Структура таблицы `chater2`
CREATE TABLE `chater2` (
`chatid` mediumint(8) UNSIGNED NOT NULL auto_increment,
`cid` tinyint(2) UNSIGNED NOT NULL default '0',
`namec` char(30) NOT NULL,
`timec` int(20) UNSIGNED NOT NULL default '0',
`sidec` int(20) UNSIGNED NOT NULL default '0',
`sideu` int(20) UNSIGNED NOT NULL default '0',
`textc` text NOT NULL,
PRIMARY KEY (`chatid`)
) ENGINE=InnoDB AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Структура таблицы `tmchater`
CREATE TABLE `tmchater` (
`chatid` mediumint(8) UNSIGNED NOT NULL auto_increment,
`cid` tinyint(2) UNSIGNED NOT NULL default '0',
`namec` char(30) NOT NULL,
`timec` int(20) UNSIGNED NOT NULL default '0',
`sidec` int(20) UNSIGNED NOT NULL default '0',
`sideu` int(20) UNSIGNED NOT NULL default '0',
`textc` text NOT NULL,
PRIMARY KEY (`chatid`)
) ENGINE=InnoDB AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Структура таблицы `chater3`
CREATE TABLE `chater3` (
`chatid` mediumint(8) unsigned NOT NULL auto_increment,
`namec` varchar(30) NOT NULL default '',
`timec` int(20) unsigned NOT NULL default '0',
`sidec` int(20) unsigned NOT NULL default '0',
`sideu` int(20) unsigned NOT NULL default '0',
`textc` text NOT NULL,
`level` smallint(10) unsigned NOT NULL default '0',
PRIMARY KEY (`chatid`)
) ENGINE=MyISAM AUTO_INCREMENT=1;
-- --------------------------------------------------------
-- Структура таблицы `modchater`
CREATE TABLE `modchater` (
`chatid` mediumint(8) UNSIGNED NOT NULL auto_increment,
`namec` char(30) NOT NULL,
`timec` int(20) UNSIGNED NOT NULL default '0',
`sidec` int(20) UNSIGNED NOT NULL default '0',
`sideu` int(20) UNSIGNED NOT NULL default '0',
`textc` text NOT NULL,
PRIMARY KEY (`chatid`)
) ENGINE=InnoDB AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Структура таблицы `days`
CREATE TABLE `days` (
`id` mediumint(8)UNSIGNED NOT NULL auto_increment,
`day` tinyint(3)UNSIGNED NOT NULL default '0',
`month` tinyint(3)UNSIGNED NOT NULL default '0',
`year` tinyint(3)UNSIGNED NOT NULL default '0',
`fraged` smallint(8)UNSIGNED NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 ;
--
-- Дамп данных таблицы `days`
--
-- ------------------------------------------------------
-- Структура таблицы `logmoney`
CREATE TABLE `logmoney` (
`id` INT( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`name` CHAR( 30 ) NOT NULL ,
`object` CHAR( 30 ) NOT NULL ,
`summa` MEDIUMINT( 20 ) UNSIGNED NOT NULL DEFAULT '0',
`time` INT( 20 ) UNSIGNED NOT NULL DEFAULT '0',
`do` CHAR( 255 ) NOT NULL ,
`comment` TEXT NOT NULL ,
`ip` CHAR( 15 ) NOT NULL ,
`soft` CHAR( 255 ) NOT NULL ,
`ip2` CHAR( 15 ) NOT NULL ,
`soft2` CHAR( 255 ) NOT NULL
) ENGINE = innodb CHARACTER SET utf8 COLLATE utf8_unicode_ci;
-- --------------------------------------------------------
-- Структура таблицы `game`
CREATE TABLE `game` (
`id` mediumint(8)UNSIGNED NOT NULL auto_increment,
`level` smallint(5)UNSIGNED NOT NULL default '0',
`name` char(30) NOT NULL default '',
`badgename` char(30) NOT NULL default '',
`activity` int(11)UNSIGNED NOT NULL default '0',
`side` tinyint(20)UNSIGNED NOT NULL default '0',
`s1use` tinyint(3)UNSIGNED NOT NULL default '0',
`s1` tinyint(3)UNSIGNED NOT NULL default '0',
`s2use` tinyint(3)UNSIGNED NOT NULL default '0',
`s3use` tinyint(3)UNSIGNED NOT NULL default '0',
`s4` tinyint(3)UNSIGNED NOT NULL default '0',
`armp` tinyint(3)UNSIGNED NOT NULL default '0',
`arms` tinyint(3)UNSIGNED NOT NULL default '0',
`act_wep` mediumint(7)UNSIGNED NOT NULL default '0',
`act_arm` mediumint(7)UNSIGNED NOT NULL default '0',
`health` tinyint(3) NOT NULL default '0',
`granadeuse` tinyint(3)UNSIGNED NOT NULL default '0',
`drinkuse` tinyint(3)UNSIGNED NOT NULL default '0',
`hittime` int(20)UNSIGNED NOT NULL default '0',
`gameexit` int(20)UNSIGNED NOT NULL default '0',
`defencetime` int(20)UNSIGNED NOT NULL default '0',
`nodefencetime` int(20)UNSIGNED NOT NULL default '0',
`round` tinyint(5)UNSIGNED NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Структура таблицы `creategame`
CREATE TABLE `creategame` (
`idg` mediumint(8)UNSIGNED NOT NULL auto_increment,
`composer` char(30)NOT NULL default '',
`timebattle` int(20)UNSIGNED NOT NULL default '0',
`fragsot` smallint(7)UNSIGNED NOT NULL default '0',
`fragsdo` smallint(7)UNSIGNED NOT NULL default '0',
`tm` tinyint(3)UNSIGNED NOT NULL default '0',
`ctm` tinyint(3)UNSIGNED NOT NULL default '0',
PRIMARY KEY (`idg`)
) ENGINE=InnoDB AUTO_INCREMENT=20 ;
-- --------------------------------------------------------
-- Структура таблицы `log`
CREATE TABLE `log` (
`id` int(10)UNSIGNED NOT NULL auto_increment,
`kto` char(30) NOT NULL,
`kogo` char(30) NOT NULL,
`kogda` int(20)UNSIGNED NOT NULL default '0',
`uron` tinyint(4)UNSIGNED NOT NULL default '0',
`granade` tinyint(4)UNSIGNED NOT NULL default '0',
`do` char (100) NOT NULL default '',
`level` tinyint(4) NOT NULL default '0',
`ip` char(20) NOT NULL default '',
`soft` char(70) NOT NULL default '',
`ip2` char(20) NOT NULL default '',
`soft2` char(70) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Структура таблицы `months`
CREATE TABLE `months` (
`id` smallint(20)UNSIGNED NOT NULL auto_increment,
`month` tinyint(3)UNSIGNED NOT NULL default '0',
`year` tinyint(3)UNSIGNED NOT NULL default '0',
`days0` smallint(4)UNSIGNED NOT NULL default '0',
`days1` smallint(4)UNSIGNED NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Структура таблицы `online`
CREATE TABLE `online` (
`oname` char(30) NOT NULL,
`otime` char(30) NOT NULL,
`maxonline` tinyint(3) NOT NULL default '0'
) ENGINE=InnoDB;
-- --------------------------------------------------------
-- Структура таблицы `pm`
CREATE TABLE `pm` (
`id` mediumint(8)UNSIGNED NOT NULL auto_increment,
`kam` char(30) NOT NULL default '',
`noka` char(30) NOT NULL default '',
`teksts` text(1000) NOT NULL,
`kad` int(10)UNSIGNED NOT NULL default '0',
`tema` char(255) NOT NULL default '',
`status` tinyint(3)UNSIGNED NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Структура таблицы `sec`
CREATE TABLE `sec` (
`id` smallint(5)UNSIGNED NOT NULL auto_increment,
`num` int(6) UNSIGNED NOT NULL default '0',
`addr` char(20) NOT NULL default '',
`ug` char(100) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 ;
-- --------------------------------------------------------
-- Структура таблицы `stats`
CREATE TABLE `stats` (
`x` char(12) NOT NULL,
`y` smallint(20)UNSIGNED NOT NULL default '0'
) ENGINE=InnoDB;
-- Дамп данных таблицы `stats`
INSERT INTO `stats` (`x`, `y`) VALUES ('day', 25);
INSERT INTO `stats` (`x`, `y`) VALUES ('month', 8);
INSERT INTO `stats` (`x`, `y`) VALUES ('frag0', 0);
INSERT INTO `stats` (`x`, `y`) VALUES ('frag1', 0);
-- --------------------------------------------------------
-- Структура таблицы `modcontrol`
CREATE TABLE `modcontrol` (
`id` mediumint(8) UNSIGNED NOT NULL auto_increment,
`mod` char(30) NOT NULL default '',
`do` char(255) NOT NULL,
`kad` int(10) UNSIGNED NOT NULL default '0',
`ip` char(20) NOT NULL default '',
`soft` char(70) NOT NULL default '',
`ip2` char(20) NOT NULL default '',
`soft2` char(70) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Структура таблицы `teams`
CREATE TABLE teams (
teamid mediumint(8) unsigned NOT NULL auto_increment,
teamside tinyint(8) unsigned NOT NULL default '0',
win smallint(8) unsigned NOT NULL default '0',
title char(40) NOT NULL default '',
badge char(4) character set utf8 collate utf8_unicode_ci NOT NULL default '',
arms char(15) NOT NULL default '',
name char(30) NOT NULL default '',
foundation int(10) unsigned NOT NULL default '0',
teambank smallint(20) unsigned NOT NULL default '0',
device char(255) NOT NULL default '',
info char(255) NOT NULL default '',
timeation int(10) unsigned NOT NULL default '0',
textaction char(255) NOT NULL default '',
PRIMARY KEY (teamid)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Структура таблицы `users`
CREATE TABLE `users` (
`id` mediumint(8) UNSIGNED NOT NULL auto_increment,
`realname` char(30) NOT NULL default '',
`city` char(30) NOT NULL default '',
`name` char(30) NOT NULL default '',
`pass` char(100) NOT NULL default '',
`mail` char(30) NOT NULL default '',
`side` tinyint(3)UNSIGNED NOT NULL default '0',
`money` mediumint(8) UNSIGNED NOT NULL default '0',
`points` tinyint(6)UNSIGNED NOT NULL default '0',
`health` tinyint(6)UNSIGNED NOT NULL default '0',
`win` smallint(8)UNSIGNED NOT NULL default '0',
`lost` int(10)UNSIGNED NOT NULL default '0',
`level` tinyint(6)UNSIGNED NOT NULL default '0',
`ppp` tinyint(20)UNSIGNED NOT NULL default '0',
`act_wep` smallint(10)UNSIGNED NOT NULL default '0',
`act_arm` smallint(10)UNSIGNED NOT NULL default '0',
`pic` char(15) NOT NULL default '',
`s1` tinyint(6) UNSIGNED NOT NULL default '0',
`s2` tinyint(6) UNSIGNED NOT NULL default '0',
`s3` tinyint(6) UNSIGNED NOT NULL default '0',
`s4` tinyint(6) UNSIGNED NOT NULL default '30',
`s5` tinyint(6) UNSIGNED NOT NULL default '0',
`s6` tinyint(6) UNSIGNED NOT NULL default '0',
`s7` tinyint(6) UNSIGNED NOT NULL default '0',
`s8` tinyint(6) UNSIGNED NOT NULL default '0',
`s9` tinyint(6) UNSIGNED NOT NULL default '0',
`s10` tinyint(6) UNSIGNED NOT NULL default '0',
`belt_granade` tinyint(6) UNSIGNED NOT NULL default '1',
`lastdeath` int(20)UNSIGNED NOT NULL default '0',
`visited` int(10)UNSIGNED NOT NULL default '0',
`visited24` int(10)UNSIGNED NOT NULL default '0',
`drinks` tinyint(6)UNSIGNED NOT NULL default '0',
`granades` tinyint(6) UNSIGNED NOT NULL default '0',
`sys_death` char(30) NOT NULL default '',
`translit` tinyint(10)UNSIGNED NOT NULL default '0',
`cgame` tinyint(6)UNSIGNED NOT NULL default '0',
`usagent` char(255) NOT NULL default '',
`usadr` char(15) NOT NULL default '',
`post` tinyint(3) UNSIGNED NOT NULL default '0',
`team` mediumint(20) UNSIGNED NOT NULL default '0',
`addteam` tinyint(3) UNSIGNED NOT NULL default '0',
`addid` tinyint(3) UNSIGNED NOT NULL default '0',
`whyban` char(255) NOT NULL default '',
`whoban` char(30) NOT NULL default '',
`sectime` int(8)UNSIGNED NOT NULL default '0',
`ignor` tinyint(5) UNSIGNED NOT NULL default '0',
`patron1` smallint(10)UNSIGNED NOT NULL default '0',
`patron2` smallint(10)UNSIGNED NOT NULL default '0',
`patron3` smallint(10)UNSIGNED NOT NULL default '0',
`patron4` smallint(10)UNSIGNED NOT NULL default '0',
`patron5` smallint(10)UNSIGNED NOT NULL default '0',
`weppatr` tinyint(10)UNSIGNED NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Структура таблицы `wep_box`
CREATE TABLE `wep_box` (
`id` mediumint(8)UNSIGNED NOT NULL auto_increment,
`name` char(30) NOT NULL default '',
`gun_id` tinyint(6)UNSIGNED NOT NULL default '0',
`gun_name` char(100) NOT NULL default '',
`bullet` tinyint(6)UNSIGNED NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Структура таблицы `arm_box`
CREATE TABLE `arm_box` (
`id` mediumint(8)UNSIGNED NOT NULL auto_increment,
`name` char(30) NOT NULL default '',
`arm_id` tinyint(6)UNSIGNED NOT NULL default '0',
`arm_name` char(100) NOT NULL default '',
`protection` tinyint(6)UNSIGNED NOT NULL default '0',
`arm_stability` tinyint(6)UNSIGNED NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Структура таблицы `optim`
CREATE TABLE `optim` (
`klu4` tinyint(6)UNSIGNED NOT NULL default '0',
`go` int(11)UNSIGNED NOT NULL default '0',
`game` int(11)UNSIGNED NOT NULL default '0',
`gamesm` int(11)UNSIGNED NOT NULL default '0',
`mbot` tinyint(5)UNSIGNED NOT NULL default '0',
PRIMARY KEY (`klu4`))
ENGINE=InnoDB;
-- --------------------------------------------------------
-- Структура таблицы `botmat`
CREATE TABLE `botmat` (
`id` mediumint(8)UNSIGNED NOT NULL auto_increment,
`perl` char(255) NOT NULL default '',
`util` tinyint(5)UNSIGNED NOT NULL default '0',
PRIMARY KEY (`id`))
ENGINE=InnoDB;
-- --------------------------------------------------------
-- Структура таблицы `enters`
CREATE TABLE `enters` (
`id` int(20) UNSIGNED NOT NULL auto_increment,
`name` char(30) NOT NULL default '',
`ip` char(255) NOT NULL default '',
`soft` char(255) NOT NULL default '0',
`cookie` char(30) NOT NULL default '',
PRIMARY KEY (`id`))
ENGINE=InnoDB;
-- --------------------------------------------------------
-- Структура таблицы `weapons`
CREATE TABLE `weapons` (
`id` int(20) UNSIGNED NOT NULL auto_increment,
`title` char(255) NOT NULL default '',
`cost` smallint(10) NOT NULL default '0',
`rapid` tinyint(5) NOT NULL default '0',
`losses` tinyint(5) NOT NULL default '0',
`mag` tinyint(5) NOT NULL default '0',
`class` tinyint(5) NOT NULL default '0',
PRIMARY KEY (`id`))
ENGINE=InnoDB;
-- --------------------------------------------------------
-- Структура таблицы `logshop`
CREATE TABLE `logshop` (
`id` int(20) UNSIGNED NOT NULL auto_increment,
`name` char(30) NOT NULL default '',
`summa` mediumint(20) UNSIGNED NOT NULL default '0',
`what` char(100) NOT NULL default '',
`data` int(20) UNSIGNED NOT NULL default '0',
PRIMARY KEY (`id`))
ENGINE=InnoDB;
-- --------------------------------------------------------
-- Структура таблицы `gamemap`
CREATE TABLE `gamemap` (
`id` int(20) UNSIGNED NOT NULL auto_increment,
`name` char(30) NOT NULL default '',
`loc1` tinyint(2) UNSIGNED NOT NULL default '0',
`loc2` tinyint(2) UNSIGNED NOT NULL default '0',
`time` int(10) UNSIGNED NOT NULL default '0',
PRIMARY KEY (`id`))
ENGINE=InnoDB;
-- --------------------------------------------------------