-- Insert a test data set to simulate an active game for testing
-- @author Eric Pietrocupo
-- @date February 19th, 2026
-- @license GNU GPL 3.0


-- insert basic players, event only used if cards are enabled
INSERT INTO player ( pk, name,  money, ishuman)
VALUES
( 1, "Jerry A", 5000, 'Y'),
( 2, "Jimmy B", 5000, 'Y'),
( 3, "Johnny C", 5000, 'Y');

-- Change some variant rules on demand
--UPDATE variant SET isenabled = 'Y' WHERE pk = 0; -- DIV goes up
--UPDATE variant SET isenabled = 'Y' WHERE pk = 2; -- cards

-- UPDATE event SET available = 'N' WHERE pk=11;
-- UPDATE event SET available = 'N' WHERE pk=22;
-- UPDATE event SET available = 'N' WHERE pk=33;


INSERT INTO game ( turn_number, game_length, fk_active_player, nb_roll)
VALUES ( 0, 3, 1, 3);


