Files

7 lines
540 B
JavaScript

/** portal/source/model.mjs — Source 옵션(§8.3) 상태 표. status: active | readonly(만료 후 30일 read-only) | deleted */
export const MIGRATIONS = [{ id: 'source_0001', sql: `
CREATE TABLE IF NOT EXISTS source_options (
id TEXT PRIMARY KEY, site_id TEXT NOT NULL UNIQUE, group_id TEXT NOT NULL, status TEXT NOT NULL DEFAULT 'active', activated_at TEXT NOT NULL, expires_at TEXT, readonly_until TEXT, delete_after TEXT,
deleted_at TEXT, reason TEXT, created_by TEXT, created_at TEXT NOT NULL, updated_at TEXT NOT NULL
);` }];