aboutsummaryrefslogtreecommitdiffhomepage
path: root/drizzle/0003_brave_blacklash.sql
diff options
context:
space:
mode:
authornsfisis <nsfisis@gmail.com>2025-12-31 14:19:22 +0900
committernsfisis <nsfisis@gmail.com>2025-12-31 14:19:22 +0900
commitb074a4901c630ee5c5f7dcff79fa6ff911a14ded (patch)
treea52b738974393e31678c85e37756004d1b547823 /drizzle/0003_brave_blacklash.sql
parent29caaa7aaf14a41dad3d345cd29b319fff6e1305 (diff)
downloadkioku-b074a4901c630ee5c5f7dcff79fa6ff911a14ded.tar.gz
kioku-b074a4901c630ee5c5f7dcff79fa6ff911a14ded.tar.zst
kioku-b074a4901c630ee5c5f7dcff79fa6ff911a14ded.zip
feat(schema): make note_id and is_reversed NOT NULL
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>
Diffstat (limited to 'drizzle/0003_brave_blacklash.sql')
-rw-r--r--drizzle/0003_brave_blacklash.sql2
1 files changed, 2 insertions, 0 deletions
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