Geeklog Forums

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;

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

age, bday, GMT (similar to phpbb).

---

-- destr0yr
"I love deadlines. I like the whooshing sound they make as they fly by." -- Douglas Adams

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?

---

-- Heather Engineering
-- No job too small

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...

---

-- destr0yr
"I love deadlines. I like the whooshing sound they make as they fly by." -- Douglas Adams