| DROP TABLE TEAMPLAYER ; | |
| DROP TABLE PLAYER ; | |
| DROP TABLE TEAM ; | |
| DROP TABLE LEAGUE ; | |
| CREATE TABLE PLAYER | |
| ( | |
| PLAYER_ID VARCHAR(255) PRIMARY KEY, | |
| NAME VARCHAR(255), | |
| POSITION VARCHAR(255), | |
| SALARY DOUBLE PRECISION NOT NULL | |
| ) ENGINE=INNODB; | |
| CREATE TABLE LEAGUE | |
| ( | |
| LEAGUE_ID VARCHAR(255) PRIMARY KEY, | |
| NAME VARCHAR(255), | |
| SPORT VARCHAR(255) | |
| ) ENGINE=INNODB; | |
| CREATE TABLE TEAM | |
| ( | |
| TEAM_ID VARCHAR(255) PRIMARY KEY, | |
| CITY VARCHAR(255), | |
| NAME VARCHAR(255), | |
| LEAGUE_ID VARCHAR(255) | |
| ) ENGINE=INNODB; | |
| CREATE TABLE TEAMPLAYER | |
| ( | |
| PLAYER_ID VARCHAR(255), | |
| TEAM_ID VARCHAR(255), | |
| CONSTRAINT PK_TEAMPLAYER PRIMARY KEY (PLAYER_ID, TEAM_ID) | |
| ) ENGINE=INNODB; | |
| commit; | |
| quit; |