CREATE TABLE `users` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(25) NOT NULL default '',
  `password` varchar(32) default NULL,
  `email` varchar(75) default NULL,
  `joined` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`),
  KEY `username` (`username`)
);

CREATE TABLE `user_info` (
  `userid` int(11) NOT NULL,
  `profile_text` TEXT default '',
  `location` varchar(30),
  `age` int default 0,
   ...
   ..
);

CREATE TABLE `user_preferences` .. ;

CREATE TABLE `user_friends` ... ;