View file social/install/db_tables/user_ref.sql

DROP TABLE IF EXISTS user_ref;
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;