m160509_000000_seomatic_addSiteLinksBing.php

<?php
namespace Craft;

/**
 * The class name is the UTC timestamp in the format of mYYMMDD_HHMMSS_pluginHandle_migrationName
 */
class m160509_000000_seomatic_addSiteLinksBing extends BaseMigration
{
    /**
     * Any migration code in here is wrapped inside of a transaction.
     *
     * @return bool
     */
    public function safeUp()
    {
        // specify columns and AttributeType
        $newColumns = array (
            'siteLinksSearchTargets' => ColumnType::Text,
            'siteLinksQueryInput' => ColumnType::Varchar,
        );

        $this->_addColumnsAfter("seomatic_settings", $newColumns, "siteRobotsTxt");

        // specify columns and AttributeType
        $newColumns = array (
            'bingSiteVerification' => ColumnType::Varchar,
        );

        $this->_addColumnsAfter("seomatic_settings", $newColumns, "googleSiteVerification");

        // return true and let craft know its done
        return true;
    }

    private function _addColumnsAfter($tableName, $newColumns, $afterColumnHandle)
    {

        // this is a foreach loop, enough said
        foreach ($newColumns as $columnName => $columnType)
        {
            // check if the column does NOT exist
            if (!craft()->db->columnExists($tableName, $columnName))
            {
                $this->addColumnAfter($tableName, $columnName, array(
                    'column' => $columnType,
                    'null'   => false,
                    ),
                    $afterColumnHandle
                );

                // log that we created the new column
                SeomaticPlugin::log("Created the `$columnName` in the `$tableName` table.", LogLevel::Info, true);

            }

            // if the column already exists in the table
            else {

                // tell craft that we couldn't create the column as it alredy exists.
                SeomaticPlugin::log("Column `$columnName` already exists in the `$tableName` table.", LogLevel::Info, true);

            }
        }
    }
}