· 9 years ago · Feb 03, 2017, 11:42 PM
1-- phpMyAdmin SQL Dump
2-- version 4.2.12deb2+deb8u2
3-- http://www.phpmyadmin.net
4--
5-- Client : localhost
6-- Généré le : Jeu 22 Septembre 2016 à 14:20
7-- Version du serveur : 5.5.50-0+deb8u1
8-- Version de PHP : 5.6.24-0+deb8u1
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Base de données : `launcher`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Structure de la table `news`
27--
28
29CREATE TABLE IF NOT EXISTS `news` (
30`id` int(11) NOT NULL,
31 `title` varchar(255) NOT NULL,
32 `content` text NOT NULL,
33 `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
34 `link` varchar(255) NOT NULL,
35 `server_id` int(11) NOT NULL
36) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=latin1;
37
38-- --------------------------------------------------------
39
40--
41-- Structure de la table `notifications`
42--
43
44CREATE TABLE IF NOT EXISTS `notifications` (
45`id` int(11) NOT NULL,
46 `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
47 `users` varchar(255) NOT NULL,
48 `title` varchar(255) NOT NULL,
49 `content` varchar(255) NOT NULL,
50 `link` varchar(255) NOT NULL
51) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;
52
53-- --------------------------------------------------------
54
55--
56-- Structure de la table `servers`
57--
58
59CREATE TABLE IF NOT EXISTS `servers` (
60`id` int(11) NOT NULL,
61 `name` varchar(255) NOT NULL,
62 `vmod` varchar(255) NOT NULL DEFAULT '0',
63 `taskforce` int(11) NOT NULL,
64 `vtaskforce` varchar(255) NOT NULL DEFAULT '0',
65 `local_path` varchar(255) NOT NULL,
66 `modpack_name` varchar(255) NOT NULL,
67 `ip` varchar(255) NOT NULL,
68 `port` varchar(255) NOT NULL,
69 `show_infos` int(11) NOT NULL,
70 `db_host` varchar(255) NOT NULL,
71 `db_name` varchar(255) NOT NULL,
72 `db_user` varchar(255) NOT NULL,
73 `db_pass` varchar(255) NOT NULL,
74 `teamspeak` varchar(255) NOT NULL,
75 `website` varchar(255) NOT NULL,
76 `game` varchar(255) NOT NULL,
77 `maintenance` int(11) NOT NULL,
78 `lock` varchar(255) DEFAULT 'null',
79 `password` varchar(255) DEFAULT 'null',
80 `rank` int(11) NOT NULL
81) ENGINE=InnoDB AUTO_INCREMENT=64 DEFAULT CHARSET=latin1;
82
83-- --------------------------------------------------------
84
85--
86-- Structure de la table `sessions`
87--
88
89CREATE TABLE IF NOT EXISTS `sessions` (
90`id` int(11) NOT NULL,
91 `token` varchar(500) NOT NULL,
92 `user_id` int(11) NOT NULL,
93 `ip` varchar(255) NOT NULL,
94 `launcher` int(11) NOT NULL,
95 `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
96) ENGINE=InnoDB AUTO_INCREMENT=156 DEFAULT CHARSET=latin1;
97
98-- --------------------------------------------------------
99
100--
101-- Structure de la table `settings`
102--
103
104CREATE TABLE IF NOT EXISTS `settings` (
105`id` int(11) NOT NULL,
106 `active` int(11) NOT NULL,
107 `msg_title` varchar(250) NOT NULL,
108 `msg_content` text NOT NULL,
109 `maintenance` int(11) NOT NULL,
110 `maintenance_title` varchar(250) NOT NULL,
111 `maintenance_content` text NOT NULL,
112 `login` int(11) NOT NULL,
113 `register` int(11) NOT NULL
114) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
115
116--
117-- Contenu de la table `settings`
118--
119
120INSERT INTO `settings` (`id`, `active`, `msg_title`, `msg_content`, `maintenance`, `maintenance_title`, `maintenance_content`, `login`, `register`) VALUES
121(1, 1, '{picture}', 'http://image.noelshack.com/fichiers/2016/25/1466452270-maintenance.png', 0, '{picture}', 'http://image.noelshack.com/fichiers/2016/25/1466452270-maintenance.png', 1, 1);
122
123-- --------------------------------------------------------
124
125--
126-- Structure de la table `support`
127--
128
129CREATE TABLE IF NOT EXISTS `support` (
130`id` int(11) NOT NULL,
131 `title` varchar(255) NOT NULL,
132 `status` int(11) NOT NULL,
133 `started_by` int(11) NOT NULL,
134 `started_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
135 `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
136 `assign_to` int(11) NOT NULL
137) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=latin1;
138
139-- --------------------------------------------------------
140
141--
142-- Structure de la table `support_conversation`
143--
144
145CREATE TABLE IF NOT EXISTS `support_conversation` (
146`id` int(11) NOT NULL,
147 `support_id` int(11) NOT NULL,
148 `send_by` int(11) NOT NULL,
149 `send_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
150 `message` varchar(140) NOT NULL
151) ENGINE=InnoDB AUTO_INCREMENT=123 DEFAULT CHARSET=latin1;
152
153-- --------------------------------------------------------
154
155--
156-- Structure de la table `users`
157--
158
159CREATE TABLE IF NOT EXISTS `users` (
160 `email` varchar(255) NOT NULL,
161 `username` varchar(255) NOT NULL,
162 `password` varchar(500) NOT NULL,
163`id` int(11) NOT NULL,
164 `banned` tinyint(1) NOT NULL DEFAULT '0',
165 `level` int(11) NOT NULL DEFAULT '1',
166 `last_connection` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
167 `last_ip` varchar(250) NOT NULL,
168 `registered` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
169 `picture` varchar(500) NOT NULL DEFAULT '/assets/images/default_user.png',
170 `uid` varchar(30) NOT NULL DEFAULT 'Not found',
171 `last_notif` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
172) ENGINE=InnoDB AUTO_INCREMENT=128 DEFAULT CHARSET=latin1;
173
174--
175-- Index pour les tables exportées
176--
177
178--
179-- Index pour la table `news`
180--
181ALTER TABLE `news`
182 ADD PRIMARY KEY (`id`);
183
184--
185-- Index pour la table `notifications`
186--
187ALTER TABLE `notifications`
188 ADD PRIMARY KEY (`id`);
189
190--
191-- Index pour la table `servers`
192--
193ALTER TABLE `servers`
194 ADD PRIMARY KEY (`id`);
195
196--
197-- Index pour la table `sessions`
198--
199ALTER TABLE `sessions`
200 ADD PRIMARY KEY (`id`);
201
202--
203-- Index pour la table `settings`
204--
205ALTER TABLE `settings`
206 ADD PRIMARY KEY (`id`);
207
208--
209-- Index pour la table `support`
210--
211ALTER TABLE `support`
212 ADD PRIMARY KEY (`id`);
213
214--
215-- Index pour la table `support_conversation`
216--
217ALTER TABLE `support_conversation`
218 ADD PRIMARY KEY (`id`);
219
220--
221-- Index pour la table `users`
222--
223ALTER TABLE `users`
224 ADD PRIMARY KEY (`id`);
225
226--
227-- AUTO_INCREMENT pour les tables exportées
228--
229
230--
231-- AUTO_INCREMENT pour la table `news`
232--
233ALTER TABLE `news`
234MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=28;
235--
236-- AUTO_INCREMENT pour la table `notifications`
237--
238ALTER TABLE `notifications`
239MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=15;
240--
241-- AUTO_INCREMENT pour la table `servers`
242--
243ALTER TABLE `servers`
244MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=64;
245--
246-- AUTO_INCREMENT pour la table `sessions`
247--
248ALTER TABLE `sessions`
249MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=156;
250--
251-- AUTO_INCREMENT pour la table `settings`
252--
253ALTER TABLE `settings`
254MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
255--
256-- AUTO_INCREMENT pour la table `support`
257--
258ALTER TABLE `support`
259MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=29;
260--
261-- AUTO_INCREMENT pour la table `support_conversation`
262--
263ALTER TABLE `support_conversation`
264MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=123;
265--
266-- AUTO_INCREMENT pour la table `users`
267--
268ALTER TABLE `users`
269MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=128;
270/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
271/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
272/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;