package dmo.fs.spa.db.sqlite3;

import dmo.fs.spa.db.SpaDatabase;
import dmo.fs.spa.db.SqlBuilder;

public abstract class DbSqlite3 extends SqlBuilder implements SpaDatabase {
    protected final static String CHECKLOGINSQL = "SELECT name FROM sqlite_master WHERE type='table' AND name='login'";
    
	private enum CreateTable {
		CREATELOGIN("create table login (id integer primary key, name text not null unique, password text not null, last_login DATETIME not null)");
		
		String sql;

        CreateTable(String sql) {
            this.sql = sql;
        }
    };

	public DbSqlite3() {
		super();
	}

	public String getCreateTable(String table) {
		return CreateTable.valueOf("CREATE"+table.toUpperCase()).sql;
	}
}