vizon/vizon.sql

   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 -- Table `vizon`.`vizon_bans`
  87 -- -----------------------------------------------------
  88 CREATE TABLE IF NOT EXISTS `vizon`.`vizon_bans` (
  89 `id` INT AUTO_INCREMENT,
  90 `nick` VARCHAR(64) not null,
  91 `oper` VARCHAR(64) not null,
  92 `reason` VARCHAR(128),
  93 PRIMARY KEY (id),
  94 UNIQUE INDEX `nick_UNIQUE` (`nick` ASC));
  95
  96
  97 SET SQL_MODE=@OLD_SQL_MODE;
  98 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
  99 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;