diff options
author | Peter Leitzen <pleitzen@gitlab.com> | 2019-09-06 12:49:44 +0200 |
---|---|---|
committer | Peter Leitzen <pleitzen@gitlab.com> | 2019-09-12 14:41:46 +0200 |
commit | ec12fc4d1a086d9c06192afeb94ca2d3a6d2a867 (patch) | |
tree | 2bc067bc66790905081ba7dc1f9d175124ee81a7 | |
parent | 1928932388f063b064dde9d235b6474121a726c0 (diff) | |
download | gitlab-ce-generic-alertsettings-model.tar.gz |
Create table `alerts_service_data`generic-alertsettings-model
This table contains data for the `AlertsService` avoiding the usage of
properties.
-rw-r--r-- | changelogs/unreleased/generic-alertsettings-model.yml | 5 | ||||
-rw-r--r-- | db/migrate/20190906104555_create_alerts_service_data.rb | 15 | ||||
-rw-r--r-- | db/schema.rb | 10 |
3 files changed, 30 insertions, 0 deletions
diff --git a/changelogs/unreleased/generic-alertsettings-model.yml b/changelogs/unreleased/generic-alertsettings-model.yml new file mode 100644 index 00000000000..958323ce100 --- /dev/null +++ b/changelogs/unreleased/generic-alertsettings-model.yml @@ -0,0 +1,5 @@ +--- +title: Create table `alerts_service_data` +merge_request: 32860 +author: +type: added diff --git a/db/migrate/20190906104555_create_alerts_service_data.rb b/db/migrate/20190906104555_create_alerts_service_data.rb new file mode 100644 index 00000000000..8ce447a67d1 --- /dev/null +++ b/db/migrate/20190906104555_create_alerts_service_data.rb @@ -0,0 +1,15 @@ +# frozen_string_literal: true + +class CreateAlertsServiceData < ActiveRecord::Migration[5.2] + DOWNTIME = false + + def change + create_table :alerts_service_data do |t| + t.references :service, type: :integer, index: true, null: false, + foreign_key: { on_delete: :cascade } + t.timestamps_with_timezone + t.string :encrypted_token, limit: 255 + t.string :encrypted_token_iv, limit: 255 + end + end +end diff --git a/db/schema.rb b/db/schema.rb index 39faf1e651e..cdeec6ff59a 100644 --- a/db/schema.rb +++ b/db/schema.rb @@ -26,6 +26,15 @@ ActiveRecord::Schema.define(version: 2019_09_12_061145) do t.integer "cached_markdown_version" end + create_table "alerts_service_data", force: :cascade do |t| + t.integer "service_id", null: false + t.datetime_with_timezone "created_at", null: false + t.datetime_with_timezone "updated_at", null: false + t.string "encrypted_token", limit: 255 + t.string "encrypted_token_iv", limit: 255 + t.index ["service_id"], name: "index_alerts_service_data_on_service_id" + end + create_table "allowed_email_domains", force: :cascade do |t| t.datetime_with_timezone "created_at", null: false t.datetime_with_timezone "updated_at", null: false @@ -3740,6 +3749,7 @@ ActiveRecord::Schema.define(version: 2019_09_12_061145) do t.index ["type"], name: "index_web_hooks_on_type" end + add_foreign_key "alerts_service_data", "services", on_delete: :cascade add_foreign_key "allowed_email_domains", "namespaces", column: "group_id", on_delete: :cascade add_foreign_key "analytics_cycle_analytics_group_stages", "labels", column: "end_event_label_id", on_delete: :cascade add_foreign_key "analytics_cycle_analytics_group_stages", "labels", column: "start_event_label_id", on_delete: :cascade |