[thelist] Q on a DB schema

[jsWalter]

I was wondering, do I need all the data (see below) in a single table or
can/should it be split up?

This is to:
  - sign up a user
  - keep user personal info
  - keep user pref
  - track user access


Thanks

Walter




CREATE TABLE 'user' (
  'user_id' int(4) NOT NULL auto_increment,
  'user_name' varchar(50) NOT NULL default '',
  'user_password' varchar(34) NOT NULL default '',
  'user_address_1' varchar(5) NOT NULL default '',
  'user_address_2' varchar(50) default NULL,
  'user_city' varchar(50) NOT NULL default '',
  'user_st' char(2) NOT NULL default '',
  'user_zip' varchar(12) NOT NULL default '',
  'user_home_phone' varchar(12) NOT NULL default '',
  'user_work_phone' varchar(12) NOT NULL default '',
  'user_cell_phone' varchar(12) default NULL,
  'user_email' varchar(100) NOT NULL default '',
  'user_email_updates' int(1) unsigned NOT NULL default '0',
  'user_show_email' int(1) unsigned NOT NULL default '0',
  'user_picture' varchar(250) default NULL,
  'user_website' varchar(150) default NULL,
  'group_id' varchar(25) NOT NULL default '',
  'group_level' int(4) NOT NULL default '0',
  'group_status' varchar(10) NOT NULL default '',
  'user_creation_date' datetime NOT NULL default '0000-00-00 00:00:00',
  'user_signup_ip' varchar(15) NOT NULL default '',
  'user_last_login' datetime NOT NULL default '0000-00-00 00:00:00',
  'user_logincount' int(12) NOT NULL default '0',
  'user_last_update' datetime NOT NULL default '0000-00-00 00:00:00',
  'user_confirmed_date' datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (user_id')
) TYPE=MyISAM AUTO_INCREMENT=1 ;