mirror of
https://github.com/smogon/pokemon-showdown.git
synced 2026-03-22 01:35:31 -05:00
7f2dec0797
* Modlog: Avoid optional properties in ModlogEntry * Use a type * Make IP nullable * Add NOT NULL constrains * Fix typo
24 lines
570 B
SQL
24 lines
570 B
SQL
CREATE TABLE modlog (
|
|
modlog_id INTEGER NOT NULL PRIMARY KEY,
|
|
-- UNIX timestamp
|
|
timestamp INTEGER NOT NULL,
|
|
--- roomid OR global-roomid
|
|
roomid TEXT NOT NULL,
|
|
action TEXT NOT NULL,
|
|
visual_roomid TEXT NOT NULL,
|
|
note TEXT NOT NULL,
|
|
action_taker_userid TEXT,
|
|
userid TEXT,
|
|
autoconfirmed_userid TEXT,
|
|
ip TEXT
|
|
);
|
|
|
|
CREATE TABLE alts (
|
|
modlog_id INTEGER NOT NULL,
|
|
userid TEXT NOT NULL,
|
|
PRIMARY KEY (modlog_id, userid),
|
|
FOREIGN KEY (modlog_id) REFERENCES modlog(modlog_id)
|
|
) WITHOUT ROWID;
|
|
|
|
PRAGMA journal_mode=WAL;
|