SQLite3 DDL for a small-sized collection of Players.

players-sqlite3-ddl.sql

PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE IF NOT EXISTS "players" (
    "id"            INTEGER,
    "firstName"     TEXT NOT NULL,
    "middleName"    TEXT,
    "lastName"      TEXT NOT NULL,
    "dateOfBirth"   TEXT,
    "squadNumber"   INTEGER NOT NULL,
    "position"      TEXT NOT NULL,
    "abbrPosition"  TEXT,
    "team"          TEXT,
    "league"        TEXT,
    "starting11"    BOOLEAN,
    PRIMARY KEY("id")
);

-- =============================================================================
-- STARTING XI (starting11 = 1)
-- =============================================================================
INSERT INTO players VALUES(1,'Damián','Emiliano','Martínez','1992-09-02T00:00:00.000Z',23,'Goalkeeper','GK','Aston Villa FC','Premier League',1);
INSERT INTO players VALUES(2,'Nahuel',NULL,'Molina','1998-04-06T00:00:00.000Z',26,'Right-Back','RB','Atlético Madrid','La Liga',1);
INSERT INTO players VALUES(3,'Cristian','Gabriel','Romero','1998-04-27T00:00:00.000Z',13,'Centre-Back','CB','Tottenham Hotspur','Premier League',1);
INSERT INTO players VALUES(4,'Nicolás','Hernán Gonzalo','Otamendi','1988-02-12T00:00:00.000Z',19,'Centre-Back','CB','SL Benfica','Liga Portugal',1);
INSERT INTO players VALUES(5,'Nicolás','Alejandro','Tagliafico','1992-08-31T00:00:00.000Z',3,'Left-Back','LB','Olympique Lyon','Ligue 1',1);
INSERT INTO players VALUES(6,'Ángel','Fabián','Di María','1988-02-14T00:00:00.000Z',11,'Right Winger','RW','SL Benfica','Liga Portugal',1);
INSERT INTO players VALUES(7,'Rodrigo','Javier','de Paul','1994-05-24T00:00:00.000Z',7,'Central Midfield','CM','Atlético Madrid','La Liga',1);
INSERT INTO players VALUES(8,'Enzo','Jeremías','Fernández','2001-01-17T00:00:00.000Z',24,'Central Midfield','CM','SL Benfica','Liga Portugal',1);
INSERT INTO players VALUES(9,'Alexis',NULL,'Mac Allister','1998-12-24T00:00:00.000Z',20,'Central Midfield','CM','Brighton & Hove Albion','Premier League',1);
INSERT INTO players VALUES(10,'Lionel','Andrés','Messi','1987-06-24T00:00:00.000Z',10,'Right Winger','RW','Paris Saint-Germain','Ligue 1',1);
INSERT INTO players VALUES(11,'Julián',NULL,'Álvarez','2000-01-31T00:00:00.000Z',9,'Centre-Forward','CF','Manchester City','Premier League',1);

-- =============================================================================
-- SUBSTITUTES (starting11 = 0)
-- =============================================================================
INSERT INTO players VALUES(12,'Franco','Daniel','Armani','1986-10-16T00:00:00.000Z',1,'Goalkeeper','GK','River Plate','Copa de la Liga',0);
INSERT INTO players VALUES(13,'Gerónimo',NULL,'Rulli','1992-05-20T00:00:00.000Z',12,'Goalkeeper','GK','Villarreal CF','La Liga',0);
INSERT INTO players VALUES(14,'Juan','Marcos','Foyth','1998-01-12T00:00:00.000Z',2,'Right-Back','RB','Villarreal CF','La Liga',0);
INSERT INTO players VALUES(15,'Gonzalo','Ariel','Montiel','1997-01-01T00:00:00.000Z',4,'Right-Back','RB','Sevilla FC','La Liga',0);
INSERT INTO players VALUES(16,'Germán','Alejo','Pezzella','1991-06-27T00:00:00.000Z',6,'Centre-Back','CB','Real Betis Balompié','La Liga',0);
INSERT INTO players VALUES(17,'Marcos','Javier','Acuña','1991-10-28T00:00:00.000Z',8,'Left-Back','LB','Sevilla FC','La Liga',0);
INSERT INTO players VALUES(18,'Lisandro',NULL,'Martínez','1998-01-18T00:00:00.000Z',25,'Centre-Back','CB','Manchester United','Premier League',0);
INSERT INTO players VALUES(19,'Leandro','Daniel','Paredes','1994-06-29T00:00:00.000Z',5,'Defensive Midfield','DM','AS Roma','Serie A',0);
INSERT INTO players VALUES(20,'Exequiel','Alejandro','Palacios','1998-10-05T00:00:00.000Z',14,'Central Midfield','CM','Bayer 04 Leverkusen','Bundesliga',0);
INSERT INTO players VALUES(21,'Alejandro','Darío','Gómez','1988-02-15T00:00:00.000Z',17,'Left Winger','LW','Sevilla FC','La Liga',0);
INSERT INTO players VALUES(22,'Guido',NULL,'Rodríguez','1994-04-12T00:00:00.000Z',18,'Defensive Midfield','DM','Real Betis Balompié','La Liga',0);
INSERT INTO players VALUES(23,'Ángel','Martín','Correa','1995-03-09T00:00:00.000Z',15,'Right Winger','RW','Atlético Madrid','La Liga',0);
INSERT INTO players VALUES(24,'Thiago','Ezequiel','Almada','2001-04-26T00:00:00.000Z',16,'Attacking Midfield','AM','Atlanta United FC','Major League Soccer',0);
INSERT INTO players VALUES(25,'Paulo','Exequiel','Dybala','1993-11-15T00:00:00.000Z',21,'Second Striker','SS','AS Roma','Serie A',0);
INSERT INTO players VALUES(26,'Lautaro','Javier','Martínez','1997-08-22T00:00:00.000Z',22,'Centre-Forward','CF','Inter Milan','Serie A',0);

-- =============================================================================
-- PRELIMINARY LIST ONLY — not in final squad of 26.                          --
-- These records are NOT inserted. Use them as fixtures for CREATE/DELETE     --
-- tests so that test data reflects real players from the 2022 World Cup      --
-- preliminary squad. Club and league reflect status at November 2022.        --
-- =============================================================================

-- Primary fixture for CREATE / DELETE tests
-- INSERT INTO players VALUES(27,'Giovani',NULL,'Lo Celso','1996-04-09T00:00:00.000Z',27,'Central Midfield','CM','Villarreal CF','La Liga',0);

-- Optional extras if a specific position is needed as a fixture
-- INSERT INTO players VALUES(28,'Juan','Agustín','Musso','1994-05-06T00:00:00.000Z',28,'Goalkeeper','GK','Atalanta BC','Serie A',0);
-- INSERT INTO players VALUES(29,'Facundo',NULL,'Medina','1999-05-26T00:00:00.000Z',29,'Centre-Back','CB','RC Lens','Ligue 1',0);

COMMIT;