Migration problem duplicate column problem which should not occur.

[DavidMont]

I dont understand some migration process, Sometimes it works , sometimes it doesnt, I carefully followed the docs on how to migrate. added 51.sql and I had previous 50.sql. I have a table aaapproved_request which does not have product_price column.

This is the data inside 51.sql

ALTER TABLE aaapproved_request ADD COLUMN product_price REAL DEFAULT 0.00 ;

but the exception occurs on ActiveAndroid.initialize(this); The exception is duplicate column Caused by: android.database.sqlite.SQLiteException: duplicate column name: product_price (code 1): , while compiling: ALTER TABLE aaapproved_request ADD COLUMN product_price REAL

I can migrate peacefully from apk-a to apk-b. The problem is fresh install of apk occurs duplication of column.

How do I mitigate my issue?