SymphonyCms\Installer\Migrations\migration_260::upgrade()

Complexity

Conditions	4
Paths	8

Size

Total Lines	32
Code Lines	11

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	1	Features	0

<?php
    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();
    }
}