diff options
Diffstat (limited to 'app/src/main/java/fr/gouv/etalab/mastodon/sqlite/Sqlite.java')
| -rw-r--r-- | app/src/main/java/fr/gouv/etalab/mastodon/sqlite/Sqlite.java | 13 |
1 files changed, 12 insertions, 1 deletions
diff --git a/app/src/main/java/fr/gouv/etalab/mastodon/sqlite/Sqlite.java b/app/src/main/java/fr/gouv/etalab/mastodon/sqlite/Sqlite.java index 58fd6f9fd..df919fd48 100644 --- a/app/src/main/java/fr/gouv/etalab/mastodon/sqlite/Sqlite.java +++ b/app/src/main/java/fr/gouv/etalab/mastodon/sqlite/Sqlite.java @@ -26,7 +26,7 @@ import android.database.sqlite.SQLiteOpenHelper; public class Sqlite extends SQLiteOpenHelper { - public static final int DB_VERSION = 24; + public static final int DB_VERSION = 26; public static final String DB_NAME = "mastodon_etalab_db"; public static SQLiteDatabase db; private static Sqlite sInstance; @@ -86,6 +86,9 @@ public class Sqlite extends SQLiteOpenHelper { static final String COL_CLIENT_ID = "CLIENT_ID"; static final String COL_CLIENT_SECRET = "CLIENT_SECRET"; static final String COL_REFRESH_TOKEN = "REFRESH_TOKEN"; + static final String COL_IS_MODERATOR = "IS_MODERATOR"; + static final String COL_IS_ADMIN = "IS_ADMIN"; + static final String COL_UPDATED_AT = "UPDATED_AT"; private static final String CREATE_TABLE_USER_ACCOUNT = "CREATE TABLE " + TABLE_USER_ACCOUNT + " (" + COL_USER_ID + " TEXT PRIMARY KEY, " + COL_USERNAME + " TEXT NOT NULL, " + COL_ACCT + " TEXT NOT NULL, " @@ -96,7 +99,10 @@ public class Sqlite extends SQLiteOpenHelper { + COL_HEADER + " TEXT NOT NULL, "+ COL_HEADER_STATIC + " TEXT NOT NULL, " + COL_EMOJIS + " TEXT, " + COL_SOCIAL + " TEXT, " + + COL_IS_MODERATOR + " INTEGER DEFAULT 0, " + + COL_IS_ADMIN + " INTEGER DEFAULT 0, " + COL_CLIENT_ID + " TEXT, " + COL_CLIENT_SECRET + " TEXT, " + COL_REFRESH_TOKEN + " TEXT," + + COL_UPDATED_AT + " TEXT, " + COL_INSTANCE + " TEXT NOT NULL, " + COL_OAUTHTOKEN + " TEXT NOT NULL, " + COL_CREATED_AT + " TEXT NOT NULL)"; @@ -318,6 +324,11 @@ public class Sqlite extends SQLiteOpenHelper { db.execSQL("ALTER TABLE " + TABLE_USER_ACCOUNT + " ADD COLUMN " + COL_CLIENT_ID + " TEXT"); db.execSQL("ALTER TABLE " + TABLE_USER_ACCOUNT + " ADD COLUMN " + COL_CLIENT_SECRET + " TEXT"); db.execSQL("ALTER TABLE " + TABLE_USER_ACCOUNT + " ADD COLUMN " + COL_REFRESH_TOKEN + " TEXT"); + case 24: + db.execSQL("ALTER TABLE " + TABLE_USER_ACCOUNT + " ADD COLUMN " + COL_IS_MODERATOR + " INTEGER DEFAULT 0"); + db.execSQL("ALTER TABLE " + TABLE_USER_ACCOUNT + " ADD COLUMN " + COL_IS_ADMIN + " INTEGER DEFAULT 0"); + case 25: + db.execSQL("ALTER TABLE " + TABLE_USER_ACCOUNT + " ADD COLUMN " + COL_UPDATED_AT + " TEXT"); default: break; } |