Skip to content

Add seats_in_use and seats_owed to gitlab_subscriptions

Mark Chao requested to merge store-seats_currently_in_use into master

What does this MR do?

Add seats_in_use and seats_owed to gitlab_subscriptions table for data warehouse analysis.

Later MRs would store calculated values in these columns.

Part of customers-gitlab-com#1641 (closed)

Migration

== 20200827085101 AddSeatsCurrentlyInUseInGitlabSubscriptions: migrating ======
-- add_column(:gitlab_subscriptions, :seats_in_use, :integer, {:default=>0, :null=>false})
   -> 0.0040s
-- add_column(:gitlab_subscriptions, :seats_owed, :integer, {:default=>0, :null=>false})
   -> 0.0017s
== 20200827085101 AddSeatsCurrentlyInUseInGitlabSubscriptions: migrated (0.0227s)
== 20200827085101 AddSeatsCurrentlyInUseInGitlabSubscriptions: reverting ======
-- remove_column(:gitlab_subscriptions, :seats_in_use)
   -> 0.0033s
-- remove_column(:gitlab_subscriptions, :seats_owed)
   -> 0.0008s
== 20200827085101 AddSeatsCurrentlyInUseInGitlabSubscriptions: reverted (0.0180s)

Does this MR meet the acceptance criteria?

Conformity

Availability and Testing

Edited by Mark Chao

Merge request reports