Autonomous multi-agent build/verify drive across gitgram + aitimemachine. All 7 subprojects now build and run; agents fixed real defects throughout. Backend (gitgram/backend): - Migrate to Express 5 typing (ambient .d.ts shims for express-rate-limit, @apollo/server, @trpc/server that resolve Express 5 types under workspace hoisting); fix 2 real GraphQL typing defects; scope typeRoots to local types - Fix startup crash (missing `buffer` pkg required by nsfwjs) - Install ioredis + web-push; build clean, boots (HTTP 200), 1241/1266 tests Web (gitgram/web): next build green (fix route-slug conflict, remove dead lib/trpc.ts); document monorepo dual-React vitest harness limitation (71/86) Mobile (gitgram/mobile): port proximity-unique features (org, starred, reading-list, languages, snippets) onto modern expo-router + axios stack; exclude standalone proximity/ from tsconfig + jest; typecheck clean, 8/8 tests AITM core: fix CLI crash from duplicate command registrations (vendored merge); secure 2 unauthenticated API routes; 520/520 tests AITM api-server: fix ioredis construct + a2a SDK decls + test mocks; 715/715 AITM mcp: fix TS5076 syntax + slow gitnexus import; 63/63 AITM website: next build green (88 routes) Root deps: fix broken @types/uuid stub (real v9), relax override to $@types/uuid Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
22 lines
1.0 KiB
SQL
22 lines
1.0 KiB
SQL
-- Migration: add `user_settings` for the website account + dashboard settings pages
|
|
-- Source: aitm-website production wiring (settings/page.tsx, dashboard/settings/page.tsx)
|
|
-- Notes:
|
|
-- - One row per user (PK = user_id, cascades on user delete).
|
|
-- - Stores account preferences (display name, sync/email toggles) and dashboard
|
|
-- preferences (compression, retention, timezone, per-event notification map).
|
|
-- - Additive + idempotent. Defaults match SETTINGS_DEFAULTS in the API + website.
|
|
|
|
CREATE TABLE IF NOT EXISTS user_settings (
|
|
user_id TEXT PRIMARY KEY REFERENCES users(id) ON DELETE CASCADE,
|
|
display_name TEXT,
|
|
auto_sync BOOLEAN NOT NULL DEFAULT true,
|
|
email_notifications BOOLEAN NOT NULL DEFAULT false,
|
|
weekly_summary BOOLEAN NOT NULL DEFAULT true,
|
|
compress BOOLEAN NOT NULL DEFAULT true,
|
|
retain_days INTEGER NOT NULL DEFAULT 30,
|
|
timezone TEXT NOT NULL DEFAULT 'UTC',
|
|
notifications JSONB NOT NULL DEFAULT '{}'::jsonb,
|
|
created_at TIMESTAMP DEFAULT now(),
|
|
updated_at TIMESTAMP DEFAULT now()
|
|
);
|