CREATE TABLE kv_store (
	  id INTEGER PRIMARY KEY,
	  key TEXT,
	  value TEXT,
	  project TEXT,
	  time TEXT
);
CREATE TABLE auth (
	  id INTEGER PRIMARY KEY,
	  project TEXT,
	  secret TEXT,
	  name TEXT,
	  email TEXT,
	  disabled INTEGER
);
CREATE INDEX idx_key ON kv_store(key ASC);
INSERT INTO auth (project,secret) VALUES ('my_project', 'password123');
PRAGMA journal_mode = WAL;
PRAGMA synchronous = 1;
.quit
