package com.miguel.amm.simplesqlite;

import android.provider.BaseColumns;

/**
 * Created by amm on 22/04/18.
 */

public final class DBSchema {
    private DBSchema() {
    }

    /* Inner class that defines the table contents */
    public static class Personas implements BaseColumns {
        public static final String TABLE_NAME = "personas";
        public static final String COL_ID = "id";
        public static final String COL_NOMBRE = "nombre";
        public static final String COL_APELLIDOS = "apellidos";
    }

    public static final String SQL_CREATE_ENTRIES =
            "CREATE TABLE " + Personas.TABLE_NAME + " (" +
                    Personas.COL_ID + " INTEGER PRIMARY KEY," +
                    Personas.COL_NOMBRE + " TEXT," +
                    Personas.COL_APELLIDOS + " TEXT)";

    public static final String SQL_DELETE_ENTRIES =
            "DROP TABLE IF EXISTS " + Personas.TABLE_NAME;
}
