salix/db/versions/11348-bronzeCamellia/00-firstScript.sql

3 lines
184 B
SQL

ALTER TABLE vn.clientObservation MODIFY COLUMN observationTypeFk tinyint(3) unsigned DEFAULT 4 NOT NULL;
UPDATE vn.clientObservation SET observationTypeFk=4 WHERE observationTypeFk=0;