👷 build(database): added editor_data and snapshot_editor_data to user_memory_persona_documents and user_memory_persona_document_histories

docs/development/database-schema.dbml

@@ -1902,6 +1902,7 @@ table user_memory_persona_document_histories {
   profile varchar(255) [not null, default: 'default']
   snapshot_persona text
   snapshot_tagline text
+  snapshot_editor_data jsonb
   reasoning text
   diff_persona text
   diff_tagline text
@@ -1931,6 +1932,7 @@ table user_memory_persona_documents {
   profile varchar(255) [not null, default: 'default']
   tagline text
   persona text
+  editor_data jsonb
   memory_ids jsonb
   source_ids jsonb
   metadata jsonb

packages/database/migrations/0101_add_editor_data_for_user_memory_persona.sql

@@ -0,0 +1,2 @@
+ALTER TABLE "user_memory_persona_document_histories" ADD COLUMN IF NOT EXISTS "snapshot_editor_data" jsonb;--> statement-breakpoint
+ALTER TABLE "user_memory_persona_documents" ADD COLUMN IF NOT EXISTS "editor_data" jsonb;

packages/database/migrations/meta/_journal.json

@@ -707,6 +707,13 @@
       "when": 1777552567945,
       "tag": "0100_add_metadata_and_trigger_to_briefs",
       "breakpoints": true
+    },
+    {
+      "idx": 101,
+      "version": "7",
+      "when": 1777995113490,
+      "tag": "0101_add_editor_data_for_user_memory_persona",
+      "breakpoints": true
     }
   ],
   "version": "6"

packages/database/src/schemas/userMemories/persona.ts

@@ -22,6 +22,7 @@ export const userPersonaDocuments = pgTable(
 
     tagline: text('tagline'),
     persona: text('persona'),
+    editorData: jsonb('editor_data').$type<Record<string, unknown>>(),
 
     memoryIds: jsonb('memory_ids').$type<string[]>(),
     sourceIds: jsonb('source_ids').$type<string[]>(),
@@ -53,6 +54,7 @@ export const userPersonaDocumentHistories = pgTable(
 
     snapshotPersona: text('snapshot_persona'),
     snapshotTagline: text('snapshot_tagline'),
+    snapshotEditorData: jsonb('snapshot_editor_data').$type<Record<string, unknown>>(),
     reasoning: text('reasoning'),
     diffPersona: text('diff_persona'),
     diffTagline: text('diff_tagline'),