CREATE TABLE IF NOT EXISTS user_ref (
id int(10) unsigned NOT NULL
auto_increment,
`time` int(10) unsigned NOT NULL,
id_user int(10)
unsigned NOT NULL,
url varchar(1024) default NULL,
type_input
varchar(12) default 'cookie',
PRIMARY KEY (id),
KEY `time`
(`time`,id_user),
KEY type_input (type_input)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;