Schema for CAMPD

CREATE TABLE "emissions" (
   [title] TEXT,
   [id] TEXT,
   [file_description] TEXT,
   [unit] TEXT,
   [year] TEXT,
   [tag] TEXT,
   [file_key] TEXT,
   [file_size] INTEGER,
   [file_checksum] TEXT,
   [file_link] TEXT,
   [datasette_link] TEXT
);
CREATE TABLE admin_content (
    id TEXT PRIMARY KEY,
    section TEXT NOT NULL UNIQUE,
    content TEXT,
    updated_at TEXT
, updated_by TEXT);
CREATE TABLE users (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    username TEXT NOT NULL UNIQUE,
    password_hash TEXT NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
, role TEXT DEFAULT 'moderator');
CREATE TABLE sqlite_sequence(name,seq)