Storing User Preferences & Site Preferences

[eluser]jayrulez[/eluser]
[quote author="skunkbad" date="1245574396"]what about something like this:

Code:

CREATE TABLE `users` (
  `user_id` int(10) unsigned NOT NULL,
  `user_name` varchar(12) NOT NULL,
  `user_pass` varchar(60) NOT NULL,
  `user_email` varchar(60) NOT NULL,
  PRIMARY KEY (`user_id`),
  UNIQUE KEY (`user_name`),
  UNIQUE KEY (`user_email`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

CREATE TABLE `user_prefs` (
  `user_id` int(10) unsigned NOT NULL,
  `user_phone` varchar(10) default NULL,
  `user_address` varchar(80) default NOT NULL,
  -- `user_state` ...
  -- `user_city` ...
  -- `user_zip` ...
  -- `user_country` ...
  -- ...
  -- ...
  PRIMARY KEY  (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

You would add fields to the user_prefs table if needed, and each site user only needs one row in each table.[/quote]

yes this is what i was suggesting