Migration_16.php — Independent Analytics – WordPress Analytics Plugin 2.8.4

independent-analytics / IAWP / Migrations / Migration_16.php

independent-analytics / IAWP / Migrations Last commit date

Migration_16.php

29 lines

1	<?php
2
3	namespace IAWP\Migrations;
4
5	use IAWP\Query;
6	/** @internal */
7	class Migration_16 extends \IAWP\Migrations\Migration
8	{
9	/**
10	* @var string
11	*/
12	protected $database_version = '16';
13	/**
14	* @return void
15	*/
16	protected function migrate() : void
17	{
18	$this->create_reports_table();
19	}
20	private function create_reports_table() : void
21	{
22	global $wpdb;
23	$charset_collate = $wpdb->get_charset_collate();
24	$reports_table = Query::get_table_name(Query::REPORTS);
25	$wpdb->query("DROP TABLE IF EXISTS {$reports_table}");
26	$wpdb->query("CREATE TABLE {$reports_table} (\n report_id bigint(20) UNSIGNED AUTO_INCREMENT,\n user_created_report boolean NOT NULL DEFAULT true,\n name varchar(255) NOT NULL,\n type varchar(64) NOT NULL,\n exact_start datetime,\n exact_end datetime,\n relative_range_id varchar(64),\n sort_column varchar(64),\n sort_direction varchar(64),\n group_name varchar(64),\n chart_interval varchar(64),\n columns text,\n filters text,\n visible_datasets text,\n position int,\n PRIMARY KEY (report_id)\n ) {$charset_collate}");
27	}
28	}
29