dPgYrpZH

1SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
2SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
3SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
4
5-- -----------------------------------------------------
6-- Schema mydb
7-- -----------------------------------------------------
8-- -----------------------------------------------------
9-- Schema dbforsale
10-- -----------------------------------------------------
11
12-- -----------------------------------------------------
13-- Schema dbforsale
14-- -----------------------------------------------------
15CREATE SCHEMA IF NOT EXISTS `dbforsale` DEFAULT CHARACTER SET utf8 ;
16USE `dbforsale` ;
17
18-- -----------------------------------------------------
19-- Table `dbforsale`.`cheque`
20-- -----------------------------------------------------
21CREATE TABLE IF NOT EXISTS `dbforsale`.`cheque` (
22  `nummer` INT(11) NOT NULL,
23  `waarde` INT(11) NOT NULL,
24  `eigenaar` INT(11) NULL DEFAULT NULL)
25ENGINE = InnoDB
26DEFAULT CHARACTER SET = utf8;
27
28
29-- -----------------------------------------------------
30-- Table `dbforsale`.`huiskaart`
31-- -----------------------------------------------------
32CREATE TABLE IF NOT EXISTS `dbforsale`.`huiskaart` (
33  `huiskaartnummer` INT(11) NOT NULL,
34  `eigenaar` INT(11) NULL DEFAULT NULL,
35  PRIMARY KEY (`huiskaartnummer`))
36ENGINE = InnoDB
37DEFAULT CHARACTER SET = utf8;
38
39
40-- -----------------------------------------------------
41-- Table `dbforsale`.`speler`
42-- -----------------------------------------------------
43CREATE TABLE IF NOT EXISTS `dbforsale`.`speler` (
44  `naam` VARCHAR(255) NOT NULL,
45  `aantalmunten` VARCHAR(45) NOT NULL,
46  `spelernummer` INT(11) NOT NULL AUTO_INCREMENT,
47  PRIMARY KEY (`spelernummer`))
48ENGINE = InnoDB
49AUTO_INCREMENT = 4
50DEFAULT CHARACTER SET = utf8;
51
52
53-- -----------------------------------------------------
54-- Table `dbforsale`.`veiling`
55-- -----------------------------------------------------
56CREATE TABLE IF NOT EXISTS `dbforsale`.`veiling` (
57  `ronde` INT(11) NOT NULL,
58  `scherm` INT(11) NOT NULL)
59ENGINE = InnoDB
60DEFAULT CHARACTER SET = utf8;
61
62
63SET SQL_MODE=@OLD_SQL_MODE;
64SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
65SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;