# give/4.16.9/src/Log/Migrations/CreateNewLogTable.php

GiveWP – Donation Plugin and Fundraising Platform, version 4.16.9. 69 lines.

- Page: https://pluginprobe.com/plugins/give/4.16.9/code/src/Log/Migrations/CreateNewLogTable.php
- Raw: https://pluginprobe.com/plugins/give/4.16.9/raw/src/Log/Migrations/CreateNewLogTable.php
- Modified: 2021-11-23T23:55:18+00:00

Line numbers below start at 1. Link to a line or a range by appending a fragment to the
page URL, for example `https://pluginprobe.com/plugins/give/4.16.9/code/src/Log/Migrations/CreateNewLogTable.php#L10-L20`.

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

```