· 7 years ago · Oct 25, 2018, 06:42 PM
1-- MySQL dump 10.13 Distrib 5.7.12, for Win64 (x86_64)
2--
3-- Host: localhost Database: oophp
4-- ------------------------------------------------------
5-- Server version 5.7.15-log
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `battles`
20--
21
22DROP TABLE IF EXISTS `battles`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `battles` (
26 `id` int(11) NOT NULL AUTO_INCREMENT,
27 `dtPlayed` date NOT NULL,
28 `gameid` int(11) NOT NULL,
29 `playerid01` int(11) NOT NULL,
30 `playerid02` int(11) NOT NULL,
31 `playerid03` int(11) DEFAULT NULL,
32 `playerid04` int(11) DEFAULT NULL,
33 `wonby` int(11) NOT NULL,
34 `score` varchar(256) DEFAULT NULL,
35 PRIMARY KEY (`id`)
36) ENGINE=MyISAM DEFAULT CHARSET=utf8;
37/*!40101 SET character_set_client = @saved_cs_client */;
38
39--
40-- Dumping data for table `battles`
41--
42
43LOCK TABLES `battles` WRITE;
44/*!40000 ALTER TABLE `battles` DISABLE KEYS */;
45/*!40000 ALTER TABLE `battles` ENABLE KEYS */;
46UNLOCK TABLES;
47
48--
49-- Table structure for table `games`
50--
51
52DROP TABLE IF EXISTS `games`;
53/*!40101 SET @saved_cs_client = @@character_set_client */;
54/*!40101 SET character_set_client = utf8 */;
55CREATE TABLE `games` (
56 `id` int(4) NOT NULL AUTO_INCREMENT,
57 `name` varchar(128) NOT NULL,
58 `nop` varchar(128) NOT NULL,
59 `dor` year(4) NOT NULL,
60 `publisherid` int(4) DEFAULT NULL,
61 `duration` varchar(32) DEFAULT NULL,
62 `description` varchar(12800) NOT NULL DEFAULT '',
63 PRIMARY KEY (`id`)
64) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
65/*!40101 SET character_set_client = @saved_cs_client */;
66
67--
68-- Dumping data for table `games`
69--
70
71LOCK TABLES `games` WRITE;
72/*!40000 ALTER TABLE `games` DISABLE KEYS */;
73INSERT INTO `games` VALUES (1,'explorers of ixalan','2-4',2016,0,NULL,'doe maar wat'),(2,'pesten','2-veel',0000,NULL,NULL,'old but gold');
74/*!40000 ALTER TABLE `games` ENABLE KEYS */;
75UNLOCK TABLES;
76
77--
78-- Table structure for table `player`
79--
80
81DROP TABLE IF EXISTS `player`;
82/*!40101 SET @saved_cs_client = @@character_set_client */;
83/*!40101 SET character_set_client = utf8 */;
84CREATE TABLE `player` (
85 `id` int(2) NOT NULL AUTO_INCREMENT,
86 `nickname` varchar(128) NOT NULL,
87 `gamestatus` int(11) DEFAULT '1',
88 PRIMARY KEY (`id`)
89) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
90/*!40101 SET character_set_client = @saved_cs_client */;
91
92--
93-- Dumping data for table `player`
94--
95
96LOCK TABLES `player` WRITE;
97/*!40000 ALTER TABLE `player` DISABLE KEYS */;
98INSERT INTO `player` VALUES (1,'bietsthemen',1),(2,'frankdefransman',2);
99/*!40000 ALTER TABLE `player` ENABLE KEYS */;
100UNLOCK TABLES;
101
102--
103-- Table structure for table `users`
104--
105
106DROP TABLE IF EXISTS `users`;
107/*!40101 SET @saved_cs_client = @@character_set_client */;
108/*!40101 SET character_set_client = utf8 */;
109CREATE TABLE `users` (
110 `id` int(2) NOT NULL AUTO_INCREMENT,
111 `fname` varchar(128) NOT NULL,
112 `lname` varchar(255) NOT NULL,
113 `email` varchar(255) NOT NULL,
114 `mobile` varchar(10) NOT NULL DEFAULT '',
115 `password` varchar(256) DEFAULT '',
116 `pwcheck` varchar(256) DEFAULT '',
117 PRIMARY KEY (`id`)
118) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
119/*!40101 SET character_set_client = @saved_cs_client */;
120
121--
122-- Dumping data for table `users`
123--
124
125LOCK TABLES `users` WRITE;
126/*!40000 ALTER TABLE `users` DISABLE KEYS */;
127INSERT INTO `users` VALUES (1,'biets','bakfiets','biets@biets.nl','0612345','doemaarwatanders','1'),(2,'frank','hanketang','frank@frank','0612346245','watanders','1'),(3,'max','verkitten','max@max.nl','0623584146','purrfectwachtwoord','1');
128/*!40000 ALTER TABLE `users` ENABLE KEYS */;
129UNLOCK TABLES;
130
131--
132-- Dumping events for database 'oophp'
133--
134
135--
136-- Dumping routines for database 'oophp'
137--
138/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
139
140/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
141/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
142/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
143/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
144/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
145/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
146/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
147
148-- Dump completed on 2018-10-25 20:38:04