Advertisement
Guest User

Untitled

a guest
Jul 26th, 2017
135
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 29.96 KB | None | 0 0
  1. /*
  2. Navicat MySQL Data Transfer
  3.  
  4. Source Server : localhost
  5. Source Server Version : 50137
  6. Source Host : localhost:3306
  7. Source Database : taq
  8.  
  9. Target Server Type : MYSQL
  10. Target Server Version : 50137
  11. File Encoding : 65001
  12.  
  13. Date: 2011-02-19 21:13:02
  14. */
  15.  
  16. SET FOREIGN_KEY_CHECKS=0;
  17. -- ----------------------------
  18. -- Table structure for `hotel`
  19. -- ----------------------------
  20. DROP TABLE IF EXISTS `hotel`;
  21. CREATE TABLE `hotel` (
  22. `id_hotel` int(11) NOT NULL AUTO_INCREMENT,
  23. `nama_hotel` char(100) NOT NULL,
  24. `alamat_hotel` char(100) NOT NULL,
  25. `daerah_hotel` char(30) NOT NULL,
  26. `id_daerah_hotel` char(30) NOT NULL,
  27. `jenis_hotel` char(30) NOT NULL,
  28. `harga_hotel` varchar(11) NOT NULL,
  29. `daya_tampung_hotel` int(11) NOT NULL,
  30. `ket_hotel` char(100) NOT NULL,
  31. `foto_hotel` varchar(100) NOT NULL,
  32. PRIMARY KEY (`id_hotel`)
  33. ) ENGINE=MyISAM AUTO_INCREMENT=50 DEFAULT CHARSET=latin1;
  34.  
  35. -- ----------------------------
  36. -- Records of hotel
  37. -- ----------------------------
  38. INSERT INTO hotel VALUES ('1', 'ARJOSARI', 'Jl. Raden intan no 49 malang', 'blimbing', 'm03', 'melati', '150000', '50', '', '');
  39. INSERT INTO hotel VALUES ('5', 'BAHAGIA', 'Jl. Letjen S Parman 45 Malang', 'klojen', 'm02', 'melati', '150000', '50', '', '');
  40. INSERT INTO hotel VALUES ('6', 'BINTANG', 'Jl. Hamid Rusdi No. 97 Malang', 'klojen', 'm02', 'melati', '150000', '50', '', '');
  41. INSERT INTO hotel VALUES ('2', 'ALOHA', 'Jl. Gajah Mada 7', 'lowokwaru', 'm01', 'melati', '150000', '50', '', '');
  42. INSERT INTO hotel VALUES ('7', 'CAMELIA', 'Jl. Dr. Cipto 24 Malang', 'blimbing', 'm03', 'melati', '150000', '50', '', '');
  43. INSERT INTO hotel VALUES ('8', 'EMMA MUSTIKA SARI', 'Jl. Laks. Martadinata 18-24 Malang', 'blimbing', 'm03', 'melati', '150000', '50', '', '');
  44. INSERT INTO hotel VALUES ('3', 'ARJUNO', 'Jl. B. S. Riadi 122 Malang', 'klojen', 'm02', 'melati', '150000', '50', '', '');
  45. INSERT INTO hotel VALUES ('9', 'GAJAHMADA GRAHA', 'Jl. Dr. Cipto 17 Malang', 'klojen', 'm02', 'melati', '300000', '125', '', '');
  46. INSERT INTO hotel VALUES ('10', 'GRAHA CAKRA', 'Jl. Cerme 16 Malang', 'klojen', 'm02', 'bintang 3', '300000', '125', '', '');
  47. INSERT INTO hotel VALUES ('4', 'ARMI', 'Jl. Kaliurang 63 Malang', 'klojen', 'm02', 'bintang 3', '150000', '50', '', '');
  48. INSERT INTO hotel VALUES ('11', 'GRAND PALACE', 'Jl. Ade Irma Suryani 23 Malang', 'klojen', 'm02', 'bintang 3', '300000', '125', '', '');
  49. INSERT INTO hotel VALUES ('12', 'GRAHA DEWATA AGUNG', 'Jl. P. Suroso no 10', 'blimbing', 'm03', 'melati', '150000', '50', '', '');
  50. INSERT INTO hotel VALUES ('13', 'H. S. KASABRA', 'Jl. Gresik No. 2 Malang', 'lowokwaru', 'm01', 'melati', '150000', '50', '', '');
  51. INSERT INTO hotel VALUES ('14', 'HELIOS', 'Jl. Pattimura 37 Malang', 'klojen', 'm02', 'melati', '150000', '50', '', '');
  52. INSERT INTO hotel VALUES ('15', 'KAHURIPAN', 'Jl. Kahuripan 11 - 15 Malang', 'klojen', 'm02', 'melati', '150000', '50', '', '');
  53. INSERT INTO hotel VALUES ('16', 'KALPATARU', 'Jl. Kalpataru 41 Malang', 'lowokwaru', 'm01', 'melati', '150000', '50', '', '');
  54. INSERT INTO hotel VALUES ('17', 'KARTIKA GRAHA', 'Jl. Jakgung Suprapto 17 Malang', 'blimbing', 'm03', 'bintang 1', '200000', '75', '', '');
  55. INSERT INTO hotel VALUES ('18', 'KARTIKA KUSUMA', 'Jl.Kahuripan 12 Malang', 'klojen', 'm02', 'melati', '150000', '50', '', '');
  56. INSERT INTO hotel VALUES ('19', 'MALANG', 'Jl. Z. Arifin 85 Malang', 'klojen', 'm02', 'melati', '150000', '50', '', '');
  57. INSERT INTO hotel VALUES ('20', 'MALINDA', 'Jl. Zainul Arifin 37 - 39 Malang', 'klojen', 'm02', 'melati', '150000', '50', '', '');
  58. INSERT INTO hotel VALUES ('21', 'MANDALA PURI', 'Jl. PB. Sudirman 81 Malang', 'klojen', 'm02', 'melati', '150000', '50', '', '');
  59. INSERT INTO hotel VALUES ('22', 'MANSION', 'Jl. Martadinata 9 Malang', 'klojen', 'm02', 'melati', '150000', '50', '', '');
  60. INSERT INTO hotel VALUES ('23', 'MEGAWATI', 'Jl. Pang. Sudirman 99 Malang', 'klojen', 'm02', 'melati', '150000', '50', '', '');
  61. INSERT INTO hotel VALUES ('24', 'MENARA', 'Jl. Pajajaran 5 Malang', 'klojen', 'm02', 'melati', '150000', '50', '', '');
  62. INSERT INTO hotel VALUES ('25', 'MONTANA I', 'Jl. Kahuripan 9 Malang', 'klojen', 'm02', 'bintang 2', '250000', '100', '', '');
  63. INSERT INTO hotel VALUES ('26', 'MONTANA II', 'Jl. Candi Panggung 2 Malang', 'lowokwaru', 'm01', 'melati', '150000', '50', '', '');
  64. INSERT INTO hotel VALUES ('27', 'MUTIARA', 'Jl. Jagung Suprapto', 'klojen', 'm02', 'melati', '150000', '50', '', '');
  65. INSERT INTO hotel VALUES ('28', 'NUGRAHA', 'Jl. Panji Suroso 16 Malang', 'blimbing', 'm03', 'melati', '150000', '50', '', '');
  66. INSERT INTO hotel VALUES ('29', 'PAJAJARAN PARK', 'Jl. Letjend. Sutoyo 178 Malang', 'klojen', 'm02', 'melati', '150000', '50', '', '');
  67. INSERT INTO hotel VALUES ('30', 'PALEM II', 'Jl. MH. Thamrin 15 Malang', 'klojen', 'm02', 'melati', '150000', '50', '', '');
  68. INSERT INTO hotel VALUES ('31', 'PELANGI I', 'Jl. Merdeka Selatan 3 Malang', 'klojen', 'm02', 'bintang 1', '200000', '75', '', '');
  69. INSERT INTO hotel VALUES ('32', 'PELANGI II', 'Jl. Gajayana Malang', 'lowokwaru', 'm01', 'melati', '150000', '50', '', '');
  70. INSERT INTO hotel VALUES ('33', 'PENGINAPAN TLOGOMAS', 'Jl. Tlogomas Malang', 'lowokwaru', 'm01', 'melati', '150000', '50', '', '');
  71. INSERT INTO hotel VALUES ('34', 'PINUS', 'Jl. S.P. Sudarmo Malang', 'blimbing', 'm03', 'melati', '150000', '50', '', '');
  72. INSERT INTO hotel VALUES ('35', 'REGENT\'S PARK', 'Jl. Jakgung Suprapto 12 - 17 Malang', 'klojen', 'm02', 'bintang 3', '300000', '125', '', '');
  73. INSERT INTO hotel VALUES ('36', 'RICHE', 'Jl. Basuki Rachmad 1', 'klojen', 'm02', 'bintang 1', '200000', '75', '', '');
  74. INSERT INTO hotel VALUES ('37', 'ROYAL INN', 'Jl. Tenaga Baru 1/5 Malang', 'blimbing', 'm03', 'melati', '150000', '50', '', '');
  75. INSERT INTO hotel VALUES ('38', 'SANTIKA', 'Jl. Letjen Sutoyo No. 79 Malang 65141', 'lowokwaru', 'm01', 'bintang 4', '350000', '150', '', '');
  76. INSERT INTO hotel VALUES ('39', 'SANTOSO', 'Jl. K.H. Agus Salim 24 Malang', 'klojen', 'm02', 'melati', '150000', '50', '', '');
  77. INSERT INTO hotel VALUES ('40', 'SERAYU', 'Jl. Serayu 3 Malang', 'blimbing', 'm03', 'melati', '150000', '50', '', '');
  78. INSERT INTO hotel VALUES ('41', 'SETIA BUDI', 'Jl. Pattimura 71 A Malang', 'klojen', 'm02', 'melati', '150000', '50', '', '');
  79. INSERT INTO hotel VALUES ('42', 'SIMPANG TIGA', 'Jl. Margono 56 Malang', 'sukun', 'm05', 'melati', '150000', '50', '', '');
  80. INSERT INTO hotel VALUES ('43', 'SPLENDID INN', 'Jl. Majapahit 2 - 4 Malang', 'klojen', 'm02', 'bintang 1', '200000', '75', '', '');
  81. INSERT INTO hotel VALUES ('44', 'TIRTO', 'Jl. Simp. Panji Suroso Kav 133 Malang', 'blimbing', 'm03', 'melati', '150000', '50', '', '');
  82. INSERT INTO hotel VALUES ('45', 'TOSARI', 'Jl. KH. A. Dahlan 31 Malang', 'klojen', 'm02', 'melati', '150000', '50', '', '');
  83. INSERT INTO hotel VALUES ('46', 'TRIO INDAH', 'Jl. Brigjen Slamet Riadi No. 2-4 Malang', 'klojen', 'm02', 'melati', '150000', '50', '', '');
  84. INSERT INTO hotel VALUES ('47', 'TRIO INDAH II', 'Jl. JA. Suprapto Malang', 'klojen', 'm02', 'melati', '150000', '50', '', '');
  85. INSERT INTO hotel VALUES ('48', 'TUGU PARK', 'Jl. Tugu No. 3 Malang', 'klojen', 'm02', 'bintang 1', '200000', '75', '', '');
  86. INSERT INTO hotel VALUES ('49', 'WILIS INDAH', 'Jl. Dr. Wahidin 40 Malang', 'klojen', 'm02', 'melati', '150000', '50', '', '');
  87.  
  88. -- ----------------------------
  89. -- Table structure for `hotel_bobot`
  90. -- ----------------------------
  91. DROP TABLE IF EXISTS `hotel_bobot`;
  92. CREATE TABLE `hotel_bobot` (
  93. `id_hotel` int(11) NOT NULL AUTO_INCREMENT,
  94. `bobot_jenis_hotel` int(11) NOT NULL,
  95. `bobot_harga_hotel` int(11) NOT NULL,
  96. `bobot_fasilitas_hotel` int(11) NOT NULL,
  97. `bobot_daya_tampung_hotel` int(11) NOT NULL,
  98. PRIMARY KEY (`id_hotel`)
  99. ) ENGINE=MyISAM AUTO_INCREMENT=50 DEFAULT CHARSET=latin1;
  100.  
  101. -- ----------------------------
  102. -- Records of hotel_bobot
  103. -- ----------------------------
  104. INSERT INTO hotel_bobot VALUES ('1', '1', '1', '1', '1');
  105. INSERT INTO hotel_bobot VALUES ('2', '1', '1', '2', '2');
  106. INSERT INTO hotel_bobot VALUES ('3', '1', '1', '1', '2');
  107. INSERT INTO hotel_bobot VALUES ('4', '1', '1', '2', '2');
  108. INSERT INTO hotel_bobot VALUES ('5', '1', '1', '1', '1');
  109. INSERT INTO hotel_bobot VALUES ('6', '1', '1', '1', '1');
  110. INSERT INTO hotel_bobot VALUES ('7', '1', '1', '1', '2');
  111. INSERT INTO hotel_bobot VALUES ('8', '1', '1', '1', '1');
  112. INSERT INTO hotel_bobot VALUES ('9', '4', '3', '3', '3');
  113. INSERT INTO hotel_bobot VALUES ('10', '4', '3', '3', '3');
  114. INSERT INTO hotel_bobot VALUES ('11', '4', '3', '3', '3');
  115. INSERT INTO hotel_bobot VALUES ('12', '1', '1', '1', '1');
  116. INSERT INTO hotel_bobot VALUES ('13', '1', '1', '1', '1');
  117. INSERT INTO hotel_bobot VALUES ('14', '1', '1', '2', '2');
  118. INSERT INTO hotel_bobot VALUES ('15', '1', '1', '1', '1');
  119. INSERT INTO hotel_bobot VALUES ('16', '1', '1', '1', '1');
  120. INSERT INTO hotel_bobot VALUES ('17', '2', '2', '2', '2');
  121. INSERT INTO hotel_bobot VALUES ('18', '1', '1', '2', '2');
  122. INSERT INTO hotel_bobot VALUES ('19', '1', '1', '1', '1');
  123. INSERT INTO hotel_bobot VALUES ('20', '1', '1', '2', '1');
  124. INSERT INTO hotel_bobot VALUES ('21', '1', '1', '2', '2');
  125. INSERT INTO hotel_bobot VALUES ('22', '1', '1', '1', '1');
  126. INSERT INTO hotel_bobot VALUES ('23', '1', '1', '1', '1');
  127. INSERT INTO hotel_bobot VALUES ('24', '1', '1', '1', '1');
  128. INSERT INTO hotel_bobot VALUES ('25', '3', '2', '2', '2');
  129. INSERT INTO hotel_bobot VALUES ('26', '1', '1', '2', '2');
  130. INSERT INTO hotel_bobot VALUES ('27', '1', '1', '1', '1');
  131. INSERT INTO hotel_bobot VALUES ('28', '1', '1', '1', '1');
  132. INSERT INTO hotel_bobot VALUES ('29', '1', '1', '2', '2');
  133. INSERT INTO hotel_bobot VALUES ('30', '1', '1', '1', '2');
  134. INSERT INTO hotel_bobot VALUES ('31', '2', '2', '2', '2');
  135. INSERT INTO hotel_bobot VALUES ('32', '1', '1', '2', '2');
  136. INSERT INTO hotel_bobot VALUES ('33', '1', '1', '2', '1');
  137. INSERT INTO hotel_bobot VALUES ('34', '1', '1', '1', '2');
  138. INSERT INTO hotel_bobot VALUES ('35', '4', '3', '3', '3');
  139. INSERT INTO hotel_bobot VALUES ('36', '2', '2', '2', '2');
  140. INSERT INTO hotel_bobot VALUES ('37', '1', '1', '2', '2');
  141. INSERT INTO hotel_bobot VALUES ('38', '5', '3', '3', '3');
  142. INSERT INTO hotel_bobot VALUES ('39', '1', '1', '1', '1');
  143. INSERT INTO hotel_bobot VALUES ('40', '1', '1', '1', '1');
  144. INSERT INTO hotel_bobot VALUES ('41', '1', '1', '1', '1');
  145. INSERT INTO hotel_bobot VALUES ('42', '1', '1', '1', '1');
  146. INSERT INTO hotel_bobot VALUES ('43', '2', '2', '2', '2');
  147. INSERT INTO hotel_bobot VALUES ('44', '1', '1', '1', '1');
  148. INSERT INTO hotel_bobot VALUES ('45', '1', '1', '1', '1');
  149. INSERT INTO hotel_bobot VALUES ('46', '1', '1', '2', '2');
  150. INSERT INTO hotel_bobot VALUES ('47', '1', '1', '2', '2');
  151. INSERT INTO hotel_bobot VALUES ('48', '2', '2', '2', '2');
  152. INSERT INTO hotel_bobot VALUES ('49', '1', '1', '1', '1');
  153.  
  154. -- ----------------------------
  155. -- Table structure for `oleh`
  156. -- ----------------------------
  157. DROP TABLE IF EXISTS `oleh`;
  158. CREATE TABLE `oleh` (
  159. `id_oleh` int(11) NOT NULL AUTO_INCREMENT,
  160. `nama_oleh` char(100) NOT NULL,
  161. `alamat_oleh` char(100) NOT NULL,
  162. `daerah_oleh` char(30) NOT NULL,
  163. `id_daerah_oleh` char(30) NOT NULL,
  164. `jenis_oleh` char(30) NOT NULL,
  165. `harga_oleh` int(11) NOT NULL,
  166. `ket_oleh` char(100) NOT NULL,
  167. `foto_oleh` int(11) NOT NULL,
  168. PRIMARY KEY (`id_oleh`)
  169. ) ENGINE=MyISAM AUTO_INCREMENT=53 DEFAULT CHARSET=latin1;
  170.  
  171. -- ----------------------------
  172. -- Records of oleh
  173. -- ----------------------------
  174. INSERT INTO oleh VALUES ('1', 'Nandra', 'Jl.Bale Arjosari', 'Blimbing', 'm03', 'Rotan', '25000', '', '0');
  175. INSERT INTO oleh VALUES ('2', 'Prima Jaya', 'Jl.Bale Arjosari', 'Blimbing', 'm03', 'Rotan', '19000', '', '0');
  176. INSERT INTO oleh VALUES ('3', 'Sakura Indah', 'Jl.Bale Arjosari', 'Blimbing', 'm03', 'Rotan', '21000', '', '0');
  177. INSERT INTO oleh VALUES ('4', 'UD.Puri Agung', 'Jl.Bale Arjosari', 'Blimbing', 'm03', 'Rotan', '23000', '', '0');
  178. INSERT INTO oleh VALUES ('5', 'Antika Rotan', 'Jl.Bale Arjosari', 'Blimbing', 'm03', 'Rotan', '27000', '', '0');
  179. INSERT INTO oleh VALUES ('6', 'Bening Jaya', 'Jl.Bale Arjosari', 'Blimbing', 'm03', 'Rotan', '30000', '', '0');
  180. INSERT INTO oleh VALUES ('7', 'Bukan Pasadena', 'Jl.Bale Arjosari', 'Blimbing', 'm03', 'Rotan', '22000', '', '0');
  181. INSERT INTO oleh VALUES ('8', 'UPK \"Ken Arok\"', 'Jl. Ahmad Yani Utara 2', 'Blimbing', 'm03', 'Kripik', '8000', '', '0');
  182. INSERT INTO oleh VALUES ('9', 'Indo Argo', 'Jl.A.yani 77', 'Blimbing', 'm03', 'Kripik', '7000', '', '0');
  183. INSERT INTO oleh VALUES ('10', 'Goldia 1', 'Jl.Galunggung', 'klojen', 'm02', 'Kripik', '6000', '', '0');
  184. INSERT INTO oleh VALUES ('11', 'Goldia 2', 'Jl.Sumber Sari', 'Lowokwaru', 'm01', 'Kripik', '6000', '', '0');
  185. INSERT INTO oleh VALUES ('12', 'Caprina', 'Jl.Raya Tlogo Mas', 'Lowokwaru', 'm01', 'Kripik', '8000', '', '0');
  186. INSERT INTO oleh VALUES ('13', 'Denis Souvenier', 'Jl. MT.Haryono Malang 340', 'Lowokwaru', 'm01', 'Keramik', '2000', '', '0');
  187. INSERT INTO oleh VALUES ('14', 'Firman', 'Jl. MT.Haryono Malang 339', 'Lowokwaru', 'm01', 'Keramik', '1500', '', '0');
  188. INSERT INTO oleh VALUES ('15', 'Pak Isma', 'Jl. MT.Haryono Malang 474', 'Lowokwaru', 'm01', 'Keramik', '3000', '', '0');
  189. INSERT INTO oleh VALUES ('16', 'Ibu Riyanti', 'Jl. MT.Haryono Malang 472', 'Lowokwaru', 'm01', 'Keramik', '2100', '', '0');
  190. INSERT INTO oleh VALUES ('17', 'Ibu Soeharto', 'Jl. MT.Haryono Malang 461', 'Lowokwaru', 'm01', 'Keramik', '2200', '', '0');
  191. INSERT INTO oleh VALUES ('18', 'Family', 'Jl. MT.Haryono Malang 42', 'Lowokwaru', 'm01', 'Keramik', '1900', '', '0');
  192. INSERT INTO oleh VALUES ('19', 'C J D W', 'Jl. MT.Haryono Malang 459', 'Lowokwaru', 'm01', 'Keramik', '1800', '', '0');
  193. INSERT INTO oleh VALUES ('20', 'Harapan Jaya', 'Jl. Mayjend. Panjaitan Malang', 'klojen', 'm02', 'Gerabah', '35000', '', '0');
  194. INSERT INTO oleh VALUES ('21', 'Al Faris', 'Jl. Mayjend. Panjaitan Malang 167', 'klojen', 'm02', 'Gerabah', '37000', '', '0');
  195. INSERT INTO oleh VALUES ('22', 'Sumber Rezeki', 'Jl. Mayjend. Panjaitan Malang', 'klojen', 'm02', 'Gerabah', '36000', '', '0');
  196. INSERT INTO oleh VALUES ('23', 'Trisensa', 'Jl. Mayjend. Panjaitan Malang no 66', 'klojen', 'm02', 'Keramik', '2200', '', '0');
  197. INSERT INTO oleh VALUES ('24', 'Pelangi Sari', 'Jl.Soekarno Hatta 29 c', 'Lowokwaru', 'm01', 'Keripik', '9000', '', '0');
  198. INSERT INTO oleh VALUES ('25', 'Pao Telay', 'Jl.Terusan Borobudur 80', 'Lowokwaru', 'm01', 'Keripik', '8500', '', '0');
  199. INSERT INTO oleh VALUES ('26', 'Sidik Putra', 'Jl.Piranha Atas 166', 'Lowokwaru', 'm01', 'Mebel', '200000', '', '0');
  200. INSERT INTO oleh VALUES ('27', 'Juli', 'Jl.Trs.Ikan Paus 3', 'Lowokwaru', 'm01', 'Mebel', '250000', '', '0');
  201. INSERT INTO oleh VALUES ('28', 'Manunggal', 'Jl.Ikan Piranha Atas 171', 'Lowokwaru', 'm01', 'Mebel', '300000', '', '0');
  202. INSERT INTO oleh VALUES ('29', 'Sumber Aram', 'Jl.Ikan Piranha Atas 182', 'Lowokwaru', 'm01', 'Mebel', '270000', '', '0');
  203. INSERT INTO oleh VALUES ('30', 'Pram\'bos', 'Jl.Ikan Piranha Atas 174', 'Lowokwaru', 'm01', 'Mebel', '280000', '', '0');
  204. INSERT INTO oleh VALUES ('31', 'Win Mebel', 'Jl.Ikan Piranha Atas 172', 'Lowokwaru', 'm01', 'Mebel', '310000', '', '0');
  205. INSERT INTO oleh VALUES ('32', 'Mia Mebel', 'Jl.Ikan Piranha Atas 167', 'Lowokwaru', 'm01', 'Mebel', '290000', '', '0');
  206. INSERT INTO oleh VALUES ('33', 'Arofah', 'Jl.Ikan Piranha Atas', 'Lowokwaru', 'm01', 'Mebel', '240000', '', '0');
  207. INSERT INTO oleh VALUES ('34', 'Jati Bersama', 'Jl.Ikan Piranha Atas 165', 'Lowokwaru', 'm01', 'Mebel', '230000', '', '0');
  208. INSERT INTO oleh VALUES ('35', 'Jati Bersama', 'Jl.Ikan Piranha Atas 172', 'Lowokwaru', 'm01', 'Mebel', '300000', '', '0');
  209. INSERT INTO oleh VALUES ('36', 'Erlangga Onix', 'Jl.Ikan Piranha Atas 163', 'Lowokwaru', 'm01', 'Mebel', '320000', '', '0');
  210. INSERT INTO oleh VALUES ('37', 'Barokah', 'Jl.Ikan Piranha Atas 160', 'Lowokwaru', 'm01', 'Mebel', '230000', '', '0');
  211. INSERT INTO oleh VALUES ('38', 'Usah Jati', 'Jl.Ikan Piranha Atas 158', 'Lowokwaru', 'm01', 'Mebel', '280000', '', '0');
  212. INSERT INTO oleh VALUES ('39', 'Muncul Jaya', 'Jl.Ikan Piranha Atas 136', 'Lowokwaru', 'm01', 'Mebel', '310000', '', '0');
  213. INSERT INTO oleh VALUES ('40', 'Pandowo', 'Jl.Ikan Piranha Atas 142', 'Lowokwaru', 'm01', 'Mebel', '250000', '', '0');
  214. INSERT INTO oleh VALUES ('41', 'Srikandi', 'Jl.Ikan Piranha Atas 14', 'Lowokwaru', 'm01', 'Mebel', '280000', '', '0');
  215. INSERT INTO oleh VALUES ('42', 'Bima Sakti', 'Jl.Ikan Piranha Atas 684', 'Lowokwaru', 'm01', 'Mebel', '190000', '', '0');
  216. INSERT INTO oleh VALUES ('43', 'Gajah Santoso', 'Jl.Tumenggung Suryo 131 E', 'Blimbing', 'm03', 'Keripik', '8200', '', '0');
  217. INSERT INTO oleh VALUES ('44', 'Dermaga', 'Jl.R.T Suryo 86 Kav E', 'Blimbing', 'm03', 'Keripik', '8000', '', '0');
  218. INSERT INTO oleh VALUES ('45', 'Burung Swari', 'Jl.Sanan 30', 'Blimbing', 'm03', 'Keripik', '8500', '', '0');
  219. INSERT INTO oleh VALUES ('46', 'Lancar Jaya', 'Jl.Sanan 18', 'Blimbing', 'm03', 'Keripik', '8000', '', '0');
  220. INSERT INTO oleh VALUES ('47', 'Karina', 'Jl.Sanan 24', 'Blimbing', 'm03', 'Keripik', '9000', '', '0');
  221. INSERT INTO oleh VALUES ('48', 'Central', 'Jl.R.T Suryo 31', 'Blimbing', 'm03', 'Keripik', '5000', '', '0');
  222. INSERT INTO oleh VALUES ('49', 'Rahayu', 'Jl.R.T Suryo', 'Blimbing', 'm03', 'Keripik', '7500', '', '0');
  223. INSERT INTO oleh VALUES ('50', 'Intan Jaya Abadi', 'Jl.R.T Suryo 84', 'Blimbing', 'm03', 'Keripik', '6000', '', '0');
  224. INSERT INTO oleh VALUES ('51', 'Andhika', 'Jl.R.T Suryo', 'Blimbing', 'm03', 'Keripik', '5000', '', '0');
  225. INSERT INTO oleh VALUES ('52', 'Sentra Industri Batu Onyx', 'Jl. Tlogomas Malang', 'Lowokwaru', 'm01', 'Batu Onyx', '50000', '', '0');
  226.  
  227. -- ----------------------------
  228. -- Table structure for `oleh_bobot`
  229. -- ----------------------------
  230. DROP TABLE IF EXISTS `oleh_bobot`;
  231. CREATE TABLE `oleh_bobot` (
  232. `id_oleh` int(11) NOT NULL AUTO_INCREMENT,
  233. `bobot_jenis_oleh` int(11) NOT NULL,
  234. `bobot_harga_oleh` int(11) NOT NULL,
  235. `bobot_fasilitas_oleh` int(11) NOT NULL,
  236. PRIMARY KEY (`id_oleh`)
  237. ) ENGINE=MyISAM AUTO_INCREMENT=53 DEFAULT CHARSET=latin1;
  238.  
  239. -- ----------------------------
  240. -- Records of oleh_bobot
  241. -- ----------------------------
  242. INSERT INTO oleh_bobot VALUES ('1', '3', '2', '1');
  243. INSERT INTO oleh_bobot VALUES ('2', '3', '2', '1');
  244. INSERT INTO oleh_bobot VALUES ('3', '3', '2', '1');
  245. INSERT INTO oleh_bobot VALUES ('4', '3', '2', '1');
  246. INSERT INTO oleh_bobot VALUES ('5', '3', '2', '1');
  247. INSERT INTO oleh_bobot VALUES ('6', '3', '2', '1');
  248. INSERT INTO oleh_bobot VALUES ('7', '3', '2', '1');
  249. INSERT INTO oleh_bobot VALUES ('8', '2', '1', '1');
  250. INSERT INTO oleh_bobot VALUES ('9', '2', '1', '1');
  251. INSERT INTO oleh_bobot VALUES ('10', '2', '1', '1');
  252. INSERT INTO oleh_bobot VALUES ('11', '2', '1', '1');
  253. INSERT INTO oleh_bobot VALUES ('12', '2', '1', '1');
  254. INSERT INTO oleh_bobot VALUES ('13', '1', '1', '2');
  255. INSERT INTO oleh_bobot VALUES ('14', '1', '1', '2');
  256. INSERT INTO oleh_bobot VALUES ('15', '1', '1', '2');
  257. INSERT INTO oleh_bobot VALUES ('16', '1', '1', '2');
  258. INSERT INTO oleh_bobot VALUES ('17', '1', '1', '2');
  259. INSERT INTO oleh_bobot VALUES ('18', '1', '1', '2');
  260. INSERT INTO oleh_bobot VALUES ('19', '1', '1', '2');
  261. INSERT INTO oleh_bobot VALUES ('20', '4', '2', '2');
  262. INSERT INTO oleh_bobot VALUES ('21', '4', '2', '2');
  263. INSERT INTO oleh_bobot VALUES ('22', '4', '2', '2');
  264. INSERT INTO oleh_bobot VALUES ('23', '1', '1', '3');
  265. INSERT INTO oleh_bobot VALUES ('24', '2', '1', '2');
  266. INSERT INTO oleh_bobot VALUES ('25', '2', '1', '2');
  267. INSERT INTO oleh_bobot VALUES ('26', '6', '3', '3');
  268. INSERT INTO oleh_bobot VALUES ('27', '6', '3', '3');
  269. INSERT INTO oleh_bobot VALUES ('28', '6', '3', '3');
  270. INSERT INTO oleh_bobot VALUES ('29', '6', '3', '3');
  271. INSERT INTO oleh_bobot VALUES ('30', '6', '3', '3');
  272. INSERT INTO oleh_bobot VALUES ('31', '6', '3', '3');
  273. INSERT INTO oleh_bobot VALUES ('32', '6', '3', '3');
  274. INSERT INTO oleh_bobot VALUES ('33', '6', '3', '3');
  275. INSERT INTO oleh_bobot VALUES ('34', '6', '3', '3');
  276. INSERT INTO oleh_bobot VALUES ('35', '6', '3', '3');
  277. INSERT INTO oleh_bobot VALUES ('36', '6', '3', '3');
  278. INSERT INTO oleh_bobot VALUES ('37', '6', '3', '3');
  279. INSERT INTO oleh_bobot VALUES ('38', '6', '3', '3');
  280. INSERT INTO oleh_bobot VALUES ('39', '6', '3', '3');
  281. INSERT INTO oleh_bobot VALUES ('40', '6', '3', '3');
  282. INSERT INTO oleh_bobot VALUES ('41', '6', '3', '3');
  283. INSERT INTO oleh_bobot VALUES ('42', '6', '3', '3');
  284. INSERT INTO oleh_bobot VALUES ('43', '2', '1', '3');
  285. INSERT INTO oleh_bobot VALUES ('44', '2', '1', '3');
  286. INSERT INTO oleh_bobot VALUES ('45', '2', '1', '3');
  287. INSERT INTO oleh_bobot VALUES ('46', '2', '1', '3');
  288. INSERT INTO oleh_bobot VALUES ('47', '2', '1', '3');
  289. INSERT INTO oleh_bobot VALUES ('48', '2', '1', '3');
  290. INSERT INTO oleh_bobot VALUES ('49', '2', '1', '3');
  291. INSERT INTO oleh_bobot VALUES ('50', '2', '1', '3');
  292. INSERT INTO oleh_bobot VALUES ('51', '2', '1', '3');
  293. INSERT INTO oleh_bobot VALUES ('52', '5', '3', '3');
  294.  
  295. -- ----------------------------
  296. -- Table structure for `rm`
  297. -- ----------------------------
  298. DROP TABLE IF EXISTS `rm`;
  299. CREATE TABLE `rm` (
  300. `id_rm` int(11) NOT NULL AUTO_INCREMENT,
  301. `nama_rm` char(100) NOT NULL,
  302. `alamat_rm` char(100) NOT NULL,
  303. `daerah_rm` char(30) NOT NULL,
  304. `id_daerah_rm` char(30) NOT NULL,
  305. `jenis_rm` char(30) NOT NULL,
  306. `harga_rm` int(11) NOT NULL,
  307. `daya_tampung_rm` int(11) NOT NULL,
  308. `ket_rm` char(100) NOT NULL,
  309. `foto_rm` int(11) NOT NULL,
  310. PRIMARY KEY (`id_rm`)
  311. ) ENGINE=MyISAM AUTO_INCREMENT=45 DEFAULT CHARSET=latin1;
  312.  
  313. -- ----------------------------
  314. -- Records of rm
  315. -- ----------------------------
  316. INSERT INTO rm VALUES ('1', 'Kedai 27 Sarangan', 'Jl. Sarangan 27', 'lowokwaru', 'm01', 'nasi', '9000', '2', '', '0');
  317. INSERT INTO rm VALUES ('2', 'warung pojok', 'jl. borobudur', 'blimbing', 'm03', 'nasi', '7000', '3', '', '0');
  318. INSERT INTO rm VALUES ('3', 'warung nasi bu gito', 'jl. soekarno hatta ruko II DR-13', 'lowokwaru', 'm01', 'nasi', '4000', '2', '', '0');
  319. INSERT INTO rm VALUES ('4', 'depot nasi goreng khas malang', 'jl. soekarno hatta 9', 'lowokwaru', 'm01', 'nasi', '5000', '1', '', '0');
  320. INSERT INTO rm VALUES ('5', 'ayam lepas', 'Jl. MT Haryono 193 B', 'lowokwaru', 'm01', 'ayam', '4000', '1', '', '0');
  321. INSERT INTO rm VALUES ('6', 'warung bu kris', 'Ruko Griya Shanta, Jl. Soekarno Hatta MP-58', 'lowokwaru', 'm01', 'ayam', '8000', '2', '', '0');
  322. INSERT INTO rm VALUES ('7', 'ayam goreng pemuda', 'jl. semeru', 'klojen', 'm02', 'ayam', '9000', '3', '', '0');
  323. INSERT INTO rm VALUES ('8', 'ayam goreng pak maning', 'jl. soekarno hatta 94', 'lowokwaru', 'm01', 'ayam', '10000', '3', '', '0');
  324. INSERT INTO rm VALUES ('9', 'rumah makan ringin asri', 'jl. soekarno hatta 45', 'lowokwaru', 'm01', 'ayam', '6000', '3', '', '0');
  325. INSERT INTO rm VALUES ('10', 'warung lesehan yogyakarta', 'jl. Kendalsari Barat no 8', 'lowokwaru', 'm01', 'ayam', '9000', '3', '', '0');
  326. INSERT INTO rm VALUES ('11', 'prambanan sari', 'Jl. Bromo 37 A', 'klojen', 'm02', 'ayam', '9000', '3', '', '0');
  327. INSERT INTO rm VALUES ('12', 'wong solo', 'jl. Arjuno', 'klojen', 'm02', 'ayam', '12000', '3', '', '0');
  328. INSERT INTO rm VALUES ('13', 'bebek super indonesia', 'Jl.Soekarno Hatta kav A.2', 'blimbing', 'm03', 'bebek', '12000', '2', '', '0');
  329. INSERT INTO rm VALUES ('14', 'bebek mercon', 'Jl. Soekarno Hatta Ruko griya shanta MP/48', 'lowokwaru', 'm01', 'bebek', '17500', '2', '', '0');
  330. INSERT INTO rm VALUES ('15', 'lesehan bambu', 'Jl. Bendungan Sigura-gura', 'lowokwaru', 'm01', 'ikan', '6000', '2', '', '0');
  331. INSERT INTO rm VALUES ('16', 'ikan bakar cianjur', 'Jl. Simpang balapan', 'klojen', 'm02', 'ikan', '9000', '3', '', '0');
  332. INSERT INTO rm VALUES ('17', 'ikan segar sutra', 'Jl. MT Haryono 16', 'lowokwaru', 'm01', 'ikan', '9000', '2', '', '0');
  333. INSERT INTO rm VALUES ('18', 'raja-raja', 'jl. Galunggung 48 A', 'klojen', 'm02', 'ikan', '15000', '2', '', '0');
  334. INSERT INTO rm VALUES ('19', 'ikan segar galunggung', 'jl. galunggung', 'klojen', 'm02', 'ikan', '15000', '2', '', '0');
  335. INSERT INTO rm VALUES ('20', 'saiyo sakato', 'Jl. MT Haryono 194 Kav B', 'lowokwaru', 'm01', 'padang', '7000', '1', '', '0');
  336. INSERT INTO rm VALUES ('21', 'ampera goyang lidah', 'Jl. MT Haryono 166', 'lowokwaru', 'm01', 'padang', '7000', '1', '', '0');
  337. INSERT INTO rm VALUES ('22', 'rumah makan pak haji', 'Jl. MT Haryono 209', 'lowokwaru', 'm01', 'soto', '5000', '1', '', '0');
  338. INSERT INTO rm VALUES ('23', 'bakso damas', 'Jl. MT Haryono 11', 'lowokwaru', 'm01', 'bakso', '6000', '1', '', '0');
  339. INSERT INTO rm VALUES ('24', 'bakso bakar pahlawan trip', 'Jl. Pahlawan Trip', 'klojen', 'm02', 'bakso', '6000', '3', '', '0');
  340. INSERT INTO rm VALUES ('25', 'bakso gun', 'jl. kawi atas 41', 'klojen', 'm02', 'bakso', '6000', '2', '', '0');
  341. INSERT INTO rm VALUES ('26', 'Bakso Solo Iga Suhat', 'Jl. Soekarno Hatta Ruko GSE. MP 39', 'lowokwaru', 'm01', 'bakso', '6000', '2', '', '0');
  342. INSERT INTO rm VALUES ('27', 'KFC', 'jl. kawi', 'klojen', 'm02', 'cepat saji', '12000', '3', '', '0');
  343. INSERT INTO rm VALUES ('28', 'pizza hut', 'jl. semeru', 'klojen', 'm02', 'cepat saji', '11000', '3', '', '0');
  344. INSERT INTO rm VALUES ('29', 'McD Basuki Rachmad', 'jl. basuki rachmad', 'klojen', 'm02', 'cepat saji', '5000', '3', '', '0');
  345. INSERT INTO rm VALUES ('30', 'Depot Yasmine Chinesefood', 'Jl. Raya Tidar H1', 'sukun', 'm05', 'chinesefood', '8000', '3', '', '0');
  346. INSERT INTO rm VALUES ('31', 'warung 9', 'Jl. Raya Langsep No.9A', 'sukun', 'm05', 'chinesefood', '9000', '3', '', '0');
  347. INSERT INTO rm VALUES ('32', 'gardena', 'Jl. Raya Dieng No.31', 'sukun', 'm05', 'chinesefood', '9000', '3', '', '0');
  348. INSERT INTO rm VALUES ('33', 'new hongkong', 'jl. panji suroso', 'blimbing', 'm03', 'chinesefood', '10000', '3', '', '0');
  349. INSERT INTO rm VALUES ('34', 'Warung Steak Kawi', 'Jl. Kawi 18', 'klojen', 'm02', 'internasional', '10000', '3', '', '0');
  350. INSERT INTO rm VALUES ('35', 'iki japanase', 'Jl. Pahlawan Trip No.8-9', 'klojen', 'm02', 'internasional', '10000', '2', '', '0');
  351. INSERT INTO rm VALUES ('36', 'toko oen', 'jl. basuki rachmad', 'klojen', 'm02', 'internasional', '10000', '2', '', '0');
  352. INSERT INTO rm VALUES ('37', 'saboten', 'jl. jakarta', 'klojen', 'm02', 'internasional', '7000', '2', '', '0');
  353. INSERT INTO rm VALUES ('38', 'amsterdam', 'jl. pahlawan trip', 'klojen', 'm02', 'internasional', '10000', '3', '', '0');
  354. INSERT INTO rm VALUES ('39', 'padi', 'Jl. Pahlawan Trip No.19', 'klojen', 'm02', 'internasional', '10000', '3', '', '0');
  355. INSERT INTO rm VALUES ('40', 'mie jogja pak karso', 'jl. Arjuno', 'klojen', 'm02', 'mie', '8000', '2', '', '0');
  356. INSERT INTO rm VALUES ('41', 'depot H&T cui mie', 'jl. kawi atas 43B', 'klojen', 'm02', 'mie', '10000', '1', '', '0');
  357. INSERT INTO rm VALUES ('42', 'pujasera makul', 'Jl. Ahmad Yani 51', 'blimbing', 'm03', 'pujasera', '8000', '3', '', '0');
  358. INSERT INTO rm VALUES ('43', 'terminal kuliner pujasera semanggi', 'Jl. Soekarno Hatta 32', 'lowokwaru', 'm01', 'pujasera', '5000', '3', '', '0');
  359. INSERT INTO rm VALUES ('44', 'pujasera masera', 'Jl. Soekarno Hatta 18', 'lowokwaru', 'm01', 'pujasera', '3000', '3', '', '0');
  360.  
  361. -- ----------------------------
  362. -- Table structure for `rm_bobot`
  363. -- ----------------------------
  364. DROP TABLE IF EXISTS `rm_bobot`;
  365. CREATE TABLE `rm_bobot` (
  366. `id_rm` int(11) NOT NULL AUTO_INCREMENT,
  367. `bobot_jenis_rm` int(11) NOT NULL,
  368. `bobot_harga_rm` int(11) NOT NULL,
  369. `bobot_fasilitas_rm` int(11) NOT NULL,
  370. `bobot_daya_tampung_rm` int(11) NOT NULL,
  371. PRIMARY KEY (`id_rm`)
  372. ) ENGINE=MyISAM AUTO_INCREMENT=45 DEFAULT CHARSET=latin1;
  373.  
  374. -- ----------------------------
  375. -- Records of rm_bobot
  376. -- ----------------------------
  377. INSERT INTO rm_bobot VALUES ('1', '5', '2', '3', '2');
  378. INSERT INTO rm_bobot VALUES ('2', '5', '2', '3', '3');
  379. INSERT INTO rm_bobot VALUES ('3', '5', '2', '2', '2');
  380. INSERT INTO rm_bobot VALUES ('4', '5', '2', '1', '1');
  381. INSERT INTO rm_bobot VALUES ('5', '6', '2', '1', '1');
  382. INSERT INTO rm_bobot VALUES ('6', '6', '2', '2', '2');
  383. INSERT INTO rm_bobot VALUES ('7', '6', '2', '3', '3');
  384. INSERT INTO rm_bobot VALUES ('8', '6', '2', '3', '3');
  385. INSERT INTO rm_bobot VALUES ('9', '6', '2', '3', '3');
  386. INSERT INTO rm_bobot VALUES ('10', '6', '2', '3', '3');
  387. INSERT INTO rm_bobot VALUES ('11', '6', '2', '3', '3');
  388. INSERT INTO rm_bobot VALUES ('12', '6', '2', '3', '3');
  389. INSERT INTO rm_bobot VALUES ('13', '12', '3', '3', '2');
  390. INSERT INTO rm_bobot VALUES ('14', '12', '3', '3', '2');
  391. INSERT INTO rm_bobot VALUES ('15', '8', '3', '2', '2');
  392. INSERT INTO rm_bobot VALUES ('16', '8', '3', '3', '3');
  393. INSERT INTO rm_bobot VALUES ('17', '8', '3', '1', '2');
  394. INSERT INTO rm_bobot VALUES ('18', '8', '3', '1', '2');
  395. INSERT INTO rm_bobot VALUES ('19', '8', '3', '2', '2');
  396. INSERT INTO rm_bobot VALUES ('20', '4', '2', '1', '1');
  397. INSERT INTO rm_bobot VALUES ('21', '4', '2', '1', '1');
  398. INSERT INTO rm_bobot VALUES ('22', '2', '1', '1', '1');
  399. INSERT INTO rm_bobot VALUES ('23', '3', '1', '1', '1');
  400. INSERT INTO rm_bobot VALUES ('24', '3', '1', '2', '3');
  401. INSERT INTO rm_bobot VALUES ('25', '3', '1', '1', '2');
  402. INSERT INTO rm_bobot VALUES ('26', '3', '1', '2', '2');
  403. INSERT INTO rm_bobot VALUES ('27', '7', '3', '3', '3');
  404. INSERT INTO rm_bobot VALUES ('28', '7', '3', '3', '3');
  405. INSERT INTO rm_bobot VALUES ('29', '7', '3', '3', '3');
  406. INSERT INTO rm_bobot VALUES ('30', '10', '2', '3', '3');
  407. INSERT INTO rm_bobot VALUES ('31', '10', '2', '3', '3');
  408. INSERT INTO rm_bobot VALUES ('32', '10', '2', '3', '3');
  409. INSERT INTO rm_bobot VALUES ('33', '10', '2', '3', '3');
  410. INSERT INTO rm_bobot VALUES ('34', '9', '2', '3', '3');
  411. INSERT INTO rm_bobot VALUES ('35', '9', '2', '3', '2');
  412. INSERT INTO rm_bobot VALUES ('36', '9', '2', '3', '2');
  413. INSERT INTO rm_bobot VALUES ('37', '9', '2', '2', '2');
  414. INSERT INTO rm_bobot VALUES ('38', '9', '2', '3', '3');
  415. INSERT INTO rm_bobot VALUES ('39', '9', '2', '3', '3');
  416. INSERT INTO rm_bobot VALUES ('40', '11', '2', '3', '2');
  417. INSERT INTO rm_bobot VALUES ('41', '11', '2', '2', '1');
  418. INSERT INTO rm_bobot VALUES ('42', '1', '1', '2', '3');
  419. INSERT INTO rm_bobot VALUES ('43', '1', '1', '2', '3');
  420. INSERT INTO rm_bobot VALUES ('44', '1', '1', '2', '3');
  421.  
  422. -- ----------------------------
  423. -- Table structure for `user`
  424. -- ----------------------------
  425. DROP TABLE IF EXISTS `user`;
  426. CREATE TABLE `user` (
  427. `user` varchar(30) NOT NULL,
  428. `pass` varchar(60) NOT NULL,
  429. `level` int(11) NOT NULL
  430. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  431.  
  432. -- ----------------------------
  433. -- Records of user
  434. -- ----------------------------
  435. INSERT INTO user VALUES ('admin', 'admin', '1');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement