diff options
| author | Michael Kozono <mkozono@gmail.com> | 2017-07-22 00:49:04 +0300 |
|---|---|---|
| committer | Michael Kozono <mkozono@gmail.com> | 2017-08-15 19:05:31 +0300 |
| commit | cf90f4ab512ee96ed1b710573020d4b6ef1285b1 (patch) | |
| tree | 64cf6dae8c053c90e5295a324ac7ccf9a68ed52c | |
| parent | 4c1c799998ef4bc2ab4676c22554824b3f4ae361 (diff) | |
Add group_id foreign key
| -rw-r--r-- | db/migrate/20170721214029_add_group_access_requests_group_foreign_key.rb | 18 | ||||
| -rw-r--r-- | db/schema.rb | 1 |
2 files changed, 19 insertions, 0 deletions
diff --git a/db/migrate/20170721214029_add_group_access_requests_group_foreign_key.rb b/db/migrate/20170721214029_add_group_access_requests_group_foreign_key.rb new file mode 100644 index 00000000000..4a24f6f915a --- /dev/null +++ b/db/migrate/20170721214029_add_group_access_requests_group_foreign_key.rb @@ -0,0 +1,18 @@ +# See http://doc.gitlab.com/ce/development/migration_style_guide.html +# for more information on how to write migrations for GitLab. + +class AddGroupAccessRequestsGroupForeignKey < ActiveRecord::Migration + include Gitlab::Database::MigrationHelpers + + disable_ddl_transaction! + + DOWNTIME = false + + def up + add_concurrent_foreign_key :group_access_requests, :namespaces, column: :group_id, on_delete: :cascade + end + + def down + remove_foreign_key :group_access_requests, column: :group_id + end +end diff --git a/db/schema.rb b/db/schema.rb index 26a00fa93f6..22746861c07 100644 --- a/db/schema.rb +++ b/db/schema.rb @@ -1707,6 +1707,7 @@ ActiveRecord::Schema.define(version: 20170809161910) do add_foreign_key "gpg_keys", "users", on_delete: :cascade add_foreign_key "gpg_signatures", "gpg_keys", on_delete: :nullify add_foreign_key "gpg_signatures", "projects", on_delete: :cascade + add_foreign_key "group_access_requests", "namespaces", column: "group_id", name: "fk_74acbd4b2f", on_delete: :cascade add_foreign_key "group_access_requests", "users", on_delete: :cascade add_foreign_key "issue_assignees", "issues", name: "fk_b7d881734a", on_delete: :cascade add_foreign_key "issue_assignees", "users", name: "fk_5e0c8d9154", on_delete: :cascade |