Migration_1_0.php — Independent Analytics – WordPress Analytics Plugin 2.12.2

independent-analytics / IAWP / Migrations / Migration_1_0.php

independent-analytics / IAWP / Migrations Last commit date

Migration_1_0.php

31 lines

1	<?php
2
3	namespace IAWP\Migrations;
4
5	use IAWP\Query;
6	/** @internal */
7	class Migration_1_0 extends \IAWP\Migrations\Migration
8	{
9	/**
10	* @var string
11	*/
12	protected $database_version = '1.0';
13	/**
14	* @return void
15	*/
16	protected function migrate() : void
17	{
18	global $wpdb;
19	$charset_collate = $wpdb->get_charset_collate();
20	$referrers_table = Query::get_table_name(Query::REFERRERS);
21	$wpdb->query("DROP TABLE IF EXISTS {$referrers_table}");
22	$wpdb->query("CREATE TABLE {$referrers_table} (\n id bigint(20) UNSIGNED AUTO_INCREMENT,\n url varchar(2048) NOT NULL,\n PRIMARY KEY (id)\n ) {$charset_collate}");
23	$views_table = Query::get_table_name(Query::VIEWS);
24	$wpdb->query("DROP TABLE IF EXISTS {$views_table}");
25	$wpdb->query("CREATE TABLE {$views_table} (\n id bigint(20) UNSIGNED AUTO_INCREMENT,\n referrer_id bigint(20) UNSIGNED,\n resource_id bigint(20) UNSIGNED NOT NULL,\n viewed_at datetime,\n PRIMARY KEY (id)\n ) {$charset_collate}");
26	$resources_table = Query::get_table_name(Query::RESOURCES);
27	$wpdb->query("DROP TABLE IF EXISTS {$resources_table}");
28	$wpdb->query("CREATE TABLE {$resources_table} (\n id bigint(20) UNSIGNED AUTO_INCREMENT,\n resource varchar(256) NOT NULL,\n page bigint(20) UNSIGNED NOT NULL DEFAULT 1,\n singular_id bigint(20) UNSIGNED,\n author_id bigint(20) UNSIGNED,\n date_archive varchar(256),\n search_query varchar(256),\n post_type varchar(256),\n term_id bigint(20) UNSIGNED,\n not_found_url varchar(256),\n cached_title varchar(256),\n cached_url varchar(256),\n cached_type varchar(256),\n cached_type_label varchar(256),\n cached_author_id bigint(20) UNSIGNED,\n cached_author varchar(256),\n cached_date varchar(256),\n PRIMARY KEY (id)\n ) {$charset_collate}");
29	}
30	}
31