<?php

defined('BASEPATH') OR exit('No direct script access allowed');

/*
        Add bandedges table in use for the dxcluster
*/

defined('BASEPATH') OR exit('No direct script access allowed');

class Migration_add_bandedges extends CI_Migration {

	public function up() {
		if (!$this->db->table_exists('bandedges')) {
			// Create the bandedges table
			$this->dbforge->add_field([
				'id' => [
					'type'           => 'INT',
					'constraint'     => 11,
					'unsigned'       => TRUE,
					'auto_increment' => TRUE,
				],
				'userid' => [
					'type'       => 'INT',
					'constraint' => 11,
				],
				'frequencyfrom' => [
					'type'       => 'BIGINT',
					'constraint' => 20,
				],
				'frequencyto' => [
					'type'       => 'BIGINT',
					'constraint' => 20,
				],
				'mode' => [
					'type'       => 'VARCHAR',
					'constraint' => 20,
				],
			]);

			$this->dbforge->add_key('id', TRUE);
			$this->dbforge->create_table('bandedges');

			// Insert initial data (for all users: userid = -1)
			$data = [
				['userid' => -1, 'frequencyfrom' => 135700,    'frequencyto' => 135800,    'mode' => 'cw'],
				['userid' => -1, 'frequencyfrom' => 472000,    'frequencyto' => 479000,    'mode' => 'cw'],
				['userid' => -1, 'frequencyfrom' => 501000,    'frequencyto' => 504000,    'mode' => 'cw'],
				['userid' => -1, 'frequencyfrom' => 1800000,   'frequencyto' => 1837999,   'mode' => 'cw'],
				['userid' => -1, 'frequencyfrom' => 1838000,   'frequencyto' => 1839999,   'mode' => 'digi'],
				['userid' => -1, 'frequencyfrom' => 1840000,   'frequencyto' => 2000000,   'mode' => 'phone'],
				['userid' => -1, 'frequencyfrom' => 3500000,   'frequencyto' => 3569999,   'mode' => 'cw'],
				['userid' => -1, 'frequencyfrom' => 3570000,   'frequencyto' => 3599999,   'mode' => 'digi'],
				['userid' => -1, 'frequencyfrom' => 3600000,   'frequencyto' => 4000000,   'mode' => 'phone'],
				['userid' => -1, 'frequencyfrom' => 5260000,   'frequencyto' => 5339999,   'mode' => 'cw'],
				['userid' => -1, 'frequencyfrom' => 5340000,   'frequencyto' => 5360000,   'mode' => 'digi'],
				['userid' => -1, 'frequencyfrom' => 5370000,   'frequencyto' => 5410000,   'mode' => 'phone'],
				['userid' => -1, 'frequencyfrom' => 7000000,   'frequencyto' => 7039999,   'mode' => 'cw'],
				['userid' => -1, 'frequencyfrom' => 7040000,   'frequencyto' => 7049999,   'mode' => 'digi'],
				['userid' => -1, 'frequencyfrom' => 7050000,   'frequencyto' => 7300000,   'mode' => 'phone'],
				['userid' => -1, 'frequencyfrom' => 10100000,  'frequencyto' => 10129999,  'mode' => 'cw'],
				['userid' => -1, 'frequencyfrom' => 10130000,  'frequencyto' => 10150000,  'mode' => 'digi'],
				['userid' => -1, 'frequencyfrom' => 14000000,  'frequencyto' => 14069999,  'mode' => 'cw'],
				['userid' => -1, 'frequencyfrom' => 14070000,  'frequencyto' => 14124999,  'mode' => 'digi'],
				['userid' => -1, 'frequencyfrom' => 14125000,  'frequencyto' => 14350000,  'mode' => 'phone'],
				['userid' => -1, 'frequencyfrom' => 18068000,  'frequencyto' => 18094999,  'mode' => 'cw'],
				['userid' => -1, 'frequencyfrom' => 18095000,  'frequencyto' => 18109000,  'mode' => 'digi'],
				['userid' => -1, 'frequencyfrom' => 18111000,  'frequencyto' => 18168000,  'mode' => 'phone'],
				['userid' => -1, 'frequencyfrom' => 21000000,  'frequencyto' => 21069999,  'mode' => 'cw'],
				['userid' => -1, 'frequencyfrom' => 21070000,  'frequencyto' => 21110000,  'mode' => 'digi'],
				['userid' => -1, 'frequencyfrom' => 21125000,  'frequencyto' => 21450000,  'mode' => 'phone'],
				['userid' => -1, 'frequencyfrom' => 24890000,  'frequencyto' => 24914999,  'mode' => 'cw'],
				['userid' => -1, 'frequencyfrom' => 24915000,  'frequencyto' => 24929000,  'mode' => 'digi'],
				['userid' => -1, 'frequencyfrom' => 24931000,  'frequencyto' => 24990000,  'mode' => 'phone'],
				['userid' => -1, 'frequencyfrom' => 28000000,  'frequencyto' => 28069999,  'mode' => 'cw'],
				['userid' => -1, 'frequencyfrom' => 28070000,  'frequencyto' => 28120000,  'mode' => 'digi'],
				['userid' => -1, 'frequencyfrom' => 28225000,  'frequencyto' => 29700000,  'mode' => 'phone'],
				['userid' => -1, 'frequencyfrom' => 50000000,  'frequencyto' => 50109000,  'mode' => 'cw'],
				['userid' => -1, 'frequencyfrom' => 50110000,  'frequencyto' => 50229000,  'mode' => 'phone'],
				['userid' => -1, 'frequencyfrom' => 50230000,  'frequencyto' => 50320000,  'mode' => 'digi'],
				['userid' => -1, 'frequencyfrom' => 69900000,  'frequencyto' => 70100000,  'mode' => 'cw'],
				['userid' => -1, 'frequencyfrom' => 70250000,  'frequencyto' => 70500000,  'mode' => 'phone'],
				['userid' => -1, 'frequencyfrom' => 70154000,  'frequencyto' => 70155000,  'mode' => 'digi'],
				['userid' => -1, 'frequencyfrom' => 144000000, 'frequencyto' => 144164999, 'mode' => 'cw'],
				['userid' => -1, 'frequencyfrom' => 144174000, 'frequencyto' => 144174999, 'mode' => 'digi'],
				['userid' => -1, 'frequencyfrom' => 144165000, 'frequencyto' => 144173999, 'mode' => 'phone'],
				['userid' => -1, 'frequencyfrom' => 144175000, 'frequencyto' => 148000000, 'mode' => 'phone'],
				['userid' => -1, 'frequencyfrom' => 432000000, 'frequencyto' => 432099999, 'mode' => 'cw'],
				['userid' => -1, 'frequencyfrom' => 432100000, 'frequencyto' => 438000000, 'mode' => 'phone'],
			];

			$this->db->insert_batch('bandedges', $data);
		}
	}

	public function down() {
		if ($this->db->table_exists('bandedges')) {
			$this->dbforge->drop_table('bandedges');
		}
	}
}