Просмотр файла sql.txt

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;