CREATE TABLE `referers`(
`id` INT(11) NOT NULL AUTO_INCREMENT,
`ip`
VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT
'Unkown',
`ua` VARCHAR(500) CHARACTER SET utf8 COLLATE
utf8_general_ci
NOT NULL DEFAULT 'Unkown',
`url` VARCHAR(1000) CHARACTER SET utf8
COLLATE
utf8_general_ci NOT NULL,
`time` INT(11) NOT NULL,
PRIMARY KEY(`id`)
)
ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci