Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- phpMyAdmin SQL Dump
- -- version 4.4.15.9
- -- https://www.phpmyadmin.net
- --
- -- Host: localhost
- -- Generation Time: Nov 19, 2018 at 03:47 AM
- -- Server version: 5.6.37
- -- PHP Version: 7.1.8
- SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
- SET time_zone = "+00:00";
- --
- -- Database: `prj_travel`
- --
- -- --------------------------------------------------------
- --
- -- Table structure for table `districts`
- --
- CREATE TABLE IF NOT EXISTS `districts` (
- `id` char(7) COLLATE utf8_unicode_ci NOT NULL,
- `regency_id` char(4) COLLATE utf8_unicode_ci NOT NULL,
- `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
- --
- -- Dumping data for table `districts`
- --
- -- --------------------------------------------------------
- --
- -- Table structure for table `perusahaans`
- --
- CREATE TABLE IF NOT EXISTS `perusahaans` (
- `id` int(10) unsigned NOT NULL,
- `agen_type` enum('1','2','3') COLLATE utf8mb4_unicode_ci NOT NULL,
- `parent_id` int(10) unsigned DEFAULT NULL,
- `nama_perusahaan` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
- `jenis_izin usaha` int(10) unsigned DEFAULT NULL,
- `nomor_izin_usaha` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT '',
- `npwp` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT '',
- `negara_id` int(10) unsigned DEFAULT NULL,
- `province_id` int(10) unsigned DEFAULT NULL,
- `regency_id` int(10) unsigned DEFAULT NULL,
- `district_id` int(10) unsigned DEFAULT NULL,
- `village_id` int(10) unsigned DEFAULT NULL,
- `alamat` text COLLATE utf8mb4_unicode_ci,
- `latitude` double DEFAULT NULL,
- `longitude` double DEFAULT NULL,
- `nama_pimpinan` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT '',
- `no_ktp_pimpinan` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT '',
- `file_surat_izin` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT '',
- `file_npwp` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT '',
- `file_ktp_pimpinan` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT '',
- `status_perusahaan` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT '',
- `jenis_izin` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
- `token` char(8) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
- `created_at` timestamp NULL DEFAULT NULL,
- `updated_at` timestamp NULL DEFAULT NULL
- ) ENGINE=InnoDB AUTO_INCREMENT=106 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
- --
- -- Dumping data for table `perusahaans`
- --
- INSERT INTO `perusahaans` (`id`, `agen_type`, `parent_id`, `nama_perusahaan`, `jenis_izin usaha`, `nomor_izin_usaha`, `npwp`, `negara_id`, `province_id`, `regency_id`, `district_id`, `village_id`, `alamat`, `latitude`, `longitude`, `nama_pimpinan`, `no_ktp_pimpinan`, `file_surat_izin`, `file_npwp`, `file_ktp_pimpinan`, `status_perusahaan`, `jenis_izin`, `token`, `created_at`, `updated_at`) VALUES
- (6, '2', NULL, 'Agent Ltd', NULL, '', '23432', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '1', 'asdfa', 'GNDM1383', '2018-11-17 04:02:02', '2018-11-17 04:03:52'),
- (100, '1', NULL, 'Agent2 Ltd', NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '0', 'SK-11111', 'LSWF3413', '2018-11-17 03:20:32', '2018-11-17 03:20:32'),
- (102, '2', NULL, 'PT 1 2 3', NULL, '', 'PT 1 2 3', NULL, 14, NULL, NULL, NULL, 'PT 1 2 3', 123, 321, 'PT 1 2 3', 'PT 1 2 3', 'file-surat-izin/2018/11/ff55835f8bf9a311da55b2866ce4689a.png', 'file-npwp/2018/11/ff55835f8bf9a311da55b2866ce4689a.png', 'file-ktp-pimpinan/2018/11/ff55835f8bf9a311da55b2866ce4689a.png', '1', 'PT 1 2 3', NULL, '2018-11-18 04:20:28', '2018-11-18 04:20:28'),
- (103, '2', NULL, 'Gundam', NULL, '', 'Gundam', NULL, 13, NULL, NULL, NULL, 'Gundam', 1212, 1212, 'Gundam', 'Gundam', 'file-surat-izin/2018/11/3f228c378a77d6409da5617a066b75e9.png', 'file-npwp/2018/11/3f228c378a77d6409da5617a066b75e9.png', 'file-ktp-pimpinan/2018/11/3f228c378a77d6409da5617a066b75e9.png', '0', 'Gundam', NULL, '2018-11-18 04:35:06', '2018-11-18 04:35:06'),
- (104, '2', NULL, 'fasdfadsf', NULL, '', 'asdfasdf', NULL, 14, NULL, NULL, NULL, 'adsfasdf', 23423423, 42342, '34234', '34234234', 'file-surat-izin/2018/11/3e8c1653e2dba242f5ea2f67065417db.png', 'file-npwp/2018/11/3e8c1653e2dba242f5ea2f67065417db.png', 'file-ktp-pimpinan/2018/11/3e8c1653e2dba242f5ea2f67065417db.png', '1', 'asdfasdf', NULL, '2018-11-18 04:37:39', '2018-11-18 07:58:49'),
- (105, '2', 100, 'PT 123', NULL, '', 'PT 123', NULL, 13, NULL, NULL, NULL, 'PT 123', 4323, 1212, 'PT 123', 'PT 123', 'file-surat-izin/2018/11/7489acc0647da8057b9d7b4ac9fd8320.png', 'file-npwp/2018/11/7489acc0647da8057b9d7b4ac9fd8320.png', 'file-ktp-pimpinan/2018/11/7489acc0647da8057b9d7b4ac9fd8320.png', '0', 'PT 123', '5BF15A', '2018-11-18 05:28:58', '2018-11-18 05:28:58'),
- (140, '2', NULL, 'PT 1 2 3', NULL, '', 'PT 1 2 3', NULL, 14, NULL, NULL, NULL, 'PT 1 2 3', 123, 321, 'PT 1 2 3', 'PT 1 2 3', 'file-surat-izin/2018/11/761635ff527e624010ae023f7768434a.png', 'file-npwp/2018/11/761635ff527e624010ae023f7768434a.png', 'file-ktp-pimpinan/2018/11/761635ff527e624010ae023f7768434a.png', '1', 'PT 1 2 3', NULL, '2018-11-18 04:19:45', '2018-11-18 04:19:45');
- -- --------------------------------------------------------
- --
- -- Table structure for table `provinces`
- --
- CREATE TABLE IF NOT EXISTS `provinces` (
- `id` char(2) COLLATE utf8_unicode_ci NOT NULL,
- `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
- --
- -- Dumping data for table `provinces`
- --
- INSERT INTO `provinces` (`id`, `name`) VALUES
- ('11', 'Aceh'),
- ('12', 'Sumatera Utara'),
- ('13', 'Sumatera Barat'),
- ('14', 'Riau'),
- ('15', 'Jambi'),
- ('16', 'Sumatera Selatan'),
- ('17', 'Bengkulu'),
- ('18', 'Lampung'),
- ('19', 'Kepulauan Bangka Belitung'),
- ('21', 'Kepulauan Riau'),
- ('31', 'DKI Jakarta'),
- ('32', 'Jawa Barat'),
- ('33', 'Jawa Tengah'),
- ('34', 'DI Yogyakarta'),
- ('35', 'Jawa Timur'),
- ('36', 'Banten'),
- ('51', 'Bali'),
- ('52', 'Nusa Tenggara Barat'),
- ('53', 'Nusa Tenggara Timur'),
- ('61', 'Kalimantan Barat'),
- ('62', 'Kalimantan Tengah'),
- ('63', 'Kalimantan Selatan'),
- ('64', 'Kalimantan Timur'),
- ('65', 'Kalimantan Utara'),
- ('71', 'Sulawesi Utara'),
- ('72', 'Sulawesi Tengah'),
- ('73', 'Sulawesi Selatan'),
- ('74', 'Sulawesi Tenggara'),
- ('75', 'Gorontalo'),
- ('76', 'Sulawesi Barat'),
- ('81', 'Maluku'),
- ('82', 'Maluku Utara'),
- ('91', 'Papua Barat'),
- ('94', 'Papua');
- -- --------------------------------------------------------
- --
- -- Table structure for table `regencies`
- --
- CREATE TABLE IF NOT EXISTS `regencies` (
- `id` char(4) COLLATE utf8_unicode_ci NOT NULL,
- `province_id` char(2) COLLATE utf8_unicode_ci NOT NULL,
- `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
- --
- -- Dumping data for table `regencies`
- --
- --
- -- Indexes for dumped tables
- --
- --
- -- Indexes for table `districts`
- --
- ALTER TABLE `districts`
- ADD PRIMARY KEY (`id`),
- ADD KEY `districts_id_index` (`regency_id`);
- --
- -- Indexes for table `perusahaans`
- --
- ALTER TABLE `perusahaans`
- ADD PRIMARY KEY (`id`);
- --
- -- Indexes for table `provinces`
- --
- ALTER TABLE `provinces`
- ADD PRIMARY KEY (`id`);
- --
- -- Indexes for table `regencies`
- --
- ALTER TABLE `regencies`
- ADD PRIMARY KEY (`id`),
- ADD KEY `regencies_province_id_index` (`province_id`);
- --
- -- AUTO_INCREMENT for dumped tables
- --
- --
- -- AUTO_INCREMENT for table `perusahaans`
- --
- ALTER TABLE `perusahaans`
- MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=106;
- --
- -- Constraints for dumped tables
- --
- --
- -- Constraints for table `districts`
- --
- ALTER TABLE `districts`
- ADD CONSTRAINT `districts_regency_id_foreign` FOREIGN KEY (`regency_id`) REFERENCES `regencies` (`id`);
- --
- -- Constraints for table `regencies`
- --
- ALTER TABLE `regencies`
- ADD CONSTRAINT `regencies_province_id_foreign` FOREIGN KEY (`province_id`) REFERENCES `provinces` (`id`);
Add Comment
Please, Sign In to add comment