· 8 years ago · May 14, 2018, 03:02 PM
1-- phpMyAdmin SQL Dump
2-- version 4.7.4
3-- https://www.phpmyadmin.net/
4--
5-- Hôte : 127.0.0.1:3306
6-- Généré le : lun. 14 mai 2018 à 14:57
7-- Version du serveur : 5.7.19
8-- Version de PHP : 5.6.31
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET AUTOCOMMIT = 0;
12START TRANSACTION;
13SET time_zone = "+00:00";
14
15
16/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
17/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
18/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
19/*!40101 SET NAMES utf8mb4 */;
20
21--
22-- Base de données : `bd_madmmoth`
23--
24
25-- --------------------------------------------------------
26
27--
28-- Structure de la table `game`
29--
30
31DROP TABLE IF EXISTS `game`;
32CREATE TABLE IF NOT EXISTS `game` (
33 `gam_id` int(11) NOT NULL AUTO_INCREMENT,
34 `gam_title` text,
35 `gam_desc` text,
36 PRIMARY KEY (`gam_id`)
37) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;
38
39--
40-- Déchargement des données de la table `game`
41--
42
43INSERT INTO `game` (`gam_id`, `gam_title`, `gam_desc`) VALUES
44(14, 'Better Drunk Than Dead', '<h2>Story</h2>\r\n<p style=\"text-align: justify;\">Project D is a fast paced shooter taking place during a transdimensional monsters invasion in a satrical modern world. It\'s heavily inspired by arena shooter of the 90\'s such as DOOM, Duke Nukem and Shadow Warrior.</p>\r\n<p style=\"text-align: justify;\">You are Jay, a student who wake up with huge hangover after the biggest party of his life and you doesn\'t remember anything about it. Will you where sleeping the city has been invaded and reduced to ash by some strange creatures who kill everything they met.</p>\r\n<p style=\"text-align: justify;\">Your mission will be to inverstigate to what\'s happen last night and also to clear this fucking mess.You will need to slaugther endless waves of monsters but always with style.</p>\r\n<h2>Features</h2>\r\n<ul>\r\n<li>Non-linear story</li>\r\n<li>Fast paced arena fighting with huge importance of scoring</li>\r\n<li>Alcoholic status management</li>\r\n<li>Over 30 range and melee weapons</li>\r\n<li>Various alcohol drinks which give mutiple boost</li>\r\n<li>Dual wield everything</li>\r\n<li>Randomly generated monsters</li>\r\n</ul>');
45
46-- --------------------------------------------------------
47
48--
49-- Structure de la table `news`
50--
51
52DROP TABLE IF EXISTS `news`;
53CREATE TABLE IF NOT EXISTS `news` (
54 `new_id` int(11) NOT NULL AUTO_INCREMENT,
55 `new_date` datetime DEFAULT CURRENT_TIMESTAMP,
56 `new_title` text,
57 `tpn_id` int(11) DEFAULT NULL,
58 `new_text` text,
59 `gam_id` int(11) DEFAULT NULL,
60 PRIMARY KEY (`new_id`),
61 KEY `tpnews_id` (`tpn_id`),
62 KEY `gam_id` (`gam_id`)
63) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=latin1;
64
65--
66-- Déchargement des données de la table `news`
67--
68
69INSERT INTO `news` (`new_id`, `new_date`, `new_title`, `tpn_id`, `new_text`, `gam_id`) VALUES
70(47, '2018-02-16 16:31:33', 'lclkcklcvklfvl', 4, '<p>klfkfdlkdfl</p>', NULL),
71(48, '2018-02-16 16:31:33', 'Patch note example', 5, '<p style=\"text-align: justify;\">Players, as with the last patch, a new type of anti-cheat solution, which is still under development, is to be applied on the test servers. We are in a test phase with this solution, and its stability and compatibility need to be verified. We would like to collect data about potential compatibility issues, analyze it and solve any issues that may emerge.</p>\r\n<p style=\"text-align: justify;\">If the current test build is consistently crashing for you, we recommend that you play on the live servers instead. Thank you for your understanding. </p>\r\n<p style=\"text-align: justify;\"><iframe src=\"//www.youtube.com/embed/gZ_OZL57c0g\" width=\"560\" height=\"314\" allowfullscreen=\"allowfullscreen\"></iframe></p>\r\n<p style=\"text-align: justify;\">Please find the patch notes below:</p>\r\n<h3 style=\"text-align: justify;\">World</h3>\r\n<ul style=\"text-align: justify;\">\r\n<li>Miramar improvements</li>\r\n<ul>\r\n<li>Added more buildings and cover across the map to improve the engagement experience</li>\r\n<li>Added more off-road routes for easier vehicle navigation</li>\r\n<li>Upgraded the item spawn level of certain areas for loot balancing (some areas will spawn better loot)</li>\r\n</ul>\r\n</ul>\r\n<h3 style=\"text-align: justify;\">Replay</h3>\r\n<ul style=\"text-align: justify;\">\r\n<li>The replay system has now been updated to a newer version and past replay files cannot be played anymore</li>\r\n</ul>\r\n<h3 style=\"text-align: justify;\">Bug fixes</h3>\r\n<ul style=\"text-align: justify;\">\r\n<li>Fixed the issue where heal and boost items could be used underwater</li>\r\n<li>Fixed the issue where characters would get stuck in certain areas on Miramar</li>\r\n<li>Fixed the issue where wall textures on some Miramar buildings were not displaying correctly</li>\r\n<li>Fixed the issue where certain buildings near by Hacienda del Patron were not displaying correctly</li>\r\n</ul>\r\n<p style=\"text-align: justify;\">Thank you.<br /><strong>The PUBG Development and Community Team</strong></p>', 14),
72(49, '2018-02-16 17:43:46', 'Test de la communauté', 2, '<p>c\'est la commu</p>', NULL),
73(50, '2018-02-17 21:45:54', 'Test de news', 1, '<p>Test</p>\r\n<p><iframe src=\"//www.youtube.com/embed/usBoJJxrFLs\" width=\"560\" height=\"314\" allowfullscreen=\"allowfullscreen\"></iframe></p>', NULL);
74
75-- --------------------------------------------------------
76
77--
78-- Structure de la table `tpnews`
79--
80
81DROP TABLE IF EXISTS `tpnews`;
82CREATE TABLE IF NOT EXISTS `tpnews` (
83 `tpn_id` int(11) NOT NULL AUTO_INCREMENT,
84 `tpn_label` varchar(10) NOT NULL,
85 PRIMARY KEY (`tpn_id`)
86) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
87
88--
89-- Déchargement des données de la table `tpnews`
90--
91
92INSERT INTO `tpnews` (`tpn_id`, `tpn_label`) VALUES
93(1, 'News'),
94(2, 'Commu'),
95(4, 'DevLog'),
96(5, 'Patch note');
97
98-- --------------------------------------------------------
99
100--
101-- Structure de la table `video`
102--
103
104DROP TABLE IF EXISTS `video`;
105CREATE TABLE IF NOT EXISTS `video` (
106 `vid_id` int(11) NOT NULL AUTO_INCREMENT,
107 `vid_name` varchar(15) DEFAULT NULL,
108 `vid_url` text,
109 `gam_id` int(11) DEFAULT NULL,
110 PRIMARY KEY (`vid_id`),
111 KEY `gam_id` (`gam_id`)
112) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
113
114--
115-- Déchargement des données de la table `video`
116--
117
118INSERT INTO `video` (`vid_id`, `vid_name`, `vid_url`, `gam_id`) VALUES
119(3, 'yolo', 'https://www.youtube.com/embed/ESIUB-NsNMg', NULL),
120(7, 'Brutal doom 2', 'https://www.youtube.com/embed/9YoADewX12E', 14),
121(8, 'DOOM 2016', 'https://www.youtube.com/embed/RO90omga8D4', 14),
122(9, 'DOOM CINEMATIC', 'https://www.youtube.com/embed/omWEZI0cT1g', 14),
123(10, 'Bill', 'https://www.youtube.com/embed/v7xn2Kj1QGA', 14);
124
125--
126-- Contraintes pour les tables déchargées
127--
128
129--
130-- Contraintes pour la table `news`
131--
132ALTER TABLE `news`
133 ADD CONSTRAINT `news_ibfk_1` FOREIGN KEY (`tpn_id`) REFERENCES `tpnews` (`tpn_id`),
134 ADD CONSTRAINT `news_ibfk_2` FOREIGN KEY (`gam_id`) REFERENCES `game` (`gam_id`) ON DELETE SET NULL;
135
136--
137-- Contraintes pour la table `video`
138--
139ALTER TABLE `video`
140 ADD CONSTRAINT `video_ibfk_1` FOREIGN KEY (`gam_id`) REFERENCES `game` (`gam_id`) ON DELETE CASCADE;
141COMMIT;
142
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 */;