25 lines
1.3 KiB
SQL
25 lines
1.3 KiB
SQL
CREATE TABLE IF NOT EXISTS sport (
|
|
"id" INT,
|
|
"code" TEXT,
|
|
"link" TEXT,
|
|
"name" TEXT,
|
|
"abbreviation" TEXT,
|
|
"sortOrder" INT,
|
|
"activeStatus" TEXT
|
|
);
|
|
INSERT INTO sport VALUES
|
|
(1,'mlb','/api/v1/sports/1','Major League Baseball','MLB',11,'True'),
|
|
(11,'aaa','/api/v1/sports/11','Triple-A','AAA',101,'True'),
|
|
(12,'aax','/api/v1/sports/12','Double-A','AA',201,'True'),
|
|
(13,'afa','/api/v1/sports/13','High-A','A+',301,'True'),
|
|
(14,'afx','/api/v1/sports/14','Single-A','A',401,'True'),
|
|
(16,'rok','/api/v1/sports/16','Rookie','ROK',701,'True'),
|
|
(17,'win','/api/v1/sports/17','Winter Leagues','WIN',1301,'True'),
|
|
(8,'bbl','/api/v1/sports/8','Organized Baseball','Pros',1401,'True'),
|
|
(21,'min','/api/v1/sports/21','Minor League Baseball','Minors',1402,'True'),
|
|
(23,'ind','/api/v1/sports/23','Independent Leagues','IND',2101,'True'),
|
|
(51,'int','/api/v1/sports/51','International Baseball','INT',3501,'True'),
|
|
(509,'nae','/api/v1/sports/509','International Baseball (18U)','18U',3503,'True'),
|
|
(510,'nas','/api/v1/sports/510','International Baseball (16 and under)','16U',3505,'True'),
|
|
(22,'bbc','/api/v1/sports/22','College Baseball','College',5101,'True'),
|
|
(586,'hsb','/api/v1/sports/586','High School Baseball','H.S.',6201,'True'); |