mirror of
https://github.com/smogon/pokemon-showdown.git
synced 2026-03-22 01:35:31 -05:00
17 lines
368 B
SQL
17 lines
368 B
SQL
BEGIN TRANSACTION;
|
|
|
|
-- Logs of each flag
|
|
CREATE TABLE perspective_flags (
|
|
userid TEXT NOT NULL,
|
|
score NUMBER NOT NULL,
|
|
certainty NUMBER NOT NULL,
|
|
type TEXT NOT NULL,
|
|
roomid TEXT NOT NULL,
|
|
time NUMBER NOT NULL
|
|
);
|
|
|
|
CREATE INDEX search_idx ON perspective_flags(type, userid);
|
|
-- update database version
|
|
UPDATE db_info SET value = '6' WHERE key = 'version';
|
|
COMMIT;
|