wmWjf81T

1-- phpMyAdmin SQL Dump
2-- version 4.2.11
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: Dec 26, 2018 at 02:19 PM
7-- Server version: 5.6.21
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: `database_tha`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `customer`
27--
28
29CREATE TABLE IF NOT EXISTS `customer` (
30`id` int(11) NOT NULL,
31  `name` varchar(40) NOT NULL,
32  `password` varchar(40) NOT NULL,
33  `email` varchar(40) NOT NULL,
34  `user_group` int(11) NOT NULL
35) ENGINE=InnoDB DEFAULT CHARSET=latin1;
36
37--
38-- Indexes for dumped tables
39--
40
41--
42-- Indexes for table `customer`
43--
44ALTER TABLE `customer`
45 ADD PRIMARY KEY (`id`);
46
47--
48-- AUTO_INCREMENT for dumped tables
49--
50
51--
52-- AUTO_INCREMENT for table `customer`
53--
54ALTER TABLE `customer`
55MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
56/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
57/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
58/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;