Shared Expenses

schema.js 2 lines

Files · 8

emits.js15 lines
index.jsx212 lines
listens.js8 lines
manifest.json240 lines
schema.js2 lines
schema.sql13 lines
store.js11 lines
style.css58 lines

12// Kept byte-for-byte equivalent to schema.sql; bundled without a runtime fetch.
export default "CREATE TABLE expenses (\n  id INTEGER PRIMARY KEY AUTOINCREMENT,\n  cost TEXT NOT NULL CHECK (length(cost) > 0),\n  description TEXT NOT NULL,\n  details TEXT,\n  date TEXT NOT NULL,\n  currency_code TEXT NOT NULL CHECK (length(currency_code) = 3),\n  group_id INTEGER,\n  repeat_interval TEXT NOT NULL DEFAULT 'never' CHECK (repeat_interval IN ('never', 'weekly', 'fortnightly', 'monthly', 'yearly')),\n  payment INTEGER NOT NULL DEFAULT 0 CHECK (payment IN (0, 1)),\n  created_at TEXT,\n  updated_at TEXT\n);\n";