-- 
--   `chat1`
-- 

CREATE TABLE `chat1` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `aid` int(11) NOT NULL default '0',
  `nickname` tinytext NOT NULL,
  `msg` text NOT NULL,
  `to` int(11) NOT NULL default '0',
  `time` tinytext NOT NULL,
  `seconds` int(11) unsigned NOT NULL default '0',
  `tonick` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

-- 
--    `chat1`
-- 


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

-- 
--   `chat11`
-- 

CREATE TABLE `chat11` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `aid` int(11) NOT NULL default '0',
  `nickname` tinytext NOT NULL,
  `msg` text NOT NULL,
  `to` int(11) NOT NULL default '0',
  `time` tinytext NOT NULL,
  `seconds` int(11) unsigned NOT NULL default '0',
  `tonick` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

-- 
--    `chat11`
-- 


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

-- 
--   `chat3`
-- 

CREATE TABLE `chat3` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `aid` int(11) NOT NULL default '0',
  `nickname` tinytext NOT NULL,
  `msg` text NOT NULL,
  `to` int(11) NOT NULL default '0',
  `time` tinytext NOT NULL,
  `seconds` int(11) unsigned NOT NULL default '0',
  `tonick` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

-- 
--    `chat3`
-- 


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

-- 
--   `chat4`
-- 

CREATE TABLE `chat4` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `aid` int(11) NOT NULL default '0',
  `nickname` tinytext NOT NULL,
  `msg` text NOT NULL,
  `to` int(11) NOT NULL default '0',
  `time` tinytext NOT NULL,
  `seconds` int(11) unsigned NOT NULL default '0',
  `tonick` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

-- 
--    `chat4`
-- 


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

-- 
--   `chat_articles`
-- 

