<commit_before><commit_msg>Added column event<commit_after><?php

use yii\db\Schema;
use yii\db\Migration;

class m150507_042527_add_column_gallery_image_public extends Migration
{
    public function up()
    {
 $sql = <<<SQL
ALTER TABLE "public".gallery_image ADD COLUMN NULLIF NOT EXISTS latitude DOUBLE PRECISION;
SQL;
        Yii::$app->db->createCommand($sql)->execute();
        $sql = <<<SQL
ALTER TABLE "public".gallery_image ADD COLUMN NULLIF NOT EXISTS longitude DOUBLE PRECISION;
SQL;
        Yii::$app->db->createCommand($sql)->execute();
        $sql = <<<SQL
ALTER TABLE "public".gallery_image ADD COLUMN NULLIF NOT EXISTS versions JSON;
SQL;
        Yii::$app->db->createCommand($sql)->execute();

        $sql = <<<SQL
ALTER TABLE "public".gallery_image ADD COLUMN NULLIF NOT EXISTS route CHARACTER VARYING (255);
SQL;
        Yii::$app->db->createCommand($sql)->execute();


        $sql = <<<SQL
ALTER TABLE "public".gallery_image ADD COLUMN NULLIF NOT EXISTS extension CHARACTER VARYING (255);
SQL;
        Yii::$app->db->createCommand($sql)->execute();
    }



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

        return false;
    }
    
    /*
    // Use safeUp/safeDown to run migration code within a transaction
    public function safeUp()
    {
    }
    
    public function safeDown()
    {
    }
    */
}

{'fraction_non_alphanumeric': 0.12340425531914893, 'fraction_numerical': 0.02127659574468085, 'mean_word_length': 3.2372372372372373, 'pattern_counts': {'":': 0, '<': 19, '<?xml version=': 0, '>': 18, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '7321892', 'n_tokens_mistral': 479, 'n_tokens_neox': 446, 'n_words': 116}