Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*
- Navicat MySQL Data Transfer
- Source Server : localhost
- Source Server Version : 50137
- Source Host : localhost:3306
- Source Database : taq
- Target Server Type : MYSQL
- Target Server Version : 50137
- File Encoding : 65001
- Date: 2011-02-19 21:13:02
- */
- SET FOREIGN_KEY_CHECKS=0;
- -- ----------------------------
- -- Table structure for `hotel`
- -- ----------------------------
- DROP TABLE IF EXISTS `hotel`;
- CREATE TABLE `hotel` (
- `id_hotel` int(11) NOT NULL AUTO_INCREMENT,
- `nama_hotel` char(100) NOT NULL,
- `alamat_hotel` char(100) NOT NULL,
- `daerah_hotel` char(30) NOT NULL,
- `id_daerah_hotel` char(30) NOT NULL,
- `jenis_hotel` char(30) NOT NULL,
- `harga_hotel` varchar(11) NOT NULL,
- `daya_tampung_hotel` int(11) NOT NULL,
- `ket_hotel` char(100) NOT NULL,
- `foto_hotel` varchar(100) NOT NULL,
- PRIMARY KEY (`id_hotel`)
- ) ENGINE=MyISAM AUTO_INCREMENT=50 DEFAULT CHARSET=latin1;
- -- ----------------------------
- -- Records of hotel
- -- ----------------------------
- INSERT INTO hotel VALUES ('1', 'ARJOSARI', 'Jl. Raden intan no 49 malang', 'blimbing', 'm03', 'melati', '150000', '50', '', '');
- INSERT INTO hotel VALUES ('5', 'BAHAGIA', 'Jl. Letjen S Parman 45 Malang', 'klojen', 'm02', 'melati', '150000', '50', '', '');
- INSERT INTO hotel VALUES ('6', 'BINTANG', 'Jl. Hamid Rusdi No. 97 Malang', 'klojen', 'm02', 'melati', '150000', '50', '', '');
- INSERT INTO hotel VALUES ('2', 'ALOHA', 'Jl. Gajah Mada 7', 'lowokwaru', 'm01', 'melati', '150000', '50', '', '');
- INSERT INTO hotel VALUES ('7', 'CAMELIA', 'Jl. Dr. Cipto 24 Malang', 'blimbing', 'm03', 'melati', '150000', '50', '', '');
- INSERT INTO hotel VALUES ('8', 'EMMA MUSTIKA SARI', 'Jl. Laks. Martadinata 18-24 Malang', 'blimbing', 'm03', 'melati', '150000', '50', '', '');
- INSERT INTO hotel VALUES ('3', 'ARJUNO', 'Jl. B. S. Riadi 122 Malang', 'klojen', 'm02', 'melati', '150000', '50', '', '');
- INSERT INTO hotel VALUES ('9', 'GAJAHMADA GRAHA', 'Jl. Dr. Cipto 17 Malang', 'klojen', 'm02', 'melati', '300000', '125', '', '');
- INSERT INTO hotel VALUES ('10', 'GRAHA CAKRA', 'Jl. Cerme 16 Malang', 'klojen', 'm02', 'bintang 3', '300000', '125', '', '');
- INSERT INTO hotel VALUES ('4', 'ARMI', 'Jl. Kaliurang 63 Malang', 'klojen', 'm02', 'bintang 3', '150000', '50', '', '');
- INSERT INTO hotel VALUES ('11', 'GRAND PALACE', 'Jl. Ade Irma Suryani 23 Malang', 'klojen', 'm02', 'bintang 3', '300000', '125', '', '');
- INSERT INTO hotel VALUES ('12', 'GRAHA DEWATA AGUNG', 'Jl. P. Suroso no 10', 'blimbing', 'm03', 'melati', '150000', '50', '', '');
- INSERT INTO hotel VALUES ('13', 'H. S. KASABRA', 'Jl. Gresik No. 2 Malang', 'lowokwaru', 'm01', 'melati', '150000', '50', '', '');
- INSERT INTO hotel VALUES ('14', 'HELIOS', 'Jl. Pattimura 37 Malang', 'klojen', 'm02', 'melati', '150000', '50', '', '');
- INSERT INTO hotel VALUES ('15', 'KAHURIPAN', 'Jl. Kahuripan 11 - 15 Malang', 'klojen', 'm02', 'melati', '150000', '50', '', '');
- INSERT INTO hotel VALUES ('16', 'KALPATARU', 'Jl. Kalpataru 41 Malang', 'lowokwaru', 'm01', 'melati', '150000', '50', '', '');
- INSERT INTO hotel VALUES ('17', 'KARTIKA GRAHA', 'Jl. Jakgung Suprapto 17 Malang', 'blimbing', 'm03', 'bintang 1', '200000', '75', '', '');
- INSERT INTO hotel VALUES ('18', 'KARTIKA KUSUMA', 'Jl.Kahuripan 12 Malang', 'klojen', 'm02', 'melati', '150000', '50', '', '');
- INSERT INTO hotel VALUES ('19', 'MALANG', 'Jl. Z. Arifin 85 Malang', 'klojen', 'm02', 'melati', '150000', '50', '', '');
- INSERT INTO hotel VALUES ('20', 'MALINDA', 'Jl. Zainul Arifin 37 - 39 Malang', 'klojen', 'm02', 'melati', '150000', '50', '', '');
- INSERT INTO hotel VALUES ('21', 'MANDALA PURI', 'Jl. PB. Sudirman 81 Malang', 'klojen', 'm02', 'melati', '150000', '50', '', '');
- INSERT INTO hotel VALUES ('22', 'MANSION', 'Jl. Martadinata 9 Malang', 'klojen', 'm02', 'melati', '150000', '50', '', '');
- INSERT INTO hotel VALUES ('23', 'MEGAWATI', 'Jl. Pang. Sudirman 99 Malang', 'klojen', 'm02', 'melati', '150000', '50', '', '');
- INSERT INTO hotel VALUES ('24', 'MENARA', 'Jl. Pajajaran 5 Malang', 'klojen', 'm02', 'melati', '150000', '50', '', '');
- INSERT INTO hotel VALUES ('25', 'MONTANA I', 'Jl. Kahuripan 9 Malang', 'klojen', 'm02', 'bintang 2', '250000', '100', '', '');
- INSERT INTO hotel VALUES ('26', 'MONTANA II', 'Jl. Candi Panggung 2 Malang', 'lowokwaru', 'm01', 'melati', '150000', '50', '', '');
- INSERT INTO hotel VALUES ('27', 'MUTIARA', 'Jl. Jagung Suprapto', 'klojen', 'm02', 'melati', '150000', '50', '', '');
- INSERT INTO hotel VALUES ('28', 'NUGRAHA', 'Jl. Panji Suroso 16 Malang', 'blimbing', 'm03', 'melati', '150000', '50', '', '');
- INSERT INTO hotel VALUES ('29', 'PAJAJARAN PARK', 'Jl. Letjend. Sutoyo 178 Malang', 'klojen', 'm02', 'melati', '150000', '50', '', '');
- INSERT INTO hotel VALUES ('30', 'PALEM II', 'Jl. MH. Thamrin 15 Malang', 'klojen', 'm02', 'melati', '150000', '50', '', '');
- INSERT INTO hotel VALUES ('31', 'PELANGI I', 'Jl. Merdeka Selatan 3 Malang', 'klojen', 'm02', 'bintang 1', '200000', '75', '', '');
- INSERT INTO hotel VALUES ('32', 'PELANGI II', 'Jl. Gajayana Malang', 'lowokwaru', 'm01', 'melati', '150000', '50', '', '');
- INSERT INTO hotel VALUES ('33', 'PENGINAPAN TLOGOMAS', 'Jl. Tlogomas Malang', 'lowokwaru', 'm01', 'melati', '150000', '50', '', '');
- INSERT INTO hotel VALUES ('34', 'PINUS', 'Jl. S.P. Sudarmo Malang', 'blimbing', 'm03', 'melati', '150000', '50', '', '');
- INSERT INTO hotel VALUES ('35', 'REGENT\'S PARK', 'Jl. Jakgung Suprapto 12 - 17 Malang', 'klojen', 'm02', 'bintang 3', '300000', '125', '', '');
- INSERT INTO hotel VALUES ('36', 'RICHE', 'Jl. Basuki Rachmad 1', 'klojen', 'm02', 'bintang 1', '200000', '75', '', '');
- INSERT INTO hotel VALUES ('37', 'ROYAL INN', 'Jl. Tenaga Baru 1/5 Malang', 'blimbing', 'm03', 'melati', '150000', '50', '', '');
- INSERT INTO hotel VALUES ('38', 'SANTIKA', 'Jl. Letjen Sutoyo No. 79 Malang 65141', 'lowokwaru', 'm01', 'bintang 4', '350000', '150', '', '');
- INSERT INTO hotel VALUES ('39', 'SANTOSO', 'Jl. K.H. Agus Salim 24 Malang', 'klojen', 'm02', 'melati', '150000', '50', '', '');
- INSERT INTO hotel VALUES ('40', 'SERAYU', 'Jl. Serayu 3 Malang', 'blimbing', 'm03', 'melati', '150000', '50', '', '');
- INSERT INTO hotel VALUES ('41', 'SETIA BUDI', 'Jl. Pattimura 71 A Malang', 'klojen', 'm02', 'melati', '150000', '50', '', '');
- INSERT INTO hotel VALUES ('42', 'SIMPANG TIGA', 'Jl. Margono 56 Malang', 'sukun', 'm05', 'melati', '150000', '50', '', '');
- INSERT INTO hotel VALUES ('43', 'SPLENDID INN', 'Jl. Majapahit 2 - 4 Malang', 'klojen', 'm02', 'bintang 1', '200000', '75', '', '');
- INSERT INTO hotel VALUES ('44', 'TIRTO', 'Jl. Simp. Panji Suroso Kav 133 Malang', 'blimbing', 'm03', 'melati', '150000', '50', '', '');
- INSERT INTO hotel VALUES ('45', 'TOSARI', 'Jl. KH. A. Dahlan 31 Malang', 'klojen', 'm02', 'melati', '150000', '50', '', '');
- INSERT INTO hotel VALUES ('46', 'TRIO INDAH', 'Jl. Brigjen Slamet Riadi No. 2-4 Malang', 'klojen', 'm02', 'melati', '150000', '50', '', '');
- INSERT INTO hotel VALUES ('47', 'TRIO INDAH II', 'Jl. JA. Suprapto Malang', 'klojen', 'm02', 'melati', '150000', '50', '', '');
- INSERT INTO hotel VALUES ('48', 'TUGU PARK', 'Jl. Tugu No. 3 Malang', 'klojen', 'm02', 'bintang 1', '200000', '75', '', '');
- INSERT INTO hotel VALUES ('49', 'WILIS INDAH', 'Jl. Dr. Wahidin 40 Malang', 'klojen', 'm02', 'melati', '150000', '50', '', '');
- -- ----------------------------
- -- Table structure for `hotel_bobot`
- -- ----------------------------
- DROP TABLE IF EXISTS `hotel_bobot`;
- CREATE TABLE `hotel_bobot` (
- `id_hotel` int(11) NOT NULL AUTO_INCREMENT,
- `bobot_jenis_hotel` int(11) NOT NULL,
- `bobot_harga_hotel` int(11) NOT NULL,
- `bobot_fasilitas_hotel` int(11) NOT NULL,
- `bobot_daya_tampung_hotel` int(11) NOT NULL,
- PRIMARY KEY (`id_hotel`)
- ) ENGINE=MyISAM AUTO_INCREMENT=50 DEFAULT CHARSET=latin1;
- -- ----------------------------
- -- Records of hotel_bobot
- -- ----------------------------
- INSERT INTO hotel_bobot VALUES ('1', '1', '1', '1', '1');
- INSERT INTO hotel_bobot VALUES ('2', '1', '1', '2', '2');
- INSERT INTO hotel_bobot VALUES ('3', '1', '1', '1', '2');
- INSERT INTO hotel_bobot VALUES ('4', '1', '1', '2', '2');
- INSERT INTO hotel_bobot VALUES ('5', '1', '1', '1', '1');
- INSERT INTO hotel_bobot VALUES ('6', '1', '1', '1', '1');
- INSERT INTO hotel_bobot VALUES ('7', '1', '1', '1', '2');
- INSERT INTO hotel_bobot VALUES ('8', '1', '1', '1', '1');
- INSERT INTO hotel_bobot VALUES ('9', '4', '3', '3', '3');
- INSERT INTO hotel_bobot VALUES ('10', '4', '3', '3', '3');
- INSERT INTO hotel_bobot VALUES ('11', '4', '3', '3', '3');
- INSERT INTO hotel_bobot VALUES ('12', '1', '1', '1', '1');
- INSERT INTO hotel_bobot VALUES ('13', '1', '1', '1', '1');
- INSERT INTO hotel_bobot VALUES ('14', '1', '1', '2', '2');
- INSERT INTO hotel_bobot VALUES ('15', '1', '1', '1', '1');
- INSERT INTO hotel_bobot VALUES ('16', '1', '1', '1', '1');
- INSERT INTO hotel_bobot VALUES ('17', '2', '2', '2', '2');
- INSERT INTO hotel_bobot VALUES ('18', '1', '1', '2', '2');
- INSERT INTO hotel_bobot VALUES ('19', '1', '1', '1', '1');
- INSERT INTO hotel_bobot VALUES ('20', '1', '1', '2', '1');
- INSERT INTO hotel_bobot VALUES ('21', '1', '1', '2', '2');
- INSERT INTO hotel_bobot VALUES ('22', '1', '1', '1', '1');
- INSERT INTO hotel_bobot VALUES ('23', '1', '1', '1', '1');
- INSERT INTO hotel_bobot VALUES ('24', '1', '1', '1', '1');
- INSERT INTO hotel_bobot VALUES ('25', '3', '2', '2', '2');
- INSERT INTO hotel_bobot VALUES ('26', '1', '1', '2', '2');
- INSERT INTO hotel_bobot VALUES ('27', '1', '1', '1', '1');
- INSERT INTO hotel_bobot VALUES ('28', '1', '1', '1', '1');
- INSERT INTO hotel_bobot VALUES ('29', '1', '1', '2', '2');
- INSERT INTO hotel_bobot VALUES ('30', '1', '1', '1', '2');
- INSERT INTO hotel_bobot VALUES ('31', '2', '2', '2', '2');
- INSERT INTO hotel_bobot VALUES ('32', '1', '1', '2', '2');
- INSERT INTO hotel_bobot VALUES ('33', '1', '1', '2', '1');
- INSERT INTO hotel_bobot VALUES ('34', '1', '1', '1', '2');
- INSERT INTO hotel_bobot VALUES ('35', '4', '3', '3', '3');
- INSERT INTO hotel_bobot VALUES ('36', '2', '2', '2', '2');
- INSERT INTO hotel_bobot VALUES ('37', '1', '1', '2', '2');
- INSERT INTO hotel_bobot VALUES ('38', '5', '3', '3', '3');
- INSERT INTO hotel_bobot VALUES ('39', '1', '1', '1', '1');
- INSERT INTO hotel_bobot VALUES ('40', '1', '1', '1', '1');
- INSERT INTO hotel_bobot VALUES ('41', '1', '1', '1', '1');
- INSERT INTO hotel_bobot VALUES ('42', '1', '1', '1', '1');
- INSERT INTO hotel_bobot VALUES ('43', '2', '2', '2', '2');
- INSERT INTO hotel_bobot VALUES ('44', '1', '1', '1', '1');
- INSERT INTO hotel_bobot VALUES ('45', '1', '1', '1', '1');
- INSERT INTO hotel_bobot VALUES ('46', '1', '1', '2', '2');
- INSERT INTO hotel_bobot VALUES ('47', '1', '1', '2', '2');
- INSERT INTO hotel_bobot VALUES ('48', '2', '2', '2', '2');
- INSERT INTO hotel_bobot VALUES ('49', '1', '1', '1', '1');
- -- ----------------------------
- -- Table structure for `oleh`
- -- ----------------------------
- DROP TABLE IF EXISTS `oleh`;
- CREATE TABLE `oleh` (
- `id_oleh` int(11) NOT NULL AUTO_INCREMENT,
- `nama_oleh` char(100) NOT NULL,
- `alamat_oleh` char(100) NOT NULL,
- `daerah_oleh` char(30) NOT NULL,
- `id_daerah_oleh` char(30) NOT NULL,
- `jenis_oleh` char(30) NOT NULL,
- `harga_oleh` int(11) NOT NULL,
- `ket_oleh` char(100) NOT NULL,
- `foto_oleh` int(11) NOT NULL,
- PRIMARY KEY (`id_oleh`)
- ) ENGINE=MyISAM AUTO_INCREMENT=53 DEFAULT CHARSET=latin1;
- -- ----------------------------
- -- Records of oleh
- -- ----------------------------
- INSERT INTO oleh VALUES ('1', 'Nandra', 'Jl.Bale Arjosari', 'Blimbing', 'm03', 'Rotan', '25000', '', '0');
- INSERT INTO oleh VALUES ('2', 'Prima Jaya', 'Jl.Bale Arjosari', 'Blimbing', 'm03', 'Rotan', '19000', '', '0');
- INSERT INTO oleh VALUES ('3', 'Sakura Indah', 'Jl.Bale Arjosari', 'Blimbing', 'm03', 'Rotan', '21000', '', '0');
- INSERT INTO oleh VALUES ('4', 'UD.Puri Agung', 'Jl.Bale Arjosari', 'Blimbing', 'm03', 'Rotan', '23000', '', '0');
- INSERT INTO oleh VALUES ('5', 'Antika Rotan', 'Jl.Bale Arjosari', 'Blimbing', 'm03', 'Rotan', '27000', '', '0');
- INSERT INTO oleh VALUES ('6', 'Bening Jaya', 'Jl.Bale Arjosari', 'Blimbing', 'm03', 'Rotan', '30000', '', '0');
- INSERT INTO oleh VALUES ('7', 'Bukan Pasadena', 'Jl.Bale Arjosari', 'Blimbing', 'm03', 'Rotan', '22000', '', '0');
- INSERT INTO oleh VALUES ('8', 'UPK \"Ken Arok\"', 'Jl. Ahmad Yani Utara 2', 'Blimbing', 'm03', 'Kripik', '8000', '', '0');
- INSERT INTO oleh VALUES ('9', 'Indo Argo', 'Jl.A.yani 77', 'Blimbing', 'm03', 'Kripik', '7000', '', '0');
- INSERT INTO oleh VALUES ('10', 'Goldia 1', 'Jl.Galunggung', 'klojen', 'm02', 'Kripik', '6000', '', '0');
- INSERT INTO oleh VALUES ('11', 'Goldia 2', 'Jl.Sumber Sari', 'Lowokwaru', 'm01', 'Kripik', '6000', '', '0');
- INSERT INTO oleh VALUES ('12', 'Caprina', 'Jl.Raya Tlogo Mas', 'Lowokwaru', 'm01', 'Kripik', '8000', '', '0');
- INSERT INTO oleh VALUES ('13', 'Denis Souvenier', 'Jl. MT.Haryono Malang 340', 'Lowokwaru', 'm01', 'Keramik', '2000', '', '0');
- INSERT INTO oleh VALUES ('14', 'Firman', 'Jl. MT.Haryono Malang 339', 'Lowokwaru', 'm01', 'Keramik', '1500', '', '0');
- INSERT INTO oleh VALUES ('15', 'Pak Isma', 'Jl. MT.Haryono Malang 474', 'Lowokwaru', 'm01', 'Keramik', '3000', '', '0');
- INSERT INTO oleh VALUES ('16', 'Ibu Riyanti', 'Jl. MT.Haryono Malang 472', 'Lowokwaru', 'm01', 'Keramik', '2100', '', '0');
- INSERT INTO oleh VALUES ('17', 'Ibu Soeharto', 'Jl. MT.Haryono Malang 461', 'Lowokwaru', 'm01', 'Keramik', '2200', '', '0');
- INSERT INTO oleh VALUES ('18', 'Family', 'Jl. MT.Haryono Malang 42', 'Lowokwaru', 'm01', 'Keramik', '1900', '', '0');
- INSERT INTO oleh VALUES ('19', 'C J D W', 'Jl. MT.Haryono Malang 459', 'Lowokwaru', 'm01', 'Keramik', '1800', '', '0');
- INSERT INTO oleh VALUES ('20', 'Harapan Jaya', 'Jl. Mayjend. Panjaitan Malang', 'klojen', 'm02', 'Gerabah', '35000', '', '0');
- INSERT INTO oleh VALUES ('21', 'Al Faris', 'Jl. Mayjend. Panjaitan Malang 167', 'klojen', 'm02', 'Gerabah', '37000', '', '0');
- INSERT INTO oleh VALUES ('22', 'Sumber Rezeki', 'Jl. Mayjend. Panjaitan Malang', 'klojen', 'm02', 'Gerabah', '36000', '', '0');
- INSERT INTO oleh VALUES ('23', 'Trisensa', 'Jl. Mayjend. Panjaitan Malang no 66', 'klojen', 'm02', 'Keramik', '2200', '', '0');
- INSERT INTO oleh VALUES ('24', 'Pelangi Sari', 'Jl.Soekarno Hatta 29 c', 'Lowokwaru', 'm01', 'Keripik', '9000', '', '0');
- INSERT INTO oleh VALUES ('25', 'Pao Telay', 'Jl.Terusan Borobudur 80', 'Lowokwaru', 'm01', 'Keripik', '8500', '', '0');
- INSERT INTO oleh VALUES ('26', 'Sidik Putra', 'Jl.Piranha Atas 166', 'Lowokwaru', 'm01', 'Mebel', '200000', '', '0');
- INSERT INTO oleh VALUES ('27', 'Juli', 'Jl.Trs.Ikan Paus 3', 'Lowokwaru', 'm01', 'Mebel', '250000', '', '0');
- INSERT INTO oleh VALUES ('28', 'Manunggal', 'Jl.Ikan Piranha Atas 171', 'Lowokwaru', 'm01', 'Mebel', '300000', '', '0');
- INSERT INTO oleh VALUES ('29', 'Sumber Aram', 'Jl.Ikan Piranha Atas 182', 'Lowokwaru', 'm01', 'Mebel', '270000', '', '0');
- INSERT INTO oleh VALUES ('30', 'Pram\'bos', 'Jl.Ikan Piranha Atas 174', 'Lowokwaru', 'm01', 'Mebel', '280000', '', '0');
- INSERT INTO oleh VALUES ('31', 'Win Mebel', 'Jl.Ikan Piranha Atas 172', 'Lowokwaru', 'm01', 'Mebel', '310000', '', '0');
- INSERT INTO oleh VALUES ('32', 'Mia Mebel', 'Jl.Ikan Piranha Atas 167', 'Lowokwaru', 'm01', 'Mebel', '290000', '', '0');
- INSERT INTO oleh VALUES ('33', 'Arofah', 'Jl.Ikan Piranha Atas', 'Lowokwaru', 'm01', 'Mebel', '240000', '', '0');
- INSERT INTO oleh VALUES ('34', 'Jati Bersama', 'Jl.Ikan Piranha Atas 165', 'Lowokwaru', 'm01', 'Mebel', '230000', '', '0');
- INSERT INTO oleh VALUES ('35', 'Jati Bersama', 'Jl.Ikan Piranha Atas 172', 'Lowokwaru', 'm01', 'Mebel', '300000', '', '0');
- INSERT INTO oleh VALUES ('36', 'Erlangga Onix', 'Jl.Ikan Piranha Atas 163', 'Lowokwaru', 'm01', 'Mebel', '320000', '', '0');
- INSERT INTO oleh VALUES ('37', 'Barokah', 'Jl.Ikan Piranha Atas 160', 'Lowokwaru', 'm01', 'Mebel', '230000', '', '0');
- INSERT INTO oleh VALUES ('38', 'Usah Jati', 'Jl.Ikan Piranha Atas 158', 'Lowokwaru', 'm01', 'Mebel', '280000', '', '0');
- INSERT INTO oleh VALUES ('39', 'Muncul Jaya', 'Jl.Ikan Piranha Atas 136', 'Lowokwaru', 'm01', 'Mebel', '310000', '', '0');
- INSERT INTO oleh VALUES ('40', 'Pandowo', 'Jl.Ikan Piranha Atas 142', 'Lowokwaru', 'm01', 'Mebel', '250000', '', '0');
- INSERT INTO oleh VALUES ('41', 'Srikandi', 'Jl.Ikan Piranha Atas 14', 'Lowokwaru', 'm01', 'Mebel', '280000', '', '0');
- INSERT INTO oleh VALUES ('42', 'Bima Sakti', 'Jl.Ikan Piranha Atas 684', 'Lowokwaru', 'm01', 'Mebel', '190000', '', '0');
- INSERT INTO oleh VALUES ('43', 'Gajah Santoso', 'Jl.Tumenggung Suryo 131 E', 'Blimbing', 'm03', 'Keripik', '8200', '', '0');
- INSERT INTO oleh VALUES ('44', 'Dermaga', 'Jl.R.T Suryo 86 Kav E', 'Blimbing', 'm03', 'Keripik', '8000', '', '0');
- INSERT INTO oleh VALUES ('45', 'Burung Swari', 'Jl.Sanan 30', 'Blimbing', 'm03', 'Keripik', '8500', '', '0');
- INSERT INTO oleh VALUES ('46', 'Lancar Jaya', 'Jl.Sanan 18', 'Blimbing', 'm03', 'Keripik', '8000', '', '0');
- INSERT INTO oleh VALUES ('47', 'Karina', 'Jl.Sanan 24', 'Blimbing', 'm03', 'Keripik', '9000', '', '0');
- INSERT INTO oleh VALUES ('48', 'Central', 'Jl.R.T Suryo 31', 'Blimbing', 'm03', 'Keripik', '5000', '', '0');
- INSERT INTO oleh VALUES ('49', 'Rahayu', 'Jl.R.T Suryo', 'Blimbing', 'm03', 'Keripik', '7500', '', '0');
- INSERT INTO oleh VALUES ('50', 'Intan Jaya Abadi', 'Jl.R.T Suryo 84', 'Blimbing', 'm03', 'Keripik', '6000', '', '0');
- INSERT INTO oleh VALUES ('51', 'Andhika', 'Jl.R.T Suryo', 'Blimbing', 'm03', 'Keripik', '5000', '', '0');
- INSERT INTO oleh VALUES ('52', 'Sentra Industri Batu Onyx', 'Jl. Tlogomas Malang', 'Lowokwaru', 'm01', 'Batu Onyx', '50000', '', '0');
- -- ----------------------------
- -- Table structure for `oleh_bobot`
- -- ----------------------------
- DROP TABLE IF EXISTS `oleh_bobot`;
- CREATE TABLE `oleh_bobot` (
- `id_oleh` int(11) NOT NULL AUTO_INCREMENT,
- `bobot_jenis_oleh` int(11) NOT NULL,
- `bobot_harga_oleh` int(11) NOT NULL,
- `bobot_fasilitas_oleh` int(11) NOT NULL,
- PRIMARY KEY (`id_oleh`)
- ) ENGINE=MyISAM AUTO_INCREMENT=53 DEFAULT CHARSET=latin1;
- -- ----------------------------
- -- Records of oleh_bobot
- -- ----------------------------
- INSERT INTO oleh_bobot VALUES ('1', '3', '2', '1');
- INSERT INTO oleh_bobot VALUES ('2', '3', '2', '1');
- INSERT INTO oleh_bobot VALUES ('3', '3', '2', '1');
- INSERT INTO oleh_bobot VALUES ('4', '3', '2', '1');
- INSERT INTO oleh_bobot VALUES ('5', '3', '2', '1');
- INSERT INTO oleh_bobot VALUES ('6', '3', '2', '1');
- INSERT INTO oleh_bobot VALUES ('7', '3', '2', '1');
- INSERT INTO oleh_bobot VALUES ('8', '2', '1', '1');
- INSERT INTO oleh_bobot VALUES ('9', '2', '1', '1');
- INSERT INTO oleh_bobot VALUES ('10', '2', '1', '1');
- INSERT INTO oleh_bobot VALUES ('11', '2', '1', '1');
- INSERT INTO oleh_bobot VALUES ('12', '2', '1', '1');
- INSERT INTO oleh_bobot VALUES ('13', '1', '1', '2');
- INSERT INTO oleh_bobot VALUES ('14', '1', '1', '2');
- INSERT INTO oleh_bobot VALUES ('15', '1', '1', '2');
- INSERT INTO oleh_bobot VALUES ('16', '1', '1', '2');
- INSERT INTO oleh_bobot VALUES ('17', '1', '1', '2');
- INSERT INTO oleh_bobot VALUES ('18', '1', '1', '2');
- INSERT INTO oleh_bobot VALUES ('19', '1', '1', '2');
- INSERT INTO oleh_bobot VALUES ('20', '4', '2', '2');
- INSERT INTO oleh_bobot VALUES ('21', '4', '2', '2');
- INSERT INTO oleh_bobot VALUES ('22', '4', '2', '2');
- INSERT INTO oleh_bobot VALUES ('23', '1', '1', '3');
- INSERT INTO oleh_bobot VALUES ('24', '2', '1', '2');
- INSERT INTO oleh_bobot VALUES ('25', '2', '1', '2');
- INSERT INTO oleh_bobot VALUES ('26', '6', '3', '3');
- INSERT INTO oleh_bobot VALUES ('27', '6', '3', '3');
- INSERT INTO oleh_bobot VALUES ('28', '6', '3', '3');
- INSERT INTO oleh_bobot VALUES ('29', '6', '3', '3');
- INSERT INTO oleh_bobot VALUES ('30', '6', '3', '3');
- INSERT INTO oleh_bobot VALUES ('31', '6', '3', '3');
- INSERT INTO oleh_bobot VALUES ('32', '6', '3', '3');
- INSERT INTO oleh_bobot VALUES ('33', '6', '3', '3');
- INSERT INTO oleh_bobot VALUES ('34', '6', '3', '3');
- INSERT INTO oleh_bobot VALUES ('35', '6', '3', '3');
- INSERT INTO oleh_bobot VALUES ('36', '6', '3', '3');
- INSERT INTO oleh_bobot VALUES ('37', '6', '3', '3');
- INSERT INTO oleh_bobot VALUES ('38', '6', '3', '3');
- INSERT INTO oleh_bobot VALUES ('39', '6', '3', '3');
- INSERT INTO oleh_bobot VALUES ('40', '6', '3', '3');
- INSERT INTO oleh_bobot VALUES ('41', '6', '3', '3');
- INSERT INTO oleh_bobot VALUES ('42', '6', '3', '3');
- INSERT INTO oleh_bobot VALUES ('43', '2', '1', '3');
- INSERT INTO oleh_bobot VALUES ('44', '2', '1', '3');
- INSERT INTO oleh_bobot VALUES ('45', '2', '1', '3');
- INSERT INTO oleh_bobot VALUES ('46', '2', '1', '3');
- INSERT INTO oleh_bobot VALUES ('47', '2', '1', '3');
- INSERT INTO oleh_bobot VALUES ('48', '2', '1', '3');
- INSERT INTO oleh_bobot VALUES ('49', '2', '1', '3');
- INSERT INTO oleh_bobot VALUES ('50', '2', '1', '3');
- INSERT INTO oleh_bobot VALUES ('51', '2', '1', '3');
- INSERT INTO oleh_bobot VALUES ('52', '5', '3', '3');
- -- ----------------------------
- -- Table structure for `rm`
- -- ----------------------------
- DROP TABLE IF EXISTS `rm`;
- CREATE TABLE `rm` (
- `id_rm` int(11) NOT NULL AUTO_INCREMENT,
- `nama_rm` char(100) NOT NULL,
- `alamat_rm` char(100) NOT NULL,
- `daerah_rm` char(30) NOT NULL,
- `id_daerah_rm` char(30) NOT NULL,
- `jenis_rm` char(30) NOT NULL,
- `harga_rm` int(11) NOT NULL,
- `daya_tampung_rm` int(11) NOT NULL,
- `ket_rm` char(100) NOT NULL,
- `foto_rm` int(11) NOT NULL,
- PRIMARY KEY (`id_rm`)
- ) ENGINE=MyISAM AUTO_INCREMENT=45 DEFAULT CHARSET=latin1;
- -- ----------------------------
- -- Records of rm
- -- ----------------------------
- INSERT INTO rm VALUES ('1', 'Kedai 27 Sarangan', 'Jl. Sarangan 27', 'lowokwaru', 'm01', 'nasi', '9000', '2', '', '0');
- INSERT INTO rm VALUES ('2', 'warung pojok', 'jl. borobudur', 'blimbing', 'm03', 'nasi', '7000', '3', '', '0');
- INSERT INTO rm VALUES ('3', 'warung nasi bu gito', 'jl. soekarno hatta ruko II DR-13', 'lowokwaru', 'm01', 'nasi', '4000', '2', '', '0');
- INSERT INTO rm VALUES ('4', 'depot nasi goreng khas malang', 'jl. soekarno hatta 9', 'lowokwaru', 'm01', 'nasi', '5000', '1', '', '0');
- INSERT INTO rm VALUES ('5', 'ayam lepas', 'Jl. MT Haryono 193 B', 'lowokwaru', 'm01', 'ayam', '4000', '1', '', '0');
- INSERT INTO rm VALUES ('6', 'warung bu kris', 'Ruko Griya Shanta, Jl. Soekarno Hatta MP-58', 'lowokwaru', 'm01', 'ayam', '8000', '2', '', '0');
- INSERT INTO rm VALUES ('7', 'ayam goreng pemuda', 'jl. semeru', 'klojen', 'm02', 'ayam', '9000', '3', '', '0');
- INSERT INTO rm VALUES ('8', 'ayam goreng pak maning', 'jl. soekarno hatta 94', 'lowokwaru', 'm01', 'ayam', '10000', '3', '', '0');
- INSERT INTO rm VALUES ('9', 'rumah makan ringin asri', 'jl. soekarno hatta 45', 'lowokwaru', 'm01', 'ayam', '6000', '3', '', '0');
- INSERT INTO rm VALUES ('10', 'warung lesehan yogyakarta', 'jl. Kendalsari Barat no 8', 'lowokwaru', 'm01', 'ayam', '9000', '3', '', '0');
- INSERT INTO rm VALUES ('11', 'prambanan sari', 'Jl. Bromo 37 A', 'klojen', 'm02', 'ayam', '9000', '3', '', '0');
- INSERT INTO rm VALUES ('12', 'wong solo', 'jl. Arjuno', 'klojen', 'm02', 'ayam', '12000', '3', '', '0');
- INSERT INTO rm VALUES ('13', 'bebek super indonesia', 'Jl.Soekarno Hatta kav A.2', 'blimbing', 'm03', 'bebek', '12000', '2', '', '0');
- INSERT INTO rm VALUES ('14', 'bebek mercon', 'Jl. Soekarno Hatta Ruko griya shanta MP/48', 'lowokwaru', 'm01', 'bebek', '17500', '2', '', '0');
- INSERT INTO rm VALUES ('15', 'lesehan bambu', 'Jl. Bendungan Sigura-gura', 'lowokwaru', 'm01', 'ikan', '6000', '2', '', '0');
- INSERT INTO rm VALUES ('16', 'ikan bakar cianjur', 'Jl. Simpang balapan', 'klojen', 'm02', 'ikan', '9000', '3', '', '0');
- INSERT INTO rm VALUES ('17', 'ikan segar sutra', 'Jl. MT Haryono 16', 'lowokwaru', 'm01', 'ikan', '9000', '2', '', '0');
- INSERT INTO rm VALUES ('18', 'raja-raja', 'jl. Galunggung 48 A', 'klojen', 'm02', 'ikan', '15000', '2', '', '0');
- INSERT INTO rm VALUES ('19', 'ikan segar galunggung', 'jl. galunggung', 'klojen', 'm02', 'ikan', '15000', '2', '', '0');
- INSERT INTO rm VALUES ('20', 'saiyo sakato', 'Jl. MT Haryono 194 Kav B', 'lowokwaru', 'm01', 'padang', '7000', '1', '', '0');
- INSERT INTO rm VALUES ('21', 'ampera goyang lidah', 'Jl. MT Haryono 166', 'lowokwaru', 'm01', 'padang', '7000', '1', '', '0');
- INSERT INTO rm VALUES ('22', 'rumah makan pak haji', 'Jl. MT Haryono 209', 'lowokwaru', 'm01', 'soto', '5000', '1', '', '0');
- INSERT INTO rm VALUES ('23', 'bakso damas', 'Jl. MT Haryono 11', 'lowokwaru', 'm01', 'bakso', '6000', '1', '', '0');
- INSERT INTO rm VALUES ('24', 'bakso bakar pahlawan trip', 'Jl. Pahlawan Trip', 'klojen', 'm02', 'bakso', '6000', '3', '', '0');
- INSERT INTO rm VALUES ('25', 'bakso gun', 'jl. kawi atas 41', 'klojen', 'm02', 'bakso', '6000', '2', '', '0');
- INSERT INTO rm VALUES ('26', 'Bakso Solo Iga Suhat', 'Jl. Soekarno Hatta Ruko GSE. MP 39', 'lowokwaru', 'm01', 'bakso', '6000', '2', '', '0');
- INSERT INTO rm VALUES ('27', 'KFC', 'jl. kawi', 'klojen', 'm02', 'cepat saji', '12000', '3', '', '0');
- INSERT INTO rm VALUES ('28', 'pizza hut', 'jl. semeru', 'klojen', 'm02', 'cepat saji', '11000', '3', '', '0');
- INSERT INTO rm VALUES ('29', 'McD Basuki Rachmad', 'jl. basuki rachmad', 'klojen', 'm02', 'cepat saji', '5000', '3', '', '0');
- INSERT INTO rm VALUES ('30', 'Depot Yasmine Chinesefood', 'Jl. Raya Tidar H1', 'sukun', 'm05', 'chinesefood', '8000', '3', '', '0');
- INSERT INTO rm VALUES ('31', 'warung 9', 'Jl. Raya Langsep No.9A', 'sukun', 'm05', 'chinesefood', '9000', '3', '', '0');
- INSERT INTO rm VALUES ('32', 'gardena', 'Jl. Raya Dieng No.31', 'sukun', 'm05', 'chinesefood', '9000', '3', '', '0');
- INSERT INTO rm VALUES ('33', 'new hongkong', 'jl. panji suroso', 'blimbing', 'm03', 'chinesefood', '10000', '3', '', '0');
- INSERT INTO rm VALUES ('34', 'Warung Steak Kawi', 'Jl. Kawi 18', 'klojen', 'm02', 'internasional', '10000', '3', '', '0');
- INSERT INTO rm VALUES ('35', 'iki japanase', 'Jl. Pahlawan Trip No.8-9', 'klojen', 'm02', 'internasional', '10000', '2', '', '0');
- INSERT INTO rm VALUES ('36', 'toko oen', 'jl. basuki rachmad', 'klojen', 'm02', 'internasional', '10000', '2', '', '0');
- INSERT INTO rm VALUES ('37', 'saboten', 'jl. jakarta', 'klojen', 'm02', 'internasional', '7000', '2', '', '0');
- INSERT INTO rm VALUES ('38', 'amsterdam', 'jl. pahlawan trip', 'klojen', 'm02', 'internasional', '10000', '3', '', '0');
- INSERT INTO rm VALUES ('39', 'padi', 'Jl. Pahlawan Trip No.19', 'klojen', 'm02', 'internasional', '10000', '3', '', '0');
- INSERT INTO rm VALUES ('40', 'mie jogja pak karso', 'jl. Arjuno', 'klojen', 'm02', 'mie', '8000', '2', '', '0');
- INSERT INTO rm VALUES ('41', 'depot H&T cui mie', 'jl. kawi atas 43B', 'klojen', 'm02', 'mie', '10000', '1', '', '0');
- INSERT INTO rm VALUES ('42', 'pujasera makul', 'Jl. Ahmad Yani 51', 'blimbing', 'm03', 'pujasera', '8000', '3', '', '0');
- INSERT INTO rm VALUES ('43', 'terminal kuliner pujasera semanggi', 'Jl. Soekarno Hatta 32', 'lowokwaru', 'm01', 'pujasera', '5000', '3', '', '0');
- INSERT INTO rm VALUES ('44', 'pujasera masera', 'Jl. Soekarno Hatta 18', 'lowokwaru', 'm01', 'pujasera', '3000', '3', '', '0');
- -- ----------------------------
- -- Table structure for `rm_bobot`
- -- ----------------------------
- DROP TABLE IF EXISTS `rm_bobot`;
- CREATE TABLE `rm_bobot` (
- `id_rm` int(11) NOT NULL AUTO_INCREMENT,
- `bobot_jenis_rm` int(11) NOT NULL,
- `bobot_harga_rm` int(11) NOT NULL,
- `bobot_fasilitas_rm` int(11) NOT NULL,
- `bobot_daya_tampung_rm` int(11) NOT NULL,
- PRIMARY KEY (`id_rm`)
- ) ENGINE=MyISAM AUTO_INCREMENT=45 DEFAULT CHARSET=latin1;
- -- ----------------------------
- -- Records of rm_bobot
- -- ----------------------------
- INSERT INTO rm_bobot VALUES ('1', '5', '2', '3', '2');
- INSERT INTO rm_bobot VALUES ('2', '5', '2', '3', '3');
- INSERT INTO rm_bobot VALUES ('3', '5', '2', '2', '2');
- INSERT INTO rm_bobot VALUES ('4', '5', '2', '1', '1');
- INSERT INTO rm_bobot VALUES ('5', '6', '2', '1', '1');
- INSERT INTO rm_bobot VALUES ('6', '6', '2', '2', '2');
- INSERT INTO rm_bobot VALUES ('7', '6', '2', '3', '3');
- INSERT INTO rm_bobot VALUES ('8', '6', '2', '3', '3');
- INSERT INTO rm_bobot VALUES ('9', '6', '2', '3', '3');
- INSERT INTO rm_bobot VALUES ('10', '6', '2', '3', '3');
- INSERT INTO rm_bobot VALUES ('11', '6', '2', '3', '3');
- INSERT INTO rm_bobot VALUES ('12', '6', '2', '3', '3');
- INSERT INTO rm_bobot VALUES ('13', '12', '3', '3', '2');
- INSERT INTO rm_bobot VALUES ('14', '12', '3', '3', '2');
- INSERT INTO rm_bobot VALUES ('15', '8', '3', '2', '2');
- INSERT INTO rm_bobot VALUES ('16', '8', '3', '3', '3');
- INSERT INTO rm_bobot VALUES ('17', '8', '3', '1', '2');
- INSERT INTO rm_bobot VALUES ('18', '8', '3', '1', '2');
- INSERT INTO rm_bobot VALUES ('19', '8', '3', '2', '2');
- INSERT INTO rm_bobot VALUES ('20', '4', '2', '1', '1');
- INSERT INTO rm_bobot VALUES ('21', '4', '2', '1', '1');
- INSERT INTO rm_bobot VALUES ('22', '2', '1', '1', '1');
- INSERT INTO rm_bobot VALUES ('23', '3', '1', '1', '1');
- INSERT INTO rm_bobot VALUES ('24', '3', '1', '2', '3');
- INSERT INTO rm_bobot VALUES ('25', '3', '1', '1', '2');
- INSERT INTO rm_bobot VALUES ('26', '3', '1', '2', '2');
- INSERT INTO rm_bobot VALUES ('27', '7', '3', '3', '3');
- INSERT INTO rm_bobot VALUES ('28', '7', '3', '3', '3');
- INSERT INTO rm_bobot VALUES ('29', '7', '3', '3', '3');
- INSERT INTO rm_bobot VALUES ('30', '10', '2', '3', '3');
- INSERT INTO rm_bobot VALUES ('31', '10', '2', '3', '3');
- INSERT INTO rm_bobot VALUES ('32', '10', '2', '3', '3');
- INSERT INTO rm_bobot VALUES ('33', '10', '2', '3', '3');
- INSERT INTO rm_bobot VALUES ('34', '9', '2', '3', '3');
- INSERT INTO rm_bobot VALUES ('35', '9', '2', '3', '2');
- INSERT INTO rm_bobot VALUES ('36', '9', '2', '3', '2');
- INSERT INTO rm_bobot VALUES ('37', '9', '2', '2', '2');
- INSERT INTO rm_bobot VALUES ('38', '9', '2', '3', '3');
- INSERT INTO rm_bobot VALUES ('39', '9', '2', '3', '3');
- INSERT INTO rm_bobot VALUES ('40', '11', '2', '3', '2');
- INSERT INTO rm_bobot VALUES ('41', '11', '2', '2', '1');
- INSERT INTO rm_bobot VALUES ('42', '1', '1', '2', '3');
- INSERT INTO rm_bobot VALUES ('43', '1', '1', '2', '3');
- INSERT INTO rm_bobot VALUES ('44', '1', '1', '2', '3');
- -- ----------------------------
- -- Table structure for `user`
- -- ----------------------------
- DROP TABLE IF EXISTS `user`;
- CREATE TABLE `user` (
- `user` varchar(30) NOT NULL,
- `pass` varchar(60) NOT NULL,
- `level` int(11) NOT NULL
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- -- ----------------------------
- -- Records of user
- -- ----------------------------
- INSERT INTO user VALUES ('admin', 'admin', '1');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement