-- phpMyAdmin SQL Dump
-- version 4.2.12deb2+deb8u6
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Sep 30, 2019 at 06:35 PM
-- Server version: 5.5.62-0+deb8u1
-- PHP Version: 5.6.40-0+deb8u6

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 */;

--
-- Database: `akbarali_john`
--

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

--
-- Table structure for table `chats`
--

CREATE TABLE IF NOT EXISTS `chats` (
`id` int(10) unsigned NOT NULL,
  `user_id` int(10) NOT NULL,
  `name` varchar(32) NOT NULL,
  `message` text NOT NULL,
  `date` int(10) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `chats`
--

INSERT INTO `chats` (`id`, `user_id`, `name`, `message`, `date`) VALUES
(1, 1, 'admin', 'asasa\n', 1569856701),
(2, 1, 'admin', 'Salom Bu Johncmsda tuzilgan Akbarali 0dan tuzgan iltimos hatoliklar bo`lsa telegramda @kbaraliga yozing lekin tuzatib berishga kafolat bermayman', 1569856789),
(3, 1, 'admin', 'sdsds', 1569856820);

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

--
-- Table structure for table `cms_ads`
--

CREATE TABLE IF NOT EXISTS `cms_ads` (
`id` int(10) unsigned NOT NULL,
  `type` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `view` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `layout` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `count` int(10) unsigned NOT NULL DEFAULT '0',
  `count_link` int(10) unsigned NOT NULL DEFAULT '0',
  `name` text NOT NULL,
  `link` text NOT NULL,
  `to` int(10) unsigned NOT NULL DEFAULT '0',
  `color` varchar(10) NOT NULL DEFAULT '',
  `time` int(10) unsigned NOT NULL DEFAULT '0',
  `day` int(10) unsigned NOT NULL DEFAULT '0',
  `mesto` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `bold` tinyint(1) NOT NULL DEFAULT '0',
  `italic` tinyint(1) NOT NULL DEFAULT '0',
  `underline` tinyint(1) NOT NULL DEFAULT '0',
  `show` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `cms_album_cat`
--

CREATE TABLE IF NOT EXISTS `cms_album_cat` (
`id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL DEFAULT '0',
  `sort` int(10) unsigned NOT NULL DEFAULT '0',
  `name` varchar(40) NOT NULL DEFAULT '',
  `description` text NOT NULL,
  `password` varchar(20) NOT NULL DEFAULT '',
  `access` tinyint(4) unsigned NOT NULL DEFAULT '0'
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `cms_album_cat`
--

INSERT INTO `cms_album_cat` (`id`, `user_id`, `sort`, `name`, `description`, `password`, `access`) VALUES
(1, 1, 1, 'uUmumiy', '', '', 4);

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

--
-- Table structure for table `cms_album_comments`
--

CREATE TABLE IF NOT EXISTS `cms_album_comments` (
`id` int(10) unsigned NOT NULL,
  `sub_id` int(10) unsigned NOT NULL DEFAULT '0',
  `time` int(10) unsigned NOT NULL DEFAULT '0',
  `user_id` int(10) unsigned NOT NULL DEFAULT '0',
  `text` text NOT NULL,
  `reply` text NOT NULL,
  `attributes` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `cms_album_downloads`
--

CREATE TABLE IF NOT EXISTS `cms_album_downloads` (
  `user_id` int(10) unsigned NOT NULL DEFAULT '0',
  `file_id` int(10) unsigned NOT NULL DEFAULT '0',
  `time` int(10) unsigned NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `cms_album_files`
--

CREATE TABLE IF NOT EXISTS `cms_album_files` (
`id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `album_id` int(10) unsigned NOT NULL,
  `description` text NOT NULL,
  `img_name` varchar(100) NOT NULL DEFAULT '',
  `tmb_name` varchar(100) NOT NULL DEFAULT '',
  `time` int(10) unsigned NOT NULL DEFAULT '0',
  `comments` tinyint(1) NOT NULL DEFAULT '1',
  `comm_count` int(10) unsigned NOT NULL DEFAULT '0',
  `access` tinyint(4) unsigned NOT NULL DEFAULT '0',
  `vote_plus` int(11) NOT NULL DEFAULT '0',
  `vote_minus` int(11) NOT NULL DEFAULT '0',
  `views` int(10) unsigned NOT NULL DEFAULT '0',
  `downloads` int(10) unsigned NOT NULL DEFAULT '0',
  `unread_comments` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `cms_album_files`
--

INSERT INTO `cms_album_files` (`id`, `user_id`, `album_id`, `description`, `img_name`, `tmb_name`, `time`, `comments`, `comm_count`, `access`, `vote_plus`, `vote_minus`, `views`, `downloads`, `unread_comments`) VALUES
(1, 1, 1, '', 'img_1569856437.jpg', 'tmb_1569856437.jpg', 1569856437, 1, 0, 4, 0, 0, 0, 0, 0),
(2, 1, 1, '', 'img_1569856446.jpg', 'tmb_1569856446.jpg', 1569856446, 1, 0, 4, 0, 0, 0, 0, 0),
(3, 1, 1, '', 'img_1569856454.jpg', 'tmb_1569856456.jpg', 1569856456, 1, 0, 4, 0, 0, 0, 0, 0),
(4, 1, 1, '', 'img_1569856466.jpg', 'tmb_1569856467.jpg', 1569856467, 1, 0, 4, 0, 0, 0, 0, 0),
(5, 1, 1, '', 'img_1569856479.jpg', 'tmb_1569856480.jpg', 1569856480, 1, 0, 4, 0, 0, 0, 0, 0);

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

--
-- Table structure for table `cms_album_views`
--

CREATE TABLE IF NOT EXISTS `cms_album_views` (
  `user_id` int(10) unsigned NOT NULL DEFAULT '0',
  `file_id` int(10) unsigned NOT NULL DEFAULT '0',
  `time` int(10) unsigned NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `cms_album_votes`
--

CREATE TABLE IF NOT EXISTS `cms_album_votes` (
`id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL DEFAULT '0',
  `file_id` int(10) unsigned NOT NULL DEFAULT '0',
  `vote` tinyint(2) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `cms_ban_ip`
--

CREATE TABLE IF NOT EXISTS `cms_ban_ip` (
`id` int(10) unsigned NOT NULL,
  `ip1` bigint(11) NOT NULL DEFAULT '0',
  `ip2` bigint(11) NOT NULL DEFAULT '0',
  `ban_type` tinyint(4) NOT NULL DEFAULT '0',
  `link` varchar(100) NOT NULL,
  `who` varchar(25) NOT NULL,
  `reason` text NOT NULL,
  `date` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `cms_ban_users`
--

CREATE TABLE IF NOT EXISTS `cms_ban_users` (
`id` int(10) unsigned NOT NULL,
  `user_id` int(11) NOT NULL DEFAULT '0',
  `ban_time` int(11) NOT NULL DEFAULT '0',
  `ban_while` int(11) NOT NULL DEFAULT '0',
  `ban_type` tinyint(4) NOT NULL DEFAULT '1',
  `ban_who` varchar(30) NOT NULL DEFAULT '',
  `ban_ref` int(11) NOT NULL DEFAULT '0',
  `ban_reason` text NOT NULL,
  `ban_raz` varchar(30) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `cms_contact`
--

CREATE TABLE IF NOT EXISTS `cms_contact` (
`id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL DEFAULT '0',
  `from_id` int(10) unsigned NOT NULL DEFAULT '0',
  `time` int(10) unsigned NOT NULL DEFAULT '0',
  `type` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `friends` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `ban` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `man` tinyint(1) unsigned NOT NULL DEFAULT '0'
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `cms_contact`
--

INSERT INTO `cms_contact` (`id`, `user_id`, `from_id`, `time`, `type`, `friends`, `ban`, `man`) VALUES
(1, 2, 1, 1569857469, 1, 0, 0, 0),
(2, 1, 2, 1569857469, 1, 0, 0, 0);

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

--
-- Table structure for table `cms_counters`
--

CREATE TABLE IF NOT EXISTS `cms_counters` (
`id` int(10) unsigned NOT NULL,
  `sort` int(10) NOT NULL DEFAULT '1',
  `name` varchar(30) NOT NULL,
  `link1` text NOT NULL,
  `link2` text NOT NULL,
  `mode` tinyint(4) NOT NULL DEFAULT '1',
  `switch` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `cms_forum_files`
--

CREATE TABLE IF NOT EXISTS `cms_forum_files` (
`id` int(10) unsigned NOT NULL,
  `cat` int(10) unsigned NOT NULL DEFAULT '0',
  `subcat` int(10) unsigned NOT NULL DEFAULT '0',
  `topic` int(10) unsigned NOT NULL DEFAULT '0',
  `post` int(10) unsigned NOT NULL DEFAULT '0',
  `time` int(10) unsigned NOT NULL DEFAULT '0',
  `filename` text NOT NULL,
  `filetype` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `dlcount` int(10) unsigned NOT NULL DEFAULT '0',
  `del` tinyint(1) unsigned NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `cms_forum_rdm`
--

CREATE TABLE IF NOT EXISTS `cms_forum_rdm` (
  `topic_id` int(10) unsigned NOT NULL DEFAULT '0',
  `user_id` int(10) unsigned NOT NULL DEFAULT '0',
  `time` int(10) unsigned NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `cms_forum_vote`
--

CREATE TABLE IF NOT EXISTS `cms_forum_vote` (
`id` int(10) unsigned NOT NULL,
  `type` int(2) NOT NULL DEFAULT '0',
  `time` int(10) unsigned NOT NULL DEFAULT '0',
  `topic` int(10) unsigned NOT NULL DEFAULT '0',
  `name` varchar(200) NOT NULL,
  `count` int(10) unsigned NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `cms_forum_vote_users`
--

CREATE TABLE IF NOT EXISTS `cms_forum_vote_users` (
`id` int(10) unsigned NOT NULL,
  `user` int(11) NOT NULL DEFAULT '0',
  `topic` int(11) NOT NULL,
  `vote` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `cms_library_comments`
--

CREATE TABLE IF NOT EXISTS `cms_library_comments` (
`id` int(11) unsigned NOT NULL,
  `sub_id` int(11) unsigned NOT NULL,
  `time` int(11) NOT NULL,
  `user_id` int(11) unsigned NOT NULL,
  `text` text NOT NULL,
  `reply` text,
  `attributes` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `cms_library_rating`
--

CREATE TABLE IF NOT EXISTS `cms_library_rating` (
`id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `st_id` int(11) NOT NULL,
  `point` tinyint(1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `cms_mail`
--

CREATE TABLE IF NOT EXISTS `cms_mail` (
`id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL DEFAULT '0',
  `from_id` int(10) unsigned NOT NULL DEFAULT '0',
  `text` text NOT NULL,
  `time` int(10) unsigned NOT NULL DEFAULT '0',
  `read` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `sys` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `delete` int(10) unsigned NOT NULL DEFAULT '0',
  `file_name` varchar(100) NOT NULL DEFAULT '',
  `count` int(10) NOT NULL DEFAULT '0',
  `size` int(10) NOT NULL DEFAULT '0',
  `them` varchar(100) NOT NULL DEFAULT '',
  `spam` tinyint(1) unsigned NOT NULL DEFAULT '0'
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `cms_mail`
--

INSERT INTO `cms_mail` (`id`, `user_id`, `from_id`, `text`, `time`, `read`, `sys`, `delete`, `file_name`, `count`, `size`, `them`, `spam`) VALUES
(1, 2, 1, 'Salom Bu skrip Johncmsda Akbarali tomonidan 0dan modlandi. Iltimos mehnatni qadirlang. Men bilan bog`lanish telegram @kbarali https://m.ok.ru/akbarbek1 \r\nsana 30/09/2019 soat 20.26 \r\n\r\nIltimos bu profilni o`chirmang men shunchaki shu profilgan kirib turaman.', 1569857469, 0, 0, 0, '', 0, 0, '', 0);

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

--
-- Table structure for table `cms_news`
--

CREATE TABLE IF NOT EXISTS `cms_news` (
`id` int(10) unsigned NOT NULL,
  `refid` int(10) unsigned NOT NULL DEFAULT '0',
  `name` varchar(100) NOT NULL,
  `text` text NOT NULL,
  `user_id` int(10) unsigned NOT NULL DEFAULT '0',
  `time` int(11) unsigned NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cms_news`
--

INSERT INTO `cms_news` (`id`, `refid`, `name`, `text`, `user_id`, `time`) VALUES
(3, 2, 'SQLlar tiklanmoqda', 'Sayt sqllarini 0dan tiklamoqdamiz', 1, 1569855736);

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

--
-- Table structure for table `cms_news_cat`
--

CREATE TABLE IF NOT EXISTS `cms_news_cat` (
`id` int(10) unsigned NOT NULL,
  `realid` int(10) unsigned NOT NULL DEFAULT '0',
  `name` varchar(100) NOT NULL,
  `desc_enable` tinyint(1) unsigned NOT NULL DEFAULT '0'
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cms_news_cat`
--

INSERT INTO `cms_news_cat` (`id`, `realid`, `name`, `desc_enable`) VALUES
(2, 1, 'salom', 0);

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

--
-- Table structure for table `cms_news_comments`
--

CREATE TABLE IF NOT EXISTS `cms_news_comments` (
`id` int(10) unsigned NOT NULL,
  `refid` int(10) unsigned NOT NULL,
  `time` int(11) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `text` text NOT NULL,
  `reply` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `cms_news_rating`
--

CREATE TABLE IF NOT EXISTS `cms_news_rating` (
`id_rate` int(11) unsigned NOT NULL,
  `news` int(11) NOT NULL,
  `user_id` int(11) unsigned NOT NULL,
  `golos` tinyint(1) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `cms_sessions`
--

CREATE TABLE IF NOT EXISTS `cms_sessions` (
  `session_id` char(32) NOT NULL DEFAULT '',
  `ip` bigint(11) NOT NULL DEFAULT '0',
  `ip_via_proxy` bigint(11) NOT NULL DEFAULT '0',
  `browser` varchar(255) NOT NULL DEFAULT '',
  `lastdate` int(10) unsigned NOT NULL DEFAULT '0',
  `sestime` int(10) unsigned NOT NULL DEFAULT '0',
  `views` int(10) unsigned NOT NULL DEFAULT '0',
  `movings` smallint(5) unsigned NOT NULL DEFAULT '0',
  `place` varchar(100) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `cms_sessions`
--

INSERT INTO `cms_sessions` (`session_id`, `ip`, `ip_via_proxy`, `browser`, `lastdate`, `sestime`, `views`, `movings`, `place`) VALUES
('491309cd2d18be342bd786154efc244e', 3588649225, 0, 'Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/49.0.2623.112 Safari/537.36', 1569857267, 1569857179, 0, 3, 'registration');

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

--
-- Table structure for table `cms_settings`
--

CREATE TABLE IF NOT EXISTS `cms_settings` (
  `key` tinytext NOT NULL,
  `val` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `cms_settings`
--

INSERT INTO `cms_settings` (`key`, `val`) VALUES
('active', '1'),
('admp', 'panel'),
('antiflood', 'a:5:{s:4:"mode";i:2;s:3:"day";i:10;s:5:"night";i:30;s:7:"dayfrom";i:10;s:5:"dayto";i:22;}'),
('clean_time', '1569854546'),
('copyright', 'Powered by JohnCMS'),
('email', '@'),
('flsz', '4000'),
('gzip', '1'),
('homeurl', 'https://akbarali.zadc.ru'),
('karma', 'a:6:{s:12:"karma_points";i:5;s:10:"karma_time";i:86400;s:5:"forum";i:20;s:4:"time";i:0;s:2:"on";i:1;s:3:"adm";i:0;}'),
('lng', 'ru'),
('mod_reg', '2'),
('mod_forum', '2'),
('mod_guest', '2'),
('mod_lib', '2'),
('mod_gal', '2'),
('mod_down_comm', '1'),
('mod_down', '2'),
('mod_lib_comm', '1'),
('mod_gal_comm', '1'),
('meta_desc', 'Powered by JohnCMS http://johncms.com'),
('meta_key', 'johncms'),
('news', 'a:8:{s:4:"view";i:0;s:4:"size";i:200;s:8:"quantity";i:1;s:4:"days";i:0;s:6:"breaks";b:1;s:7:"smileys";b:1;s:4:"tags";b:1;s:3:"kom";b:1;}'),
('reg_message', ''),
('setting_mail', ''),
('skindef', 'akbar'),
('them_message', ''),
('timeshift', '0'),
('site_access', '2');

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

--
-- Table structure for table `cms_users_data`
--

CREATE TABLE IF NOT EXISTS `cms_users_data` (
`id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL DEFAULT '0',
  `key` varchar(30) NOT NULL DEFAULT '',
  `val` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `cms_users_guestbook`
--

CREATE TABLE IF NOT EXISTS `cms_users_guestbook` (
`id` int(10) unsigned NOT NULL,
  `sub_id` int(10) unsigned NOT NULL,
  `time` int(11) NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `text` text NOT NULL,
  `reply` text NOT NULL,
  `attributes` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `cms_users_iphistory`
--

CREATE TABLE IF NOT EXISTS `cms_users_iphistory` (
`id` bigint(20) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `ip` bigint(11) NOT NULL DEFAULT '0',
  `ip_via_proxy` bigint(11) NOT NULL DEFAULT '0',
  `time` int(10) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `download`
--

CREATE TABLE IF NOT EXISTS `download` (
`id` int(10) unsigned NOT NULL,
  `refid` int(11) NOT NULL DEFAULT '0',
  `adres` text NOT NULL,
  `time` int(11) NOT NULL DEFAULT '0',
  `name` text NOT NULL,
  `type` varchar(4) NOT NULL DEFAULT '',
  `avtor` varchar(25) NOT NULL DEFAULT '',
  `ip` text NOT NULL,
  `soft` text NOT NULL,
  `text` text NOT NULL,
  `screen` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `forum`
--

CREATE TABLE IF NOT EXISTS `forum` (
`id` int(10) unsigned NOT NULL,
  `refid` int(10) unsigned NOT NULL DEFAULT '0',
  `type` char(1) NOT NULL DEFAULT '',
  `time` int(10) unsigned NOT NULL DEFAULT '0',
  `user_id` int(10) unsigned NOT NULL DEFAULT '0',
  `from` varchar(25) NOT NULL DEFAULT '',
  `realid` int(3) NOT NULL DEFAULT '0',
  `ip` bigint(11) NOT NULL DEFAULT '0',
  `ip_via_proxy` bigint(11) NOT NULL DEFAULT '0',
  `soft` text NOT NULL,
  `text` text NOT NULL,
  `close` tinyint(1) NOT NULL DEFAULT '0',
  `close_who` varchar(25) NOT NULL DEFAULT '',
  `vip` tinyint(1) NOT NULL DEFAULT '0',
  `edit` text NOT NULL,
  `tedit` int(10) unsigned NOT NULL DEFAULT '0',
  `kedit` int(2) unsigned NOT NULL DEFAULT '0',
  `curators` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `forum_arz`
--

CREATE TABLE IF NOT EXISTS `forum_arz` (
`id` int(11) NOT NULL,
  `post_id` varchar(255) DEFAULT NULL,
  `user_id` varchar(10) DEFAULT '0',
  `arzchi_id` varchar(10) DEFAULT '0',
  `arz` varchar(350) NOT NULL DEFAULT '',
  `time` int(10) unsigned NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

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

--
-- Table structure for table `forum_chat`
--

CREATE TABLE IF NOT EXISTS `forum_chat` (
`id` int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
  `javob` int(11) NOT NULL,
  `text` text NOT NULL,
  `time` int(11) NOT NULL,
  `sekret` int(11) NOT NULL,
  `read` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `forum_group`
--

CREATE TABLE IF NOT EXISTS `forum_group` (
`id` int(11) NOT NULL,
  `oplata` varchar(244) DEFAULT '0',
  `user_id` varchar(10) NOT NULL,
  `status` varchar(244) NOT NULL,
  `img` varchar(244) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `forum_group_add`
--

CREATE TABLE IF NOT EXISTS `forum_group_add` (
`id` int(11) NOT NULL,
  `user_id` varchar(244) NOT NULL,
  `phone` varchar(10) NOT NULL,
  `group` varchar(244) NOT NULL,
  `wmid` varchar(244) NOT NULL,
  `wmr` varchar(244) NOT NULL,
  `wmz` varchar(244) NOT NULL,
  `time` int(10) unsigned NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `forum_lenta`
--

CREATE TABLE IF NOT EXISTS `forum_lenta` (
`id` int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
  `id_tema` int(11) NOT NULL,
  `time` int(11) NOT NULL,
  `read` set('0','1') NOT NULL DEFAULT '0',
  `count` int(11) NOT NULL,
  `ot_kogo` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `forum_mavzu`
--

CREATE TABLE IF NOT EXISTS `forum_mavzu` (
`id` int(11) NOT NULL,
  `tema` varchar(244) NOT NULL,
  `us` varchar(244) NOT NULL,
  `javob` varchar(244) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `forum_mehmon`
--

CREATE TABLE IF NOT EXISTS `forum_mehmon` (
`id` int(11) NOT NULL,
  `id_ank` int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
  `read` enum('0','1') NOT NULL DEFAULT '1',
  `time` int(11) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `forum_mehmon`
--

INSERT INTO `forum_mehmon` (`id`, `id_ank`, `id_user`, `read`, `time`) VALUES
(1, 1, 2, '1', 1569857280);

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

--
-- Table structure for table `forum_rahmat`
--

CREATE TABLE IF NOT EXISTS `forum_rahmat` (
`id` int(11) NOT NULL,
  `post_id` varchar(255) DEFAULT NULL,
  `tema_id` varchar(10) DEFAULT '0',
  `user_id` varchar(10) DEFAULT '0',
  `kimga` varchar(10) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

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

--
-- Table structure for table `forum_reply`
--

CREATE TABLE IF NOT EXISTS `forum_reply` (
`id` int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
  `mavzu` varchar(244) NOT NULL,
  `read` enum('0','1') NOT NULL DEFAULT '1',
  `time` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `forum_votte`
--

CREATE TABLE IF NOT EXISTS `forum_votte` (
`id` int(11) NOT NULL,
  `post_id` varchar(255) DEFAULT NULL,
  `tema_id` varchar(10) DEFAULT '0',
  `user_id` varchar(10) DEFAULT '0',
  `kimga` varchar(10) DEFAULT '0',
  `votte` varchar(10) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

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

--
-- Table structure for table `forum_zaklad`
--

CREATE TABLE IF NOT EXISTS `forum_zaklad` (
`id` int(11) NOT NULL,
  `tema` varchar(244) NOT NULL,
  `us` varchar(244) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `gallery`
--

CREATE TABLE IF NOT EXISTS `gallery` (
`id` int(10) unsigned NOT NULL,
  `refid` int(11) NOT NULL DEFAULT '0',
  `time` int(11) NOT NULL DEFAULT '0',
  `type` varchar(2) NOT NULL DEFAULT '',
  `avtor` varchar(25) NOT NULL DEFAULT '',
  `text` text NOT NULL,
  `name` text NOT NULL,
  `user` binary(1) NOT NULL DEFAULT '\0',
  `ip` text NOT NULL,
  `soft` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `guest`
--

CREATE TABLE IF NOT EXISTS `guest` (
`id` int(10) unsigned NOT NULL,
  `adm` tinyint(1) NOT NULL DEFAULT '0',
  `time` int(10) unsigned NOT NULL DEFAULT '0',
  `user_id` int(10) unsigned NOT NULL DEFAULT '0',
  `name` varchar(25) NOT NULL DEFAULT '',
  `text` text NOT NULL,
  `ip` bigint(11) NOT NULL DEFAULT '0',
  `browser` tinytext NOT NULL,
  `admin` varchar(25) NOT NULL DEFAULT '',
  `otvet` text NOT NULL,
  `otime` int(10) unsigned NOT NULL DEFAULT '0',
  `edit_who` varchar(20) NOT NULL DEFAULT '',
  `edit_time` int(10) unsigned NOT NULL DEFAULT '0',
  `edit_count` tinyint(3) unsigned NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `karma_users`
--

CREATE TABLE IF NOT EXISTS `karma_users` (
`id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL DEFAULT '0',
  `name` varchar(50) NOT NULL DEFAULT '',
  `karma_user` int(10) unsigned NOT NULL DEFAULT '0',
  `points` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `type` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `time` int(10) unsigned NOT NULL DEFAULT '0',
  `text` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `library_cats`
--

CREATE TABLE IF NOT EXISTS `library_cats` (
`id` int(10) unsigned NOT NULL,
  `parent` int(10) unsigned NOT NULL DEFAULT '0',
  `name` varchar(200) NOT NULL DEFAULT '',
  `description` text NOT NULL,
  `dir` tinyint(1) NOT NULL DEFAULT '0',
  `pos` int(10) unsigned NOT NULL DEFAULT '0',
  `user_add` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `library_cats`
--

INSERT INTO `library_cats` (`id`, `parent`, `name`, `description`, `dir`, `pos`, `user_add`) VALUES
(1, 0, 'aKBARALI', '', 0, 1, 0);

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

--
-- Table structure for table `library_tags`
--

CREATE TABLE IF NOT EXISTS `library_tags` (
`id` int(10) unsigned NOT NULL,
  `lib_text_id` int(10) unsigned NOT NULL DEFAULT '0',
  `tag_name` varchar(255) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `library_texts`
--

CREATE TABLE IF NOT EXISTS `library_texts` (
`id` int(10) unsigned NOT NULL,
  `cat_id` int(10) unsigned NOT NULL DEFAULT '0',
  `text` mediumtext NOT NULL,
  `name` varchar(255) NOT NULL DEFAULT '',
  `announce` text,
  `uploader` varchar(100) NOT NULL DEFAULT '',
  `uploader_id` int(10) unsigned NOT NULL DEFAULT '0',
  `count_views` int(10) unsigned NOT NULL DEFAULT '0',
  `premod` tinyint(1) NOT NULL DEFAULT '0',
  `comments` tinyint(1) NOT NULL DEFAULT '0',
  `count_comments` int(10) unsigned NOT NULL DEFAULT '0',
  `time` int(10) unsigned NOT NULL DEFAULT '0'
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `library_texts`
--

INSERT INTO `library_texts` (`id`, `cat_id`, `text`, `name`, `announce`, `uploader`, `uploader_id`, `count_views`, `premod`, `comments`, `count_comments`, `time`) VALUES
(1, 1, '[ Фотография ]\r\nФарғонада бир маҳлуқ пайдо бўлибди эмиш. У маҳлуқнинг гавдаси молдан сал кичик, эшшакдан каттароқ экан. Хуллас эшшакнинг тугаши – молнинг бошланиши эмиш. Башараси узоқдан чўчқани эслатиб юборар экан. Маҳлуқ пана-пистирмадан тинч аҳолига ҳамла қилиб, асосан аёлларнинг этагига ёпишаётган эмиш. Маҳаллий аҳолининг айтишига қараганда ушбу маҳлуқ бундан аввалроқ Фарғонанинг Тошлоқ тумани ва Риштон аҳолисининг ҳам тинчини бузган экан, мана энди бутун Фарғона аҳлининг ғазабига тегаётган эмиш. Фарғоналик фермер Тошмат ота: - Агар ушбу маҳлуқ менинг қўлимга тушиб қолса, мол бўладими у, эшшак бўладими, манга деса чўчқа бўлмайди-ми, унинг думини қайириб ўзининг к... ...кир оғзига тиқиб қўяман – дейди. Нима ҳам дер эдик, биз Фарғона аҳлига сабр тилаб, ушбу маҳлуққа хушёр бўлишларини тилаб қоламиз!\r\n(Матндаги реал ҳаёт билан ҳар қандай ўхшашлик – тасодиф).\r\n\r\n@RaisBuva', 'Cho`chqalar ko`paymoqda', '[ Фотография ]\r\nФарғонада бир маҳлуқ пайдо бўлибди эмиш. У маҳлуқнинг гавдаси молдан сал кичик, эшшакдан каттароқ экан. Хуллас эшшакнинг тугаши – молнинг бошланиши эмиш. Башараси узоқдан чўчқани эслатиб юборар экан. Маҳлуқ пана-пистирмадан тинч аҳолига ҳамла қилиб, асосан аёлларнинг этагига ёпишаётган эмиш. Маҳаллий аҳолининг айтишига қараганда ушбу маҳлуқ бундан аввалроқ Фарғонанинг Тошлоқ тумани ва Риштон аҳолисининг ҳам тинчини бузган экан, мана энди бутун Фарғона аҳлининг ғазабига тегаётган ', 'admin', 1, 1, 1, 1, 0, 1569856299),
(2, 1, '[ Фотография ]\r\nБу эса имконияти чекланган инсонлар учун ер ости йўлида яратилган удар шароит. #форсаж\r\n"Ўзбекистон тарихи" давлат музейи томонга ўтиш йўлаги. Тошкент.  Ўзбекистон. XXI-аср. \r\n\r\nКеча ушбу йўлакдан бир инсонни аравачада олиб чиқишмоқчи бўлишган ва жуда қийналишган. Кейин шу ер ости йўлига жавобгар шахсларни қаттиқ "дуо" қилишибди.\r\n\r\n@RaisBuva', 'Nogironlik yo`lakchalaRI', '[ Фотография ]\r\nБу эса имконияти чекланган инсонлар учун ер ости йўлида яратилган удар шароит. #форсаж\r\n"Ўзбекистон тарихи" давлат музейи томонга ўтиш йўлаги. Тошкент.  Ўзбекистон. XXI-аср. \r\n\r\nКеча ушбу йўлакдан бир инсонни аравачада олиб чиқишмоқчи бўлишган ва жуда қийналишган. Кейин шу ер ости йўлига жавобгар шахсларни қаттиқ "дуо" қилишибди.\r\n\r\n@RaisBuva', 'admin', 1, 0, 1, 1, 0, 1569856373);

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

--
-- Table structure for table `lider`
--

CREATE TABLE IF NOT EXISTS `lider` (
`id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `time` int(11) NOT NULL,
  `text` varchar(255) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `lider`
--

INSERT INTO `lider` (`id`, `user_id`, `time`, `text`) VALUES
(1, 1, 1572448535, 'Bu akbarali tomonidan 30/09/2019 yil soat 20.12 da tarqatish uchun tuzildi.');

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

--
-- Table structure for table `news`
--

CREATE TABLE IF NOT EXISTS `news` (
`id` int(10) unsigned NOT NULL,
  `time` int(10) unsigned NOT NULL DEFAULT '0',
  `avt` varchar(25) NOT NULL DEFAULT '',
  `name` text NOT NULL,
  `text` text NOT NULL,
  `kom` int(10) unsigned NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `users`
--

CREATE TABLE IF NOT EXISTS `users` (
`id` int(10) unsigned NOT NULL,
  `name` varchar(25) NOT NULL DEFAULT '',
  `name_lat` varchar(40) NOT NULL DEFAULT '',
  `password` varchar(32) NOT NULL DEFAULT '',
  `rights` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `failed_login` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `imname` varchar(50) NOT NULL DEFAULT '',
  `sex` varchar(2) NOT NULL DEFAULT '',
  `komm` int(10) unsigned NOT NULL DEFAULT '0',
  `postforum` int(10) unsigned NOT NULL DEFAULT '0',
  `postguest` int(10) unsigned NOT NULL DEFAULT '0',
  `yearofbirth` int(4) NOT NULL DEFAULT '0',
  `datereg` int(10) unsigned NOT NULL DEFAULT '0',
  `lastdate` int(10) unsigned NOT NULL DEFAULT '0',
  `mail` varchar(50) NOT NULL DEFAULT '',
  `icq` int(10) unsigned NOT NULL DEFAULT '0',
  `skype` varchar(50) NOT NULL DEFAULT '',
  `jabber` varchar(50) NOT NULL DEFAULT '',
  `www` varchar(50) NOT NULL DEFAULT '',
  `about` text NOT NULL,
  `live` varchar(100) NOT NULL DEFAULT '',
  `mibile` varchar(50) NOT NULL DEFAULT '',
  `status` varchar(100) NOT NULL DEFAULT '',
  `ip` bigint(11) NOT NULL DEFAULT '0',
  `ip_via_proxy` bigint(11) NOT NULL DEFAULT '0',
  `browser` text NOT NULL,
  `preg` tinyint(1) NOT NULL DEFAULT '0',
  `regadm` varchar(25) NOT NULL DEFAULT '',
  `mailvis` tinyint(1) NOT NULL DEFAULT '0',
  `dayb` int(2) NOT NULL DEFAULT '0',
  `monthb` int(2) NOT NULL DEFAULT '0',
  `sestime` int(10) unsigned NOT NULL DEFAULT '0',
  `total_on_site` int(10) unsigned NOT NULL DEFAULT '0',
  `lastpost` int(10) unsigned NOT NULL DEFAULT '0',
  `rest_code` varchar(32) NOT NULL DEFAULT '',
  `rest_time` int(10) unsigned NOT NULL DEFAULT '0',
  `movings` int(10) unsigned NOT NULL DEFAULT '0',
  `place` varchar(30) NOT NULL DEFAULT '',
  `set_user` text NOT NULL,
  `set_forum` text NOT NULL,
  `set_mail` text NOT NULL,
  `karma_plus` int(11) NOT NULL DEFAULT '0',
  `karma_minus` int(11) NOT NULL DEFAULT '0',
  `karma_time` int(10) unsigned NOT NULL DEFAULT '0',
  `karma_off` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `comm_count` int(10) unsigned NOT NULL DEFAULT '0',
  `comm_old` int(10) unsigned NOT NULL DEFAULT '0',
  `smileys` text NOT NULL,
  `balans` int(11) NOT NULL DEFAULT '0',
  `balans_day` int(11) NOT NULL DEFAULT '0',
  `balans_time` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `name`, `name_lat`, `password`, `rights`, `failed_login`, `imname`, `sex`, `komm`, `postforum`, `postguest`, `yearofbirth`, `datereg`, `lastdate`, `mail`, `icq`, `skype`, `jabber`, `www`, `about`, `live`, `mibile`, `status`, `ip`, `ip_via_proxy`, `browser`, `preg`, `regadm`, `mailvis`, `dayb`, `monthb`, `sestime`, `total_on_site`, `lastpost`, `rest_code`, `rest_time`, `movings`, `place`, `set_user`, `set_forum`, `set_mail`, `karma_plus`, `karma_minus`, `karma_time`, `karma_off`, `comm_count`, `comm_old`, `smileys`, `balans`, `balans_day`, `balans_time`) VALUES
(1, 'admin', 'admin', '1f32aa4c9a1d2ea010adcf2348166a04', 9, 0, '', 'm', 0, 0, 0, 0, 1569854544, 1569857557, '@', 0, '', '', 'http://akbarali.zadc.ru', '', '', '', 'Hamma xato qiladi', 3588649225, 0, 'Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/49.0.2623.112 Safari/537.36', 1, '', 0, 0, 0, 1569857481, 2158, 1569856374, '', 0, 7, 'mainpage', '', '', '', 0, 0, 1569854560, 0, 0, 0, '', 13, 1, 1569855303),
(2, 'Akbarali', 'akbarali', '7fce94d1d5472db66fa02e2d253b4b4a', 0, 0, 'Akbarali', 'm', 0, 0, 0, 0, 1569857267, 1569857469, '', 0, '', '', '', '', '', '', '', 3588649225, 0, 'Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/49.0.2623.112 Safari/537.36', 1, '', 0, 0, 0, 1569857267, 202, 1569857469, '', 0, 4, 'mail', '', '', '', 0, 0, 1569857271, 0, 0, 0, '', 40, 1, 1569857271);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `chats`
--
ALTER TABLE `chats`
 ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `cms_ads`
--
ALTER TABLE `cms_ads`
 ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cms_album_cat`
--
ALTER TABLE `cms_album_cat`
 ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`), ADD KEY `access` (`access`);

--
-- Indexes for table `cms_album_comments`
--
ALTER TABLE `cms_album_comments`
 ADD PRIMARY KEY (`id`), ADD KEY `sub_id` (`sub_id`), ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `cms_album_downloads`
--
ALTER TABLE `cms_album_downloads`
 ADD PRIMARY KEY (`user_id`,`file_id`);

--
-- Indexes for table `cms_album_files`
--
ALTER TABLE `cms_album_files`
 ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`), ADD KEY `album_id` (`album_id`), ADD KEY `access` (`access`);

--
-- Indexes for table `cms_album_views`
--
ALTER TABLE `cms_album_views`
 ADD PRIMARY KEY (`user_id`,`file_id`);

--
-- Indexes for table `cms_album_votes`
--
ALTER TABLE `cms_album_votes`
 ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`), ADD KEY `file_id` (`file_id`);

--
-- Indexes for table `cms_ban_ip`
--
ALTER TABLE `cms_ban_ip`
 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `ip1` (`ip1`), ADD UNIQUE KEY `ip2` (`ip2`);

--
-- Indexes for table `cms_ban_users`
--
ALTER TABLE `cms_ban_users`
 ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`), ADD KEY `ban_time` (`ban_time`);

--
-- Indexes for table `cms_contact`
--
ALTER TABLE `cms_contact`
 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `id_user` (`user_id`,`from_id`), ADD KEY `time` (`time`), ADD KEY `ban` (`ban`);

--
-- Indexes for table `cms_counters`
--
ALTER TABLE `cms_counters`
 ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cms_forum_files`
--
ALTER TABLE `cms_forum_files`
 ADD PRIMARY KEY (`id`), ADD KEY `cat` (`cat`), ADD KEY `subcat` (`subcat`), ADD KEY `topic` (`topic`), ADD KEY `post` (`post`);

--
-- Indexes for table `cms_forum_rdm`
--
ALTER TABLE `cms_forum_rdm`
 ADD PRIMARY KEY (`topic_id`,`user_id`), ADD KEY `time` (`time`);

--
-- Indexes for table `cms_forum_vote`
--
ALTER TABLE `cms_forum_vote`
 ADD PRIMARY KEY (`id`), ADD KEY `type` (`type`), ADD KEY `topic` (`topic`);

--
-- Indexes for table `cms_forum_vote_users`
--
ALTER TABLE `cms_forum_vote_users`
 ADD PRIMARY KEY (`id`), ADD KEY `topic` (`topic`);

--
-- Indexes for table `cms_library_comments`
--
ALTER TABLE `cms_library_comments`
 ADD PRIMARY KEY (`id`), ADD KEY `sub_id` (`sub_id`), ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `cms_library_rating`
--
ALTER TABLE `cms_library_rating`
 ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`,`st_id`);

--
-- Indexes for table `cms_mail`
--
ALTER TABLE `cms_mail`
 ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`), ADD KEY `from_id` (`from_id`), ADD KEY `time` (`time`), ADD KEY `read` (`read`), ADD KEY `sys` (`sys`), ADD KEY `delete` (`delete`);

--
-- Indexes for table `cms_news`
--
ALTER TABLE `cms_news`
 ADD PRIMARY KEY (`id`), ADD KEY `time` (`time`), ADD KEY `refid` (`refid`);

--
-- Indexes for table `cms_news_cat`
--
ALTER TABLE `cms_news_cat`
 ADD PRIMARY KEY (`id`), ADD KEY `realid` (`realid`);

--
-- Indexes for table `cms_news_comments`
--
ALTER TABLE `cms_news_comments`
 ADD PRIMARY KEY (`id`), ADD KEY `refid` (`refid`), ADD KEY `time` (`time`), ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `cms_news_rating`
--
ALTER TABLE `cms_news_rating`
 ADD PRIMARY KEY (`id_rate`);

--
-- Indexes for table `cms_sessions`
--
ALTER TABLE `cms_sessions`
 ADD PRIMARY KEY (`session_id`), ADD KEY `lastdate` (`lastdate`), ADD KEY `place` (`place`(10));

--
-- Indexes for table `cms_settings`
--
ALTER TABLE `cms_settings`
 ADD PRIMARY KEY (`key`(30));

--
-- Indexes for table `cms_users_data`
--
ALTER TABLE `cms_users_data`
 ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`), ADD KEY `key` (`key`);

--
-- Indexes for table `cms_users_guestbook`
--
ALTER TABLE `cms_users_guestbook`
 ADD PRIMARY KEY (`id`), ADD KEY `sub_id` (`sub_id`), ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `cms_users_iphistory`
--
ALTER TABLE `cms_users_iphistory`
 ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`), ADD KEY `user_ip` (`ip`);

--
-- Indexes for table `download`
--
ALTER TABLE `download`
 ADD PRIMARY KEY (`id`), ADD KEY `type` (`type`), ADD KEY `refid` (`refid`), ADD KEY `time` (`time`);

--
-- Indexes for table `forum`
--
ALTER TABLE `forum`
 ADD PRIMARY KEY (`id`), ADD KEY `refid` (`refid`), ADD KEY `type` (`type`), ADD KEY `time` (`time`), ADD KEY `close` (`close`), ADD KEY `user_id` (`user_id`), ADD FULLTEXT KEY `text` (`text`);

--
-- Indexes for table `forum_arz`
--
ALTER TABLE `forum_arz`
 ADD PRIMARY KEY (`id`);

--
-- Indexes for table `forum_chat`
--
ALTER TABLE `forum_chat`
 ADD PRIMARY KEY (`id`);

--
-- Indexes for table `forum_group`
--
ALTER TABLE `forum_group`
 ADD PRIMARY KEY (`id`);

--
-- Indexes for table `forum_group_add`
--
ALTER TABLE `forum_group_add`
 ADD PRIMARY KEY (`id`);

--
-- Indexes for table `forum_lenta`
--
ALTER TABLE `forum_lenta`
 ADD PRIMARY KEY (`id`), ADD KEY `id_user` (`id_user`,`ot_kogo`), ADD KEY `read` (`read`);

--
-- Indexes for table `forum_mavzu`
--
ALTER TABLE `forum_mavzu`
 ADD PRIMARY KEY (`id`);

--
-- Indexes for table `forum_mehmon`
--
ALTER TABLE `forum_mehmon`
 ADD PRIMARY KEY (`id`);

--
-- Indexes for table `forum_rahmat`
--
ALTER TABLE `forum_rahmat`
 ADD PRIMARY KEY (`id`);

--
-- Indexes for table `forum_reply`
--
ALTER TABLE `forum_reply`
 ADD PRIMARY KEY (`id`);

--
-- Indexes for table `forum_votte`
--
ALTER TABLE `forum_votte`
 ADD PRIMARY KEY (`id`);

--
-- Indexes for table `forum_zaklad`
--
ALTER TABLE `forum_zaklad`
 ADD PRIMARY KEY (`id`);

--
-- Indexes for table `gallery`
--
ALTER TABLE `gallery`
 ADD PRIMARY KEY (`id`), ADD KEY `refid` (`refid`), ADD KEY `type` (`type`), ADD KEY `time` (`time`), ADD KEY `avtor` (`avtor`);

--
-- Indexes for table `guest`
--
ALTER TABLE `guest`
 ADD PRIMARY KEY (`id`), ADD KEY `time` (`time`), ADD KEY `ip` (`ip`), ADD KEY `adm` (`adm`);

--
-- Indexes for table `karma_users`
--
ALTER TABLE `karma_users`
 ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`), ADD KEY `karma_user` (`karma_user`), ADD KEY `type` (`type`);

--
-- Indexes for table `library_cats`
--
ALTER TABLE `library_cats`
 ADD PRIMARY KEY (`id`);

--
-- Indexes for table `library_tags`
--
ALTER TABLE `library_tags`
 ADD PRIMARY KEY (`id`), ADD KEY `lib_text_id` (`lib_text_id`), ADD KEY `tag_name` (`tag_name`(250));

--
-- Indexes for table `library_texts`
--
ALTER TABLE `library_texts`
 ADD PRIMARY KEY (`id`), ADD FULLTEXT KEY `text` (`text`,`name`);

--
-- Indexes for table `lider`
--
ALTER TABLE `lider`
 ADD PRIMARY KEY (`id`);

--
-- Indexes for table `news`
--
ALTER TABLE `news`
 ADD PRIMARY KEY (`id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
 ADD PRIMARY KEY (`id`), ADD KEY `name_lat` (`name_lat`), ADD KEY `lastdate` (`lastdate`), ADD KEY `place` (`place`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `chats`
--
ALTER TABLE `chats`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `cms_ads`
--
ALTER TABLE `cms_ads`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `cms_album_cat`
--
ALTER TABLE `cms_album_cat`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `cms_album_comments`
--
ALTER TABLE `cms_album_comments`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `cms_album_files`
--
ALTER TABLE `cms_album_files`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `cms_album_votes`
--
ALTER TABLE `cms_album_votes`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `cms_ban_ip`
--
ALTER TABLE `cms_ban_ip`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `cms_ban_users`
--
ALTER TABLE `cms_ban_users`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `cms_contact`
--
ALTER TABLE `cms_contact`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `cms_counters`
--
ALTER TABLE `cms_counters`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `cms_forum_files`
--
ALTER TABLE `cms_forum_files`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `cms_forum_vote`
--
ALTER TABLE `cms_forum_vote`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `cms_forum_vote_users`
--
ALTER TABLE `cms_forum_vote_users`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `cms_library_comments`
--
ALTER TABLE `cms_library_comments`
MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `cms_library_rating`
--
ALTER TABLE `cms_library_rating`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `cms_mail`
--
ALTER TABLE `cms_mail`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `cms_news`
--
ALTER TABLE `cms_news`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `cms_news_cat`
--
ALTER TABLE `cms_news_cat`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `cms_news_comments`
--
ALTER TABLE `cms_news_comments`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `cms_news_rating`
--
ALTER TABLE `cms_news_rating`
MODIFY `id_rate` int(11) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `cms_users_data`
--
ALTER TABLE `cms_users_data`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `cms_users_guestbook`
--
ALTER TABLE `cms_users_guestbook`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `cms_users_iphistory`
--
ALTER TABLE `cms_users_iphistory`
MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `download`
--
ALTER TABLE `download`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `forum`
--
ALTER TABLE `forum`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `forum_arz`
--
ALTER TABLE `forum_arz`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `forum_chat`
--
ALTER TABLE `forum_chat`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `forum_group`
--
ALTER TABLE `forum_group`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `forum_group_add`
--
ALTER TABLE `forum_group_add`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `forum_lenta`
--
ALTER TABLE `forum_lenta`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `forum_mavzu`
--
ALTER TABLE `forum_mavzu`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `forum_mehmon`
--
ALTER TABLE `forum_mehmon`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `forum_rahmat`
--
ALTER TABLE `forum_rahmat`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `forum_reply`
--
ALTER TABLE `forum_reply`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `forum_votte`
--
ALTER TABLE `forum_votte`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `forum_zaklad`
--
ALTER TABLE `forum_zaklad`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `gallery`
--
ALTER TABLE `gallery`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `guest`
--
ALTER TABLE `guest`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `karma_users`
--
ALTER TABLE `karma_users`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `library_cats`
--
ALTER TABLE `library_cats`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `library_tags`
--
ALTER TABLE `library_tags`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `library_texts`
--
ALTER TABLE `library_texts`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `lider`
--
ALTER TABLE `lider`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `news`
--
ALTER TABLE `news`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
/*!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 */;
