Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package com.example.myapplication
- import android.content.Context
- import android.database.sqlite.SQLiteDatabase
- import android.database.sqlite.SQLiteOpenHelper
- class DBHelper(val context: Context) : SQLiteOpenHelper(context, DATABASE_NAME, null, DATABASE_VERSION) {
- companion object {
- internal const val DATABASE_VERSION = 1
- internal const val DATABASE_NAME = "Users.db"
- internal const val TABLE_NAME = "users"
- internal const val COL_ID = "id"
- internal const val COL_NAME = "name"
- internal const val COL_SURNAME = "surname"
- }
- override fun onCreate(db: SQLiteDatabase?) {
- val sql = db!!.execSQL("CREATE TABLE IF NOT EXISTS $TABLE_NAME(" +
- "$COL_ID INTEGER PRIMARY KEY, " +
- "$COL_NAME TEXT NOT NULL, " +
- "$COL_SURNAME TEXT NOT NULL)")
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement