diff options
Diffstat (limited to 'db/ci_migrate/20210617101848_create_ci_instance_variables_on_ci.rb')
-rw-r--r-- | db/ci_migrate/20210617101848_create_ci_instance_variables_on_ci.rb | 31 |
1 files changed, 31 insertions, 0 deletions
diff --git a/db/ci_migrate/20210617101848_create_ci_instance_variables_on_ci.rb b/db/ci_migrate/20210617101848_create_ci_instance_variables_on_ci.rb new file mode 100644 index 00000000000..7274e6bcdf2 --- /dev/null +++ b/db/ci_migrate/20210617101848_create_ci_instance_variables_on_ci.rb @@ -0,0 +1,31 @@ +# frozen_string_literal: true + +class CreateCiInstanceVariablesOnCi < ActiveRecord::Migration[6.1] + include Gitlab::Database::MigrationHelpers + + disable_ddl_transaction! + + def up + unless table_exists?(:ci_instance_variables) + create_table :ci_instance_variables do |t| + t.integer :variable_type, null: false, limit: 2, default: 1 + t.boolean :masked, default: false, allow_null: false + t.boolean :protected, default: false, allow_null: false + t.text :key, null: false + t.text :encrypted_value + t.text :encrypted_value_iv + + t.index [:key], name: 'index_ci_instance_variables_on_key', unique: true, using: :btree + end + end + + add_text_limit(:ci_instance_variables, :key, 255) + # Use constraint_name generated from db/migrate/20200625193358_increase_size_on_instance_level_variable_values.rb + add_text_limit(:ci_instance_variables, :encrypted_value, 13_579, constraint_name: 'check_956afd70f1') + add_text_limit(:ci_instance_variables, :encrypted_value_iv, 255) + end + + def down + drop_table :ci_instance_variables + end +end |