import {
  ACTIVITY_INDEX_PENDING_DDL,
  ACTIVITY_REPOS_DDL,
  ATTACHMENT_BYTES_DDL,
  DEPLOY_TOKEN_INDEX_DDL,
  GAUGE_ACCOUNTS_DDL,
  RUNNER_OFFLINE_NOTICES_DDL,
  SCOPE_DIRTY_DDL,
  SCOPE_GAUGES_DDL,
  SITE_ROLLUPS_DDL,
} from "./extra-ddl";

/**
 * Scoped-table DDL added after the move out of D1. Statements must be idempotent (IF NOT EXISTS, or an ALTER
 * guarded by a version check) because every object runs them on its next prepare. Append; never reorder.
 */
export const REPO_SCHEMA_EXTRA: readonly string[] = [
  ...ACTIVITY_INDEX_PENDING_DDL,
  ...SCOPE_DIRTY_DDL,
  ...GAUGE_ACCOUNTS_DDL,
  ...SITE_ROLLUPS_DDL,
];

export const ACCOUNT_SCHEMA_EXTRA: readonly string[] = [
  ...DEPLOY_TOKEN_INDEX_DDL,
  ...ACTIVITY_REPOS_DDL,
  ...ATTACHMENT_BYTES_DDL,
  ...SCOPE_DIRTY_DDL,
  ...SCOPE_GAUGES_DDL,
  ...RUNNER_OFFLINE_NOTICES_DDL,
];