m190926_110717_hit_counter__table

Complexity

Total Complexity

3

Size/Duplication

Total Lines	78
Duplicated Lines	0 %

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	safeUp()	0	64	2
A	safeDown()	0	4	1

<?php

use yii\db\Migration;

/**
 * Class m190926_110717_hit_counter__table
 */
class m190926_110717_hit_counter__table extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        $tableOptions = null;
        if ('mysql' === $this->db->driverName) {
            $tableOptions = 'CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE=InnoDB';
        }

        $this->createTable('{{%hit_counter}}', [
            'id' => $this->primaryKey()->unsigned(),
            'counter_id' => $this->string()->notNull(),
            'cookie_mark'=> $this->char(32)->null(),
            'js_cookei_enabled' => $this->boolean()->notNull()->defaultValue(0),
            'js_java_enabled' => $this->boolean()->notNull()->defaultValue(0),
            'js_timezone_offset' => $this->integer()->null(),
            'js_timezone' => $this->string()->null(),
            'js_connection' => $this->string()->null(),
            'js_current_url' => $this->text()->null(),
            'js_referer_url' => $this->text()->null(),
            'js_screen_width' => $this->integer()->null(),
            'js_screen_height' => $this->integer()->null(),
            'js_color_depth' => $this->integer()->null(),
            'js_browser_language' => $this->string()->null(),
            'js_history_length' => $this->integer()->null(),
            'js_is_toutch_device' => $this->boolean()->notNull()->defaultValue(0),
            'js_processor_ram' => $this->integer()->null(),

            'serv_ip' => $this->char(20)->null(),
            'serv_user_agent' => $this->text()->null(),
            'serv_referer_url' => $this->text()->null(),
            'serv_server_name' => $this->string()->null(),
            'serv_auth_user_id' => $this->integer()->unsigned()->null(),
            'serv_port' => $this->integer()->unsigned()->null(),
            'serv_cookies' => 'JSON',
            
            'serv_os' => $this->string()->null(),
            'serv_client' => $this->string()->null(),
            'serv_device' => $this->string()->null(),
            'serv_brand' => $this->string()->null(),
            'serv_model' => $this->string()->null(),
            'serv_bot' => $this->string()->null(),
            'serv_host_by_ip' => $this->string()->null(),
            'serv_is_proxy_or_vpn' => $this->boolean()->notNull()->defaultValue(0),

            'created_at' => $this->dateTime()->notNull(),
        ], $tableOptions);

        $this->createIndex('{{%idx-hit_counter-cookie_mark}}', '{{%hit_counter}}', 'cookie_mark');
        $this->createIndex('{{%idx-hit_counter-serv_ip}}', '{{%hit_counter}}', 'serv_ip');
        $this->createIndex('{{%idx-hit_counter-serv_auth_user_id}}', '{{%hit_counter}}', 'serv_auth_user_id');
        $this->createIndex('{{%idx-hit_counter-created_at}}', '{{%hit_counter}}', 'created_at');

        $this->addForeignKey(
            '{{%fk-hit_counter-serv_auth_user_id}}',
            '{{%hit_counter}}',
            'serv_auth_user_id',
            '{{%user}}',
            'id',
            'RESTRICT',
            'CASCADE'
        );

        $this->addCommentOnColumn('{{%hit_counter}}', 'serv_auth_user_id', 'User id if exists');
        $this->addCommentOnColumn('{{%hit_counter}}', 'serv_ip', 'User ip');
        $this->addCommentOnColumn('{{%hit_counter}}', 'counter_id', 'Counter id generated in widget and passed by query param in inage src');
    }

    /**
     * {@inheritdoc}
     */
    public function safeDown()
    {
        $this->dropTable('{{%hit_counter}}');
        echo "m190926_110717_hit_counter__table dropped.\n";
        // echo "m190926_110717_hit_counter__table cannot be reverted.\n";

        // return false;
    }

    /*
    // Use up()/down() to run migration code without a transaction.
    public function up()
    {

    }

    public function down()
    {
        echo "m190926_110717_hit_counter__table cannot be reverted.\n";

        return false;
    }
    */
}