View file top-elena/base.txt

CREATE TABLE `count_24` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `uid` int(10) unsigned NOT NULL default '0',
  `date` int(10) unsigned NOT NULL default '0',
  `hour` smallint(5) unsigned NOT NULL default '0',
  `count` int(10) unsigned NOT NULL default '0',
  `host` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

CREATE TABLE `hits_ip` (
  `uid` int(10) unsigned NOT NULL default '0',
  `ip` varchar(15) NOT NULL default '',
  `ua` varchar(255) NOT NULL default 'n/a',
  PRIMARY KEY  (`ip`,`ua`,`uid`)
) TYPE=MyISAM;

CREATE TABLE `hits_time` (
  `uid` int(10) unsigned NOT NULL default '0',
  `time` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`uid`)
) TYPE=MyISAM;

CREATE TABLE `months` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `uid` int(10) unsigned NOT NULL default '0',
  `date` int(10) unsigned NOT NULL default '0',
  `count` int(10) unsigned NOT NULL default '0',
  `host` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

CREATE TABLE `online_ip` (
  `uid` int(10) unsigned NOT NULL default '0',
  `ip` varchar(15) NOT NULL default '',
  PRIMARY KEY  (`ip`,`uid`)
) TYPE=MyISAM;

CREATE TABLE `online_time` (
  `uid` int(10) unsigned NOT NULL default '0',
  `time` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`uid`)
) TYPE=MyISAM;

CREATE TABLE `users` (
  `uid` int(10) unsigned NOT NULL auto_increment,
  `site_name` varchar(50) NOT NULL default '',
  `link` varchar(50) NOT NULL default '',
  `admin` varchar(30) NOT NULL default '',
  `email` varchar(30) NOT NULL default '',
  `info` varchar(200) NOT NULL default '',
  `date` int(10) unsigned NOT NULL default '0',
  `pass` varchar(50) NOT NULL default '',
  `type` int(1) unsigned NOT NULL default '2',
  `typeStat` int(1) unsigned NOT NULL default '1',
  PRIMARY KEY  (`uid`)
) TYPE=MyISAM;

CREATE TABLE `weeks` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `uid` int(10) unsigned NOT NULL default '0',
  `next_mon` int(10) unsigned NOT NULL default '0',
  `date` int(10) unsigned NOT NULL default '0',
  `day_week` smallint(5) unsigned NOT NULL default '0',
  `count` int(10) unsigned NOT NULL default '0',
  `host` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;