From b074a4901c630ee5c5f7dcff79fa6ff911a14ded Mon Sep 17 00:00:00 2001
From: nsfisis <nsfisis@gmail.com>
Date: Wed, 31 Dec 2025 14:19:22 +0900
Subject: feat(schema): make note_id and is_reversed NOT NULL
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

All cards now require note association - legacy card support removed.
This aligns with the note-based card architecture introduced in Phase 8.

- Add database migration for NOT NULL constraints
- Update client Dexie schema to version 3
- Remove LegacyCardItem component and legacy card handling
- Update sync schemas and type definitions
- Update all tests to use note-based cards

🤖 Generated with [Claude Code](https://claude.com/claude-code)

Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
---
 drizzle/0003_brave_blacklash.sql | 2 ++
 1 file changed, 2 insertions(+)
 create mode 100644 drizzle/0003_brave_blacklash.sql

(limited to 'drizzle/0003_brave_blacklash.sql')

diff --git a/drizzle/0003_brave_blacklash.sql b/drizzle/0003_brave_blacklash.sql
new file mode 100644
index 0000000..d129f36
--- /dev/null
+++ b/drizzle/0003_brave_blacklash.sql
@@ -0,0 +1,2 @@
+ALTER TABLE "cards" ALTER COLUMN "note_id" SET NOT NULL;--> statement-breakpoint
+ALTER TABLE "cards" ALTER COLUMN "is_reversed" SET NOT NULL;
\ No newline at end of file
-- 
cgit v1.2.3-70-g09d2

