Файл: baza_dannih.sql
Строк: 429
-- phpMyAdmin SQL Dump
-- version 3.5.3
-- http://www.phpmyadmin.net
--
--
Хост: localhost
-- Время создания: Июл 13 2013 г.,
17:16
-- Версия сервера: 5.5.29
-- Версия PHP:
5.3.23
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 */;
--
-- База данных: `clubec`
--
--
--------------------------------------------------------
--
--
Структура таблицы `ac_com`
--
CREATE TABLE IF NOT EXISTS
`ac_com` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`nid` int(11) NOT NULL
DEFAULT '0',
`date` text NOT NULL,
`login` text NOT NULL,
`text` text
NOT NULL,
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `akcii`
--
CREATE TABLE IF NOT EXISTS
`akcii` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`date`
varchar(15) NOT NULL,
`news` text NOT NULL,
`comm` int(10) unsigned NOT
NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=9 ;
--
--------------------------------------------------------
--
--
Структура таблицы `akcii_comment`
--
CREATE TABLE IF NOT
EXISTS `akcii_comment` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`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,
PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
--
--------------------------------------------------------
--
--
Структура таблицы `auk`
--
CREATE TABLE IF NOT EXISTS
`auk` (
`id` text,
`lastnik` text,
`lastkred` text,
`time` text,
`timeup` text,
`bank` text
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
--------------------------------------------------------
--
--
Структура таблицы `auk1`
--
CREATE TABLE IF NOT EXISTS
`auk1` (
`id` text,
`lastnik` text,
`lastkred` text,
`time` text,
`timeup` text,
`bank` text
) 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;
--
--------------------------------------------------------
--
--
Структура таблицы `auk24`
--
CREATE TABLE IF NOT EXISTS
`auk24` (
`id` text,
`lastnik` text,
`lastkred` text,
`time` text,
`timeup` text,
`bank` text
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
--------------------------------------------------------
--
--
Структура таблицы `auk48`
--
CREATE TABLE IF NOT EXISTS
`auk48` (
`id` text,
`lastnik` text,
`lastkred` text,
`time` text,
`timeup` text,
`bank` text
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
--------------------------------------------------------
--
--
Структура таблицы `auk72`
--
CREATE TABLE IF NOT EXISTS
`auk72` (
`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 AUTO_INCREMENT,
`stavki` text,
`ts`
bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=374 ;
--
--------------------------------------------------------
--
--
Структура таблицы `auk_stav`
--
CREATE TABLE IF NOT EXISTS
`auk_stav` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`date` text,
`ktostavil` text,
`skolkostavil` text,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=44 ;
--
--------------------------------------------------------
--
--
Структура таблицы `auk_stav1`
--
CREATE TABLE IF NOT
EXISTS `auk_stav1` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`date`
text,
`ktostavil` text,
`skolkostavil` text,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=391 ;
--
--------------------------------------------------------
--
--
Структура таблицы `auk_stav3`
--
CREATE TABLE IF NOT
EXISTS `auk_stav3` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`date`
text,
`ktostavil` text,
`skolkostavil` text,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=73 ;
--
--------------------------------------------------------
--
--
Структура таблицы `auk_stav24`
--
CREATE TABLE IF NOT
EXISTS `auk_stav24` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`date`
text,
`ktostavil` text,
`skolkostavil` text,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
--
--------------------------------------------------------
--
--
Структура таблицы `auk_stav48`
--
CREATE TABLE IF NOT
EXISTS `auk_stav48` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`date`
text,
`ktostavil` text,
`skolkostavil` text,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
--
--------------------------------------------------------
--
--
Структура таблицы `auk_stav72`
--
CREATE TABLE IF NOT
EXISTS `auk_stav72` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`date`
text,
`ktostavil` text,
`skolkostavil` text,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
--
--------------------------------------------------------
--
--
Структура таблицы `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;
--
--------------------------------------------------------
--
--
Структура таблицы `cclub_act`
--
CREATE TABLE IF NOT
EXISTS `cclub_act` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`text`
text,
`do` text,
`us` text,
`ts` bigint(20) DEFAULT NULL,
PRIMARY
KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=19 ;
--
--------------------------------------------------------
--
--
Структура таблицы `cclub_actia`
--
CREATE TABLE IF NOT
EXISTS `cclub_actia` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`text`
text,
`tema` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`ts`
bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=71 ;
--
--------------------------------------------------------
--
--
Структура таблицы `cclub_adm_chat`
--
CREATE TABLE IF NOT
EXISTS `cclub_adm_chat` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`who`
text,
`text` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`ts`
bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=5001 ;
--
--------------------------------------------------------
--
--
Структура таблицы `cclub_adsmail`
--
CREATE TABLE IF NOT
EXISTS `cclub_adsmail` (
`number` int(11) NOT NULL AUTO_INCREMENT,
`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,
PRIMARY KEY
(`number`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=824 ;
--
--------------------------------------------------------
--
--
Структура таблицы `cclub_bkat`
--
CREATE TABLE IF NOT
EXISTS `cclub_bkat` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`who`
text,
`text` text,
`ts` bigint(20) DEFAULT NULL,
`ua` text,
`moder`
int(1) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=425 ;
--
--------------------------------------------------------
--
--
Структура таблицы `cclub_captcha`
--
CREATE TABLE IF NOT
EXISTS `cclub_captcha` (
`code` text,
`ua` text,
`ip` text,
`ts`
bigint(20) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
--------------------------------------------------------
--
--
Структура таблицы `cclub_chat`
--
CREATE TABLE IF NOT
EXISTS `cclub_chat` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user`
text,
`text` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`date`
text,
`nastr` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`ans`
text,
`ansuser` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=17012 ;
--
--------------------------------------------------------
--
--
Структура таблицы `cclub_clicks`
--
CREATE TABLE IF NOT
EXISTS `cclub_clicks` (
`who` text,
`to` text,
`ts` bigint(20)
DEFAULT NULL,
`id_user` int(11) NOT NULL,
`ip` text NOT NULL,
`ua`
tinytext NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
--------------------------------------------------------
--
--
Структура таблицы `cclub_icq`
--
CREATE TABLE IF NOT
EXISTS `cclub_icq` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`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,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `cclub_lichka`
--
CREATE TABLE IF NOT
EXISTS `cclub_lichka` (
`number` int(11) NOT NULL AUTO_INCREMENT,
`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,
PRIMARY KEY
(`number`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1232 ;
--
--------------------------------------------------------
--
--
Структура таблицы `cclub_lichkaout`
--
CREATE TABLE IF NOT
EXISTS `cclub_lichkaout` (
`number` int(11) NOT NULL AUTO_INCREMENT,
`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,
PRIMARY KEY
(`number`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=573 ;
--
--------------------------------------------------------
--
--
Структура таблицы `cclub_logi_buy`
--
CREATE TABLE IF NOT
EXISTS `cclub_logi_buy` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`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,
KEY `id` (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=526 ;
--
--------------------------------------------------------
--
--
Структура таблицы `cclub_log_kp`
--
CREATE TABLE IF NOT
EXISTS `cclub_log_kp` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`kupil`
text,
`prodal` text,
`kolvo` text,
`data` text,
`cena` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1736 ;
--
--------------------------------------------------------
--
--
Структура таблицы `cclub_log_vhod`
--
CREATE TABLE IF NOT
EXISTS `cclub_log_vhod` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`login`
text,
`data` text,
`ip` text,
`arbuz` text,
`surl` text,
PRIMARY
KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=106155
;
-- --------------------------------------------------------
--
--
Структура таблицы `cclub_mes`
--
CREATE TABLE IF NOT
EXISTS `cclub_mes` (
`id_mes` int(255) NOT NULL AUTO_INCREMENT,
`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,
`time` int(255) NOT NULL DEFAULT '0',
PRIMARY KEY (`id_mes`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `cclub_moderka`
--
CREATE TABLE IF NOT
EXISTS `cclub_moderka` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`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,
KEY
`id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
AUTO_INCREMENT=49 ;
--
--------------------------------------------------------
--
--
Структура таблицы `cclub_money_in`
--
CREATE TABLE IF NOT
EXISTS `cclub_money_in` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`login`
text,
`time` text,
`summa` text,
`admin` text,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=172 ;
--
--------------------------------------------------------
--
--
Структура таблицы `cclub_money_in_otmena`
--
CREATE TABLE
IF NOT EXISTS `cclub_money_in_otmena` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`login` text,
`time` bigint(20) DEFAULT NULL,
`kred`
text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=39 ;
--
--------------------------------------------------------
--
--
Структура таблицы `cclub_money_in_zakaz`
--
CREATE TABLE
IF NOT EXISTS `cclub_money_in_zakaz` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`login` text,
`time` bigint(20) DEFAULT NULL,
`summa`
text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=296 ;
--
--------------------------------------------------------
--
--
Структура таблицы `cclub_money_out`
--
CREATE TABLE IF NOT
EXISTS `cclub_money_out` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`login` text,
`time` bigint(20) DEFAULT NULL,
`summa` text,
`admin`
text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=531 ;
--
--------------------------------------------------------
--
--
Структура таблицы `cclub_money_out_otmena`
--
CREATE TABLE
IF NOT EXISTS `cclub_money_out_otmena` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`login` text,
`time` bigint(20) DEFAULT NULL,
`kred`
text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=31 ;
--
--------------------------------------------------------
--
--
Структура таблицы `cclub_news`
--
CREATE TABLE IF NOT
EXISTS `cclub_news` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`text`
text,
`tema` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`ts`
bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=139 ;
--
--------------------------------------------------------
--
--
Структура таблицы `cclub_perevod`
--
CREATE TABLE IF NOT
EXISTS `cclub_perevod` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`otkogo`
text,
`komy` text,
`skolko` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
--
--------------------------------------------------------
--
--
Структура таблицы `cclub_posts`
--
CREATE TABLE IF NOT
EXISTS `cclub_posts` (
`id` int(7) NOT NULL AUTO_INCREMENT,
`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,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=328 ;
--
--------------------------------------------------------
--
--
Структура таблицы `cclub_shinfo`
--
CREATE TABLE IF NOT
EXISTS `cclub_shinfo` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`login`
text,
`icq` text,
`data` text,
`msg` text,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `cclub_system_chat`
--
CREATE TABLE IF
NOT EXISTS `cclub_system_chat` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`who` text,
`text` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`ts` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1537 ;
--
--------------------------------------------------------
--
--
Структура таблицы `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=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 AUTO_INCREMENT,
`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,
`autos` int(1) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=11409 ;
--
--------------------------------------------------------
--
--
Структура таблицы `cclub_url_ban`
--
CREATE TABLE IF NOT
EXISTS `cclub_url_ban` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`who`
varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`url_id`
varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`date` int(40)
NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=48 ;
--
--------------------------------------------------------
--
--
Структура таблицы `cclub_users`
--
CREATE TABLE IF NOT
EXISTS `cclub_users` (
`nazv` text CHARACTER SET utf8 COLLATE
utf8_unicode_ci,
`id` int(11) NOT NULL AUTO_INCREMENT,
`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` bigint(20)
DEFAULT NULL,
`cfrom` float 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,
`pidcnt` int(10) 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,
`icq` int(11) DEFAULT NULL,
`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,
`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,
`activation` int(1) NOT NULL
DEFAULT '0',
`activoff` int(1) NOT NULL DEFAULT '0',
PRIMARY KEY
(`id`),
FULLTEXT KEY `city` (`city`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=5616 ;
--
--------------------------------------------------------
--
--
Структура таблицы `cclub_user_ban`
--
CREATE TABLE IF NOT
EXISTS `cclub_user_ban` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`who`
varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`to`
varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`date` int(40)
NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=8 ;
--
--------------------------------------------------------
--
--
Структура таблицы `cclub_workm`
--
CREATE TABLE IF NOT
EXISTS `cclub_workm` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`ts`
bigint(20) NOT NULL,
`log` text COLLATE utf8_unicode_ci,
`log2` text
COLLATE utf8_unicode_ci,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=468 ;
--
--------------------------------------------------------
--
--
Структура таблицы `cclub_zmsg`
--
CREATE TABLE IF NOT
EXISTS `cclub_zmsg` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_zadanie` text NOT NULL,
`login` text,
`text` text CHARACTER SET
utf8 COLLATE utf8_unicode_ci,
`date` text,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=336 ;
--
--------------------------------------------------------
--
--
Структура таблицы `editpass`
--
CREATE TABLE IF NOT EXISTS
`editpass` (
`id` int(9) NOT NULL AUTO_INCREMENT,
`login` text,
`kodaktiv` text,
`time` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=122 ;
--
--------------------------------------------------------
--
--
Структура таблицы `icqm`
--
CREATE TABLE IF NOT EXISTS
`icqm` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`who` text NOT NULL,
`text` text NOT NULL,
`parol` text NOT NULL,
`stoim` int(11) NOT NULL
DEFAULT '0',
`ts` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=59 ;
--
--------------------------------------------------------
--
--
Структура таблицы `logmod`
--
CREATE TABLE IF NOT EXISTS
`logmod` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`login` text,
`oper`
text,
`time` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=914 ;
--
--------------------------------------------------------
--
--
Структура таблицы `mlink`
--
CREATE TABLE IF NOT EXISTS
`mlink` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`link` text,
`nlink`
text,
`date` int(40) DEFAULT NULL,
`who` text CHARACTER SET utf8
COLLATE utf8_unicode_ci,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=333 ;
--
--------------------------------------------------------
--
--
Структура таблицы `mrek`
--
CREATE TABLE IF NOT EXISTS
`mrek` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`link` varchar(100)
DEFAULT NULL,
`nlink` varchar(30) DEFAULT NULL,
`date` int(40) DEFAULT
NULL,
`who` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
PRIMARY
KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=431 ;
--
--------------------------------------------------------
--
--
Структура таблицы `nastroyki`
--
CREATE TABLE IF NOT
EXISTS `nastroyki` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`ref_pr`
text,
`bonus` text NOT NULL,
`ploshadki` text NOT NULL,
`proclick`
text NOT NULL,
`bank_min_aktiv` text NOT NULL,
`oplata` enum('0','1')
NOT NULL DEFAULT '0',
`cena` float(11,3) NOT NULL DEFAULT '0.002',
`acena` float(11,3) NOT NULL DEFAULT '0.001',
`mp` text NOT NULL,
`off`
int(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=10 ;
--
-- Дамп
данных таблицы `nastroyki`
--
INSERT INTO `nastroyki` (`id`,
`ref_pr`, `bonus`, `ploshadki`, `proclick`, `bank_min_aktiv`, `oplata`,
`cena`, `acena`, `mp`, `off`) VALUES
(1, '0.10', '25', '15', '3', '20',
'1', 0.002, 0.001, '0', 0);
--
--------------------------------------------------------
--
--
Структура таблицы `news_comment`
--
CREATE TABLE IF NOT
EXISTS `news_comment` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`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,
PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=183 ;
--
--------------------------------------------------------
--
--
Структура таблицы `news_news`
--
CREATE TABLE IF NOT
EXISTS `news_news` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`date` varchar(15) NOT NULL,
`news` text NOT NULL,
`comm` int(10)
unsigned NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=148 ;
--
--------------------------------------------------------
--
--
Структура таблицы `nizrek`
--
CREATE TABLE IF NOT EXISTS
`nizrek` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`link` text,
`nlink`
text,
`date` int(40) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=143 ;
--
--------------------------------------------------------
--
--
Структура таблицы `online`
--
CREATE TABLE IF NOT EXISTS
`online` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`ip` varchar(40)
DEFAULT '0',
`time` varchar(90) DEFAULT NULL,
`ua` varchar(80) DEFAULT
NULL,
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0
AUTO_INCREMENT=1322436 ;
--
--------------------------------------------------------
--
--
Структура таблицы `perevod`
--
CREATE TABLE IF NOT EXISTS
`perevod` (
`sid` int(11) NOT NULL AUTO_INCREMENT,
`from` text NOT
NULL,
`to` text NOT NULL,
`kredit` int(11) NOT NULL DEFAULT '0',
`time` text NOT NULL,
`komm` text,
PRIMARY KEY (`sid`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=324 ;
--
--------------------------------------------------------
--
--
Структура таблицы `ppbase`
--
CREATE TABLE IF NOT EXISTS
`ppbase` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`who` text,
`text`
text,
`ts` bigint(20) DEFAULT NULL,
`ua` text,
`moder` int(1) DEFAULT
NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=11 ;
--
--------------------------------------------------------
--
--
Структура таблицы `refb`
--
CREATE TABLE IF NOT EXISTS
`refb` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`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,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=90 ;
--
--------------------------------------------------------
--
--
Структура таблицы `rek`
--
CREATE TABLE IF NOT EXISTS
`rek` (
`url` text,
`nazv` text NOT NULL,
`id` int(11) NOT NULL
AUTO_INCREMENT,
`cvet` text,
`srok` int(11) DEFAULT NULL,
`b` text,
`mesto` int(11) DEFAULT NULL,
`perehodov` int(11) NOT NULL,
PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=73 ;
--
--------------------------------------------------------
--
--
Структура таблицы `sites`
--
CREATE TABLE IF NOT EXISTS
`sites` (
`id` int(9) NOT NULL AUTO_INCREMENT,
`url` varchar(50) NOT
NULL,
`name` varchar(100) NOT NULL,
`about` text NOT NULL,
`date`
int(11) NOT NULL,
`cena` int(5) DEFAULT NULL,
`login` varchar(25) NOT
NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=25 ;
--
--------------------------------------------------------
--
--
Структура таблицы `sovpvhod`
--
CREATE TABLE IF NOT EXISTS
`sovpvhod` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`hz` text,
`time`
text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=429 ;
--
--------------------------------------------------------
--
--
Структура таблицы `stavki`
--
CREATE TABLE IF NOT EXISTS
`stavki` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`kr` int(11) DEFAULT
'0',
`pr` float(11,4) DEFAULT '0.0000',
`nick` tinytext,
`time`
tinytext,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=2055 ;
--
--------------------------------------------------------
--
--
Структура таблицы `users`
--
CREATE TABLE IF NOT EXISTS
`users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`nick` tinytext,
`money` float(11,4) DEFAULT '0.0000',
`in_money` int(11) DEFAULT '0',
`out_money` int(11) DEFAULT '0',
`wmr` tinytext,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3308 ;
--
--------------------------------------------------------
--
--
Структура таблицы `verhrek`
--
CREATE TABLE IF NOT EXISTS
`verhrek` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`link` text,
`nlink` text,
`date` int(40) DEFAULT NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=146 ;
--
--------------------------------------------------------
--
--
Структура таблицы `wins`
--
CREATE TABLE IF NOT EXISTS
`wins` (
`login` text,
`kred` text,
`time` text
) ENGINE=MyISAM
DEFAULT CHARSET=utf8;
--
--------------------------------------------------------
--
--
Структура таблицы `wins1`
--
CREATE TABLE IF NOT EXISTS
`wins1` (
`login` text,
`kred` text,
`time` text
) ENGINE=MyISAM
DEFAULT CHARSET=utf8;
--
--------------------------------------------------------
--
--
Структура таблицы `wins3`
--
CREATE TABLE IF NOT EXISTS
`wins3` (
`login` text,
`kred` text,
`time` text
) ENGINE=MyISAM
DEFAULT CHARSET=utf8;
--
--------------------------------------------------------
--
--
Структура таблицы `wins24`
--
CREATE TABLE IF NOT EXISTS
`wins24` (
`login` text,
`kred` text,
`time` text
) ENGINE=MyISAM
DEFAULT CHARSET=utf8;
--
--------------------------------------------------------
--
--
Структура таблицы `wins48`
--
CREATE TABLE IF NOT EXISTS
`wins48` (
`login` text,
`kred` text,
`time` text
) ENGINE=MyISAM
DEFAULT CHARSET=utf8;
--
--------------------------------------------------------
--
--
Структура таблицы `wins72`
--
CREATE TABLE IF NOT EXISTS
`wins72` (
`login` text,
`kred` text,
`time` text
) ENGINE=MyISAM
DEFAULT CHARSET=utf8;
/*!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 */;