pyr0ball
2cc85d8fc5
FastAPI backend (SQLite + APScheduler), Vue 3 frontend, MCP server for Claude integration, and Docker Compose stack. Includes campaign data model (campaigns → variants → subs), post history, sub rules, and Playwright-based Reddit posting layer migrated from claude-bridge/reddit-poster. Also seeds legacy campaigns (6) and sub rules (14) from reddit-poster history. Closes #1 (scaffold), resolves migration from claude-bridge.
16 lines
691 B
SQL
16 lines
691 B
SQL
-- Sub rules: per-subreddit posting rules and capabilities.
|
|
-- promo_allowed: NULL = unknown, 1 = allowed, 0 = banned
|
|
CREATE TABLE IF NOT EXISTS sub_rules (
|
|
id INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
platform TEXT NOT NULL DEFAULT 'reddit',
|
|
sub TEXT NOT NULL,
|
|
flair_required INTEGER NOT NULL DEFAULT 0,
|
|
flair_to_use TEXT,
|
|
promo_allowed INTEGER, -- NULL=unknown, 1=yes, 0=hard-banned
|
|
rule_warning INTEGER NOT NULL DEFAULT 0, -- shows "Your post may break rules" modal
|
|
notes TEXT,
|
|
last_checked TEXT,
|
|
updated_at TEXT NOT NULL DEFAULT (datetime('now')),
|
|
|
|
UNIQUE(platform, sub)
|
|
);
|