CREATE TABLE `stats` (
`ip` VARCHAR( 15 ) NOT NULL PRIMARY KEY ,
`datetime` DATETIME NOT NULL ,
`user_agent` VARCHAR( 50 ) NOT NULL ,
`browser` VARCHAR( 10 ) NOT NULL ,
`os` VARCHAR( 15 ) NOT NULL ,
`uri` VARCHAR( 150 ) NOT NULL ,
`accept_lang` CHAR( 2 ) NOT NULL ,
`is_dw` INTEGERSIGNED NOT NULL DEFAULT '0',
`is_ex` INTEGERSIGNED NOT NULL DEFAULT '0',
`total` INTEGER UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY ( `ip` )
) ENGINE = MYISAM ;