public function up() { if (HSetting::isInstalled()) { $this->alterColumn('profile', 'zip', 'VARCHAR(10) DEFAULT NULL'); $this->update('profile_field', array('field_type_class' => 'ProfileFieldTypeText', 'field_type_config' => '{"minLength":null,"maxLength":10,"validator":null,"default":null,"regexp":null,"regexpErrorMessage":null}'), 'internal_name="zip"'); } }
public function up() { $connection = $this->getDbConnection(); $command = $connection->commandBuilder->createFindCommand('user', new CDbCriteria()); $reader = $command->query(); foreach ($reader as $row) { // Ignore deleted users if ($row['status'] == 3) { continue; } $userId = $row['id']; $receive_email_notifications = $row['receive_email_notifications']; $receive_email_messaging = $row['receive_email_messaging']; $receive_email_activities = $row['receive_email_activities']; $insertCommand = $connection->commandBuilder->createInsertCommand('user_setting', array('user_id' => $userId, 'module_id' => 'core', 'name' => 'receive_email_notifications', 'value' => $receive_email_notifications)); $insertCommand->execute(); $insertCommand = $connection->commandBuilder->createInsertCommand('user_setting', array('user_id' => $userId, 'module_id' => 'core', 'name' => 'receive_email_messaging', 'value' => $receive_email_messaging)); $insertCommand->execute(); $insertCommand = $connection->commandBuilder->createInsertCommand('user_setting', array('user_id' => $userId, 'module_id' => 'core', 'name' => 'receive_email_activities', 'value' => $receive_email_activities)); $insertCommand->execute(); } $this->dropColumn('user', 'receive_email_notifications'); $this->dropColumn('user', 'receive_email_messaging'); $this->dropColumn('user', 'receive_email_activities'); if (HSetting::isInstalled()) { $this->insert('setting', array('name' => 'receive_email_activities', 'value' => '1', 'name' => 'mailing')); $this->insert('setting', array('name' => 'receive_email_notifications', 'value' => '2', 'name' => 'mailing')); } }
public function up() { if (HSetting::isInstalled()) { $this->insert('setting', array('name' => 'enable_html5_desktop_notifications', 'value' => 0, 'module_id' => 'notification')); } $this->addColumn('notification', 'desktop_notified', 'tinyint(1) DEFAULT 0'); $this->update('notification', array('desktop_notified' => 1)); }
public function up() { // Check if the installer already ran when not create new profile field // (Typically the installer creates initial data.) if (HSetting::isInstalled()) { $db = $this->getDbConnection(); // Get "General" Category Group Id $categoryId = $db->createCommand()->select('id')->from('profile_field_category')->where('title=:title', array(':title' => 'General'))->queryScalar(); // Check if we got a category Id if ($categoryId == "") { throw new CException("Could not find 'General' profile field category!"); } // Create manually profile field $insertCommand = $db->commandBuilder->createInsertCommand('profile_field', array('profile_field_category_id' => $categoryId, 'field_type_class' => 'ProfileFieldTypeSelect', 'field_type_config' => '{"options":"male=>Male\\r\\nfemale=>Female\\r\\ncustom=>Custom"}', 'internal_name' => 'gender', 'title' => 'Gender', 'sort_order' => '350', 'editable' => '1', 'visible' => '1', 'show_at_registration' => '0', 'required' => '0')); $insertCommand->execute(); // Create column for profile field $this->addColumn('profile', 'gender', 'varchar(255) DEFAULT NULL'); } }
public function up() { // Check if the installer already ran when not create new profile field // (Typically the installer creates initial data.) if (HSetting::isInstalled()) { $db = $this->getDbConnection(); // Get "General" Category Group Id $categoryId = $db->createCommand()->select('id')->from('profile_field_category')->where('title=:title', array(':title' => 'General'))->queryScalar(); // Check if we got a category Id if ($categoryId == "") { throw new CException("Could not find 'General' profile field category!"); } // Create manually profile field $insertCommand = $db->commandBuilder->createInsertCommand('profile_field', array('profile_field_category_id' => $categoryId, 'field_type_class' => 'ProfileFieldTypeBirthday', 'field_type_config' => '', 'internal_name' => 'birthday', 'title' => 'Birthday', 'sort_order' => '850', 'editable' => '1', 'is_system' => '1', 'visible' => '1', 'show_at_registration' => '0', 'required' => '0')); $insertCommand->execute(); // Create columns for profile field $this->addColumn('profile', 'birthday', 'DATETIME DEFAULT NULL'); $this->addColumn('profile', 'birthday_hide_year', 'INT(1) DEFAULT NULL'); } }
public function up() { if (HSetting::isInstalled()) { $this->insert('setting', array('name' => 'installationId', 'value' => md5(uniqid("", true)), 'module_id' => 'admin')); } }