Posted on: 05/23/04 08:33pm
By: mthomas
DB Map, please take a look see if there is anything to add.
CREATE TABLE `gl_users_extended` (
`uid` mediumint(8) NOT NULL,
`lastname` varchar(25) default NULL,
`firstname` varchar(25) default NULL,
`email` varchar(50) default NULL,
`url_1` varchar(50) default NULL,
`url_2` varchar(50) default NULL,
`phone_1` varchar(50) default NULL,
`phone_2` varchar(50) default NULL,
`ext` varchar(8) default NULL,
`mobile` varchar(50) default NULL,
`title` varchar(50) default NULL,
`addr_1` varchar(25) default NULL,
`addr_2` varchar(25) default NULL,
`addr_3` varchar(50) default NULL,
`addr_4` varchar(50) default NULL,
`addr_5` varchar(50) default NULL,
`addr_6` varchar(50) default NULL,
PRIMARY KEY (`uid`)
) TYPE=MyISAM;
gl_users_extended
Posted on: 05/23/04 11:35pm
By: samstone
I do sites for non-profit orgs. Most of the time we need a field for AFFILIATION (for something like "Company" or "Church" or "Denomination.")
And also POSITION, for "Chair Person", "Leader", or "Premium Member" or "guest", etc.
These optional fields will also be helpful. "Hobbies", "Special Talents or Professional Skills", "Birthday," "Marrital Status", "Gender"
Thank you for your enthusiasm!
Sam
gl_users_extended
Posted on: 05/24/04 01:34am
By: destr0yr
age, bday, GMT (similar to phpbb).
gl_users_extended
Posted on: 05/24/04 02:26am
By: Euan
How about
user_defined_1_title
user_defined_1_desc
user_defined_2_title
user_defined_2_desc
user_defined_3_title
user_defined_3_desc
but that's messy.
date of birth (and then calculate age as it changes).
GMT? Greenwich mean time?
gl_users_extended
Posted on: 05/24/04 02:58am
By: destr0yr
[QUOTE BY= euan]date of birth (and then calculate age as it changes).
GMT? Greenwich mean time?[/QUOTE]
Yes, have selectable DOB options, year, month day... shouldn't be too difficult, i did it on GL 1.3.7 but when i did the update forgot to back it up (and it was coded right into the core).
GMT, yah, Greenwich mean time selector for the timezone you're in. -8 Pacific, -7 Mountain, etc etc...