No such table with migration

[welshrat77]

Hi I am having major problems getting my app to upgrade.

I have a migration script 2.sql with the following

[welshrat77]

ALTER TABLE APP_USER add EMERGENCY_PHONE TEXT;

UPDATE APP_USER SET LOGGED_IN = 0 ;

And I get the following error installing the update via google internal testing

Caused by android.database.sqlite.SQLiteException
no such table: APP_USER (code 1): , while compiling: ALTER TABLE APP_USER add EMERGENCY_PHONE TEXT

App is working fine with version 1 and also works fine if I do a fresh install however wont work with upgrade

[welshrat77]

Ok so having done some reading it appears as though sugar now takes care of migrations however how can I set a database column (logged in) to 0 if the db is not yet upgraded.

i.e if they are on version 1 then log out otherwise leave it be.