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 */;
DROP TABLE IF EXISTS `antimat`;
CREATE TABLE `antimat` (
`mat_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`mat_string` varchar(100) NOT NULL,
PRIMARY KEY (`mat_id`)
) ENGINE=MyISAM AUTO_INCREMENT=122 DEFAULT CHARSET=utf8;
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');
DROP TABLE IF EXISTS `avatars`;
CREATE TABLE `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 AUTO_INCREMENT=570 DEFAULT CHARSET=latin1;
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');
DROP TABLE IF EXISTS `back`;
CREATE TABLE `back` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`ip` varchar(50) NOT NULL,
`link` varchar(75) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `book`;
CREATE TABLE `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 AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `cab_msg`;
CREATE TABLE `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 AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `chat`;
CREATE TABLE `chat` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` text NOT NULL,
`status` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `chat_msg`;
CREATE TABLE `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 AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `cms`;
CREATE TABLE `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 AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `dating`;
CREATE TABLE `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 AUTO_INCREMENT=220 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `ddos`;
CREATE TABLE `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 AUTO_INCREMENT=84927 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `diary`;
CREATE TABLE `diary` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `diary_cat`;
CREATE TABLE `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 AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `diary_com`;
CREATE TABLE `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 AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `diary_note`;
CREATE TABLE `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 AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `drug`;
CREATE TABLE `drug` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`my_login` text NOT NULL,
`send_login` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `files`;
CREATE TABLE `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 AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `files_com`;
CREATE TABLE `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 AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `files_com_status`;
CREATE TABLE `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 AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `files_my`;
CREATE TABLE `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 AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `files_rat`;
CREATE TABLE `files_rat` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`file` varchar(150) NOT NULL,
`login` varchar(30) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `files_spam`;
CREATE TABLE `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 AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `forum`;
CREATE TABLE `forum` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`themes` text,
`pod_themes` text,
`login` text,
`data` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `forum_themes`;
CREATE TABLE `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,
`time` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `forum_topic`;
CREATE TABLE `forum_topic` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`themes` text,
`topic` text,
`login` text,
`message` text,
`data` text,
`time` text,
`privat` text,
`edit` varchar(150) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=118 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `friend`;
CREATE TABLE `friend` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`kto` text NOT NULL,
`kogo` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `gallery`;
CREATE TABLE `gallery` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) CHARACTER SET utf8 NOT NULL,
`login` varchar(30) CHARACTER SET utf8 NOT NULL,
`opi` varchar(100) CHARACTER SET utf8 NOT NULL,
`data_reg` varchar(50) CHARACTER SET utf8 NOT NULL,
`data_edit` varchar(50) CHARACTER SET utf8 NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `gallery_anti`;
CREATE TABLE `gallery_anti` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_file` int(11) NOT NULL,
`login` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `gallery_com`;
CREATE TABLE `gallery_com` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_foto` int(11) NOT NULL,
`login` varchar(50) NOT NULL,
`data` varchar(50) NOT NULL,
`msg` varchar(150) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `gallery_foto`;
CREATE TABLE `gallery_foto` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_gallery` int(11) NOT NULL,
`name` varchar(50) NOT NULL,
`opi` varchar(100) NOT NULL,
`rat` int(11) NOT NULL,
`img` varchar(100) NOT NULL,
`login` varchar(50) NOT NULL,
`size` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `grop`;
CREATE TABLE `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 AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `grop_chat`;
CREATE TABLE `grop_chat` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_grop` int(11) NOT NULL,
`login` varchar(30) CHARACTER SET utf8 NOT NULL,
`msg` varchar(200) CHARACTER SET utf8 NOT NULL,
`time` int(11) NOT NULL,
`data` varchar(30) CHARACTER SET utf8 NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `grop_user`;
CREATE TABLE `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 AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `grop_user_in`;
CREATE TABLE `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 AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `history_ban`;
CREATE TABLE `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 AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `ignor`;
CREATE TABLE `ignor` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`kto` text NOT NULL,
`kogo` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `lic`;
CREATE TABLE `lic` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`key` varchar(8) NOT NULL,
`site` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `news`;
CREATE TABLE `news` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` text NOT NULL,
`news` text NOT NULL,
`data` text NOT NULL,
`login` text NOT NULL,
`time` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `news_kom`;
CREATE TABLE `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 AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `note`;
CREATE TABLE `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 AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `present`;
CREATE TABLE `present` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
INSERT INTO `present` (`id`, `name`) VALUES
(1, 'Игры');
DROP TABLE IF EXISTS `present_c`;
CREATE TABLE `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 AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
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);
DROP TABLE IF EXISTS `present_user`;
CREATE TABLE `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 AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `rating`;
CREATE TABLE `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 AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `reclama`;
CREATE TABLE `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 AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `send_mail`;
CREATE TABLE `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,
`response` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=408 DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `session`;
CREATE TABLE `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;
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;
DROP TABLE IF EXISTS `session_forum`;
CREATE TABLE `session_forum` (
`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;
DROP TABLE IF EXISTS `session_user`;
CREATE TABLE `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;
DROP TABLE IF EXISTS `session_vic`;
CREATE TABLE `session_vic` (
`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;
DROP TABLE IF EXISTS `setting`;
CREATE TABLE `setting` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`DBPORT` varchar(100) CHARACTER SET utf8 NOT NULL,
`DBNAME` varchar(100) CHARACTER SET utf8 NOT NULL,
`DBUSER` varchar(100) CHARACTER SET utf8 NOT NULL,
`DBPASS` varchar(100) CHARACTER SET utf8 NOT NULL,
`STYLEINT` varchar(100) CHARACTER SET utf8 NOT NULL,
`SITE` varchar(100) CHARACTER SET utf8 NOT NULL,
`doslimit` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `smiles`;
CREATE TABLE `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 AUTO_INCREMENT=128 DEFAULT CHARSET=utf8;
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');
DROP TABLE IF EXISTS `statistic`;
CREATE TABLE `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 AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `users`;
CREATE TABLE `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,
`avatar_main` varchar(100) DEFAULT NULL,
`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,
`vic` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=146 DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `vic`;
CREATE TABLE `vic` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`vopros` varchar(250) CHARACTER SET utf8 NOT NULL,
`otvet` text CHARACTER SET utf8 NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6476 DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `vic_msg`;
CREATE TABLE `vic_msg` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`login` varchar(50) CHARACTER SET utf8 NOT NULL,
`msg` varchar(500) CHARACTER SET utf8 NOT NULL,
`data` varchar(50) CHARACTER SET utf8 NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=166 DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `vic_vopros`;
CREATE TABLE `vic_vopros` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`vopros` varchar(500) CHARACTER SET utf8 NOT NULL,
`otvet` varchar(50) CHARACTER SET utf8 NOT NULL,
`pod` varchar(50) CHARACTER SET utf8 NOT NULL,
`pod_1` varchar(50) CHARACTER SET utf8 NOT NULL,
`pod_2` varchar(50) CHARACTER SET utf8 NOT NULL,
`step` varchar(10) CHARACTER SET utf8 NOT NULL,
`time` varchar(75) CHARACTER SET utf8 NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `vote`;
CREATE TABLE `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 AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `vote_answer`;
CREATE TABLE `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 AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `vote_golos`;
CREATE TABLE `vote_golos` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`vote` text,
`login` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `wall`;
CREATE TABLE `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 AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
/*!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 */;