Waterhorses eksempel

-- -----------------------------------------------------
-- Schema waterhorses_dk_dk
-- -----------------------------------------------------
CREATE SCHEMA IF NOT EXISTS `waterhorses_dk_dk` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;
USE `waterhorses_dk_dk` ;

-- -----------------------------------------------------
-- Table `waterhorses_dk_dk`.`wh2_users`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `waterhorses_dk_dk`.`wh2_users` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `username` VARCHAR(45) NULL,
  `wkr` INT NULL,
  PRIMARY KEY (`id`),
  UNIQUE INDEX `username_UNIQUE` (`username` ASC))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `waterhorses_dk_dk`.`wh2_lottery`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `waterhorses_dk_dk`.`wh2_lottery` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(255) NULL,
  `from` DATETIME NULL,
  `to` DATETIME NULL,
  PRIMARY KEY (`id`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `waterhorses_dk_dk`.`wh2_attendees`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `waterhorses_dk_dk`.`wh2_attendees` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `wh2_users_id` INT NOT NULL,
  `wh2_lottery_id` INT NOT NULL,
  PRIMARY KEY (`id`, `wh2_users_id`, `wh2_lottery_id`),
  INDEX `fk_wh2_attendees_wh2_users_idx` (`wh2_users_id` ASC),
  INDEX `fk_wh2_attendees_wh2_lottery1_idx` (`wh2_lottery_id` ASC),
  CONSTRAINT `fk_wh2_attendees_wh2_users`
    FOREIGN KEY (`wh2_users_id`)
    REFERENCES `waterhorses_dk_dk`.`wh2_users` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_wh2_attendees_wh2_lottery1`
    FOREIGN KEY (`wh2_lottery_id`)
    REFERENCES `waterhorses_dk_dk`.`wh2_lottery` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;