text: -- phpMyAdmin SQL Dump
  -- version 5.1.0
  -- https://www.phpmyadmin.net/
  --
  -- Host: 127.0.0.1
  -- Waktu pembuatan: 20 Jun 2021 pada 17.27
  -- Versi server: 10.4.18-MariaDB
  -- Versi PHP: 8.0.3
  
  SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  START TRANSACTION;
  SET time_zone = "+00:00";
  
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  /*!40101 SET NAMES utf8mb4 */;
  
  --
  -- Database: `testing`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `employee`
  --
  
  CREATE TABLE `employee` (
    `employee_id` int(11) NOT NULL,
    `employee_name` varchar(100) NOT NULL,
    `employee_mobile` varchar(100) NOT NULL,
    `employee_email` varchar(20) NOT NULL,
    `employee_department` varchar(50) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  
  --
  -- Dumping data untuk tabel `employee`
  --
  
  INSERT INTO `employee` (`employee_id`, `employee_name`, `employee_mobile`, `employee_email`, `employee_department`) VALUES
  (1, 'Aimee Padberg', '828.959.4878', 'rippin.orlando@schad', 'Marketing'),
  (2, 'Declan Kuhlman V', '(820) 248-0241', 'rwintheiser@schinner', 'Inventory'),
  (3, 'Mariano Macejkovic', '1-949-389-9007', 'sophie13@gmail.com', 'Marketing'),
  (4, 'Prof. Jayson O\'Connell V', '+1-725-690-8849', 'okirlin@hotmail.com', 'Marketing'),
  (5, 'Elise Feil II', '+1-580-828-4117', 'gwendolyn96@gmail.co', 'Marketing'),
  (6, 'Elna Parker V', '+1-423-969-2047', 'terry.delores@swania', 'Finance'),
  (7, 'Ethelyn Nader Sr.', '+18729165980', 'uokeefe@gmail.com', 'Inventory'),
  (8, 'Prof. Jillian Kautzer III', '(913) 686-7771', 'gaston59@hotmail.com', 'Production'),
  (9, 'Estell Mohr', '304.221.4743', 'vilma.lesch@leffler.', 'Inventory'),
  (10, 'Kiley Stoltenberg DDS', '1-801-850-8510', 'zoila.schmitt@tillma', 'Finance'),
  (11, 'Esteban Gislason', '(425) 848-7972', 'kulas.dandre@hotmail', 'Production'),
  (12, 'Vicky Stamm', '463.365.5521', 'dhessel@gleichner.bi', 'Production'),
  (13, 'Abdullah Friesen', '1-478-426-1074', 'pacocha.kaleb@hotmai', 'Marketing'),
  (14, 'Fermin Bashirian', '410-333-6799', 'granville.cruickshan', 'Production'),
  (15, 'Eveline Stanton', '+1.707.726.5992', 'schamberger.daniela@', 'Marketing'),
  (16, 'Jermain Deckow', '+1 (719) 235-8560', 'juwan48@johnston.com', 'Finance'),
  (17, 'Valentin Blanda', '1-385-283-7071', 'fschinner@king.com', 'Production'),
  (18, 'Lempi Berge', '+1-202-674-5616', 'moshe.koelpin@hotmai', 'Finance'),
  (19, 'Prof. Connor Gleichner', '1-918-310-2829', 'citlalli.cummerata@m', 'Marketing'),
  (20, 'Aylin Kerluke DVM', '304.877.3278', 'thansen@stiedemann.c', 'Finance'),
  (21, 'Ms. Ethelyn Bartoletti', '(458) 569-1230', 'homenick.lenora@jaco', 'Inventory'),
  (22, 'Adolf Hodkiewicz', '(224) 497-6960', 'gorczany.joanne@yaho', 'Production'),
  (23, 'Daphne Bechtelar IV', '+14757005278', 'lesch.kitty@effertz.', 'Inventory'),
  (24, 'Susanna Hessel', '+1.206.567.5806', 'yesenia82@marquardt.', 'Marketing'),
  (25, 'Marta Lowe', '424.639.3398', 'dcartwright@hotmail.', 'Inventory'),
  (26, 'Lupe McKenzie', '+1 (786) 218-6547', 'sauer.arthur@gmail.c', 'Finance'),
  (27, 'Santina Schmidt', '+1-405-830-4176', 'taryn.fritsch@hotmai', 'Marketing'),
  (28, 'Dr. Tristin Smitham MD', '386.369.2113', 'jortiz@hotmail.com', 'Inventory'),
  (29, 'Bryon Kuvalis', '+12236271841', 'lucie.swaniawski@hot', 'Inventory'),
  (30, 'Favian Eichmann', '+1.916.373.5712', 'rmiller@botsford.org', 'Production'),
  (31, 'Caden Yost', '(425) 787-1726', 'pattie.abernathy@gma', 'Production'),
  (32, 'Mr. Nigel Legros DVM', '(662) 401-4365', 'lucile.dickens@barto', 'Finance'),
  (33, 'Nyasia Kirlin', '423-664-3029', 'beier.orval@yahoo.co', 'Production'),
  (34, 'Birdie Hoeger', '762-899-8072', 'paucek.mara@gmail.co', 'Marketing'),
  (35, 'Delia Grady', '769.665.6416', 'vzulauf@graham.com', 'Finance'),
  (36, 'Cooper Miller', '319.558.6302', 'constantin25@durgan.', 'Finance'),
  (37, 'Hilma Keeling', '952-202-4034', 'plesch@hotmail.com', 'Inventory'),
  (38, 'Greyson Mayert', '(715) 753-2256', 'ruby.windler@yahoo.c', 'Finance'),
  (39, 'Elmer Moore', '(732) 486-5098', 'rogahn.evelyn@hotmai', 'Finance'),
  (40, 'Anne Braun IV', '913-610-3883', 'yquigley@hotmail.com', 'Finance'),
  (41, 'Prof. Amiya Raynor DDS', '+1-440-963-4980', 'rmoen@gmail.com', 'Marketing'),
  (42, 'Maya Harris', '+17475540412', 'marquardt.myron@wind', 'Production'),
  (43, 'King Bogan', '425.929.8145', 'georgette37@hane.com', 'Inventory'),
  (44, 'Kirstin Stamm', '+1.617.786.7612', 'torey57@yahoo.com', 'Production'),
  (45, 'Fanny Lindgren', '(539) 336-0705', 'flangosh@macejkovic.', 'Production'),
  (46, 'Abdullah Daniel', '+1-878-604-6735', 'fkautzer@hotmail.com', 'Marketing'),
  (47, 'Prof. Antonette Towne IV', '1-678-245-4258', 'moriah.okuneva@yahoo', 'Finance'),
  (48, 'Kayleigh Morar', '(585) 384-7949', 'ljohnston@dare.com', 'Marketing'),
  (49, 'Dangelo Feeney', '517.506.3889', 'llittle@runolfsson.c', 'Inventory'),
  (50, 'Prof. Ethan Kihn', '463-424-7966', 'braden.brakus@dietri', 'Inventory');
  
  --
  -- Indexes for dumped tables
  --
  
  --
  -- Indeks untuk tabel `employee`
  --
  ALTER TABLE `employee`
    ADD PRIMARY KEY (`employee_id`);
  
  --
  -- AUTO_INCREMENT untuk tabel yang dibuang
  --
  
  --
  -- AUTO_INCREMENT untuk tabel `employee`
  --
  ALTER TABLE `employee`
    MODIFY `employee_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=51;
  COMMIT;
  
  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  