title: Executing multiple statements with SQLiteDatabase.execSQL
body: <p>I've followed a standard tutorial for building a database with Android.  I've created a class called DbHelper which extends SQLiteOpenHelper.  I've Overridden the create handler to execute a string.</p>
  
  <pre><code>@Override
  public void onCreate(SQLiteDatabase db) {
      db.execSQL(DbDefinitions.DB_CREATE);
  }
  </code></pre>
  
  <p>DbDefinitions.DB_CREATE is a static String I've created.</p>
  
  <pre><code>public static final String TABLE_MESSAGES = "messages";
  public static final String TABLE_FRIENDS = "friends";
  
  public static final String STATE_OK = "STATE_OK";
  
  public static final String DB_CREATE = 
      "create table " + TABLE_MESSAGES + " (_id integer primary key, user_id integer not null, created_on integer, subject text not null, summary text not null, messagetext text null, read integer not null, status text not null default '" + STATE_OK + "'); " +
      "create table " + TABLE_FRIENDS + " (_id integer primary key, user_id integer not null, friend_id integer not null, created_on integer, status text not null default '" + STATE_OK + "');";
  </code></pre>
  
  <p>I'd like to use 1 String to execute multiple SQL statements.  How can I do this as SQLiteDatabase.execSQL only allows 1 statement?</p>