package id.com.rumahcoding.sekolahku

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

class DatabaseHelper (context : Context)
    : SQLiteOpenHelper (context , "sekolah.db"
    , null ,  1){

    override fun onCreate(db: SQLiteDatabase?) {

        var query = "cREate Table siswa ( " +
                "id INTEGER PRIMARY KEY AUTOINCREMENT, " +
                COL_NAMADEPAN+" TEXT, " +
                "nama_belakang TEXT, " +
                "no_hp TEXT, " +
                "jenjang TEXT, " +
                "hobi TEXT, " +
                "gender TEXT, " +
                "alamat TEXT, " +
                "email TEXT, " +
                "tgl_lahir TEXT)"
        db?.execSQL(query)

    }

    override fun onUpgrade(db: SQLiteDatabase?, oldVersion: Int, newVersion: Int) {


    }

    companion object{
        val COL_NAMADEPAN = "nama_depan"
    }


}