export declare const blogSchemaContent = "import { Events, makeSchema, Schema, SessionIdSymbol, State } from '@livestore/livestore'\n\n// Content management with collaborative editing capabilities\nexport const tables = {\n  posts: State.SQLite.table({\n    name: 'posts',\n    columns: {\n      id: State.SQLite.text({ primaryKey: true }),\n      title: State.SQLite.text(),\n      content: State.SQLite.text(), // Consider using JSON for rich text operations\n      slug: State.SQLite.text(),\n      published: State.SQLite.boolean({ default: false }),\n      authorId: State.SQLite.text(),\n      createdAt: State.SQLite.integer({ schema: Schema.DateFromNumber }),\n      publishedAt: State.SQLite.integer({ nullable: true, schema: Schema.DateFromNumber }),\n      deletedAt: State.SQLite.integer({ nullable: true, schema: Schema.DateFromNumber }),\n      version: State.SQLite.integer({ default: 1 }), // For optimistic concurrency\n    },\n  }),\n  \n  comments: State.SQLite.table({\n    name: 'comments',\n    columns: {\n      id: State.SQLite.text({ primaryKey: true }),\n      postId: State.SQLite.text(),\n      authorId: State.SQLite.text(),\n      content: State.SQLite.text(),\n      parentId: State.SQLite.text({ nullable: true }), // For threaded comments\n      createdAt: State.SQLite.integer({ schema: Schema.DateFromNumber }),\n      editedAt: State.SQLite.integer({ nullable: true, schema: Schema.DateFromNumber }),\n      deletedAt: State.SQLite.integer({ nullable: true, schema: Schema.DateFromNumber }),\n    },\n  }),\n  \n  authors: State.SQLite.table({\n    name: 'authors',\n    columns: {\n      id: State.SQLite.text({ primaryKey: true }),\n      name: State.SQLite.text(),\n      email: State.SQLite.text(),\n      bio: State.SQLite.text({ nullable: true }),\n      avatarUrl: State.SQLite.text({ nullable: true }),\n      createdAt: State.SQLite.integer({ schema: Schema.DateFromNumber }),\n    },\n  }),\n  \n  // Track collaborative editing sessions\n  editingSessions: State.SQLite.clientDocument({\n    name: 'editingSessions',\n    schema: Schema.Struct({\n      postId: Schema.String,\n      authorId: Schema.String,\n      lastActivity: Schema.Date,\n      cursorPosition: Schema.Number,\n    }),\n    default: { \n      id: SessionIdSymbol, \n      value: { postId: '', authorId: '', lastActivity: new Date(), cursorPosition: 0 }\n    },\n  }),\n}\n\nexport const events = {\n  // Post lifecycle events\n  postCreated: Events.synced({\n    name: 'v1.PostCreated',\n    schema: Schema.Struct({\n      id: Schema.String,\n      title: Schema.String,\n      slug: Schema.String,\n      authorId: Schema.String,\n      createdAt: Schema.Date,\n    }),\n  }),\n  \n  postTitleChanged: Events.synced({\n    name: 'v1.PostTitleChanged',\n    schema: Schema.Struct({\n      id: Schema.String,\n      title: Schema.String,\n      version: Schema.Number, // Optimistic concurrency control\n    }),\n  }),\n  \n  postContentChanged: Events.synced({\n    name: 'v1.PostContentChanged',\n    schema: Schema.Struct({\n      id: Schema.String,\n      content: Schema.String,\n      version: Schema.Number,\n      authorId: Schema.String,\n    }),\n  }),\n  \n  postPublished: Events.synced({\n    name: 'v1.PostPublished',\n    schema: Schema.Struct({\n      id: Schema.String,\n      publishedAt: Schema.Date,\n    }),\n  }),\n  \n  postUnpublished: Events.synced({\n    name: 'v1.PostUnpublished',\n    schema: Schema.Struct({ id: Schema.String }),\n  }),\n  \n  postDeleted: Events.synced({\n    name: 'v1.PostDeleted',\n    schema: Schema.Struct({\n      id: Schema.String,\n      deletedAt: Schema.Date,\n    }),\n  }),\n  \n  // Comment events\n  commentCreated: Events.synced({\n    name: 'v1.CommentCreated',\n    schema: Schema.Struct({\n      id: Schema.String,\n      postId: Schema.String,\n      authorId: Schema.String,\n      content: Schema.String,\n      parentId: Schema.NullOr(Schema.String),\n      createdAt: Schema.Date,\n    }),\n  }),\n  \n  commentEdited: Events.synced({\n    name: 'v1.CommentEdited',\n    schema: Schema.Struct({\n      id: Schema.String,\n      content: Schema.String,\n      editedAt: Schema.Date,\n    }),\n  }),\n  \n  commentDeleted: Events.synced({\n    name: 'v1.CommentDeleted',\n    schema: Schema.Struct({\n      id: Schema.String,\n      deletedAt: Schema.Date,\n    }),\n  }),\n  \n  // Author events\n  authorCreated: Events.synced({\n    name: 'v1.AuthorCreated',\n    schema: Schema.Struct({\n      id: Schema.String,\n      name: Schema.String,\n      email: Schema.String,\n      createdAt: Schema.Date,\n    }),\n  }),\n  \n  // Local editing session tracking\n  editingSessionUpdated: tables.editingSessions.set,\n}\n\n// Materializers with conflict resolution strategies\nconst materializers = State.SQLite.materializers(events, {\n  // Post materializers\n  'v1.PostCreated': ({ id, title, slug, authorId, createdAt }) =>\n    tables.posts.insert({ id, title, content: '', slug, authorId, createdAt, version: 1 }),\n    \n  'v1.PostTitleChanged': ({ id, title, version }) =>\n    // Last-write-wins with version check for optimistic concurrency\n    tables.posts.update({ title, version }).where({ id }),\n    \n  'v1.PostContentChanged': ({ id, content, version, authorId }) =>\n    tables.posts.update({ content, version }).where({ id }),\n    \n  'v1.PostPublished': ({ id, publishedAt }) =>\n    tables.posts.update({ published: true, publishedAt }).where({ id }),\n    \n  'v1.PostUnpublished': ({ id }) =>\n    tables.posts.update({ published: false, publishedAt: null }).where({ id }),\n    \n  'v1.PostDeleted': ({ id, deletedAt }) =>\n    tables.posts.update({ deletedAt }).where({ id }),\n    \n  // Comment materializers\n  'v1.CommentCreated': ({ id, postId, authorId, content, parentId, createdAt }) =>\n    tables.comments.insert({ id, postId, authorId, content, parentId, createdAt }),\n    \n  'v1.CommentEdited': ({ id, content, editedAt }) =>\n    tables.comments.update({ content, editedAt }).where({ id }),\n    \n  'v1.CommentDeleted': ({ id, deletedAt }) =>\n    tables.comments.update({ deletedAt }).where({ id }),\n    \n  // Author materializers\n  'v1.AuthorCreated': ({ id, name, email, createdAt }) =>\n    tables.authors.insert({ id, name, email, createdAt }),\n})\n\nconst state = State.SQLite.makeState({ tables, materializers })\n\nexport const schema = makeSchema({ events, state })\n\n// Example queries:\n//\n// // Published posts with author info\n// const publishedPosts$ = queryDb(\n//   tables.posts\n//     .select()\n//     .join(tables.authors, 'authorId', 'id')\n//     .where({ published: true, deletedAt: null })\n//     .orderBy('publishedAt', 'desc'),\n//   { label: 'publishedPosts' }\n// )\n//\n// // Comments for a post (threaded)\n// const postComments$ = (postId: string) => queryDb(\n//   tables.comments\n//     .select()\n//     .join(tables.authors, 'authorId', 'id') \n//     .where({ postId, deletedAt: null })\n//     .orderBy('createdAt'),\n//   { label: `postComments-${postId}` }\n// )";
//# sourceMappingURL=blog.d.ts.map