Weimin Yu 4b1f4f96e3 Reorganize new schema changes (#1551) ...

* Reorganize new schema changes

Reorganized new schema changes and make each flyway script update a
single table.

Each flyway script is executed in a single database transaction so that
the script can be rolled back in one shot. It acquires a shared lock on
all tables touched by the script. This is deadlock-prone because in a
busy database, there may be user queries that attempt to lock the same
set of tables, but in different order. By limiting each script to one
table, we avoid the problem.

We should have some a presubmit check to enforce this rule.

All changes have been deployed to Sandbox out-of-band. When doing so,
we changed all CREATE INDEX statements to CREATE INDEX IF NOT EXISTS.

Future deployments should be able to proceed normally.

2022-03-09 20:47:24 -05:00

..

main

Reorganize new schema changes (#1551)

2022-03-09 20:47:24 -05:00

test

Enhance the test for forbidden Schema changes (#815)

2020-09-24 12:31:08 -04:00