EsbQ4WiQ

1export interface Setting {
2    id: number;
3    key: string;
4    value: string;
5};
6
7export const SQL_CREATE_SETTINGS_TABLE: string = "CREATE TABLE IF NOT EXISTS settings (id INTEGER PRIMARY KEY, key VARCHAR UNIQUE, value VARCHAR);";
8export const SQL_BATCH_INSERT_INTO_SETTINGS_TABLE: string[] =[
9    "INSERT OR IGNORE INTO settings VALUES(NULL, 'key1', 'value1'); ",
10    "INSERT OR IGNORE INTO settings VALUES(NULL, 'key2', 'value2'); ",
11    "INSERT OR IGNORE INTO settings VALUES(NULL, 'keyX', 'valueX'); "
12]
13export const  SQL_SELECT_ALL_SETTINGS: string = "SELECT * FROM settings;"