Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- phpMyAdmin SQL Dump
- -- version 3.4.5
- -- http://www.phpmyadmin.net
- --
- -- Host: localhost
- -- Generation Time: Jul 29, 2013 at 05:46 AM
- -- Server version: 5.5.16
- -- PHP Version: 5.3.8
- SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
- SET time_zone = "+00:00";
- -- --------------------------------------------------------
- --
- -- Table structure for table `provinsi`
- --
- CREATE TABLE IF NOT EXISTS `provinsi` (
- `prov_id` INT(11) NOT NULL AUTO_INCREMENT,
- `prov_name` VARCHAR(50) NOT NULL,
- `prov_detail` text NOT NULL,
- PRIMARY KEY (`prov_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=35 ;
- --
- -- Dumping data for table `provinsi`
- --
- INSERT INTO `provinsi` (`prov_id`, `prov_name`, `prov_detail`) VALUES
- (1, 'Kalimantan Utara', ''),
- (2, 'Aceh', ''),
- (3, 'Sumatera Utara', ''),
- (4, 'Sumatera Barat', ''),
- (5, 'Riau', ''),
- (6, 'Jambi', ''),
- (7, 'Sumatera Selatan', ''),
- (8, 'Bengkulu', ''),
- (9, 'Lampung', ''),
- (10, 'Kepulauan Bangka Belitung', ''),
- (11, 'Kepulauan Riau', ''),
- (12, 'Jakarta', ''),
- (13, 'Jawa Barat', ''),
- (14, 'Jawa Tengah', ''),
- (15, 'Yogyakarta', ''),
- (16, 'Jawa Timur', ''),
- (17, 'Banten', ''),
- (18, 'Bali', ''),
- (19, 'Nusa Tenggara Barat', ''),
- (20, 'Nusa Tenggara Timur', ''),
- (21, 'Kalimantan Barat', ''),
- (22, 'Kalimantan Tengah', ''),
- (23, 'Kalimantan Selatan', ''),
- (24, 'Kalimantan Timur', ''),
- (25, 'Sulawesi Utara', ''),
- (26, 'Sulawesi Tengah', ''),
- (27, 'Sulawesi Selatan', ''),
- (28, 'Sulawesi Tenggara', ''),
- (29, 'Gorontalo', ''),
- (30, 'Sulawesi Barat', ''),
- (31, 'Maluku', ''),
- (32, 'Maluku Utara', ''),
- (33, 'Papua Barat', ''),
- (34, 'Papua', '');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement