migration_260

Complexity

Total Complexity

6

Size/Duplication

Total Lines	45
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	3

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	getVersion()	0	4	1
A	getReleaseNotes()	0	4	1

<?php
namespace SymphonyCms\Installer\Migrations;

use SymphonyCms\Installer\Lib\Migration;
use Symphony;
use Exception;

class migration_260 extends Migration
{
    public static function getVersion()
    {
        return '2.6.0';
    }

    public static function getReleaseNotes()
    {
        return 'http://getsymphony.com/download/releases/version/2.6.0/';
    }

    public static function upgrade()
    {
        // Add date field options
        try {
            Symphony::Database()->query('
                ALTER TABLE `tbl_fields_date`
                ADD `calendar` ENUM("yes","no") COLLATE utf8_unicode_ci NOT NULL DEFAULT "no",
                ADD `time` ENUM("yes","no") COLLATE utf8_unicode_ci NOT NULL DEFAULT "yes";
            ');
        } catch (Exception $ex) {
        }

        // Add namespace field to the cache table. RE: #2162
        try {
            Symphony::Database()->query('
                ALTER TABLE `tbl_cache` ADD `namespace` VARCHAR(255) COLLATE utf8_unicode_ci;
            ');
        } catch (Exception $ex) {
        }

        // Add UNIQUE key constraint to the `hash` RE: #2163
        try {
            Symphony::Database()->import('
                ALTER TABLE `tbl_cache` DROP INDEX `hash`;
                ALTER TABLE `tbl_cache` ADD UNIQUE INDEX `hash` (`hash`)
            ');
        } catch (Exception $ex) {
        }

        // Update the version information
        return parent::upgrade();
    }
}