Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- phpMyAdmin SQL Dump
- -- version 4.8.2
- -- https://www.phpmyadmin.net/
- --
- -- Host: localhost
- -- Generation Time: Aug 25, 2018 at 10:48 AM
- -- Server version: 5.7.23-0ubuntu0.16.04.1
- -- PHP Version: 7.0.31-1+ubuntu16.04.1+deb.sury.org+1SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
- SET AUTOCOMMIT = 0;
- START TRANSACTION;
- SET time_zone = "+00:00";--
- -- Database: `erp_sda`
- ---- ----------------------------------------------------------
- -- Table structure for table `sda_wilayah`
- --CREATE TABLE `sda_wilayah` (
- `num` int(11) NOT NULL,
- `id` char(12) CHARACTER SET utf16 COLLATE utf16_unicode_ci NOT NULL,
- `id_parent` char(12) NOT NULL,
- `nama` varchar(50) NOT NULL,
- `id_jenis` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='summary';--
- -- Dumping data for table `sda_wilayah`
- --INSERT INTO `sda_wilayah` (`num`, `id`, `id_parent`, `nama`, `id_jenis`) VALUES
- (1, '11', '0', 'Aceh', 0),
- (2, '12', '0', 'Sumatera Utara', 0),
- (3, '13', '0', 'Sumatera Barat', 0),
- (4, '14', '0', 'Riau', 0),
- (5, '15', '0', 'Jambi', 0),
- (6, '16', '0', 'Sumatera Selatan', 0),
- (7, '17', '0', 'Bengkulu', 0),
- (8, '18', '0', 'Lampung', 0),
- (9, '19', '0', 'Kepulauan Bangka Belitung', 0),
- (10, '21', '0', 'Kepulauan Riau', 0),
- (11, '31', '0', 'DKI Jakarta', 0),
- (12, '32', '0', 'Jawa Barat', 0),
- (13, '33', '0', 'Jawa Tengah', 0),
- (14, '34', '0', 'DI Yogyakarta', 0),
- (15, '35', '0', 'Jawa Timur', 0),
- (16, '36', '0', 'Banten', 0),
- (17, '51', '0', 'Bali', 0),
- (18, '52', '0', 'Nusa Tenggara Barat', 0),
- (19, '53', '0', 'Nusa Tenggara Timur', 0),
- (20, '61', '0', 'Kalimantan Barat', 0),
- (21, '62', '0', 'Kalimantan Tengah', 0),
- (22, '63', '0', 'Kalimantan Selatan', 0),
- (23, '64', '0', 'Kalimantan Timur', 0),
- (24, '65', '0', 'Kalimantan Utara', 0),
- (25, '71', '0', 'Sulawesi Utara', 0),
- (26, '72', '0', 'Sulawesi Tengah', 0),
- (27, '73', '0', 'Sulawesi Selatan', 0),
- (28, '74', '0', 'Sulawesi Tenggara', 0),
- (29, '75', '0', 'Gorontalo', 0),
- (30, '76', '0', 'Sulawesi Barat', 0),
- (31, '81', '0', 'Maluku', 0),
- (32, '82', '0', 'Maluku Utara', 0),
- (33, '91', '0', 'Papua Barat', 0),
- (34, '92', '0', 'Papua', 0);--
- -- Indexes for dumped tables
- ----
- -- Indexes for table `sda_wilayah`
- --
- ALTER TABLE `sda_wilayah`
- ADD PRIMARY KEY (`num`),
- ADD UNIQUE KEY `id` (`id`),
- ADD KEY `id_parent` (`id_parent`),
- ADD KEY `nama` (`nama`),
- ADD KEY `id_jenis` (`id_jenis`);
- --
- -- AUTO_INCREMENT for dumped tables
- --
- --
- -- AUTO_INCREMENT for table `sda_wilayah`
- --
- ALTER TABLE `sda_wilayah`
- MODIFY `num` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35;
- COMMIT;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement