4QHGB9fN

1-- phpMyAdmin SQL Dump
2-- version 4.2.11
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: Mar 02, 2019 at 05:44 PM
7-- Server version: 5.7.19-log
8-- PHP Version: 5.6.3
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `emp`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `user`
27--
28
29CREATE TABLE IF NOT EXISTS `user` (
30`id` int(11) NOT NULL,
31  `name` varchar(100) NOT NULL,
32  `email` varchar(50) NOT NULL
33) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
34
35--
36-- Dumping data for table `user`
37--
38
39INSERT INTO `user` (`id`, `name`, `email`) VALUES
40(1, 'Barney', 'Rubble'),
41(2, 'Barney', 'Rubble'),
42(3, '@ManagedBean   @ReferencedBean  ', '@ManagedBean   @ReferencedBean  '),
43(4, 'Awais', 'Awais'),
44(5, 'Awais', 'Awais'),
45(6, '', ''),
46(7, 'hamza', 'hamza');
47
48-- --------------------------------------------------------
49
50--
51-- Table structure for table `users`
52--
53
54CREATE TABLE IF NOT EXISTS `users` (
55`id` int(11) NOT NULL,
56  `name` varchar(100) DEFAULT NULL,
57  `email` varchar(50) DEFAULT NULL,
58  `password` varchar(20) DEFAULT NULL,
59  `gender` varchar(1) DEFAULT NULL,
60  `address` text
61) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
62
63--
64-- Dumping data for table `users`
65--
66
67INSERT INTO `users` (`id`, `name`, `email`, `password`, `gender`, `address`) VALUES
68(1, 'Awaisa g', 'aarshadaawais@gmail.com', 'awais12345', 'm', 'st 51 ');
69
70--
71-- Indexes for dumped tables
72--
73
74--
75-- Indexes for table `user`
76--
77ALTER TABLE `user`
78 ADD PRIMARY KEY (`id`);
79
80--
81-- Indexes for table `users`
82--
83ALTER TABLE `users`
84 ADD PRIMARY KEY (`id`);
85
86--
87-- AUTO_INCREMENT for dumped tables
88--
89
90--
91-- AUTO_INCREMENT for table `user`
92--
93ALTER TABLE `user`
94MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8;
95--
96-- AUTO_INCREMENT for table `users`
97--
98ALTER TABLE `users`
99MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
100/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
101/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
102/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;