SQLiteOpenHelper updating a table in a Database
<p>I have a class that extends SQLiteOpenHelper. The two functions overloaded are</p>

<pre><code>@Override
    public void onCreate(SQLiteDatabase database) {
        database.execSQL(DATABASE_CREATE);

    }

    @Override
    public void onUpgrade(SQLiteDatabase dataBase, int oldVersion,
            int newVersion) {

    }
</code></pre>

<p>In the OnCreate function i add SQL scripts to create a table. Now what if i want to upgrade a table in the Database. </p>

<p>When is the onUpgrade function called ? </p>

<p>What are the oldVersion and newVersion int values ? </p>

<p>Do these allow me to create a versioning on my db ? </p>

<p>Like in version 2 i want to add a new table and in version 3 i want to add a new column to an existing database table ? </p>

<p>How can i do this ? </p>

<p>The onCreate function will be called each time i create an object of the class, or will Android call this only when the application is installed ?</p>
