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 , "sekolahku.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, "+
                "alaamat TEXT )"
        db?.execSQL(query)

    }

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

    }

    companion object{
        val COL_NAMADEPAN = "nama_depan"
    }
}