You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
44 lines
846 B
44 lines
846 B
INSERT INTO games
|
|
(id, division, team_home, team_away, start_at, end_at)
|
|
VALUES
|
|
(
|
|
1,
|
|
1, -- LV/D
|
|
1, -- Bullseye
|
|
2, -- Seecats
|
|
'2022-03-25 17:00:00 America/Toronto',
|
|
'2022-03-25 18:30:00 America/Toronto'
|
|
),
|
|
(
|
|
2,
|
|
1, -- LV/D
|
|
1, -- Bullseye
|
|
2, -- Seecats
|
|
'2022-03-26 12:00:00 America/Toronto',
|
|
'2022-03-26 13:30:00 America/Toronto'
|
|
),
|
|
(
|
|
3,
|
|
1, -- LV/D
|
|
1, -- Bullseye
|
|
2, -- Seecats
|
|
'2022-03-26 17:30:00 America/Toronto',
|
|
'2022-03-26 19:00:00 America/Toronto'
|
|
),
|
|
(
|
|
4,
|
|
1, -- LV/D
|
|
1, -- Bullseye
|
|
2, -- Seecats
|
|
'2022-03-27 10:00:00 America/Toronto',
|
|
'2022-03-27 11:30:00 America/Toronto'
|
|
);
|
|
|
|
INSERT INTO game_names
|
|
(id, game, name, language)
|
|
VALUES
|
|
(1, 1, 'Game 1', 1),
|
|
(2, 2, 'Game 2', 1),
|
|
(3, 3, 'Game 3', 1),
|
|
(4, 4, 'Game 4', 1);
|