boost/updates/00-05-02.sql from AppStateESS/homestead

boost/updates/00-05-02.sql

Summary

Maintainability

Test Coverage

Issues
Source
Stats

Issues

alter table hms_fall_application add column smoking_preference smallint;
update hms_fall_application set smoking_preference = 0;
alter table hms_fall_application alter column smoking_preference set default 0;
alter table hms_fall_application alter column smoking_preference set not null;


alter table hms_spring_application add column smoking_preference smallint;
update hms_spring_application set smoking_preference = 0;
alter table hms_spring_application alter column smoking_preference set default 0;
alter table hms_spring_application alter column smoking_preference set not null;

alter table hms_summer_application add column smoking_preference smallint;
update hms_summer_application set smoking_preference = 0;
alter table hms_summer_application alter column smoking_preference set default 0;
alter table hms_summer_application alter column smoking_preference set not null;