CREATE TABLE `chat_articles` (
  `nomer` int(11) NOT NULL auto_increment,
  `name` text NOT NULL,
  `article` text NOT NULL,
  `date` text NOT NULL,
  `nickname` text NOT NULL,
  PRIMARY KEY  (`nomer`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- 
--    `chat_articles`
-- 


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

-- 
--   `chat_bad_answers`
-- 

CREATE TABLE `chat_bad_answers` (
  `id` int(11) NOT NULL auto_increment,
  `answer` blob NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

-- 
--    `chat_bad_answers`
-- 


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

-- 
--   `chat_banned`
-- 

CREATE TABLE `chat_banned` (
  `id` int(11) NOT NULL auto_increment,
  `ip` tinyblob NOT NULL,
  `ua` tinyblob NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

-- 
--    `chat_banned`
-- 


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

-- 
--   `chat_banned_nicknames`
-- 

CREATE TABLE `chat_banned_nicknames` (
  `id` int(11) NOT NULL auto_increment,
  `nickname` tinyblob NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

-- 
--    `chat_banned_nicknames`
-- 


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

-- 
--   `chat_code`
-- 

CREATE TABLE `chat_code` (
  `code` text,
  `ua` text,
  `ip` text,
  `ts` bigint(20) default NULL,
  `zact` varchar(12) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

-- 
--    `chat_code`
-- 


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

-- 
--   `chat_com`
-- 

CREATE TABLE `chat_com` (
  `id` int(11) NOT NULL auto_increment,
  `idfoto` text NOT NULL,
  `idhozyaina` text NOT NULL,
  `idadda` text NOT NULL,
  `msg` text NOT NULL,
  `ocenka` text NOT NULL,
  `time` int(11) NOT NULL default '0',
  `ip` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

-- 
--    `chat_com`
-- 


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

-- 
--   `chat_foto`
-- 

CREATE TABLE `chat_foto` (
  `id` int(11) NOT NULL auto_increment,
  `iduser` int(11) NOT NULL default '0',
  `type` varchar(10) NOT NULL default '',
  `descr` text NOT NULL,
  `foto` text NOT NULL,
  `golos` text NOT NULL,
  `time` varchar(25) NOT NULL default '',
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

-- 
--    `chat_foto`
-- 


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

-- 
--   `chat_ignor`
-- 

CREATE TABLE `chat_ignor` (
  `id` int(11) NOT NULL default '0',
  `uid` int(11) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

-- 
--    `chat_ignor`
-- 


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

-- 
--   `chat_insults`
-- 

CREATE TABLE `chat_insults` (
  `id` int(11) NOT NULL auto_increment,
  `insult` blob NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

-- 
--    `chat_insults`
-- 


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

-- 
--   `chat_intim`
-- 

CREATE TABLE `chat_intim` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `aid` int(11) NOT NULL default '0',
  `nickname` tinyblob NOT NULL,
  `msg` blob NOT NULL,
  `key` tinyblob NOT NULL,
  `to` int(11) NOT NULL default '0',
  `time` tinyblob NOT NULL,
  `seconds` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

-- 
--    `chat_intim`
-- 


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

-- 
--   `chat_jokes`
-- 

CREATE TABLE `chat_jokes` (
  `id` int(6) NOT NULL auto_increment,
  `joke` blob NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

-- 
--    `chat_jokes`
-- 


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

-- 
--   `chat_letters`
-- 

CREATE TABLE `chat_letters` (
  `lid` int(11) unsigned NOT NULL auto_increment,
  `id` int(11) NOT NULL default '0',
  `to` int(11) unsigned NOT NULL default '0',
  `from` int(11) unsigned NOT NULL default '0',
  `subject` tinyblob NOT NULL,
  `body` blob NOT NULL,
  `date` tinyblob NOT NULL,
  `time` int(11) unsigned NOT NULL default '0',
  `read` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`lid`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

-- 
--    `chat_letters`
-- 


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

-- 
--   `chat_logs`
-- 

CREATE TABLE `chat_logs` (
  `id` int(11) NOT NULL auto_increment,
  `moder` tinyblob NOT NULL,
  `action` tinyint(1) NOT NULL default '0',
  `object` tinyblob NOT NULL,
  `blob` blob NOT NULL,
  `date` tinyblob NOT NULL,
  `time` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

-- 
--    `chat_logs`
-- 


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

-- 
--   `chat_meets`
-- 

CREATE TABLE `chat_meets` (
  `id` int(11) NOT NULL auto_increment,
  `author` tinyblob NOT NULL,
  `title` tinyblob NOT NULL,
  `body` blob NOT NULL,
  `date` tinyblob NOT NULL,
  `time` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

-- 
--    `chat_meets`
-- 


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

-- 
--   `chat_news`
-- 

CREATE TABLE `chat_news` (
  `id` int(6) unsigned NOT NULL auto_increment,
  `name` tinyblob NOT NULL,
  `author` tinyblob NOT NULL,
  `blob` blob NOT NULL,
  `date` tinyblob NOT NULL,
  `time` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

-- 
--    `chat_news`
-- 


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

-- 
--   `chat_questions`
-- 

CREATE TABLE `chat_questions` (
  `id` int(6) NOT NULL auto_increment,
  `question` blob NOT NULL,
  `answer` tinyblob NOT NULL,
  `translit` tinyblob NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

-- 
--    `chat_questions`
-- 


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

-- 
--   `chat_rooms`
-- 

CREATE TABLE `chat_rooms` (
  `id` int(11) NOT NULL auto_increment,
  `name` tinyblob NOT NULL,
  `position` int(6) NOT NULL default '0',
  `topic` tinyblob NOT NULL,
  `type` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=cp1251 AUTO_INCREMENT=18 ;

-- 
--    `chat_rooms`
-- 

INSERT INTO `chat_rooms` VALUES (3, 0xd0a2d183d0b0d0bbd0b5d18220d0b7d0bdd0b0d182d0bed0bad0bed0b2, 2, 0xd0a2d183d0b0d0bbd0b5d18220d0b7d0bdd0b0d182d0bed0bad0bed0b2, 0);
INSERT INTO `chat_rooms` VALUES (1, 0xd092d0b8d0bad182d0bed180d0b8d0bdd0b0, 1, 0xd092d0b8d0bad182d0bed180d0b8d0bdd0b0, 0);
INSERT INTO `chat_rooms` VALUES (4, 0xd0a1d0bed180d0a2d0b8d0a0, 3, 0xd092d181d0b520d181d18ed0b4d0b020d0b3d0b3, 0);
INSERT INTO `chat_rooms` VALUES (11, 0xd093d0bed181d182d0b8d0bdd0b0d18f, 4, 0xd093d0bed181d182d0b8d0bdd0b0d18f, 0);

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

-- 
--   `chat_users`
-- 

CREATE TABLE `chat_users` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `nickname` tinyblob NOT NULL,
  `password` tinytext NOT NULL,
  `ip` tinyblob NOT NULL,
  `ua` blob NOT NULL,
  `level` tinyint(1) NOT NULL default '0',
  `photo` tinyblob NOT NULL,
  `avatar` text NOT NULL,
  `invisible` tinyint(1) NOT NULL default '0',
  `status` tinyblob NOT NULL,
  `kick` int(11) unsigned NOT NULL default '0',
  `moder` tinyblob NOT NULL,
  `reason` blob NOT NULL,
  `ban` tinyint(1) NOT NULL default '0',
  `name` tinyblob NOT NULL,
  `sex` tinyint(1) NOT NULL default '0',
  `email` blob NOT NULL,
  `site` blob NOT NULL,
  `birthday` tinyblob NOT NULL,
  `from` blob NOT NULL,
  `mobile` tinyblob NOT NULL,
  `about` blob NOT NULL,
  `posts` int(11) NOT NULL default '0',
  `answers` int(11) NOT NULL default '0',
  `gbalans` int(11) NOT NULL default '0',
  `smiles` tinyint(1) NOT NULL default '1',
  `translit` tinyint(1) NOT NULL default '0',
  `msgs` tinyint(2) NOT NULL default '5',
  `refresh` tinyint(3) unsigned NOT NULL default '20',
  `fsize` tinyint(1) NOT NULL default '1',
  `security` tinyint(1) NOT NULL default '1',
  `place` mediumint(9) NOT NULL default '0',
  `time` int(11) unsigned NOT NULL default '0',
  `intim` int(11) unsigned NOT NULL default '0',
  `key` tinyblob NOT NULL,
  `regdate` tinyblob NOT NULL,
  `hidden` tinyint(1) NOT NULL default '0',
  `mood` tinyint(2) NOT NULL default '0',
  `default` tinyint(1) NOT NULL default '0',
  `emotions` tinyint(1) NOT NULL default '1',
  `bystrsmile` tinyint(1) NOT NULL default '1',
  `system` tinyint(1) NOT NULL default '1',
  `gzip` tinyint(1) NOT NULL default '0',
  `sftky` int(6) NOT NULL default '0',
  `monety` int(11) NOT NULL default '0',
  `privilegii` tinyint(1) NOT NULL default '0',
  `avatar_etc` tinyint(1) NOT NULL default '0',
  `opsos` blob NOT NULL,
  `icq` blob NOT NULL,
  `nomer` text NOT NULL,
  `nickparu` blob NOT NULL,
  `colornick` varchar(8) NOT NULL default '',
  `version` blob NOT NULL,
  `foto` char(2) NOT NULL default '',
  `music` char(2) NOT NULL default '',
  `video` char(2) NOT NULL default '',
  `goodpass` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=172 DEFAULT CHARSET=cp1251 AUTO_INCREMENT=172 ;

-- 
--    `chat_users`
-- 

INSERT INTO `chat_users` VALUES (1, 0x4d615a6146614b61, '2995474157604fa5d54d1360809bb95d', 0x3132372e302e302e31, 0x4f706572612f392e3233202857696e646f7773204e5420352e313b20553b20727529, 5, '', '', 0, 0x4e4f20535441545553, 1225617321, 0xd0a1d0b8d181d182d0b5d0bcd0b0, 0xd092d18b20d0b1d18bd0bbd0b820d0b0d0b2d182d0bed0bcd0b0d182d0b8d187d0b5d181d0bad0b820d0b7d0b0d0b1d0b0d0bdd0b5d0bdd18b20d181d0b8d181d182d0b5d0bcd0bed0b920d0b7d0b020d184d0bbd183d0b42028d0bcd0bdd0bed0b3d0bed0bad180d0b0d182d0bdd0bed0b520d0bfd0bed0b2d182d0bed180d0b5d0bdd0b8d0b520d181d0bed0bed0b1d189d0b5d0bdd0b8d0b9292e, 0, 0xd094d0bcd0b8d182d180d0b8d0b9, 0, 0x737570706f727440776170612e7375, 0x776170612e7375, 0x32312d31312d31393839, 0xd0a1d183d0b4d0b0d0ba, 0x4f70657261, 0x504850, 843, 107, -11, 1, 0, 8, 10, 1, 1, 0, 1225650799, 1225638876, 0x7075626c6963, 0x31392d30342d32303038, 1, 0, 0, 1, 1, 1, 1, 0, 39512, 0, 1, 0x5574656c, 0x3434392d353539, '380919104685', 0x4d7953514c, '00C7AD', 0x68746d6c, '6', '2', '2', '');
INSERT INTO `chat_users` VALUES (2, 0xd091d0bed182d0b0d0bdd0b8d0ba, 'f86cb3d9b22adfea2711a9db53422e17', 0x3231322e3131332e35322e313237, 0x4f706572612f392e3233202857696e646f7773204e5420352e313b20553b20727529, 0, '', '', 0, 0x626f74, 0, '', '', 0, 0x6173647361647361, 0, '', '', 0x31312d31312d31393930, 0x6473666473, 0x4f70657261, 0x6464646464646464646464646464646464, 12341, 0, 0, 1, 0, 5, 20, 1, 1, 1, 1225642164, 0, '', 0x30362d30382d32303038, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, '', '', '', '', '', '', '6', '2', '2', '');
INSERT INTO `chat_users` VALUES (3, 0xd0a8d183d182d0bdd0b8d0ba, 'f86cb3d9b22adfea2711a9db53422e17', 0x3132372e302e302e31, 0x4f706572612f392e3233202857696e646f7773204e5420352e313b20553b20727529, 0, '', '', 0, 0x626f74, 0, '', '', 0, 0xd183d0b0d0b0d0b2d18bd0b0d0b2d18b, 0, '', '', 0x31312d31312d31393930, 0xd0b2d0b2d0b2d0b2d0b2d0b2d0b2d0b2d0b2, 0x4f70657261, 0xd0b2d0b2d0b2d0b2d0b2d0b2d0b2d0b2d0b2d0b2d0b2d0b2d0b2d0b2d0b2d0b2d0b2d0b2d0b2d0b2, 0, 0, 0, 1, 0, 5, 20, 1, 1, 1, 1225650663, 0, '', 0x30362d30382d32303038, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, '', '', '', '', '', '', '6', '2', '2', '');
INSERT INTO `chat_users` VALUES (4, 0xd0a3d0bcd0bdd0b8d0ba, 'f86cb3d9b22adfea2711a9db53422e17', 0x3132372e302e302e31, 0x4f706572612f392e3233202857696e646f7773204e5420352e313b20553b20727529, 0, '', '', 0, 0x626f74, 0, '', '', 0, 0xd187d187d187d187d187d187d187d187d187d187d187d187d187d187, 0, '', '', 0x31312d31312d31393930, 0xd18bd184d0b2d18b, 0x4f70657261, 0xd18bd18bd18bd18bd18bd18bd18bd18bd18bd18bd18bd18bd18bd18bd18bd18bd18b, 0, 0, 0, 1, 0, 5, 20, 1, 1, 3, 1222400251, 0, '', 0x30362d30382d32303038, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, '', '', '', '', '', '', '6', '2', '2', '');
INSERT INTO `chat_users` VALUES (5, 0xd0a1d0b8d181d182d0b5d0bcd0b0, 'f86cb3d9b22adfea2711a9db53422e17', 0x3132372e302e302e31, 0x4f706572612f392e3233202857696e646f7773204e5420352e313b20553b20727529, 0, '', '', 0, 0x626f74, 0, '', '', 0, 0xd0b2d0b2d0b2d0b2d0b2d0b2d0b2d0b2d0b2d0b2d0b2d0b2d0b2d0b2d0b2, 0, '', '', 0x31312d31312d31393930, 0xd0b2d0b2d0b2d0b2d0b2d0b2d0b2d0b2d0b2d0b2d0b2d0b2d0b2d0b2d0b2d0b2d0b2, 0x4f70657261, 0xd0b2d0b2d0b2d0b2d0b2d0b2d0b2d0b2d0b2d0b2d0b2, 0, 0, 0, 1, 0, 5, 20, 1, 1, 0, 1218020260, 0, '', 0x30362d30382d32303038, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, '', '', '', '', '', '', '6', '2', '2', '');
        