142.sql (846B)
1 -- +migrate Up 2 CREATE TABLE IF NOT EXISTS chess_games ( 3 id INTEGER NOT NULL PRIMARY KEY, 4 uuid VARCHAR(100) UNIQUE NOT NULL, 5 created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, 6 updated_at DATETIME NULL DEFAULT CURRENT_TIMESTAMP, 7 white_user_id INTEGER NOT NULL, 8 black_user_id INTEGER NOT NULL, 9 pgn TEXT NOT NULL, 10 outcome VARCHAR(20) NOT NULL DEFAULT '*', 11 accuracy_white REAL NOT NULL DEFAULT 0, 12 accuracy_black REAL NOT NULL DEFAULT 0, 13 CONSTRAINT chess_games_white_user_id_fk 14 FOREIGN KEY (white_user_id) 15 REFERENCES users (id) 16 ON DELETE CASCADE 17 ON UPDATE CASCADE, 18 CONSTRAINT chess_games_black_user_id_fk 19 FOREIGN KEY (black_user_id) 20 REFERENCES users (id) 21 ON DELETE CASCADE 22 ON UPDATE CASCADE); 23 24 -- +migrate Down