START TRANSACTION;



CREATE TABLE `ads_abuse` (
  `id` int(11) NOT NULL,
  `ad_id` int(11) NOT NULL,
  `ident` tinyint(1) NOT NULL DEFAULT 0,
  `date` int(11) NOT NULL,
  `name` varchar(20) NOT NULL,
  `url` varchar(150) NOT NULL,
  `prichina` smallint(1) NOT NULL DEFAULT 0,
  `rekl` varchar(25) NOT NULL DEFAULT '' COMMENT 'login_rekl'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `regmonitor` (
  `id` int(11) NOT NULL,
  `type` varchar(20) NOT NULL,
  `name` varchar(20) NOT NULL,
  `registered` varchar(30) NOT NULL,
  `referrer` mediumtext NOT NULL,
  `ip` varchar(15) NOT NULL,
  `unbanurl` varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `still_autoclik` (
  `id` int(11) NOT NULL,
  `idu` int(11) NOT NULL,
  `count_serf` int(11) NOT NULL,
  `count_mail` int(11) NOT NULL,
  `count_pay` int(11) NOT NULL,
  `count_youtube` int(11) NOT NULL,
  `date` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `still_block_earnings` (
  `id` int(11) NOT NULL,
  `user` varchar(20) NOT NULL,
  `idu` int(11) NOT NULL DEFAULT 0,
  `userb` varchar(20) NOT NULL,
  `idb` int(11) NOT NULL DEFAULT 0,
  `date` varchar(11) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `still_block_reklam` (
  `id` int(11) NOT NULL,
  `user` varchar(20) NOT NULL,
  `idu` int(11) NOT NULL DEFAULT 0,
  `userb` varchar(20) NOT NULL,
  `idb` int(11) NOT NULL DEFAULT 0,
  `date` varchar(11) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `still_block_white` (
  `id` int(11) NOT NULL,
  `user` varchar(20) NOT NULL,
  `idu` int(11) NOT NULL DEFAULT 0,
  `userb` varchar(20) NOT NULL,
  `idb` int(11) NOT NULL DEFAULT 0,
  `date` varchar(11) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `still_chain` (
  `id` int(11) NOT NULL,
  `idu` int(11) NOT NULL,
  `login` varchar(20) NOT NULL DEFAULT '',
  `title` varchar(45) NOT NULL DEFAULT '',
  `url` varchar(700) NOT NULL DEFAULT '',
  `color` tinyint(4) NOT NULL DEFAULT 0,
  `jump` mediumint(9) NOT NULL DEFAULT 0,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `date` date NOT NULL,
  `unix_date` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

CREATE TABLE `still_chat` (
  `id` mediumint(8) NOT NULL,
  `username` varchar(20) NOT NULL,
  `comu` varchar(20) NOT NULL,
  `text` varchar(300) NOT NULL,
  `date` int(10) NOT NULL,
  `color` varchar(6) NOT NULL,
  `robot` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
  `moder` tinyint(1) UNSIGNED NOT NULL DEFAULT 0
) ENGINE=MEMORY DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `still_chat_block` (
  `id` int(11) NOT NULL,
  `idu` int(11) NOT NULL,
  `users` varchar(20) NOT NULL,
  `idu_b` int(11) NOT NULL,
  `users_b` varchar(20) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `still_chat_online` (
  `username` varchar(20) NOT NULL,
  `date` int(10) NOT NULL,
  `fio` varchar(12) NOT NULL,
  `tabs` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
  `id_us_chat` int(11) NOT NULL DEFAULT 0,
  `sex` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=MEMORY DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `still_competition` (
  `id` mediumint(8) UNSIGNED NOT NULL,
  `start_date` int(10) UNSIGNED NOT NULL,
  `end_date` int(10) UNSIGNED NOT NULL,
  `min` mediumint(6) UNSIGNED NOT NULL DEFAULT 0,
  `bonus` varchar(500) NOT NULL DEFAULT '',
  `bonus_b` varchar(500) NOT NULL DEFAULT '',
  `vid` enum('work','ref','ad') NOT NULL,
  `status_bonus` tinyint(1) UNSIGNED NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
DELIMITER $$
CREATE TRIGGER `DeletComp` BEFORE DELETE ON `still_competition` FOR EACH ROW BEGIN
  DELETE FROM  `still_competition_data` WHERE  `OLD`.`id` =  `idk` ;
END
$$
DELIMITER ;

CREATE TABLE `still_competition_data` (
  `id` int(11) NOT NULL,
  `idu` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `idk` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `data` double(15,4) UNSIGNED NOT NULL DEFAULT 0.0000,
  `date` int(10) UNSIGNED NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `still_day_stata` (
  `id` int(11) NOT NULL,
  `users` varchar(20) NOT NULL DEFAULT '',
  `date` date NOT NULL,
  `date_unix` int(11) NOT NULL DEFAULT 0,
  `serf` int(11) NOT NULL DEFAULT 0,
  `mail` int(11) NOT NULL DEFAULT 0,
  `test` int(11) NOT NULL DEFAULT 0,
  `task` int(11) NOT NULL DEFAULT 0,
  `youtube` int(11) NOT NULL DEFAULT 0,
  `vk` int(11) NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `still_faq_categ` (
  `id` int(11) NOT NULL,
  `name_m` varchar(50) NOT NULL,
  `name` varchar(100) NOT NULL,
  `text` mediumtext NOT NULL,
  `mesto` smallint(3) NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `still_faq_help` (
  `id` int(11) NOT NULL,
  `idc` int(11) NOT NULL,
  `title` varchar(150) NOT NULL,
  `text` mediumtext NOT NULL,
  `mesto` smallint(3) NOT NULL DEFAULT 0,
  `vip` tinyint(1) UNSIGNED NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `still_friends` (
  `id` int(11) NOT NULL,
  `idu` int(11) NOT NULL,
  `user` varchar(20) NOT NULL,
  `idf` int(11) NOT NULL,
  `user_friends` varchar(20) NOT NULL,
  `status` int(1) UNSIGNED NOT NULL DEFAULT 0,
  `date` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `still_gift_cat` (
  `id` int(11) NOT NULL,
  `title` varchar(100) NOT NULL,
  `mesto` smallint(3) NOT NULL,
  `status` tinyint(1) UNSIGNED NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

INSERT INTO `still_gift_cat` (`id`, `title`, `mesto`, `status`) VALUES
(1, 'Дружба', 1, 0),
(2, 'Новый год', 2, 0);

CREATE TABLE `still_gift_img` (
  `id` int(11) NOT NULL,
  `idc` int(11) NOT NULL,
  `img` varchar(37) NOT NULL,
  `mesto` smallint(3) NOT NULL,
  `money` double(9,2) UNSIGNED NOT NULL DEFAULT 0.00,
  `num` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `pmoney` double(9,2) UNSIGNED NOT NULL DEFAULT 0.00
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

INSERT INTO `still_gift_img` (`id`, `idc`, `img`, `mesto`, `money`, `num`, `pmoney`) VALUES
(1, 1, 'f1ce1ae68cd17f53fbb94af8c2b5cf3f.png', 1, 1.00, 183, 0.00),
(2, 1, '252da073729132851266c33bb54964e3.jpeg', 2, 1.00, 42, 0.00),
(3, 1, '3322d70e4c91cac115f3ff9a30dc58f3.png', 3, 1.00, 6, 0.00),
(4, 1, '74491060de38b829c8afff025d0e7590.png', 4, 1.00, 104, 0.00),
(5, 1, '47fb9f1a747a47d1a1be00d6a510e388.jpeg', 5, 1.00, 21, 0.00),
(6, 2, '97737e2f6ae1dde1adc9f6041cbb2d9f.jpeg', 1, 3.00, 39, 0.00),
(7, 2, '684f912e9bb6c4f4e7c30fe20aafa0c1.jpeg', 2, 3.00, 3, 0.00),
(8, 2, '789b2fd8a843bc318b5b8814507bf05a.jpeg', 3, 3.00, 18, 0.00),
(9, 2, '9f6a9339e33540a7c2398cde5757649c.jpeg', 4, 3.00, 25, 0.00),
(10, 2, '84ecb797ad844d719b858b2807e03d24.jpeg', 5, 3.00, 9, 0.00);

CREATE TABLE `still_gift_users` (
  `id` int(11) NOT NULL,
  `idu` int(10) UNSIGNED NOT NULL,
  `idw` int(10) UNSIGNED NOT NULL,
  `idi` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `text` varchar(200) NOT NULL,
  `date` int(11) NOT NULL,
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `still_goodref` (
  `id` mediumint(8) NOT NULL,
  `idu` mediumint(8) UNSIGNED NOT NULL,
  `date` datetime NOT NULL,
  `text` varchar(30) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `still_mail` (
  `id` int(11) NOT NULL,
  `sender` varchar(20) NOT NULL DEFAULT '',
  `recipient` varchar(20) NOT NULL DEFAULT '',
  `date` int(11) UNSIGNED NOT NULL,
  `inc` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
  `out` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
  `status_inc` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
  `status_out` tinyint(1) UNSIGNED NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `still_mail_block` (
  `username` varchar(15) NOT NULL,
  `mail_user` mediumtext NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `still_mail_mess` (
  `id` int(11) NOT NULL,
  `idm` int(11) NOT NULL,
  `text` mediumtext NOT NULL,
  `date` int(11) NOT NULL,
  `user` varchar(20) NOT NULL,
  `status` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
  `test` tinyint(1) UNSIGNED NOT NULL DEFAULT 1
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `still_moder_bonus` (
  `id` int(11) NOT NULL,
  `idu` int(11) NOT NULL,
  `all` int(11) NOT NULL,
  `month` varchar(6) NOT NULL,
  `proc` double(7,2) NOT NULL DEFAULT 0.00,
  `bonus` double(9,2) NOT NULL DEFAULT 0.00,
  `status` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `still_moder_history` (
  `id` int(11) NOT NULL,
  `idr` int(11) NOT NULL,
  `vid` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
  `moder` varchar(20) NOT NULL,
  `text` mediumtext NOT NULL,
  `date` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `still_moder_mess` (
  `id` int(11) NOT NULL,
  `idu` int(11) NOT NULL,
  `username` varchar(20) NOT NULL,
  `text` mediumtext NOT NULL,
  `date` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `still_moder_reklama` (
  `id` int(11) NOT NULL,
  `idu` int(11) NOT NULL,
  `p_test` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `o_test` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `v_test` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `opl_test` int(11) NOT NULL DEFAULT 0,
  `p_task` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `o_task` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `v_task` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `opl_task` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `p_vk` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `o_vk` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `v_vk` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `opl_vk` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `p_yt` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `o_yt` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `v_yt` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `opl_yt` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `p_serf` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `o_serf` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `v_serf` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `opl_serf` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `p_mails` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `o_mails` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `v_mails` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `opl_mails` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `date` datetime NOT NULL DEFAULT current_timestamp(),
  `money` double(11,2) UNSIGNED NOT NULL DEFAULT 0.00
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `still_note` (
  `id` int(11) NOT NULL,
  `idu` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `title` varchar(60) NOT NULL,
  `text` mediumtext NOT NULL,
  `date` int(11) UNSIGNED NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `still_online` (
  `usonline` varchar(20) NOT NULL,
  `visitor` varchar(15) NOT NULL DEFAULT '',
  `lastvisit` int(10) NOT NULL DEFAULT 0,
  `mobusak` tinyint(1) NOT NULL DEFAULT 2
) ENGINE=MEMORY DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `still_perfect_id` (
  `id` int(11) NOT NULL,
  `perfect_id` varchar(50) NOT NULL,
  `date` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `still_ref_bonus` (
  `id` int(11) NOT NULL,
  `idu` int(11) NOT NULL,
  `view` smallint(2) NOT NULL DEFAULT 0,
  `datestart` int(10) NOT NULL,
  `status` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
  `dateend` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `min` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
  `vid_ref` smallint(2) NOT NULL DEFAULT 0,
  `bonus` double(9,3) NOT NULL DEFAULT 0.000,
  `bonus_all` int(11) NOT NULL DEFAULT 0,
  `bonus_all_price` double(10,3) NOT NULL DEFAULT 0.000,
  `balance` double(9,3) NOT NULL DEFAULT 0.000,
  `comment` varchar(300) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `still_ref_bonus_rezult` (
  `idu` int(11) NOT NULL,
  `idk` int(11) NOT NULL,
  `data` double(10,4) UNSIGNED NOT NULL DEFAULT 0.0000,
  `data_all` double(10,4) UNSIGNED NOT NULL DEFAULT 0.0000,
  `all_bonus` double(9,3) UNSIGNED NOT NULL DEFAULT 0.000
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `still_ref_koncurs` (
  `id` int(11) NOT NULL,
  `idu` int(11) NOT NULL,
  `view` smallint(2) UNSIGNED NOT NULL DEFAULT 0,
  `period` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
  `datestart` int(10) NOT NULL,
  `dayend` smallint(3) UNSIGNED NOT NULL DEFAULT 1,
  `priz` varchar(200) NOT NULL,
  `status` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
  `dateend` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `auto` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
  `min` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
  `comment` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `still_ref_koncurs_rezult` (
  `idu` int(11) NOT NULL,
  `idk` int(11) NOT NULL,
  `data` double(10,4) UNSIGNED NOT NULL DEFAULT 0.0000
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `still_rutube_abuse` (
  `id` int(11) NOT NULL,
  `idu` int(11) NOT NULL,
  `username` varchar(20) NOT NULL,
  `idr` int(11) NOT NULL,
  `reklamod` varchar(20) NOT NULL,
  `comment` varchar(500) NOT NULL,
  `date` int(11) NOT NULL,
  `idp` int(11) NOT NULL,
  `vid` tinyint(1) UNSIGNED NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `still_rutube_ads` (
  `id` int(11) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 0,
  `idu` int(11) NOT NULL DEFAULT 0,
  `author` varchar(20) NOT NULL,
  `vip` tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
  `color` int(11) NOT NULL DEFAULT 0,
  `timer` int(11) NOT NULL DEFAULT 20,
  `title` varchar(60) NOT NULL,
  `text` varchar(60) NOT NULL,
  `id_video` varchar(99) NOT NULL,
  `members` int(11) NOT NULL DEFAULT 0,
  `price_r` double(10,3) NOT NULL DEFAULT 0.000,
  `price_u` double(10,3) NOT NULL DEFAULT 0.000,
  `ballans` double(10,3) NOT NULL DEFAULT 0.000,
  `country` varchar(125) NOT NULL,
  `date_reg_user` int(11) NOT NULL DEFAULT 0,
  `rating_user` int(11) NOT NULL DEFAULT 0,
  `sex_user` smallint(6) NOT NULL DEFAULT 0,
  `vozrast` varchar(7) NOT NULL DEFAULT '0,999',
  `goroda` varchar(200) NOT NULL,
  `unik_ip_user` tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
  `inter` tinyint(1) NOT NULL DEFAULT 0,
  `inter_text` varchar(100) NOT NULL,
  `texno` tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
  `go_url` tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
  `moder` varchar(20) NOT NULL DEFAULT '',
  `moder_text` longtext NOT NULL DEFAULT '',
  `count_o` smallint(6) NOT NULL DEFAULT 0,
  `date_start_moder` int(11) NOT NULL DEFAULT 0,
  `date_end_moder` int(11) NOT NULL DEFAULT 0,
  `date` int(11) NOT NULL,
  `date_end` int(11) NOT NULL DEFAULT 0,
  `autoclik` tinyint(3) UNSIGNED NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

CREATE TABLE `still_rutube_ads_user` (
  `id` int(11) NOT NULL,
  `idp` int(11) NOT NULL,
  `idu` int(11) NOT NULL,
  `id_video` varchar(50) NOT NULL,
  `ip` varchar(15) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `date` int(11) NOT NULL,
  `date_inter` varchar(20) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

CREATE TABLE `still_shoot` (
  `id` int(11) NOT NULL,
  `idu` int(11) NOT NULL,
  `vid` smallint(2) NOT NULL,
  `shoot` varchar(25) NOT NULL,
  `date` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `still_socialseti` (
  `id` int(11) NOT NULL,
  `idu` int(11) NOT NULL DEFAULT 0,
  `youtube_video` int(11) NOT NULL DEFAULT 0,
  `youtube_podp` int(11) NOT NULL DEFAULT 0,
  `youtube_like` int(11) NOT NULL DEFAULT 0,
  `youtube_all` int(11) NOT NULL DEFAULT 0,
  `youtube_money` double(10,4) NOT NULL DEFAULT 0.0000,
  `youtube_money_rekl` varchar(50) NOT NULL DEFAULT '0~0~0',
  `vk_groups` int(11) NOT NULL DEFAULT 0,
  `vk_likes` int(11) NOT NULL DEFAULT 0,
  `vk_repost` int(11) NOT NULL DEFAULT 0,
  `vk_all` int(11) NOT NULL DEFAULT 0,
  `vk_money` double(10,4) NOT NULL DEFAULT 0.0000,
  `vk_money_rekl` varchar(50) NOT NULL DEFAULT '0~0~0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `still_support_mess` (
  `id` int(11) NOT NULL,
  `text` mediumtext NOT NULL,
  `date` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `still_support_moder` (
  `id` int(11) NOT NULL,
  `idu` int(11) NOT NULL,
  `mess_status` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
  `num_comment` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `num_closed` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `opl_comment` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `opl_closed` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `money` double(11,2) NOT NULL DEFAULT 0.00,
  `date` datetime NOT NULL DEFAULT current_timestamp(),
  `tiket_status` tinyint(1) UNSIGNED NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `still_support_setup` (
  `id` int(11) NOT NULL,
  `idu` int(11) NOT NULL,
  `title` varchar(30) NOT NULL,
  `text` varchar(1000) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `still_task_abuse` (
  `id` int(11) NOT NULL,
  `idu` int(11) NOT NULL,
  `username` varchar(20) NOT NULL,
  `idr` int(11) NOT NULL,
  `reklamod` varchar(20) NOT NULL,
  `comment` varchar(500) NOT NULL,
  `date` int(11) NOT NULL,
  `idz` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `still_test_bl` (
  `id` int(11) NOT NULL,
  `user` varchar(20) NOT NULL,
  `id_user` int(11) NOT NULL DEFAULT 0,
  `user_z` varchar(20) NOT NULL,
  `id_z` int(11) NOT NULL DEFAULT 0,
  `data` varchar(11) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `still_test_i` (
  `id` int(11) NOT NULL,
  `idt` int(11) NOT NULL DEFAULT 0,
  `user` varchar(20) NOT NULL,
  `idu` int(11) NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `still_test_m` (
  `id` int(11) NOT NULL,
  `idt` int(11) NOT NULL,
  `idu` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `still_test_r` (
  `id` int(11) NOT NULL,
  `idt` int(11) NOT NULL DEFAULT 0,
  `idu` int(11) NOT NULL DEFAULT 0,
  `reyt` smallint(3) NOT NULL DEFAULT 0,
  `comment` mediumtext NOT NULL,
  `date` int(10) UNSIGNED NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `still_test_status` (
  `id` int(11) NOT NULL,
  `idu` int(11) UNSIGNED NOT NULL,
  `user` varchar(20) NOT NULL,
  `idt` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `money` double(9,4) UNSIGNED NOT NULL DEFAULT 0.0000,
  `start_date` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `date` int(10) NOT NULL,
  `ip` varchar(15) NOT NULL,
  `perexod` smallint(3) UNSIGNED NOT NULL DEFAULT 0,
  `time` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
  `referer` varchar(50) NOT NULL,
  `arr_vopros` varchar(20) NOT NULL DEFAULT '0,0,0',
  `otvet` varchar(300) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `still_vk_abuse` (
  `id` int(11) NOT NULL,
  `idu` int(11) NOT NULL,
  `username` varchar(20) NOT NULL,
  `idr` int(11) NOT NULL,
  `reklamod` varchar(20) NOT NULL,
  `comment` varchar(500) NOT NULL,
  `date` int(11) NOT NULL,
  `idp` int(11) NOT NULL,
  `vid` tinyint(1) UNSIGNED NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `still_vk_bl` (
  `id` int(11) NOT NULL,
  `user` varchar(20) NOT NULL,
  `idu` int(11) NOT NULL DEFAULT 0,
  `userb` varchar(20) NOT NULL,
  `idb` int(11) NOT NULL DEFAULT 0,
  `date` varchar(11) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `still_vk_delprofil` (
  `id` int(11) NOT NULL,
  `idu` int(11) NOT NULL,
  `id_vk` varchar(30) NOT NULL,
  `date` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `still_vk_groups` (
  `id` int(11) NOT NULL,
  `status` int(1) NOT NULL DEFAULT 0,
  `idu` int(11) NOT NULL DEFAULT 0,
  `author` varchar(20) NOT NULL,
  `vip` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
  `color` int(1) NOT NULL DEFAULT 0,
  `title` varchar(60) NOT NULL,
  `text` varchar(60) NOT NULL,
  `id_groups` varchar(30) NOT NULL,
  `screen_name` varchar(30) NOT NULL,
  `members` int(11) NOT NULL DEFAULT 0,
  `price_r` double(10,3) NOT NULL DEFAULT 0.000,
  `price_u` double(10,3) NOT NULL DEFAULT 0.000,
  `ballans` double(10,3) NOT NULL DEFAULT 0.000,
  `country` varchar(125) NOT NULL,
  `date_reg_user` int(4) NOT NULL DEFAULT 0,
  `rating_user` int(4) NOT NULL DEFAULT 0,
  `sex_user` smallint(1) NOT NULL DEFAULT 0,
  `vozrast` varchar(7) NOT NULL DEFAULT '0,999',
  `goroda` varchar(200) NOT NULL,
  `unik_ip_user` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
  `inter` tinyint(1) NOT NULL DEFAULT 0,
  `inter_text` varchar(100) NOT NULL,
  `friends` mediumint(6) NOT NULL DEFAULT 0,
  `moder` varchar(20) NOT NULL DEFAULT '',
  `moder_text` mediumtext NOT NULL DEFAULT '',
  `count_o` smallint(3) NOT NULL DEFAULT 0,
  `date_start_moder` int(11) NOT NULL DEFAULT 0,
  `date_end_moder` int(11) NOT NULL DEFAULT 0,
  `date` int(11) NOT NULL DEFAULT 0,
  `date_end` int(11) NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `still_vk_groups_user` (
  `id` int(11) NOT NULL,
  `idp` int(11) NOT NULL,
  `idu` int(11) NOT NULL,
  `id_vk` varchar(50) NOT NULL,
  `ip` varchar(15) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `date` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `still_vk_likes` (
  `id` int(11) NOT NULL,
  `status` int(1) NOT NULL DEFAULT 0,
  `idu` int(11) NOT NULL DEFAULT 0,
  `author` varchar(20) NOT NULL,
  `vip` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
  `color` int(1) NOT NULL DEFAULT 0,
  `title` varchar(60) NOT NULL,
  `text` varchar(60) NOT NULL,
  `type` varchar(20) NOT NULL,
  `owner_id` varchar(20) NOT NULL,
  `item_id` varchar(20) NOT NULL,
  `url_vk` varchar(700) NOT NULL,
  `members` int(11) NOT NULL DEFAULT 0,
  `price_r` double(10,3) NOT NULL DEFAULT 0.000,
  `price_u` double(10,3) NOT NULL DEFAULT 0.000,
  `ballans` double(10,3) NOT NULL DEFAULT 0.000,
  `country` varchar(125) NOT NULL,
  `date_reg_user` int(4) NOT NULL DEFAULT 0,
  `rating_user` int(4) NOT NULL DEFAULT 0,
  `sex_user` smallint(1) NOT NULL DEFAULT 0,
  `vozrast` varchar(7) NOT NULL DEFAULT '0,999',
  `goroda` varchar(200) NOT NULL,
  `unik_ip_user` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
  `inter` tinyint(1) NOT NULL DEFAULT 0,
  `inter_text` varchar(100) NOT NULL,
  `friends` mediumint(6) NOT NULL DEFAULT 0,
  `moder` varchar(20) NOT NULL DEFAULT '',
  `moder_text` mediumtext NOT NULL DEFAULT '',
  `count_o` smallint(3) NOT NULL DEFAULT 0,
  `date_start_moder` int(11) NOT NULL DEFAULT 0,
  `date_end_moder` int(11) NOT NULL DEFAULT 0,
  `date` int(11) NOT NULL,
  `date_end` int(11) NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `still_vk_likes_user` (
  `id` int(11) NOT NULL,
  `idp` int(11) NOT NULL,
  `idu` int(11) NOT NULL,
  `id_vk` varchar(100) NOT NULL,
  `ip` varchar(15) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `date` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `still_vk_profil` (
  `id` int(11) NOT NULL,
  `idu` int(11) NOT NULL,
  `idp` varchar(30) NOT NULL DEFAULT '0',
  `domain` varchar(300) NOT NULL,
  `name` varchar(100) NOT NULL,
  `email` varchar(50) NOT NULL,
  `friends` int(11) NOT NULL DEFAULT 0,
  `time_updata` int(11) NOT NULL,
  `login` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `still_vk_repost` (
  `id` int(11) NOT NULL,
  `status` int(1) NOT NULL DEFAULT 0,
  `idu` int(11) NOT NULL DEFAULT 0,
  `author` varchar(20) NOT NULL,
  `vip` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
  `color` int(1) NOT NULL DEFAULT 0,
  `title` varchar(60) NOT NULL,
  `text` varchar(60) NOT NULL,
  `type` varchar(20) NOT NULL,
  `owner_id` varchar(30) NOT NULL,
  `item_id` varchar(30) NOT NULL,
  `url_vk` varchar(700) NOT NULL,
  `members` int(11) NOT NULL DEFAULT 0,
  `price_r` double(10,3) NOT NULL DEFAULT 0.000,
  `price_u` double(10,3) NOT NULL DEFAULT 0.000,
  `ballans` double(10,3) NOT NULL DEFAULT 0.000,
  `country` varchar(125) NOT NULL,
  `date_reg_user` int(4) NOT NULL DEFAULT 0,
  `rating_user` int(4) NOT NULL DEFAULT 0,
  `sex_user` smallint(1) NOT NULL DEFAULT 0,
  `vozrast` varchar(7) NOT NULL DEFAULT '0,999',
  `goroda` varchar(200) NOT NULL,
  `unik_ip_user` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
  `inter` tinyint(1) NOT NULL DEFAULT 0,
  `inter_text` varchar(100) NOT NULL,
  `friends` mediumint(6) NOT NULL DEFAULT 0,
  `moder` varchar(20) NOT NULL DEFAULT '',
  `moder_text` mediumtext NOT NULL DEFAULT '',
  `count_o` smallint(3) NOT NULL DEFAULT 0,
  `date_start_moder` int(11) NOT NULL DEFAULT 0,
  `date_end_moder` int(11) NOT NULL DEFAULT 0,
  `date` int(11) NOT NULL,
  `date_end` int(11) NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `still_vk_repost_user` (
  `id` int(11) NOT NULL,
  `idp` int(11) NOT NULL,
  `idu` int(11) NOT NULL,
  `id_vk` varchar(100) NOT NULL,
  `ip` varchar(15) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `date` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `still_youtube_abuse` (
  `id` int(11) NOT NULL,
  `idu` int(11) NOT NULL,
  `username` varchar(20) NOT NULL,
  `idr` int(11) NOT NULL,
  `reklamod` varchar(20) NOT NULL,
  `comment` varchar(500) NOT NULL,
  `date` int(11) NOT NULL,
  `idp` int(11) NOT NULL,
  `vid` tinyint(1) UNSIGNED NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `still_youtube_ads` (
  `id` int(11) NOT NULL,
  `status` int(1) NOT NULL DEFAULT 0,
  `idu` int(11) NOT NULL DEFAULT 0,
  `author` varchar(20) NOT NULL DEFAULT '',
  `vip` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
  `color` int(1) NOT NULL DEFAULT 0,
  `timer` int(3) NOT NULL DEFAULT 20,
  `title` varchar(60) NOT NULL,
  `text` varchar(60) NOT NULL,
  `id_video` varchar(30) NOT NULL,
  `members` int(11) NOT NULL DEFAULT 0,
  `price_r` double(10,3) NOT NULL DEFAULT 0.000,
  `price_u` double(10,3) NOT NULL DEFAULT 0.000,
  `ballans` double(10,3) NOT NULL DEFAULT 0.000,
  `country` varchar(125) NOT NULL DEFAULT '',
  `date_reg_user` int(4) NOT NULL DEFAULT 0,
  `rating_user` int(4) NOT NULL DEFAULT 0,
  `sex_user` smallint(1) NOT NULL DEFAULT 0,
  `vozrast` varchar(7) NOT NULL DEFAULT '0,999',
  `goroda` varchar(200) NOT NULL DEFAULT '',
  `unik_ip_user` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
  `inter` tinyint(1) NOT NULL DEFAULT 0,
  `inter_text` varchar(100) NOT NULL DEFAULT '',
  `texno` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
  `go_url` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
  `moder` varchar(20) NOT NULL DEFAULT '',
  `moder_text` mediumtext NOT NULL DEFAULT '',
  `count_o` smallint(3) NOT NULL DEFAULT 0,
  `date_start_moder` int(11) NOT NULL DEFAULT 0,
  `date_end_moder` int(11) NOT NULL DEFAULT 0,
  `date` int(11) NOT NULL,
  `date_end` int(11) NOT NULL DEFAULT 0,
  `autoclik` tinyint(1) UNSIGNED NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `still_youtube_ads_user` (
  `id` int(11) NOT NULL,
  `idp` int(11) NOT NULL,
  `idu` int(11) NOT NULL,
  `id_video` varchar(50) NOT NULL,
  `ip` varchar(15) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `date` int(11) NOT NULL,
  `date_inter` varchar(20) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `still_youtube_bl` (
  `id` int(11) NOT NULL,
  `user` varchar(20) NOT NULL,
  `idu` int(11) NOT NULL DEFAULT 0,
  `userb` varchar(20) NOT NULL,
  `idb` int(11) NOT NULL DEFAULT 0,
  `date` varchar(11) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `still_youtube_delprofil` (
  `id` int(11) NOT NULL,
  `idu` int(11) NOT NULL,
  `channel_id` varchar(24) NOT NULL,
  `id_google` varchar(30) NOT NULL DEFAULT '',
  `date` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `still_youtube_like` (
  `id` int(11) NOT NULL,
  `status` int(1) NOT NULL DEFAULT 0,
  `idu` int(11) NOT NULL DEFAULT 0,
  `author` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `vip` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
  `color` int(1) NOT NULL DEFAULT 0,
  `title` varchar(200) NOT NULL,
  `text` varchar(60) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `id_video` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `members` int(11) NOT NULL DEFAULT 0,
  `price_r` double(10,3) NOT NULL DEFAULT 0.000,
  `price_u` double(10,3) NOT NULL DEFAULT 0.000,
  `ballans` double(10,3) NOT NULL DEFAULT 0.000,
  `country` varchar(125) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `date_reg_user` int(4) NOT NULL DEFAULT 0,
  `rating_user` int(4) NOT NULL DEFAULT 0,
  `sex_user` smallint(1) NOT NULL DEFAULT 0,
  `vozrast` varchar(7) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '0,999',
  `goroda` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `unik_ip_user` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
  `inter` tinyint(1) NOT NULL DEFAULT 0,
  `inter_text` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `like` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
  `moder` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '',
  `moder_text` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '',
  `count_o` smallint(3) NOT NULL DEFAULT 0,
  `date_start_moder` int(11) NOT NULL DEFAULT 0,
  `date_end_moder` int(11) NOT NULL DEFAULT 0,
  `date` int(11) NOT NULL,
  `date_end` int(11) NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

CREATE TABLE `still_youtube_like_user` (
  `id` int(11) NOT NULL,
  `idp` int(11) NOT NULL,
  `idu` int(11) NOT NULL,
  `id_video` varchar(50) NOT NULL,
  `ip` varchar(15) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `date` int(11) NOT NULL,
  `date_inter` varchar(20) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `still_youtube_podp` (
  `id` int(11) NOT NULL,
  `status` int(1) NOT NULL DEFAULT 0,
  `idu` int(11) NOT NULL DEFAULT 0,
  `author` varchar(20) NOT NULL,
  `vip` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
  `color` int(1) NOT NULL DEFAULT 0,
  `title` varchar(60) NOT NULL,
  `text` varchar(60) NOT NULL,
  `id_channels` varchar(50) NOT NULL,
  `members` int(11) NOT NULL DEFAULT 0,
  `price_r` double(10,3) NOT NULL DEFAULT 0.000,
  `price_u` double(10,3) NOT NULL DEFAULT 0.000,
  `ballans` double(10,3) NOT NULL DEFAULT 0.000,
  `country` varchar(125) NOT NULL,
  `date_reg_user` int(4) NOT NULL DEFAULT 0,
  `rating_user` int(4) NOT NULL DEFAULT 0,
  `sex_user` smallint(1) NOT NULL DEFAULT 0,
  `vozrast` varchar(7) NOT NULL DEFAULT '0,999',
  `goroda` varchar(200) NOT NULL,
  `unik_ip_user` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
  `inter` tinyint(1) NOT NULL DEFAULT 0,
  `inter_text` varchar(100) NOT NULL,
  `moder` varchar(20) NOT NULL DEFAULT '',
  `moder_text` mediumtext NOT NULL DEFAULT '',
  `count_o` smallint(3) NOT NULL DEFAULT 0,
  `date_start_moder` int(11) NOT NULL DEFAULT 0,
  `date_end_moder` int(11) NOT NULL DEFAULT 0,
  `date` int(11) NOT NULL,
  `date_end` int(11) NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `still_youtube_podp_user` (
  `id` int(11) NOT NULL,
  `idp` int(11) NOT NULL,
  `idu` int(11) NOT NULL,
  `id_video` varchar(50) NOT NULL,
  `ip` varchar(15) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `date` int(11) NOT NULL,
  `date_inter` varchar(20) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `tb_add_pay` (
  `id` int(11) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `merch_tran_id` int(11) NOT NULL DEFAULT 0,
  `method_pay` tinyint(1) NOT NULL DEFAULT 0,
  `dop_method` varchar(50) NOT NULL,
  `id_user` int(11) NOT NULL DEFAULT 0,
  `username` varchar(25) NOT NULL,
  `wmid` varchar(15) NOT NULL DEFAULT '',
  `date` int(11) NOT NULL,
  `ip` varchar(15) NOT NULL,
  `money` float(10,2) NOT NULL DEFAULT 0.00,
  `test` mediumtext NOT NULL DEFAULT '',
  `data` varchar(1000) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `tb_ads_banner` (
  `id` int(11) NOT NULL,
  `status` int(1) NOT NULL DEFAULT 0,
  `session_ident` varchar(50) NOT NULL,
  `merch_tran_id` int(11) NOT NULL DEFAULT 0,
  `method_pay` int(1) NOT NULL DEFAULT 0,
  `dop_method` varchar(50) NOT NULL,
  `type` varchar(10) NOT NULL,
  `mesto` int(11) NOT NULL DEFAULT 0,
  `plan` int(11) NOT NULL DEFAULT 0,
  `date` int(11) NOT NULL DEFAULT 0,
  `date_end` int(11) NOT NULL DEFAULT 0,
  `date_stop` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `wmid` varchar(15) NOT NULL,
  `username` varchar(20) NOT NULL,
  `id_user` int(11) NOT NULL DEFAULT 0,
  `url` varchar(160) NOT NULL,
  `urlbanner` varchar(160) NOT NULL,
  `picbanner` varchar(41) NOT NULL,
  `ip` varchar(15) NOT NULL,
  `money` float(10,2) NOT NULL DEFAULT 0.00,
  `ost` double(9,4) NOT NULL DEFAULT 0.0000
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `tb_ads_dlink` (
  `id` int(11) NOT NULL,
  `status` int(1) NOT NULL DEFAULT 0,
  `id_user` int(11) NOT NULL DEFAULT 0,
  `username` varchar(20) NOT NULL DEFAULT '',
  `date` int(11) NOT NULL DEFAULT 0,
  `date_stop` int(11) NOT NULL DEFAULT 0,
  `category` int(1) NOT NULL DEFAULT 1,
  `active` int(1) NOT NULL DEFAULT 0,
  `color` int(1) NOT NULL DEFAULT 0,
  `timer` int(3) NOT NULL DEFAULT 20,
  `nolimit` int(11) NOT NULL DEFAULT 0,
  `limit_plan` smallint(2) NOT NULL DEFAULT 0,
  `url` varchar(160) NOT NULL,
  `description` varchar(60) NOT NULL,
  `opisanie` varchar(60) NOT NULL,
  `members` int(11) NOT NULL DEFAULT 0,
  `outside` int(11) NOT NULL DEFAULT 0,
  `claims` int(11) NOT NULL DEFAULT 0,
  `ip` varchar(15) NOT NULL DEFAULT '',
  `max_v` int(11) NOT NULL DEFAULT 0,
  `country` varchar(125) NOT NULL DEFAULT '',
  `date_reg_user` int(4) NOT NULL DEFAULT 0,
  `rating_user` int(4) NOT NULL DEFAULT 0,
  `sex_user` smallint(1) NOT NULL DEFAULT 0,
  `chastota_serf` smallint(1) NOT NULL DEFAULT 0,
  `ref` smallint(1) NOT NULL DEFAULT 0,
  `perehod` tinyint(1) NOT NULL DEFAULT 0,
  `date_end` int(11) NOT NULL DEFAULT 0,
  `uved` tinyint(1) NOT NULL DEFAULT 0,
  `vozrast` varchar(7) NOT NULL DEFAULT '0,999',
  `goroda` varchar(200) NOT NULL DEFAULT '',
  `autoclik` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
  `unik_ip_user` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
  `time_stop` int(11) NOT NULL DEFAULT 0,
  `price_u` double(9,4) NOT NULL DEFAULT 0.0000,
  `price_r` double(9,4) NOT NULL DEFAULT 0.0000,
  `balance` double(14,4) NOT NULL DEFAULT 0.0000,
  `moder` varchar(20) NOT NULL DEFAULT '',
  `moder_text` mediumtext NOT NULL DEFAULT '',
  `count_o` smallint(3) NOT NULL DEFAULT 0,
  `date_start_moder` int(11) NOT NULL DEFAULT 0,
  `date_end_moder` int(11) NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `tb_ads_dlink_visits` (
  `id` int(11) NOT NULL,
  `username` varchar(20) NOT NULL,
  `idu` int(11) NOT NULL,
  `ids` int(11) NOT NULL,
  `date` int(11) NOT NULL,
  `ip` varchar(15) NOT NULL,
  `status` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
  `money` double(10,6) NOT NULL DEFAULT 0.000000
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `tb_ads_fraim` (
  `id` int(11) NOT NULL,
  `status` int(1) NOT NULL DEFAULT 0,
  `session_ident` varchar(50) NOT NULL,
  `merch_tran_id` int(11) NOT NULL DEFAULT 0,
  `method_pay` int(1) NOT NULL DEFAULT 0,
  `dop_method` varchar(50) NOT NULL,
  `plan` int(11) NOT NULL DEFAULT 0,
  `date` int(11) NOT NULL DEFAULT 0,
  `date_end` int(11) NOT NULL DEFAULT 0,
  `date_stop` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `wmid` varchar(15) NOT NULL,
  `username` varchar(20) NOT NULL,
  `id_user` int(11) NOT NULL DEFAULT 0,
  `url` varchar(160) NOT NULL,
  `title` varchar(100) NOT NULL,
  `views` int(11) NOT NULL DEFAULT 0,
  `ip` varchar(15) NOT NULL,
  `money` float(10,2) NOT NULL DEFAULT 0.00,
  `ost` double(9,4) NOT NULL DEFAULT 0.0000,
  `out` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `tb_ads_mails` (
  `id` int(11) NOT NULL,
  `status` int(1) NOT NULL DEFAULT 0,
  `date` int(11) NOT NULL DEFAULT 0,
  `date_stop` int(11) NOT NULL DEFAULT 0,
  `username` varchar(20) NOT NULL DEFAULT '',
  `id_user` int(11) NOT NULL DEFAULT 0,
  `title` varchar(70) NOT NULL,
  `url` varchar(160) NOT NULL,
  `description` mediumtext NOT NULL,
  `question` varchar(70) NOT NULL,
  `answer_t` varchar(70) NOT NULL,
  `answer_f_1` varchar(70) NOT NULL,
  `answer_f_2` varchar(70) NOT NULL,
  `members` int(11) NOT NULL DEFAULT 0,
  `nolimit` int(11) NOT NULL DEFAULT 0,
  `limit_plan` smallint(2) NOT NULL DEFAULT 0,
  `tarif` int(1) NOT NULL DEFAULT 0,
  `color` int(1) NOT NULL DEFAULT 0,
  `active` int(1) NOT NULL DEFAULT 0,
  `gotosite` int(1) NOT NULL DEFAULT 0,
  `mailsre` int(1) NOT NULL DEFAULT 0,
  `claims` int(1) NOT NULL DEFAULT 0,
  `ip` varchar(15) NOT NULL DEFAULT '',
  `country` varchar(125) NOT NULL DEFAULT '',
  `date_reg_user` int(4) NOT NULL DEFAULT 0,
  `rating_user` int(4) NOT NULL DEFAULT 0,
  `sex_user` smallint(1) NOT NULL DEFAULT 0,
  `chastota_serf` smallint(1) NOT NULL DEFAULT 0,
  `ref` smallint(1) NOT NULL DEFAULT 0,
  `date_end` int(11) NOT NULL DEFAULT 0,
  `uved` tinyint(1) NOT NULL DEFAULT 0,
  `vozrast` varchar(7) NOT NULL DEFAULT '0,999',
  `goroda` varchar(200) NOT NULL DEFAULT '',
  `autoclik` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
  `unik_ip_user` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
  `time_stop` int(11) NOT NULL DEFAULT 0,
  `price_u` double(9,4) NOT NULL DEFAULT 0.0000,
  `price_r` double(9,4) NOT NULL DEFAULT 0.0000,
  `balance` double(14,4) NOT NULL DEFAULT 0.0000,
  `moder` varchar(20) NOT NULL DEFAULT '',
  `moder_text` mediumtext NOT NULL DEFAULT '',
  `count_o` smallint(3) NOT NULL DEFAULT 0,
  `date_start_moder` int(11) NOT NULL DEFAULT 0,
  `date_end_moder` int(11) NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `tb_ads_mails_visits` (
  `id` int(11) NOT NULL,
  `username` varchar(20) NOT NULL,
  `ident` int(11) NOT NULL DEFAULT 0,
  `type` int(1) NOT NULL DEFAULT 0,
  `date` int(11) NOT NULL DEFAULT 0,
  `ip` varchar(15) NOT NULL,
  `money` float(12,5) NOT NULL DEFAULT 0.00000,
  `status` tinyint(1) UNSIGNED NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `tb_ads_slinks` (
  `id` int(11) NOT NULL,
  `status` int(1) NOT NULL DEFAULT 0,
  `session_ident` varchar(50) NOT NULL,
  `merch_tran_id` int(11) NOT NULL DEFAULT 0,
  `method_pay` int(1) NOT NULL DEFAULT 0,
  `dop_method` varchar(50) NOT NULL,
  `type` int(1) NOT NULL DEFAULT 0,
  `plan` int(11) NOT NULL DEFAULT 0,
  `date` int(11) NOT NULL DEFAULT 0,
  `date_end` int(11) NOT NULL DEFAULT 0,
  `date_stop` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `wmid` varchar(15) NOT NULL,
  `username` varchar(20) NOT NULL,
  `id_user` int(11) NOT NULL DEFAULT 0,
  `url` varchar(160) NOT NULL,
  `headline` varchar(30) NOT NULL,
  `description` varchar(70) NOT NULL,
  `color` int(1) NOT NULL DEFAULT 0,
  `views` int(11) NOT NULL DEFAULT 0,
  `ip` varchar(15) NOT NULL,
  `money` float(10,2) NOT NULL DEFAULT 0.00,
  `ost` double(9,4) NOT NULL DEFAULT 0.0000
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `tb_ads_slinks_visits` (
  `id` int(11) NOT NULL,
  `id_links` int(11) NOT NULL DEFAULT 0,
  `ip` varchar(15) NOT NULL DEFAULT '0',
  `date` int(11) NOT NULL DEFAULT 0,
  `user` varchar(20) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `tb_ads_txt` (
  `id` int(11) NOT NULL,
  `status` int(1) NOT NULL DEFAULT 0,
  `session_ident` varchar(50) NOT NULL,
  `merch_tran_id` int(11) NOT NULL DEFAULT 0,
  `method_pay` int(1) NOT NULL DEFAULT 0,
  `dop_method` varchar(50) NOT NULL,
  `plan` int(11) NOT NULL DEFAULT 0,
  `date` int(11) NOT NULL DEFAULT 0,
  `date_end` int(11) NOT NULL DEFAULT 0,
  `date_stop` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `wmid` varchar(15) NOT NULL,
  `username` varchar(20) NOT NULL,
  `id_user` int(11) NOT NULL DEFAULT 0,
  `url` varchar(160) NOT NULL,
  `title` varchar(60) NOT NULL DEFAULT '',
  `description` varchar(255) NOT NULL,
  `color` int(1) NOT NULL DEFAULT 0,
  `ip` varchar(31) NOT NULL,
  `money` float(10,2) NOT NULL DEFAULT 0.00,
  `balance` decimal(15,4) NOT NULL DEFAULT 0.0000,
  `ost` double(9,4) NOT NULL DEFAULT 0.0000,
  `count` mediumint(8) NOT NULL DEFAULT 0,
  `date_check` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `tb_articles` (
  `id` int(11) NOT NULL,
  `title` varchar(100) NOT NULL,
  `text` varchar(10000) NOT NULL,
  `chpu` varchar(100) NOT NULL,
  `status` int(11) NOT NULL,
  `coments` int(11) NOT NULL DEFAULT 0,
  `data` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

CREATE TABLE `tb_articles_coment` (
  `id` int(11) NOT NULL,
  `article_id` int(11) NOT NULL,
  `username_com` varchar(32) NOT NULL,
  `coment` varchar(3000) NOT NULL,
  `coment_otv` varchar(3000) NOT NULL DEFAULT '',
  `date` int(11) NOT NULL DEFAULT 0,
  `ip` varchar(15) NOT NULL,
  `ip_otv` varchar(15) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `moder` varchar(25) NOT NULL DEFAULT '',
  `support_name` varchar(70) NOT NULL DEFAULT '',
  `support_vid` tinyint(4) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

CREATE TABLE `tb_bansite` (
  `id` int(11) NOT NULL,
  `dateban` int(11) NOT NULL,
  `wmid` varchar(12) NOT NULL DEFAULT '',
  `username` varchar(30) NOT NULL DEFAULT '',
  `url` varchar(150) NOT NULL,
  `parseurl` varchar(150) NOT NULL,
  `prichina` smallint(3) NOT NULL DEFAULT 0,
  `moder` varchar(20) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `tb_banwmid` (
  `id` int(11) NOT NULL,
  `wmid` varchar(12) NOT NULL,
  `user` varchar(15) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `tb_desk` (
  `id` int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
  `user` varchar(20) NOT NULL,
  `refback` smallint(2) NOT NULL,
  `rating` float(18,2) NOT NULL DEFAULT 0.00,
  `data` int(11) NOT NULL,
  `segodnya` int(11) NOT NULL DEFAULT 0,
  `kolvo` int(11) NOT NULL DEFAULT 0,
  `priz` float(10,2) NOT NULL DEFAULT 0.00,
  `komment` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `tb_desk_priz` (
  `id` int(11) NOT NULL,
  `date` int(11) NOT NULL,
  `username` varchar(20) NOT NULL,
  `summa` float(10,2) NOT NULL DEFAULT 0.00
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `tb_history` (
  `id` int(11) NOT NULL,
  `user` varchar(20) NOT NULL,
  `id_user` int(11) NOT NULL DEFAULT 0,
  `date` varchar(21) NOT NULL,
  `ballans` float(10,4) NOT NULL DEFAULT 0.0000,
  `amount` float NOT NULL,
  `amount_d` float(14,2) NOT NULL DEFAULT 0.00,
  `ostatok` float(10,4) NOT NULL DEFAULT 0.0000,
  `method` char(2) NOT NULL,
  `status` char(2) NOT NULL,
  `payzasutki` int(11) NOT NULL,
  `wmid` bigint(11) NOT NULL DEFAULT 0,
  `tipo` varchar(15) NOT NULL DEFAULT '',
  `wmr` char(13) NOT NULL DEFAULT '0',
  `yandex` char(15) NOT NULL DEFAULT '',
  `qiwi` bigint(19) NOT NULL DEFAULT 0,
  `payeer` char(20) NOT NULL DEFAULT '',
  `perfectmoney` varchar(15) NOT NULL DEFAULT '',
  `qiwi_pay` bigint(19) NOT NULL DEFAULT 0,
  `ip_user` varchar(15) NOT NULL DEFAULT '',
  `id2` int(11) NOT NULL DEFAULT 0,
  `lastiplog` varchar(15) NOT NULL DEFAULT '',
  `vr_pole` smallint(1) NOT NULL DEFAULT 0,
  `err` varchar(50) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `tb_messfornewref` (
  `id` int(11) NOT NULL,
  `username` varchar(20) NOT NULL,
  `tema` varchar(50) NOT NULL,
  `messaga_forref` varchar(1000) NOT NULL,
  `test` tinyint(1) UNSIGNED NOT NULL DEFAULT 1
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `tb_news` (
  `id` int(10) NOT NULL,
  `data` varchar(15) NOT NULL,
  `news_title` varchar(60) NOT NULL,
  `newstext` varchar(3000) NOT NULL,
  `coments` int(11) NOT NULL DEFAULT 0,
  `status` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `tb_news_coment` (
  `id` int(11) NOT NULL,
  `ident` int(11) NOT NULL DEFAULT 0,
  `username_com` varchar(25) NOT NULL,
  `coment` mediumtext NOT NULL,
  `coment_otv` mediumtext NOT NULL DEFAULT '',
  `date` int(11) NOT NULL DEFAULT 0,
  `ip` varchar(15) NOT NULL,
  `ip_otv` varchar(15) NOT NULL,
  `status` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
  `moder` varchar(25) NOT NULL DEFAULT '',
  `support_name` varchar(70) NOT NULL DEFAULT '',
  `support_vid` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `tb_operations` (
  `id` int(11) NOT NULL,
  `type` smallint(2) NOT NULL DEFAULT 0,
  `tip` smallint(2) NOT NULL,
  `id_user` int(11) NOT NULL DEFAULT 0,
  `user` varchar(20) NOT NULL,
  `date` int(11) NOT NULL,
  `operations` varchar(300) NOT NULL,
  `oplata` float NOT NULL DEFAULT 0,
  `ostatok_money_rekl` float(18,4) NOT NULL DEFAULT 0.0000,
  `ip` varchar(15) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `tb_pay_stat` (
  `id` int(11) NOT NULL,
  `type` varchar(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci NOT NULL,
  `mon` double(18,6) NOT NULL DEFAULT 0.000000,
  `tue` double(18,6) NOT NULL DEFAULT 0.000000,
  `wed` double(18,6) NOT NULL DEFAULT 0.000000,
  `thu` double(18,6) NOT NULL DEFAULT 0.000000,
  `fri` double(18,6) NOT NULL DEFAULT 0.000000,
  `sat` double(18,6) NOT NULL DEFAULT 0.000000,
  `sun` double(18,6) NOT NULL DEFAULT 0.000000
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `tb_ref_rass` (
  `id` int(11) NOT NULL,
  `user` varchar(20) NOT NULL,
  `ava_sender` varchar(30) NOT NULL DEFAULT '',
  `fio_sender` varchar(10) NOT NULL,
  `type` int(11) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 0,
  `money` float(14,2) NOT NULL DEFAULT 0.00,
  `text` varchar(1000) NOT NULL,
  `date` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `tb_stat_refbirj` (
  `id` int(11) NOT NULL,
  `date` int(11) NOT NULL DEFAULT 0,
  `pokupatel` varchar(30) NOT NULL,
  `referal` varchar(30) NOT NULL,
  `prodavec` varchar(30) NOT NULL,
  `price` float(10,2) NOT NULL DEFAULT 0.00
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `tb_support_tik` (
  `id` int(11) NOT NULL,
  `email` varchar(40) NOT NULL,
  `tema` varchar(50) NOT NULL,
  `category` tinyint(1) NOT NULL,
  `prioritet` tinyint(1) NOT NULL DEFAULT 0,
  `text` mediumtext NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `date_oup_lok` int(11) NOT NULL DEFAULT 0,
  `date` int(11) NOT NULL,
  `soob` int(11) NOT NULL DEFAULT 0,
  `reade` smallint(5) NOT NULL DEFAULT 0,
  `readea` smallint(5) NOT NULL DEFAULT 0,
  `kol` tinyint(1) NOT NULL DEFAULT 0,
  `dop_infa` mediumtext NOT NULL DEFAULT '',
  `otv_users` varchar(20) NOT NULL DEFAULT '',
  `moder` varchar(20) NOT NULL DEFAULT '',
  `start_moder` int(11) NOT NULL DEFAULT 0,
  `important` varchar(100) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `tb_support_tiks` (
  `id` int(11) NOT NULL,
  `email` varchar(40) NOT NULL,
  `text` mediumtext NOT NULL,
  `date` int(11) NOT NULL,
  `numb` int(11) NOT NULL,
  `otvet` tinyint(1) NOT NULL DEFAULT 0,
  `scrin` varchar(500) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `tb_task_bl` (
  `id` int(11) NOT NULL,
  `id_task` int(11) NOT NULL DEFAULT 0,
  `user` varchar(20) NOT NULL,
  `id_user` int(11) NOT NULL DEFAULT 0,
  `user_z` varchar(20) NOT NULL,
  `id_z` int(11) NOT NULL DEFAULT 0,
  `otvet` mediumtext NOT NULL,
  `data` varchar(11) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `tb_task_i` (
  `id` int(11) NOT NULL,
  `id_task` int(11) NOT NULL DEFAULT 0,
  `user` varchar(20) NOT NULL,
  `id_user` int(11) NOT NULL DEFAULT 0,
  `date` int(11) NOT NULL DEFAULT 0,
  `status` int(1) NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `tb_task_m` (
  `id` int(11) NOT NULL,
  `id_task` int(11) NOT NULL,
  `id_user` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `tb_task_otziv` (
  `id` int(11) NOT NULL,
  `id_task` int(11) NOT NULL DEFAULT 0,
  `user` varchar(20) NOT NULL,
  `id_user` int(11) NOT NULL DEFAULT 0,
  `otziv` varchar(500) NOT NULL DEFAULT '',
  `autor_comm` varchar(500) NOT NULL DEFAULT '',
  `ocenka` int(1) NOT NULL DEFAULT 0,
  `date` int(11) NOT NULL,
  `status_otz` smallint(1) NOT NULL DEFAULT 0,
  `moder` varchar(25) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `tb_task_r` (
  `id` int(11) NOT NULL,
  `id_task` int(11) NOT NULL DEFAULT 0,
  `author` varchar(20) NOT NULL,
  `id_author` int(11) NOT NULL DEFAULT 0,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `user` varchar(20) NOT NULL,
  `id_user` int(11) NOT NULL DEFAULT 0,
  `otvet` varchar(3000) NOT NULL DEFAULT '',
  `scrin_1` varchar(150) NOT NULL DEFAULT '',
  `scrin_2` varchar(150) NOT NULL DEFAULT '',
  `scrin_3` varchar(150) NOT NULL DEFAULT '',
  `scrin_4` varchar(150) NOT NULL DEFAULT '',
  `data` varchar(11) NOT NULL DEFAULT '',
  `dataotvet` varchar(11) NOT NULL DEFAULT '',
  `datarezult` varchar(11) NOT NULL DEFAULT '',
  `badotvet` varchar(300) NOT NULL DEFAULT '',
  `good` int(11) NOT NULL DEFAULT 0,
  `dor_ka` smallint(3) NOT NULL DEFAULT 0,
  `time_rework` int(10) UNSIGNED DEFAULT 0,
  `ip_user` varchar(15) NOT NULL DEFAULT '',
  `ip_start` varchar(15) NOT NULL,
  `c_code` varchar(2) NOT NULL DEFAULT '',
  `money` float(18,4) NOT NULL DEFAULT 0.0000,
  `atte` int(1) NOT NULL DEFAULT 0,
  `mnog` tinyint(1) NOT NULL DEFAULT 0,
  `dop_status` tinyint(1) NOT NULL DEFAULT 0,
  `dop_auto` tinyint(1) NOT NULL DEFAULT 0,
  `categ` tinyint(3) NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `tb_task_s` (
  `id` int(11) NOT NULL,
  `author` varchar(20) NOT NULL,
  `id_author` int(11) NOT NULL DEFAULT 0,
  `data` varchar(11) NOT NULL DEFAULT '',
  `id_task` int(11) NOT NULL DEFAULT 0,
  `typ` int(1) NOT NULL DEFAULT 0,
  `amount` float NOT NULL DEFAULT 0,
  `other` varchar(40) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `tb_wall_coment` (
  `id` int(11) NOT NULL,
  `username` varchar(20) NOT NULL,
  `username_id` int(11) NOT NULL DEFAULT 0,
  `username_com` varchar(20) NOT NULL,
  `username_com_id` int(11) NOT NULL DEFAULT 0,
  `coment` mediumtext NOT NULL,
  `ocenka` int(1) NOT NULL DEFAULT 0,
  `coment_otv` mediumtext NOT NULL,
  `date` int(11) NOT NULL DEFAULT 0,
  `ip` varchar(15) NOT NULL,
  `ip_otv` varchar(15) NOT NULL,
  `status_komment` tinyint(1) NOT NULL DEFAULT 0,
  `moder` varchar(20) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;


ALTER TABLE `ads_abuse`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `regmonitor`
  ADD KEY `id` (`id`);

ALTER TABLE `still_autoclik`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idu` (`idu`);

ALTER TABLE `still_block_earnings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user` (`user`),
  ADD KEY `idu` (`idu`),
  ADD KEY `idb` (`idb`),
  ADD KEY `userb` (`userb`);

ALTER TABLE `still_block_reklam`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user` (`user`),
  ADD KEY `idu` (`idu`),
  ADD KEY `idb` (`idb`),
  ADD KEY `userb` (`userb`);

ALTER TABLE `still_block_white`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user` (`user`),
  ADD KEY `idu` (`idu`),
  ADD KEY `idb` (`idb`),
  ADD KEY `userb` (`userb`);

ALTER TABLE `still_chain`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `still_chat`
  ADD PRIMARY KEY (`id`),
  ADD KEY `date` (`date`),
  ADD KEY `moder` (`moder`);

ALTER TABLE `still_chat_block`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idu` (`idu`,`idu_b`),
  ADD KEY `users` (`users`),
  ADD KEY `users_b` (`users_b`);

ALTER TABLE `still_chat_online`
  ADD UNIQUE KEY `username` (`username`);

ALTER TABLE `still_competition`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `still_competition_data`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `idu` (`idu`,`idk`);

ALTER TABLE `still_day_stata`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users` (`users`),
  ADD KEY `date` (`date`);

ALTER TABLE `still_faq_categ`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `still_faq_help`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idc` (`idc`);
ALTER TABLE `still_faq_help` ADD FULLTEXT KEY `title` (`title`,`text`);

ALTER TABLE `still_friends`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idu` (`idu`,`idf`,`status`),
  ADD KEY `date` (`date`);

ALTER TABLE `still_gift_cat`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mesto` (`mesto`),
  ADD KEY `status` (`status`);

ALTER TABLE `still_gift_img`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idc` (`idc`,`mesto`);

ALTER TABLE `still_gift_users`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idu` (`idu`,`idw`,`date`,`status`);

ALTER TABLE `still_goodref`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idu` (`idu`);

ALTER TABLE `still_mail`
  ADD PRIMARY KEY (`id`),
  ADD KEY `recipient` (`recipient`),
  ADD KEY `sender` (`sender`),
  ADD KEY `status_inc` (`status_inc`),
  ADD KEY `status_out` (`status_out`),
  ADD KEY `date` (`date`);

ALTER TABLE `still_mail_block`
  ADD UNIQUE KEY `username` (`username`);

ALTER TABLE `still_mail_mess`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idm` (`idm`);

ALTER TABLE `still_moder_bonus`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idu` (`idu`),
  ADD KEY `month` (`month`);

ALTER TABLE `still_moder_history`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idr` (`idr`);

ALTER TABLE `still_moder_mess`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `still_moder_reklama`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idu` (`idu`);

ALTER TABLE `still_note`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idu` (`idu`);

ALTER TABLE `still_online`
  ADD UNIQUE KEY `visitor` (`visitor`),
  ADD KEY `usonline` (`usonline`);

ALTER TABLE `still_perfect_id`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `still_ref_bonus`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idu` (`idu`),
  ADD KEY `status` (`status`);

ALTER TABLE `still_ref_bonus_rezult`
  ADD KEY `idu` (`idu`,`idk`);

ALTER TABLE `still_ref_koncurs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idu` (`idu`),
  ADD KEY `status` (`status`);

ALTER TABLE `still_ref_koncurs_rezult`
  ADD KEY `idu` (`idu`,`idk`);

ALTER TABLE `still_rutube_abuse`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idp` (`idp`),
  ADD KEY `vid` (`vid`);

ALTER TABLE `still_rutube_ads`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `still_rutube_ads_user`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `still_shoot`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idu` (`idu`,`vid`,`shoot`);

ALTER TABLE `still_socialseti`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idu` (`idu`),
  ADD KEY `youtube_all` (`youtube_all`),
  ADD KEY `vk_all` (`vk_all`),
  ADD KEY `vk_all_2` (`vk_all`);

ALTER TABLE `still_support_mess`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `still_support_moder`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idu` (`idu`);

ALTER TABLE `still_support_setup`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idu` (`idu`);

ALTER TABLE `still_task_abuse`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idz` (`idz`);

ALTER TABLE `still_test_bl`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user` (`user`),
  ADD KEY `user_z` (`user_z`),
  ADD KEY `id_user` (`id_user`,`id_z`),
  ADD KEY `id_z` (`id_z`);

ALTER TABLE `still_test_i`
  ADD KEY `id` (`id`),
  ADD KEY `idt` (`idt`,`user`),
  ADD KEY `idu` (`idu`);

ALTER TABLE `still_test_m`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idt` (`idt`,`idu`),
  ADD KEY `idu` (`idu`);

ALTER TABLE `still_test_r`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idt` (`idt`),
  ADD KEY `idu` (`idu`);

ALTER TABLE `still_test_status`
  ADD PRIMARY KEY (`id`),
  ADD KEY `status` (`status`),
  ADD KEY `idu` (`idu`),
  ADD KEY `idt` (`idt`,`status`,`ip`),
  ADD KEY `start_date` (`start_date`),
  ADD KEY `date` (`date`);

ALTER TABLE `still_vk_abuse`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idp` (`idp`),
  ADD KEY `vid` (`vid`);

ALTER TABLE `still_vk_bl`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user` (`user`),
  ADD KEY `user_z` (`userb`),
  ADD KEY `id_user` (`idu`,`idb`),
  ADD KEY `id_z` (`idb`);

ALTER TABLE `still_vk_delprofil`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idu` (`idu`,`id_vk`),
  ADD KEY `id_google` (`id_vk`);

ALTER TABLE `still_vk_groups`
  ADD PRIMARY KEY (`id`),
  ADD KEY `status` (`status`),
  ADD KEY `idu` (`idu`),
  ADD KEY `price_r` (`price_r`),
  ADD KEY `ballans` (`ballans`);

ALTER TABLE `still_vk_groups_user`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idp` (`idp`),
  ADD KEY `idu` (`idu`),
  ADD KEY `id_vk` (`id_vk`),
  ADD KEY `ip` (`ip`),
  ADD KEY `status` (`status`),
  ADD KEY `date` (`date`);

ALTER TABLE `still_vk_likes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `status` (`status`),
  ADD KEY `idu` (`idu`),
  ADD KEY `price_r` (`price_r`),
  ADD KEY `ballans` (`ballans`);

ALTER TABLE `still_vk_likes_user`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idp` (`idp`),
  ADD KEY `idu` (`idu`),
  ADD KEY `id_vk` (`id_vk`),
  ADD KEY `ip` (`ip`),
  ADD KEY `status` (`status`),
  ADD KEY `date` (`date`);

ALTER TABLE `still_vk_profil`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idu` (`idu`),
  ADD KEY `idp` (`idp`);

ALTER TABLE `still_vk_repost`
  ADD PRIMARY KEY (`id`),
  ADD KEY `status` (`status`),
  ADD KEY `idu` (`idu`),
  ADD KEY `price_r` (`price_r`),
  ADD KEY `ballans` (`ballans`);

ALTER TABLE `still_vk_repost_user`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idp` (`idp`),
  ADD KEY `idu` (`idu`),
  ADD KEY `id_vk` (`id_vk`),
  ADD KEY `ip` (`ip`),
  ADD KEY `status` (`status`),
  ADD KEY `date` (`date`);

ALTER TABLE `still_youtube_abuse`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idp` (`idp`),
  ADD KEY `vid` (`vid`);

ALTER TABLE `still_youtube_ads`
  ADD PRIMARY KEY (`id`),
  ADD KEY `status` (`status`),
  ADD KEY `idu` (`idu`),
  ADD KEY `autoclik` (`autoclik`);

ALTER TABLE `still_youtube_ads_user`
  ADD PRIMARY KEY (`id`),
  ADD KEY `status` (`status`),
  ADD KEY `idu` (`idu`),
  ADD KEY `ip` (`ip`),
  ADD KEY `date` (`date`),
  ADD KEY `idp` (`idp`),
  ADD KEY `date_inter` (`date_inter`);

ALTER TABLE `still_youtube_bl`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user` (`user`),
  ADD KEY `user_z` (`userb`),
  ADD KEY `id_user` (`idu`,`idb`),
  ADD KEY `id_z` (`idb`);

ALTER TABLE `still_youtube_delprofil`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idu` (`idu`,`id_google`),
  ADD KEY `id_google` (`id_google`);

ALTER TABLE `still_youtube_like`
  ADD PRIMARY KEY (`id`),
  ADD KEY `status` (`status`),
  ADD KEY `idu` (`idu`);

ALTER TABLE `still_youtube_like_user`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idp` (`idp`,`idu`,`id_video`,`ip`,`status`,`date`),
  ADD KEY `status` (`status`),
  ADD KEY `idu` (`idu`),
  ADD KEY `ip` (`ip`),
  ADD KEY `date` (`date`),
  ADD KEY `id_video` (`id_video`),
  ADD KEY `date_inter` (`date_inter`);

ALTER TABLE `still_youtube_podp`
  ADD PRIMARY KEY (`id`),
  ADD KEY `status` (`status`),
  ADD KEY `idu` (`idu`);

ALTER TABLE `still_youtube_podp_user`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idp` (`idp`,`idu`,`id_video`,`ip`,`status`,`date`),
  ADD KEY `status` (`status`),
  ADD KEY `idu` (`idu`),
  ADD KEY `ip` (`ip`),
  ADD KEY `date` (`date`),
  ADD KEY `id_video` (`id_video`),
  ADD KEY `date_inter` (`date_inter`);

ALTER TABLE `tb_add_pay`
  ADD PRIMARY KEY (`id`),
  ADD KEY `status` (`status`),
  ADD KEY `username` (`username`),
  ADD KEY `merch_tran_id` (`merch_tran_id`);

ALTER TABLE `tb_ads_banner`
  ADD PRIMARY KEY (`id`),
  ADD KEY `status` (`status`,`type`,`mesto`,`date_end`,`wmid`);

ALTER TABLE `tb_ads_dlink`
  ADD PRIMARY KEY (`id`),
  ADD KEY `status` (`status`,`category`),
  ADD KEY `autoclik` (`autoclik`),
  ADD KEY `autoclik_2` (`autoclik`),
  ADD KEY `category` (`category`),
  ADD KEY `max_v` (`max_v`);

ALTER TABLE `tb_ads_dlink_visits`
  ADD PRIMARY KEY (`id`),
  ADD KEY `status` (`status`),
  ADD KEY `idu` (`idu`),
  ADD KEY `date` (`date`),
  ADD KEY `ids` (`ids`);

ALTER TABLE `tb_ads_fraim`
  ADD PRIMARY KEY (`id`),
  ADD KEY `status` (`status`,`date_end`,`wmid`);

ALTER TABLE `tb_ads_mails`
  ADD PRIMARY KEY (`id`),
  ADD KEY `date` (`date`),
  ADD KEY `status` (`status`),
  ADD KEY `username` (`username`),
  ADD KEY `autoclik` (`autoclik`),
  ADD KEY `autoclik_2` (`autoclik`);

ALTER TABLE `tb_ads_mails_visits`
  ADD PRIMARY KEY (`id`),
  ADD KEY `username` (`username`),
  ADD KEY `ident` (`ident`),
  ADD KEY `type` (`type`),
  ADD KEY `date` (`date`),
  ADD KEY `status` (`status`);

ALTER TABLE `tb_ads_slinks`
  ADD PRIMARY KEY (`id`),
  ADD KEY `status` (`status`,`type`,`date_end`,`wmid`);

ALTER TABLE `tb_ads_slinks_visits`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `tb_ads_txt`
  ADD PRIMARY KEY (`id`),
  ADD KEY `status` (`status`),
  ADD KEY `date` (`date`),
  ADD KEY `date_end` (`date_end`);

ALTER TABLE `tb_articles`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `tb_articles_coment`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `tb_bansite`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `url` (`url`,`parseurl`);

ALTER TABLE `tb_banwmid`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `tb_desk`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `tb_desk_priz`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `tb_history`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user` (`user`,`date`),
  ADD KEY `date` (`date`),
  ADD KEY `status` (`status`),
  ADD KEY `wmr` (`wmr`),
  ADD KEY `payzasutki` (`payzasutki`),
  ADD KEY `yandex` (`yandex`),
  ADD KEY `qiwi` (`qiwi`),
  ADD KEY `payeer` (`payeer`),
  ADD KEY `perfectmoney` (`perfectmoney`),
  ADD KEY `qiwi_pay` (`qiwi_pay`),
  ADD KEY `lastiplog` (`lastiplog`),
  ADD KEY `ip_user` (`ip_user`),
  ADD KEY `amount` (`amount`);

ALTER TABLE `tb_messfornewref`
  ADD PRIMARY KEY (`id`),
  ADD KEY `username` (`username`);

ALTER TABLE `tb_news`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `tb_news_coment`
  ADD PRIMARY KEY (`id`),
  ADD KEY `username` (`username_com`,`date`);

ALTER TABLE `tb_operations`
  ADD UNIQUE KEY `id` (`id`),
  ADD KEY `type` (`type`,`user`),
  ADD KEY `user` (`user`),
  ADD KEY `date` (`date`),
  ADD KEY `tip` (`tip`);

ALTER TABLE `tb_pay_stat`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `tb_ref_rass`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id` (`id`,`user`);

ALTER TABLE `tb_stat_refbirj`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `tb_support_tik`
  ADD PRIMARY KEY (`id`),
  ADD KEY `moder` (`moder`),
  ADD KEY `email` (`email`),
  ADD KEY `readea` (`readea`),
  ADD KEY `status` (`status`),
  ADD KEY `category` (`category`),
  ADD KEY `date` (`date`),
  ADD KEY `Important` (`important`);

ALTER TABLE `tb_support_tiks`
  ADD PRIMARY KEY (`id`),
  ADD KEY `wmid` (`email`),
  ADD KEY `date` (`date`),
  ADD KEY `email` (`email`);

ALTER TABLE `tb_task_bl`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user` (`user`),
  ADD KEY `user_z` (`user_z`),
  ADD KEY `id_task` (`id_task`),
  ADD KEY `id_user` (`id_user`,`id_z`),
  ADD KEY `id_z` (`id_z`);

ALTER TABLE `tb_task_i`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_task` (`id_task`,`user`),
  ADD KEY `id_user` (`id_user`);

ALTER TABLE `tb_task_m`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_task` (`id_task`,`id_user`),
  ADD KEY `id_user` (`id_user`);

ALTER TABLE `tb_task_otziv`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user` (`user`),
  ADD KEY `id_task` (`id_task`);

ALTER TABLE `tb_task_r`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_task` (`id_task`),
  ADD KEY `user` (`user`),
  ADD KEY `author` (`author`),
  ADD KEY `id_user` (`id_user`),
  ADD KEY `status` (`status`);

ALTER TABLE `tb_task_s`
  ADD PRIMARY KEY (`id`),
  ADD KEY `author` (`author`),
  ADD KEY `id_task` (`id_task`);

ALTER TABLE `tb_wall_coment`
  ADD PRIMARY KEY (`id`),
  ADD KEY `username` (`username`,`username_com`,`date`),
  ADD KEY `username_id` (`username_id`),
  ADD KEY `status_komment` (`status_komment`),
  ADD KEY `status_komment_2` (`status_komment`),
  ADD KEY `ocenka` (`ocenka`),
  ADD KEY `ocenka_2` (`ocenka`),
  ADD KEY `ocenka_3` (`ocenka`),
  ADD KEY `ocenka_4` (`ocenka`);


ALTER TABLE `ads_abuse`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `regmonitor`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `still_autoclik`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `still_block_earnings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `still_block_reklam`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `still_block_white`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `still_chain`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `still_chat`
  MODIFY `id` mediumint(8) NOT NULL AUTO_INCREMENT;

ALTER TABLE `still_chat_block`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `still_competition`
  MODIFY `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT;

ALTER TABLE `still_competition_data`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `still_day_stata`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `still_faq_categ`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `still_faq_help`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `still_friends`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `still_gift_cat`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

ALTER TABLE `still_gift_img`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

ALTER TABLE `still_gift_users`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `still_goodref`
  MODIFY `id` mediumint(8) NOT NULL AUTO_INCREMENT;

ALTER TABLE `still_mail`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `still_mail_mess`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `still_moder_bonus`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `still_moder_history`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `still_moder_mess`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `still_moder_reklama`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `still_note`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `still_perfect_id`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `still_ref_bonus`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `still_ref_koncurs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `still_rutube_abuse`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `still_rutube_ads`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `still_rutube_ads_user`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `still_shoot`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `still_socialseti`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `still_support_mess`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `still_support_moder`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `still_support_setup`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `still_task_abuse`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `still_test_bl`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `still_test_i`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `still_test_m`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `still_test_r`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `still_test_status`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `still_vk_abuse`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `still_vk_bl`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `still_vk_delprofil`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `still_vk_groups`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `still_vk_groups_user`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `still_vk_likes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `still_vk_likes_user`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `still_vk_profil`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `still_vk_repost`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `still_vk_repost_user`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `still_youtube_abuse`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `still_youtube_ads`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `still_youtube_ads_user`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `still_youtube_bl`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `still_youtube_delprofil`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `still_youtube_like`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `still_youtube_like_user`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `still_youtube_podp`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `still_youtube_podp_user`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `tb_add_pay`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `tb_ads_banner`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `tb_ads_dlink`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `tb_ads_dlink_visits`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `tb_ads_fraim`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `tb_ads_mails`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `tb_ads_mails_visits`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `tb_ads_slinks`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `tb_ads_slinks_visits`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `tb_ads_txt`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `tb_articles`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

ALTER TABLE `tb_articles_coment`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

ALTER TABLE `tb_bansite`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `tb_banwmid`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `tb_desk`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `tb_desk_priz`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `tb_history`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `tb_messfornewref`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `tb_news`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;

ALTER TABLE `tb_news_coment`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `tb_operations`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `tb_pay_stat`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `tb_ref_rass`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `tb_stat_refbirj`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `tb_support_tik`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `tb_support_tiks`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `tb_task_bl`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `tb_task_i`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `tb_task_m`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `tb_task_otziv`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `tb_task_r`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `tb_task_s`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `tb_wall_coment`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

