33 lines
1.0 KiB
PHP
33 lines
1.0 KiB
PHP
|
<?php
|
||
|
|
|
||
|
|
/*
|
||
|
|
* @copyright Copyright (C) 2005-2010 Keyboard Monkeys Ltd. http://www.kb-m.com
|
||
|
|
* @license http://creativecommons.org/licenses/BSD/ BSD License
|
||
|
|
* @author Keyboard Monkey Ltd
|
||
|
|
* @since CommunityID 0.9
|
||
|
|
* @package CommunityID
|
||
|
|
* @packager Keyboard Monkeys
|
||
|
|
*/
|
||
|
|
|
||
|
|
class Upgrade_2_0_0_beta1 extends CommunityID_UpgradeStage
|
||
|
|
{
|
||
|
|
/**
|
||
|
|
* I need to fill the new profile_id field in the fields_values table, before being able to
|
||
|
|
* add a foreign key to it
|
||
|
|
*/
|
||
|
|
public function proceed()
|
||
|
|
{
|
||
|
|
$fieldsValues = new Model_FieldsValues();
|
||
|
|
$users = new Users_Model_Users();
|
||
|
|
foreach ($users->getUsers() as $user) {
|
||
|
|
$profileId = $user->createDefaultProfile($this->_view);
|
||
|
|
foreach ($fieldsValues->getForUser($user) as $fieldValue) {
|
||
|
|
$fieldValue->profile_id = $profileId;
|
||
|
|
$fieldValue->save();
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
$this->_db->query('ALTER TABLE `fields_values` ADD FOREIGN KEY ( `profile_id` ) REFERENCES `profiles` (`id`) ON DELETE CASCADE');
|
||
|
|
}
|
||
|
|
}
|