ajTnVeAZ

1DROP TABLE IF EXISTS `staffs`;
2CREATE TABLE `staffs` (
3  `id` int(11) NOT NULL,
4  `fname` varchar(255) DEFAULT NULL,
5  `lname` varchar(255) DEFAULT NULL,
6  `email` varchar(255) DEFAULT NULL,
7  `phone` varchar(255) DEFAULT NULL,a
8  `address` text,
9  `gender` varchar(255) DEFAULT NULL,
10  `created` datetime DEFAULT NULL,
11  `modified` datetime DEFAULT NULL
12) ENGINE=InnoDB DEFAULT CHARSET=latin1;
13
14--
15-- Dumping data for table `staffs`
16--
17
18INSERT INTO `staffs` (`id`, `fname`, `lname`, `email`, `phone`, `address`, `gender`, `created`, `modified`) VALUES
19(1, 'Mohd', 'Zaki', 'mzm@gmail.com', '123456789', 'KL', 'Lelaki', '2017-05-24 00:00:00', '2017-05-17 00:00:00'),
20(2, 'Mohd', 'Husin', 'husin@gmail.com', '12345667', 'Putrajaya', 'Lelaki', '2017-05-17 00:00:00', '2017-05-17 00:00:00'),
21(3, 'Mohd', 'Jaafar', 'jaafar@gmail.com', '12345667', 'Putrajaya', 'Lelaki', '2017-05-17 00:00:00', '2017-05-17 00:00:00'),
22(4, 'Mohd', 'Zahari', 'zahari@gmail.com', '12345667', 'Putrajaya', 'Lelaki', '2017-05-17 00:00:00', '2017-05-17 00:00:00'),
23(5, 'Mohd', 'Johan', 'johan@gmail.com', '12345667', 'Putrajaya', 'Lelaki', '2017-05-17 00:00:00', '2017-05-17 00:00:00'),
24(6, 'Saiful', 'Ahmad', 'saiful@gmail.com', '12344656', 'KL', 'Lelaki', NULL, NULL);
25--
26-- Indexes for dumped tables
27--
28
29--
30-- Indexes for table `staffs`
31--
32ALTER TABLE `staffs`
33  ADD PRIMARY KEY (`id`);