]>
Commit | Line | Data |
---|---|---|
cbf53068 O |
1 | -- MySQL Script generated by MySQL Workbench |
2 | -- 01/15/17 12:21:36 | |
3 | -- Model: New Model Version: 1.0 | |
4 | -- MySQL Workbench Forward Engineering | |
5 | ||
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'; | |
9 | ||
10 | -- ----------------------------------------------------- | |
11 | -- Schema vizon | |
12 | -- ----------------------------------------------------- | |
13 | ||
14 | -- ----------------------------------------------------- | |
15 | -- Schema vizon | |
16 | -- ----------------------------------------------------- | |
17 | CREATE SCHEMA IF NOT EXISTS `vizon` DEFAULT CHARACTER SET latin1 ; | |
18 | USE `vizon` ; | |
19 | ||
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, | |
35 | PRIMARY KEY (`id`), | |
36 | UNIQUE INDEX `nick_UNIQUE` (`nick` ASC)) | |
37 | ENGINE = InnoDB; | |
38 | ||
39 | ||
40 | -- ----------------------------------------------------- | |
41 | -- Table `vizon`.`vizon_drawings` | |
42 | -- ----------------------------------------------------- | |
43 | CREATE TABLE IF NOT EXISTS `vizon`.`vizon_drawings` ( | |
44 | `id` INT NOT NULL AUTO_INCREMENT, | |
45 | `first` INT NULL, | |
46 | `second` INT NULL, | |
47 | `third` INT NULL, | |
48 | `fourth` INT NULL, | |
49 | `fifth` INT NULL, | |
50 | `sixth` INT NULL, | |
51 | `drawing_date` TIMESTAMP NOT NULL, | |
52 | PRIMARY KEY (`id`)) | |
53 | ENGINE = InnoDB; | |
54 | ||
55 | ||
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, | |
63 | `first` INT NOT NULL, | |
64 | `second` INT NOT NULL, | |
65 | `third` INT NOT NULL, | |
66 | `fourth` INT NOT NULL, | |
67 | `fifth` INT NOT NULL, | |
68 | `sixth` INT NOT NULL, | |
69 | `placed` TIMESTAMP NOT NULL DEFAULT NOW(), | |
70 | PRIMARY KEY (`id`), | |
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`) | |
76 | ON DELETE CASCADE | |
77 | ON UPDATE CASCADE, | |
78 | CONSTRAINT `fk_vizon_bets_vizon_drawings1` | |
79 | FOREIGN KEY (`vizon_drawings_id`) | |
80 | REFERENCES `vizon`.`vizon_drawings` (`id`) | |
81 | ON DELETE CASCADE | |
82 | ON UPDATE CASCADE) | |
83 | ENGINE = InnoDB; | |
84 | ||
85 | ||
86 | SET SQL_MODE=@OLD_SQL_MODE; | |
87 | SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS; | |
88 | SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS; |