Co-Authored-By: Claude Fable 5.1 <noreply@anthropic.com>
12 lines
769 B
JavaScript
12 lines
769 B
JavaScript
/**
|
|
* portal/usage/model.mjs — 사용량 영역 표(§13.4).
|
|
* usage_limits 그룹·자원·대상별 현재 경고 구간(level)과 제한 여부(limited). 다른 영역(사이트·메일·배포)은 portal/usage/limits.mjs 로 읽는다.
|
|
*/
|
|
export const MIGRATIONS = [{ id: 'usage_0001', sql: `
|
|
CREATE TABLE IF NOT EXISTS usage_limits (
|
|
group_id TEXT NOT NULL, resource TEXT NOT NULL, subject_type TEXT NOT NULL, subject_id TEXT NOT NULL, level INTEGER NOT NULL DEFAULT 0, limited INTEGER NOT NULL DEFAULT 0,
|
|
used INTEGER NOT NULL DEFAULT 0, "limit" INTEGER NOT NULL DEFAULT 0, since TEXT, reason TEXT, overage INTEGER NOT NULL DEFAULT 0, evaluated_at TEXT NOT NULL, period_start TEXT,
|
|
PRIMARY KEY(group_id, resource, subject_type, subject_id)
|
|
);
|
|
` }];
|