CREATE TABLE IF NOT EXISTS `blogs` (
  `id` int(32) NOT NULL AUTO_INCREMENT,
  `id_user` int(32) NOT NULL,
  `title` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `time` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=0 ;

CREATE TABLE IF NOT EXISTS `blogs_comments` (
  `id` int(32) NOT NULL AUTO_INCREMENT,
  `id_record` int(32) NOT NULL,
  `id_user` int(32) NOT NULL,
  `rate` int(1) NOT NULL,
  `text` text COLLATE utf8_unicode_ci NOT NULL,
  `time` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=0 ;

CREATE TABLE IF NOT EXISTS `blogs_records` (
  `id` int(32) NOT NULL AUTO_INCREMENT,
  `id_user` int(32) NOT NULL,
  `id_blog` int(32) NOT NULL,
  `rate` int(32) NOT NULL,
  `title` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `text` text COLLATE utf8_unicode_ci NOT NULL,
  `time` int(10) NOT NULL,
  `see` int(32) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=0 ;

CREATE TABLE IF NOT EXISTS `chat_ini` (
  `id` varchar(50) NOT NULL,
  `value` tinytext NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `chat_ini` (`id`, `value`) VALUES
('last_ques', '1324007106'),
('pd', '0'),
('ans', 'РјРѕСЂС„РѕР»РѕРіРёСЏ\r\n'),
('us', ''),
('time', '0');

CREATE TABLE IF NOT EXISTS `chat_posts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rid` int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
  `time` int(11) NOT NULL,
  `msg` varchar(512) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `um_otvet` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `shut` tinyint(1) NOT NULL DEFAULT '0',
  `umnik` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `id_user` (`id_user`,`time`,`shut`,`umnik`),
  KEY `rid` (`rid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;

CREATE TABLE IF NOT EXISTS `chat_rooms` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `sort` tinyint(4) NOT NULL DEFAULT '0',
  `umnik` int(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sort` (`sort`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;

CREATE TABLE IF NOT EXISTS `chat_users` (
  `id_user` int(11) NOT NULL,
  `time` int(11) NOT NULL,
  `rid` int(11) NOT NULL,
  UNIQUE KEY `id_user` (`id_user`),
  KEY `rid` (`rid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `community` (
  `id` int(32) NOT NULL AUTO_INCREMENT,
  `id_maker` int(32) NOT NULL,
  `id_sel` int(32) NOT NULL,
  `title` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `logo` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `deviz` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `interests` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `descript` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `rules` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `enter` int(1) NOT NULL,
  `read` int(1) NOT NULL,
  `write` int(1) NOT NULL,
  `time` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=0 ;

INSERT INTO `community` (`id`, `id_maker`, `id_sel`, `title`, `logo`, `deviz`, `interests`, `descript`, `rules`, `enter`, `read`, `write`, `time`) VALUES
(9, 1, 23, 'А', '653862_', 'А', 'А', 'А', 'А', 1, 2, 2, 1323776245);

CREATE TABLE IF NOT EXISTS `community_application` (
  `id` int(32) NOT NULL AUTO_INCREMENT,
  `id_community` int(32) NOT NULL,
  `id_user` int(32) NOT NULL,
  `time` int(32) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=0 ;

CREATE TABLE IF NOT EXISTS `community_chat_posts` (
  `id` int(32) NOT NULL AUTO_INCREMENT,
  `id_community` int(32) NOT NULL,
  `id_maker` int(32) NOT NULL,
  `text` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `time` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=0 ;

CREATE TABLE IF NOT EXISTS `community_forum_posts` (
  `id` int(32) NOT NULL AUTO_INCREMENT,
  `id_topic` int(32) NOT NULL,
  `login` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `text` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
  `time` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=0 ;

CREATE TABLE IF NOT EXISTS `community_forum_topics` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_community` int(11) NOT NULL,
  `id_maker` int(11) NOT NULL,
  `title` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=0 ;

CREATE TABLE IF NOT EXISTS `community_selections` (
  `id` int(32) NOT NULL AUTO_INCREMENT,
  `title` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=0 ;

CREATE TABLE IF NOT EXISTS `community_users` (
  `id` int(32) NOT NULL AUTO_INCREMENT,
  `id_community` int(32) NOT NULL,
  `id_user` int(32) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=0 ;


CREATE TABLE IF NOT EXISTS `files_comments` (
  `id` int(32) NOT NULL AUTO_INCREMENT,
  `id_file` int(32) NOT NULL,
  `user` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `text` text COLLATE utf8_unicode_ci NOT NULL,
  `time` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=0 ;

CREATE TABLE IF NOT EXISTS `files_files` (
  `id` int(32) NOT NULL AUTO_INCREMENT,
  `user` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `id_sel` int(32) NOT NULL,
  `id_usel` int(32) NOT NULL,
  `ext` varchar(5) COLLATE utf8_unicode_ci NOT NULL,
  `title` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `opis` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `time` int(10) NOT NULL,
  `url` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `rate` int(32) NOT NULL,
  `down` int(32) NOT NULL,
  `size` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `see` int(32) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=0 ;

CREATE TABLE IF NOT EXISTS `files_rate` (
  `id` int(32) NOT NULL AUTO_INCREMENT,
  `id_file` int(32) NOT NULL,
  `id_user` int(32) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=0 ;

CREATE TABLE IF NOT EXISTS `files_sel` (
  `id` int(32) NOT NULL AUTO_INCREMENT,
  `title` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=0 ;

INSERT INTO `files_sel` (`id`, `title`) VALUES
(10, 'Фото');

CREATE TABLE IF NOT EXISTS `files_usel` (
  `id` int(32) NOT NULL AUTO_INCREMENT,
  `id_sel` int(32) NOT NULL,
  `title` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `format` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=0 ;

CREATE TABLE IF NOT EXISTS `forum_forums` (
  `id` int(32) NOT NULL AUTO_INCREMENT,
  `id_sel` int(32) NOT NULL,
  `title` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=0 ;

CREATE TABLE IF NOT EXISTS `forum_posts` (
  `id` int(32) NOT NULL AUTO_INCREMENT,
  `url_file` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `id_forum` int(32) NOT NULL,
  `id_topic` int(32) NOT NULL,
  `login` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `text` text COLLATE utf8_unicode_ci NOT NULL,
  `time` int(32) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=0 ;

CREATE TABLE IF NOT EXISTS `forum_sel` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `title` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=0 ;

CREATE TABLE IF NOT EXISTS `forum_topics` (
  `id` int(32) NOT NULL AUTO_INCREMENT,
  `id_forum` int(32) NOT NULL,
  `status` int(1) NOT NULL,
  `position` int(1) NOT NULL,
  `title` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `time` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=0 ;

CREATE TABLE IF NOT EXISTS `friends` (
  `id` int(32) NOT NULL AUTO_INCREMENT,
  `id_user` int(32) NOT NULL,
  `id_added` int(32) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=0 ;

CREATE TABLE IF NOT EXISTS `friend_application` (
  `id` int(32) NOT NULL AUTO_INCREMENT,
  `id_user` int(32) NOT NULL,
  `id_adder` int(32) NOT NULL,
  `time` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=0 ;

CREATE TABLE IF NOT EXISTS `gifts` (
  `id` int(32) NOT NULL AUTO_INCREMENT,
  `path` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=0 ;

INSERT INTO `gifts` (`id`, `path`) VALUES
(1, '1.png'),
(2, '2.png'),
(3, '3.png'),
(4, '4.png'),
(5, '5.png'),
(6, '6.png'),
(7, '7.png'),
(8, '8.png'),
(9, '9.png'),
(10, '10.png'),
(11, '11.png'),
(12, '12.png'),
(13, '13.png'),
(14, '14.png'),
(15, '15.png'),
(16, '16.png'),
(17, '17.png'),
(18, '18.png'),
(19, '19.png'),
(20, '20.png'),
(21, '21.png'),
(22, '22.png'),
(23, '23.png'),
(24, '24.png'),
(25, '25.png'),
(26, '26.png'),
(27, '27.png'),
(28, '28.png'),
(29, '29.png'),
(30, '30.png'),
(31, '31.png'),
(32, '32.png'),
(33, '33.png'),
(34, '34.png'),
(35, '35.png'),
(36, '36.png'),
(37, '37.png'),
(38, '38.png'),
(39, '39.png'),
(40, '40.png'),
(41, '41.png'),
(42, '42.png'),
(43, '43.png'),
(44, '44.png'),
(45, '45.png'),
(46, '46.png'),
(47, '47.png'),
(48, '48.png'),
(49, '49.png'),
(50, '50.png'),
(51, '51.png'),
(52, '52.png'),
(53, '53.png'),
(54, '54.png'),
(55, '55.png'),
(56, '56.png'),
(57, '57.png'),
(58, '58.png'),
(59, '59.png'),
(60, '60.png'),
(61, '61.png'),
(62, '62.png'),
(63, '63.png'),
(64, '64.png'),
(65, '65.png'),
(66, '66.png'),
(67, '67.png'),
(68, '68.png'),
(69, '69.png'),
(70, '70.png'),
(71, '71.png'),
(72, '72.png'),
(73, '73.png'),
(74, '74.png'),
(75, '75.png'),
(76, '76.png'),
(77, '77.png'),
(78, '78.png'),
(79, '79.png'),
(80, '80.png'),
(81, '81.png'),
(82, '82.png'),
(83, '83.png'),
(84, '84.png'),
(85, '85.png'),
(86, '86.png'),
(87, '87.png'),
(88, '88.png'),
(89, '89.png'),
(90, '90.png'),
(91, '91.png'),
(92, '92.png'),
(93, '93.png'),
(94, '94.png'),
(95, '95.png'),
(96, '96.png'),
(97, '97.png'),
(98, '98.png'),
(99, '99.png'),
(100, '100.png'),
(101, '101.png'),
(102, '102.png'),
(103, '103.png'),
(104, '104.png'),
(105, '105.png'),
(106, '106.png'),
(107, '107.png'),
(108, '108.png'),
(109, '109.png'),
(110, '110.png'),
(111, '111.png'),
(112, '112.png'),
(113, '113.png'),
(114, '114.png'),
(115, '115.png'),
(116, '116.png'),
(117, '117.png'),
(118, '118.png'),
(119, '119.png'),
(120, '120.png'),
(121, '121.png'),
(122, '122.png'),
(123, '123.png'),
(124, '124.png'),
(125, '125.png'),
(126, '126.png'),
(127, '127.png'),
(128, '128.png'),
(129, '129.png'),
(130, '130.png'),
(131, '131.png'),
(132, '132.png'),
(133, '133.png'),
(134, '134.png'),
(135, '135.png'),
(136, '136.png'),
(137, '137.png'),
(138, '138.png'),
(139, '139.png'),
(140, '140.png'),
(141, '141.png'),
(142, '142.png'),
(143, '143.png'),
(144, '144.png'),
(145, '145.png'),
(146, '146.png'),
(147, '147.png'),
(148, '148.png'),
(149, '149.png'),
(150, '150.png'),
(151, '151.png'),
(152, '152.png'),
(153, '153.png'),
(154, '154.png'),
(155, '155.png'),
(156, '156.png'),
(157, '157.png'),
(158, '158.png'),
(159, '159.png'),
(160, '160.png'),
(161, '161.png'),
(162, '162.png'),
(163, '163.png'),
(164, '164.png'),
(165, '165.png'),
(166, '166.png'),
(167, '167.png'),
(168, '168.png'),
(169, '169.png'),
(170, '170.png'),
(171, '171.png'),
(172, '172.png'),
(173, '173.png'),
(174, '174.png'),
(175, '175.png'),
(176, '176.png'),
(177, '177.png'),
(178, '178.png'),
(179, '179.png'),
(180, '180.png'),
(181, '181.png'),
(182, '182.png'),
(183, '183.png'),
(184, '184.png'),
(185, '185.png'),
(186, '186.png'),
(187, '187.png'),
(188, '188.png'),
(189, '189.png'),
(190, '190.png'),
(191, '191.png'),
(192, '192.png'),
(193, '193.png'),
(194, '194.png'),
(195, '195.png'),
(196, '196.png'),
(197, '197.png'),
(198, '198.png'),
(199, '199.png'),
(200, '200.png'),
(201, '201.png'),
(202, '202.png'),
(203, '203.png'),
(204, '204.png'),
(205, '205.png'),
(206, '206.png'),
(207, '207.png'),
(208, '208.png'),
(209, '209.png'),
(210, '210.png'),
(211, '211.png'),
(212, '212.png'),
(213, '213.png'),
(214, '214.png'),
(215, '215.png'),
(216, '216.png'),
(217, '217.png'),
(218, '218.png'),
(219, '219.png'),
(220, '220.png'),
(221, '221.png'),
(222, '222.png'),
(223, '223.png'),
(224, '224.png'),
(225, '225.png'),
(226, '226.png'),
(227, '227.png'),
(228, '228.png'),
(229, '229.png'),
(230, '230.png'),
(231, '231.png'),
(232, '232.png'),
(233, '233.png'),
(234, '234.png'),
(235, '235.png'),
(236, '236.png'),
(237, '237.png'),
(238, '238.png'),
(239, '239.png'),
(240, '240.png'),
(241, '241.png'),
(242, '242.png'),
(243, '243.png'),
(244, '244.png'),
(245, '245.png'),
(246, '246.png'),
(247, '247.png'),
(248, '248.png'),
(249, '249.png'),
(250, '250.png'),
(251, '251.png'),
(252, '252.png'),
(253, '253.png'),
(254, '254.png'),
(255, '255.png'),
(256, '256.png'),
(257, '257.png'),
(258, '258.png'),
(259, '259.png'),
(260, '260.png'),
(261, '261.png'),
(262, '262.png'),
(263, '263.png'),
(264, '264.png'),
(265, '265.png'),
(266, '266.png'),
(267, '267.png'),
(268, '268.png'),
(269, '269.png'),
(270, '270.png'),
(271, '271.png'),
(272, '272.png'),
(273, '273.png'),
(274, '274.png'),
(275, '275.png');

CREATE TABLE IF NOT EXISTS `gifts_users` (
  `id` int(32) NOT NULL AUTO_INCREMENT,
  `id_gift` int(32) NOT NULL,
  `id_sender` int(32) NOT NULL,
  `id_getter` int(32) NOT NULL,
  `opis` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=0 ;

CREATE TABLE IF NOT EXISTS `guests` (
  `id_user` int(11) NOT NULL,
  `login_guest` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `status` int(11) NOT NULL,
  `time` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE IF NOT EXISTS `mail` (
  `id` int(32) NOT NULL AUTO_INCREMENT,
  `id_getter` int(32) NOT NULL,
  `id_sender` int(32) NOT NULL,
  `status` int(1) NOT NULL,
  `text` text COLLATE utf8_unicode_ci NOT NULL,
  `time` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=0 ;

CREATE TABLE IF NOT EXISTS `news` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(32) NOT NULL,
  `text` varchar(500) NOT NULL,
  `time` int(32) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;

CREATE TABLE IF NOT EXISTS `news_comments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_news` varchar(32) NOT NULL,
  `id_user` varchar(32) NOT NULL,
  `text` text NOT NULL,
  `time` varchar(32) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;

CREATE TABLE IF NOT EXISTS `online` (
  `ip` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `ua` varchar(16) COLLATE utf8_unicode_ci NOT NULL,
  `pereh` int(11) NOT NULL DEFAULT '0',
  `time` int(11) NOT NULL DEFAULT '0',
  `where` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`ip`,`ua`),
  KEY `pereh` (`pereh`,`time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE IF NOT EXISTS `questions` (
  `qid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `vopros` text NOT NULL,
  `otvet` text NOT NULL,
  PRIMARY KEY (`qid`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=0 ;

CREATE TABLE IF NOT EXISTS `settings` (
  `id` varchar(50) NOT NULL,
  `value` tinytext NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `settings` (`id`, `value`) VALUES
('keywords', ''),
('description', ''),
('http', ''),
('site', ''),
('str', '5'),
('style', 'default'),
('password', 'extrapass'),
('reg_mail', ''),
('umtime', '60');

CREATE TABLE IF NOT EXISTS `smiles` (
  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(50) DEFAULT NULL,
  `smile_url` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;

INSERT INTO `smiles` (`id`, `code`, `smile_url`) VALUES
(1, ':(', '(.gif'),
(2, ':)', ').gif'),
(3, ':2pistoleta', '2pistoleta.gif'),
(4, ':4moks', '4moks.gif'),
(5, ':D', 'D.gif'),
(6, ':E', 'E.gif'),
(7, ':P', 'P.gif'),
(8, ':aaa', 'aaa.gif'),
(9, ':acute', 'acute.gif'),
(10, ':adm', 'adm.gif'),
(11, ':aftar', 'aftar.gif'),
(12, ':agree', 'agree.gif'),
(13, ':ah', 'ah.gif'),
(14, ':airkiss', 'airkiss.gif'),
(15, ':akula', 'akula.gif'),
(16, ':alkawi', 'alkawi.gif'),
(17, ':alkogolik', 'alkogolik.gif'),
(18, ':angel', 'angel.gif'),
(19, ':angel2', 'angel2.gif'),
(20, ':angel3', 'angel3.gif'),
(21, ':antifem', 'antifem.gif'),
(22, ':apl', 'apl.gif'),
(23, ':arbuz', 'arbuz.gif'),
(24, ':arrow', 'arrow.gif'),
(25, ':arsenal', 'arsenal.gif'),
(26, ':asasin', 'asasin.gif'),
(27, ':atata', 'atata.gif'),
(28, ':atlet', 'atlet.gif'),
(29, ':avangard', 'avangard.gif'),
(30, ':babochka', 'babochka.gif'),
(31, ':babochka2', 'babochka2.gif'),
(32, ':baby', 'baby.gif'),
(33, ':baern', 'baern.gif'),
(34, ':baj', 'baj.gif'),
(35, ':bajan2', 'bajan2.gif'),
(36, ':baks', 'baks.gif'),
(37, ':ban', 'ban.gif'),
(38, ':ban2', 'ban2.gif'),
(39, ':ban3', 'ban3.gif'),
(40, ':banan', 'banan.gif'),
(41, ':banany', 'banany.gif'),
(42, ':banned', 'banned.gif'),
(43, ':bant', 'bant.gif'),
(44, ':baraban', 'baraban.gif'),
(45, ':barsa', 'barsa.gif'),
(46, ':basket', 'basket.gif'),
(47, ':be', 'be.gif'),
(48, ':beg', 'beg.gif'),
(49, ':belka', 'belka.gif'),
(50, ':beltigr', 'beltigr.gif'),
(51, ':best', 'best.gif'),
(52, ':bezdna', 'bezdna.gif'),
(53, ':bezpaniki', 'bezpaniki.gif'),
(54, ':biggrin2', 'biggrin2.gif'),
(55, ':binok', 'binok.gif'),
(56, ':bis', 'bis.gif'),
(57, ':blabla', 'blabla.gif'),
(58, ':blabla2', 'blabla2.gif'),
(59, ':blejn', 'blejn.gif'),
(60, ':blin', 'blin.gif'),
(61, ':blum', 'blum.gif'),
(62, ':bmed', 'bmed.gif'),
(63, ':bob1', 'bob1.gif'),
(64, ':bobslej', 'bobslej.gif'),
(65, ':bodibild', 'bodibild.gif'),
(66, ':bokaly', 'bokaly.gif'),
(67, ':boks', 'boks.gif'),
(68, ':bolen', 'bolen.gif'),
(69, ':boleyu', 'boleyu.gif'),
(70, ':bomba', 'bomba.gif'),
(71, ':bonsaj', 'bonsaj.gif'),
(72, ':boss', 'boss.gif'),
(73, ':bounce', 'bounce.gif'),
(74, ':bratok', 'bratok.gif'),
(75, ':bt', 'bt.gif'),
(76, ':buba', 'buba.gif'),
(77, ':budilnik', 'budilnik.gif'),
(78, ':bugaga', 'bugaga.gif'),
(79, ':buhoj', 'buhoj.gif'),
(80, ':bur2', 'bur2.gif'),
(81, ':butylki', 'butylki.gif'),
(82, ':bwink', 'bwink.gif'),
(83, ':celuju', 'celuju.gif'),
(84, ':chaj', 'chaj.gif'),
(85, ':chasy', 'chasy.gif'),
(86, ':chel', 'chel.gif'),
(87, ':chelsi', 'chelsi.gif'),
(88, ':cherep', 'cherep.gif'),
(89, ':chervyak', 'chervyak.gif'),
(90, ':chit', 'chit.gif'),
(91, ':chit2', 'chit2.gif'),
(92, ':chit3', 'chit3.gif'),
(93, ':chmak', 'chmak.gif'),
(94, ':chmok', 'chmok.gif'),
(95, ':chmok2', 'chmok2.gif'),
(96, ':clapping', 'clapping.gif'),
(97, ':closed', 'closed.gif'),
(98, ':closed2', 'closed2.gif'),
(99, ':cold', 'cold.gif'),
(100, ':cool', 'cool.gif'),
(101, ':crazyfriends', 'crazyfriends.gif'),
(102, ':crazyfriends2', 'crazyfriends2.gif'),
(103, ':cry', 'cry.gif'),
(104, ':cska', 'cska.gif'),
(105, ':cvetok', 'cvetok.gif'),
(106, ':cvetok1', 'cvetok1.gif'),
(107, ':cvetok2', 'cvetok2.gif'),
(108, ':cvetok3', 'cvetok3.gif'),
(109, ':cvetok4', 'cvetok4.gif'),
(110, ':cvetok5', 'cvetok5.gif'),
(111, ':cypa', 'cypa.gif'),
(112, ':cypka', 'cypka.gif'),
(113, ':cyplenok', 'cyplenok.gif'),
(114, ':darov', 'darov.gif'),
(115, ':darova', 'darova.gif'),
(116, ':daryrozu', 'daryrozu.gif'),
(117, ':daryserd', 'daryserd.gif'),
(118, ':dash1', 'dash1.gif'),
(119, ':dash2', 'dash2.gif'),
(120, ':dash3', 'dash3.gif'),
(121, ':ded', 'ded.gif'),
(122, ':ded_moroz', 'ded_moroz.gif'),
(123, ':ded_snegur2', 'ded_snegur2.gif'),
(124, ':demon', 'demon.gif'),
(125, ':derevo', 'derevo.gif'),
(126, ':derisive', 'derisive.gif'),
(127, ':dev', 'dev.gif'),
(128, ':dev2', 'dev2.gif'),
(129, ':devil', 'devil.gif'),
(130, ':dik', 'dik.gif'),
(131, ':dinamo', 'dinamo.gif'),
(132, ':disko', 'disko.gif'),
(133, ':disko2', 'disko2.gif'),
(134, ':disko3', 'disko3.gif'),
(135, ':dj', 'dj.gif'),
(136, ':dont', 'dont.gif'),
(137, ':dovolen', 'dovolen.gif'),
(138, ':dovolen2', 'dovolen2.gif'),
(139, ':dovolendum', 'dovolendum.gif'),
(140, ':dozhd', 'dozhd.gif'),
(141, ':dr', 'dr.gif'),
(142, ':draka', 'draka.gif'),
(143, ':draznilka', 'draznilka.gif'),
(144, ':drinks', 'drinks.gif'),
(145, ':drool', 'drool.gif'),
(146, ':drova', 'drova.gif'),
(147, ':druzhba', 'druzhba.gif'),
(148, ':dum', 'dum.gif'),
(149, ':duma', 'duma.gif'),
(150, ':duw', 'duw.gif'),
(151, ':edu', 'edu.gif'),
(152, ':elka2', 'elka2.gif'),
(153, ':evrej', 'evrej.gif'),
(154, ':exercise', 'exercise.gif'),
(155, ':fan', 'fan.gif'),
(156, ':fanat', 'fanat.gif'),
(157, ':fanat2', 'fanat2.gif'),
(158, ':fanaty', 'fanaty.gif'),
(159, ':faq', 'faq.gif'),
(160, ':feministka', 'feministka.gif'),
(161, ':fen', 'fen.gif'),
(162, ':fermer', 'fermer.gif'),
(163, ':figa', 'figa.gif'),
(164, ':figa2', 'figa2.gif'),
(165, ':figase', 'figase.gif'),
(166, ':fing', 'fing.gif'),
(167, ':fingal', 'fingal.gif'),
(168, ':fiorentina', 'fiorentina.gif'),
(169, ':flag', 'flag.gif'),
(170, ':flirt', 'flirt.gif'),
(171, ':flood', 'flood.gif'),
(172, ':flood2', 'flood2.gif'),
(173, ':fokus', 'fokus.gif'),
(174, ':frezija', 'frezija.gif'),
(175, ':ftopku', 'ftopku.gif'),
(176, ':fu', 'fu.gif'),
(177, ':fuck', 'fuck.gif'),
(178, ':fuu', 'fuu.gif'),
(179, ':gadaet', 'gadaet.gif'),
(180, ':gdevil', 'gdevil.gif'),
(181, ':gg', 'gg.gif'),
(182, ':gibon', 'gibon.gif'),
(183, ':girl_blum', 'girl_blum.gif'),
(184, ':girl_cry', 'girl_cry.gif'),
(185, ':girl_hide', 'girl_hide.gif'),
(186, ':girl_wink', 'girl_wink.gif'),
(187, ':gitara', 'gitara.gif'),
(188, ':gitara2', 'gitara2.gif'),
(189, ':gitara3', 'gitara3.gif'),
(190, ':gitara4', 'gitara4.gif'),
(191, ':glaza', 'glaza.gif'),
(192, ':gordo', 'gordo.gif'),
(193, ':granatomet', 'granatomet.gif'),
(194, ':gudok', 'gudok.gif'),
(195, ':gugl', 'gugl.gif'),
(196, ':gy', 'gy.gif'),
(197, ':gyy', 'gyy.gif'),
(198, ':ha', 'ha.gif'),
(199, ':hackcat', 'hackcat.gif'),
(200, ':haha', 'haha.gif'),
(201, ':happy', 'happy.gif'),
(202, ':harp', 'harp.gif'),
(203, ':heart', 'heart.gif'),
(204, ':hello', 'hello.gif'),
(205, ':help', 'help.gif'),
(206, ':help2', 'help2.gif'),
(207, ':helpme', 'helpme.gif'),
(208, ':hi', 'hi.gif'),
(209, ':hlopaet', 'hlopaet.gif'),
(210, ':hm', 'hm.gif'),
(211, ':hnyk', 'hnyk.gif'),
(212, ':holms', 'holms.gif'),
(213, ':homjachok', 'homjachok.gif'),
(214, ':horow', 'horow.gif'),
(215, ':horseshe', 'horseshe.gif'),
(216, ':hrap', 'hrap.gif'),
(217, ':huligan', 'huligan.gif'),
(218, ':id', 'id.gif'),
(219, ':idfox', 'idfox.gif'),
(220, ':idiot', 'idiot.gif'),
(221, ':ik', 'ik.gif'),
(222, ':infat', 'infat.gif'),
(223, ':inlav', 'inlav.gif'),
(224, ':inlove', 'inlove.gif'),
(225, ':inter', 'inter.gif'),
(226, ':ioda', 'ioda.gif'),
(227, ':irda', 'irda.gif'),
(228, ':iris', 'iris.gif'),
(229, ':ispug', 'ispug.gif'),
(230, ':isterika', 'isterika.gif'),
(231, ':jabloko', 'jabloko.gif'),
(232, ':jahu', 'jahu.gif'),
(233, ':jajca', 'jajca.gif'),
(234, ':jason', 'jason.gif'),
(235, ':java', 'java.gif'),
(236, ':jeh2', 'jeh2.gif'),
(237, ':juventus', 'juventus.gif'),
(238, ':kak_tebe', 'kak_tebe.gif'),
(239, ':kamaz', 'kamaz.gif'),
(240, ':kanabis', 'kanabis.gif'),
(241, ':ket', 'ket.gif'),
(242, ':killer', 'killer.gif'),
(243, ':kisa', 'kisa.gif'),
(244, ':kiss', 'kiss.gif'),
(245, ':kiss1', 'kiss1.gif'),
(246, ':kiss2', 'kiss2.gif'),
(247, ':kiss3', 'kiss3.gif'),
(248, ':klass', 'klass.gif'),
(249, ':klever', 'klever.gif'),
(250, ':kloun', 'kloun.gif'),
(251, ':kochin', 'kochin.gif'),
(252, ':kofe', 'kofe.gif'),
(253, ':kofein', 'kofein.gif'),
(254, ':koktel', 'koktel.gif'),
(255, ':koldun', 'koldun.gif'),
(256, ':kolyaska', 'kolyaska.gif'),
(257, ':konon', 'konon.gif'),
(258, ':konon2', 'konon2.gif'),
(259, ':konon_mobi_55154', 'konon_mobi_55154.gif'),
(260, ':konon_mobi_vinsent', 'konon_mobi_vinsent.gif'),
(261, ':kopilka', 'kopilka.gif'),
(262, ':korol', 'korol.gif'),
(263, ':korol2', 'korol2.gif'),
(264, ':korol3', 'korol3.gif'),
(265, ':korzina', 'korzina.gif'),
(266, ':kosa', 'kosa.gif'),
(267, ':kovyr3', 'kovyr3.gif'),
(268, ':kowak', 'kowak.gif'),
(269, ':krasn', 'krasn.gif'),
(270, ':krolik', 'krolik.gif'),
(271, ':krut', 'krut.gif'),
(272, ':krutoy', 'krutoy.gif'),
(273, ':kruzhki', 'kruzhki.gif'),
(274, ':kuku', 'kuku.gif'),
(275, ':kuku2', 'kuku2.gif'),
(276, ':kul', 'kul.gif'),
(277, ':kul2', 'kul2.gif'),
(278, ':kul3', 'kul3.gif'),
(279, ':kulak', 'kulak.gif'),
(280, ':kur', 'kur.gif'),
(281, ':kurit', 'kurit.gif'),
(282, ':kuvyr', 'kuvyr.gif'),
(283, ':kysja', 'kysja.gif'),
(284, ':laj', 'laj.gif'),
(285, ':lak', 'lak.gif'),
(286, ':lamer', 'lamer.gif'),
(287, ':landyw', 'landyw.gif'),
(288, ':lapa', 'lapa.gif'),
(289, ':larisu', 'larisu.gif'),
(290, ':lechitsja', 'lechitsja.gif'),
(291, ':ledenec', 'ledenec.gif'),
(292, ':letaet', 'letaet.gif'),
(293, ':lisa', 'lisa.gif'),
(294, ':liverpul', 'liverpul.gif'),
(295, ':loko', 'loko.gif'),
(296, ':lol', 'lol.gif'),
(297, ':lol2', 'lol2.gif'),
(298, ':love', 'love.gif'),
(299, ':love2', 'love2.gif'),
(300, ':loveman', 'loveman.gif'),
(301, ':lovemsg', 'lovemsg.gif'),
(302, ':lowadka', 'lowadka.gif'),
(303, ':luchnik', 'luchnik.gif'),
(304, ':luzha', 'luzha.gif'),
(305, ':lyzhi', 'lyzhi.gif'),
(306, ':mafiya', 'mafiya.gif'),
(307, ':mag', 'mag.gif'),
(308, ':mail', 'mail.gif'),
(309, ':malyw', 'malyw.gif'),
(310, ':mama', 'mama.gif'),
(311, ':mama2', 'mama2.gif'),
(312, ':man2', 'man2.gif'),
(313, ':man3', 'man3.gif'),
(314, ':maniak', 'maniak.gif'),
(315, ':manjuta', 'manjuta.gif'),
(316, ':martywka', 'martywka.gif'),
(317, ':mashinist', 'mashinist.gif'),
(318, ':mat', 'mat.gif'),
(319, ':maus', 'maus.gif'),
(320, ':mda', 'mda.gif'),
(321, ':mdja', 'mdja.gif'),
(322, ':ment', 'ment.gif'),
(323, ':ment2', 'ment2.gif'),
(324, ':mertvec', 'mertvec.gif'),
(325, ':metallist', 'metallist.gif'),
(326, ':milan', 'milan.gif'),
(327, ':mister', 'mister.gif'),
(328, ':miwa', 'miwa.gif'),
(329, ':miwka', 'miwka.gif'),
(330, ':miwutka', 'miwutka.gif'),
(331, ':mjach', 'mjach.gif'),
(332, ':mmg', 'mmg.gif'),
(333, ':mob', 'mob.gif'),
(334, ':moder', 'moder.gif'),
(335, ':moder2', 'moder2.gif'),
(336, ':mog', 'mog.gif'),
(337, ':mokujin', 'mokujin.gif'),
(338, ':molit', 'molit.gif'),
(339, ':molitva', 'molitva.gif'),
(340, ':money', 'money.gif'),
(341, ':moped', 'moped.gif'),
(342, ':morkovka', 'morkovka.gif'),
(343, ':morozhenoe', 'morozhenoe.gif'),
(344, ':moto', 'moto.gif'),
(345, ':mu', 'mu.gif'),
(346, ':muha', 'muha.gif'),
(347, ':music', 'music.gif'),
(348, ':musik', 'musik.gif'),
(349, ':muzon', 'muzon.gif'),
(350, ':mvd', 'mvd.gif'),
(351, ':nakol', 'nakol.gif'),
(352, ':nakone', 'nakone.gif'),
(353, ':napitok', 'napitok.gif'),
(354, ':nea', 'nea.gif'),
(355, ':neangel', 'neangel.gif'),
(356, ':neftehimik', 'neftehimik.gif'),
(357, ':nehuligan', 'nehuligan.gif'),
(358, ':nenado', 'nenado.gif'),
(359, ':nenado2', 'nenado2.gif'),
(360, ':neo', 'neo.gif'),
(361, ':neochem', 'neochem.gif'),
(362, ':nepovezlo', 'nepovezlo.gif'),
(363, ':net', 'net.gif'),
(364, ':netlyub', 'netlyub.gif'),
(365, ':nevozm', 'nevozm.gif'),
(366, ':newyear', 'newyear.gif'),
(367, ':neya', 'neya.gif'),
(368, ':neznaet', 'neznaet.gif'),
(369, ':neznaju', 'neznaju.gif'),
(370, ':neznayu', 'neznayu.gif'),
(371, ':nifiga', 'nifiga.gif'),
(372, ':night', 'night.gif'),
(373, ':nika', 'nika.gif'),
(374, ':ninja', 'ninja.gif'),
(375, ':nitki', 'nitki.gif'),
(376, ':nlo', 'nlo.gif'),
(377, ':no', 'no.gif'),
(378, ':nono', 'nono.gif'),
(379, ':novrus', 'novrus.gif'),
(380, ':nozh', 'nozh.gif'),
(381, ':nravitsya', 'nravitsya.gif'),
(382, ':nyam', 'nyam.gif'),
(383, ':nyam2', 'nyam2.gif'),
(384, ':obana', 'obana.gif'),
(385, ':obed', 'obed.gif'),
(386, ':obnimki', 'obnimki.gif'),
(387, ':obozhayu', 'obozhayu.gif'),
(388, ':obruch', 'obruch.gif'),
(389, ':offtop', 'offtop.gif'),
(390, ':offtopik', 'offtopik.gif'),
(391, ':ogogo', 'ogogo.gif'),
(392, ':oguryum', 'oguryum.gif'),
(393, ':ok', 'ok.gif'),
(394, ':olimp', 'olimp.gif'),
(395, ':oops', 'oops.gif'),
(396, ':opa', 'opa.gif'),
(397, ':opera', 'opera.gif'),
(398, ':or', 'or.gif'),
(399, ':orc', 'orc.gif'),
(400, ':osen', 'osen.gif'),
(401, ':osminog', 'osminog.gif'),
(402, ':otstoy', 'otstoy.gif'),
(403, ':owibochka', 'owibochka.gif'),
(404, ':oy', 'oy.gif'),
(405, ':pacak', 'pacak.gif'),
(406, ':palach', 'palach.gif'),
(407, ':paladin', 'paladin.gif'),
(408, ':pank', 'pank.gif'),
(409, ':papa', 'papa.gif'),
(410, ':pardon', 'pardon.gif'),
(411, ':pardon2', 'pardon2.gif'),
(412, ':parovoz1', 'parovoz1.gif'),
(413, ':parovoz2', 'parovoz2.gif'),
(414, ':parus', 'parus.gif'),
(415, ':pasiba', 'pasiba.gif'),
(416, ':pauk', 'pauk.gif'),
(417, ':persik', 'persik.gif'),
(418, ':pil', 'pil.gif'),
(419, ':pila', 'pila.gif'),
(420, ':pilot', 'pilot.gif'),
(421, ':pilotidiot', 'pilotidiot.gif'),
(422, ':pingv', 'pingv.gif'),
(423, ':pingvenok', 'pingvenok.gif'),
(424, ':pink', 'pink.gif'),
(425, ':pioner', 'pioner.gif'),
(426, ':piosmok', 'piosmok.gif'),
(427, ':pirat', 'pirat.gif'),
(428, ':pirat2', 'pirat2.gif'),
(429, ':piska', 'piska.gif'),
(430, ':pistolet', 'pistolet.gif'),
(431, ':pistolet2', 'pistolet2.gif'),
(432, ':pivo', 'pivo.gif'),
(433, ':piwet', 'piwet.gif'),
(434, ':pizdec', 'pizdec.gif'),
(435, ':pizza', 'pizza.gif'),
(436, ':plak', 'plak.gif'),
(437, ':plaksa', 'plaksa.gif'),
(438, ':plaksa2', 'plaksa2.gif'),
(439, ':plavaet', 'plavaet.gif'),
(440, ':ploho', 'ploho.gif'),
(441, ':plushit', 'plushit.gif'),
(442, ':podmig2', 'podmig2.gif'),
(443, ':podruzhki', 'podruzhki.gif'),
(444, ':pogran', 'pogran.gif'),
(445, ':pogubam', 'pogubam.gif'),
(446, ':poh', 'poh.gif'),
(447, ':poisk', 'poisk.gif'),
(448, ':poka', 'poka.gif'),
(449, ':poka2', 'poka2.gif'),
(450, ':poklon', 'poklon.gif'),
(451, ':popa', 'popa.gif'),
(452, ':popcorn', 'popcorn.gif'),
(453, ':popope', 'popope.gif'),
(454, ':pora', 'pora.gif'),
(455, ':porukam', 'porukam.gif'),
(456, ':porukam2', 'porukam2.gif'),
(457, ':porukam3', 'porukam3.gif'),
(458, ':poryadok', 'poryadok.gif'),
(459, ':posuda', 'posuda.gif'),
(460, ':povar', 'povar.gif'),
(461, ':poxt', 'poxt.gif'),
(462, ':pozhali', 'pozhali.gif'),
(463, ':pravila', 'pravila.gif'),
(464, ':prelest', 'prelest.gif'),
(465, ':preved', 'preved.gif'),
(466, ':princesa', 'princesa.gif'),
(467, ':princesa2', 'princesa2.gif'),
(468, ':privet', 'privet.gif'),
(469, ':proud', 'proud.gif'),
(470, ':pryatki', 'pryatki.gif'),
(471, ':pryg', 'pryg.gif'),
(472, ':ptica', 'ptica.gif'),
(473, ':pticy', 'pticy.gif'),
(474, ':puh', 'puh.gif'),
(475, ':puls', 'puls.gif'),
(476, ':punish', 'punish.gif'),
(477, ':puwki2', 'puwki2.gif'),
(478, ':puzyr', 'puzyr.gif'),
(479, ':pwag', 'pwag.gif'),
(480, ':pylesos', 'pylesos.gif'),
(481, ':q', 'q.gif'),
(482, ':queen', 'queen.gif'),
(483, ':rabochij', 'rabochij.gif'),
(484, ':rap', 'rap.gif'),
(485, ':razmaz', 'razmaz.gif'),
(486, ':read', 'read.gif'),
(487, ':realm', 'realm.gif'),
(488, ':respect', 'respect.gif'),
(489, ':reverans', 'reverans.gif'),
(490, ':rofl', 'rofl.gif'),
(491, ':rojal', 'rojal.gif'),
(492, ':rok', 'rok.gif'),
(493, ':rok2', 'rok2.gif'),
(494, ':roller', 'roller.gif'),
(495, ':roma', 'roma.gif'),
(496, ':romawki', 'romawki.gif'),
(497, ':rossija', 'rossija.gif'),
(498, ':rostov', 'rostov.gif'),
(499, ':roza', 'roza.gif'),
(500, ':roza2', 'roza2.gif'),
(501, ':roza3', 'roza3.gif'),
(502, ':roza4', 'roza4.gif'),
(503, ':roza5', 'roza5.gif'),
(504, ':roza6', 'roza6.gif'),
(505, ':roza7', 'roza7.gif'),
(506, ':roza8', 'roza8.gif'),
(507, ':roza9', 'roza9.gif'),
(508, ':rubin', 'rubin.gif'),
(509, ':rus', 'rus.gif'),
(510, ':rus2', 'rus2.gif'),
(511, ':rusruletka', 'rusruletka.gif'),
(512, ':russoldat', 'russoldat.gif'),
(513, ':ryba', 'ryba.gif'),
(514, ':rybak', 'rybak.gif'),
(515, ':rybalka2', 'rybalka2.gif'),
(516, ':rybka', 'rybka.gif'),
(517, ':rybka2', 'rybka2.gif'),
(518, ':rybu', 'rybu.gif'),
(519, ':rzhu', 'rzhu.gif'),
(520, ':sad', 'sad.gif'),
(521, ':salavat', 'salavat.gif'),
(522, ':saljut', 'saljut.gif'),
(523, ':samolet', 'samolet.gif'),
(524, ':santa', 'santa.gif'),
(525, ':santa2', 'santa2.gif'),
(526, ':santa3', 'santa3.gif'),
(527, ':sarkastik', 'sarkastik.gif'),
(528, ':sarkastik2', 'sarkastik2.gif'),
(529, ':saturn', 'saturn.gif'),
(530, ':se', 'se.gif'),
(531, ':seanim', 'seanim.gif'),
(532, ':seks', 'seks.gif'),
(533, ':seks2', 'seks2.gif'),
(534, ':selov', 'selov.gif'),
(535, ':senjor', 'senjor.gif'),
(536, ':serdce', 'serdce.gif'),
(537, ':serenada', 'serenada.gif'),
(538, ':sestra', 'sestra.gif'),
(539, ':sevilla', 'sevilla.gif'),
(540, ':sflagom', 'sflagom.gif'),
(541, ':shock11', 'shock11.gif'),
(542, ':shok', 'shok.gif'),
(543, ':shok2', 'shok2.gif'),
(544, ':silpriem', 'silpriem.gif'),
(545, ':siski', 'siski.gif'),
(546, ':skosoj', 'skosoj.gif'),
(547, ':skripka', 'skripka.gif'),
(548, ':skrjaga', 'skrjaga.gif'),
(549, ':skull', 'skull.gif'),
(550, ':skuter', 'skuter.gif'),
(551, ':sljuni', 'sljuni.gif'),
(552, ':slon', 'slon.gif'),
(553, ':slonik', 'slonik.gif'),
(554, ':sluzhba', 'sluzhba.gif'),
(555, ':sluzhba2', 'sluzhba2.gif'),
(556, ':smart', 'smart.gif'),
(557, ':smeh', 'smeh.gif'),
(558, ':smeh2', 'smeh2.gif'),
(559, ':smert', 'smert.gif'),
(560, ':smile', 'smile.gif'),
(561, ':smoke', 'smoke.gif'),
(562, ':snegur', 'snegur.gif'),
(563, ':snezhok', 'snezhok.gif'),
(564, ':sob', 'sob.gif'),
(565, ':sobaka', 'sobaka.gif'),
(566, ':sobarik', 'sobarik.gif'),
(567, ':soldat', 'soldat.gif'),
(568, ':solnce', 'solnce.gif'),
(569, ':sorri', 'sorri.gif'),
(570, ':sorry', 'sorry.gif'),
(571, ':sortir', 'sortir.gif'),
(572, ':sortir2', 'sortir2.gif'),
(573, ':spartak', 'spartak.gif'),
(574, ':spicy', 'spicy.gif'),
(575, ':spit', 'spit.gif'),
(576, ':sport1', 'sport1.gif'),
(577, ':spy', 'spy.gif'),
(578, ':star', 'star.gif'),
(579, ':stena', 'stena.gif'),
(580, ':stereo', 'stereo.gif'),
(581, ':stesnit', 'stesnit.gif'),
(582, ':stesnit2', 'stesnit2.gif'),
(583, ':stranno', 'stranno.gif'),
(584, ':strela', 'strela.gif'),
(585, ':suicid', 'suicid.gif'),
(586, ':suicid2', 'suicid2.gif'),
(587, ':sumas', 'sumas.gif'),
(588, ':sumas2', 'sumas2.gif'),
(589, ':surf', 'surf.gif'),
(590, ':svadba', 'svadba.gif'),
(591, ':svecha', 'svecha.gif'),
(592, ':svist', 'svist.gif'),
(593, ':tanec', 'tanec.gif'),
(594, ':tank', 'tank.gif'),
(595, ':tanz', 'tanz.gif'),
(596, ':tel', 'tel.gif'),
(597, ':telefon', 'telefon.gif'),
(598, ':teleskop', 'teleskop.gif'),
(599, ':tema', 'tema.gif'),
(600, ':tennis', 'tennis.gif'),
(601, ':tennis2', 'tennis2.gif'),
(602, ':terek', 'terek.gif'),
(603, ':tigr', 'tigr.gif'),
(604, ':tiho', 'tiho.gif'),
(605, ':tjulpan', 'tjulpan.gif'),
(606, ':tomat', 'tomat.gif'),
(607, ':tommi', 'tommi.gif'),
(608, ':tongue', 'tongue.gif'),
(609, ':tormoz', 'tormoz.gif'),
(610, ':torpedo', 'torpedo.gif'),
(611, ':torpedonn', 'torpedonn.gif'),
(612, ':tort', 'tort.gif'),
(613, ':tost', 'tost.gif'),
(614, ':translit', 'translit.gif'),
(615, ':trening', 'trening.gif'),
(616, ':triniti', 'triniti.gif'),
(617, ':truba4', 'truba4.gif'),
(618, ':uborka', 'uborka.gif'),
(619, ':uchen', 'uchen.gif'),
(620, ':ukaz', 'ukaz.gif'),
(621, ':ukraina', 'ukraina.gif'),
(622, ':ulitka', 'ulitka.gif'),
(623, ':ulitka2', 'ulitka2.gif'),
(624, ':umka', 'umka.gif'),
(625, ':umora', 'umora.gif'),
(626, ':ura', 'ura.gif'),
(627, ':ura2', 'ura2.gif'),
(628, ':ural', 'ural.gif'),
(629, ':usa', 'usa.gif'),
(630, ':vampir', 'vampir.gif'),
(631, ':vanna', 'vanna.gif'),
(632, ':vantuz', 'vantuz.gif'),
(633, ':vantuzom', 'vantuzom.gif'),
(634, ':varvar', 'varvar.gif'),
(635, ':vau', 'vau.gif'),
(636, ':vban', 'vban.gif'),
(637, ':vbanke', 'vbanke.gif'),
(638, ':vedma2', 'vedma2.gif'),
(639, ':vedqma', 'vedqma.gif'),
(640, ':velo', 'velo.gif'),
(641, ':velo2', 'velo2.gif'),
(642, ':ves', 'ves.gif'),
(643, ':vglaz', 'vglaz.gif'),
(644, ':victory', 'victory.gif'),
(645, ':vilka_nozh', 'vilka_nozh.gif'),
(646, ':vinni', 'vinni.gif'),
(647, ':vino', 'vino.gif'),
(648, ':vis', 'vis.gif'),
(649, ':vis2', 'vis2.gif'),
(650, ':viselica', 'viselica.gif'),
(651, ':vitjaz', 'vitjaz.gif'),
(652, ':viwnja', 'viwnja.gif'),
(653, ':viwnja2', 'viwnja2.gif'),
(654, ':vkusna', 'vkusna.gif'),
(655, ':vodolaz', 'vodolaz.gif'),
(656, ':volgann', 'volgann.gif'),
(657, ':vonyuchka', 'vonyuchka.gif'),
(658, ':vopros', 'vopros.gif'),
(659, ':vosadok', 'vosadok.gif'),
(660, ':voskl', 'voskl.gif'),
(661, ':vozdp', 'vozdp.gif'),
(662, ':vruku', 'vruku.gif'),
(663, ':vsempr', 'vsempr.gif'),
(664, ':vt', 'vt.gif'),
(665, ':vtopku', 'vtopku.gif'),
(666, ':vzasos', 'vzasos.gif'),
(667, ':w', 'w.gif'),
(668, ':wackogirl', 'wackogirl.gif'),
(669, ':wahter', 'wahter.gif'),
(670, ':wamp', 'wamp.gif'),
(671, ':wampanskoe', 'wampanskoe.gif'),
(672, ':wink', 'wink.gif'),
(673, ':wiza', 'wiza.gif'),
(674, ':wlep', 'wlep.gif'),
(675, ':woko', 'woko.gif'),
(676, ':wow', 'wow.gif'),
(677, ':wtanga', 'wtanga.gif'),
(678, ':wummi', 'wummi.gif'),
(679, ':wutka', 'wutka.gif'),
(680, ':wutnik', 'wutnik.gif'),
(681, ':wveja', 'wveja.gif'),
(682, ':xaxa', 'xaxa.gif'),
(683, ':xmas2', 'xmas2.gif'),
(684, ':xmm', 'xmm.gif'),
(685, ':xp', 'xp.gif'),
(686, ':yad', 'yad.gif'),
(687, ':yahoo', 'yahoo.gif'),
(688, ':yaza', 'yaza.gif'),
(689, ':yazyk', 'yazyk.gif'),
(690, ':yeh', 'yeh.gif'),
(691, ':yes', 'yes.gif'),
(692, ':yy', 'yy.gif'),
(693, ':zagruz', 'zagruz.gif'),
(694, ':zaigryvaet', 'zaigryvaet.gif'),
(695, ':zajca', 'zajca.gif'),
(696, ':zakosu', 'zakosu.gif'),
(697, ':zamerz', 'zamerz.gif'),
(698, ':zapiska', 'zapiska.gif'),
(699, ':zasos', 'zasos.gif'),
(700, ':zasyp', 'zasyp.gif'),
(701, ':zawtoroj', 'zawtoroj.gif'),
(702, ':zenit', 'zenit.gif'),
(703, ':zerkalo', 'zerkalo.gif'),
(704, ':zerkalo2', 'zerkalo2.gif'),
(705, ':zevaet', 'zevaet.gif'),
(706, ':zhaba', 'zhaba.gif'),
(707, ':zharko', 'zharko.gif'),
(708, ':zhopa', 'zhopa.gif'),
(709, ':zhuk', 'zhuk.gif'),
(710, ':zima', 'zima.gif'),
(711, ':zk', 'zk.gif'),
(712, ':zlaja', 'zlaja.gif'),
(713, ':zlo', 'zlo.gif'),
(714, ':zloj', 'zloj.gif'),
(715, ':zona', 'zona.gif'),
(716, ':zub', 'zub.gif'),
(717, ':zubch', 'zubch.gif'),
(718, ':zverjok', 'zverjok.gif'),
(719, ':zvezda', 'zvezda.gif'),
(720, ':zvezdy', 'zvezdy.gif');

CREATE TABLE IF NOT EXISTS `statuses` (
  `id` int(32) NOT NULL AUTO_INCREMENT,
  `user` int(32) NOT NULL,
  `text` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `time` int(11) NOT NULL,
  `who` text COLLATE utf8_unicode_ci NOT NULL,
  `type` text COLLATE utf8_unicode_ci NOT NULL,
  `refid` int(32) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=0 ;

CREATE TABLE IF NOT EXISTS `uins_sel` (
  `id` int(32) NOT NULL AUTO_INCREMENT,
  `title` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=0 ;

INSERT INTO `uins_sel` (`id`, `title`) VALUES
(2, '6 Знаки'),
(3, '7 Знаки'),
(4, '8 Знаки'),
(5, '9 Знаки');

CREATE TABLE IF NOT EXISTS `uins_uins` (
  `id` int(32) NOT NULL AUTO_INCREMENT,
  `id_sel` int(32) NOT NULL,
  `uin` int(9) NOT NULL,
  `password` varchar(8) COLLATE utf8_unicode_ci NOT NULL,
  `price` int(5) NOT NULL,
  `time` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=0 ;

CREATE TABLE IF NOT EXISTS `users` (
  `login` varchar(32) NOT NULL,
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `password` varchar(32) NOT NULL,
  `gender` varchar(1) NOT NULL,
  `level` varchar(1) NOT NULL,
  `birthday_day` varchar(2) NOT NULL,
  `birthday_month` varchar(2) NOT NULL,
  `birthday_year` varchar(4) NOT NULL,
  `name` varchar(32) NOT NULL,
  `style` varchar(20) NOT NULL,
  `reg_time` int(11) NOT NULL,
  `time` int(11) NOT NULL,
  `greeting` varchar(500) NOT NULL,
  `mail` varchar(32) DEFAULT NULL,
  `city` varchar(20) DEFAULT NULL,
  `country` varchar(32) DEFAULT NULL,
  `icq` int(20) DEFAULT NULL,
  `mobile` varchar(20) DEFAULT NULL,
  `about_me` varchar(5000) DEFAULT NULL,
  `interests` varchar(5000) DEFAULT NULL,
  `work` varchar(20) DEFAULT NULL,
  `purpose` tinyint(1) NOT NULL DEFAULT '0',
  `marriage` tinyint(1) NOT NULL DEFAULT '0',
  `smoke` tinyint(1) NOT NULL DEFAULT '0',
  `growth` varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `weight` varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `eyes` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `hair` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `constitution` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `whatido` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `music` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `films` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `books` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `rate` int(50) DEFAULT '0',
  `ip` varchar(20) NOT NULL,
  `foto` varchar(50) NOT NULL,
  `chat` int(32) NOT NULL,
  `ban` int(11) NOT NULL,
  `timesdvig` int(32) NOT NULL,
  `where` varchar(64) NOT NULL,
  `balls` int(32) NOT NULL,
  `age` int(32) NOT NULL,
  `countsee` int(32) NOT NULL,
  `chat_vict` int(32) NOT NULL,
  `prich_ban` text NOT NULL,
  `family` varchar(42) NOT NULL,
  `skype` varchar(42) NOT NULL,
  `phone` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;

INSERT INTO `users` (`login`, `id`, `password`, `gender`, `level`, `birthday_day`, `birthday_month`, `birthday_year`, `name`, `style`, `reg_time`, `time`, `greeting`, `mail`, `city`, `country`, `icq`, `mobile`, `about_me`, `interests`, `work`, `purpose`, `marriage`, `smoke`, `growth`, `weight`, `eyes`, `hair`, `constitution`, `whatido`, `music`, `films`, `books`, `rate`, `ip`, `foto`, `chat`, `ban`, `timesdvig`, `where`, `balls`, `age`, `countsee`, `chat_vict`, `prich_ban`, `family`, `skype`, `phone`) VALUES
('admin', 1, 'e10adc3949ba59abbe56e057f20f883e', '1', '3', '', '', '', 'admin', '', 1333728178, 1333728185, 'Всем привет!', 'admin@mail.ru', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '127.0.0.1', '', 0, 0, 0, '', 0, 0, 0, 0, '', '', '', '');

CREATE TABLE IF NOT EXISTS `votes` (
  `id` int(32) NOT NULL AUTO_INCREMENT,
  `count` int(32) NOT NULL,
  `title` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=0 ;

CREATE TABLE IF NOT EXISTS `votes_answers` (
  `id` int(32) NOT NULL AUTO_INCREMENT,
  `id_vote` int(32) NOT NULL,
  `title` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `count` int(32) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=0 ;

INSERT INTO `votes_answers` (`id`, `id_vote`, `title`, `count`) VALUES
(11, 4, 'Супер', 1),
(12, 4, 'Отлично', 0),
(13, 4, 'Плохо', 0),
(14, 4, 'Отстой', 0);

CREATE TABLE IF NOT EXISTS `votes_answers_users` (
  `id` int(32) NOT NULL AUTO_INCREMENT,
  `id_vote` int(32) NOT NULL,
  `id_user` int(32) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=0 ;

CREATE TABLE IF NOT EXISTS `wall` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_getter` int(11) NOT NULL,
  `id_sender` int(11) NOT NULL,
  `text` text COLLATE utf8_unicode_ci NOT NULL,
  `time` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=0 ;