-- phpMyAdmin SQL Dump
-- version 3.4.3.2
-- http://www.phpmyadmin.net
--
-- Хост: localhost
-- Время создания: Июн 03 2012 г., 16:06
-- Версия сервера: 5.1.56
-- Версия PHP: 5.3.6
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- База данных: `my_cms_lite`
--
-- --------------------------------------------------------
--
-- Структура таблицы `antimat`
--
CREATE TABLE IF NOT EXISTS `antimat` (
`mat_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`mat_string` varchar(100) NOT NULL,
PRIMARY KEY (`mat_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=122 ;
--
-- Дамп данных таблицы `antimat`
--
INSERT INTO `antimat` (`mat_id`, `mat_string`) VALUES
(1, 'сука'),
(2, 'пидарас'),
(5, 'h2m'),
(6, 'wen'),
(7, 'keo'),
(8, 'com'),
(9, 'su'),
(10, 'net'),
(11, 'org'),
(12, 'бляд'),
(13, 'бля'),
(14, 'пецд'),
(15, 'песд'),
(16, 'пезд'),
(17, 'пицд'),
(18, 'пысд'),
(19, 'пызд'),
(20, 'пусд'),
(21, 'пузд'),
(22, 'писд'),
(23, 'пизд'),
(24, 'поху'),
(25, 'ахуу'),
(26, 'ахуе'),
(27, 'ахуи'),
(28, 'охую'),
(29, 'охуу'),
(30, 'охуе'),
(31, 'охуи'),
(32, 'хуу'),
(33, 'хуе'),
(34, 'хуё'),
(35, 'хуи'),
(36, 'хуй'),
(37, 'блад'),
(38, 'блят'),
(39, 'блать'),
(40, 'блйад'),
(41, 'блйат'),
(42, 'блиад'),
(43, 'блиат'),
(44, 'млят'),
(45, 'млат'),
(46, 'ёб'),
(47, 'ёп'),
(49, 'йоб'),
(50, 'иоб'),
(51, 'ъеб'),
(52, 'аёп'),
(53, 'аеб'),
(54, 'айоб'),
(55, 'оёб'),
(56, 'оеб'),
(57, 'уёб'),
(58, 'уёп'),
(59, 'уеб'),
(60, 'уйоб'),
(61, 'уиоб'),
(62, 'остопиздело'),
(63, 'мудаёб'),
(64, 'вспизднуть'),
(65, 'въебать'),
(66, 'ёбля'),
(67, 'съебаться'),
(68, 'схуярить'),
(69, 'впиздячить'),
(70, 'охуеть'),
(71, 'уебать'),
(72, 'Трахать'),
(73, 'Гавно'),
(75, 'соса'),
(76, 'саси'),
(77, 'соси'),
(78, 'соска'),
(79, 'дрочи'),
(80, 'драчи'),
(81, 'жоп'),
(82, 'пидор'),
(83, 'перд'),
(84, 'пидр'),
(85, 'педик'),
(86, 'пидар'),
(87, 'пидор'),
(88, 'муда'),
(89, 'муди'),
(90, 'ыеб'),
(91, 'иеб'),
(92, 'хуесос'),
(93, 'уебанан'),
(94, 'пиздиый'),
(95, 'ебанько'),
(96, 'ебу'),
(97, 'еба'),
(98, 'Чмо'),
(99, 'Пидфил'),
(100, 'хер'),
(101, 'МУДАК'),
(102, 'жопа'),
(103, 'бля'),
(104, 'блять'),
(105, 'бляди'),
(106, 'разъебай'),
(107, 'заёб'),
(108, 'изъёб'),
(109, 'дураёб'),
(110, 'долбоёб'),
(111, 'Хуедин'),
(112, 'хуёвый'),
(113, 'хую'),
(114, 'хули'),
(115, 'хуя'),
(116, 'худоебина'),
(117, 'sistem'),
(118, 'echo'),
(119, 'include'),
(120, 'meta'),
(121, 'script');
-- --------------------------------------------------------
--
-- Структура таблицы `avatars`
--
CREATE TABLE IF NOT EXISTS `avatars` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`status` int(11) NOT NULL,
`img` text CHARACTER SET utf8 NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=570 ;
--
-- Дамп данных таблицы `avatars`
--
INSERT INTO `avatars` (`id`, `status`, `img`) VALUES
(22, 1, '1.gif'),
(23, 1, '2.gif'),
(24, 1, '3.gif'),
(25, 1, '4.gif'),
(26, 1, '5.gif'),
(27, 1, '6.gif'),
(28, 1, '7.gif'),
(29, 1, '8.gif'),
(30, 1, '9.gif'),
(31, 1, '10.gif'),
(32, 1, '11.gif'),
(33, 1, '12.gif'),
(34, 1, '13.gif'),
(35, 1, '14.gif'),
(36, 1, '15.gif'),
(37, 1, '16.gif'),
(38, 1, '17.gif'),
(39, 1, '18.gif'),
(40, 1, '19.gif'),
(41, 1, '20.gif'),
(42, 1, '21.gif'),
(43, 1, '22.gif'),
(44, 1, '23.gif'),
(45, 1, '24.gif'),
(46, 1, '25.gif'),
(47, 1, '26.gif'),
(48, 1, '27.gif'),
(49, 1, '28.gif'),
(50, 1, '29.gif'),
(51, 1, '30.gif'),
(52, 1, '31.gif'),
(53, 1, '32.gif'),
(54, 1, '33.gif'),
(55, 1, '34.gif'),
(56, 1, '35.gif'),
(57, 1, '36.gif'),
(58, 1, '37.gif'),
(59, 1, '38.gif'),
(60, 1, '39.gif'),
(61, 1, '40.gif'),
(62, 1, '41.gif'),
(63, 1, '42.gif'),
(64, 1, '43.gif'),
(65, 1, '44.gif'),
(66, 1, '45.gif'),
(67, 1, '46.gif'),
(68, 1, '47.gif'),
(69, 1, '48.gif'),
(70, 1, '49.gif'),
(71, 1, '50.gif'),
(72, 1, '51.gif'),
(73, 1, '52.gif'),
(74, 1, '53.gif'),
(75, 1, '54.gif'),
(76, 1, '55.gif'),
(77, 1, '56.gif'),
(78, 1, '57.gif'),
(79, 1, '58.gif'),
(80, 1, '59.gif'),
(81, 1, '60.gif'),
(82, 1, '61.gif'),
(83, 1, '62.gif'),
(84, 1, '63.gif'),
(85, 1, '64.gif'),
(86, 1, '65.gif'),
(87, 1, '66.gif'),
(88, 1, '67.gif'),
(89, 1, '68.gif'),
(90, 1, '69.gif'),
(91, 1, '70.gif'),
(92, 1, '71.gif'),
(93, 1, '72.gif'),
(94, 1, '73.gif'),
(95, 1, '74.gif'),
(96, 1, '75.gif'),
(97, 1, '76.gif'),
(98, 1, '77.gif'),
(99, 1, '78.gif'),
(100, 1, '79.gif'),
(101, 1, '80.gif'),
(102, 1, '81.gif'),
(103, 1, '82.gif'),
(104, 1, '83.gif'),
(105, 1, '84.gif'),
(106, 1, '85.gif'),
(107, 1, '86.gif'),
(108, 1, '87.gif'),
(109, 1, '88.gif'),
(110, 1, '89.gif'),
(111, 1, '90.gif'),
(112, 1, '91.gif'),
(113, 1, '92.gif'),
(114, 1, '93.gif'),
(115, 1, '94.gif'),
(116, 1, '95.gif'),
(117, 1, '96.gif'),
(118, 1, '97.gif'),
(119, 1, '98.gif'),
(120, 1, '99.gif'),
(121, 1, '100.gif'),
(122, 1, '101.gif'),
(123, 1, '102.gif'),
(124, 1, '103.gif'),
(125, 1, '104.gif'),
(126, 1, '105.gif'),
(127, 1, '106.gif'),
(128, 1, '107.gif'),
(129, 1, '108.gif'),
(130, 1, '109.gif'),
(131, 1, '110.gif'),
(132, 1, '111.gif'),
(133, 1, '112.gif'),
(134, 1, '113.gif'),
(135, 1, '114.gif'),
(136, 1, '115.gif'),
(137, 1, '116.gif'),
(138, 1, '117.gif'),
(139, 1, '118.gif'),
(140, 1, '119.gif'),
(141, 1, '120.gif'),
(142, 1, '121.gif'),
(143, 1, '122.gif'),
(144, 1, '123.gif'),
(145, 1, '124.gif'),
(146, 1, '125.gif'),
(147, 1, '126.gif'),
(148, 1, '127.gif'),
(149, 1, '128.gif'),
(150, 1, '129.gif'),
(151, 1, '130.gif'),
(152, 1, '131.gif'),
(153, 1, '132.gif'),
(154, 1, '133.gif'),
(155, 1, '134.gif'),
(156, 1, '135.gif'),
(157, 1, '136.gif'),
(158, 1, '137.gif'),
(159, 1, '138.gif'),
(160, 1, '139.gif'),
(161, 1, '140.gif'),
(162, 1, '141.gif'),
(163, 1, '142.gif'),
(164, 1, '143.gif'),
(165, 1, '144.gif'),
(166, 1, '145.gif'),
(167, 1, '146.gif'),
(168, 1, '147.gif'),
(169, 1, '148.gif'),
(170, 1, '149.gif'),
(171, 1, '150.gif'),
(172, 1, '151.gif'),
(173, 1, '152.gif'),
(174, 1, '153.gif'),
(175, 1, '154.gif'),
(176, 1, '155.gif'),
(177, 1, '156.gif'),
(178, 1, '157.gif'),
(179, 1, '158.gif'),
(180, 1, '159.gif'),
(181, 1, '160.gif'),
(182, 1, '161.gif'),
(183, 1, '162.gif'),
(184, 1, '163.gif'),
(185, 1, '164.gif'),
(186, 1, '165.gif'),
(187, 1, '166.gif'),
(188, 1, '167.gif'),
(189, 1, '168.gif'),
(190, 1, '169.gif'),
(191, 1, '170.gif'),
(192, 1, '171.gif'),
(193, 1, '172.gif'),
(194, 1, '173.gif'),
(195, 1, '174.gif'),
(196, 1, '175.gif'),
(197, 1, '176.gif'),
(198, 1, '177.gif'),
(199, 1, '178.gif'),
(200, 1, '179.gif'),
(201, 1, '180.gif'),
(202, 1, '181.gif'),
(203, 1, '182.gif'),
(204, 1, '183.gif'),
(205, 1, '184.gif'),
(206, 1, '185.gif'),
(207, 1, '186.gif'),
(208, 1, '187.gif'),
(209, 1, '188.gif'),
(210, 1, '189.gif'),
(211, 1, '190.gif'),
(212, 1, '191.gif'),
(213, 1, '192.gif'),
(214, 1, '193.gif'),
(215, 1, '194.gif'),
(216, 1, '195.gif'),
(217, 1, '196.gif'),
(218, 1, '197.gif'),
(219, 1, '198.gif'),
(220, 1, '199.gif'),
(221, 1, '200.gif'),
(222, 1, '201.gif'),
(223, 1, '202.gif'),
(224, 1, '203.gif'),
(225, 1, '204.gif'),
(226, 1, '205.gif'),
(227, 1, '206.gif'),
(228, 1, '207.gif'),
(229, 1, '208.gif'),
(230, 1, '209.gif'),
(231, 1, '210.gif'),
(232, 1, '211.gif'),
(233, 1, '212.gif'),
(234, 1, '213.gif'),
(235, 1, '214.gif'),
(236, 1, '215.gif'),
(237, 1, '216.gif'),
(238, 1, '217.gif'),
(239, 1, '218.gif'),
(240, 1, '219.gif'),
(241, 1, '220.gif'),
(242, 1, '221.gif'),
(243, 1, '222.gif'),
(244, 1, '223.gif'),
(245, 1, '224.gif'),
(246, 1, '225.gif'),
(247, 1, '226.gif'),
(248, 1, '227.gif'),
(249, 1, '228.gif'),
(250, 1, '229.gif'),
(251, 1, '230.gif'),
(252, 1, '231.gif'),
(253, 1, '232.gif'),
(254, 1, '233.gif'),
(255, 1, '234.gif'),
(256, 1, '235.gif'),
(257, 1, '236.gif'),
(258, 1, '237.gif'),
(259, 1, '238.gif'),
(260, 1, '239.gif'),
(261, 1, '240.gif'),
(262, 1, '241.gif'),
(263, 1, '242.gif'),
(264, 1, '243.gif'),
(265, 1, '244.gif'),
(266, 1, '245.gif'),
(267, 1, '246.gif'),
(268, 1, '247.gif'),
(269, 1, '248.gif'),
(270, 1, '249.gif'),
(271, 1, '250.gif'),
(272, 1, '251.gif'),
(273, 1, '252.gif'),
(274, 1, '253.gif'),
(275, 1, '254.gif'),
(276, 1, '255.gif'),
(277, 1, '256.gif'),
(278, 1, '257.gif'),
(279, 1, '258.gif'),
(280, 1, '259.gif'),
(281, 1, '260.gif'),
(282, 1, '261.gif'),
(283, 1, '262.gif'),
(284, 1, '263.gif'),
(285, 1, '264.gif'),
(286, 1, '265.gif'),
(287, 1, '266.gif'),
(288, 1, '267.gif'),
(289, 1, '268.gif'),
(290, 1, '269.gif'),
(291, 1, '270.gif'),
(292, 1, '271.gif'),
(293, 1, '272.gif'),
(294, 1, '273.gif'),
(295, 1, '274.gif'),
(296, 1, '275.gif'),
(297, 1, '276.gif'),
(298, 1, '277.gif'),
(299, 1, '278.gif'),
(300, 1, '279.gif'),
(301, 1, '280.gif'),
(302, 1, '281.gif'),
(303, 1, '282.gif'),
(304, 1, '283.gif'),
(305, 1, '284.gif'),
(306, 1, '285.gif'),
(307, 1, '286.gif'),
(308, 1, '287.gif'),
(309, 1, '288.gif'),
(310, 1, '289.gif'),
(311, 1, '290.gif'),
(312, 1, '291.gif'),
(313, 1, '292.gif'),
(314, 1, '293.gif'),
(315, 1, '294.gif'),
(316, 1, '295.gif'),
(317, 1, '296.gif'),
(318, 1, '297.gif'),
(319, 1, '298.gif'),
(320, 1, '299.gif'),
(321, 1, '300.gif'),
(322, 2, '1.gif'),
(323, 2, '2.gif'),
(324, 2, '3.gif'),
(325, 2, '4.gif'),
(326, 2, '5.gif'),
(327, 2, '6.gif'),
(328, 2, '7.gif'),
(329, 2, '8.gif'),
(330, 2, '9.gif'),
(331, 2, '10.gif'),
(332, 2, '11.gif'),
(333, 2, '12.gif'),
(334, 2, '13.gif'),
(335, 2, '14.gif'),
(336, 2, '15.gif'),
(337, 2, '16.gif'),
(338, 2, '17.gif'),
(339, 2, '18.gif'),
(340, 2, '19.gif'),
(341, 2, '20.gif'),
(342, 2, '21.gif'),
(343, 2, '22.gif'),
(344, 2, '23.gif'),
(345, 2, '24.gif'),
(346, 2, '25.gif'),
(347, 2, '26.gif'),
(348, 2, '27.gif'),
(349, 2, '28.gif'),
(350, 2, '29.gif'),
(351, 2, '30.gif'),
(352, 2, '31.gif'),
(353, 2, '32.gif'),
(354, 2, '33.gif'),
(355, 2, '34.gif'),
(356, 2, '35.gif'),
(357, 2, '36.gif'),
(358, 2, '37.gif'),
(359, 2, '38.gif'),
(360, 2, '39.gif'),
(361, 2, '40.gif'),
(362, 2, '41.gif'),
(363, 2, '42.gif'),
(364, 2, '43.gif'),
(365, 2, '44.gif'),
(366, 2, '45.gif'),
(367, 2, '46.gif'),
(368, 2, '47.gif'),
(369, 2, '48.gif'),
(370, 2, '49.gif'),
(371, 2, '50.gif'),
(372, 2, '51.gif'),
(373, 2, '52.gif'),
(374, 2, '53.gif'),
(375, 2, '54.gif'),
(376, 2, '55.gif'),
(377, 2, '56.gif'),
(378, 2, '57.gif'),
(379, 2, '58.gif'),
(380, 2, '59.gif'),
(381, 2, '60.gif'),
(382, 2, '61.gif'),
(383, 2, '62.gif'),
(384, 2, '63.gif'),
(385, 2, '64.gif'),
(386, 2, '65.gif'),
(387, 2, '66.gif'),
(388, 2, '67.gif'),
(389, 2, '68.gif'),
(390, 2, '69.gif'),
(391, 2, '70.gif'),
(392, 2, '71.gif'),
(393, 2, '72.gif'),
(394, 2, '73.gif'),
(395, 2, '74.gif'),
(396, 2, '75.gif'),
(397, 2, '76.gif'),
(398, 2, '77.gif'),
(399, 2, '78.gif'),
(400, 2, '79.gif'),
(401, 2, '80.gif'),
(402, 2, '81.gif'),
(403, 2, '82.gif'),
(404, 2, '83.gif'),
(405, 2, '84.gif'),
(406, 2, '85.gif'),
(407, 2, '86.gif'),
(408, 2, '87.gif'),
(409, 2, '88.gif'),
(410, 2, '89.gif'),
(411, 2, '90.gif'),
(412, 2, '91.gif'),
(413, 2, '92.gif'),
(414, 2, '93.gif'),
(415, 2, '94.gif'),
(416, 2, '95.gif'),
(417, 2, '96.gif'),
(418, 2, '97.gif'),
(419, 2, '98.gif'),
(420, 2, '99.gif'),
(421, 2, '100.gif'),
(422, 2, '101.gif'),
(423, 2, '102.gif'),
(424, 2, '103.gif'),
(425, 2, '104.gif'),
(426, 2, '105.gif'),
(427, 2, '106.gif'),
(428, 2, '107.gif'),
(429, 2, '108.gif'),
(430, 2, '109.gif'),
(431, 2, '110.gif'),
(432, 2, '111.gif'),
(433, 2, '112.gif'),
(434, 2, '113.gif'),
(435, 2, '114.gif'),
(436, 2, '115.gif'),
(437, 2, '116.gif'),
(438, 2, '117.gif'),
(439, 2, '118.gif'),
(440, 2, '119.gif'),
(441, 2, '120.gif'),
(442, 2, '121.gif'),
(443, 2, '122.gif'),
(444, 2, '123.gif'),
(445, 2, '124.gif'),
(446, 2, '125.gif'),
(447, 2, '126.gif'),
(448, 2, '127.gif'),
(449, 2, '128.gif'),
(450, 2, '129.gif'),
(451, 2, '130.gif'),
(452, 2, '131.gif'),
(453, 2, '132.gif'),
(454, 2, '133.gif'),
(455, 2, '134.gif'),
(456, 2, '135.gif'),
(457, 2, '136.gif'),
(458, 2, '137.gif'),
(459, 2, '138.gif'),
(460, 2, '139.gif'),
(461, 2, '140.gif'),
(462, 2, '141.gif'),
(463, 2, '142.gif'),
(464, 2, '143.gif'),
(465, 2, '144.gif'),
(466, 2, '145.gif'),
(467, 2, '146.gif'),
(468, 2, '147.gif'),
(469, 2, '148.gif'),
(470, 2, '149.gif'),
(471, 2, '150.gif'),
(472, 2, '151.gif'),
(473, 2, '152.gif'),
(474, 2, '153.gif'),
(475, 2, '154.gif'),
(476, 2, '155.gif'),
(477, 2, '156.gif'),
(478, 2, '157.gif'),
(479, 2, '158.gif'),
(480, 2, '159.gif'),
(481, 2, '160.gif'),
(482, 2, '161.gif'),
(483, 2, '162.gif'),
(484, 2, '163.gif'),
(485, 2, '164.gif'),
(486, 2, '165.gif'),
(487, 2, '166.gif'),
(488, 2, '167.gif'),
(489, 2, '168.gif'),
(490, 2, '169.gif'),
(491, 2, '170.gif'),
(492, 2, '171.gif'),
(493, 2, '172.gif'),
(494, 2, '173.gif'),
(495, 2, '174.gif'),
(496, 2, '175.gif'),
(497, 2, '176.gif'),
(498, 2, '177.gif'),
(499, 2, '178.gif'),
(500, 2, '179.gif'),
(501, 2, '180.gif'),
(502, 2, '181.gif'),
(503, 2, '182.gif'),
(504, 2, '183.gif'),
(505, 2, '184.gif'),
(506, 2, '185.gif'),
(507, 2, '186.gif'),
(508, 2, '187.gif'),
(509, 2, '188.gif'),
(510, 2, '189.gif'),
(511, 2, '190.gif'),
(512, 2, '191.gif'),
(513, 2, '192.gif'),
(514, 2, '193.gif'),
(515, 2, '194.gif'),
(516, 2, '195.gif'),
(517, 2, '196.gif'),
(518, 2, '197.gif'),
(519, 2, '198.gif'),
(520, 2, '199.gif'),
(521, 2, '200.gif'),
(522, 2, '201.gif'),
(523, 2, '202.gif'),
(524, 2, '203.gif'),
(525, 2, '204.gif'),
(526, 2, '205.gif'),
(527, 2, '206.gif'),
(528, 2, '207.gif'),
(529, 2, '208.gif'),
(530, 2, '209.gif'),
(531, 2, '210.gif'),
(532, 2, '211.gif'),
(533, 2, '212.gif'),
(534, 2, '213.gif'),
(535, 2, '214.gif'),
(536, 2, '215.gif'),
(537, 2, '216.gif'),
(538, 2, '217.gif'),
(539, 2, '218.gif'),
(540, 2, '219.gif'),
(541, 2, '220.gif'),
(542, 2, '221.gif'),
(543, 2, '222.gif'),
(544, 2, '223.gif'),
(545, 2, '224.gif'),
(546, 2, '225.gif'),
(547, 2, '226.gif'),
(548, 2, '227.gif'),
(549, 2, '228.gif'),
(550, 2, '229.gif'),
(551, 2, '230.gif'),
(552, 2, '231.gif'),
(553, 2, '232.gif'),
(554, 2, '233.gif'),
(555, 2, '234.gif'),
(556, 2, '235.gif'),
(557, 2, '236.gif'),
(558, 2, '237.gif'),
(559, 2, '238.gif'),
(560, 2, '239.gif'),
(561, 2, '240.gif'),
(562, 2, '241.gif'),
(563, 2, '242.gif'),
(564, 2, '243.gif'),
(565, 2, '244.gif'),
(566, 2, '245.gif'),
(567, 2, '246.gif'),
(568, 2, '247.gif'),
(569, 2, '248.gif');
-- --------------------------------------------------------
--
-- Структура таблицы `ban`
--
CREATE TABLE IF NOT EXISTS `ban` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`login` text,
`ip` text,
`time` text,
`live` text,
`ban` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Структура таблицы `book`
--
CREATE TABLE IF NOT EXISTS `book` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`nik` varchar(30) CHARACTER SET utf8 NOT NULL,
`message` varchar(500) CHARACTER SET utf8 NOT NULL,
`data` varchar(35) NOT NULL,
`ip` varchar(30) NOT NULL,
`arbuz` varchar(30) NOT NULL,
`admin` varchar(500) CHARACTER SET utf8 NOT NULL,
`nik_status` text CHARACTER SET utf8,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Структура таблицы `cab`
--
CREATE TABLE IF NOT EXISTS `cab` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) CHARACTER SET utf8 NOT NULL,
`opi` varchar(100) CHARACTER SET utf8 NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Структура таблицы `cab_msg`
--
CREATE TABLE IF NOT EXISTS `cab_msg` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_cab` int(11) NOT NULL,
`name_cab` varchar(100) CHARACTER SET utf8 NOT NULL,
`name` varchar(20) CHARACTER SET utf8 NOT NULL,
`famil` varchar(40) CHARACTER SET utf8 NOT NULL,
`opi` varchar(1000) CHARACTER SET utf8 NOT NULL,
`icq` varchar(9) CHARACTER SET utf8 NOT NULL,
`site` varchar(50) CHARACTER SET utf8 NOT NULL,
`mail` varchar(50) CHARACTER SET utf8 NOT NULL,
`time` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Структура таблицы `chat`
--
CREATE TABLE IF NOT EXISTS `chat` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` text NOT NULL,
`status` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Структура таблицы `chat_msg`
--
CREATE TABLE IF NOT EXISTS `chat_msg` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_chat` int(11) NOT NULL,
`login` text NOT NULL,
`msg` text NOT NULL,
`data` text NOT NULL,
`arbuz` text NOT NULL,
`ip` text NOT NULL,
`time` text NOT NULL,
`privat` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Структура таблицы `cms`
--
CREATE TABLE IF NOT EXISTS `cms` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`tema` text NOT NULL,
`status` int(11) NOT NULL,
`msg` text NOT NULL,
`name` text NOT NULL,
`data` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Структура таблицы `dating`
--
CREATE TABLE IF NOT EXISTS `dating` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`login` text NOT NULL,
`name` text NOT NULL,
`sity` text NOT NULL,
`starna` text NOT NULL,
`data` text NOT NULL,
`about` text NOT NULL,
`interes` text NOT NULL,
`music` text NOT NULL,
`movie` text NOT NULL,
`book` text NOT NULL,
`status` text NOT NULL,
`oren` text NOT NULL,
`znakom` text NOT NULL,
`brak` text NOT NULL,
`partner` text NOT NULL,
`rost` int(11) NOT NULL,
`ves` text NOT NULL,
`glas` text NOT NULL,
`volos` text NOT NULL,
`body` text NOT NULL,
`xarakter` text NOT NULL,
`zanim` text NOT NULL,
`prof` text NOT NULL,
`smoke` text NOT NULL,
`img` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Структура таблицы `ddos`
--
CREATE TABLE IF NOT EXISTS `ddos` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`time` int(11) NOT NULL,
`ip` varchar(50) NOT NULL,
`url` varchar(150) NOT NULL,
`refer` varchar(300) NOT NULL,
`brow` varchar(50) NOT NULL,
`user` varchar(30) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Структура таблицы `diary`
--
CREATE TABLE IF NOT EXISTS `diary` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Структура таблицы `diary_cat`
--
CREATE TABLE IF NOT EXISTS `diary_cat` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_diary` int(11) NOT NULL,
`login` varchar(30) NOT NULL,
`data` varchar(30) NOT NULL,
`name` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Структура таблицы `diary_com`
--
CREATE TABLE IF NOT EXISTS `diary_com` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_diary_note` int(11) NOT NULL,
`login` varchar(30) NOT NULL,
`data` varchar(30) NOT NULL,
`msg` varchar(250) NOT NULL,
`time` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Структура таблицы `diary_note`
--
CREATE TABLE IF NOT EXISTS `diary_note` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_diary_cat` int(11) NOT NULL,
`login` varchar(30) NOT NULL,
`data` varchar(30) NOT NULL,
`name` varchar(70) NOT NULL,
`msg` varchar(1000) NOT NULL,
`count` int(11) NOT NULL,
`status` varchar(10) NOT NULL,
`time` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Структура таблицы `drug`
--
CREATE TABLE IF NOT EXISTS `drug` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`my_login` text NOT NULL,
`send_login` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Структура таблицы `files`
--
CREATE TABLE IF NOT EXISTS `files` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(150) NOT NULL,
`last` varchar(30) NOT NULL,
`kb` varchar(30) NOT NULL,
`data` varchar(30) NOT NULL,
`link` varchar(300) NOT NULL,
`login` varchar(30) NOT NULL,
`type` varchar(30) NOT NULL,
`opi` varchar(500) NOT NULL,
`count` int(11) NOT NULL,
`time` varchar(30) NOT NULL,
`plus` int(11) NOT NULL,
`minus` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Структура таблицы `files_com`
--
CREATE TABLE IF NOT EXISTS `files_com` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`file` varchar(150) NOT NULL,
`login` varchar(30) NOT NULL,
`msg` varchar(200) NOT NULL,
`data` varchar(30) NOT NULL,
`time` varchar(30) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Структура таблицы `files_com_status`
--
CREATE TABLE IF NOT EXISTS `files_com_status` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`file` varchar(150) NOT NULL,
`status` varchar(10) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Структура таблицы `files_my`
--
CREATE TABLE IF NOT EXISTS `files_my` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`link` varchar(300) NOT NULL,
`login` varchar(30) NOT NULL,
`file` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Структура таблицы `files_rat`
--
CREATE TABLE IF NOT EXISTS `files_rat` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`file` varchar(150) NOT NULL,
`login` varchar(30) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Структура таблицы `files_spam`
--
CREATE TABLE IF NOT EXISTS `files_spam` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_file` int(11) NOT NULL,
`name` varchar(150) NOT NULL,
`ip` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Структура таблицы `forum`
--
CREATE TABLE IF NOT EXISTS `forum` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`themes` text,
`pod_themes` text,
`login` text,
`data` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Структура таблицы `forum_themes`
--
CREATE TABLE IF NOT EXISTS `forum_themes` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`forum` text,
`themes` text,
`login` text,
`mail_login` varchar(30) NOT NULL,
`pod_themes` text,
`status` text,
`krep` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Структура таблицы `forum_topic`
--
CREATE TABLE IF NOT EXISTS `forum_topic` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`themes` text,
`topic` text,
`login` text,
`message` text,
`data` text,
`time` text,
`privat` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Структура таблицы `friend`
--
CREATE TABLE IF NOT EXISTS `friend` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`kto` text NOT NULL,
`kogo` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Структура таблицы `grop`
--
CREATE TABLE IF NOT EXISTS `grop` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`cozd` varchar(30) CHARACTER SET utf8 NOT NULL,
`lider` varchar(30) CHARACTER SET utf8 NOT NULL,
`moder` varchar(30) CHARACTER SET utf8 NOT NULL,
`exp` varchar(10) CHARACTER SET utf8 NOT NULL,
`status` varchar(10) CHARACTER SET utf8 NOT NULL,
`logo` varchar(50) CHARACTER SET utf8 NOT NULL,
`mini` varchar(50) CHARACTER SET utf8 NOT NULL,
`opi` varchar(200) CHARACTER SET utf8 NOT NULL,
`name` varchar(100) CHARACTER SET utf8 NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Структура таблицы `grop_chat`
--
CREATE TABLE IF NOT EXISTS `grop_chat` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_grop` int(11) NOT NULL,
`login` varchar(30) NOT NULL,
`msg` varchar(200) NOT NULL,
`time` int(11) NOT NULL,
`data` varchar(30) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Структура таблицы `grop_user`
--
CREATE TABLE IF NOT EXISTS `grop_user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_grop` int(11) NOT NULL,
`login` varchar(30) NOT NULL,
`time` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Структура таблицы `grop_user_in`
--
CREATE TABLE IF NOT EXISTS `grop_user_in` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_grop` int(11) NOT NULL,
`login` varchar(30) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Структура таблицы `history_ban`
--
CREATE TABLE IF NOT EXISTS `history_ban` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`login` text NOT NULL,
`data` text NOT NULL,
`pri` text NOT NULL,
`status` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Структура таблицы `ignor`
--
CREATE TABLE IF NOT EXISTS `ignor` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`kto` text NOT NULL,
`kogo` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Структура таблицы `news`
--
CREATE TABLE IF NOT EXISTS `news` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` text NOT NULL,
`news` text NOT NULL,
`data` text NOT NULL,
`login` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Структура таблицы `news_kom`
--
CREATE TABLE IF NOT EXISTS `news_kom` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_news` int(11) NOT NULL,
`login` text NOT NULL,
`msg` text NOT NULL,
`data` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Структура таблицы `note`
--
CREATE TABLE IF NOT EXISTS `note` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`login` text NOT NULL,
`msg` text NOT NULL,
`data` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Структура таблицы `present`
--
CREATE TABLE IF NOT EXISTS `present` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Дамп данных таблицы `present`
--
INSERT INTO `present` (`id`, `name`) VALUES
(1, 'Игры');
-- --------------------------------------------------------
--
-- Структура таблицы `present_c`
--
CREATE TABLE IF NOT EXISTS `present_c` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_present` int(11) NOT NULL,
`name` varchar(75) NOT NULL,
`img` varchar(50) NOT NULL,
`money` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
--
-- Дамп данных таблицы `present_c`
--
INSERT INTO `present_c` (`id`, `id_present`, `name`, `img`, `money`) VALUES
(1, 1, 'Три туза', 'cardgame_3189.png', 300),
(2, 1, 'Игровой автомат', 'package_games_arcade_7860.png', 300);
-- --------------------------------------------------------
--
-- Структура таблицы `present_user`
--
CREATE TABLE IF NOT EXISTS `present_user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`my_login` varchar(20) NOT NULL,
`send_login` varchar(20) NOT NULL,
`msg` varchar(150) NOT NULL,
`data` varchar(50) NOT NULL,
`img` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Структура таблицы `rating`
--
CREATE TABLE IF NOT EXISTS `rating` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`my_login` text NOT NULL,
`send_login` text NOT NULL,
`rat` text NOT NULL,
`data` text NOT NULL,
`msg` text NOT NULL,
`time` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Структура таблицы `reclama`
--
CREATE TABLE IF NOT EXISTS `reclama` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` text,
`color` text,
`g` text,
`link` text,
`opi` text,
`real_count` int(11) DEFAULT NULL,
`max_count` int(11) DEFAULT NULL,
`gde` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Структура таблицы `send_mail`
--
CREATE TABLE IF NOT EXISTS `send_mail` (
`my_login` text NOT NULL,
`send_login` text NOT NULL,
`msg` text CHARACTER SET utf8 NOT NULL,
`data` text NOT NULL,
`id` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Структура таблицы `session`
--
CREATE TABLE IF NOT EXISTS `session` (
`id_session` tinytext NOT NULL,
`putdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`user` tinytext NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `session_chat`
--
CREATE TABLE IF NOT EXISTS `session_chat` (
`id_session` tinytext NOT NULL,
`putdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`user` tinytext NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `session_user`
--
CREATE TABLE IF NOT EXISTS `session_user` (
`id_session` tinytext NOT NULL,
`putdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`user` tinytext NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `smiles`
--
CREATE TABLE IF NOT EXISTS `smiles` (
`smiles_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`smiles_cats` smallint(4) unsigned NOT NULL,
`smiles_name` varchar(20) NOT NULL,
`smiles_code` varchar(20) NOT NULL,
PRIMARY KEY (`smiles_id`),
KEY `smiles_cats` (`smiles_cats`),
KEY `smiles_code` (`smiles_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=128 ;
--
-- Дамп данных таблицы `smiles`
--
INSERT INTO `smiles` (`smiles_id`, `smiles_cats`, `smiles_name`, `smiles_code`) VALUES
(1, 1, '(.gif', ':('),
(2, 1, ').gif', ':)'),
(3, 1, '4moks.gif', ':4moks'),
(4, 1, 'D.gif', ':D'),
(5, 1, 'E.gif', ':E'),
(6, 1, 'aaa.gif', ':aaa'),
(7, 1, 'agree.gif', ':agree'),
(8, 1, 'airkiss.gif', ':airkiss'),
(9, 1, 'atlet.gif', ':atlet'),
(10, 1, 'baby.gif', ':baby'),
(11, 1, 'bant.gif', ':bant'),
(12, 1, 'be.gif', ':be'),
(13, 1, 'blin.gif', ':blin'),
(14, 1, 'blum.gif', ':blum'),
(15, 1, 'bomba.gif', ':bomba'),
(16, 1, 'bounce.gif', ':bounce'),
(17, 1, 'bugaga.gif', ':bugaga'),
(18, 1, 'buhoj.gif', ':buhoj'),
(19, 1, 'bwink.gif', ':bwink'),
(20, 1, 'cold.gif', ':cold'),
(21, 1, 'cool.gif', ':cool'),
(22, 1, 'cry.gif', ':cry'),
(23, 1, 'ded.gif', ':ded'),
(24, 1, 'derisive.gif', ':derisive'),
(25, 1, 'drool.gif', ':drool'),
(26, 1, 'duma.gif', ':duma'),
(27, 1, 'exercise.gif', ':exercise'),
(28, 1, 'faq.gif', ':faq'),
(29, 1, 'fermer.gif', ':fermer'),
(30, 1, 'fingal.gif', ':fingal'),
(31, 1, 'flirt.gif', ':flirt'),
(32, 1, 'fuck.gif', ':fuck'),
(33, 1, 'girl_blum.gif', ':girl_blum'),
(34, 1, 'girl_bye.gif', ':girl_bye'),
(35, 1, 'girl_cry.gif', ':girl_cry'),
(36, 1, 'girl_hide.gif', ':girl_hide'),
(37, 1, 'girl_wink.gif', ':girl_wink'),
(38, 1, 'girls.gif', ':girls'),
(39, 1, 'happy.gif', ':happy'),
(40, 1, 'heart.gif', ':heart'),
(41, 1, 'hello.gif', ':hello'),
(42, 1, 'help.gif', ':help'),
(43, 1, 'help2.gif', ':help2'),
(44, 1, 'hi.gif', ':hi'),
(45, 1, 'infat.gif', ':infat'),
(46, 1, 'kiss.gif', ':kiss'),
(47, 1, 'kiss2.gif', ':kiss2'),
(48, 1, 'klass.gif', ':klass'),
(49, 1, 'krut.gif', ':krut'),
(50, 1, 'krutoy.gif', ':krutoy'),
(51, 1, 'ku.gif', ':ku'),
(52, 1, 'kuku.gif', ':kuku'),
(53, 1, 'kulak.gif', ':kulak'),
(54, 1, 'lamer.gif', ':lamer'),
(55, 1, 'love.gif', ':love'),
(56, 1, 'love2.gif', ':love2'),
(58, 1, 'mail.gif', ':mail'),
(59, 1, 'mister.gif', ':mister'),
(60, 1, 'money.gif', ':money'),
(61, 1, 'moped.gif', ':moped'),
(62, 1, 'musik.gif', ':musik'),
(63, 1, 'nea.gif', ':nea'),
(64, 1, 'net.gif', ':net'),
(65, 1, 'neznaju.gif', ':neznaju'),
(66, 1, 'ninja.gif', ':ninja'),
(67, 1, 'no.gif', ':no'),
(68, 1, 'nono.gif', ':nono'),
(69, 1, 'nozh.gif', ':nozh'),
(70, 1, 'nyam.gif', ':nyam'),
(71, 1, 'nyam2.gif', ':nyam2'),
(72, 1, 'obana.gif', ':obana'),
(73, 1, 'ogogo.gif', ':ogogo'),
(74, 1, 'oops.gif', ':oops'),
(75, 1, 'opa.gif', ':opa'),
(76, 1, 'otstoy.gif', ':otstoy'),
(77, 1, 'oy.gif', ':oy'),
(78, 1, 'pirat.gif', ':pirat'),
(79, 1, 'pirat2.gif', ':pirat2'),
(80, 1, 'pistolet.gif', ':pistolet'),
(81, 1, 'pistolet2.gif', ':pistolet2'),
(82, 1, 'pizdec.gif', ':pizdec'),
(83, 1, 'poisk.gif', ':poisk'),
(84, 1, 'proud.gif', ':proud'),
(85, 1, 'puls.gif', ':puls'),
(86, 1, 'queen.gif', ':queen'),
(87, 1, 'rap.gif', ':rap'),
(88, 1, 'read.gif', ':read'),
(89, 1, 'respekt.gif', ':respekt'),
(90, 1, 'rok.gif', ':rok'),
(91, 1, 'rok2.gif', ':rok2'),
(92, 1, 'senjor.gif', ':senjor'),
(93, 1, 'shok.gif', ':shok'),
(94, 1, 'shok2.gif', ':shok2'),
(95, 1, 'skull.gif', ':skull'),
(96, 1, 'smert.gif', ':smert'),
(97, 1, 'smoke.gif', ':smoke'),
(98, 1, 'spy.gif', ':spy'),
(99, 1, 'strela.gif', ':strela'),
(100, 1, 'svist.gif', ':svist'),
(101, 1, 'tiho.gif', ':tiho'),
(102, 1, 'vau.gif', ':vau'),
(103, 1, 'victory.gif', ':victory'),
(106, 1, 'vtopku.gif', ':vtopku'),
(107, 1, 'wackogirl.gif', ':wackogirl'),
(108, 1, 'xaxa.gif', ':xaxa'),
(109, 1, 'xmm.gif', ':xmm'),
(110, 1, 'yu.gif', ':yu'),
(111, 1, 'zlo.gif', ':zlo'),
(112, 2, 'ban.gif', ':ban'),
(113, 2, 'ban2.gif', ':ban2'),
(114, 2, 'banned.gif', ':banned'),
(115, 2, 'closed.gif', ':closed'),
(116, 2, 'closed2.gif', ':closed2'),
(117, 2, 'devil.gif', ':devil'),
(118, 2, 'flood.gif', ':flood'),
(119, 2, 'flood2.gif', ':flood2'),
(120, 2, 'huligan.gif', ':huligan'),
(121, 2, 'ment.gif', ':ment'),
(122, 2, 'ment2.gif', ':ment2'),
(123, 2, 'moder.gif', ':moder'),
(124, 2, 'nika.gif', ':nika'),
(125, 2, 'offtop.gif', ':offtop'),
(126, 2, 'pravila.gif', ':pravila'),
(127, 2, 'zona.gif', ':zona');
-- --------------------------------------------------------
--
-- Структура таблицы `statistic`
--
CREATE TABLE IF NOT EXISTS `statistic` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`hits` int(11) DEFAULT NULL,
`host` int(11) DEFAULT NULL,
`hits_today` int(11) DEFAULT NULL,
`host_today` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Структура таблицы `users`
--
CREATE TABLE IF NOT EXISTS `users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`login` varchar(50) CHARACTER SET utf8 NOT NULL,
`pass` varchar(50) CHARACTER SET utf8 NOT NULL,
`mail` varchar(50) CHARACTER SET utf8 NOT NULL,
`activ` int(11) NOT NULL,
`money` text CHARACTER SET utf8,
`bank` text CHARACTER SET utf8,
`time` text CHARACTER SET utf8,
`level` int(11) NOT NULL,
`exp` text CHARACTER SET utf8,
`plus` int(11) NOT NULL,
`minus` int(11) NOT NULL,
`status` varchar(50) CHARACTER SET utf8 NOT NULL,
`pol` text CHARACTER SET utf8,
`name` text CHARACTER SET utf8,
`famil` text CHARACTER SET utf8,
`date` text CHARACTER SET utf8,
`aim` text CHARACTER SET utf8,
`strana` text CHARACTER SET utf8,
`gorod` text CHARACTER SET utf8,
`yvl` text CHARACTER SET utf8,
`mobil` text CHARACTER SET utf8,
`operator` text CHARACTER SET utf8,
`icq` text CHARACTER SET utf8,
`site` text CHARACTER SET utf8,
`last` text CHARACTER SET utf8,
`reg_data` text CHARACTER SET utf8,
`avatar_mini` text CHARACTER SET utf8,
`my_mail` int(11) NOT NULL DEFAULT '0',
`new` int(11) NOT NULL DEFAULT '0',
`act_mail` text,
`theme` text,
`hero` int(11) NOT NULL,
`ip` text NOT NULL,
`x-status` text CHARACTER SET utf8 NOT NULL,
`code_pass` varchar(8) NOT NULL,
`lost_pass_time` int(11) NOT NULL,
`act_mail_time` int(11) NOT NULL,
`send_mails` varchar(3) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Структура таблицы `vote`
--
CREATE TABLE IF NOT EXISTS `vote` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`vote` text,
`data` text NOT NULL,
`count` int(11) NOT NULL,
`close` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Структура таблицы `vote_answer`
--
CREATE TABLE IF NOT EXISTS `vote_answer` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`vote` int(11) NOT NULL,
`answer` text NOT NULL,
`count` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Структура таблицы `vote_golos`
--
CREATE TABLE IF NOT EXISTS `vote_golos` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`vote` text,
`login` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Структура таблицы `wall`
--
CREATE TABLE IF NOT EXISTS `wall` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`my_login` text NOT NULL,
`send_login` text NOT NULL,
`msg` text CHARACTER SET utf8 NOT NULL,
`data` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;