Cacher is the code snippet organizer for pro developers

public final class UserInfoContract implements BaseColumns
{
  public static final String TABLE_NAME = "user";
  public static final String COLUMN_NAME_USERNAME = "username";
  public static final String COLUMN_NAME_HASH = "hash";
  public static final String COLUMN_NAME_PIN = "pin";

  public static final String COLUMN_NAME_SITE = "site_json";
  public static final String COLUMN_NAME_SITEID = "siteid";
  public static final String SITE_TABLE_NAME = "sites";

  public static final String TEXT_TYPE = " TEXT";
  public static final String BLOB_TYPE = " BLOB";
  public static final String COMMA_SEP = ",";

  public static final String SQL_DROP_USERS = "DROP TABLE IF EXISTS " + TABLE_NAME + ";";
  public static final String SQL_DROP_SITES = "DROP TABLE IF EXISTS " + SITE_TABLE_NAME + ";";
  public static final String SQL_CREATE_ENTRIES =
      "CREATE TABLE " + TABLE_NAME + " (" +
          _ID + " INTEGER PRIMARY KEY" + COMMA_SEP +
          COLUMN_NAME_USERNAME + TEXT_TYPE + COMMA_SEP +
          COLUMN_NAME_HASH + TEXT_TYPE + COMMA_SEP +
          COLUMN_NAME_PIN + TEXT_TYPE +
          " );";

  public static final String SQL_CREATE_SITE_TABLE = "CREATE TABLE " + SITE_TABLE_NAME + " (" +
      _ID + " INTEGER PRIMARY KEY" + COMMA_SEP +
      COLUMN_NAME_SITEID + TEXT_TYPE + COMMA_SEP +
      COLUMN_NAME_SITE + BLOB_TYPE +
      " );";
  public static final String SQL_DELETE_ENTRIES =
      "DELETE FROM " + TABLE_NAME + ";" + "VACUUM;";

  public static final String SQL_DELETE_SITES = "DELETE FROM " + SITE_TABLE_NAME + ";" + "VACUUM";

  // Prevent instantiation
  public UserInfoContract()
  {
  }
}

public class Database extends SQLiteOpenHelper
{
    public static final int DATABASE_VERSION = 1;
    public static final String DATABASE_NAME = "DatabaseName.db";

    public Database(Context context)
    {
        super(context, DATABASE_NAME, null, DATABASE_VERSION);
    }

    public void onCreate(SQLiteDatabase db)
    {
        db.execSQL(UserInfoContract.SQL_CREATE_ENTRIES);
        db.execSQL(UserInfoContract.SQL_CREATE_SITE_TABLE);
    }

    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion)
    {
        // delete old data
        db.execSQL(UserInfoContract.SQL_DELETE_ENTRIES);
        onCreate(db);
    }
    public void onDowngrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        onUpgrade(db, oldVersion, newVersion);
    }
}

try
{
  Database dbh = new Database( context );

  SQLiteDatabase db = dbh.getWritableDatabase();

  ContentValues vals_to_save = new ContentValues();
  vals_to_save.put( UserInfoContract.COLUMN_NAME_SITE, json );
  vals_to_save.put( UserInfoContract.COLUMN_NAME_SITEID, siteid );

  long id;
  id = db.insert(
      UserInfoContract.SITE_TABLE_NAME,
      UserInfoContract.COLUMN_NAME_SITEID,
      vals_to_save
                );
  if ( id >= 0 )
  {
    // success
  }
  else
  {
    // fail
  }
} catch ( Exception e )
{
  // Log exception
}