· 7 years ago · Feb 22, 2019, 01:44 AM
1
2
3-- -----------------------------------------------------
4-- Table `work_rate`
5-- -----------------------------------------------------
6CREATE TABLE IF NOT EXISTS `work_rate` (
7 `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
8 `workRate` VARCHAR(45) NOT NULL,
9 PRIMARY KEY (`id`),
10 UNIQUE INDEX `id_UNIQUE` (`id` ASC) ,
11 UNIQUE INDEX `workRate_UNIQUE` (`workRate` ASC) )
12ENGINE = InnoDB;
13
14
15-- -----------------------------------------------------
16-- Table `position`
17-- -----------------------------------------------------
18CREATE TABLE IF NOT EXISTS `position` (
19 `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
20 `position` VARCHAR(45) NULL,
21 PRIMARY KEY (`id`))
22ENGINE = InnoDB;
23
24
25-- -----------------------------------------------------
26-- Table `body_type`
27-- -----------------------------------------------------
28CREATE TABLE IF NOT EXISTS `body_type` (
29 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
30 `name` VARCHAR(20) NOT NULL,
31 PRIMARY KEY (`id`),
32 UNIQUE INDEX `id_UNIQUE` (`id` ASC) ,
33 UNIQUE INDEX `name_UNIQUE` (`name` ASC) )
34ENGINE = InnoDB
35DEFAULT CHARACTER SET = utf8;
36
37
38-- -----------------------------------------------------
39-- Table `club`
40-- -----------------------------------------------------
41CREATE TABLE IF NOT EXISTS `club` (
42 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
43 `name` VARCHAR(139) NULL DEFAULT NULL,
44 `logo` VARCHAR(50) NULL DEFAULT NULL,
45 PRIMARY KEY (`id`),
46 UNIQUE INDEX `id_UNIQUE` (`id` ASC) ,
47 UNIQUE INDEX `name_UNIQUE` (`name` ASC) )
48ENGINE = InnoDB
49DEFAULT CHARACTER SET = utf8;
50
51
52-- -----------------------------------------------------
53-- Table `country`
54-- -----------------------------------------------------
55CREATE TABLE IF NOT EXISTS `country` (
56 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
57 `name` VARCHAR(25) NOT NULL,
58 `flag_url` VARCHAR(40) NOT NULL,
59 PRIMARY KEY (`id`),
60 UNIQUE INDEX `id_UNIQUE` (`id` ASC) ,
61 UNIQUE INDEX `name_UNIQUE` (`name` ASC) ,
62 UNIQUE INDEX `flag_url_UNIQUE` (`flag_url` ASC) )
63ENGINE = InnoDB
64DEFAULT CHARACTER SET = utf8;
65
66
67-- -----------------------------------------------------
68-- Table `prefered_foot`
69-- -----------------------------------------------------
70CREATE TABLE IF NOT EXISTS `prefered_foot` (
71 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
72 `name` VARCHAR(10) NOT NULL,
73 PRIMARY KEY (`id`),
74 UNIQUE INDEX `id_UNIQUE` (`id` ASC) ,
75 UNIQUE INDEX `name_UNIQUE` (`name` ASC) )
76ENGINE = InnoDB
77DEFAULT CHARACTER SET = utf8;
78
79
80-- -----------------------------------------------------
81-- Table `player`
82-- -----------------------------------------------------
83CREATE TABLE IF NOT EXISTS `player` (
84 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
85 `name` VARCHAR(45) NOT NULL,
86 `age` INT(10) UNSIGNED NOT NULL,
87 `realFace` VARCHAR(3) NULL,
88 `photo_url` VARCHAR(50) NOT NULL,
89 `club_id` INT(10) UNSIGNED NULL DEFAULT NULL,
90 `position_id` INT UNSIGNED NULL,
91 `jerseyNumber` INT UNSIGNED NULL,
92 `country_id` INT(10) UNSIGNED NOT NULL,
93 `prefered_foot_id` INT(10) UNSIGNED NULL DEFAULT NULL,
94 `body_type_id` INT(10) UNSIGNED NULL DEFAULT NULL,
95 `work_rate_id` INT UNSIGNED NULL,
96 `special` INT NULL,
97 `internationalReputation` INT NULL,
98 `overall` INT NULL,
99 `potential` INT NULL,
100 PRIMARY KEY (`id`),
101 UNIQUE INDEX `id_UNIQUE` (`id` ASC) ,
102 INDEX `fk_player_club_idx` (`club_id` ASC) ,
103 INDEX `fk_player_country1_idx` (`country_id` ASC) ,
104 INDEX `fk_player_body_type1_idx` (`body_type_id` ASC) ,
105 INDEX `fk_player_prefered_foot1_idx` (`prefered_foot_id` ASC) ,
106 INDEX `fk_player_position1_idx` (`position_id` ASC) ,
107 INDEX `fk_player_work_rate1_idx` (`work_rate_id` ASC) ,
108 CONSTRAINT `fk_player_body_type1`
109 FOREIGN KEY (`body_type_id`)
110 REFERENCES `body_type` (`id`)
111 ON DELETE CASCADE
112 ON UPDATE CASCADE,
113 CONSTRAINT `fk_player_club`
114 FOREIGN KEY (`club_id`)
115 REFERENCES `club` (`id`)
116 ON DELETE CASCADE
117 ON UPDATE CASCADE,
118 CONSTRAINT `fk_player_country1`
119 FOREIGN KEY (`country_id`)
120 REFERENCES `country` (`id`)
121 ON DELETE CASCADE
122 ON UPDATE CASCADE,
123 CONSTRAINT `fk_player_prefered_foot1`
124 FOREIGN KEY (`prefered_foot_id`)
125 REFERENCES `prefered_foot` (`id`)
126 ON DELETE CASCADE
127 ON UPDATE CASCADE,
128 CONSTRAINT `fk_player_position1`
129 FOREIGN KEY (`position_id`)
130 REFERENCES `position` (`id`)
131 ON DELETE CASCADE
132 ON UPDATE CASCADE,
133 CONSTRAINT `fk_player_work_rate1`
134 FOREIGN KEY (`work_rate_id`)
135 REFERENCES `work_rate` (`id`)
136 ON DELETE CASCADE
137 ON UPDATE CASCADE)
138ENGINE = InnoDB
139DEFAULT CHARACTER SET = utf8;
140
141
142-- -----------------------------------------------------
143-- Table `player_contract`
144-- -----------------------------------------------------
145CREATE TABLE IF NOT EXISTS `player_contract` (
146 `player_id` INT(10) UNSIGNED NOT NULL,
147 `joined_date` INT(11) NULL DEFAULT NULL,
148 `value` INT(10) NULL,
149 `wage` INT(10) NULL DEFAULT NULL,
150 `contract_valid_untill` VARCHAR(10) NULL DEFAULT NULL,
151 `release_clause` INT(10) NULL DEFAULT NULL,
152 `loaned_from` INT(10) UNSIGNED NULL,
153 PRIMARY KEY (`player_id`),
154 INDEX `fk_player_contract_club1_idx` (`loaned_from` ASC) ,
155 CONSTRAINT `fk_player_contract_player1`
156 FOREIGN KEY (`player_id`)
157 REFERENCES `player` (`id`)
158 ON DELETE CASCADE
159 ON UPDATE CASCADE,
160 CONSTRAINT `fk_player_contract_club1`
161 FOREIGN KEY (`loaned_from`)
162 REFERENCES `club` (`id`)
163 ON DELETE CASCADE
164 ON UPDATE CASCADE)
165ENGINE = InnoDB
166DEFAULT CHARACTER SET = utf8;
167
168
169-- -----------------------------------------------------
170-- Table `player_stats`
171-- -----------------------------------------------------
172CREATE TABLE IF NOT EXISTS `player_stats` (
173 `player_id` INT(10) UNSIGNED NOT NULL,
174 `height` VARCHAR(4) NULL,
175 `weight` INT(3) NULL,
176 `weakFoot` INT NULL,
177 `skillMoves` INT NULL,
178 `ls` VARCHAR(5) NULL,
179 `st` VARCHAR(5) NULL,
180 `rs` VARCHAR(5) NULL,
181 `lw` VARCHAR(5) NULL,
182 `lf` VARCHAR(5) NULL,
183 `cf` VARCHAR(5) NULL,
184 `rf` VARCHAR(5) NULL,
185 `rw` VARCHAR(5) NULL,
186 `lam` VARCHAR(5) NULL,
187 `cam` VARCHAR(5) NULL,
188 `ram` VARCHAR(5) NULL,
189 `lm` VARCHAR(5) NULL,
190 `lcm` VARCHAR(5) NULL,
191 `cm` VARCHAR(5) NULL,
192 `rcm` VARCHAR(5) NULL,
193 `rm` VARCHAR(5) NULL,
194 `lwb` VARCHAR(5) NULL,
195 `ldm` VARCHAR(5) NULL,
196 `cdm` VARCHAR(5) NULL,
197 `rdm` VARCHAR(5) NULL,
198 `rwb` VARCHAR(5) NULL,
199 `lb` VARCHAR(5) NULL,
200 `lcb` VARCHAR(5) NULL,
201 `cb` VARCHAR(5) NULL,
202 `rcb` VARCHAR(5) NULL,
203 `rb` VARCHAR(5) NULL,
204 `crossing` INT(3) NULL,
205 `finishing` INT(3) NULL,
206 `headingAccuracy` INT(3) NULL,
207 `shortPassing` INT(3) NULL,
208 `volleys` INT(3) NULL,
209 `dribbling` INT(3) NULL,
210 `curve` INT(3) NULL,
211 `fKAccuracy` INT(3) NULL,
212 `longPassing` INT(3) NULL,
213 `ballControl` INT(3) NULL,
214 `acceleration` INT(3) NULL,
215 `sprintSpeed` INT(3) NULL,
216 `agility` INT(3) NULL,
217 `reactions` INT(3) NULL,
218 `balance` INT(3) NULL,
219 `shotPower` INT(3) NULL,
220 `jumping` INT(3) NULL,
221 `stamina` INT(3) NULL,
222 `strenght` INT(3) NULL,
223 `longShots` INT(3) NULL,
224 `aggression` INT(3) NULL,
225 `interception` INT(3) NULL,
226 `positioning` INT(3) NULL,
227 `vision` INT(3) NULL,
228 `penalties` INT(3) NULL,
229 `composure` INT(3) NULL,
230 `marking` INT(3) NULL,
231 `standingTackle` INT(3) NULL,
232 `slidingTackle` INT(3) NULL,
233 `GKDiving` INT(3) NULL,
234 `GKHandling` INT(3) NULL,
235 `GKKicking` INT(3) NULL,
236 `GKPositioning` INT(3) NULL,
237 `GKReflexes` INT(3) NULL,
238 PRIMARY KEY (`player_id`),
239 CONSTRAINT `fk_player_stats_player1`
240 FOREIGN KEY (`player_id`)
241 REFERENCES `player` (`id`)
242 ON DELETE CASCADE
243 ON UPDATE CASCADE)
244ENGINE = InnoDB
245DEFAULT CHARACTER SET = utf8;