title: SQLite and Android Exception
body: <p>I am facing problem in android application i want to create database with following script.</p>
  
  <pre><code>CREATE TABLE IF NOT EXISTS events (
  _id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
  source_device_id INT,
  timestamp INT NOT NULL,
  processed BOOLEAN DEFAULT FALSE,
  event_type TINYINT NOT NULL,
  payload BLOB);
  
  CREATE INDEX IF NOT EXISTS events_unprocessed ON events (processed, _id);
  </code></pre>
  
  <p>and my android code is </p>
  
  <pre><code>public void onCreate(SQLiteDatabase db) {
    InputStream schemaStream = context.getResources().openRawResource(R.raw.logdb_schema);
    Scanner schemaScanner = new Scanner(schemaStream, "UTF-8");
    schemaScanner.useDelimiter(";");
  
    Log.i(TAG, "Creating database");
    try {
      db.beginTransaction();
      while (schemaScanner.hasNext()) {
        String statement = schemaScanner.next();
        Log.d(TAG, "Creating database: " + statement);
        db.execSQL(statement);
      }
      db.setTransactionSuccessful();
    }
    finally {
      db.endTransaction();
    }
  }
  </code></pre>
  
  <p>Its not working its generating run-time exception:</p>
  
  <blockquote>
    <p>android.database.sqlite.SQLiteException: not an error:</p>
  </blockquote>