package com.com.mr_wrong.ContentProvider;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
/**
* Created by Mr_Wrong on 15/9/29.
*/
public class DbOpenHelper extends SQLiteOpenHelper {
private static final String DB_NAME= "book_provider.db";
public static final String BOOK_TABLE_NAME= "book";
public static final String USER_TABLE_NAME= "user";
private static final int DB_VERSION= 1;
private String CREATE_BOOK_TABLE= "CREATE TABLE IF NOT EXISTS "
+BOOK_TABLE_NAME+"(_id INTEGER PRIMARY KEY,"+"name TEXT)";
private String CREATE_USER_TABLE = "CREATE TABLE IF NOT EXISTS "
+USER_TABLE_NAME+"(_id INTEGER PRIMARY KEY,"+"name TEXT,"+"sex INT)";
public DbOpenHelper(Context context) {
super(context, DB_NAME, null, DB_VERSION);
}
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL(CREATE_BOOK_TABLE);
db.execSQL(CREATE_USER_TABLE);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
}
}