Guest User

Untitled

a guest
Jun 8th, 2018
301
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.53 KB | None | 0 0
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.7.7
  3. -- https://www.phpmyadmin.net/
  4. --
  5. -- Host: localhost:3306
  6. -- Generation Time: Jun 08, 2018 at 08:14 PM
  7. -- Server version: 5.6.39
  8. -- PHP Version: 5.6.30
  9.  
  10. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  11. SET AUTOCOMMIT = 0;
  12. START TRANSACTION;
  13. SET 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. -- Database: `justgra2_fullsite`
  23. --
  24.  
  25. -- --------------------------------------------------------
  26.  
  27. --
  28. -- Table structure for table `users`
  29. --
  30.  
  31. CREATE TABLE `users` (
  32. `ID` int(11) NOT NULL,
  33. `username` text NOT NULL,
  34. `email` varchar(30) NOT NULL,
  35. `password` varchar(37) DEFAULT NULL,
  36. `first_name` varchar(11) NOT NULL,
  37. `last_name` varchar(11) NOT NULL,
  38. `validation` int(12) NOT NULL
  39. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  40.  
  41. --
  42. -- Dumping data for table `users`
  43. --
  44.  
  45. INSERT INTO `users` (`ID`, `username`, `email`, `password`, `first_name`, `last_name`, `validation`) VALUES
  46. (0, 'TESTACC', '[email protected]', '', 'Test', 'Account', 0);
  47.  
  48. --
  49. -- Indexes for dumped tables
  50. --
  51.  
  52. --
  53. -- Indexes for table `users`
  54. --
  55. ALTER TABLE `users`
  56. ADD PRIMARY KEY (`ID`);
  57. COMMIT;
  58.  
  59. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  60. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  61. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Advertisement
Add Comment
Please, Sign In to add comment