CREATE TABLE `ban` (
`reason` varchar(250) NOT NULL,
`who` varchar(100) NOT NULL,
`date` int(40) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;
CREATE TABLE `cclub_captcha` (
`code` text,
`ua` text,
`ip` text,
`ts` bigint(20) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `cclub_clicks` (
`who` text,
`to` text,
`ts` bigint(20) default NULL,
`id_user` text
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `cclub_guest` (
`id` int(11) NOT NULL auto_increment,
`who` text,
`text` text,
`answer` text,
`ts` bigint(20) default NULL,
`ua` text,
`nans` text,
`izmts` BIGINT(20) NOT NULL,
`izmkol` INT(3) NOT NULL DEFAULT '0',
`izmwho` TEXT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `cclub_lichka` (
`number` int(11) NOT NULL auto_increment,
`idot` text character set utf8 collate utf8_unicode_ci NOT NULL,
`idto` 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=1 ;
CREATE TABLE IF NOT EXISTS `cclub_lichkaout` (
`number` int(11) NOT NULL auto_increment,
`idot` text character set utf8 collate utf8_unicode_ci NOT NULL,
`idto` 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=1 ;
CREATE TABLE `cclub_news` (
`id` int(11) NOT NULL auto_increment,
`text` text,
`tema` text,
`ts` bigint(20) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE `cclub_users` (
`id` int(11) NOT NULL auto_increment,
`login` text,
`password` 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',
`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` text,
`moder` tinyint(4) default '0',
`imja` text,
`gorod` text,
`icq` text,
`wm` text,
`osebe` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE `cclub_actia` (
`id` int(11) NOT NULL auto_increment,
`text` text,
`tema` text,
`ts` bigint(20) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE `stavki` (
`id` int(11) NOT NULL auto_increment,
`kr` int(11) default '0',
`pr` float(11,4) default '0',
`nick` tinytext,
`time` tinytext,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `users` (
`id` int(11) NOT NULL auto_increment,
`nick` tinytext,
`money` float(11,4) default '0',
`in_money` int(11) default '0',
`out_money` int(11) default '0',
`wmr` tinytext,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `cclub_onas` (
`id` int(11) NOT NULL auto_increment,
`who` text,
`text` text,
`ts` bigint(20) default NULL,
`ua` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE `cclub_chat` (
`id` int(11) NOT NULL auto_increment,
`who` text,
`text` text,
`ts` bigint(20) default NULL,
`nastr` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
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 ;
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 ;
CREATE TABLE IF NOT EXISTS `news_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 ;
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 ;
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=1 ;
CREATE TABLE `mrek` (
`id` int(11) NOT NULL auto_increment,
`link` text,
`nlink` text,
`date` int(40) default NULL,
`who` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `cclub_aneks` (
`id` int(11) NOT NULL auto_increment,
`who` text,
`text` text,
`ts` bigint(20) default NULL,
`ua` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `cclub_url` (
`id` int(11) NOT NULL auto_increment,
`id_user` text character set utf8 collate utf8_unicode_ci,
`url` text character set utf8 collate utf8_unicode_ci,
`nazv` text character set utf8 collate utf8_unicode_ci,
`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) character set utf8 collate utf8_unicode_ci NOT NULL,
`referer` bigint(20) NOT NULL,
`ref` text character set utf8 collate utf8_unicode_ci,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `cclub_zadanie` (
`id` int(11) NOT NULL auto_increment,
`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,
`time_on` text NOT NULL,
`status` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
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=1 ;
CREATE TABLE `cclub_forums` (
`id` int(5) NOT NULL auto_increment,
`name` varchar(40) character set utf8 collate utf8_unicode_ci default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE `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 NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE `cclub_themes` (
`id` int(5) NOT NULL auto_increment,
`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,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE `cclub_stats` (
`who` varchar(60) NOT NULL,
`cn` smallint(6) unsigned NOT NULL,
`ts` date NOT NULL,
UNIQUE KEY `who` (`who`,`cn`,`ts`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;