<?php namespace flow\db\migrations;

[0] Fix | Delete

use la\core\db\LADDLUtils;

[1] Fix | Delete

use la\core\db\migrations\ILADBMigration;

[2] Fix | Delete

[3] Fix | Delete

if ( ! defined( 'WPINC' ) ) die;

[4] Fix | Delete

/**

[5] Fix | Delete

* Flow-Flow.

[6] Fix | Delete

*

[7] Fix | Delete

* @package FlowFlow

[8] Fix | Delete

* @author Looks Awesome <email@looks-awesome.com>

[9] Fix | Delete

*

[10] Fix | Delete

* @link http://looks-awesome.com

[11] Fix | Delete

* @copyright Looks Awesome

[12] Fix | Delete

*/

[13] Fix | Delete

class FFMigration_2_3 implements ILADBMigration{

[14] Fix | Delete

[15] Fix | Delete

public function version() {

[16] Fix | Delete

return '2.3';

[17] Fix | Delete

}

[18] Fix | Delete

[19] Fix | Delete

public function execute($conn, $manager) {

[20] Fix | Delete

if (!LADDLUtils::existTable($conn, $manager->image_cache_table_name)){

[21] Fix | Delete

$charset_collate = '';

[22] Fix | Delete

$charset = LADDLUtils::charset();

[23] Fix | Delete

if ( !empty( $charset ) ) {

[24] Fix | Delete

$charset_collate = "DEFAULT CHARACTER SET {$charset}";

[25] Fix | Delete

}

[26] Fix | Delete

$collate = LADDLUtils::collate();

[27] Fix | Delete

if ( !empty( $collate ) ) {

[28] Fix | Delete

$charset_collate .= " COLLATE {$collate}";

[29] Fix | Delete

}

[30] Fix | Delete

[31] Fix | Delete

$sql = "CREATE TABLE ?n ( `url` VARCHAR(50) NOT NULL, `width` INT, `height` INT, `creation_time` TIMESTAMP DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`url`) ) $charset_collate";

[32] Fix | Delete

$conn->query($sql, $manager->image_cache_table_name);

[33] Fix | Delete

}

[34] Fix | Delete

[35] Fix | Delete

LADDLUtils::addColumnIfNotExist($conn, $manager->table_prefix . 'snapshots', 'dump', 'BLOB NULL');

[36] Fix | Delete

}

[37] Fix | Delete

}

[38] Fix | Delete