-- Время создания: Июл 11 2007 г., 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 '',
`win` smallint(8) UNSIGNED NOT NULL default '0',
`title` char(40) NOT NULL default '',
`badge` char(40) NOT NULL default '',
`arms` char(15) NOT NULL default '',
`name` char(30) NOT NULL,
`foundation` int(10) UNSIGNED NOT NULL default '0',
`teambank` smallint(20) UNSIGNED NOT NULL default '',
`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=InnoDB 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;
-- --------------------------------------------------------