WAHAHAHA TOLOL

Back Back Up Advanced Editor

<?php

/**
 * Created by PhpStorm.
 * User: User
 * Date: 7/3/2017
 * Time: 4:09 PM
 */

namespace GDGallery\Database\Migrations;

use GDGallery\Core\Model as Model;
use GDGallery\Models\Gallery as Gallery;

class CreateGalleryTable
{
    public static function run()
    {
        global $wpdb;

$wpdb->query(
            "CREATE TABLE IF NOT EXISTS " . Gallery::getTableName() . "(
                `id_gallery` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
                `name` varchar(255) NULL,
                `description` text,
                `ordering` int(11) NOT NULL DEFAULT 0,
                `order_by` int(1) NOT NULL DEFAULT 0,
                `sort_by` int(1) NOT NULL DEFAULT 0,
                `show_title` int(1) NOT NULL DEFAULT 0,
                `display_type` int(1) NOT NULL DEFAULT 0,
                `view_type` int(1) NOT NULL DEFAULT 0,
                `position` ENUM('center','left','right') DEFAULT 'center',
                `hover_effect` int(1) NOT NULL DEFAULT 0,
                `items_per_page` int(3) NOT NULL DEFAULT 5,
                `custom_css` TEXT,
                `ctime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, 
                PRIMARY KEY (id_gallery)
            ) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci "
        );

if (!Model::isset_table_column(Gallery::getTableName(), "show_title")) {
            $wpdb->query("ALTER TABLE `" . Gallery::getTableName() . "` ADD `show_title` int(1) NOT NULL DEFAULT 0 AFTER `sort_by`");
        }

}
}