notifications-api

darkhelm/notifications-api

Fork 0

mirror of https://github.com/GSA/notifications-api.git synced 2026-09-10 18:23:01 -04:00

Commit Graph

Author	SHA1	Message	Date
Rebecca Law	490efad97a	To avoid any table locks and contention on the production database we are going to add the unique index concurrently. This only works if we execute a commit first.	2021-04-23 15:16:18 +01:00
Rebecca Law	a637c8eb92	Add unique key on annual_billing for service_id + financial_year_start. This is an extra precaution for the table to ensure data integrity. Since we only update/insert the data using the annual_billing_dao methods the integrity is in tact. I've check the data on preview, staging and prod there are no violations of this unique key.	2021-04-20 13:42:20 +01:00

Author

SHA1

Message

Date

Rebecca Law

490efad97a

To avoid any table locks and contention on the production database we

are going to add the unique index concurrently. This only works if we
execute a commit first.

2021-04-23 15:16:18 +01:00

Rebecca Law

a637c8eb92

Add unique key on annual_billing for service_id + financial_year_start.

This is an extra precaution for the table to ensure data integrity. Since we only update/insert the data using the annual_billing_dao methods the integrity is in tact. I've check the data on preview, staging and prod there are no violations of this unique key.

2021-04-20 13:42:20 +01:00