Posted by guitarromantic on 09/09/05 03:11

hey,

Mine is pretty specific to my site, but here's what I'm using:

CREATE TABLE `staff` (
`Staff_id` int(11) NOT NULL auto_increment,
`username` text NOT NULL,
`Staff_Email` text NOT NULL,
`password` text NOT NULL,
`status` text NOT NULL,
`profile` text NOT NULL,
PRIMARY KEY (`Staff_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=75 ;

Password is stored as md5. Status is a number corresponding to the
'statuses' table (contains two columns, 'id' and 'title'). Profile is
just html code for that staff member's personal info.

[Back to original message]