diff options
Diffstat (limited to 'db/migrate/20191119231621_create_container_expiration_policies.rb')
-rw-r--r-- | db/migrate/20191119231621_create_container_expiration_policies.rb | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/db/migrate/20191119231621_create_container_expiration_policies.rb b/db/migrate/20191119231621_create_container_expiration_policies.rb new file mode 100644 index 00000000000..d7108870cf1 --- /dev/null +++ b/db/migrate/20191119231621_create_container_expiration_policies.rb @@ -0,0 +1,21 @@ +# frozen_string_literal: true + +class CreateContainerExpirationPolicies < ActiveRecord::Migration[5.2] + DOWNTIME = false + + def change + create_table :container_expiration_policies, id: false, primary_key: :project_id do |t| + t.timestamps_with_timezone null: false + t.datetime_with_timezone :next_run_at + t.references :project, primary_key: true, default: nil, index: false, foreign_key: { on_delete: :cascade } + t.string :name_regex, limit: 255 + t.string :cadence, null: false, limit: 12, default: '7d' + t.string :older_than, limit: 12 + t.integer :keep_n + t.boolean :enabled, null: false, default: false + end + + add_index :container_expiration_policies, [:next_run_at, :enabled], + name: 'index_container_expiration_policies_on_next_run_at_and_enabled' + end +end |