· 10 years ago · Apr 23, 2016, 01:42 PM
1-- phpMyAdmin SQL Dump
2-- version 4.1.14
3-- http://www.phpmyadmin.net
4--
5-- Client : 127.0.0.1
6-- Généré le : Sam 23 Avril 2016 à 15:26
7-- Version du serveur : 5.6.17
8-- Version de PHP : 5.5.12
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 : `listelobby`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Structure de la table `lobby`
27--
28
29CREATE TABLE IF NOT EXISTS `lobby` (
30 `id` int(11) NOT NULL AUTO_INCREMENT,
31 `email_acheteur` longtext NOT NULL,
32 `email_psn` longtext NOT NULL,
33 `mdp_psn` longtext NOT NULL,
34 `jeu` longtext NOT NULL,
35 `formule` longtext NOT NULL,
36 `infos` longtext NOT NULL,
37 `psn_id` longtext NOT NULL,
38 PRIMARY KEY (`id`)
39) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;
40
41--
42-- Contenu de la table `lobby`
43--
44
45INSERT INTO `lobby` (`id`, `email_acheteur`, `email_psn`, `mdp_psn`, `jeu`, `formule`, `infos`, `psn_id`) VALUES
46(7, 'xwzino@hotmail.fr', 'xwzino@hotmail.fr', 'x', 'Call Of Duty : Advanced Warfare', 'Basique', 'x', '<br />\r\n<font size=''1''><table class=''xdebug-error xe-notice'' dir=''ltr'' border=''1'' cellspacing=''0'' cellpadding=''1''>\r\n<tr><th align=''left'' bgcolor=''#f57900'' colspan='),
47(8, 'xwzino@hotmail.fr', 'xwzino@hotmail.fr', 'x', 'Call Of Duty : Advanced Warfare', 'Basique', 'x', '<br />\r\n<font size=''1''><table class=''xdebug-error xe-notice'' dir=''ltr'' border=''1'' cellspacing=''0'' cellpadding=''1''>\r\n<tr><th align=''left'' bgcolor=''#f57900'' colspan='),
48(9, 'r', 'r', 'r', 'Call Of Duty : Advanced Warfare', 'Basique', 'r', '<br />\r\n<font size=''1''><table class=''xdebug-error xe-notice'' dir=''ltr'' border=''1'' cellspacing=''0'' cellpadding=''1''>\r\n<tr><th align=''left'' bgcolor=''#f57900'' colspan='),
49(10, 'x', 'x', 'x', 'Call Of Duty : Advanced Warfare', 'Basique', 'x', '<br />\r\n<font size=''1''><table class=''xdebug-error xe-notice'' dir=''ltr'' border=''1'' cellspacing=''0'' cellpadding=''1''>\r\n<tr><th align=''left'' bgcolor=''#f57900'' colspan='),
50(11, 'x', 'x', '', 'Call Of Duty : Advanced Warfare', 'Basique', 'x', '<br />\r\n<font size=''1''><table class=''xdebug-error xe-notice'' dir=''ltr'' border=''1'' cellspacing=''0'' cellpadding=''1''>\r\n<tr><th align=''left'' bgcolor=''#f57900'' colspan=');
51
52-- --------------------------------------------------------
53
54--
55-- Structure de la table `login`
56--
57
58CREATE TABLE IF NOT EXISTS `login` (
59 `id` int(11) NOT NULL AUTO_INCREMENT,
60 `username` longtext NOT NULL,
61 `password` longtext NOT NULL,
62 PRIMARY KEY (`id`)
63) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
64
65--
66-- Contenu de la table `login`
67--
68
69INSERT INTO `login` (`id`, `username`, `password`) VALUES
70(1, 'xWzino', ''),
71(2, 'Maskuch', 'd64e131e393f0d4070b7f8d7964875d022b976631a35d9d527180df1f5d52e32'),
72(3, 'xWzino', ''),
73(4, 'Maskuch', '4baf160df76f238a71d2d039e91d9804f28b5bc8');
74
75-- --------------------------------------------------------
76
77--
78-- Structure de la table `support`
79--
80
81CREATE TABLE IF NOT EXISTS `support` (
82 `id` int(11) NOT NULL AUTO_INCREMENT,
83 `pseudo` longtext NOT NULL,
84 `email` longtext NOT NULL,
85 `objet` longtext NOT NULL,
86 `message` longtext NOT NULL,
87 PRIMARY KEY (`id`)
88) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
89
90--
91-- Contenu de la table `support`
92--
93
94INSERT INTO `support` (`id`, `pseudo`, `email`, `objet`, `message`) VALUES
95(1, 'x', 'xwzino@hotmail.fr', 'x', 'x');
96
97-- --------------------------------------------------------
98
99--
100-- Structure de la table `traitement_achat`
101--
102
103CREATE TABLE IF NOT EXISTS `traitement_achat` (
104 `id` int(11) NOT NULL AUTO_INCREMENT,
105 `email_acheteur` longtext NOT NULL,
106 `email_psn` longtext NOT NULL,
107 `mdp_psn` longtext NOT NULL,
108 `jeu` longtext NOT NULL,
109 `formule` longtext NOT NULL,
110 `infos` longtext NOT NULL,
111 `psn_id` longtext NOT NULL,
112 PRIMARY KEY (`id`)
113) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
114
115/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
116/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
117/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;