Advertisement
Guest User

Untitled

a guest
Apr 24th, 2015
366
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.41 KB | None | 0 0
  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.  
  10. SET 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.  
  22. CREATE 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.  
  35. INSERT 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);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement