Add new table subscription_members_add_on_assignments
What does this MR do and why?
Adds new table subscription_members_add_on_assignments
This commit adds new table 'subscription_members_add_on_assignments' to store information on assigned add ons to namespace members by the owners.
Related to #411967
Changelog: added
Migrations
Migrate
$ bin/rails db:migrate:up:main VERSION=20230612151118
WARNING: This version of GitLab depends on gitlab-shell 14.23.0, but you're running 14.19.0. Please update gitlab-shell.
main: == [advisory_lock_connection] object_id: 228060, pg_backend_pid: 74387
main: == 20230612151118 CreateSubscriptionMembersAddOnAssignments: migrating ========
main: -- create_table(:subscription_members_add_on_assignments)
main: -> 0.0059s
main: == 20230612151118 CreateSubscriptionMembersAddOnAssignments: migrated (0.1186s)
main: == [advisory_lock_connection] object_id: 228060, pg_backend_pid: 74387
$ bin/rails db:migrate:up:main VERSION=20230612203305
WARNING: This version of GitLab depends on gitlab-shell 14.23.0, but you're running 14.19.0. Please update gitlab-shell.
main: == [advisory_lock_connection] object_id: 228060, pg_backend_pid: 74842
main: == 20230612203305 AddForeignKeyMemberIdOnSubscriptionMembersAddOnAssignments: migrating
main: -- transaction_open?()
main: -> 0.0000s
main: -- transaction_open?()
main: -> 0.0000s
main: -- execute("ALTER TABLE subscription_members_add_on_assignments ADD CONSTRAINT fk_b94eeb74c9 FOREIGN KEY (member_id) REFERENCES members (id) ON DELETE CASCADE NOT VALID;")
main: -> 0.0011s
main: -- execute("SET statement_timeout TO 0")
main: -> 0.0004s
main: -- execute("ALTER TABLE subscription_members_add_on_assignments VALIDATE CONSTRAINT fk_b94eeb74c9;")
main: -> 0.0023s
main: -- execute("RESET statement_timeout")
main: -> 0.0004s
main: == 20230612203305 AddForeignKeyMemberIdOnSubscriptionMembersAddOnAssignments: migrated (0.1363s)
main: == [advisory_lock_connection] object_id: 228060, pg_backend_pid: 74842
$ bin/rails db:migrate:up:main VERSION=20230612203331
WARNING: This version of GitLab depends on gitlab-shell 14.23.0, but you're running 14.19.0. Please update gitlab-shell.
main: == [advisory_lock_connection] object_id: 228080, pg_backend_pid: 75317
main: == 20230612203331 AddForeignKeyAddOnPurchaseIdOnSubscriptionMembersAddOnAssignments: migrating
main: -- transaction_open?()
main: -> 0.0000s
main: -- transaction_open?()
main: -> 0.0000s
main: -- execute("ALTER TABLE subscription_members_add_on_assignments ADD CONSTRAINT fk_ccd3d7438f FOREIGN KEY (subscription_add_on_purchase_id) REFERENCES subscription_add_on_purchases (id) ON DELETE CASCADE NOT VALID;")
main: -> 0.0032s
main: -- execute("SET statement_timeout TO 0")
main: -> 0.0018s
main: -- execute("ALTER TABLE subscription_members_add_on_assignments VALIDATE CONSTRAINT fk_ccd3d7438f;")
main: -> 0.0036s
main: -- execute("RESET statement_timeout")
main: -> 0.0004s
main: == 20230612203331 AddForeignKeyAddOnPurchaseIdOnSubscriptionMembersAddOnAssignments: migrated (0.1414s)
main: == [advisory_lock_connection] object_id: 228080, pg_backend_pid: 75317
Rollback
$ bin/rails db:migrate:down:main VERSION=20230612203331
WARNING: This version of GitLab depends on gitlab-shell 14.23.0, but you're running 14.19.0. Please update gitlab-shell.
main: == [advisory_lock_connection] object_id: 227760, pg_backend_pid: 73038
main: == 20230612203331 AddForeignKeyAddOnPurchaseIdOnSubscriptionMembersAddOnAssignments: reverting
main: -- transaction_open?()
main: -> 0.0000s
main: -- remove_foreign_key(:subscription_members_add_on_assignments, {:column=>:subscription_add_on_purchase_id})
main: -> 0.0747s
main: == 20230612203331 AddForeignKeyAddOnPurchaseIdOnSubscriptionMembersAddOnAssignments: reverted (0.0891s)
main: == [advisory_lock_connection] object_id: 227760, pg_backend_pid: 73038
$ bin/rails db:migrate:down:main VERSION=20230612203305
WARNING: This version of GitLab depends on gitlab-shell 14.23.0, but you're running 14.19.0. Please update gitlab-shell.
main: == [advisory_lock_connection] object_id: 228060, pg_backend_pid: 73477
main: == 20230612203305 AddForeignKeyMemberIdOnSubscriptionMembersAddOnAssignments: reverting
main: -- transaction_open?()
main: -> 0.0000s
main: -- remove_foreign_key(:subscription_members_add_on_assignments, {:column=>:member_id})
main: -> 0.0964s
main: == 20230612203305 AddForeignKeyMemberIdOnSubscriptionMembersAddOnAssignments: reverted (0.1238s)
main: == [advisory_lock_connection] object_id: 228060, pg_backend_pid: 73477
$ bin/rails db:migrate:down:main VERSION=20230612151118
WARNING: This version of GitLab depends on gitlab-shell 14.23.0, but you're running 14.19.0. Please update gitlab-shell.
main: == [advisory_lock_connection] object_id: 228080, pg_backend_pid: 73910
main: == 20230612151118 CreateSubscriptionMembersAddOnAssignments: reverting ========
main: -- drop_table(:subscription_members_add_on_assignments)
main: -> 0.0022s
main: == 20230612151118 CreateSubscriptionMembersAddOnAssignments: reverted (0.0075s)
main: == [advisory_lock_connection] object_id: 228080, pg_backend_pid: 73910
MR acceptance checklist
This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.
-
I have evaluated the MR acceptance checklist for this MR.
Edited by Bishwa Hang Rai