Error when create by hand many table in SQLite
<p>I create database by hand and want to add two tables to database.If i only add one table it work but when add two tables,it give report : no have users.
1).DBAdapter 
This is my code:</p>

<pre><code>public class DBAdapter {

public static final String KEY_EQID="eqid";
public static final String KEY_MAGNITUDE="magnitude";
public static final String KEY_LNG="lng";
public static final String KEY_SRC="src";
public static final String KEY_DATETIME="datetime";
public static final String KEY_DEPTH="depth";
public static final String KEY_LAT="lat";

public static final String KEY_USERNAME="username";
public static final String KEY_ADDRESS="address";

public static final String DATABASE_CREATE1="create table earthquakes(eqid String primary key not null,magnitude double,lng double,src text not null,datetime text,depth double,lat double);";
public static final String DATABASE_CREATE2="create table users(eqid String primary key not null,username text not null,address text not null);";
public static final String DATABASE_UPGRADE1="DROP TABLE IF EXISTS earthquakes ";
public static final String DATABASE_UPGRADE2="DROP TABLE IF EXISTS users ";
public static final String DATABASE_NAME="JSONDatabase";
public static final String DATABASE_TABLE1="earthquakes";
public static final String DATABASE_TABLE2="users";
public static final int DATABASE_VERSION=2;


private DatabaseHelper mDbHelper;
private SQLiteDatabase mDB;
private final Context mContext;

private static class DatabaseHelper extends SQLiteOpenHelper
{

    public DatabaseHelper(Context context, String name,
            CursorFactory factory, int version) {
        super(context, name, factory, version);
        // TODO Auto-generated constructor stub
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        // TODO Auto-generated method stub
        db.execSQL(DATABASE_CREATE2);
        db.execSQL(DATABASE_CREATE1);           
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        // TODO Auto-generated method stub
        Log.i("msg","Upgrade version");
        db.execSQL(DATABASE_UPGRADE2);
        db.execSQL(DATABASE_UPGRADE1);          
        onCreate(db);
    }

}

public DBAdapter(Context ctx){
    this.mContext = ctx;
}

public DBAdapter open()
{
    mDbHelper = new DatabaseHelper(mContext, DATABASE_NAME, null, DATABASE_VERSION);
    mDB = mDbHelper.getWritableDatabase();
    return this;
}

public void close(){
    mDbHelper.close();
}

//create a earthquakes with information input...ex
public long createEarthquakes(String eqid,double magnitude,double lng,String src,String datetime,double depth,double lat){
    ContentValues inititalValues = new ContentValues();
    inititalValues.put(KEY_EQID, eqid);
    inititalValues.put(KEY_MAGNITUDE, magnitude);
    inititalValues.put(KEY_LNG, lng);
    inititalValues.put(KEY_SRC, src);
    inititalValues.put(KEY_DATETIME, datetime);
    inititalValues.put(KEY_DEPTH, depth);
    inititalValues.put(KEY_LAT, lat);

    return mDB.insert(DATABASE_TABLE1, null, inititalValues);
}

//create a user with information input
public long createUser(String eqid,String username,String address)
{
    ContentValues inititalValues = new ContentValues();
    inititalValues.put(KEY_EQID, eqid);
    inititalValues.put(KEY_USERNAME,username);
    inititalValues.put(KEY_ADDRESS,address);
    return mDB.insert(DATABASE_TABLE2, null, inititalValues);
}


//delete record with rowId=eqid above
public boolean deleteEarthquakes(int rowId)
{
    return mDB.delete(DATABASE_TABLE1, KEY_EQID + "=" + rowId, null) &gt;0;
}

//delete all record
public void deleteAllEarthquakes()
{
    mDB.delete(DATABASE_TABLE1, null, null);
}

public Cursor getAllEarthquakes(){
    return mDB.query(DATABASE_TABLE1, new String[] {KEY_EQID,KEY_MAGNITUDE,KEY_LNG,KEY_SRC,KEY_DATETIME,KEY_DEPTH,KEY_LAT}, null, null, null, null, null);
}

public Cursor getAllUsers(){
    return mDB.query(DATABASE_TABLE2, new String[] {KEY_EQID,KEY_USERNAME,KEY_ADDRESS}, null, null, null, null, null);
}


 public Cursor getAllEarthquakesOrderBy() {
        return mDB.query(DATABASE_TABLE1, new String[] {
                KEY_EQID,KEY_MAGNITUDE,KEY_LNG,KEY_SRC,KEY_DATETIME,KEY_DEPTH,KEY_LAT}, null, null, null, null, KEY_EQID + " ASC");
    }
</code></pre>

<p>}</p>

<p><strong>And here is my Activity:</strong></p>

<pre><code>public class JSONActivity extends Activity {

TextView tv;
TextView tv1;
Button btn;
DBAdapter mDBAdapter;
Cursor mCursor;
ArrayList&lt;String&gt; array_list;
InputStream raw;
@Override
public void onCreate(Bundle circle)
{
    super.onCreate(circle);
    setContentView(R.layout.json_layout);

    array_list=new ArrayList&lt;String&gt;();
    mDBAdapter=new DBAdapter(this);
    mDBAdapter.open();

            //if i use code between /* it work..but in createUser below,it's not work
            /* 
            mDBAdapter.createEarthquakes("Num01",1.0,1.0,"src1","date1",2.5,3.3);       
    mCursor=mDBAdapter.getAllUsers();
    startManagingCursor(mCursor);
    mCursor.moveToFirst();      
    String s=mCursor.getString(0);                                              
    tv=(TextView)findViewById(R.id.textview);                       
    tv.setText(s);
            */      

    mDBAdapter.createUser("Num01", "tuanshaker", "california");     
    mCursor=mDBAdapter.getAllUsers();
    startManagingCursor(mCursor);
    mCursor.moveToFirst();      
    String s=mCursor.getString(0);                                              
    tv=(TextView)findViewById(R.id.textview);                       
    tv.setText(s);      
}
</code></pre>
