29 lines
1.6 KiB
SQL
29 lines
1.6 KiB
SQL
CREATE TABLE IF NOT EXISTS league (
|
|
"id" INT,
|
|
"name" TEXT,
|
|
"link" TEXT,
|
|
"abbreviation" TEXT,
|
|
"nameShort" TEXT,
|
|
"seasonState" TEXT,
|
|
"hasWildCard" TEXT,
|
|
"hasSplitSeason" TEXT,
|
|
"numGames" INT,
|
|
"hasPlayoffPoints" TEXT,
|
|
"numTeams" INT,
|
|
"numWildcardTeams" INT,
|
|
"orgCode" TEXT,
|
|
"conferencesInUse" TEXT,
|
|
"divisionsInUse" TEXT,
|
|
"sportId" INT,
|
|
"sortOrder" INT,
|
|
"active" TEXT
|
|
);
|
|
INSERT INTO league VALUES
|
|
(103,'American League','/api/v1/league/103','AL','American','offseason','True','False',162,'False',15,3,'AL','False','True',1,21,'True'),
|
|
(104,'National League','/api/v1/league/104','NL','National','offseason','True','False',162,'False',15,3,'NL','False','True',1,31,'True'),
|
|
(114,'Cactus League','/api/v1/league/114','CL','Cactus','offseason','False','False',NULL,'False',NULL,NULL,'CL','False','False',NULL,51,'True'),
|
|
(115,'Grapefruit League','/api/v1/league/115','GL','Grapefruit','offseason','False','False',NULL,'False',NULL,NULL,'GL','False','False',NULL,52,'True'),
|
|
(100,'American Association','/api/v1/league/100','AA',NULL,'offseason','False','False',NULL,NULL,9,NULL,'AA','False','False',1,2811,'False'),
|
|
(105,'Players League','/api/v1/league/105','PL',NULL,'offseason','False','False',NULL,NULL,8,NULL,'PL','False','False',1,2831,'False'),
|
|
(101,'Union Association','/api/v1/league/101','UA',NULL,'offseason','False','False',NULL,NULL,12,NULL,'UA','False','False',1,2841,'False'),
|
|
(106,'Federal League','/api/v1/league/106','FL',NULL,'offseason','False','False',154,NULL,8,NULL,'FL','False','False',1,2851,'False'); |