package com.bignerdranch.android.criminalintent.database;

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

public class CrimeBaseHelper extends SQLiteOpenHelper

    private static final int VERSION = 1;
    private static final String DATABASE_NAME = "crimeBase.db";


    public CrimeBaseHelper(Context context) {
        super(context, DATABASE_NAME, null, VERSION);
    }

    @Override public void onCreate(SQLiteDatabase db) {

    }

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

    }
}

@@ -181,16 +181,99 @@
 elper;%0A%0A
+import com.bignerdranch.android.criminalintent.database.CrimeDbSchema.CrimeTable;%0A%0A
 public c
@@ -317,16 +317,18 @@
 enHelper
+ %7B
 %0A%0A    pr
@@ -588,24 +588,387 @@
 abase db) %7B%0A
+        db.execSQL(%22create table %22 + CrimeTable.NAME%0A                        + %22( _id integer primary key autoincrement, %22%0A                        + CrimeTable.Cols.UUID + %22, %22%0A                        + CrimeTable.Cols.TITLE + %22, %22%0A                        + CrimeTable.Cols.DATE + %22, %22%0A                        + CrimeTable.Cols.SOLVED + %22)%22%0A                    );
 %0A    %7D%0A%0A    

Create table