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

drop table TEAMPLAYER
drop table PLAYER
drop table TEAM
drop TABLE LEAGUE
go

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)
)

go