dBjUfKM8

1-- MySQL Script generated by MySQL Workbench
2-- 10/25/18 20:30:58
3-- Model: New Model    Version: 1.0
4-- MySQL Workbench Forward Engineering
5
6SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
7SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
8SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
9
10-- -----------------------------------------------------
11-- Schema mydb
12-- -----------------------------------------------------
13-- -----------------------------------------------------
14-- Schema oophp
15-- -----------------------------------------------------
16
17-- -----------------------------------------------------
18-- Schema oophp
19-- -----------------------------------------------------
20CREATE SCHEMA IF NOT EXISTS `oophp` DEFAULT CHARACTER SET utf8 ;
21USE `oophp` ;
22
23-- -----------------------------------------------------
24-- Table `oophp`.`battles`
25-- -----------------------------------------------------
26DROP TABLE IF EXISTS `oophp`.`battles` ;
27
28CREATE TABLE IF NOT EXISTS `oophp`.`battles` (
29  `id` INT(11) NOT NULL AUTO_INCREMENT,
30  `dtPlayed` DATE NOT NULL,
31  `gameid` INT(11) NOT NULL,
32  `playerid01` INT(11) NOT NULL,
33  `playerid02` INT(11) NOT NULL,
34  `playerid03` INT(11) NULL DEFAULT NULL,
35  `playerid04` INT(11) NULL DEFAULT NULL,
36  `wonby` INT(11) NOT NULL,
37  `score` VARCHAR(256) NULL DEFAULT NULL,
38  PRIMARY KEY (`id`))
39ENGINE = MyISAM
40DEFAULT CHARACTER SET = utf8;
41
42
43-- -----------------------------------------------------
44-- Table `oophp`.`games`
45-- -----------------------------------------------------
46DROP TABLE IF EXISTS `oophp`.`games` ;
47
48CREATE TABLE IF NOT EXISTS `oophp`.`games` (
49  `id` INT(4) NOT NULL AUTO_INCREMENT,
50  `name` VARCHAR(128) NOT NULL,
51  `nop` VARCHAR(128) NOT NULL,
52  `dor` YEAR(4) NOT NULL,
53  `publisherid` INT(4) NULL DEFAULT NULL,
54  `duration` VARCHAR(32) NULL DEFAULT NULL,
55  `description` VARCHAR(12800) NOT NULL DEFAULT '',
56  PRIMARY KEY (`id`))
57ENGINE = MyISAM
58AUTO_INCREMENT = 3
59DEFAULT CHARACTER SET = utf8;
60
61
62-- -----------------------------------------------------
63-- Table `oophp`.`player`
64-- -----------------------------------------------------
65DROP TABLE IF EXISTS `oophp`.`player` ;
66
67CREATE TABLE IF NOT EXISTS `oophp`.`player` (
68  `id` INT(2) NOT NULL AUTO_INCREMENT,
69  `nickname` VARCHAR(128) NOT NULL,
70  `gamestatus` INT(11) NULL DEFAULT '1',
71  PRIMARY KEY (`id`))
72ENGINE = MyISAM
73AUTO_INCREMENT = 3
74DEFAULT CHARACTER SET = latin1;
75
76
77-- -----------------------------------------------------
78-- Table `oophp`.`users`
79-- -----------------------------------------------------
80DROP TABLE IF EXISTS `oophp`.`users` ;
81
82CREATE TABLE IF NOT EXISTS `oophp`.`users` (
83  `id` INT(2) NOT NULL AUTO_INCREMENT,
84  `fname` VARCHAR(128) NOT NULL,
85  `lname` VARCHAR(255) NOT NULL,
86  `email` VARCHAR(255) NOT NULL,
87  `mobile` VARCHAR(10) NOT NULL DEFAULT '',
88  `password` VARCHAR(256) NULL DEFAULT '',
89  `pwcheck` VARCHAR(256) NULL DEFAULT '',
90  PRIMARY KEY (`id`))
91ENGINE = MyISAM
92AUTO_INCREMENT = 4
93DEFAULT CHARACTER SET = utf8;
94
95
96SET SQL_MODE=@OLD_SQL_MODE;
97SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
98SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;