package ru.rache.mobileappmanager.db

import android.provider.BaseColumns
import android.provider.BaseColumns._ID

class NotesContract(){

    val DB_NAME : String = "notes.db"
    val DB_VERSION : Int = 1
    val CREATE_DATABASE_QUERIES : Array<String> = arrayOf(
        Notes.CREATE_TABLE,
        Notes.CREATE_UPDATED_TS_INDEX
    )

    abstract class Notes : BaseColumns{
        val TABLE_NAME : String = "notes"
        val COLUMN_TITLE : String = "title"
        val COLUMN_NOTE : String = "note"
        val COLUMN_CREATED_TS : String = "created_ts"
        val COLUMN_UPDATED_TS : String = "updated_ts"

        val CREATE_TABLE : String = "CREATE TABLE $TABLE_NAME " +
                "($_ID INTEGER PRIMARY KEY, " +
                "$COLUMN_TITLE TEXT NOT NULL, " +
                "$COLUMN_NOTE TEXT NOT NULL, " +
                "$COLUMN_CREATED_TS INTEGER NOT NULL, " +
                "$COLUMN_UPDATED_TS INTEGER NOT NULL);"


        val CREATE_UPDATED_TS_INDEX : String = "CREATE INDEX updated_ts_index " +
        "ON $TABLE_NAME ($COLUMN_UPDATED_TS);"
    }

}