Просмотр архива копия топ рейтинга statok

DROP TABLE IF EXISTS `cat`;

CREATE TABLE `cat` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `name` varchar(30) NOT NULL,
  `about` varchar(80) NOT
NULL,
  `position` int(3) DEFAULT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM AUTO_INCREMENT=91213 DEFAULT CHARSET=cp1251;




DROP TABLE
IF EXISTS `hits`;

CREATE TABLE `hits` (
  `id_sait` int(11) NOT NULL,
 
`time` int(8) NOT NULL,
  `ip` varchar(16) NOT NULL,
  `browser`
varchar(30) NOT NULL,
  `operator` int(6) NOT NULL
) ENGINE=MyISAM DEFAULT
CHARSET=cp1251;




DROP TABLE IF EXISTS `hosts`;

CREATE TABLE `hosts` (
 
`id_sait` int(11) NOT NULL,
  `time` int(8) NOT NULL,
  `ip` varchar(16)
NOT NULL,
  `browser` varchar(30) NOT NULL,
  `operator` int(6) NOT NULL
)
ENGINE=MyISAM DEFAULT CHARSET=cp1251;




DROP TABLE IF EXISTS
`online`;

CREATE TABLE `online` (
  `ip` varchar(16) NOT NULL,
  `ua`
varchar(20) NOT NULL,
  `time` int(7) NOT NULL
) ENGINE=MyISAM DEFAULT
CHARSET=cp1251;




DROP TABLE IF EXISTS `sait`;

CREATE TABLE `sait` (
 
`id` int(11) NOT NULL AUTO_INCREMENT,
  `id_user` int(11) NOT NULL,
 
`id_mod` int(11) NOT NULL,
  `name` varchar(35) NOT NULL,
  `about`
varchar(150) NOT NULL,
  `time_reg` int(8) NOT NULL,
  `time_activ` int(8)
NOT NULL,
  `hits` int(11) NOT NULL,
  `hits2` int(11) NOT NULL,
  `hits3`
int(11) NOT NULL,
  `hits4` int(11) NOT NULL,
  `hits5` int(11) NOT NULL,
 
`hits6` int(11) NOT NULL,
  `hits7` int(11) NOT NULL,
  `hits8` int(11) NOT
NULL,
  `hits9` int(11) NOT NULL,
  `hits10` int(11) NOT NULL,
  `hits11`
int(11) NOT NULL,
  `hits12` int(11) NOT NULL,
  `hits13` int(11) NOT
NULL,
  `hits14` int(11) NOT NULL,
  `hits15` int(11) NOT NULL,
  `hits16`
int(11) NOT NULL,
  `hits17` int(11) NOT NULL,
  `hits18` int(11) NOT
NULL,
  `hits19` int(11) NOT NULL,
  `hits20` int(11) NOT NULL,
  `hits21`
int(11) NOT NULL,
  `hits22` int(11) NOT NULL,
  `hits23` int(11) NOT
NULL,
  `hits24` int(11) NOT NULL,
  `hits25` int(11) NOT NULL,
  `hits26`
int(11) NOT NULL,
  `hits27` int(11) NOT NULL,
  `hits28` int(11) NOT
NULL,
  `hits29` int(11) NOT NULL,
  `hits30` int(11) NOT NULL,
  `hosts`
int(11) NOT NULL,
  `hosts2` int(11) NOT NULL,
  `hosts3` int(11) NOT
NULL,
  `hosts4` int(11) NOT NULL,
  `hosts5` int(11) NOT NULL,
  `hosts6`
int(11) NOT NULL,
  `hosts7` int(11) NOT NULL,
  `hosts8` int(11) NOT
NULL,
  `hosts9` int(11) NOT NULL,
  `hosts10` int(11) NOT NULL,
 
`hosts11` int(11) NOT NULL,
  `hosts12` int(11) NOT NULL,
  `hosts13`
int(11) NOT NULL,
  `hosts14` int(11) NOT NULL,
  `hosts15` int(11) NOT
NULL,
  `hosts16` int(11) NOT NULL,
  `hosts17` int(11) NOT NULL,
 
`hosts18` int(11) NOT NULL,
  `hosts19` int(11) NOT NULL,
  `hosts20`
int(11) NOT NULL,
  `hosts21` int(11) NOT NULL,
  `hosts22` int(11) NOT
NULL,
  `hosts23` int(11) NOT NULL,
  `hosts24` int(11) NOT NULL,
 
`hosts25` int(11) NOT NULL,
  `hosts26` int(11) NOT NULL,
  `hosts27`
int(11) NOT NULL,
  `hosts28` int(11) NOT NULL,
  `hosts29` int(11) NOT
NULL,
  `hosts30` int(11) NOT NULL,
  `all_hits` int(11) NOT NULL,
 
`all_hosts` int(11) NOT NULL,
  `in` int(11) NOT NULL,
  `in2` int(11) NOT
NULL,
  `in3` int(11) NOT NULL,
  `in4` int(11) NOT NULL,
  `in5` int(11)
NOT NULL,
  `in6` int(11) NOT NULL,
  `in7` int(11) NOT NULL,
  `in8`
int(11) NOT NULL,
  `in9` int(11) NOT NULL,
  `in10` int(11) NOT NULL,
 
`in11` int(11) NOT NULL,
  `in12` int(11) NOT NULL,
  `in13` int(11) NOT
NULL,
  `in14` int(11) NOT NULL,
  `in15` int(11) NOT NULL,
  `in16`
int(11) NOT NULL,
  `in17` int(11) NOT NULL,
  `in18` int(11) NOT NULL,
 
`in19` int(11) NOT NULL,
  `in20` int(11) NOT NULL,
  `in21` int(11) NOT
NULL,
  `in22` int(11) NOT NULL,
  `in23` int(11) NOT NULL,
  `in24`
int(11) NOT NULL,
  `in25` int(11) NOT NULL,
  `in26` int(11) NOT NULL,
 
`in27` int(11) NOT NULL,
  `in28` int(11) NOT NULL,
  `in29` int(11) NOT
NULL,
  `in30` int(11) NOT NULL,
  `out` int(11) NOT NULL,
  `out2` int(11)
NOT NULL,
  `out3` int(11) NOT NULL,
  `out4` int(11) NOT NULL,
  `out5`
int(11) NOT NULL,
  `out6` int(11) NOT NULL,
  `out7` int(11) NOT NULL,
 
`out8` int(11) NOT NULL,
  `out9` int(11) NOT NULL,
  `out10` int(11) NOT
NULL,
  `out11` int(11) NOT NULL,
  `out12` int(11) NOT NULL,
  `out13`
int(11) NOT NULL,
  `out14` int(11) NOT NULL,
  `out15` int(11) NOT NULL,
 
`out16` int(11) NOT NULL,
  `out17` int(11) NOT NULL,
  `out18` int(11) NOT
NULL,
  `out19` int(11) NOT NULL,
  `out20` int(11) NOT NULL,
  `out21`
int(11) NOT NULL,
  `out22` int(11) NOT NULL,
  `out23` int(11) NOT NULL,
 
`out24` int(11) NOT NULL,
  `out25` int(11) NOT NULL,
  `out26` int(11) NOT
NULL,
  `out27` int(11) NOT NULL,
  `out28` int(11) NOT NULL,
  `out29`
int(11) NOT NULL,
  `out30` int(11) NOT NULL,
  `all_in` int(11) NOT NULL,

 `all_out` int(11) NOT NULL,
  `category` int(6) NOT NULL,
  `image`
varchar(6) NOT NULL,
  `image_s` varchar(6) NOT NULL,
  `url` varchar(30)
NOT NULL,
  `status` int(1) NOT NULL,
  `auto_ban` int(1) NOT NULL,
  `ban`
int(1) NOT NULL,
  `ban_reason` varchar(50) NOT NULL,
  `ban_who` int(11)
NOT NULL,
  `ban_time` int(8) NOT NULL,
  `auto_del` int(1) NOT NULL,
 
`count` int(9) NOT NULL,
  `gold` int(11) NOT NULL DEFAULT '0',
  PRIMARY
KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT
CHARSET=cp1251;




DROP TABLE IF EXISTS `sait_online`;

CREATE TABLE
`sait_online` (
  `id_sait` int(11) NOT NULL,
  `ip` varchar(16) NOT NULL,

 `ua` varchar(20) NOT NULL,
  `time` int(7) NOT NULL
) ENGINE=MyISAM
DEFAULT CHARSET=cp1251;




DROP TABLE IF EXISTS `settings`;

CREATE TABLE
`settings` (
  `name` varchar(60) NOT NULL,
  `value` varchar(60) NOT
NULL,
  PRIMARY KEY (`name`,`value`)
) ENGINE=MyISAM DEFAULT
CHARSET=cp1251;




DROP TABLE IF EXISTS `users`;

CREATE TABLE `users` (
 
`id` int(11) NOT NULL AUTO_INCREMENT,
  `time_reg` int(8) NOT NULL,
 
`login` varchar(30) NOT NULL,
  `password` varchar(50) NOT NULL,
  `mail`
varchar(30) NOT NULL,
  `level` int(2) NOT NULL,
  `pages` int(2) NOT
NULL,
  `page_platforms` int(2) NOT NULL,
  `page_sait` int(2) NOT NULL,
 
`page_top` int(2) NOT NULL,
  `auto_del` int(1) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=cp1251;