mirror of
https://github.com/smogon/pokemon-showdown.git
synced 2026-03-21 17:25:10 -05:00
15 lines
309 B
SQL
15 lines
309 B
SQL
BEGIN TRANSACTION;
|
|
|
|
-- Logs of renames
|
|
CREATE TABLE alts_log (
|
|
to_id TEXT NOT NULL,
|
|
from_id TEXT NOT NULL,
|
|
ip TEXT NOT NULL,
|
|
PRIMARY KEY (to_id, from_id)
|
|
);
|
|
|
|
CREATE INDEX search_idx_alts on alts_log(from_id, to_id);
|
|
-- update database version
|
|
UPDATE db_info SET value = '7' WHERE key = 'version';
|
|
COMMIT;
|