[thelist] Q on a DB schema
jsWalter
jsWalter at torres.ws
Thu Feb 19 11:05:53 CST 2004
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 ;
More information about the thelist
mailing list