Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --
- -- Database: `yourDBname`
- --
- -- --------------------------------------------------------
- --
- -- Table structure for table `tbl_users`
- --
- CREATE TABLE `tbl_users` (
- `user_id` int(11) NOT NULL,
- `user_name` varchar(25) NOT NULL,
- `user_email` varchar(60) NOT NULL,
- `user_password` varchar(255) NOT NULL,
- `joining_date` datetime NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `tbl_users`
- --
- INSERT INTO `tbl_users` (`user_id`, `user_name`, `user_email`, `user_password`, `joining_date`) VALUES
- (2, 'Fred', 'fred@me.com', '78dec27507b0f88d5fadac7be095e30c', '2017-08-31 14:19:50'),
- (3, 'Ted', 'ted@me.com', '0396b1e2c728395669189f1da619ce7a', '2017-08-31 14:23:17'),
- (4, 'Steve', 'stece@me.com', '62b1c9f774f1e0defb99240512f63765', '2017-08-31 14:32:41'),
- (5, 'Harry', 'harry@me.com', 'e879e57509b93b470219608b7603326d', '2017-08-31 14:40:39'),
- (6, 'Usif', 'usif@me.com', '3cc2e94e50f9a6f759813229da057c1d', '2017-08-31 14:45:11'),
- (7, 'Red', 'red@me.com', 'ef026326ee8822a446b9593df02359a6', '2017-08-31 14:47:45'),
- (8, 'Teddy', 'ted@gmail.com', '61d10a829eb8aa6dd7b78ba8ad64395e', '2017-08-31 14:49:27'),
- (9, 'Fed', 'fed@gmail.com', 'a8a8d31bea4d05c305803f6506a8385e', '2017-08-31 14:50:11'),
- --
- -- Indexes for dumped tables
- --
- --
- -- Indexes for table `tbl_users`
- --
- ALTER TABLE `tbl_users`
- ADD PRIMARY KEY (`user_id`);
- --
- -- AUTO_INCREMENT for dumped tables
- --
- --
- -- AUTO_INCREMENT for table `tbl_users`
- --
- ALTER TABLE `tbl_users`
- MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement