DROP TABLE IF EXISTS `diary`;
CREATE TABLE `diary` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`msg` varchar(1024) DEFAULT NULL,
`time` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `time` (`time`)
) ENGINE=MyISAM AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;

INSERT INTO `diary` VALUES (1, '[b]??????? ????? ?? ??????[/b]<br/>?? ??????? 25 ????? ? 4 ?????', 1335500948, 1);
INSERT INTO `diary` VALUES (2, '[b]?? ??? ? ?????? 10 ????? ? ?? ????? 5 ?????, ? ????? ???????? 4 ?????[/b]', 1335549594, 1);
INSERT INTO `diary` VALUES (3, '[b]?? ??? ? ?????? 10 ????? ? ?? ????? 38 ?????, ? ????? ???????? 5 ?????[/b]', 1335550781, 1);
INSERT INTO `diary` VALUES (4, '[b]?? ??? ? ?????? 10 ????? ? ?? ????? 45 ?????, ? ????? ???????? 3 ?????[/b]', 1335552368, 1);
INSERT INTO `diary` VALUES (5, '[b]?? ??? ? ?????? 90 ????? ? ?? ????? 185 ?????, ? ????? ???????? 2 ?????[/b]', 1335558409, 1);
INSERT INTO `diary` VALUES (6, '[b]?? ??? ? ?????? 10 ????? ? ?? ????? 36 ?????, ? ????? ???????? 1 ?????[/b]', 1335561122, 1);
INSERT INTO `diary` VALUES (7, '[b]?? ??? ? ?????? 40 ????? ? ?? ????? 92 ?????, ? ????? ???????? 5 ?????[/b]', 1335586587, 1);
INSERT INTO `diary` VALUES (8, '[b]?? ??? ? ?????? 10 ????? ? ?? ????? 47 ?????, ? ????? ???????? 1 ?????[/b]', 1335587274, 1);
INSERT INTO `diary` VALUES (9, '[b]??????? ????? ?? ??????[/b]<br/>?? ??????? 13 ????? ? 2 ?????', 1335587350, 1);
INSERT INTO `diary` VALUES (10, '[b]?? ??? ? ?????? 90 ????? ? ?? ????? 221 ?????, ? ????? ???????? 3 ?????[/b]', 1335595282, 1);
INSERT INTO `diary` VALUES (11, '[b]?? ??? ? ?????? 80 ????? ? ?? ????? 185 ?????, ? ????? ???????? 5 ?????[/b]', 1335601402, 1);
INSERT INTO `diary` VALUES (12, '[b]?? ??? ? ?????? 10 ????? ? ?? ????? 47 ?????, ? ????? ???????? 5 ?????[/b]', 1335602720, 1);
INSERT INTO `diary` VALUES (13, '[b]??????? ????? ?? ??????[/b]<br/>?? ??????? 20 ????? ? 2 ?????', 1335613998, 2);
INSERT INTO `diary` VALUES (14, '[b]?? ??? ? ?????? 10 ????? ? ?? ????? 26 ?????, ? ????? ???????? 2 ?????[/b]', 1335621243, 2);
INSERT INTO `diary` VALUES (15, '[b]?? ??? ? ?????? 10 ????? ? ?? ????? 41 ?????, ? ????? ???????? 3 ?????[/b]', 1335624004, 2);
INSERT INTO `diary` VALUES (16, '[b]?? ??? ? ?????? 10 ????? ? ?? ????? 25 ?????, ? ????? ???????? 5 ?????[/b]', 1335632026, 2);
INSERT INTO `diary` VALUES (17, '[b]?? ??? ? ?????? 10 ????? ? ?? ????? 38 ?????, ? ????? ???????? 4 ?????[/b]', 1335634274, 2);
INSERT INTO `diary` VALUES (18, '[b]?? ??? ? ?????? 10 ????? ? ?? ????? 46 ?????, ? ????? ???????? 2 ?????[/b]', 1335635333, 2);
INSERT INTO `diary` VALUES (19, '[b]??????? ????? ?? ??????[/b]<br/>?? ??????? 8 ????? ? 4 ?????', 1335693337, 1);
INSERT INTO `diary` VALUES (20, '[b]?? ??? ? ?????? 90 ????? ? ?? ????? 191 ?????, ? ????? ???????? 14 ?????[/b]', 1335759788, 1);
INSERT INTO `diary` VALUES (21, '[b]???? ??????? ????????? ?? 2![/b]', 1335759788, 1);
INSERT INTO `diary` VALUES (22, '[b]??????? ????? ?? ??????[/b]<br/>?? ??????? 12 ????? ? 4 ?????', 1335796312, 1);
INSERT INTO `diary` VALUES (23, '[b]?? ??? ? ?????? 90 ????? ? ?? ????? 220 ?????, ? ????? ???????? 14 ?????[/b]', 1335878525, 1);
INSERT INTO `diary` VALUES (24, '[b]?? ??? ? ?????? 80 ????? ? ?? ????? 186 ?????, ? ????? ???????? 12 ?????[/b]', 1335930816, 1);
INSERT INTO `diary` VALUES (25, '[b]??????? ????? ?? ??????[/b]<br/>?? ??????? 18 ????? ? 3 ?????', 1335930816, 1);
INSERT INTO `diary` VALUES (26, '[b]?? ??? ? ?????? 10 ????? ? ?? ????? 70 ?????, ? ????? ???????? 3 ?????[/b]', 1335931530, 1);

DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`nick` varchar(32) NOT NULL,
`pass` varchar(32) NOT NULL,
`sess` varchar(32) DEFAULT NULL,
`ban` int(11) NOT NULL DEFAULT '0',
`ban_pr` varchar(64) DEFAULT NULL,
`ip` bigint(20) NOT NULL DEFAULT '0',
`ip_cl` bigint(20) NOT NULL DEFAULT '0',
`ip_xff` bigint(20) NOT NULL DEFAULT '0',
`ua` varchar(32) DEFAULT NULL,
`date_reg` int(11) NOT NULL DEFAULT '0',
`date_aut` int(11) NOT NULL DEFAULT '0',
`date_last` int(11) NOT NULL DEFAULT '0',
`level` enum('0','1','2','3','4') NOT NULL DEFAULT '0',
`pol` enum('0','1') NOT NULL DEFAULT '1',
`url` varchar(64) NOT NULL DEFAULT '/',
`show_url` enum('0','1') NOT NULL DEFAULT '0',
`ank_g_r` int(4) DEFAULT NULL,
`ank_m_r` int(2) DEFAULT NULL,
`ank_d_r` int(2) DEFAULT NULL,
`ank_city` varchar(32) DEFAULT NULL,
`ank_o_sebe` varchar(512) DEFAULT NULL,
`ank_icq` int(9) DEFAULT NULL,
`ank_mail` varchar(32) DEFAULT NULL,
`ank_n_tel` varchar(11) DEFAULT NULL,
`ank_name` varchar(32) DEFAULT NULL,
`set_p_str` int(11) DEFAULT '7',
`set_show_mail` enum('0','1') NOT NULL DEFAULT '0',
`meteo_country` int(11) NOT NULL DEFAULT '0',
`ava` enum('0','1') NOT NULL DEFAULT '0',
`read` enum('0','1') NOT NULL DEFAULT '0',
`lv` int(11) NOT NULL DEFAULT '1',
`opit` int(11) NOT NULL DEFAULT '0',
`life` int(11) NOT NULL DEFAULT '100',
`gold` int(11) NOT NULL DEFAULT '10',
`date_24` int(11) NOT NULL,
`go_time` int(11) NOT NULL DEFAULT '0',
`go_ost` int(11) NOT NULL DEFAULT '180',
`go_sk` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `nick` (`nick`),
KEY `url` (`url`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

INSERT INTO `users` VALUES (1, 'Admin', 'xchats1', 'f2H4Lg1z', 0, NULL, 1385287888, 0, 780473348, 'Opera Mini (Nokia2700c-2)', 0, 1335930816, 1335931558, '0', '1', '/', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 7, '0', 0, '0', '0', 2, 94, 100, 1794, 1336017216, 1335932158, 170, 10);
INSERT INTO `users` VALUES (2, '????', 'kakaka', 'JDAJWs1G', 0, NULL, 1385287820, 0, 2995121412, 'Opera Mini (Nokia2700c-2)', 0, 1335657696, 1335657889, '0', '1', '/', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 7, '0', 0, '0', '0', 1, 18, 100, 206, 1335700398, 1335663118, 130, 90);

