Skip to content

Self-hosted, Self-Improving, Federated Everything App — dev management, agent orchestration, persistent mind, digital twin, second brain, and creative pipeline from a single dashboard over Tailscale to port the user into the OS

4.6 KB
Raw Blame
// Barrel + composer for the per-domain schema DDL modules (#2832).
//
// ensureSchemaImpl() in server/lib/db.js used to inline ~1265 lines of
// CREATE TABLE / CREATE INDEX / trigger DDL for every domain. That DDL now
// lives in per-domain modules here, each exporting a plain statement array;
// this file re-exports them and composes the two ordered lists that
// ensureSchemaImpl runs on every boot.
//
// ORDER IS LOAD-BEARING. The composed lists reproduce the pre-split statement
// order EXACTLY (foreign-key references, the trigger function preceding its
// triggers, and catalog_user_types' original post-media position all depend on
// it), so the executed schema is byte-identical to the inline version.
//
// See README.md for the module catalog.

import { coreDdl } from './core.js';
import { tribeDdl } from './tribe.js';
import { humanActivityDdl } from './humanActivity.js';
import { postDdl } from './post.js';
import { commissionsDdl } from './commissions.js';
import { userActionsDdl } from './userActions.js';
import { reviewQueueTriageDdl } from './reviewQueueTriage.js';
import { cosAgentFeedbackDdl } from './cosAgentFeedback.js';
import { cosTasksDdl } from './cosTasks.js';
import { cosAgentsDdl } from './cosAgents.js';
import { aiGraphDdl } from './aiGraph.js';
import { peerExecutionDdl } from './peerExecution.js';
import { catalogDdl, catalogUserTypesDdl, catalogPendingAppliesDdl } from './catalog.js';
import { catalogIdentityDdl } from './catalogIdentity.js';
import { buildCatalogIdentityViewsDdl, buildCatalogIdentityViewsPreludeDdl } from './catalogIdentityViews.js';
import { mediaDdl } from './media.js';
import { universesDdl } from './universes.js';
import { libraryDdl } from './library.js';
import { pipelineDdl } from './pipeline.js';
import { writersRoomDdl } from './writersRoom.js';
import { loraDdl } from './lora.js';
import { privacyDdl } from './privacy.js';
import { stackerNewsDdl } from './stackerNews.js';
import { xDdl } from './x.js';
import { mindToolRecipesDdl } from './mindToolRecipes.js';
import { decksDdl } from './decks.js';
import { beeperDdl } from './beeper.js';
import { githubNotificationsDdl } from './githubNotifications.js';
import { auditDdl, auditedTables, buildAuditTriggers } from './audit.js';
import { syncFeedDdl, syncFeedTables, buildSyncFeedTriggers } from './syncFeed.js';

export {
  coreDdl,
  tribeDdl,
  humanActivityDdl,
  postDdl,
  commissionsDdl,
  userActionsDdl,
  reviewQueueTriageDdl,
  cosAgentFeedbackDdl,
  cosTasksDdl,
  cosAgentsDdl,
  aiGraphDdl,
  peerExecutionDdl,
  catalogDdl,
  catalogIdentityDdl,
  buildCatalogIdentityViewsDdl,
  buildCatalogIdentityViewsPreludeDdl,
  catalogUserTypesDdl,
  catalogPendingAppliesDdl,
  mediaDdl,
  universesDdl,
  libraryDdl,
  pipelineDdl,
  writersRoomDdl,
  loraDdl,
  privacyDdl,
  stackerNewsDdl,
  xDdl,
  beeperDdl,
  githubNotificationsDdl,
  mindToolRecipesDdl,
  decksDdl,
  auditDdl,
  auditedTables,
  buildAuditTriggers,
  syncFeedDdl,
  syncFeedTables,
  buildSyncFeedTriggers,
};

// Phase 1 — the `upgrades` list: memory-sync columns + migration tracker, then
// the machine-local Tribe / human-activity / POST / commission / user-action /
// AI-connection-graph tables. Run first, before the catalog block.
export function buildUpgradeDdl() {
  return [
    ...coreDdl,
    ...tribeDdl,
    ...humanActivityDdl,
    ...postDdl,
    ...commissionsDdl,
    ...userActionsDdl,
    ...reviewQueueTriageDdl,
    ...cosAgentFeedbackDdl,
    ...cosTasksDdl,
    ...cosAgentsDdl,
    ...aiGraphDdl,
    ...peerExecutionDdl,
  ];
}

// Phase 2 — the `catalogDDL` list: catalog + all creative-app tables, then the
// record_audit table/function, then the per-table audit triggers. catalog_user_types
// is threaded in AFTER the media block to match its original position (see catalog.js).
// `beeperDdl` is appended after `xDdl` (#27) — same external-mirror shape as
// stackerNews/x, added last of that group, before the audit block. The
// commit-ordered sync feed (#8315) comes last: its triggers attach to memories
// and the catalog tables, which must already exist.
export function buildCatalogDdl() {
  return [
    ...catalogDdl,
    ...catalogIdentityDdl,
    ...buildCatalogIdentityViewsPreludeDdl(),
    ...buildCatalogIdentityViewsDdl(),
    ...mediaDdl,
    ...catalogUserTypesDdl,
    ...universesDdl,
    ...libraryDdl,
    ...pipelineDdl,
    ...writersRoomDdl,
    ...loraDdl,
    ...privacyDdl,
    ...stackerNewsDdl,
    ...xDdl,
    ...beeperDdl,
    ...githubNotificationsDdl,
    ...mindToolRecipesDdl,
    ...decksDdl,
    ...auditDdl,
    ...buildAuditTriggers(),
    ...syncFeedDdl,
    ...buildSyncFeedTriggers(),
  ];
}