SQLite database and upgrade attempt using SimpleSQLProvider.

FooProviderConfig.java

package com.es0329.sqlite;

import ckm.simple.sql_provider.UpgradeScript;
import ckm.simple.sql_provider.annotation.ProviderConfig;
import ckm.simple.sql_provider.annotation.SimpleSQLConfig;
import com.es0329.sqlite.R;

@SimpleSQLConfig(
    name = "FooProvider",
    authority = "com.es0329.sqlite.AUTHORITY",
    database = "foo.db",
    version = 2)
public class FooProviderConfig implements ProviderConfig {

  @Override public UpgradeScript[] getUpdateScripts() {

    return new UpgradeScript[] {
        new UpgradeScript(2, R.raw.v2_upgrade)
    };
  }
}

User.java

package com.es0329.sqlite;

import ckm.simple.sql_provider.annotation.SimpleSQLColumn;
import ckm.simple.sql_provider.annotation.SimpleSQLTable;

@SimpleSQLTable(table = "user", provider = "FooProvider")
public class User {
  // version 1 = successful
  @SimpleSQLColumn(value = "id", primary = true) public String id = "";
  @SimpleSQLColumn(value = "name") public String name = "";
  
  // version 2 = no upgrade
  @SimpleSQLColumn(value = "avatar_url") public String avatar_url = "";
}

v2_upgrade.sql

ALTER TABLE user ADD COLUMN avatar_url TEXT

Sql script line must end with semicolon to be executed, e.g. ALTER TABLE user ADD COLUMN avatar_url TEXT;