Advertisement
Guest User

Untitled

a guest
Aug 31st, 2017
472
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.51 KB | None | 0 0
  1. --
  2. -- Database: `yourDBname`
  3. --
  4.  
  5. -- --------------------------------------------------------
  6.  
  7. --
  8. -- Table structure for table `tbl_users`
  9. --
  10.  
  11. CREATE TABLE `tbl_users` (
  12. `user_id` int(11) NOT NULL,
  13. `user_name` varchar(25) NOT NULL,
  14. `user_email` varchar(60) NOT NULL,
  15. `user_password` varchar(255) NOT NULL,
  16. `joining_date` datetime NOT NULL
  17. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  18.  
  19. --
  20. -- Dumping data for table `tbl_users`
  21. --
  22.  
  23. INSERT INTO `tbl_users` (`user_id`, `user_name`, `user_email`, `user_password`, `joining_date`) VALUES
  24. (2, 'Fred', 'fred@me.com', '78dec27507b0f88d5fadac7be095e30c', '2017-08-31 14:19:50'),
  25. (3, 'Ted', 'ted@me.com', '0396b1e2c728395669189f1da619ce7a', '2017-08-31 14:23:17'),
  26. (4, 'Steve', 'stece@me.com', '62b1c9f774f1e0defb99240512f63765', '2017-08-31 14:32:41'),
  27. (5, 'Harry', 'harry@me.com', 'e879e57509b93b470219608b7603326d', '2017-08-31 14:40:39'),
  28. (6, 'Usif', 'usif@me.com', '3cc2e94e50f9a6f759813229da057c1d', '2017-08-31 14:45:11'),
  29. (7, 'Red', 'red@me.com', 'ef026326ee8822a446b9593df02359a6', '2017-08-31 14:47:45'),
  30. (8, 'Teddy', 'ted@gmail.com', '61d10a829eb8aa6dd7b78ba8ad64395e', '2017-08-31 14:49:27'),
  31. (9, 'Fed', 'fed@gmail.com', 'a8a8d31bea4d05c305803f6506a8385e', '2017-08-31 14:50:11'),
  32.  
  33. --
  34. -- Indexes for dumped tables
  35. --
  36.  
  37. --
  38. -- Indexes for table `tbl_users`
  39. --
  40. ALTER TABLE `tbl_users`
  41. ADD PRIMARY KEY (`user_id`);
  42.  
  43. --
  44. -- AUTO_INCREMENT for dumped tables
  45. --
  46.  
  47. --
  48. -- AUTO_INCREMENT for table `tbl_users`
  49. --
  50. ALTER TABLE `tbl_users`
  51. MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement