eZTkQn3A

1-- phpMyAdmin SQL Dump
2-- version 3.2.0.1
3-- http://www.phpmyadmin.net
4--
5-- Serveur: localhost
6-- Généré le : Ven 24 Avril 2015 à 07:06
7-- Version du serveur: 5.1.36
8-- Version de PHP: 5.3.0
9
10SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11
12--
13-- Base de données: `mywebsite`
14--
15
16-- --------------------------------------------------------
17
18--
19-- Structure de la table `members`
20--
21
22CREATE TABLE IF NOT EXISTS `members` (
23  `id` smallint(6) NOT NULL AUTO_INCREMENT,
24  `nickname` varchar(30) NOT NULL,
25  `password` varchar(30) NOT NULL,
26  `email` varchar(30) NOT NULL,
27  `gid` tinyint(4) NOT NULL,
28  PRIMARY KEY (`id`)
29) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=20 ;
30
31--
32-- Contenu de la table `members`
33--
34
35INSERT INTO `members` (`id`, `nickname`, `password`, `email`, `gid`) VALUES
36(1, 'admin', '123456', 'admin', 1),
37(2, 'antoine', '123', '123@123.com', 0),
38(3, 'da', 'da', 'da', 0),
39(4, 'dada', 'da', 'da', 0),
40(5, 'renou', 'ren', 'dadadadad', 0),
41(6, 'tata', 'tata', 'tata', 0),
42(10, 'user1', '123', '123', 0),
43(11, 'utilisateur', 'azer', 'azer', 0),
44(12, 'bryan', '123', '123', 0),
45(14, 'Renou', '123', 'antoinerenou95@gmail.com', 0),
46(15, 'a', '123', 'antoinerenou95@gmail.com', 0),
47(16, 'b', '123', 'antoinerenou95@gmail.com', 0),
48(17, 'c', 'c', 'antoinerenou95@gmail.com', 0),
49(18, 'cq', '123', 'antoinerenou95@gmail.com', 0),
50(19, 's', '123', 'antoinerenou95@gmail.com', 0);