# MySQL-Front Dump 2.1
#
# Host: 210.54.17.179 Database: eftpop
#--------------------------------------------------------
CREATE TABLE `traffic_summary` (
`traffic_id` tinyint(3) unsigned NOT NULL auto_increment,
`traffic_date` date default NULL,
`traffic_view` tinyint(3) unsigned default '0',
`win_9x` tinyint(6) unsigned default '0',
`win_2000` tinyint(6) unsigned default '0',
`win_xp` tinyint(6) unsigned default '0',
`win_other` tinyint(3) unsigned default '0',
`mac_ppc` tinyint(6) unsigned default '0',
`mac_osx` tinyint(6) unsigned default '0',
`linux` tinyint(6) unsigned default '0',
`unix` tinyint(6) unsigned default '0',
`other_os` tinyint(6) unsigned default '0',
`ie_under_5` tinyint(3) unsigned default '0',
`ie_5` tinyint(3) unsigned default '0',
`ie_5_5` tinyint(3) unsigned default '0',
`ie_6` tinyint(3) unsigned default '0',
`ns_under_4` tinyint(3) unsigned default '0',
`ns_4` tinyint(3) unsigned default '0',
`ns_6` tinyint(3) unsigned default '0',
`ns_7_over` tinyint(3) unsigned default '0',
`opera` tinyint(3) unsigned default '0',
`gecko` tinyint(3) unsigned default '0',
`crawler` tinyint(3) unsigned default '0',
`other_browser` tinyint(3) unsigned default '0',
`screen_800x600` tinyint(3) unsigned default '0',
`screen_1024x768` tinyint(3) unsigned default '0',
`screen_1152x864` tinyint(3) unsigned default '0',
`screen_1600x1200` tinyint(3) unsigned default '0',
`screen_other` tinyint(3) unsigned default '0',
`java_enabled` tinyint(3) unsigned default '0',
`js_using_under_1_2` tinyint(3) unsigned default '0',
`js_using_1_3` tinyint(3) unsigned default '0',
`js_using_above_1_4` tinyint(3) unsigned default '0',
`js_aval` tinyint(3) unsigned default '0',
`activex_aval` tinyint(3) unsigned default '0',
`activex_enabled` tinyint(3) unsigned default '0',
`cookies_aval` tinyint(3) unsigned default '0',
`cookies_enabled` tinyint(3) unsigned default '0',
`reg_exp_aval` tinyint(3) unsigned default '0',
`font_smooth_enabled` tinyint(3) unsigned default '0',
`flash_4` tinyint(3) unsigned default '0',
`flash_5` tinyint(3) unsigned default '0',
`flash_mx` tinyint(3) unsigned default '0',
`quicktime` tinyint(3) unsigned default '0',
`realplayer` tinyint(3) unsigned default '0',
`windows_media_player` tinyint(3) unsigned default '0',
`director` tinyint(3) unsigned default '0',
`color_16bit` tinyint(3) unsigned default '0',
`color_24bit` tinyint(3) unsigned default '0',
`color_32bit` tinyint(3) unsigned default '0',
`non_english` tinyint(3) unsigned default '0',
PRIMARY KEY (`traffic_id`)
) TYPE=MyISAM;
#
# Dumping data for table 'traffic_summary'
#
|