j06P202G

1-- phpMyAdmin SQL Dump
2-- version 4.8.3
3-- https://www.phpmyadmin.net/
4--
5-- Host: localhost:8889
6-- Generation Time: Jul 23, 2019 at 12:53 AM
7-- Server version: 5.7.23
8-- PHP Version: 7.2.10
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13--
14-- Database: `mbc_db`
15--
16CREATE DATABASE IF NOT EXISTS `mbc_db` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
17USE `mbc_db`;
18
19-- --------------------------------------------------------
20
21--
22-- Table structure for table `customers`
23--
24
25CREATE TABLE `customers` (
26  `id` int(11) NOT NULL,
27  `email` varchar(50) NOT NULL,
28  `firstName` varchar(30) DEFAULT NULL,
29  `lastName` varchar(30) DEFAULT NULL,
30  `phoneNumber` varchar(12) DEFAULT NULL,
31  `address` varchar(100) DEFAULT NULL,
32  `companyName` varchar(80) DEFAULT NULL,
33  `updated_at` date NOT NULL,
34  `created_at` date NOT NULL
35) ENGINE=InnoDB DEFAULT CHARSET=utf8;
36
37--
38-- Indexes for dumped tables
39--
40
41--
42-- Indexes for table `customers`
43--
44ALTER TABLE `customers`
45  ADD PRIMARY KEY (`id`),
46  ADD UNIQUE KEY `email` (`email`);
47
48--
49-- AUTO_INCREMENT for dumped tables
50--
51
52--
53-- AUTO_INCREMENT for table `customers`
54--
55ALTER TABLE `customers`
56  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;