g54101042

Dump Tabel Propinsi untuk MySQL

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