INNER CODE UNIT · Python
init_schema
browser-use/bux · agent/agency_db.py:49
def init_schema(db: sqlite3.Connection) -> None:
db.executescript(
"""
CREATE TABLE IF NOT EXISTS suggestions (
id INTEGER PRIMARY KEY AUTOINCREMENT,
title TEXT NOT NULL,
description TEXT NOT NULL,
importance TEXT CHECK (importance IN ('high','med','low')) DEFAULT 'med',
source TEXT, -- e.g. slack-c-foo, gmail-thread-19df, gh-pr-78
prompt TEXT, -- the action that would run if user says yes
buttons_json TEXT, -- JSON list of the labels shown
blocks_json TEXT, -- JSON list of expandable card blocks
image_url TEXT,
image_file TEXT,
source_label TEXT,
source_url TEXT,
tg_chat_id INTEGER,
tg_thread_id INTEGER,