Java EE学习笔记

2017-01-11

create database SoccerLeague;
use SoccerLeague;

create table League (
    lid integer primary key auto_increment,
    lyear integer not null,
    season varchar(10) not null,
    title varchar(30) not null);

create table Player(
    pid integer primary key auto_increment,
    name varchar(30) not null,
    address varchar(30) not null,
    city varchar(20) not null,
    email varchar(40) not null);

create table Registration(
    rid integer primary key auto_increment,
    division varchar(20) not null,
    LEAGUE_LID integer not null,
    PLAYER_PID integer not null);

create table AdminUser(
    uid integer primary key,
    username varchar(20) not null,
    password varchar(20) not null);

insert into League(lid, lyear, season, title) values(1, 2008, 'Spring', 'Soccer League (Spring "08)');

insert into League(lid, lyear, season, title) values(2, 2008, 'Summer', 'Summer Soccer Fest 2008');

insert into League(lid, lyear, season, title) values(3, 2008, 'Fall', 'Fall Soccer League  (2008)');

insert into League(lid, lyear, season, title) values(4, 2009, 'Spring', 'Soccer League (Spring "09)');

insert into League(lid, lyear, season, title) values(5, 2009, 'Summer', 'The Summer of Soccer Love 2009');

insert into League(lid, lyear, season, title) values(6, 2009, 'Fall', 'Fall Soccer League (2009)');

insert into AdminUser(uid, username, password) values(100, 'admin', 'admin');

insert into AdminUser(uid, username, password) values(101, 'jack', 'admin');


注明:本文章属于转载,仅供行业人员学习交流使用,文章版权属于原创作者,在此向原创者致敬,感谢原创作者为大家学习交流提供精品内容。

站方声明:IThao123是为广大互联网从业者免费提供学习交流的平台,如果侵犯了原创著作权,请联系站方删除,给你带来不便,深表歉意。

顶部