-- Время создания: Июл 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;

-- --------------------------------------------------------