· 8 years ago · Aug 11, 2018, 11:02 AM
1-- phpMyAdmin SQL Dump
2-- version 4.7.9
3-- https://www.phpmyadmin.net/
4--
5-- Hôte : 127.0.0.1:3306
6-- Généré le : sam. 11 août 2018 à 10:57
7-- Version du serveur : 5.7.21
8-- Version de PHP : 5.6.35
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 : `ig`
23--
24
25-- --------------------------------------------------------
26
27--
28-- Structure de la table `achats`
29--
30
31DROP TABLE IF EXISTS `achats`;
32CREATE TABLE IF NOT EXISTS `achats` (
33 `id` int(11) NOT NULL AUTO_INCREMENT,
34 `id_item` int(11) NOT NULL,
35 `id_authme` int(11) NOT NULL,
36 `valid` int(11) NOT NULL,
37 PRIMARY KEY (`id`)
38) ENGINE=MyISAM AUTO_INCREMENT=37 DEFAULT CHARSET=latin1;
39
40--
41-- Déchargement des données de la table `achats`
42--
43
44INSERT INTO `achats` (`id`, `id_item`, `id_authme`, `valid`) VALUES
45(36, 3, 5, 1),
46(35, 1, 5, 1),
47(34, 3, 5, 1),
48(33, 3, 5, 1),
49(32, 1, 5, 1),
50(31, 3, 5, 1),
51(30, 3, 5, 1),
52(29, 5, 5, 1),
53(28, 2, 5, 1);
54
55-- --------------------------------------------------------
56
57--
58-- Structure de la table `forum_category`
59--
60
61DROP TABLE IF EXISTS `forum_category`;
62CREATE TABLE IF NOT EXISTS `forum_category` (
63 `id` int(11) NOT NULL AUTO_INCREMENT,
64 `name_category` varchar(255) NOT NULL,
65 `desc_category` text NOT NULL,
66 `author` int(11) NOT NULL,
67 `date_category` datetime NOT NULL,
68 `open` int(1) NOT NULL DEFAULT '1',
69 PRIMARY KEY (`id`)
70) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
71
72--
73-- Déchargement des données de la table `forum_category`
74--
75
76INSERT INTO `forum_category` (`id`, `name_category`, `desc_category`, `author`, `date_category`, `open`) VALUES
77(4, 'Forum de test', 'Forum pour les tests', 5, '2018-08-06 14:33:08', 1),
78(3, 'Forum in-game', 'Forum du jeu', 5, '2018-08-06 14:32:50', 1);
79
80-- --------------------------------------------------------
81
82--
83-- Structure de la table `forum_posts`
84--
85
86DROP TABLE IF EXISTS `forum_posts`;
87CREATE TABLE IF NOT EXISTS `forum_posts` (
88 `id` int(11) NOT NULL AUTO_INCREMENT,
89 `id_category` int(11) NOT NULL,
90 `name_post` varchar(255) NOT NULL,
91 `text` text NOT NULL,
92 `author` int(11) NOT NULL,
93 `date_post` datetime NOT NULL,
94 `valid` int(11) NOT NULL DEFAULT '1',
95 `open` int(11) NOT NULL DEFAULT '1',
96 PRIMARY KEY (`id`)
97) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
98
99--
100-- Déchargement des données de la table `forum_posts`
101--
102
103INSERT INTO `forum_posts` (`id`, `id_category`, `name_post`, `text`, `author`, `date_post`, `valid`, `open`) VALUES
104(8, 4, 'trtre', 'rteretre', 5, '2018-08-06 15:02:55', 1, 1),
105(7, 3, 'Probleme in-game monnaie', 'j\'ai un problème avec ma monnaie', 5, '2018-08-06 14:33:39', 1, 1);
106
107-- --------------------------------------------------------
108
109--
110-- Structure de la table `forum_replies`
111--
112
113DROP TABLE IF EXISTS `forum_replies`;
114CREATE TABLE IF NOT EXISTS `forum_replies` (
115 `id` int(11) NOT NULL AUTO_INCREMENT,
116 `id_post` int(11) NOT NULL,
117 `reply` text NOT NULL,
118 `author` varchar(255) NOT NULL,
119 `date_reply` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
120 PRIMARY KEY (`id`)
121) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;
122
123--
124-- Déchargement des données de la table `forum_replies`
125--
126
127INSERT INTO `forum_replies` (`id`, `id_post`, `reply`, `author`, `date_reply`) VALUES
128(12, 8, 'ok', 'EnObliO', '2018-08-06 15:03:10'),
129(11, 7, 'azaezr', 'EnObliO', '2018-08-06 14:37:21'),
130(10, 7, 'ah bah rip alors', 'EnObliO', '2018-08-06 14:33:56'),
131(13, 8, '545456', 'EnObliO', '2018-08-06 15:08:17');
132
133-- --------------------------------------------------------
134
135--
136-- Structure de la table `messages`
137--
138
139DROP TABLE IF EXISTS `messages`;
140CREATE TABLE IF NOT EXISTS `messages` (
141 `id` int(11) NOT NULL AUTO_INCREMENT,
142 `title` varchar(255) NOT NULL,
143 `description` text NOT NULL,
144 `author` int(11) NOT NULL,
145 `date_message` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
146 `valid` int(11) NOT NULL DEFAULT '1',
147 `type` varchar(255) NOT NULL,
148 PRIMARY KEY (`id`)
149) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
150
151--
152-- Déchargement des données de la table `messages`
153--
154
155INSERT INTO `messages` (`id`, `title`, `description`, `author`, `date_message`, `valid`, `type`) VALUES
156(10, 'Un message de test', 'Custom message de test', 5, '2018-08-07 14:23:09', 1, ''),
157(6, '', 'Description du serveur. ', 5, '2018-08-07 12:21:06', 1, 'description');
158
159-- --------------------------------------------------------
160
161--
162-- Structure de la table `shop`
163--
164
165DROP TABLE IF EXISTS `shop`;
166CREATE TABLE IF NOT EXISTS `shop` (
167 `id` int(11) NOT NULL AUTO_INCREMENT,
168 `name` varchar(255) NOT NULL,
169 `image` text NOT NULL,
170 `price` float NOT NULL,
171 `commands` text NOT NULL,
172 `author` int(11) NOT NULL,
173 `date_add` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
174 PRIMARY KEY (`id`)
175) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
176
177--
178-- Déchargement des données de la table `shop`
179--
180
181INSERT INTO `shop` (`id`, `name`, `image`, `price`, `commands`, `author`, `date_add`) VALUES
182(1, 'Grade Bourgeois', 'http://www.blocksandgold.com//media/catalog/product/cache/2/image/200x/6cffa5908a86143a54dc6ad9b8a7c38e/i/r/iron__block_.png', 500000, 'pex user <username> group add Bourgeois', 5, '2018-08-05 17:47:19'),
183(2, 'Grade riche', 'https://d1u5p3l4wpay3k.cloudfront.net/minecraft_fr_gamepedia/9/9f/Bloc_d%27or.png', 1000000, 'pex user <username> group add Riche', 5, '2018-08-05 17:47:34'),
184(3, 'Kit tools', 'https://cdn.icon-icons.com/icons2/224/PNG/512/Iron_Pickaxe_25722.png', 2000, 'kit tools <username>', 5, '2018-08-05 17:47:46'),
185(4, 'Kit pvp', 'https://cdn.icon-icons.com/icons2/224/PNG/512/Diamond_Sword_25716.png', 5000, 'kit pvp <username>', 5, '2018-08-05 17:48:00'),
186(5, 'Caisse aléatoire rare', 'https://thumbs.dreamstime.com/b/caisse-de-coffre-au-tr%C3%A9sor-de-bande-dessin%C3%A9e-avec-les-pi%C3%A8ces-d-et-le-collier-de-perle-58364820.jpg', 200000, '', 5, '2018-08-05 17:48:22'),
187(6, 'Caisse aléatoire légendaire', 'https://www.phenixmc.fr/images/images_boutique/caisse4.png', 500000, '', 5, '2018-08-05 17:48:39');
188
189-- --------------------------------------------------------
190
191--
192-- Structure de la table `web_admin`
193--
194
195DROP TABLE IF EXISTS `web_admin`;
196CREATE TABLE IF NOT EXISTS `web_admin` (
197 `id` int(11) NOT NULL AUTO_INCREMENT,
198 `authme_id` int(11) NOT NULL,
199 PRIMARY KEY (`id`)
200) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
201
202--
203-- Déchargement des données de la table `web_admin`
204--
205
206INSERT INTO `web_admin` (`id`, `authme_id`) VALUES
207(4, 5);
208COMMIT;
209
210/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
211/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
212/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;