title: Version number for SQLite DB
body: <p>I am working on sqlite in my android app.</p>
  
  <p>I am doing  <code>db.getVersion()</code> to get current version of my database.</p>
  
  <p>it is showing  <code>3</code> in logcat.</p>
  
  <p>even in constructor i set <code>4</code> as a version number.</p>
  
  <pre><code>public Helper(Context context)
      {
          super(context, DATABASE_NAME, null,4);
      }
  </code></pre>
  
  <p>i am giving <code>4</code> it should take <code>4</code> as version number.</p>
  
  <p>but its not behaving like this. it is showing <code>3</code> as version number.</p>
  
  <p>please any suggestion.</p>
  
  <p>UPDATE:-</p>
  
  <pre><code>    public class Helper extends SQLiteOpenHelper {
          public static final String  DATABASE_NAME = "helper.db";
  
          public static final String TITLE = "title";
          public static final String AUTHOR = "author";
          public static final String ISBN = "isbn";
  
          public Helper(Context context)
          {
              super(context, DATABASE_NAME, null,4);
          }
  
          @Override
          public void onCreate(SQLiteDatabase db) {
  
                  db.execSQL( "CREATE TABLE book1(_id INTEGER PRIMARY KEY AUTOINCREMENT,title TEXT, author TEXT,isbn INTEGER);");
                  Log.v("Create Table", "CREATE TABLE book1(_id INTEGER PRIMARY KEY AUTOINCREMENT,title TEXT, author TEXT,isbn INTEGER);");
  
  Log.v("version ", "Version number is "+db.getVersion());
  
  }
  </code></pre>