1{ 2 // Note: Comments are not supported in JSON schema, but android parser is lenient. 3 4 // Maximum DB version supported by this schema 5 "version" : 28, 6 7 "downgrade_to_27" : [ 8 "CREATE TABLE workspaceScreens (_id INTEGER PRIMARY KEY,screenRank INTEGER,modified INTEGER NOT NULL DEFAULT 0)", 9 "insert into workspaceScreens (_id, screenRank) select screen as _id, screen as screenRank from favorites where container = -100 group by screen order by screen" 10 ], 11 // Downgrade from 27 to 26. Empty array indicates, the DB is compatible 12 "downgrade_to_26" : [], 13 "downgrade_to_25" : [], 14 "downgrade_to_24" : [], 15 "downgrade_to_23" : [], 16 "downgrade_to_22" : [ 17 "ALTER TABLE favorites RENAME TO temp_favorites;", 18 "CREATE TABLE favorites(_id INTEGER PRIMARY KEY, title TEXT, intent TEXT, container INTEGER, screen INTEGER, cellX INTEGER, cellY INTEGER, spanX INTEGER, spanY INTEGER, itemType INTEGER, appWidgetId INTEGER NOT NULL DEFAULT - 1, iconPackage TEXT, iconResource TEXT, icon BLOB, appWidgetProvider TEXT, modified INTEGER NOT NULL DEFAULT 0, restored INTEGER NOT NULL DEFAULT 0, profileId INTEGER DEFAULT 0, rank INTEGER NOT NULL DEFAULT 0);", 19 "INSERT INTO favorites SELECT _id, title, intent, container, screen, cellX, cellY, spanX, spanY, itemType, appWidgetId, iconPackage, iconResource, icon, appWidgetProvider, modified, restored, profileId, rank FROM temp_favorites;", 20 "DROP TABLE temp_favorites;" 21 ] 22 23 // Missing values indicate the DB is not compatible 24}