-- phpMyAdmin SQL Dump
-- version 4.0.10.6
-- http://www.phpmyadmin.net
--
-- Хост: 127.0.0.1:3306
-- Время создания: Апр 24 2017 г., 01:25
-- Версия сервера: 5.1.73-community-log
-- Версия PHP: 5.3.29
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 */;
--
-- База данных: `skortes`
--
-- --------------------------------------------------------
--
-- Структура таблицы `7dig`
--
CREATE TABLE IF NOT EXISTS `7dig` (
`id` int(11) NOT NULL,
`who` text NOT NULL,
`text` text NOT NULL,
`status` text,
`parol` text NOT NULL,
`stoim` int(11) NOT NULL DEFAULT '0',
`ts` bigint(20) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `8dig`
--
CREATE TABLE IF NOT EXISTS `8dig` (
`id` int(11) NOT NULL,
`who` text NOT NULL,
`text` text NOT NULL,
`status` text,
`parol` text NOT NULL,
`stoim` int(11) NOT NULL DEFAULT '0',
`ts` bigint(20) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `9dig`
--
CREATE TABLE IF NOT EXISTS `9dig` (
`id` int(11) NOT NULL,
`who` text NOT NULL,
`text` text NOT NULL,
`status` text,
`parol` text NOT NULL,
`stoim` int(11) NOT NULL DEFAULT '0',
`ts` bigint(20) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `21`
--
CREATE TABLE IF NOT EXISTS `21` (
`id` int(11) NOT NULL,
`stavka` float DEFAULT NULL,
`time` int(11) DEFAULT NULL,
`status` tinyint(1) DEFAULT NULL,
`bankir` varchar(150) DEFAULT NULL,
`igrok` varchar(150) DEFAULT NULL,
`double` tinyint(1) DEFAULT NULL,
`login` varchar(40) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
-- --------------------------------------------------------
--
-- Структура таблицы `akcii`
--
CREATE TABLE IF NOT EXISTS `akcii` (
`id` int(11) unsigned NOT NULL,
`date` varchar(15) NOT NULL,
`news` text NOT NULL,
`comm` int(10) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `akcii_comment`
--
CREATE TABLE IF NOT EXISTS `akcii_comment` (
`id` int(11) unsigned NOT NULL,
`news_id` int(10) unsigned NOT NULL,
`user` varchar(55) NOT NULL,
`date` varchar(25) NOT NULL,
`text` text NOT NULL,
`ans` text NOT NULL,
`ansuser` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `auk3`
--
CREATE TABLE IF NOT EXISTS `auk3` (
`id` text,
`lastnik` text,
`lastkred` text,
`time` text,
`timeup` text,
`bank` text
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `aukd`
--
CREATE TABLE IF NOT EXISTS `aukd` (
`id` text,
`lastnik` text,
`lastkred` text,
`time` text,
`timeup` text,
`bank` text
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `aukmini`
--
CREATE TABLE IF NOT EXISTS `aukmini` (
`id` int(11) NOT NULL,
`stavki` text,
`ts` bigint(20) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `auk_stav3`
--
CREATE TABLE IF NOT EXISTS `auk_stav3` (
`id` int(11) NOT NULL,
`date` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`ktostavil` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`skolkostavil` text CHARACTER SET utf8 COLLATE utf8_unicode_ci
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
-- --------------------------------------------------------
--
-- Структура таблицы `auk_stavd`
--
CREATE TABLE IF NOT EXISTS `auk_stavd` (
`id` int(11) NOT NULL,
`date` text,
`ktostavil` text,
`skolkostavil` text
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `ban`
--
CREATE TABLE IF NOT EXISTS `ban` (
`reason` varchar(250) COLLATE utf8_bin NOT NULL,
`who` varchar(100) COLLATE utf8_bin NOT NULL,
`date` int(40) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- --------------------------------------------------------
--
-- Структура таблицы `baner`
--
CREATE TABLE IF NOT EXISTS `baner` (
`id` int(30) NOT NULL,
`naz` varchar(300) NOT NULL,
`urlimg` varchar(300) DEFAULT NULL,
`url` varchar(300) NOT NULL,
`time` text
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `cclub_act`
--
CREATE TABLE IF NOT EXISTS `cclub_act` (
`id` int(11) NOT NULL,
`text` text,
`do` text,
`us` text,
`ts` bigint(20) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `cclub_actia`
--
CREATE TABLE IF NOT EXISTS `cclub_actia` (
`id` int(11) NOT NULL,
`text` text CHARACTER SET utf8,
`tema` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`ts` bigint(20) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
-- --------------------------------------------------------
--
-- Структура таблицы `cclub_adm_chat`
--
CREATE TABLE IF NOT EXISTS `cclub_adm_chat` (
`id` int(11) NOT NULL,
`who` text,
`text` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`ts` bigint(20) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
-- --------------------------------------------------------
--
-- Структура таблицы `cclub_aneks`
--
CREATE TABLE IF NOT EXISTS `cclub_aneks` (
`id` int(11) NOT NULL,
`who` text,
`text` text,
`ts` bigint(20) DEFAULT NULL,
`ua` text
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `cclub_bkat`
--
CREATE TABLE IF NOT EXISTS `cclub_bkat` (
`id` int(11) NOT NULL,
`who` text CHARACTER SET utf8,
`text` text CHARACTER SET utf8,
`ts` bigint(20) DEFAULT NULL,
`ua` text CHARACTER SET utf8,
`moder` int(1) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
-- --------------------------------------------------------
--
-- Структура таблицы `cclub_captcha`
--
CREATE TABLE IF NOT EXISTS `cclub_captcha` (
`code` text,
`ua` text,
`ip` text,
`ts` bigint(20) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
-- --------------------------------------------------------
--
-- Структура таблицы `cclub_chat`
--
CREATE TABLE IF NOT EXISTS `cclub_chat` (
`id` int(11) NOT NULL,
`user` text,
`text` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`date` text,
`nastr` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`ans` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`ansuser` text
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
-- --------------------------------------------------------
--
-- Структура таблицы `cclub_clicks`
--
CREATE TABLE IF NOT EXISTS `cclub_clicks` (
`who` text,
`to` text,
`ts` bigint(20) DEFAULT NULL,
`id_user` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
-- --------------------------------------------------------
--
-- Структура таблицы `cclub_forums`
--
CREATE TABLE IF NOT EXISTS `cclub_forums` (
`id` int(5) NOT NULL,
`name` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`position` int(5) NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `cclub_icq`
--
CREATE TABLE IF NOT EXISTS `cclub_icq` (
`id` int(11) NOT NULL,
`who` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`text` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`answer` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`ts` bigint(20) DEFAULT NULL,
`ua` text CHARACTER SET utf8 COLLATE utf8_unicode_ci
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `cclub_kassa`
--
CREATE TABLE IF NOT EXISTS `cclub_kassa` (
`v_kasse` text NOT NULL,
`vsego_vivod` text NOT NULL,
`posl_summa` text NOT NULL,
`komu` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Касса клуба';
-- --------------------------------------------------------
--
-- Структура таблицы `cclub_kontrol`
--
CREATE TABLE IF NOT EXISTS `cclub_kontrol` (
`id` int(11) NOT NULL,
`id_user` text,
`url` text,
`nazv` text,
`credit` int(11) DEFAULT NULL,
`perehod` bigint(20) DEFAULT NULL,
`typeclick` int(11) NOT NULL,
`time` bigint(20) DEFAULT NULL,
`moder` int(11) NOT NULL,
`activ` int(3) NOT NULL DEFAULT '1',
`ban_prihin` varchar(255) NOT NULL,
`referer` bigint(20) NOT NULL,
`ref` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`modban` bigint(20) NOT NULL,
`modprihin` text CHARACTER SET utf8 COLLATE utf8_unicode_ci
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `cclub_kontrol_info`
--
CREATE TABLE IF NOT EXISTS `cclub_kontrol_info` (
`id` int(11) NOT NULL,
`url_id` int(11) NOT NULL,
`time` int(11) DEFAULT NULL,
`agent` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`ipp` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`surl` text CHARACTER SET utf8 COLLATE utf8_unicode_ci
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `cclub_lichka`
--
CREATE TABLE IF NOT EXISTS `cclub_lichka` (
`number` int(11) NOT NULL,
`loginot` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`loginto` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`date` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`tema` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`mess` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`status` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Дамп данных таблицы `cclub_lichka`
--
INSERT INTO `cclub_lichka` (`number`, `loginot`, `loginto`, `date`, `tema`, `mess`, `status`) VALUES
(0, 'admin', 'Admin', '', '', '<b>Admin</b> ', '2');
-- --------------------------------------------------------
--
-- Структура таблицы `cclub_lichkaout`
--
CREATE TABLE IF NOT EXISTS `cclub_lichkaout` (
`number` int(11) NOT NULL,
`loginot` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`loginto` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`date` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`tema` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`mess` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `cclub_logi_buy`
--
CREATE TABLE IF NOT EXISTS `cclub_logi_buy` (
`id` int(11) NOT NULL,
`who` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`ts` bigint(20) DEFAULT NULL,
`num` int(9) NOT NULL,
`pass` text,
`status` int(11) DEFAULT NULL,
`cena` int(9) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `cclub_log_kp`
--
CREATE TABLE IF NOT EXISTS `cclub_log_kp` (
`id` int(11) NOT NULL,
`kupil` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`prodal` text,
`kolvo` text,
`data` text,
`cena` text
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
-- --------------------------------------------------------
--
-- Структура таблицы `cclub_log_vhod`
--
CREATE TABLE IF NOT EXISTS `cclub_log_vhod` (
`id` int(11) NOT NULL,
`login` text,
`data` text,
`ip` text,
`arbuz` text,
`surl` text
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
--
-- Дамп данных таблицы `cclub_log_vhod`
--
INSERT INTO `cclub_log_vhod` (`id`, `login`, `data`, `ip`, `arbuz`, `surl`) VALUES
(0, 'Admin', '24.04.17 01:22:51', '127.0.0.1', 'Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.71 Safari/537.36', 'http://skortes.ru/reg.php?mode=ok');
-- --------------------------------------------------------
--
-- Структура таблицы `cclub_mes`
--
CREATE TABLE IF NOT EXISTS `cclub_mes` (
`id_mes` int(255) NOT NULL,
`login` text NOT NULL,
`date` varchar(40) NOT NULL DEFAULT '',
`id_th` int(255) NOT NULL DEFAULT '0',
`id_kat` int(255) NOT NULL DEFAULT '0',
`text` text CHARACTER SET utf8,
`time` int(255) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
-- --------------------------------------------------------
--
-- Структура таблицы `cclub_moderka`
--
CREATE TABLE IF NOT EXISTS `cclub_moderka` (
`id` int(11) NOT NULL,
`mod` text COLLATE utf8_unicode_ci NOT NULL,
`ml` float NOT NULL,
`login` text COLLATE utf8_unicode_ci NOT NULL,
`ts` bigint(20) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Структура таблицы `cclub_money_in`
--
CREATE TABLE IF NOT EXISTS `cclub_money_in` (
`id` int(11) NOT NULL,
`login` text,
`time` text,
`summa` text,
`admin` text
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
-- --------------------------------------------------------
--
-- Структура таблицы `cclub_money_in_otmena`
--
CREATE TABLE IF NOT EXISTS `cclub_money_in_otmena` (
`id` int(11) NOT NULL,
`login` text,
`time` bigint(20) DEFAULT NULL,
`kred` text
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
-- --------------------------------------------------------
--
-- Структура таблицы `cclub_money_in_zakaz`
--
CREATE TABLE IF NOT EXISTS `cclub_money_in_zakaz` (
`id` int(11) NOT NULL,
`login` text,
`time` bigint(20) DEFAULT NULL,
`summa` text
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
-- --------------------------------------------------------
--
-- Структура таблицы `cclub_money_out`
--
CREATE TABLE IF NOT EXISTS `cclub_money_out` (
`id` int(11) NOT NULL,
`login` text,
`time` bigint(20) DEFAULT NULL,
`summa` text,
`admin` text
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
-- --------------------------------------------------------
--
-- Структура таблицы `cclub_money_out_otmena`
--
CREATE TABLE IF NOT EXISTS `cclub_money_out_otmena` (
`id` int(11) NOT NULL,
`login` text,
`time` bigint(20) DEFAULT NULL,
`kred` text
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
-- --------------------------------------------------------
--
-- Структура таблицы `cclub_nastr`
--
CREATE TABLE IF NOT EXISTS `cclub_nastr` (
`id` int(11) NOT NULL,
`bankf` int(11) DEFAULT '0',
`outv` int(11) DEFAULT '0',
`prokliks` int(11) DEFAULT '0',
`pls` int(11) DEFAULT '0',
`refp` float(11,2) DEFAULT '0.00',
`bonus` int(11) DEFAULT '0',
`krek` int(11) DEFAULT '0',
`moneys` float(11,3) DEFAULT '0.000',
`kbir` int(11) DEFAULT '0',
`cbir` float(11,3) DEFAULT '0.000',
`canek` int(11) DEFAULT '0',
`cfor` int(11) DEFAULT '0',
`zchat` int(11) DEFAULT '0',
`strass` int(11) DEFAULT '0',
`rekverh` int(11) DEFAULT '0',
`rekniz` int(11) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `cclub_news`
--
CREATE TABLE IF NOT EXISTS `cclub_news` (
`id` int(11) NOT NULL,
`text` text CHARACTER SET utf8,
`tema` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`ts` bigint(20) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
-- --------------------------------------------------------
--
-- Структура таблицы `cclub_onas`
--
CREATE TABLE IF NOT EXISTS `cclub_onas` (
`id` int(11) NOT NULL,
`who` text,
`text` text,
`ts` bigint(20) DEFAULT NULL,
`ua` text
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `cclub_perevod`
--
CREATE TABLE IF NOT EXISTS `cclub_perevod` (
`id` int(11) NOT NULL,
`otkogo` text,
`komy` text,
`skolko` text
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `cclub_posts`
--
CREATE TABLE IF NOT EXISTS `cclub_posts` (
`id` int(7) NOT NULL,
`id_theme` int(5) NOT NULL,
`id_forum` int(3) NOT NULL,
`login` text,
`text` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`time` text,
`izmts` bigint(20) NOT NULL,
`izmkol` int(3) NOT NULL DEFAULT '0',
`izmwho` text
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `cclub_shinfo`
--
CREATE TABLE IF NOT EXISTS `cclub_shinfo` (
`id` int(11) NOT NULL,
`login` text,
`icq` text,
`data` text,
`msg` text
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `cclub_stats`
--
CREATE TABLE IF NOT EXISTS `cclub_stats` (
`who` varchar(60) NOT NULL,
`cn` smallint(6) unsigned NOT NULL,
`ts` date NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `cclub_text`
--
CREATE TABLE IF NOT EXISTS `cclub_text` (
`uid` text NOT NULL,
`ref` text NOT NULL,
`ip` text NOT NULL,
`agent` text NOT NULL,
`day` text NOT NULL,
`min` text NOT NULL,
`url` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
-- --------------------------------------------------------
--
-- Структура таблицы `cclub_themes`
--
CREATE TABLE IF NOT EXISTS `cclub_themes` (
`id` int(5) NOT NULL,
`id_forum` int(5) NOT NULL,
`name` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`login` text,
`time` text,
`last_time` text NOT NULL,
`type` text
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `cclub_transfers`
--
CREATE TABLE IF NOT EXISTS `cclub_transfers` (
`from` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`to` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`ts` bigint(20) DEFAULT NULL,
`sum` mediumint(9) NOT NULL,
`komm` text COLLATE utf8_unicode_ci
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Структура таблицы `cclub_url`
--
CREATE TABLE IF NOT EXISTS `cclub_url` (
`id` int(11) NOT NULL,
`id_user` text,
`url` text,
`nazv` text,
`credit` int(11) DEFAULT NULL,
`perehod` bigint(20) DEFAULT NULL,
`typeclick` int(11) NOT NULL,
`time` bigint(20) DEFAULT NULL,
`moder` int(11) NOT NULL,
`activ` int(3) NOT NULL DEFAULT '1',
`ban_prihin` varchar(255) NOT NULL,
`referer` bigint(20) NOT NULL,
`ref` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`modban` bigint(20) NOT NULL,
`modprihin` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`tip` int(1) DEFAULT NULL,
`premium` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `cclub_users`
--
CREATE TABLE IF NOT EXISTS `cclub_users` (
`nazv` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`id` int(11) NOT NULL,
`login` text,
`city` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`name` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`password` text,
`url` text,
`mail` text,
`ts` bigint(20) DEFAULT NULL,
`cto` double DEFAULT NULL,
`cfrom` double DEFAULT NULL,
`ip` text,
`ua` text,
`ets` bigint(20) DEFAULT '0',
`admin` tinyint(4) DEFAULT '0',
`moder` tinyint(4) DEFAULT '0',
`typeclick` int(11) DEFAULT '0',
`pid` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`bank` float NOT NULL DEFAULT '0',
`time` bigint(20) NOT NULL DEFAULT '0',
`mesto` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`online` int(11) NOT NULL,
`pol` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`icq` int(11) NOT NULL DEFAULT '0',
`inf` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`many` bigint(20) DEFAULT NULL,
`wmid` bigint(20) DEFAULT NULL,
`enter` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`enterip` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`enterb` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`enterdata` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`turl` text NOT NULL,
`tkr` text NOT NULL,
`style` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`imja` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`gorod` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`wm` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`osebe` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`java` int(1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
--
-- Дамп данных таблицы `cclub_users`
--
INSERT INTO `cclub_users` (`nazv`, `id`, `login`, `city`, `name`, `password`, `url`, `mail`, `ts`, `cto`, `cfrom`, `ip`, `ua`, `ets`, `admin`, `moder`, `typeclick`, `pid`, `bank`, `time`, `mesto`, `online`, `pol`, `icq`, `inf`, `many`, `wmid`, `enter`, `enterip`, `enterb`, `enterdata`, `turl`, `tkr`, `style`, `imja`, `gorod`, `wm`, `osebe`, `java`) VALUES
(NULL, 0, 'Admin', NULL, NULL, 'e10adc3949ba59abbe56e057f20f883e', NULL, 'fsb@fsb26.ru', 1492986168, 0, 0, '127.0.0.1', 'Mozilla', 0, 0, 0, 0, '', 0, 0, '', 1492986191, '', 0, NULL, 0, 0, 'Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.71 Safari/537.36', '127.0.0.1', '', '24.04.17 01:22:51', '', '', NULL, NULL, NULL, NULL, NULL, 0);
-- --------------------------------------------------------
--
-- Структура таблицы `cclub_workm`
--
CREATE TABLE IF NOT EXISTS `cclub_workm` (
`id` int(11) NOT NULL,
`ts` bigint(20) NOT NULL,
`log` text COLLATE utf8_unicode_ci,
`log2` text COLLATE utf8_unicode_ci
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Структура таблицы `cclub_zadanie`
--
CREATE TABLE IF NOT EXISTS `cclub_zadanie` (
`id` int(11) NOT NULL,
`login` text,
`name` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`text` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`purse` text NOT NULL,
`life` text NOT NULL,
`life2` text NOT NULL,
`time_on` text NOT NULL,
`status` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `cclub_zmsg`
--
CREATE TABLE IF NOT EXISTS `cclub_zmsg` (
`id` int(11) NOT NULL,
`id_zadanie` text NOT NULL,
`login` text,
`text` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`date` text
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
-- --------------------------------------------------------
--
-- Структура таблицы `counters`
--
CREATE TABLE IF NOT EXISTS `counters` (
`id` int(30) NOT NULL,
`naz` varchar(300) NOT NULL,
`urlimg` varchar(300) DEFAULT NULL,
`url` varchar(300) NOT NULL,
`time` text
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Дамп данных таблицы `counters`
--
INSERT INTO `counters` (`id`, `naz`, `urlimg`, `url`, `time`) VALUES
(1, 'Statok.net', 'http://statok.net/image/8166', 'http://statok.net/go/8166', '1424645777'),
(26, 'top.h2m.name', 'http://top.h2m.name/image/176', 'http://top.h2m.name/go/176', '1430600550'),
(38, 'upstat.ru', 'http://upstat.ru/image/63', 'http://upstat.ru/go/63', '1432189676');
-- --------------------------------------------------------
--
-- Структура таблицы `editpass`
--
CREATE TABLE IF NOT EXISTS `editpass` (
`id` int(9) NOT NULL,
`login` text,
`kodaktiv` text,
`time` text
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
-- --------------------------------------------------------
--
-- Структура таблицы `icqm`
--
CREATE TABLE IF NOT EXISTS `icqm` (
`id` int(11) NOT NULL,
`who` text NOT NULL,
`text` text NOT NULL,
`parol` text NOT NULL,
`stoim` int(11) NOT NULL DEFAULT '0',
`ts` bigint(20) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `logmod`
--
CREATE TABLE IF NOT EXISTS `logmod` (
`id` int(11) NOT NULL,
`login` text,
`oper` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`time` text
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
-- --------------------------------------------------------
--
-- Структура таблицы `lotoreya`
--
CREATE TABLE IF NOT EXISTS `lotoreya` (
`id` int(11) NOT NULL,
`rozygrash` int(11) NOT NULL,
`nomer` int(11) NOT NULL,
`who` text CHARACTER SET utf8 NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
-- --------------------------------------------------------
--
-- Структура таблицы `lotoreya_nastr`
--
CREATE TABLE IF NOT EXISTS `lotoreya_nastr` (
`id` int(11) NOT NULL,
`num` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
-- --------------------------------------------------------
--
-- Структура таблицы `lotoreya_num`
--
CREATE TABLE IF NOT EXISTS `lotoreya_num` (
`rozygrash` int(11) NOT NULL,
`priz` int(11) NOT NULL,
`vsego_biletov` int(11) NOT NULL,
`cena_bileta` float NOT NULL,
`ok` int(11) NOT NULL,
`who` text CHARACTER SET utf8 NOT NULL,
`nomer` int(11) NOT NULL,
`zapis` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
-- --------------------------------------------------------
--
-- Структура таблицы `mrek`
--
CREATE TABLE IF NOT EXISTS `mrek` (
`id` int(11) NOT NULL,
`link` text,
`nlink` text,
`date` int(40) DEFAULT NULL,
`who` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`login` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `nastroyki`
--
CREATE TABLE IF NOT EXISTS `nastroyki` (
`id` int(11) NOT NULL,
`ref_pr` text,
`bonus` text NOT NULL,
`copi` text NOT NULL,
`kosh` text NOT NULL,
`ploshadki` text NOT NULL,
`minimalka` varchar(15) NOT NULL,
`commission` float(11,2) NOT NULL DEFAULT '0.00',
`strass` int(11) NOT NULL DEFAULT '0',
`proclick` text NOT NULL,
`bank_min_aktiv` text NOT NULL,
`oplata` enum('0','1') NOT NULL DEFAULT '0',
`cena` float(11,3) NOT NULL,
`acena` float(11,3) NOT NULL DEFAULT '0.000',
`mp` float NOT NULL DEFAULT '0',
`min_k` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
-- --------------------------------------------------------
--
-- Структура таблицы `news_comment`
--
CREATE TABLE IF NOT EXISTS `news_comment` (
`id` int(11) unsigned NOT NULL,
`news_id` int(10) unsigned NOT NULL,
`user` varchar(55) NOT NULL,
`date` varchar(25) NOT NULL,
`text` text NOT NULL,
`ans` text NOT NULL,
`ansuser` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `news_news`
--
CREATE TABLE IF NOT EXISTS `news_news` (
`id` int(11) unsigned NOT NULL,
`date` varchar(15) NOT NULL,
`news` text NOT NULL,
`comm` int(10) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `nizrek`
--
CREATE TABLE IF NOT EXISTS `nizrek` (
`id` int(11) NOT NULL,
`link` text,
`nlink` text,
`date` int(40) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `online`
--
CREATE TABLE IF NOT EXISTS `online` (
`id` int(10) NOT NULL,
`ip` varchar(40) DEFAULT '0',
`time` varchar(90) DEFAULT NULL,
`ua` varchar(80) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0;
-- --------------------------------------------------------
--
-- Структура таблицы `perevod`
--
CREATE TABLE IF NOT EXISTS `perevod` (
`sid` int(11) NOT NULL,
`from` text NOT NULL,
`to` text NOT NULL,
`kredit` int(11) NOT NULL DEFAULT '0',
`time` text NOT NULL,
`komm` text
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `rassilka`
--
CREATE TABLE IF NOT EXISTS `rassilka` (
`id` int(11) NOT NULL,
`login` text,
`tema` text,
`text` text,
`summa` int(11) DEFAULT '0',
`date` int(40) DEFAULT NULL,
`status` int(11) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Дамп данных таблицы `rassilka`
--
INSERT INTO `rassilka` (`id`, `login`, `tema`, `text`, `summa`, `date`, `status`) VALUES
(4, 'HELL', 'Ìàññîâàÿ ðàññûëêà!', 'Ïðèâåò! Äîáàâëÿé ñâîé ñàéò â òîï ðåéòèíã http://xsou.ru áóäó î÷åíü áëàãîäàðåí)\r\n\r\nÒîï õîòü è òîëüêî îòêðûëñÿ, íî áóäåò íàáèðàòü îáîðîòû è áóäåòå ïîëó÷àòü î÷åíü õîðîøóþ îòäà÷ó!\r\n\r\nÇà ðàíèå áîëüøîå ñïàñèáî! Ñ Óâ. Àëåêñàíäð! sven36@ukr.net', 5, 1425484566, 0),
(5, 'Zed', 'Ìàññîâàÿ ðàññûëêà!', 'Âñåì çäðàâñòâóéòå çàõîäèòå íà íîâóþ Wap ìàñòåðñêóþ http://wm.anisub.ru \r\nÇäåñü òåáå ïîìîãóò ñîçäàòü ñâîé ñàéò\r\nÈñïðàâèòü îøèáêè \r\nÒàê æå íàïèøóò ìîäóëè è øàáëîí \r\nÐåãèñòðèðóéñÿ è ïèøè íà ôîðóìå :)', 5, 1425688491, 0),
(7, '2121992', 'Ìàññîâàÿ ðàññûëêà!', 'Çäðàâñòâóéòå! õî÷ó ïðåäëîæûòü çàíÿòñÿ êðåäèòèðóâàíèåì è ñòàòü ìîèì ïàðòíåðîì íà ñàéòå êðåäèòèðóâàíèÿ! ÿ è ìîé ñòàðøûé ïàðòíåð óñïåøíî ðàáîòàåì â ýòîé ñôåðå. ìîé ñòàðøûé ïàðòíåð óæå çàðàáàòóåò íà ñàéòå 120 ýòî áåç ëè÷íûõ âëîæåíèé! ðàáîòàÿ òàì îêîëî òðåõ ìåñÿöîâ! íè÷åãî ñëîæíîãî íåò, äàåø êðåäèòû ïîä ïðîöåíòû â äîëëàðàõ ÑØÀ è ïîëó÷àåøü ïðîöåíòû!! êîìó èíòåðåñíî îáðàùàéòåñü â ëè÷êó! https://webtransfer-finance.com/ru/?id_partner=46984444', 5, 1428942969, 0),
(9, 'san4ik', 'Ìàññîâàÿ ðàññûëêà!', 'Âñåõ ëþáèòåëåé ïîðíî ïðèãëàøàþ íà http://san4ik.ru', 5, 1430463187, 0),
(12, 'Froll5551', 'Ìàññîâàÿ ðàññûëêà!', 'Ïðèãëîøàþ âñåõ â ñâîé êëóá. white-club.tk', 2, 1432591357, 0),
(13, 'san4ik', 'Ìàññîâàÿ ðàññûëêà!', 'Áåëûé êàòàëîã ñàéòîâ-îáðàòíàÿ ññûëêà íå íóæíà http://top.san4ik.ru -ðåãèñòðèðóéòåñü', 2, 1433067273, 0);
-- --------------------------------------------------------
--
-- Структура таблицы `refb`
--
CREATE TABLE IF NOT EXISTS `refb` (
`id` int(11) NOT NULL,
`login` text,
`prcen` bigint(20) DEFAULT NULL,
`realcen` bigint(20) DEFAULT NULL,
`ids` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`ts` bigint(20) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `referer`
--
CREATE TABLE IF NOT EXISTS `referer` (
`url` varchar(100) NOT NULL,
`hits` int(10) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `rek`
--
CREATE TABLE IF NOT EXISTS `rek` (
`url` text,
`nazv` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`id` int(11) NOT NULL,
`cvet` text,
`srok` int(11) DEFAULT NULL,
`b` text,
`mesto` int(11) DEFAULT NULL,
`perehodov` int(11) NOT NULL,
`kk` int(1) DEFAULT NULL,
`oplata` int(1) DEFAULT NULL,
`srokd` int(3) DEFAULT NULL,
`login` text,
`balans` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
-- --------------------------------------------------------
--
-- Структура таблицы `sovpvhod`
--
CREATE TABLE IF NOT EXISTS `sovpvhod` (
`id` int(11) NOT NULL,
`hz` text,
`time` text
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `stavki`
--
CREATE TABLE IF NOT EXISTS `stavki` (
`id` int(11) NOT NULL,
`kr` int(11) DEFAULT '0',
`pr` float(11,4) DEFAULT '0.0000',
`nick` tinytext,
`time` tinytext
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `urlk`
--
CREATE TABLE IF NOT EXISTS `urlk` (
`id` int(30) NOT NULL,
`login` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`naz` varchar(300) NOT NULL,
`url` varchar(300) NOT NULL,
`time` text
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `users`
--
CREATE TABLE IF NOT EXISTS `users` (
`id` int(10) unsigned NOT NULL COMMENT 'Ид',
`nick` tinytext,
`money` float(11,3) DEFAULT '0.000',
`in_money` int(11) DEFAULT '0',
`out_money` double unsigned DEFAULT '0',
`wmr` tinytext,
`wmid` varchar(20) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Дамп данных таблицы `users`
--
INSERT INTO `users` (`id`, `nick`, `money`, `in_money`, `out_money`, `wmr`, `wmid`) VALUES
(0, 'Admin', 0.000, 0, 0, '0', NULL);
-- --------------------------------------------------------
--
-- Структура таблицы `verhrek`
--
CREATE TABLE IF NOT EXISTS `verhrek` (
`id` int(11) NOT NULL,
`link` text,
`nlink` text,
`date` int(40) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `wins3`
--
CREATE TABLE IF NOT EXISTS `wins3` (
`login` text,
`kred` text,
`time` text
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `winsd`
--
CREATE TABLE IF NOT EXISTS `winsd` (
`login` text,
`kred` text,
`time` text
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `worldkassa`
--
CREATE TABLE IF NOT EXISTS `worldkassa` (
`id` int(11) unsigned NOT NULL COMMENT 'ID платежа (Внутренний ID)',
`id_user` int(11) unsigned NOT NULL COMMENT 'ID пользователя',
`id_bill` int(11) unsigned NOT NULL COMMENT 'ID платежа в Worldkassa',
`time` int(11) unsigned NOT NULL COMMENT 'Время инициализации платежа',
`time_oplata` int(11) unsigned DEFAULT '0' COMMENT 'Время оплаты',
`summa` decimal(11,2) NOT NULL DEFAULT '0.00' COMMENT 'Сумма'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Статистика платежей через WorldKassa';
/*!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 */;