1 -- MySQL Script generated by MySQL Workbench
3 -- Model: New Model Version: 1.0
4 -- MySQL Workbench Forward Engineering
6 SET @OLD_UNIQUE_CHECKS
=@@UNIQUE_CHECKS
, UNIQUE_CHECKS
=0;
7 SET @OLD_FOREIGN_KEY_CHECKS
=@@FOREIGN_KEY_CHECKS
, FOREIGN_KEY_CHECKS
=0;
8 SET @OLD_SQL_MODE
=@@SQL_MODE
, SQL_MODE
='TRADITIONAL,ALLOW_INVALID_DATES';
10 -- -----------------------------------------------------
12 -- -----------------------------------------------------
14 -- -----------------------------------------------------
16 -- -----------------------------------------------------
17 CREATE SCHEMA IF NOT EXISTS `vizon`
DEFAULT CHARACTER SET latin1
;
20 -- -----------------------------------------------------
21 -- Table `vizon`.`vizon_users`
22 -- -----------------------------------------------------
23 CREATE TABLE IF NOT EXISTS `vizon`.`vizon_users`
(
24 `
id`
INT NOT NULL AUTO_INCREMENT
,
25 `nick`
VARCHAR(64) NOT NULL,
26 `vhost`
VARCHAR(64) NULL,
27 `eligible`
TINYINT(1) NULL DEFAULT 0,
28 `bold`
TINYINT(1) NULL DEFAULT 0,
29 `expires`
INT NULL DEFAULT -1,
30 `obtained`
TIMESTAMP NULL,
31 `multiplier`
INT NULL DEFAULT 1,
32 `jackpot`
TINYINT(1) NULL DEFAULT 0,
33 `permanent`
TINYINT(1) NULL DEFAULT 0,
34 `days`
INT NULL DEFAULT 0,
36 UNIQUE INDEX `nick_UNIQUE`
(`nick`
ASC))
40 -- -----------------------------------------------------
41 -- Table `vizon`.`vizon_drawings`
42 -- -----------------------------------------------------
43 CREATE TABLE IF NOT EXISTS `vizon`.`vizon_drawings`
(
44 `
id`
INT NOT NULL AUTO_INCREMENT
,
51 `drawing_date`
TIMESTAMP NOT NULL,
56 -- -----------------------------------------------------
57 -- Table `vizon`.`vizon_bets`
58 -- -----------------------------------------------------
59 CREATE TABLE IF NOT EXISTS `vizon`.`vizon_bets`
(
60 `
id`
INT NOT NULL AUTO_INCREMENT
,
61 `vizon_users_id`
INT NOT NULL,
62 `vizon_drawings_id`
INT NOT NULL,
64 `
second`
INT NOT NULL,
66 `fourth`
INT NOT NULL,
69 `placed`
TIMESTAMP NOT NULL DEFAULT NOW(),
71 INDEX `fk_vizon_bets_vizon_users_idx`
(`vizon_users_id`
ASC),
72 INDEX `fk_vizon_bets_vizon_drawings1_idx`
(`vizon_drawings_id`
ASC),
73 CONSTRAINT `fk_vizon_bets_vizon_users`
74 FOREIGN KEY (`vizon_users_id`
)
75 REFERENCES `vizon`.`vizon_users`
(`
id`
)
78 CONSTRAINT `fk_vizon_bets_vizon_drawings1`
79 FOREIGN KEY (`vizon_drawings_id`
)
80 REFERENCES `vizon`.`vizon_drawings`
(`
id`
)
86 SET SQL_MODE
=@OLD_SQL_MODE
;
87 SET FOREIGN_KEY_CHECKS
=@OLD_FOREIGN_KEY_CHECKS
;
88 SET UNIQUE_CHECKS
=@OLD_UNIQUE_CHECKS
;