appserver/tests/v2-tests/appserv-tests/devtests/cmp/rosterext/sql/RosterApp_derby.sql

DROP TABLE TEAMPLAYER ;
DROP TABLE PLAYER ;
DROP TABLE TEAM ;
DROP TABLE LEAGUE ;

CREATE TABLE PLAYER
(
    player_Id VARCHAR(255) PRIMARY KEY NOT NULL,
    name VARCHAR(255),
    position VARCHAR(255),
    salary DOUBLE PRECISION NOT NULL
);

CREATE TABLE LEAGUE
(
    league_Id VARCHAR(255) PRIMARY KEY NOT NULL,
    name VARCHAR(255),
    sport VARCHAR(255)
);

CREATE TABLE TEAM
(
    team_Id VARCHAR(255) PRIMARY KEY NOT NULL,
    city VARCHAR(255),
    name VARCHAR(255),
    league_Id VARCHAR(255),
    FOREIGN KEY (league_Id)   REFERENCES League (league_Id)
);

CREATE TABLE TEAMPLAYER
(
    player_Id VARCHAR(255) NOT NULL,
        team_Id VARCHAR(255) NOT NULL,
        CONSTRAINT pk_TeamPlayer PRIMARY KEY (player_Id, team_Id),
    FOREIGN KEY (team_Id)   REFERENCES Team (team_Id),
    FOREIGN KEY (player_Id)   REFERENCES Player (player_Id)
);