Comment 1 by Jethro Carr, Jul 24, 2010
There is a need to create a new SQL table for this feature, we weren't sure if it was best to modify the upgrade script and submit that or to just provide the SQL for the main developers to add. Anyway, here it is: CREATE TABLE IF NOT EXISTS `indefero_idf_user_data` ( `id` mediumint(9) unsigned NOT NULL auto_increment, `user` mediumint(9) unsigned NOT NULL default '0', `description` text NOT NULL, `twitter` varchar(255) NOT NULL, `public_email` varchar(255) NOT NULL, `website` varchar(255) NOT NULL, `avatar` varchar(255) NOT NULL, PRIMARY KEY (`id`), KEY `user_foreignkey_idx` (`user`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
Comment 2 by Patrick Georgi, Jul 25, 2010
That's what the migrations are for: src/IDF/Migrations/* are executed in order, and the highest applied number is stored somewhere. That way, new schema modifications can be done incrementially. Where possible it can use the Pluf DB APIs, making things DB independent (see 15AddGConf.php). Where Pluf's API is not enough (eg. when changing column types), SQL queries are necessary (see 5DescToText.php)
Comment 3 by Loïc d'Anterroches, Sep 6, 2010
Great, I will reuse your code and use the general GConf object to store the data without the need to add a new table. Patrick, this will solve the gravatar issue!
Labels:
Type:Enhancement
Priority:High
Type:Defect
Priority:Medium
Status: Accepted
Summary: Enhanced User Profile Page & Avatar
Status: Accepted
Summary: Enhanced User Profile Page & Avatar
Comment 4 by Thomas Keller, Nov 25, 2010
I'd really like to see that feature in 1.1 - Loic, what do you think?
Owner:
loic
Comment 5 by Loïc d'Anterroches, Nov 29, 2010
Ok to include it. Either you are ready to update it with GConf, if not assign it back to me and I will do it.
Owner:
tommyd
Comment 6 by Thomas Keller, Nov 29, 2010
You said you wanted to do that - I just wanted to second the demand :) But if you don't have the time for it, then I could do it. But I have a pile of other work on my list as well.
Comment 7 by Jethro Carr, Nov 29, 2010
I could potentially take a look at helping out with this change, but realistically I won't have the free time till late Dec.
Comment 9 by Thomas Keller, Dec 5, 2010
Thanks for the patch. It was included, but heavily modified in commit 784c971. Follow the link to see the full list of changes.
Status:
Fixed
Sign in to reply to this comment.
Reported by Jethro Carr, Jul 24, 2010