CREATE TABLE `counter_segodnya` (
  `id_zapisi` int( 15 ) NOT NULL auto_increment,
  `chislo` date NOT NULL default '0000-00-00',
  `vremya` time NOT NULL default '00:00:00',
  `vizit_timestamp` int( 16 ) NOT NULL default '0',
  `random_for_jaba` varchar( 64 ) collate cp1251_bin NOT NULL default '',
  `ip` varchar( 15 ) collate cp1251_bin NOT NULL default '',
  `page` int( 5 ) NOT NULL default '0',
  `user_agent` text collate cp1251_bin NOT NULL,
  `referer` text collate cp1251_bin NOT NULL,
  `screen_width` int( 11 ) default NULL,
  `screen_height` int( 11 ) default NULL,
  `user_color` int( 11 ) default NULL,
  PRIMARY KEY  (`id_zapisi`),
  KEY `random_for_jaba` (`random_for_jaba`),
  KEY `vizit_timestamp` (`vizit_timestamp`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COLLATE=cp1251_bin 
AUTO_INCREMENT= 26122  ;

CREATE TABLE `table_all_stat_of_site` (
  `unic_id` int( 11 ) NOT NULL auto_increment,
  `year_field` int( 11 ) default '0',
  `month_field` int( 11 ) default '0',
  `date_field` int( 11 ) default '0',
  `hour_field` int( 11 ) default '0',
  `all_users` int( 11 ) default '0',
  `yandex` int( 11 ) default '0',
  `rambler` int( 11 ) default '0',
  `google` int( 11 ) default '0',
  `mail_ru` int( 11 ) default '0',
  `yahoo` int( 11 ) default '0',
  `msn` int( 11 ) default '0',
  `other_robots` int( 11 ) default '0',
  `user_color` int( 11 ) default '0',
  `640x480` int( 11 ) default '0',
  `800x600` int( 11 ) default '0',
  `1024x768` int( 11 ) default '0',
  `1280x1024` int( 11 ) default '0',
  `1600x1200` int( 11 ) default '0',
  `other_screen` int( 11 ) default '0',
  `java_disabled` int( 11 ) NOT NULL default '0',
  PRIMARY KEY  (`unic_id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COLLATE=cp1251_bin COMMENT='Общая 
статистика сайта' AUTO_INCREMENT= 1  ;

// ищем дату, когда `сегодня` началось :)
$segodnya = time() - ((date('H',time()))* 3600 ) - ((date('i',time()))* 60 ) - (date('s',time()));