
CREATE TABLE `friends` (
  `id` int(20) NOT NULL auto_increment,
  `user_id` int(20) NOT NULL default '0',
  `fr_id` int(20) NOT NULL default '0',
  `yes` int(20) NOT NULL default '0',
  `no` int(20) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=0;

CREATE TABLE `ignor` (
  `id` int(20) NOT NULL auto_increment,
  `user_id` int(20) NOT NULL default '0',
  `ig_id` int(20) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE `levels` (
  `level` int(5) NOT NULL default '0',
  `name` blob,
  PRIMARY KEY  (`level`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `levels` VALUES (0, 0xd09dd0bed0b2d0b8d187d0bed0ba);
INSERT INTO `levels` VALUES (1, 0xd09fd0bed0bbd18cd0b7d0bed0b2d0b0d182d0b5d0bbd18c);
INSERT INTO `levels` VALUES (2, 0xd0a7d0b0d182d182d0b5d180);
INSERT INTO `levels` VALUES (3, 0xd0a2d183d181d0bed0b2d189d0b8d0ba);
INSERT INTO `levels` VALUES (4, 0x562e492e50);
INSERT INTO `levels` VALUES (5, 0xd09ad0b8d0bbd0bbd0b5d180);
INSERT INTO `levels` VALUES (6, 0xd0a1d182d0b0d180d188d0b8d0b920d0bcd0bed0b4d0b5d180);
INSERT INTO `levels` VALUES (7, 0xd090d0b4d0bcd0b8d0bd);
INSERT INTO `levels` VALUES (8, 0xd0a1d183d0bfd0b5d18020d090d0b4d0bcd0b8d0bd);
INSERT INTO `levels` VALUES (9, 0xd0a1d183d0bfd0b5d18020d090d0b4d0bcd0b8d0bd);

CREATE TABLE `setting` (
  `ids` int(1) NOT NULL default '1',
  `link` varchar(200) character set utf8 collate utf8_bin NOT NULL default 'masteram.us',
  `link_name` varchar(50) character set utf8 collate utf8_bin NOT NULL default 'masteram.us',
  `rus` int(1) NOT NULL default '1',
  `reg` int(1) NOT NULL default '1',
  `umnik` varchar(50) character set utf8 collate utf8_bin NOT NULL default 'umnik',
  `shut` varchar(50) character set utf8 collate utf8_bin NOT NULL default 'shut',
  `anek` varchar(50) character set utf8 collate utf8_bin NOT NULL default 'anek',
  `tupica` varchar(50) character set utf8 collate utf8_bin NOT NULL default 'tupica',
  `svaisch` varchar(50) character set utf8 collate utf8_bin NOT NULL default 'svaisch',
  `system` varchar(50) character set utf8 collate utf8_bin NOT NULL default 'system',
  `baryga` varchar(50) character set utf8 collate utf8_bin NOT NULL default 'baryga',
  `znatok` varchar(50) character set utf8 collate utf8_bin NOT NULL default 'znatok',
  `flyder` varchar(50) character set utf8 collate utf8_bin NOT NULL default 'flyder',
  `victint` int(20) NOT NULL default '10',
  `shuttime` int(20) NOT NULL default '1800',
  `znatoktime` int(20) NOT NULL default '1800',
  `anektime` int(20) NOT NULL default '1800',
  `vict` int(1) NOT NULL default '1',
  `cena_answ` int(20) NOT NULL default '100',
  `timesdvig` int(20) NOT NULL default '0',
  `time_aut` int(20) NOT NULL default '300',
  `head` text character set utf8 collate utf8_bin NOT NULL default '',
  `antir` text character set utf8 collate utf8_bin NOT NULL default '',
  `avtorega` int(2) NOT NULL default '0',
  `privat` int(2) NOT NULL default '9',
  `posts_pr` int(20) NOT NULL default '0',
  `posts_vph` int(20) NOT NULL default '0',
  `posts_vus` int(20) NOT NULL default '0',
  `posts_nik` int(20) NOT NULL default '150',
  `size_photo` int(20) NOT NULL default '250',
  `w_photo` int(20) NOT NULL default '0',
  `h_photo` int(20) NOT NULL default '0',
  `size_foto` int(20) NOT NULL default '0',
  `w_foto` int(20) NOT NULL default '0',
  `h_foto` int(20) NOT NULL default '0',
  `w_foto2` int(20) NOT NULL default '0',
  `h_foto2` int(20) NOT NULL default '0',
  `size_img_sten` int(20) NOT NULL default '0',
  `w_img_sten` int(20) NOT NULL default '0',
  `h_img_sten` int(20) NOT NULL default '0',
  `kom_p_posts` int(20) NOT NULL default '0',
  `min_p_posts` int(20) NOT NULL default '0',
  `max_p_posts` int(20) NOT NULL default '0',
  `kom_p_rur` int(20) NOT NULL default '0',
  `min_p_rur` int(20) NOT NULL default '0',
  `max_p_rur` int(20) NOT NULL default '0',
  `kurs_bank_ob` int(20) NOT NULL default '0',
  `size_lich` int(20) NOT NULL default '20',
  `size_video` int(20) NOT NULL default '0',
  `size_audio` int(20) NOT NULL default '0',
  `size_for` int(20) NOT NULL default '0',
  `size_vvod_for` int(20) NOT NULL default '0',
  `for_time_p` int(20) NOT NULL default '0',
  `for_time_t` int(20) NOT NULL default '0',
  `for_cit` int(20) NOT NULL default '0',
  `for_privat` int(20) NOT NULL default '0',
  `kik_notify` int(20) NOT NULL default '0',
  `ban_notify` int(20) NOT NULL default '0',
  `ban2_notify` int(20) NOT NULL default '0',
  `style` varchar(50) character set utf8 collate utf8_bin NOT NULL default 'sasisa',
  `alignpr` varchar(50) character set utf8 collate utf8_bin NOT NULL default 'left',
  `objavs_rur` int(20) NOT NULL default '1',
  `name` varchar(50) character set utf8 collate utf8_bin NOT NULL default 'Вобля.ру',
  PRIMARY KEY  (`ids`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `setting` VALUES (1, 'masteram.us', 'masteram.us', '1', '1', 'umnik', 'shut', 'anek', 'tupica', 'svaisch', 'system', baryga, 'znatok', 'flyder', '10', '1800', '1800', '1800', '1', '100', '0', '300', '', 'реклама', '0', '9', '0', '0', '0', '150', '250', '200', '150', '500', '50', '50', '250', '250', '50', '100', '100', '10', '20', '600', '10', '20', '600', '100', '20', '1024', '1024', '1024', '1024', '15', '60', '200', '9', '1', '1', '1', 'go-wap', 'left', '1', 'voblja.ru');

CREATE TABLE `users` (
  `id` int(20) NOT NULL auto_increment,
  `user` varchar(50) character set utf8 collate utf8_bin NOT NULL default '',
  `pass` varchar(500) character set utf8 collate utf8_bin default NULL,
  `name` varchar(30) character set utf8 collate utf8_bin default NULL,
  `surname` varchar(30) character set utf8 collate utf8_bin default NULL,
  `sex` int(1) NOT NULL default '1',
  `semia` int(1) NOT NULL default '0',
  `day` int(2) NOT NULL default '0',
  `month` int(2) NOT NULL default '0',
  `year` int(5) NOT NULL default '0',
  `politic` int(1) NOT NULL default '0',
  `city` varchar(50) character set utf8 collate utf8_bin NOT NULL default '',
  `country` varchar(50) character set utf8 collate utf8_bin NOT NULL default '',
  `religia` varchar(50) character set utf8 collate utf8_bin NOT NULL default '',
  `mail` varchar(50) character set utf8 collate utf8_bin NOT NULL default '',
  `mobtel` varchar(30) character set utf8 collate utf8_bin default NULL,
  `hometel` varchar(30) character set utf8 collate utf8_bin default NULL,
  `icq` varchar(30) character set utf8 collate utf8_bin default NULL,
  `site` varchar(30) character set utf8 collate utf8_bin default NULL,
  `deiat` blob,
  `interes` blob,
  `likemuz` blob,
  `likefil` blob,
  `liketel` blob,
  `likebook` blob,
  `likegames` blob,
  `likecit` blob,
  `infa` blob,
  `obcoun` varchar(50) character set utf8 collate utf8_bin default NULL,
  `obcity` varchar(50) character set utf8 collate utf8_bin default NULL,
  `school` varchar(50) character set utf8 collate utf8_bin default NULL,
  `vuz` varchar(50) character set utf8 collate utf8_bin default NULL,
  `ptu` varchar(50) character set utf8 collate utf8_bin default NULL,
  `valcoun` varchar(50) character set utf8 collate utf8_bin default NULL,
  `valcity` varchar(50) character set utf8 collate utf8_bin default NULL,
  `val` varchar(50) character set utf8 collate utf8_bin default NULL,
  `valyear1` varchar(50) character set utf8 collate utf8_bin default NULL,
  `valyear2` varchar(50) character set utf8 collate utf8_bin default NULL,
  `position` varchar(50) character set utf8 collate utf8_bin default NULL,
  `milcoun` varchar(50) character set utf8 collate utf8_bin default NULL,
  `milcity` varchar(50) character set utf8 collate utf8_bin default NULL,
  `fsize` varchar(10) character set utf8 collate utf8_bin NOT NULL default 'medium',
  `nastroi` varchar(100) character set utf8 collate utf8_bin NOT NULL default '',
  `ver` varchar(25) character set utf8 collate utf8_bin NOT NULL default '',
  `daya` int(20) NOT NULL default '0',
  `dayp` int(20) NOT NULL default '0',
  `style` varchar(50) character set utf8 collate utf8_bin NOT NULL default 'shaxty-style',
  `xstatus` tinyint(1) NOT NULL default '1',
  `photo` varchar(200) character set utf8 collate utf8_bin NOT NULL default '',
  `vote_photo` int(200) NOT NULL default '0',
  `credits` int(20) NOT NULL default '0',
  `gposts` int(20) NOT NULL default '0',
  `translit` tinyint(1) NOT NULL default '0',
  `visit` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `ruser` varchar(30) character set utf8 collate utf8_bin NOT NULL default '',
  `onl` int(20) NOT NULL default '0',
  `posts` int(20) NOT NULL default '0',
  `status` varchar(100) character set utf8 collate utf8_bin NOT NULL default 'User',
  `date` varchar(50) character set utf8 collate utf8_bin default NULL,
  `timereg` varchar(50) character set utf8 collate utf8_bin default NULL,
  `max` int(2) NOT NULL default '10',
  `max_pr` int(2) NOT NULL default '5',
  `pole1` int(2) NOT NULL default '2',
  `pole2` int(2) NOT NULL default '20',
  `pic_stat` int(2) NOT NULL default '1',
  `level` int(6) NOT NULL default '0',
  `user_ip` varchar(20) character set utf8 collate utf8_bin NOT NULL default '',
  `user_soft` varchar(200) character set utf8 collate utf8_bin NOT NULL default '',
  `inv` tinyint(1) NOT NULL default '0',
  `kik` int(20) NOT NULL default '0',
  `whokik` varchar(20) character set utf8 collate utf8_bin NOT NULL default '',
  `whykik` varchar(200) character set utf8 collate utf8_bin NOT NULL default '',
  `bann` int(20) NOT NULL default '0',
  `whobann` varchar(20) character set utf8 collate utf8_bin NOT NULL default '',
  `whybann` varchar(200) character set utf8 collate utf8_bin NOT NULL default '',
  `byeotv` int(20) NOT NULL default '0',
  `alltraf` varchar(255) character set utf8 collate utf8_bin NOT NULL default '0',
  `lasttraf` varchar(255) character set utf8 collate utf8_bin NOT NULL default '0',
  `costtraf` int(255) NOT NULL default '0',
  `creditsingame` int(20) NOT NULL default '0',
  `mafcredits` int(20) NOT NULL default '0',
  `avtootvet` blob NOT NULL,
  `binds` varchar(255) character set utf8 collate utf8_bin NOT NULL default '',
  `para` varchar(50) character set utf8 collate utf8_bin NOT NULL default '',
  `myavatar` varchar(50) character set utf8 collate utf8_bin NOT NULL default '',
  `anketa` varchar(255) character set utf8 collate utf8_bin NOT NULL default '',
  `rur` int(20) NOT NULL default '0',
  `rurmag` int(20) NOT NULL default '0',
  `postsf` int(20) NOT NULL default '0',
  `vote_us` int(20) NOT NULL default '0',
  `poias` varchar(50) character set utf8 collate utf8_bin NOT NULL default '',
  `pp_m_s` int(2) NOT NULL default '0',
  `pp_c_fr` int(2) NOT NULL default '0',
  `pp_c_st` int(2) NOT NULL default '0',
  `pp_st_s` int(2) NOT NULL default '0',
  `pp_f_s` int(2) NOT NULL default '0',
  `pp_al` int(2) NOT NULL default '0',
  `pp_al_k` int(2) NOT NULL default '0',
  `pp_gifts` int(2) NOT NULL default '0',
  `fr_notify` int(2) NOT NULL default '1',
  `pm_notify` int(2) NOT NULL default '1',
  `st_notify` int(2) NOT NULL default '1',
  `ph_notify` int(2) NOT NULL default '1',
  `gr_notify` int(2) NOT NULL default '1',
  `gifts_notify` int(2) NOT NULL default '1',
  `avr` int(20) NOT NULL default '0',
  `color_nik` varchar(50) character set utf8 collate utf8_bin NOT NULL default '',
  `effnik` varchar(50) character set utf8 collate utf8_bin NOT NULL default '',
  `odobr` int(2) NOT NULL default '0',
  `razd` int(2) NOT NULL default '1',
  `forma` int(2) NOT NULL default '1',
  `redp` int(2) NOT NULL default '1',
  `formf` int(2) NOT NULL default '1',
  `sizep` int(2) NOT NULL default '512',
  `diaries` int(20) NOT NULL default '0',
  `viz` int(20) NOT NULL default '0',

  `dd` int(20) NOT NULL default '1',
  `emo` int(20) NOT NULL default '1',
  `color` int(20) NOT NULL default '1',
  `softk` int(20) NOT NULL default '0',
  `polevv` int(2) NOT NULL default '2',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=0 ;


ALTER TABLE `users` ADD `email` varchar(50) character set utf8 collate utf8_bin NOT NULL default '';

CREATE TABLE `bannlist` (
  `id` int(20) NOT NULL auto_increment,
  `ip` varchar(255) character set utf8 collate utf8_bin NOT NULL default '',
  `soft` varchar(255) character set utf8 collate utf8_bin NOT NULL default '',
  `user_id` varchar(255) character set utf8 collate utf8_bin NOT NULL default '',
  `who_id` varchar(255) character set utf8 collate utf8_bin NOT NULL default '',
  `why` varchar(255) character set utf8 collate utf8_bin NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;


CREATE TABLE `rooms` (
  `rm` int(255) NOT NULL auto_increment,
  `name` varchar(255) character set utf8 collate utf8_bin NOT NULL default '',
  `topic` varchar(255) character set utf8 collate utf8_bin NOT NULL default '',
  `umnik` tinyint(1) NOT NULL default '0',
  `shut` tinyint(1) NOT NULL default '1',
  `anek` tinyint(1) NOT NULL default '1',
  `tupica` tinyint(1) NOT NULL default '0',
  `svaisch` tinyint(1) NOT NULL default '0',
  `system` tinyint(1) NOT NULL default '1',
  `baryga` tinyint(1) NOT NULL default '0',
  `znatok` tinyint(1) NOT NULL default '1',
  `flyder` tinyint(1) NOT NULL default '1',
  `flyd` tinyint(5) NOT NULL default '0',
  `antir` tinyint(1) NOT NULL default '1',
  `antim` tinyint(1) NOT NULL default '1',
  `pinban` tinyint(1) NOT NULL default '1',
  `sartir` tinyint(1) NOT NULL default '0',
  `intim` tinyint(1) NOT NULL default '1',

  `inkog` tinyint(1) NOT NULL default '1',
  `level` tinyint(1) NOT NULL default '0',
  `pos` tinyint(255) NOT NULL default '0',
  PRIMARY KEY  (`rm`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=0;


CREATE TABLE `who` (
  `id` int(20) NOT NULL auto_increment,
  `user` int(20) NOT NULL default '0',
  `time` varchar(40) character set utf8 collate utf8_bin NOT NULL default '',
  `room` varchar(40) character set utf8 collate utf8_bin NOT NULL default '',
  `rm` int(20) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=0 ;


CREATE TABLE `message` (
  `id` int(255) NOT NULL auto_increment,
  `user` varchar(40) character set utf8 collate utf8_bin NOT NULL,
  `user_id` int(20) NOT NULL default '0',
  `komu` varchar(40) character set utf8 collate utf8_bin NOT NULL default '0',
  `time` varchar(40) character set utf8 collate utf8_bin NOT NULL,
  `msg` blob,
  `rm` int(20) NOT NULL default '0',
  `emo` int(20) NOT NULL default '0',
  `bb` int(20) NOT NULL default '0',
  `color` int(20) NOT NULL default '0',
  `privat` int(20) NOT NULL default '0',
  `inps` int(20) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=0 ;


DROP TABLE `vopros`;
CREATE TABLE `vopros` (
  `ids` tinyint(1) NOT NULL default '0',
  `number` int(11) NOT NULL default '0',
  `time` int(11) NOT NULL default '0',
  `question` blob NOT NULL,
  `answer` varchar(100) character set utf8 collate utf8_bin NOT NULL default '',
  `tran` varchar(100) character set utf8 collate utf8_bin NOT NULL default '',
  PRIMARY KEY  (`ids`)
) TYPE=MyISAM;
INSERT INTO `vopros` (`ids`, `number`, `time`, `question`, `answer`, `tran`) VALUES (1, 5, 1174384141, 0xd094d180d0b5d0b2d0bdd0b5d0b3d180d0b5d187d0b5d181d0bad0b0d18f20d182d0b5d180d180d0b8d182d0bed180d0b8d18f20d0bdd0b020d0bcd0b0d0bbd0bed0b0d0b7d0b8d0b9d181d0bad0bed0bc20d0bfd0bed0b1d0b5d180d0b5d0b6d18cd0b520d0add0b3d0b5d0b9d181d0bad0bed0b3d0be20d0bcd0bed180d18f2e20283c623e3520d0b1d183d0bad0b23c2f623e29, '', ''),
(2, 0, 1174346903, 0x3c623ed092d0bed0bfd180d0bed1813a3c2f623e20d093d0bed180d0b1d0b0d182d18bd0b920d187d0b5d0bbd0bed0b2d0b5d0ba2e2028d0b1d183d0bad0b220d0bcd0b0d0bbd0be2e20d098d0bbd0b820d0bcd0bdd0bed0b3d0be2e20d09ad0bed180d0bed187d0b520d0bfd0bed185d183d0b92e29, 0xd0b3d0bed180d0b1d183d0bd, 0x676f7262756e);
DROP TABLE `bots`;
CREATE TABLE `question` (
  `number` int(5) NOT NULL default '0',
  `vopros` blob NOT NULL,
  `answer` varchar(100) character set utf8 collate utf8_bin NOT NULL default '',
  `tran` varchar(60) character set utf8 collate utf8_bin NOT NULL default '',
  PRIMARY KEY  (`number`)
) TYPE=MyISAM;


CREATE TABLE `botst` (
  `id` int(5) NOT NULL default '0',
  `shut` varchar(100) character set utf8 collate utf8_bin NOT NULL default '',
  `znatok` varchar(100) character set utf8 collate utf8_bin NOT NULL default '',
  `anek` varchar(100) character set utf8 collate utf8_bin NOT NULL default '',
  `tupica` varchar(100) character set utf8 collate utf8_bin NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

INSERT INTO `botst` VALUES (1, 0, 0, 0, 0);

CREATE TABLE `shutki` (
  `ids` int(11) NOT NULL auto_increment,
  `message` blob NOT NULL,
  PRIMARY KEY  (`ids`)
) TYPE=MyISAM AUTO_INCREMENT=0 ;

CREATE TABLE `anekdot` (
  `ids` int(11) NOT NULL auto_increment,
  `message` blob NOT NULL,
  `who` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ids`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `frazi` (
  `ids` int(11) NOT NULL auto_increment,
  `message` blob NOT NULL,
  PRIMARY KEY  (`ids`)
) TYPE=MyISAM AUTO_INCREMENT=0 ;

CREATE TABLE `chislo` (
  `id` int(11) NOT NULL auto_increment,
  `chislo` varchar(100) character set utf8 collate utf8_bin NOT NULL default '',
   `ip` varchar(255) character set utf8 collate utf8_bin NOT NULL default '',
    PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=0 ;

CREATE TABLE `privat` (
  `id` int(255) NOT NULL auto_increment,
  `user` varchar(40) binary NOT NULL default '',
  `user_id` int(12) NOT NULL default '0',
  `msg` blob NOT NULL,
  `to_user` varchar(40) binary NOT NULL default '',
  `to_id` int(12) NOT NULL default '0',
  `time` int(11) NOT NULL default '0',
  `readin` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=0 ;

CREATE TABLE `xstatus` (
  `id` int( 11 ) NOT NULL AUTO_INCREMENT ,
  `user` text CHARACTER SET utf8 NOT NULL ,
  `stat` text CHARACTER SET utf8 NOT NULL ,
  `name` text CHARACTER SET utf8 NOT NULL ,
  `content` text CHARACTER SET utf8 NOT NULL ,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=0 ;


CREATE TABLE `vote_photo` (
  `id` int(20) NOT NULL auto_increment,
  `user_id` int(20) NOT NULL default '0',
  `vote_id` int(20) NOT NULL default '0',
  `znak` int(20) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=0 ;

CREATE TABLE `komm_photo` (
  `id` int(20) NOT NULL auto_increment,
  `user_id` int(20) NOT NULL default '0',
  `mgs_id` int(20) NOT NULL default '0',
  `msg` blob NOT NULL,
  `time` int(20) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=0 ;

CREATE TABLE `stena` (
  `id` int(20) NOT NULL auto_increment,
  `user_id` int(20) NOT NULL default '0',
  `mgs_id` int(20) NOT NULL default '0',
  `msg` blob NOT NULL,
  `time` int(20) NOT NULL default '0',
  `img` text CHARACTER SET utf8 NOT NULL ,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=0 ;

CREATE TABLE `vote_us` (
  `id` int(20) NOT NULL auto_increment,
  `user_id` int(20) NOT NULL default '0',
  `vote_id` int(20) NOT NULL default '0',
  `znak` int(20) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=0 ;

CREATE TABLE `opinions` (
  `id` int(20) NOT NULL auto_increment,
  `user_id` int(20) NOT NULL default '0',
  `mgs_id` int(20) NOT NULL default '0',
  `msg` blob NOT NULL,
  `time` int(20) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=0 ;

CREATE TABLE `questions` (
  `id` int(20) NOT NULL auto_increment,
  `user_id` int(20) NOT NULL default '0',
  `vote` blob NOT NULL,
  `vars` text CHARACTER SET utf8 NOT NULL ,
  `time` int(20) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=0 ;


CREATE TABLE `perevod` (
  `id` int(11) NOT NULL auto_increment,
  `tip` varchar(100) character set utf8 collate utf8_bin NOT NULL default '',
  `user_id` int(20) NOT NULL default '0',
  `to_id` int(20) NOT NULL default '0',
  `kol` int(20) NOT NULL default '0',
  `time` int(20) NOT NULL default '0',
  `kom` text CHARACTER SET utf8 NOT NULL ,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=0 ;

CREATE TABLE `foto_add` (
  `id` int(11) NOT NULL auto_increment,
  `user_id` text NOT NULL,
  `kom` text NOT NULL,
  `album` int(20) NOT NULL default '0',
  `prosm` int(20) NOT NULL default '0',
  `time`  text CHARACTER SET utf8 NOT NULL,
  `adres`  text CHARACTER SET utf8 NOT NULL,
  `format`  text CHARACTER SET utf8 NOT NULL,
  `razmer`  text CHARACTER SET utf8 NOT NULL,
  `level` int(20) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE `foto_albom` (
  `id` int(20) NOT NULL auto_increment,
  `name` text CHARACTER SET utf8 NOT NULL ,
  `user_id` int(11) NOT NULL default '0',
  `kom` text CHARACTER SET utf8 NOT NULL ,
  `level` int(2) NOT NULL default '0',
  `pp_al` int(2) NOT NULL default '0',
  `pp_al_k` int(2) NOT NULL default '0',
  `time_s` int(20) NOT NULL default '0',
  `time_izm` int(20) NOT NULL default '0',
  `prosm` int(20) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE `foto_komm` (
  `id` int(20) NOT NULL auto_increment,
  `user_id` int(20) NOT NULL default '0',
  `mgs_id` int(20) NOT NULL default '0',
  `msg` blob NOT NULL,
  `time` int(20) NOT NULL default '0',
  `foto` int(20) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=0 ;

CREATE TABLE IF NOT EXISTS `opsos` (
  `min` bigint(11) default NULL,
  `max` bigint(11) default NULL,
  `opsos` varchar(64) default NULL,
  KEY `min` (`min`,`max`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `opsos` (`min`, `max`, `opsos`) VALUES
(3274702592, 3274702847, 'Kcel'),
(1333559296, 1333575679, 'life:)'),
(-734354944, -734354433, 'life:)'),
(3582431104, 3582434943, 'TambovGSM'),
(1358905344, 1358905471, 'UMC'),
(1490444288, 1490452479, 'UMC'),
(1490436096, 1490444287, 'UMC'),
(3588472832, 3588489215, 'WellCOM GSM'),
(3253698560, 3253699071, 'WellCOM GSM'),
(3557661440, 3557661695, 'КаР-Тел'),
(3240705024, 3240706047, 'Киевстар'),
(1360467968, 1360470015, 'Киевстар'),
(1360465920, 1360467967, 'Киевстар'),
(1402278912, 1402279935, 'МегаФон'),
(1402286080, 1402287103, 'МегаФон'),
(1402273792, 1402275839, 'MegaFon'),
(3650368512, 3650368767, 'МОТИВ'),
(1410459648, 1410460159, 'МТС'),
(3641237504, 3641241599, 'МТС'),
(3276428288, 3276428543, 'МТС'),
(3258356736, 3258357759, 'МТС'),
(3562834880, 3562834943, 'МТС'),
(3579259392, 3579265535, 'МТС'),
(1347674112, 1347678207, 'МТС'),
(3579267072, 3579267935, 'МТС'),
(1358906880, 1358907135, 'МТС'),
(1476194816, 1476195071, 'МТС'),
(1372794624, 1372794879, 'МТС'),
(3642047744, 3642047999, 'МТС'),
(3579269120, 3579273215, 'МТС'),
(3277188608, 3277188863, 'МТС'),
(3645018112, 3645019135, 'МТС'),
(1347126528, 1347127167, 'МТС'),
(3281465344, 3281465599, 'МТС'),
(1360933376, 1360933887, 'МТС'),
(3647698432, 3647698687, 'МТС'),
(3267023360, 3267023488, 'МТС'),
(1535627776, 1535628031, 'МТС'),
(1410457600, 1410459647, 'МТС'),
(1433788416, 1433788671, 'МТС'),
(1389383040, 1389383167, 'НСС'),
(1358122240, 1358123007, 'НТК'),
(1358118912, 1358119423, 'НТК'),
(1438682304, 1438682335, 'Оренбург-GSM'),
(1509752832, 1509756927, 'Скай Линк'),
(3565250560, 3565254655, 'Скай Линк'),
(1536507904, 1536516095, 'Скай Линк'),
(1536516096, 1536518143, 'Скай Линк'),
(3578853376, 3578854079, 'Скай Линк'),
(1406738432, 1406739967, 'Скай Линк'),
(3266342656, 3266342911, 'Скай Мобайл'),
(1346736128, 1346737151, 'СМАРТС'),
(3260286336, 3260286463, 'СМАРТС'),
(1509527552, 1509528575, 'СТеК Джи Эс Эм'),
(1506762752, 1506764799, 'ТАТИНКОМ-Т'),
(1404203008, 1404211199, 'Теле2'),
(3580231936, 3580232191, 'Теле2'),
(1404215296, 1404219391, 'Теле2'),
(1404874752, 1404875775, 'Теле2'),
(1404189184, 1404189695, 'Теле2'),
(1404829696, 1404837887, 'Теле2'),
(3580236800, 3580237567, 'Теле2'),
(3580235264, 3580235775, 'Теле2'),
(1404837888, 1404846079, 'Теле2'),
(3580214272, 3580214783, 'Теле2'),
(1404227584, 1404232191, 'Теле2'),
(3580232448, 3580233215, 'Теле2'),
(3580239360, 3580239871, 'Теле2'),
(3580231680, 3580231935, 'Теле2'),
(1441366016, 1441371903, 'Utel'),
(1401450496, 1401450751, 'Utel'),
(1506570240, 1506574335, 'Utel'),
(3571187712, 3571191807, 'Utel'),
(3564676832, 3564676863, 'Utel'),
(1494507776, 1494508031, 'Utel'),
(3641816064, 3641816319, 'Utel'),
(3651755008, 3651756031, 'Цифровая экспансия'),
(2130706433, 2130706433, 'localhost'),
(3283979853, 3283979853, 'Opera Mini'),
(1412413440, 1412413951, 'Наука-Связь'),
(1518993408, 1519058943, 'Теле2'),
(1410269184, 1410334719, 'Bite GSM'),
(1407907840, 1407908351, 'Ульяновск-GSM'),
(2197028864, 2197094399, 'Теле2'),
(3274702592, 3274702847, 'Kcel'),
(-734351360, -734347265, 'life:)'),
(-734353408, -734351361, 'life:)'),
(3582431104, 3582434943, 'TambovGSM'),
(1358905344, 1358905471, 'UMC'),
(1490444288, 1490452479, 'UMC'),
(1490436096, 1490444287, 'UMC'),
(3588472832, 3588489215, 'WellCOM GSM'),
(3253698560, 3253699071, 'WellCOM GSM'),
(3557661440, 3557661695, 'КаР-Тел'),
(3240705024, 3240706047, 'Киевстар'),
(1360467968, 1360470015, 'Киевстар'),
(1360465920, 1360467967, 'Киевстар'),
(1402275840, 1402276863, 'МегаФон'),
(1402278912, 1402279935, 'МегаФон'),
(1402286080, 1402287103, 'МегаФон'),
(1402273792, 1402275839, 'МегаФон'),
(1346621440, 1346622463, 'МегаФон'),
(3251233792, 3251234815, 'МегаФон'),
(1402284032, 1402285055, 'МегаФон'),
(1402281984, 1402283007, 'МегаФон'),
(1402287104, 1402288127, 'МегаФон'),
(1402279936, 1402280959, 'МегаФон'),
(1402277888, 1402278911, 'МегаФон'),
(3650368512, 3650368767, 'МОТИВ'),
(1410459648, 1410460159, 'МТС'),
(3641237504, 3641241599, 'МТС'),
(3276428288, 3276428543, 'МТС'),
(3258356736, 3258357759, 'МТС'),
(3562834880, 3562834943, 'МТС'),
(3579259392, 3579265535, 'МТС'),
(1347674112, 1347678207, 'МТС'),
(3579267072, 3579267935, 'МТС'),
(1358906880, 1358907135, 'МТС'),
(1476194816, 1476195071, 'МТС'),
(1372794624, 1372794879, 'МТС'),
(3642047744, 3642047999, 'МТС'),
(3579269120, 3579273215, 'МТС'),
(3277188608, 3277188863, 'МТС'),
(3645018112, 3645019135, 'МТС'),
(1347126528, 1347127167, 'МТС'),
(3281465344, 3281465599, 'МТС'),
(1360933376, 1360933887, 'МТС'),
(3647698432, 3647698687, 'МТС'),
(3267023360, 3267023488, 'МТС'),
(3645566976, 3645569023, 'МТС'),
(1535627776, 1535628031, 'МТС'),
(1410457600, 1410459647, 'МТС'),
(1433788416, 1433788671, 'МТС'),
(1389383040, 1389383167, 'НСС'),
(1358122240, 1358123007, 'НТК'),
(1358118912, 1358119423, 'НТК'),
(1438682304, 1438682335, 'Оренбург-GSM'),
(1509752832, 1509756927, 'Скай Линк'),
(3565250560, 3565254655, 'Скай Линк'),
(1536507904, 1536516095, 'Скай Линк'),
(1536516096, 1536518143, 'Скай Линк'),
(3578853376, 3578854079, 'Скай Линк'),
(1406738432, 1406739967, 'Скай Линк'),
(3266342656, 3266342911, 'Скай Мобайл'),
(1346736128, 1346737151, 'СМАРТС'),
(3260286336, 3260286463, 'СМАРТС'),
(1509527552, 1509528575, 'СТеК Джи Эс Эм'),
(1506762752, 1506764799, 'ТАТИНКОМ-Т'),
(1404203008, 1404211199, 'Теле2'),
(3580231936, 3580232191, 'Теле2'),
(1404215296, 1404219391, 'Теле2'),
(1404874752, 1404875775, 'Теле2'),
(1404189184, 1404189695, 'Теле2'),
(1404829696, 1404837887, 'Теле2'),
(3580236800, 3580237567, 'Теле2'),
(3580235264, 3580235775, 'Теле2'),
(1404837888, 1404846079, 'Теле2'),
(3580214272, 3580214783, 'Теле2'),
(1404227584, 1404232191, 'Теле2'),
(3580232448, 3580233215, 'Теле2'),
(3580239360, 3580239871, 'Теле2'),
(3580231680, 3580231935, 'Теле2'),
(1441366016, 1441371903, 'Utel'),
(1401450496, 1401450751, 'Utel'),
(1506570240, 1506574335, 'Utel'),
(3571187712, 3571191807, 'Utel'),
(3564676832, 3564676863, 'Utel'),
(1494507776, 1494508031, 'Utel'),
(3641816064, 3641816319, 'Utel'),
(3651755008, 3651756031, 'Цифровая экспансия'),
(2130706433, 2130706433, 'localhost'),
(3283979853, 3283979853, 'Opera Mini'),
(1412413440, 1412413951, 'Наука-Связь'),
(3588390912, 3588391935, 'Bite GSM'),
(1518993408, 1519058943, 'Теле2'),
(1410269184, 1410334719, 'Bite GSM'),
(1407907840, 1407908351, 'Ульяновск-GSM'),
(2197028864, 2197094399, 'Теле2'),
(-646557696, -646556673, 'Beeline'),
(3274702592, 3274702847, 'K cel'),
(-712536192, -712532353, 'TambovGSM'),
(1333575680, 1333592063, 'life:)'),
(-734355456, -734355201, 'life:)'),
(1536278528, 1536294911, 'Life:)'),
(3582431104, 3582434943, 'TambovGSM'),
(1358905344, 1358905471, 'UMC'),
(1490444288, 1490452479, 'UMC'),
(1490436096, 1490444287, 'UMC'),
(3588472832, 3588489215, 'WellCOM GSM'),
(3253698560, 3253699071, 'WellCOM GSM'),
(1519796224, 1519800319, 'Уралсвязьинформ'),
(1388849152, 1388850175, 'ИНДИГО'),
(1427948288, 1427948543, 'Дальсвязь'),
(1385632000, 1385632255, 'БашСЕЛ'),
(3273026560, 3273027583, 'БашСЕЛ'),
(1347599104, 1347599359, 'Байкалвестком'),
(1360162816, 1360166911, 'Байкалвестком'),
(1360163840, 1360164351, 'Байкалвестком'),
(3588519936, 3588520447, 'Байкалвестком'),
(1407888896, 1407889151, 'Байкалвестком'),
(3564188672, 3564188927, 'Utel'),
(3564189696, 3564191743, 'Utel'),
(1441366016, 1441371903, 'Utel'),
(1401450496, 1401450751, 'Utel'),
(1506570240, 1506574335, 'Utel'),
(3571187712, 3571191807, 'Utel'),
(3564676832, 3564676863, 'Utel'),
(1494507776, 1494508031, 'Utel'),
(3641816064, 3641816319, 'Utel'),
(3564189440, 3564189695, 'Utel'),
(2130706433, 2130706433, 'localhost'),
(3283979853, 3283979853, 'Opera Mini'),
(3588390912, 3588391935, 'Bite GSM'),
(3585764352, 3585764607, 'Utel'),
(1410269184, 1410334719, 'Bite GSM'),
(3564189184, 3564189439, 'Utel'),
(3582031776, 3582031807, 'Мегафон'),
(1427812352, 1427813375, 'Мегафон'),
(1433657344, 1433657599, 'Билайн'),
(3648405504, 3648406527, 'Билайн'),
(3648406528, 3648407551, 'Билайн'),
(3648408576, 3648409599, 'Билайн'),
(3648409600, 3648410623, 'Билайн'),
(3648410624, 3648411647, 'Билайн'),
(3648411648, 3648412671, 'Билайн'),
(3648412672, 3648413695, 'Билайн'),
(1047070464, 1047072255, 'Utel'),
(1401451520, 1401451775, 'Utel'),
(1425981440, 1425997823, 'Utel'),
(3272364544, 3272364799, 'Utel'),
(3564675072, 3564675583, 'Utel'),
(3641816576, 3641816831, 'Utel'),
(1519779840, 1519910911, 'Utel'),
(3274599168, 3274599423, 'БайкалВестКом'),
(1042394624, 1042394879, 'МТС'),
(1346950400, 1346950655, 'МТС'),
(3281453056, 3281518591, 'МТС'),
(3287259392, 3287259647, 'МТС'),
(3559689216, 3559689471, 'МТС'),
(3562834688, 3562834879, 'МТС'),
(3578831872, 3578832127, 'МТС'),
(3648478720, 3648479231, 'МТС'),
(3579268096, 3579268607, 'МТС'),
(1404862464, 1404870655, 'Tele2'),
(1404846080, 1404854271, 'Tele2'),
(1404854272, 1404862463, 'Tele2'),
(1518927872, 1518944255, 'Tele2'),
(3650367488, 3650368511, 'Мотив'),
(3278955480, 3278955515, 'ЕТК'),
(3278956288, 3278956543, 'ЕТК'),
(3278960128, 3278960383, 'ЕТК'),
(1432330240, 1432334335, 'НСС'),
(3282161664, 3282163711, 'НСС'),
(3282171904, 3282173951, 'НСС'),
(3585171456, 3585174271, 'НСС'),
(3267008512, 3267008767, 'НСС'),
(3277992448, 3277992959, 'НСС'),
(1441609984, 1441610239, 'НСС'),
(3645731072, 3645731079, 'Смартс'),
(1310210048, 1310211071, 'Смартс'),
(1536099328, 1536099839, 'Смартс'),
(3587219456, 3587219711, 'Смартс'),
(3648294912, 3648295935, 'Stek GSM'),
(1481787392, 1481787647, 'Татинком-Т'),
(3652001536, 3652001599, 'Татинком-Т'),
(1052193280, 1052193535, 'MTT'),
(1347125248, 1347125759, 'MTT'),
(1358119424, 1358120703, 'НТК'),
(1406740480, 1406746623, 'Sky Link'),
(3564593152, 3564593919, 'Sky Link'),
(3564595968, 3564596735, 'Sky Link'),
(3564599808, 3564601343, 'Sky Link'),
(3565248512, 3565250047, 'Sky Link'),
(3565250048, 3565250559, 'Sky Link'),
(3648212992, 3648217087, 'Sky Link'),
(1386348544, 1386414079, 'Акос'),
(1566410752, 1566411775, 'Ульяновск GSM'),
(3651751936, 3651752191, 'Цифровая экспансия'),
(3651752192, 3651752447, 'Цифровая экспансия'),
(3287244288, 3287244543, 'Индиго'),
(3560612864, 3560613887, 'Киевстар'),
(1486487552, 1486553087, 'Киевстар'),
(1295253504, 1295319039, 'UMC'),
(1358907392, 1358907647, 'UMC'),
(1358907648, 1358907903, 'UMC'),
(1358907904, 1358908031, 'UMC'),
(1358908160, 1358908415, 'UMC'),
(1358908416, 1358908671, 'UMC'),
(1358908672, 1358908927, 'UMC'),
(1358908928, 1358909183, 'UMC'),
(1358909184, 1358909439, 'UMC'),
(2516451328, 2516516863, 'T-Mobile'),
(3562889472, 3562889727, 'LMT'),
(3651710976, 3651715071, 'AzerCellTelecom'),
(1365222400, 1365223423, 'Ge-Magticom'),
(3645744128, 3645744639, 'Vodafon'),
(3584180736, 3584180991, 'T-Mobile'),
(1358192896, 1358193151, 'Vodafon'),
(1507835904, 1507852287, 'Vodafon'),
(1507819520, 1507827711, 'Vodafon'),
(1507827712, 1507835903, 'Vodafon'),
(1536655360, 1536659455, 'Geocell'),
(3253712384, 3253712895, 'Voxtel'),
(3560144384, 3560144639, 'Mobtel'),
(3644964864, 3644965479, 'T-Mobile'),
(1054471936, 1054472191, 'Orange'),
(3275173632, 3275173695, 'TME'),
(1404190720, 1404198911, 'Tele2'),
(3583496320, 3583496447, 'Orange'),
(3266322432, 3266322687, 'Omnitel'),
(1407033600, 1407033855, 'Unitel'),
(3568795648, 3568799999, 'Vodafon'),
(1407188992, 1407210495, 'Vodafon'),
(3645317120, 3645318015, 'EMT'),
(3240329216, 3240333311, 'Orange'),
(3254619392, 3254619647, 'Orange'),
(1358598144, 1358600191, 'Cellcom'),
(1296285696, 1296302079, 'Tcell'),
(3576365056, 3576397823, 'Tcell'),
(1449959424, 1449967615, 'Tcell'),
(1336598528, 1336599521, 'Mordcell'),
(3566895360, 3566895615, 'МТС'),
(3279123456, 3279124479, 'SRR'),
(3652165632, 3652167167, 'OutRemer'),
(3283979776, 3283980287, 'Opera Mini'),
(3242554368, 3242554495, 'Opera Mini'),
(1357411584, 1357411839, 'Opera Mini'),
(1540055040, 1540056063, 'Opera Mini'),
(1593212416, 1593212927, 'Opera Mini'),
(-1010987520, -1010987009, 'Opera Mini'),
(-646555136, -646554369, 'Вымпелком'),
(-646554368, -646553857, 'Вымпелком WiFi');

CREATE TABLE `bannip` (
  `id` int(10) NOT NULL auto_increment,
  `ip` varchar(20) NOT NULL,
  `who_id` int(20) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE `vklads` (
  `id` int(20) NOT NULL auto_increment,
  `user_id` int(20) NOT NULL default '0',
  `vklad` int(20) NOT NULL default '0',
  `kol` int(20) NOT NULL default '0',
  `time` int(20) NOT NULL default '0',
  `srok` int(20) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=0 ;

CREATE TABLE `gifts` (
  `id` int(20) NOT NULL auto_increment,
  `user_id` int(20) NOT NULL default '0',
  `gift_id` int(20) NOT NULL default '0',
  `time` int(20) NOT NULL default '0',
  `kom` text CHARACTER SET utf8 NOT NULL ,
  `gift` text CHARACTER SET utf8 NOT NULL ,
  `anonim` int(20) NOT NULL default '0',
  `publ` int(20) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=0 ;

CREATE TABLE `news` (
  `id` int(20) NOT NULL auto_increment,
  `user_id` int(20) NOT NULL default '0',
  `time` int(20) NOT NULL default '0',
  `msg` text CHARACTER SET utf8 NOT NULL ,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=0 ;

CREATE TABLE `newskom` (
  `id` int(20) NOT NULL auto_increment,
  `new` int(20) NOT NULL default '0',
  `user_id` int(20) NOT NULL default '0',
  `time` int(20) NOT NULL default '0',
  `msg` text CHARACTER SET utf8 NOT NULL ,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=0 ;

-- ------------------------------------------------------------
CREATE TABLE `forum_b` (
  `id` int(11) NOT NULL auto_increment,
  `t_id` text NOT NULL,
  `time` text NOT NULL,
  `user_id` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE `forum_msg` (
  `id` int(11) NOT NULL auto_increment,
  `f_id` int(11) NOT NULL,
  `r_id` int(11) NOT NULL,
  `t_id` int(11) NOT NULL,
  `user_id` text NOT NULL,
  `msg` text NOT NULL,
  `time` text NOT NULL,
  `file` text NOT NULL,
  `fname` text NOT NULL,
  `fsize` text NOT NULL,
  `sfile` int(11) NOT NULL default '0',
  `izm` text NOT NULL,
  `izmk` text NOT NULL,
  `cit` text NOT NULL,
  `privat` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE `forum_s` (
  `id` int(11) NOT NULL auto_increment,
  `search` text NOT NULL,
  `time` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE `forum_f` (
  `id` int(11) NOT NULL auto_increment,
  `name` text NOT NULL,
  `time` int(11) NOT NULL default '0',
  `pos` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE `forum_r` (
  `id` int(11) NOT NULL auto_increment,
  `f_id` int(11) NOT NULL default '0',
  `name` text NOT NULL,
  `pos` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE `forum_t` (
  `id` int(11) NOT NULL auto_increment,
  `f_id` int(11) NOT NULL,
  `r_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `name` text NOT NULL,
  `close` int(11) NOT NULL default '0',
  `time` int(11) NOT NULL default '0',
  `zak` int(11) NOT NULL default '0',
  `privat` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE `audio` (
  `id` int(11) NOT NULL auto_increment,
  `user_id` text NOT NULL,
  `name` text NOT NULL,
  `kom` text NOT NULL,
  `prosm` int(20) NOT NULL default '0',
  `time`  text CHARACTER SET utf8 NOT NULL,
  `adres`  text CHARACTER SET utf8 NOT NULL,
  `format`  text CHARACTER SET utf8 NOT NULL,
  `razmer`  text CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE `audio_komm` (
  `id` int(20) NOT NULL auto_increment,
  `user_id` int(20) NOT NULL default '0',
  `mgs_id` int(20) NOT NULL default '0',
  `msg` blob NOT NULL,
  `time` int(20) NOT NULL default '0',
  `audio` int(20) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=0 ;

CREATE TABLE `video` (
  `id` int(11) NOT NULL auto_increment,
  `user_id` text NOT NULL,
  `name` text NOT NULL,
  `kom` text NOT NULL,
  `prosm` int(20) NOT NULL default '0',
  `time`  text CHARACTER SET utf8 NOT NULL,
  `adres`  text CHARACTER SET utf8 NOT NULL,
  `format`  text CHARACTER SET utf8 NOT NULL,
  `razmer`  text CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE `video_komm` (
  `id` int(20) NOT NULL auto_increment,
  `user_id` int(20) NOT NULL default '0',
  `mgs_id` int(20) NOT NULL default '0',
  `msg` blob NOT NULL,
  `time` int(20) NOT NULL default '0',
  `video` int(20) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=0 ;

CREATE TABLE `oko` (
  `id` int(20) NOT NULL auto_increment,
  `user_id` int(20) NOT NULL default '0',
  `who_id` int(20) NOT NULL default '0',
  `msg` blob NOT NULL,
  `time` int(20) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=0 ;

CREATE TABLE `diaries` (
  `id` int(20) NOT NULL auto_increment,
  `user_id` int(20) NOT NULL default '0',
  `name` blob NOT NULL,
  `msg` blob NOT NULL,
  `time` int(20) NOT NULL default '0',
  `chit` int(20) NOT NULL default '0',
  `vote` int(20) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=0 ;

CREATE TABLE `vote_diaries` (
  `id` int(20) NOT NULL auto_increment,
  `vote_id` int(20) NOT NULL default '0',
  `did` int(20) NOT NULL default '0',
  `znak` int(20) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=0 ;

CREATE TABLE `board` (
  `id` int(20) NOT NULL auto_increment,
  `name` text NOT NULL,
  `who` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=0 ;

CREATE TABLE `objavs` (
  `id` int(20) NOT NULL auto_increment,
  `user_id` int(20) NOT NULL default '0',
  `name` blob NOT NULL,
  `msg` blob NOT NULL,
  `time` int(20) NOT NULL default '0',
  `chit` int(20) NOT NULL default '0',
  `srok` int(20) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=0 ;


CREATE TABLE `fo_cat` (
  `id` int(11) NOT NULL auto_increment,
  `path` text NOT NULL,
  `infolder` text NOT NULL,
  `name` varchar(255) NOT NULL,
  `priority` tinyint(3) NOT NULL default '0',
  `time` int(11) NOT NULL default '0',
  `pos` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE `fo_cat2` (
  `id` int(11) NOT NULL auto_increment,
  `fid` int(11) NOT NULL default '0',
  `path` text NOT NULL,
  `infolder` text NOT NULL,
  `name` varchar(255) NOT NULL,
  `priority` tinyint(3) NOT NULL default '0',
  `time` int(11) NOT NULL default '0',
  `pos` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `fo_files` (
  `id` int(20) NOT NULL auto_increment,
  `user_id` int(20) NOT NULL default '0',
  `path` text NOT NULL,
  `infolder` text NOT NULL,
  `name` varchar(255) NOT NULL,
  `priority` tinyint(3) NOT NULL default '0',
  `size` bigint(20) NOT NULL,
  `about` text NOT NULL,
  `pass` text NOT NULL,
  `price` int(11) NOT NULL default '0',
  `fastabout` text NOT NULL,
  `loads` int(11) NOT NULL default '0',
  `timeload` int(11) unsigned NOT NULL,
  `timeupload` int(11) NOT NULL,
  `ips` text NOT NULL,
  `yes` int(11) NOT NULL default '0',
  `no` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE `fo_komm` (
  `id` int(20) NOT NULL auto_increment,
  `file` int(20) NOT NULL default '0',
  `user_id` int(20) NOT NULL default '0',
  `time` int(20) NOT NULL default '0',
  `msg` text CHARACTER SET utf8 NOT NULL ,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=0 ;

ALTER TABLE `users` ADD `fo_files` int(20) NOT NULL default '0';


CREATE TABLE `diaskomm` (
  `id` int(20) NOT NULL auto_increment,
  `did` int(20) NOT NULL default '0',
  `user_id` int(20) NOT NULL default '0',
  `time` int(20) NOT NULL default '0',
  `msg` text CHARACTER SET utf8 NOT NULL ,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=0 ;

CREATE TABLE `groups` (
  `id` int(11) NOT NULL auto_increment,
  `lider_id` int(20) NOT NULL default '0',
  `name` text NOT NULL,
  `opis` text NOT NULL,
  `time` int(20) NOT NULL default '0',
  `users` int(20) NOT NULL default '0',
  `logo` text NOT NULL,
  `icon` text NOT NULL,
  `tip` int(11) NOT NULL,
  `infa` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE `group_users` (
  `id` int(20) NOT NULL auto_increment,
  `gid` int(20) NOT NULL default '0',
  `user_id` int(20) NOT NULL default '0',
  `access` int(1) NOT NULL default '0',
  `time` int(20) NOT NULL default '0',
  `level` int(1) NOT NULL default '0',
  `posts` int(20) NOT NULL default '0',
  `status` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE `group_news` (
  `id` int(20) NOT NULL auto_increment,
  `gid` int(20) NOT NULL default '0',
  `user_id` int(20) NOT NULL default '0',
  `time` int(20) NOT NULL default '0',
  `msg` text CHARACTER SET utf8 NOT NULL ,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=0 ;

CREATE TABLE `group_newskom` (
  `id` int(20) NOT NULL auto_increment,
  `gid` int(20) NOT NULL default '0',
  `new` int(20) NOT NULL default '0',
  `user_id` int(20) NOT NULL default '0',
  `time` int(20) NOT NULL default '0',
  `msg` text CHARACTER SET utf8 NOT NULL ,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=0 ;

CREATE TABLE `group_chat` (
  `id` int(20) NOT NULL auto_increment,
  `gid` int(20) NOT NULL default '0',
  `user_id` int(20) NOT NULL default '0',
  `time` int(20) NOT NULL default '0',
  `msg` text CHARACTER SET utf8 NOT NULL ,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=0 ;


CREATE TABLE `logs` (
  `id` int(255) NOT NULL auto_increment,
  `log` varchar(255) NOT NULL default '',
  `msg` text NOT NULL,
  `time` int(20) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


ALTER TABLE `forum_t` ADD `times` int(20) NOT NULL default '0';

CREATE TABLE `vstr` (
  `id` int(20) NOT NULL auto_increment,
  `user_id` int(20) NOT NULL default '0',
  `time` int(20) NOT NULL default '0',
  `msg` text CHARACTER SET utf8 NOT NULL ,
  `org` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=0 ;

CREATE TABLE `akcyi` (
  `id` int(20) NOT NULL auto_increment,
  `user_id` int(20) NOT NULL default '0',
  `time` int(20) NOT NULL default '0',
  `msg` text CHARACTER SET utf8 NOT NULL ,
  `org` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=0 ;

CREATE TABLE `konkurs` (
  `id` int(20) NOT NULL auto_increment,
  `user_id` int(20) NOT NULL default '0',
  `time` int(20) NOT NULL default '0',
  `msg` text CHARACTER SET utf8 NOT NULL ,
  `org` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=0 ;


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


CREATE TABLE `bomj` (
  `klu4` int(11) NOT NULL default '0',
  `night_act` text NOT NULL,
  PRIMARY KEY  (`klu4`)
) TYPE=MyISAM;

INSERT INTO `bomj` (`klu4`, `night_act`) VALUES
(1, '&#x413;&#x43E;&#x440;&#x43E;&#x434;&#x441;&#x43A;&#x43E;&#x439; &#x431;&#x43E;&#x43C;&#x436;, &#x43E;&#x441;&#x442;&#x430;&#x432;&#x438;&#x432; &#x43F;&#x43E;&#x43C;&#x43E;&#x439;&#x43A;&#x443;, w&#x430;&#x440;&#x438;&#x442; &#x441;&#x432;&#x43E;&#x438;&#x43C;&#x438; &#x433;&#x440;&#x44F;&#x437;&#x43D;&#x44B;&#x43C;&#x438; &#x440;&#x443;&#x43A;&#x430;&#x43C;&#x438; &#x43F;&#x43E; &#x43A;&#x430;&#x440;&#x43C;&#x430;&#x43D;&#x430;&#x43C; &#x43F;&#x440;&#x43E;&#x445;&#x43E;&#x436;&#x438;&#x445;...'),
(2, '&#x412;&#x43E;&#x43D;&#x44E;&#x447;&#x438;&#x439; &#x431;&#x43E;&#x43C;&#x436; w&#x43D;&#x44B;&#x440;&#x44F;&#x435;&#x442; &#x43F;&#x43E; &#x43F;&#x435;&#x440;&#x435;&#x443;&#x43B;&#x43A;&#x430;&#x43C;, &#x438; &#x43C;&#x435;&#x436;&#x434;&#x443; &#x43E;&#x447;&#x435;&#x440;&#x435;&#x434;&#x43D;&#x43E;&#x439; &#x43C;&#x443;&#x441;&#x43E;&#x440;&#x43A;&#x43E;&#x439; &#x43A;&#x43E;&#x43F;&#x430;&#x435;&#x442;&#x441;&#x44F; &#x432; &#x447;&#x44C;&#x438;&#x445;-&#x442;&#x43E; &#x43A;&#x430;&#x440;&#x43C;&#x430;&#x43D;&#x430;&#x445;...'),
(3, '&#x411;&#x43E;&#x43C;&#x436;, &#x440;&#x430;&#x441;&#x43F;&#x440;&#x43E;&#x441;&#x442;&#x440;&#x430;&#x43D;&#x44F;&#x44F; &#x43F;&#x43E; &#x433;&#x43E;&#x440;&#x43E;&#x434;&#x443; &#x447;&#x443;&#x434;&#x435;&#x441;&#x43D;&#x44B;&#x439; &#x430;&#x440;&#x43E;&#x43C;&#x430;&#x442; &#x441;&#x432;&#x43E;&#x438;&#x445; &#x43F;&#x43E;&#x434;&#x43C;&#x44B;w&#x435;&#x43A;, &#x443;&#x43C;&#x443;&#x434;&#x440;&#x44F;&#x435;&#x442;&#x441;&#x44F; &#x435;&#x449;&#x435; &#x43F;&#x440;&#x43E;&#x432;&#x435;&#x440;&#x44F;&#x442;&#x44C; &#x43A;&#x430;&#x440;&#x43C;&#x430;&#x43D;&#x44B; &#x433;&#x43E;&#x440;&#x43E;&#x436;&#x430;&#x43D;...');

CREATE TABLE `doktor` (
  `klu4` int(11) NOT NULL default '0',
  `night_act` text NOT NULL,
  PRIMARY KEY  (`klu4`)
) TYPE=MyISAM;

INSERT INTO `doktor` (`klu4`, `night_act`) VALUES
(1, '&#x414;&#x43E;&#x43A;&#x442;&#x43E;&#x440;, &#x437;&#x430;&#x445;&#x432;&#x430;&#x442;&#x438;&#x432; &#x441; &#x441;&#x43E;&#x431;&#x43E;&#x439; w&#x43F;&#x440;&#x438;&#x446; &#x43F;&#x43E;&#x431;&#x43E;&#x43B;&#x44C;w&#x435;, &#x440;&#x44B;&#x449;&#x435;&#x442; &#x43F;&#x43E; &#x433;&#x43E;&#x440;&#x43E;&#x434;&#x443;, &#x43A;&#x43E;&#x43C;&#x443; &#x436;&#x435; &#x438; &#x43A;&#x443;&#x434;&#x430; &#x435;&#x433;&#x43E; &#x432;&#x441;&#x442;&#x430;&#x432;&#x438;&#x442;&#x44C;...'),
(2, '&#x414;&#x43E;&#x43A;&#x442;&#x43E;&#x440;, &#x43D;&#x430;&#x433;&#x43B;&#x43E;&#x442;&#x430;&#x432;w&#x438;&#x441;&#x44C; &#x434;&#x443;&#x440;&#x438;, &#x440;&#x435;w&#x438;&#x43B; &#x437;&#x430;&#x43B;&#x435;&#x447;&#x438;&#x442;&#x44C; &#x447;&#x442;&#x43E;-&#x43D;&#x438;&#x431;&#x443;&#x434;&#x44C; &#x443; &#x43A;&#x43E;&#x433;&#x43E;-&#x43D;&#x438;&#x431;&#x443;&#x434;&#x44C; &#x44D;&#x442;&#x43E;&#x439; &#x43D;&#x43E;&#x447;&#x44C;&#x44E;...'),
(3, '&#x41D;&#x430;w &#x431;&#x440;&#x430;&#x432;&#x44B;&#x439; &#x433;&#x43E;&#x440;&#x43E;&#x434;&#x441;&#x43A;&#x43E;&#x439; &#x432;&#x440;&#x430;&#x447; &#x432;&#x44B;w&#x435;&#x43B; &#x43D;&#x430; &#x43E;&#x445;&#x43E;&#x442;&#x443; &#x437;&#x430; &#x43F;&#x430;&#x446;&#x438;&#x435;&#x43D;&#x442;&#x430;&#x43C;&#x438;. &#x423; &#x43D;&#x435;&#x433;&#x43E; &#x442;&#x430;&#x43A; &#x438; &#x447;&#x435;w&#x443;&#x442;&#x441;&#x44F; &#x440;&#x443;&#x43A;&#x438; &#x43A;&#x43E;&#x433;&#x43E;-&#x43D;&#x438;&#x431;&#x443;&#x434;&#x44C; &#x432;&#x44B;&#x43B;&#x435;&#x447;&#x438;&#x442;&#x44C;...');

CREATE TABLE `komissar` (
  `klu4` int(11) NOT NULL default '0',
  `night_act` text NOT NULL,
  PRIMARY KEY  (`klu4`)
) TYPE=MyISAM;

INSERT INTO `komissar` (`klu4`, `night_act`) VALUES
(1, '&#x41A;&#x43E;&#x43C;&#x438;&#x441;&#x441;&#x430;&#x440; &#x41A;&#x430;&#x442;&#x430;&#x43D;&#x438;, &#x441;&#x435;&#x432; &#x432; &#x441;&#x432;&#x43E;&#x439; &#x431;&#x43E;&#x431;&#x438;&#x43A;, &#x43F;&#x43E;&#x435;&#x445;&#x430;&#x43B; &#x438;&#x441;&#x43A;&#x430;&#x442;&#x44C; &#x43F;&#x440;&#x435;&#x441;&#x442;&#x443;&#x43F;&#x43D;&#x438;&#x43A;&#x43E;&#x432;...'),
(2, '&#x41A;&#x43E;&#x43C;&#x438;&#x441;&#x441;&#x430;&#x440; &#x41A;&#x430;&#x442;&#x430;&#x43D;&#x438;, &#x43D;&#x430;&#x433;&#x43B;&#x43E;&#x442;&#x430;&#x432;w&#x438;&#x441;&#x44C; &#x43A;&#x43E;&#x43B;&#x435;&#x441;, &#x445;&#x43E;&#x434;&#x438;&#x442; &#x43F;&#x43E; &#x43A;&#x43E;&#x43C;&#x43D;&#x430;&#x442;&#x435; &#x438; &#x432;&#x44B;&#x447;&#x438;&#x441;&#x43B;&#x44F;&#x435;&#x442; &#x43C;&#x430;&#x444;&#x438;&#x44E;...'),
(3, '&#x41A;&#x43E;&#x43C;&#x438;&#x441;&#x441;&#x430;&#x440; &#x41A;&#x430;&#x442;&#x430;&#x43D;&#x438; &#x43B;&#x435;&#x436;&#x438;&#x442; &#x432; &#x437;&#x430;&#x441;&#x430;&#x434;&#x435; &#x432; &#x43A;&#x443;&#x447;&#x435; &#x43D;&#x430;&#x432;&#x43E;&#x437;&#x430; &#x438; &#x441;&#x43B;&#x435;&#x434;&#x438;&#x442; &#x437;&#x430; &#x43C;&#x430;&#x444;&#x438;&#x435;&#x439;... &#x424;&#x443;&#x443;-&#x443;, &#x43D;&#x443; &#x438; &#x437;&#x430;&#x43F;&#x430;w&#x43E;&#x43A;:)');


CREATE TABLE `mafia` (
  `klu4` int(11) NOT NULL default '0',
  `night_act` text NOT NULL,
  PRIMARY KEY  (`klu4`)
) TYPE=MyISAM;

INSERT INTO `mafia` (`klu4`, `night_act`) VALUES
(1, '&#x41C;&#x430;&#x444;&#x438;&#x43E;&#x437;&#x438;, &#x432;&#x43E;&#x43E;&#x440;&#x443;&#x436;&#x438;&#x432;w&#x438;&#x441;&#x44C; &#x434;&#x43E; &#x437;&#x443;&#x431;&#x43E;&#x432;, &#x43D;&#x430;&#x43F;&#x440;&#x430;&#x432;&#x43B;&#x44F;&#x44E;&#x442;&#x441;&#x44F; &#x43D;&#x430;&#x432;&#x441;&#x442;&#x440;&#x435;&#x447;&#x443; &#x441;&#x432;&#x43E;&#x435;&#x439; &#x436;&#x435;&#x440;&#x442;&#x432;&#x435;...'),
(2, '&#x413;&#x43B;&#x430;&#x432;&#x430;&#x440;&#x44C; &#x43C;&#x430;&#x444;&#x438;&#x438; &#x432;&#x44B;&#x441;&#x43C;&#x430;&#x442;&#x440;&#x438;&#x432;&#x430;&#x435;&#x442; &#x441;&#x432;&#x43E;&#x44E; &#x436;&#x435;&#x440;&#x442;&#x432;&#x443;. &#x417;&#x430; &#x43D;&#x438;&#x43C;, &#x43B;&#x438;&#x437;&#x43E;&#x431;&#x43B;&#x44E;&#x434;&#x44F;, &#x441;&#x43B;&#x435;&#x434;&#x443;&#x44E;&#x442; &#x435;&#x433;&#x43E; w&#x435;&#x441;&#x442;&#x435;&#x440;&#x43A;&#x438;...'),
(3, '&#x41C;&#x430;&#x444;&#x438;&#x44F; &#x43D;&#x430; &#x447;&#x435;&#x442;&#x44B;&#x440;&#x435;&#x445; &#x43C;&#x430;w&#x438;&#x43D;&#x430;&#x445; &#x43D;&#x43E;&#x441;&#x438;&#x442;&#x441;&#x44F; &#x43F;&#x43E; &#x43D;&#x43E;&#x447;&#x43D;&#x43E;&#x43C;&#x443; &#x433;&#x43E;&#x440;&#x43E;&#x434;&#x443; &#x438; &#x43F;&#x443;&#x433;&#x430;&#x435;&#x442; &#x440;&#x435;&#x434;&#x43A;&#x438;&#x445; &#x43F;&#x440;&#x43E;&#x445;&#x43E;&#x436;&#x438;&#x445;...');

CREATE TABLE `maniac` (
  `klu4` int(11) NOT NULL default '0',
  `night_act` text NOT NULL,
  PRIMARY KEY  (`klu4`)
) TYPE=MyISAM;

INSERT INTO `maniac` (`klu4`, `night_act`) VALUES
(1, '&#x41C;&#x430;&#x43D;&#x44C;&#x44F;&#x43A; &#x43D;&#x43E;&#x441;&#x438;&#x442;&#x441;&#x44F; &#x441; &#x442;&#x43E;&#x43F;&#x43E;&#x440;&#x43E;&#x43C; &#x432; &#x440;&#x443;&#x43A;&#x430;&#x445; &#x43F;&#x43E; &#x442;&#x435;&#x43C;&#x43D;&#x44B;&#x43C; &#x43F;&#x435;&#x440;&#x435;&#x443;&#x43B;&#x43A;&#x430;&#x43C;...'),
(2, '&#x41C;&#x430;&#x43D;&#x44C;&#x44F;&#x43A; &#x441; &#x433;&#x430;&#x434;&#x43A;&#x43E;&#x439; &#x443;&#x445;&#x43C;&#x44B;&#x43B;&#x43A;&#x43E;&#x439; &#x43D;&#x430; &#x43B;&#x438;&#x446;&#x435; &#x442;&#x43E;&#x447;&#x438;&#x442; &#x441;&#x432;&#x43E;&#x439; &#x442;&#x43E;&#x43F;&#x43E;&#x440;...'),
(3, '&#x41C;&#x430;&#x43D;&#x44C;&#x44F;&#x43A; &#x441;&#x438;&#x434;&#x438;&#x442; &#x432; &#x437;&#x430;&#x441;&#x430;&#x434;&#x435; &#x441; &#x43E;&#x440;&#x443;&#x436;&#x438;&#x435;&#x43C; &#x43D;&#x430;&#x433;&#x43E;&#x442;&#x43E;&#x432;&#x435; &#x438; &#x43F;&#x43E;&#x434;&#x436;&#x438;&#x434;&#x430;&#x435;&#x442; &#x441;&#x43B;&#x443;&#x447;&#x430;&#x439;&#x43D;&#x44B;&#x445; &#x43F;&#x440;&#x43E;&#x445;&#x43E;&#x436;&#x438;&#x445;...');

CREATE TABLE `wluha` (
  `klu4` int(11) NOT NULL default '0',
  `night_act` text NOT NULL,
  PRIMARY KEY  (`klu4`)
) TYPE=MyISAM;

INSERT INTO `wluha` (`klu4`, `night_act`) VALUES
(1, 'W&#x43B;&#x44E;&#x445;&#x430; &#x432;&#x44B;w&#x43B;&#x430; &#x438;&#x437; &#x434;&#x43E;&#x43C;&#x430;, &#x43A;&#x43E;&#x43C;&#x443;-&#x442;&#x43E; &#x441;&#x435;&#x433;&#x43E;&#x434;&#x43D;&#x44F; &#x43D;&#x435; &#x443;&#x434;&#x430;&#x441;&#x442;&#x441;&#x44F; &#x43F;&#x43E;&#x441;&#x43F;&#x430;&#x442;&#x44C;...'),
(2, '&#x414;&#x435;&#x432;&#x43A;&#x430;, &#x432;&#x438;&#x43B;&#x44F;&#x44F; &#x431;&#x435;&#x434;&#x440;&#x430;&#x43C;&#x438;, &#x445;&#x43E;&#x434;&#x438;&#x442; &#x43D;&#x43E;&#x447;&#x44C;&#x44E; &#x43F;&#x43E; &#x433;&#x43E;&#x440;&#x43E;&#x434;&#x443;, &#x43D;&#x435; &#x43F;&#x440;&#x43E;&#x43F;&#x443;&#x441;&#x43A;&#x430;&#x44F; &#x43D;&#x438; &#x43E;&#x434;&#x43D;&#x43E;&#x433;&#x43E; &#x43C;&#x443;&#x436;&#x447;&#x438;&#x43D;&#x44B;.'),
(3, '&#x413;&#x43E;&#x440;&#x43E;&#x434;&#x441;&#x43A;&#x430;&#x44F; w&#x43B;&#x44E;w&#x43A;&#x430; &#x432; &#x43E;&#x442;&#x43A;&#x440;&#x43E;&#x432;&#x435;&#x43D;&#x43D;&#x43E;&#x43C; &#x432;&#x438;&#x434;&#x435; w&#x430;&#x441;&#x442;&#x430;&#x435;&#x442; &#x43F;&#x43E; &#x443;&#x43B;&#x438;&#x446;&#x430;&#x43C;, &#x432;&#x44B;&#x431;&#x438;&#x440;&#x430;&#x44F; &#x436;&#x435;&#x440;&#x442;&#x432;&#x443;...');



CREATE TABLE `ingame1` (
  `gamer_id` int(11) NOT NULL default '0',
  `role` varchar(100) NOT NULL default '',
  `gamer_act` varchar(50) NOT NULL default '',
  `id_in_game` int(11) NOT NULL default '0',
  `dvote` int(11) NOT NULL default '0',
  `wholin` int(11) NOT NULL default '0',
  `onl` int(12) NOT NULL default '0',
  `state` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`gamer_id`)
) TYPE=MyISAM;

CREATE TABLE `mafaction1` (
  `klu4` tinyint(1) NOT NULL default '0',
  `action` varchar(100) NOT NULL default '',
  `nexttime` int(11) NOT NULL default '0',
  `kiked` tinyint(1) NOT NULL default '0',
  `prevprev` int(11) NOT NULL default '0',
  `prev` int(11) NOT NULL default '0',
  `current` int(11) NOT NULL default '0',
  `cround` smallint(2) NOT NULL default '0',
  PRIMARY KEY  (`klu4`)
) TYPE=MyISAM;
INSERT INTO `mafaction1` (`klu4`, `action`, `nexttime`, `kiked`, `prevprev`, `prev`, `current`, `cround`) VALUES (1, 'nogame', 1172463028, 0, 200, 3, 2, 2);

CREATE TABLE `maf1` (
  `klu4` int(8) NOT NULL default '0',
  `time` varchar(5) NOT NULL default '',
  `who` varchar(100) NOT NULL default '',
  `message` text NOT NULL,
  `messagewosm` text NOT NULL,
  `messagewoasm` text NOT NULL,
  `id` double NOT NULL default '0',
  `towhom` varchar(12) NOT NULL default '',
  `hid` smallint(1) NOT NULL default '0',
  `usid` int(12) NOT NULL default '0',
  `gamemes` tinyint(1) NOT NULL default '0',
  `komu` varchar(40) NOT NULL default '',
  PRIMARY KEY  (`klu4`)
) TYPE=MyISAM;

CREATE TABLE `scores1` (
  `gamer_id` int(11) NOT NULL default '0',
  `score` int(11) NOT NULL default '0',
  PRIMARY KEY  (`gamer_id`)
) TYPE=MyISAM;
INSERT INTO `scores1` (`gamer_id`, `score`) VALUES (1457, 0),
(913, 20),
(839, 60),
(1472, 75);

ALTER TABLE `setting` ADD `mafiozi` varchar(50) character set utf8 collate utf8_bin NOT NULL default 'mafiozi';

ALTER TABLE `users` ADD `rest_time` int(20) NOT NULL default '0';
ALTER TABLE `users` ADD `rest_code` varchar(200) character set utf8 collate utf8_bin NOT NULL default '';