OHSUCMP / coach

web application frontend for OHSU HTN U18 grant
2 stars 0 forks source link

update SQL Server flyway migrations #226

Closed mattStorer closed 6 days ago

mattStorer commented 6 days ago

MU is encountering an issue in flyway migrations that is due to the alter table syntax not being correct.

looks like this:

alter table home_pulse_reading modify source varchar(10) not null;

needs to be this:

alter table home_pulse_reading alter column source varchar(10) not null;

mattStorer commented 6 days ago

tested these migrations in a SQL server environment as they would be executed by Flyway, and everything went through fine.