CREATE TABLE user_settings (
  user_id int(11) NOT NULL,
  `key` varchar(255) NOT NULL,
  `value` longtext NOT NULL,
  `type` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (user_id,`key`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;