· 8 years ago · Jul 11, 2018, 12:34 AM
1SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
2
3SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
4
5SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';
6
7
8
9CREATE SCHEMA IF NOT EXISTS `betting_odds` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci ;
10
11USE `betting_odds`;
12
13
14
15-- -----------------------------------------------------
16
17-- Table `betting_odds`.`bookie`
18
19-- -----------------------------------------------------
20
21DROP TABLE IF EXISTS `betting_odds`.`bookie` ;
22
23
24
25CREATE TABLE IF NOT EXISTS `betting_odds`.`bookie` (
26
27 `bookie_id` INT NOT NULL AUTO_INCREMENT ,
28
29 `name` VARCHAR(45) NOT NULL ,
30
31 `betsTaken` INT NOT NULL ,
32
33 `betsWon` INT NOT NULL ,
34
35 `balance` FLOAT NOT NULL ,
36
37 `username` VARCHAR(45) NOT NULL ,
38
39 `password` VARCHAR(45) NOT NULL ,
40
41 PRIMARY KEY (`bookie_id`) )
42
43ENGINE = InnoDB;
44
45
46
47
48
49-- -----------------------------------------------------
50
51-- Table `betting_odds`.`sport`
52
53-- -----------------------------------------------------
54
55DROP TABLE IF EXISTS `betting_odds`.`sport` ;
56
57
58
59CREATE TABLE IF NOT EXISTS `betting_odds`.`sport` (
60
61 `sport_id` INT NOT NULL AUTO_INCREMENT ,
62
63 `name` VARCHAR(45) NOT NULL ,
64
65 PRIMARY KEY (`sport_id`) )
66
67ENGINE = InnoDB;
68
69
70
71
72
73-- -----------------------------------------------------
74
75-- Table `betting_odds`.`event`
76
77-- -----------------------------------------------------
78
79DROP TABLE IF EXISTS `betting_odds`.`event` ;
80
81
82
83CREATE TABLE IF NOT EXISTS `betting_odds`.`event` (
84
85 `event_id` INT NOT NULL AUTO_INCREMENT ,
86
87 `l_sport_id` INT NOT NULL ,
88
89 `date` DATE NOT NULL ,
90
91 `time` TIME NOT NULL ,
92
93 `return` FLOAT NULL ,
94
95 `totalStake` FLOAT NULL ,
96
97 `bet` TINYINT(1) NULL ,
98
99 PRIMARY KEY (`event_id`) ,
100
101 INDEX `l_sport_id_1` (`l_sport_id` ASC) ,
102
103 INDEX `bet` (`bet` ASC) ,
104
105 CONSTRAINT `l_sport_id_1`
106
107 FOREIGN KEY (`l_sport_id` )
108
109 REFERENCES `betting_odds`.`sport` (`sport_id` )
110
111 ON DELETE NO ACTION
112
113 ON UPDATE NO ACTION)
114
115ENGINE = InnoDB;
116
117
118
119
120
121-- -----------------------------------------------------
122
123-- Table `betting_odds`.`bet`
124
125-- -----------------------------------------------------
126
127DROP TABLE IF EXISTS `betting_odds`.`bet` ;
128
129
130
131CREATE TABLE IF NOT EXISTS `betting_odds`.`bet` (
132
133 `bet_id` INT NOT NULL AUTO_INCREMENT ,
134
135 `l_bookie_id` INT NOT NULL ,
136
137 `l_event_id` INT NOT NULL ,
138
139 `odds` FLOAT NOT NULL ,
140
141 `stake` FLOAT NOT NULL ,
142
143 PRIMARY KEY (`bet_id`) ,
144
145 INDEX `l_event_id_1` (`l_event_id` ASC) ,
146
147 INDEX `l_bookie_id_1` (`l_bookie_id` ASC) ,
148
149 CONSTRAINT `l_event_id_1`
150
151 FOREIGN KEY (`l_event_id` )
152
153 REFERENCES `betting_odds`.`event` (`event_id` )
154
155 ON DELETE CASCADE
156
157 ON UPDATE NO ACTION,
158
159 CONSTRAINT `l_bookie_id_1`
160
161 FOREIGN KEY (`l_bookie_id` )
162
163 REFERENCES `betting_odds`.`bookie` (`bookie_id` )
164
165 ON DELETE NO ACTION
166
167 ON UPDATE NO ACTION)
168
169ENGINE = InnoDB;
170
171
172
173
174
175-- -----------------------------------------------------
176
177-- Table `betting_odds`.`overround`
178
179-- -----------------------------------------------------
180
181DROP TABLE IF EXISTS `betting_odds`.`overround` ;
182
183
184
185CREATE TABLE IF NOT EXISTS `betting_odds`.`overround` (
186
187 `overround_id` INT NOT NULL AUTO_INCREMENT ,
188
189 `l_event_id` INT NOT NULL ,
190
191 `overround` FLOAT NOT NULL ,
192
193 `time` INT NOT NULL ,
194
195 PRIMARY KEY (`overround_id`) ,
196
197 INDEX `l_event_id_2` (`l_event_id` ASC) ,
198
199 CONSTRAINT `l_event_id_2`
200
201 FOREIGN KEY (`l_event_id` )
202
203 REFERENCES `betting_odds`.`event` (`event_id` )
204
205 ON DELETE NO ACTION
206
207 ON UPDATE NO ACTION)
208
209ENGINE = InnoDB;
210
211
212
213
214
215
216
217SET SQL_MODE=@OLD_SQL_MODE;
218
219SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
220
221SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;