InventorySqlHelper.java

package com.godoro.androidsqlite;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

public class InventorySqlHelper extends SQLiteOpenHelper {


    public InventorySqlHelper(Context context) {
        super(context, "inventory", null, 1);
    }

    @Override
    public void onCreate(SQLiteDatabase database) {
        String create="create table product( " +
                " _id integer primary key autoincrement, " +
                " productName varchar(50) not null," +
                " salesPrice float)";
        database.execSQL(create);
    }

    @Override
    public void onUpgrade(SQLiteDatabase database, int oldVersion, int newVersion) {
        String drop="drop table if exists product";
        database.execSQL(drop);
        onCreate(database);
    }
}