LWKeRfev

1-- phpMyAdmin SQL Dump
2-- version 4.2.11
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: May 26, 2016 at 07:42 PM
7-- Server version: 5.6.21
8-- PHP Version: 5.5.19
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: `test`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `test_demo`
27--
28
29CREATE TABLE IF NOT EXISTS `test_demo` (
30`id` int(255) NOT NULL,
31  `name` varchar(255) NOT NULL,
32  `email` varchar(255) NOT NULL,
33  `phone_number` varchar(255) NOT NULL
34) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
35
36--
37-- Dumping data for table `test_demo`
38--
39
40INSERT INTO `test_demo` (`id`, `name`, `email`, `phone_number`) VALUES
41(1, 'Sam', 'sam@gmail.com', '1234567890'),
42(2, 'smith', 'smith@gmail.com', '0987654321'),
43(3, 'John', 'john@gmail.com', '1234567890'),
44(4, 'sameer', 'sameer@gmail.com', '0987654321'),
45(5, 'Jack', 'jack@gmail.com', '1234567890');
46
47--
48-- Indexes for dumped tables
49--
50
51--
52-- Indexes for table `test_demo`
53--
54ALTER TABLE `test_demo`
55 ADD PRIMARY KEY (`id`);
56
57--
58-- AUTO_INCREMENT for dumped tables
59--
60
61--
62-- AUTO_INCREMENT for table `test_demo`
63--
64ALTER TABLE `test_demo`
65MODIFY `id` int(255) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
66/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
67/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
68/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;