64 lines
3.2 KiB
Transact-SQL
64 lines
3.2 KiB
Transact-SQL
USE "Gwent - The Witcher Card Game"
|
|
|
|
DECLARE @monster INT = (SELECT hmy FROM Factions WHERE name = 'Monsters')
|
|
DECLARE @nilfgaard INT = (SELECT hmy FROM Factions WHERE name = 'Nilfgaard')
|
|
DECLARE @northern_realms INT = (SELECT hmy FROM Factions WHERE name = 'Northern Realms')
|
|
DECLARE @scoiatael INT = (SELECT hmy FROM Factions WHERE name = 'Scoia''tael')
|
|
DECLARE @skellige INT = (SELECT hmy FROM Factions WHERE name = 'Skellige')
|
|
DECLARE @syndicate INT = (SELECT hmy FROM Factions WHERE name = 'Syndicate')
|
|
DECLARE @neutral INT = (SELECT hmy FROM Factions WHERE name = 'Neutral')
|
|
|
|
DECLARE @player1 INT = (SELECT hmy FROM Players WHERE name = 'Sif_Great_Wolf')
|
|
DECLARE @player2 INT = (SELECT hmy FROM Players WHERE name = 'Nik-r')
|
|
DECLARE @player3 INT = (SELECT hmy FROM Players WHERE name = 'lerio2')
|
|
DECLARE @player4 INT = (SELECT hmy FROM Players WHERE name = 'Mya-Mon369EX')
|
|
DECLARE @player5 INT = (SELECT hmy FROM Players WHERE name = 'Daniel.Cujba.54')
|
|
DECLARE @player6 INT = (SELECT hmy FROM Players WHERE name = 'RaChid-bhk')
|
|
|
|
INSERT INTO Matches (hPlayer1, hPlayer2, hPlayer1Faction, hPlayer2Faction, result)
|
|
VALUES
|
|
(@player1, @player2, @monster, @nilfgaard, 1),
|
|
(@player1, @player3, @monster, @northern_realms, 1),
|
|
(@player1, @player4, @monster, @scoiatael, 2),
|
|
(@player1, @player5, @monster, @skellige, 2),
|
|
(@player1, @player6, @monster, @syndicate, 1),
|
|
(@player2, @player3, @nilfgaard, @northern_realms, 3),
|
|
(@player2, @player4, @nilfgaard, @scoiatael, 1),
|
|
(@player2, @player5, @nilfgaard, @skellige, 1),
|
|
(@player2, @player6, @nilfgaard, @syndicate, 1),
|
|
(@player3, @player4, @northern_realms, @scoiatael, 2),
|
|
(@player3, @player5, @northern_realms, @skellige, 2),
|
|
(@player3, @player6, @northern_realms, @syndicate, 2),
|
|
(@player4, @player5, @scoiatael, @skellige, 2),
|
|
(@player4, @player6, @scoiatael, @syndicate, 1),
|
|
(@player5, @player6, @skellige, @syndicate, 2),
|
|
(@player1, @player2, @monster, @nilfgaard, 1),
|
|
(@player1, @player3, @monster, @northern_realms, 1),
|
|
(@player1, @player4, @monster, @scoiatael, 1),
|
|
(@player1, @player5, @monster, @skellige, 3),
|
|
(@player1, @player6, @monster, @syndicate, 3),
|
|
(@player2, @player3, @nilfgaard, @northern_realms, 1),
|
|
(@player2, @player4, @nilfgaard, @scoiatael, 3),
|
|
(@player2, @player5, @nilfgaard, @skellige, 1),
|
|
(@player2, @player6, @nilfgaard, @syndicate, 1),
|
|
(@player3, @player4, @northern_realms, @scoiatael, 1),
|
|
(@player3, @player5, @northern_realms, @skellige, 1),
|
|
(@player3, @player6, @northern_realms, @syndicate, 1),
|
|
(@player4, @player5, @scoiatael, @skellige, 1),
|
|
(@player4, @player6, @scoiatael, @syndicate, 1),
|
|
(@player5, @player6, @skellige, @syndicate, 2),
|
|
(@player1, @player2, @monster, @nilfgaard, 2),
|
|
(@player1, @player3, @monster, @northern_realms, 2),
|
|
(@player1, @player4, @monster, @scoiatael, 2),
|
|
(@player1, @player5, @monster, @skellige, 2),
|
|
(@player1, @player6, @monster, @syndicate, 1),
|
|
(@player2, @player3, @nilfgaard, @northern_realms, 1),
|
|
(@player2, @player4, @nilfgaard, @scoiatael, 1),
|
|
(@player2, @player5, @nilfgaard, @skellige, 2),
|
|
(@player2, @player6, @nilfgaard, @syndicate, 2),
|
|
(@player3, @player4, @northern_realms, @scoiatael, 1),
|
|
(@player3, @player5, @northern_realms, @skellige, 1),
|
|
(@player3, @player6, @northern_realms, @syndicate, 1),
|
|
(@player4, @player5, @scoiatael, @skellige, 2),
|
|
(@player4, @player6, @scoiatael, @syndicate, 1)
|