Migration_3.php — Independent Analytics – WordPress Analytics Plugin 2.8.4

independent-analytics / IAWP / Migrations / Migration_3.php

independent-analytics / IAWP / Migrations Last commit date

Migration_3.php

30 lines

1	<?php
2
3	namespace IAWP\Migrations;
4
5	use IAWP\Query;
6	/** @internal */
7	class Migration_3 extends \IAWP\Migrations\Migration
8	{
9	/**
10	* @var string
11	*/
12	protected $database_version = '3';
13	/**
14	* @return void
15	*/
16	protected function migrate() : void
17	{
18	global $wpdb;
19	$charset_collate = $wpdb->get_charset_collate();
20	$campaigns_table = Query::get_table_name(Query::CAMPAIGNS);
21	$wpdb->query("DROP TABLE IF EXISTS {$campaigns_table}");
22	$wpdb->query("CREATE TABLE {$campaigns_table} (\n campaign_id bigint(20) UNSIGNED AUTO_INCREMENT,\n utm_source varchar(2048) NOT NULL, \n utm_medium varchar(2048) NOT NULL,\n utm_campaign varchar(2048) NOT NULL,\n utm_term varchar(2048),\n utm_content varchar(2048),\n PRIMARY KEY (campaign_id)\n ) {$charset_collate}");
23	$campaign_urls_table = Query::get_table_name(Query::CAMPAIGN_URLS);
24	$wpdb->query("DROP TABLE IF EXISTS {$campaign_urls_table}");
25	$wpdb->query("CREATE TABLE {$campaign_urls_table} (\n campaign_url_id bigint(20) UNSIGNED AUTO_INCREMENT,\n path varchar(2048), \n utm_source varchar(2048) NOT NULL, \n utm_medium varchar(2048) NOT NULL,\n utm_campaign varchar(2048) NOT NULL,\n utm_term varchar(2048),\n utm_content varchar(2048),\n created_at datetime NOT NULL,\n PRIMARY KEY (campaign_url_id)\n ) {$charset_collate}");
26	$views_table = Query::get_table_name(Query::VIEWS);
27	$wpdb->query("\n ALTER TABLE {$views_table}\n ADD (\n campaign_id bigint(20) UNSIGNED\n )\n ");
28	}
29	}
30