FM / Migrations

/var/www/vhosts/ihelp.ro/ajutam.ro/wp-content/plugins/give/src/Log/Migrations/

/var/www/vhosts/ihelp.ro/ajutam.ro/wp-content/plugins/give/src/Log/Migrations

Name	Size	Mode	Actions
CreateNewLogTable.php	1529	0644	edit dl rm
DeleteOldLogTables.php	903	0644	edit dl rm
MigrateExistingLogs.php	3848	0644	edit dl rm

Edit: /var/www/vhosts/ihelp.ro/ajutam.ro/wp-content/plugins/give/src/Log/Migrations/CreateNewLogTable.php (1529B)

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

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); } } }