WgaeZX7E

1/* Database backup, generated at 25/10/2018 10:07:16 */
2
3SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
4SET time_zone = "+00:00";
5SET @OLD_FOREIGN_KEY_CHECKS = @@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS =0;
6
7/* Create user accounts */
8
9/* Create user roboweb */
10
11/* Create user oophp */
12DROP USER IF EXISTS oophp;
13CREATE USER 'oophp'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*7A61A61644DDABC9B7B5C9E799EA3939E648CE50' REQUIRE NONE PASSWORD EXPIRE DEFAULT ACCOUNT UNLOCK;
14GRANT USAGE ON *.* TO 'oophp'@'localhost';
15GRANT ALL PRIVILEGES ON `oophp`.* TO 'oophp'@'localhost' WITH GRANT OPTION;
16
17
18/* Create schemas and tables */
19
20/* Create schema oophp */
21DROP SCHEMA IF EXISTS `oophp`;
22CREATE SCHEMA `oophp`;
23USE `oophp`;
24
25/* Create table battles */
26DROP TABLE IF EXISTS `battles`; 
27CREATE TABLE `battles` (
28  `id` int(11) NOT NULL AUTO_INCREMENT,
29  `dtPlayed` date NOT NULL,
30  `gameid` int(11) NOT NULL,
31  `playerid01` int(11) NOT NULL,
32  `playerid02` int(11) NOT NULL,
33  `playerid03` int(11) DEFAULT NULL,
34  `playerid04` int(11) DEFAULT NULL,
35  `wonby` int(11) NOT NULL,
36  `score` varchar(256) DEFAULT NULL,
37  PRIMARY KEY (`id`)
38) ENGINE=MyISAM DEFAULT CHARSET=utf8;
39/* Insert data into table */
40
41/* Create table games */
42DROP TABLE IF EXISTS `games`; 
43CREATE TABLE `games` (
44  `id` int(4) NOT NULL AUTO_INCREMENT,
45  `name` varchar(128) NOT NULL,
46  `nop` varchar(128) NOT NULL,
47  `dor` year(4) NOT NULL,
48  `publisherid` int(4) DEFAULT NULL,
49  `duration` varchar(32) DEFAULT NULL,
50  `description` varchar(12800) NOT NULL DEFAULT '',
51  PRIMARY KEY (`id`)
52) ENGINE=MyISAM DEFAULT CHARSET=utf8;
53/* Insert data into table */
54
55/* Create table player */
56DROP TABLE IF EXISTS `player`; 
57CREATE TABLE `player` (
58  `id` int(2) NOT NULL AUTO_INCREMENT,
59  `nickname` varchar(128) NOT NULL,
60  `gamestatus` int(11) DEFAULT '1',
61  PRIMARY KEY (`id`)
62) ENGINE=MyISAM DEFAULT CHARSET=latin1;
63/* Insert data into table */
64
65/* Create table users */
66DROP TABLE IF EXISTS `users`; 
67CREATE TABLE `users` (
68  `id` int(2) NOT NULL AUTO_INCREMENT,
69  `fname` varchar(128) NOT NULL,
70  `lname` varchar(255) NOT NULL,
71  `email` varchar(255) NOT NULL,
72  `mobile` varchar(10) NOT NULL DEFAULT '',
73  `password` varchar(256) DEFAULT '',
74  `pwcheck` varchar(256) DEFAULT '',
75  PRIMARY KEY (`id`)
76) ENGINE=MyISAM DEFAULT CHARSET=utf8;
77/* Insert data into table */