CREATE TABLE created_budgets (month TEXT PRIMARY KEY); CREATE TABLE spreadsheet_cells (name TEXT PRIMARY KEY, expr TEXT, cachedValue TEXT); CREATE TABLE banks (id TEXT PRIMARY KEY, bank_id TEXT, name TEXT, tombstone INTEGER DEFAULT 0); CREATE TABLE accounts (id TEXT PRIMARY KEY, account_id TEXT, name TEXT, balance_current INTEGER, balance_available INTEGER, balance_limit INTEGER, mask TEXT, official_name TEXT, type TEXT, subtype TEXT, bank TEXT, offbudget INTEGER DEFAULT 0, closed INTEGER DEFAULT 0, tombstone INTEGER DEFAULT 0); CREATE TABLE pending_transactions (id TEXT PRIMARY KEY, acct INTEGER, amount INTEGER, description TEXT, date TEXT, FOREIGN KEY(acct) REFERENCES accounts(id)); CREATE TABLE transactions (id TEXT PRIMARY KEY, isParent INTEGER DEFAULT 0, isChild INTEGER DEFAULT 0, acct TEXT, category TEXT, amount INTEGER, description TEXT, notes TEXT, date INTEGER, financial_id TEXT, type TEXT, location TEXT, error TEXT, imported_description TEXT, starting_balance_flag INTEGER DEFAULT 0, transferred_id TEXT, sort_order REAL, tombstone INTEGER DEFAULT 0); CREATE TABLE categories (id TEXT PRIMARY KEY, name TEXT, is_income INTEGER DEFAULT 0, cat_group TEXT, sort_order REAL, tombstone INTEGER DEFAULT 0); CREATE TABLE category_groups (id TEXT PRIMARY KEY, name TEXT UNIQUE, is_income INTEGER DEFAULT 0, sort_order REAL, tombstone INTEGER DEFAULT 0); CREATE TABLE messages_crdt (id INTEGER PRIMARY KEY, timestamp TEXT NOT NULL UNIQUE, dataset TEXT NOT NULL, row TEXT NOT NULL, column TEXT NOT NULL, value BLOB NOT NULL); CREATE TABLE category_mapping (id TEXT PRIMARY KEY, transferId TEXT); CREATE TABLE messages_clock (id INTEGER PRIMARY KEY, clock TEXT); CREATE TABLE db_version (version TEXT PRIMARY KEY); CREATE TABLE __migrations__ (id INT PRIMARY KEY NOT NULL);