Current File : /home/bravrvjk/itiministry.org/wp-content/plugins/give/src/Log/Migrations//CreateNewLogTable.php
<?php
namespace Give\Log\Migrations;
use Give\Framework\Database\DB;
use Give\Framework\Database\Exceptions\DatabaseQueryException;
use Give\Framework\Migrations\Contracts\Migration;
use Give\Framework\Migrations\Exceptions\DatabaseMigrationException;
/**
* Class CreateNewLogTables
* @package Give\Log\Migrations
*
* @since 2.10.0
*/
class CreateNewLogTable extends Migration
{
/**
* @return string
*/
public static function id()
{
return 'create_new_log_table';
}
/**
* @return string
*/
public static function title()
{
return esc_html__('Create new give_log table', 'give');
}
/**
* @return int
*/
public static function timestamp()
{
return strtotime('2021-01-28 12:00');
}
public function run()
{
global $wpdb;
$table = "{$wpdb->prefix}give_log";
$charset = DB::get_charset_collate();
$sql = "CREATE TABLE {$table} (
id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
log_type VARCHAR(16) NOT NULL,
data text NOT NULL,
category VARCHAR(64) NOT NULL,
source VARCHAR(64) NOT NULL,
date DATETIME NOT NULL,
PRIMARY KEY (id),
KEY log_type (log_type),
KEY category (category),
KEY source (source)
) {$charset}";
try {
DB::delta($sql);
} catch (DatabaseQueryException $exception) {
throw new DatabaseMigrationException('An error occurred while creating the give_log table', 0, $exception);
}
}
}
