Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- phpMyAdmin SQL Dump
- -- version 4.0.10deb1
- -- http://www.phpmyadmin.net
- --
- -- Host: localhost
- SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
- SET time_zone = "+00:00";
- --
- -- Database: `laravel`
- --
- -- --------------------------------------------------------
- --
- -- Table structure for table `propinsi`
- --
- CREATE TABLE IF NOT EXISTS `propinsi` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `kode` tinyint(4) NOT NULL,
- `nama` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
- `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
- `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
- PRIMARY KEY (`id`),
- UNIQUE KEY `propinsi_kode_unique` (`kode`),
- UNIQUE KEY `propinsi_nama_unique` (`nama`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=35 ;
- --
- -- Dumping data for table `propinsi`
- --
- INSERT INTO `propinsi` (`id`, `kode`, `nama`, `created_at`, `updated_at`) VALUES
- (1, 11, 'Aceh', '2015-04-25 02:53:48', '2015-04-25 02:59:22'),
- (2, 12, 'Sumatera Utara', '2015-04-25 02:53:48', '2015-04-25 02:59:22'),
- (3, 13, 'Sumatera Barat', '2015-04-25 02:53:48', '2015-04-25 02:59:22'),
- (4, 14, 'Riau', '2015-04-25 02:53:48', '2015-04-25 02:59:22'),
- (5, 15, 'Jambi', '2015-04-25 02:53:48', '2015-04-25 02:59:22'),
- (6, 16, 'Sumatera Selatan', '2015-04-25 02:53:48', '2015-04-25 02:59:22'),
- (7, 17, 'Bengkulu', '2015-04-25 02:53:48', '2015-04-25 02:59:22'),
- (8, 18, 'Lampung', '2015-04-25 02:53:48', '2015-04-25 02:59:22'),
- (9, 19, 'Kepulauan Bangka Belitung', '2015-04-25 02:53:48', '2015-04-25 02:59:22'),
- (10, 21, 'Kepulauan Riau', '2015-04-25 02:53:48', '2015-04-25 02:59:22'),
- (11, 31, 'DKI Jakarta', '2015-04-25 02:53:48', '2015-04-25 02:59:22'),
- (12, 32, 'Jawa Barat', '2015-04-25 02:53:48', '2015-04-25 02:59:22'),
- (13, 33, 'Jawa Tengah', '2015-04-25 02:53:48', '2015-04-25 02:59:22'),
- (14, 34, 'DI Yogyakarta', '2015-04-25 02:53:48', '2015-04-25 02:59:22'),
- (15, 35, 'Jawa Timur', '2015-04-25 02:53:48', '2015-04-25 02:59:22'),
- (16, 36, 'Banten', '2015-04-25 02:53:48', '2015-04-25 02:59:22'),
- (17, 51, 'Bali', '2015-04-25 02:53:48', '2015-04-25 02:59:22'),
- (18, 52, 'Nusa Tenggara Barat', '2015-04-25 02:53:48', '2015-04-25 02:59:22'),
- (19, 53, 'Nusa Tenggara Timur', '2015-04-25 02:53:48', '2015-04-25 02:59:22'),
- (20, 61, 'Kalimantan Barat', '2015-04-25 02:53:48', '2015-04-25 02:59:22'),
- (21, 62, 'Kalimantan Tengah', '2015-04-25 02:53:48', '2015-04-25 02:59:22'),
- (22, 63, 'Kalimantan Selatan', '2015-04-25 02:53:48', '2015-04-25 02:59:22'),
- (23, 64, 'Kalimantan Timur', '2015-04-25 02:53:48', '2015-04-25 02:59:22'),
- (24, 65, 'Kalimantan Utara', '2015-04-25 02:53:48', '2015-04-25 02:59:22'),
- (25, 71, 'Sulawesi Utara', '2015-04-25 02:53:48', '2015-04-25 02:59:22'),
- (26, 72, 'Sulawesi Tengah', '2015-04-25 02:53:48', '2015-04-25 02:59:22'),
- (27, 73, 'Sulawesi Selatan', '2015-04-25 02:53:48', '2015-04-25 02:59:22'),
- (28, 74, 'Sulawesi Tenggara', '2015-04-25 02:53:48', '2015-04-25 02:59:22'),
- (29, 75, 'Gorontalo', '2015-04-25 02:53:48', '2015-04-25 02:59:22'),
- (30, 76, 'Sulawesi Barat', '2015-04-25 02:53:48', '2015-04-25 02:59:22'),
- (31, 81, 'Maluku', '2015-04-25 02:53:48', '2015-04-25 02:59:22'),
- (32, 82, 'Maluku Utara', '2015-04-25 02:53:48', '2015-04-25 02:59:22'),
- (33, 91, 'Papua Barat', '2015-04-25 02:53:48', '2015-04-25 02:59:22'),
- (34, 94, 'Papua', '2015-04-25 02:53:48', '2015-04-25 02:59:22');
Add Comment
Please, Sign In to add comment