F1gjyk41

1-- phpMyAdmin SQL Dump
2-- version 4.4.15.9
3-- https://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Sep 06, 2019 at 02:04 PM
7-- Server version: 5.6.37
8-- PHP Version: 7.2.22
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13--
14-- Database: `testing`
15--
16
17-- --------------------------------------------------------
18
19--
20-- Table structure for table `kota`
21--
22
23CREATE TABLE IF NOT EXISTS `kota` (
24  `id` int(11) NOT NULL,
25  `code` char(11) NOT NULL,
26  `name` varchar(110) NOT NULL,
27  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
28  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
29) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
30
31--
32-- Dumping data for table `kota`
33--
34
35INSERT INTO `kota` (`id`, `code`, `name`, `created_at`, `updated_at`) VALUES
36(1, 'JK', 'Jakarta', '2019-09-06 11:44:20', '2019-09-06 11:44:20'),
37(2, 'SB', 'Surabaya', '2019-09-06 11:44:20', '2019-09-06 11:44:20'),
38(3, 'BL', 'Bali', '2019-09-06 11:44:20', '2019-09-06 11:44:20'),
39(4, 'BD', 'BANDUNG', '2019-09-06 11:44:20', '2019-09-06 11:44:20'),
40(5, 'SMG', 'SEMARANG', '2019-09-06 11:44:20', '2019-09-06 11:45:09'),
41(6, 'SL', 'SOLO', '2019-09-06 11:44:43', '2019-09-06 11:44:43'),
42(7, 'SJ', 'SALATIGA', '2019-09-06 11:44:43', '2019-09-06 11:44:43');
43
44--
45-- Indexes for dumped tables
46--
47
48--
49-- Indexes for table `kota`
50--
51ALTER TABLE `kota`
52  ADD PRIMARY KEY (`id`),
53  ADD UNIQUE KEY `kode` (`code`),
54  ADD KEY `nama` (`name`);
55
56--
57-- AUTO_INCREMENT for dumped tables
58--
59
60--
61-- AUTO_INCREMENT for table `kota`
62--
63ALTER TABLE `kota`
64  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8;