Open loljoho opened 5 years ago
.
CREATE TABLE triviaactivity (
id INTEGER PRIMARY KEY AUTOINCREMENT,
type TEXT,
activity TEXT,
channel TEXT,
channel_canonical TEXT,
network TEXT,
timestamp INTEGER);
CREATE TABLE triviaedit (
id INTEGER PRIMARY KEY AUTOINCREMENT,
question_id INTEGER,
question TEXT,
status TEXT,
username TEXT,
channel TEXT,
created_at TEXT,
username_canonical TEXT,
channel_canonical TEXT);
CREATE TABLE triviaquestion (
id INTEGER PRIMARY KEY AUTOINCREMENT,
question_canonical TEXT,
question TEXT,
deleted INTEGER NOT NULL DEFAULT 0,
num_answered INTEGER,
num_missed INTEGER);
CREATE TABLE triviatemporaryquestion (
id INTEGER PRIMARY KEY AUTOINCREMENT,
username TEXT,
channel TEXT,
question TEXT,
username_canonical TEXT,
channel_canonical TEXT);
CREATE TABLE triviadelete (
id INTEGER PRIMARY KEY AUTOINCREMENT,
username TEXT,
username_canonical TEXT,
line_num INTEGER,
channel TEXT,
channel_canonical TEXT,
reason TEXT);
The "Latest Activities" table on the home page only reflects approvals/rejections made via the IRC bot interface, and not the web interface. The corresponding SQLite table
triviaactivity
is only updated through the bot plugin Python code; no such methods exist in the PHP portion.