API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jul 16th, 2018
289
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.15 KB | None | 0 0
raw download clone embed print report
  1. SET FOREIGN_KEY_CHECKS=0;
  2.  
  3. -- ----------------------------
  4. -- Table structure for tbl_alat
  5. -- ----------------------------
  6. DROP TABLE IF EXISTS `tbl_alat`;
  7. CREATE TABLE `tbl_alat` (
  8. `id` int(10) NOT NULL AUTO_INCREMENT,
  9. `nama_alat` varchar(20) DEFAULT NULL,
  10. `jenis_alat` varchar(20) DEFAULT NULL,
  11. `model` varchar(20) DEFAULT NULL,
  12. `tgl_pengadaan` date DEFAULT NULL,
  13. `tgl_operasional` date DEFAULT NULL,
  14. `status` varchar(20) DEFAULT NULL,
  15. `wmoid` int(5) DEFAULT NULL,
  16. PRIMARY KEY (`id`)
  17. ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;
  18.  
  19. -- ----------------------------
  20. -- Records of tbl_alat
  21. -- ----------------------------
  22. INSERT INTO `tbl_alat` VALUES ('3', 'Accelerograph', 'Taide', 'TDL-303QS', '0000-00-00', '2017-10-24', 'Baik', '96745');
  23. INSERT INTO `tbl_alat` VALUES ('4', 'Accelerograph', 'Taide', 'TDL-303QS', '2018-05-03', '2017-10-24', 'Baik', '96745');
  24. INSERT INTO `tbl_alat` VALUES ('5', 'Accelerograph', 'Taide', 'TDL-303QS', '0000-00-00', '2017-10-24', 'Baik', '96733');
  25. INSERT INTO `tbl_alat` VALUES ('6', 'Calibration table', 'Lennartz', 'CT-EW1 290', '0000-00-00', '2017-10-24', 'Baik', '96745');
  26. INSERT INTO `tbl_alat` VALUES ('7', 'Calibration table', 'Lennartz', 'CT-EW1 290', '0000-00-00', '2017-10-24', 'Baik', '96733');
  27. INSERT INTO `tbl_alat` VALUES ('8', 'Dgital anemometer', 'RM Young', 'Wind Monitor', '0000-00-00', '2017-10-24', 'Rusak', '96745');
  28. INSERT INTO `tbl_alat` VALUES ('9', 'Dgital anemometer', 'RM Young', 'Wind Monitor', '2017-10-17', '2017-10-24', 'Rusak', '96733');
  29. INSERT INTO `tbl_alat` VALUES ('10', 'Dgital anemometer', 'Vaisala', 'WMS301', '2014-01-01', '2017-10-24', 'Rusak', '96733');
  30. INSERT INTO `tbl_alat` VALUES ('11', 'Accelerograph', 'Taide', 'TDL-333', '2017-04-01', '2017-10-24', 'Baik', '96101');
  31. INSERT INTO `tbl_alat` VALUES ('12', 'Accelerograph', 'Taide', 'TDL-333', '2017-04-01', '2017-10-24', 'Baik', '96101');
  32. INSERT INTO `tbl_alat` VALUES ('13', 'Accelerograph', 'Taide', 'TDL-333', '2017-01-01', '2017-10-24', 'Baik', '96102');
  33.  
  34. -- ----------------------------
  35. -- Table structure for tbl_data
  36. -- ----------------------------
  37. DROP TABLE IF EXISTS `tbl_data`;
  38. CREATE TABLE `tbl_data` (
  39. `id` int(5) NOT NULL AUTO_INCREMENT,
  40. `wmoid` double DEFAULT NULL,
  41. `Tanggal` date DEFAULT NULL,
  42. `T0700` varchar(255) DEFAULT NULL,
  43. `T1300` varchar(255) DEFAULT NULL,
  44. `T1800` varchar(255) DEFAULT NULL,
  45. `Trata` varchar(255) DEFAULT NULL,
  46. `Tmax` varchar(255) DEFAULT NULL,
  47. `Tmin` varchar(255) DEFAULT NULL,
  48. `CH` varchar(255) DEFAULT NULL,
  49. `LPM` varchar(255) DEFAULT NULL,
  50. `Cuaca Khusus` varchar(255) DEFAULT NULL,
  51. `QFF` varchar(255) DEFAULT NULL,
  52. `QFE` varchar(255) DEFAULT NULL,
  53. `RH0700` varchar(255) DEFAULT NULL,
  54. `RH1300` varchar(255) DEFAULT NULL,
  55. `RH1800` varchar(255) DEFAULT NULL,
  56. `Rhrata` varchar(255) DEFAULT NULL,
  57. `ffrata` varchar(255) DEFAULT NULL,
  58. `dd` varchar(255) DEFAULT NULL,
  59. `ffmax` varchar(255) DEFAULT NULL,
  60. `ddmax` varchar(255) DEFAULT NULL,
  61. PRIMARY KEY (`id`)
  62. ) ENGINE=InnoDB AUTO_INCREMENT=5100 DEFAULT CHARSET=latin1;
  63.  
  64. -- ----------------------------
  65. -- Records of tbl_data
  66. -- ----------------------------
  67. INSERT INTO `tbl_data` VALUES ('1', '96749', '1994-02-01', '17.4', '26.6', '23', '21.1', '33.2', '17.2', '0.2', '67', '', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999');
  68. INSERT INTO `tbl_data` VALUES ('2', '96749', '1994-02-02', '17', '26.2', '22.8', '20.75', '28.2', '16.8', '9999', '58', '', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999');
  69. INSERT INTO `tbl_data` VALUES ('3', '96749', '1994-02-03', '19', '24.8', '23.6', '21.6', '27.8', '18.2', '0.3', '31', '', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999');
  70. INSERT INTO `tbl_data` VALUES ('4', '96749', '1994-02-04', '20', '25.4', '23.6', '22.25', '27.2', '18.4', '7', '14', '', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999');
  71. INSERT INTO `tbl_data` VALUES ('5', '96749', '1994-02-05', '17.8', '28', '23.2', '21.7', '33.1', '17.4', '3.7', '77', '', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999');
  72. INSERT INTO `tbl_data` VALUES ('6', '96749', '1994-02-06', '19.2', '27.8', '24.8', '22.75', '28.8', '18.7', '9999', '96', '', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999');
  73. INSERT INTO `tbl_data` VALUES ('7', '96749', '1994-02-07', '20.1', '27.8', '24', '23', '29', '19.2', '9999', '89', '', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999');
  74. INSERT INTO `tbl_data` VALUES ('8', '96749', '1994-02-08', '20.4', '24.2', '21.8', '21.7', '26.4', '19.5', '29', '5', '', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999');
  75. INSERT INTO `tbl_data` VALUES ('9', '96749', '1994-02-09', '20.6', '23', '22.2', '21.6', '25.8', '20.6', '4.5', '2', '', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999');
  76. INSERT INTO `tbl_data` VALUES ('10', '96749', '1994-02-10', '20.8', '25.4', '23.6', '22.65', '28', '20.1', '15.3', '90', '', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999');
  77. INSERT INTO `tbl_data` VALUES ('11', '96749', '1994-02-11', '20.8', '27.3', '25.2', '23525', '29.1', '19.4', '1.6', '91', '', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999');
  78. INSERT INTO `tbl_data` VALUES ('12', '96749', '1994-02-12', '20.6', '20.4', '20', '20.4', '26.5', '19.8', 'TTU', '0', '', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999');
  79. INSERT INTO `tbl_data` VALUES ('13', '96749', '1994-02-13', '20', '25.2', '22.6', '21.95', '26.4', '18.6', '26', '64', '', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999');
  80. INSERT INTO `tbl_data` VALUES ('14', '96749', '1994-02-14', '21.5', '26.8', '22.8', '23.15', '27.6', '20.3', '3.4', '72', '', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999');
  81. INSERT INTO `tbl_data` VALUES ('15', '96749', '1994-02-15', '21', '26.6', '23', '22.9', '28', '17.2', '9999', '97', '', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999');
  82. INSERT INTO `tbl_data` VALUES ('16', '96749', '1994-02-16', '21', '23.8', '22.2', '22', '27', '17.2', '9999', '57', '', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999');
  83. INSERT INTO `tbl_data` VALUES ('17', '96749', '1994-02-17', '17.2', '26.4', '22.4', '20.8', '27.6', '15.8', '0.8', '85', '', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999');
  84. INSERT INTO `tbl_data` VALUES ('18', '96749', '1994-02-18', '18.8', '25.8', '22.8', '21.55', '27.4', '17.8', '7.3', '90', '', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999');
  85. INSERT INTO `tbl_data` VALUES ('19', '96749', '1994-02-19', '21', '26.2', '22.2', '22.6', '26.9', '19', '9999', '74', '', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999');
  86. INSERT INTO `tbl_data` VALUES ('20', '96749', '1994-02-20', '21', '26.4', '23.4', '22.95', '27.8', '19', '9999', '89', '', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999');
  87. INSERT INTO `tbl_data` VALUES ('21', '96749', '1994-02-21', '19.6', '26.6', '22.8', '22.15', '27.2', '18.4', '0.4', '100', '', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999');
  88. INSERT INTO `tbl_data` VALUES ('22', '96749', '1994-02-22', '21.2', '26.2', '22.4', '22.75', '28.4', '18.6', '9999', '70', '', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999');
  89. INSERT INTO `tbl_data` VALUES ('23', '96749', '1994-02-23', '21.4', '25.4', '22.2', '22.6', '26.9', '18.4', '9999', '75', '', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999');
  90. INSERT INTO `tbl_data` VALUES ('24', '96749', '1994-02-24', '28.1', '25.4', '23.5', '26275', '26.9', '17.5', '9999', '69', '', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999');
  91. INSERT INTO `tbl_data` VALUES ('25', '96749', '1994-02-25', '20.8', '26', '23.8', '22.85', '27.4', '17.4', '9999', '58', '', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999');
  92. INSERT INTO `tbl_data` VALUES ('26', '96749', '1994-02-26', '21.5', '26', '22.7', '22925', '27.2', '20.9', '9999', '78', '', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999');
  93. INSERT INTO `tbl_data` VALUES ('27', '96749', '1994-02-27', '20.3', '27', '22.6', '22.55', '27.6', '19.4', '0.4', '85', '', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999');
  94. INSERT INTO `tbl_data` VALUES ('28', '96749', '1994-02-28', '20.6', '25.6', '23', '22.45', '27.8', '19.5', '9999', '73', '', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999', '9999');
  95. INSERT INTO `tbl_data` VALUES ('29', '96749', '1994-03-01', '19.2', '26', '23.2', '21.9', '29', '18.2', '9999', '72', '', '9999', '9999', '96', '75', '86', '88.25', '3.93', 'U', '9.09', 'U');
  96.  
  97. -- ----------------------------
  98. -- Table structure for tbl_pegawai
  99. -- ----------------------------
  100. DROP TABLE IF EXISTS `tbl_pegawai`;
  101. CREATE TABLE `tbl_pegawai` (
  102. `id` int(11) NOT NULL AUTO_INCREMENT,
  103. `WMOID` int(11) DEFAULT NULL,
  104. `Nama` varchar(40) DEFAULT NULL,
  105. `NIP` varchar(18) DEFAULT NULL,
  106. `Gol` varchar(3) DEFAULT NULL,
  107. `Jabatan` varchar(30) DEFAULT NULL,
  108. `telepon` double DEFAULT NULL,
  109. `Email` varchar(30) DEFAULT NULL,
  110. PRIMARY KEY (`id`)
  111. ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;
  112.  
  113. -- ----------------------------
  114. -- Records of tbl_pegawai
  115. -- ----------------------------
  116. INSERT INTO `tbl_pegawai` VALUES ('11', '96733', 'I GUSTI MADE SUARDIKA, SP', '196007171983031000', 'III', 'KEPALA', '81338453424', 'agungsuardika@gmail.com');
  117. INSERT INTO `tbl_pegawai` VALUES ('12', '96733', 'SUROSO PRAMONO, SP', '195911191985031000', 'IVa', 'PMG', '81338712064', 'suroso.pramono@gmail.com');
  118. INSERT INTO `tbl_pegawai` VALUES ('13', '96733', 'I WAYAN SUDANA', '196203281985031000', 'III', 'TEKNISI', '81337073664', 'sudana2803@gmail.com');
  119. INSERT INTO `tbl_pegawai` VALUES ('14', '96733', 'I WAYAN RIKSA WIBAWA', '197105011994031000', 'III', 'TEKNISI', '81338261504', 'riksawbw319@gmail.com');
  120. INSERT INTO `tbl_pegawai` VALUES ('15', '96733', 'ZAILAND HARISDA, ST', '197105301992022000', 'IVa', 'PMG', '81558740992', 'za_ilend@yahoo.co.id');
  121. INSERT INTO `tbl_pegawai` VALUES ('16', '96745', 'I KOMANG SUSILA', '197112311994031000', 'III', 'TEKNISI', '81316315136', 'komangsusila7@gmail.com');
  122. INSERT INTO `tbl_pegawai` VALUES ('17', '96745', 'I GEDE MONY ARTHA, ST', '198108102008121000', 'III', 'PMG', '81916674048', 'mony.artha@gmail.com');
  123. INSERT INTO `tbl_pegawai` VALUES ('18', '96745', 'PANDE GEDE WIPRADNYANA', '198404222008011000', 'III', 'TEKNISI', '85738430464', 'pande.wipradnyana@gmail.com');
  124. INSERT INTO `tbl_pegawai` VALUES ('19', '96835', 'SAIFUL ROHMAN', '198610272008011000', 'III', 'TEKNISI', '81337049088', 'saiful86rohman@gmail.com');
  125. INSERT INTO `tbl_pegawai` VALUES ('20', '96835', 'SETIYA PURNAWAN', '198706132012121000', 'III', 'TEKNISI', '81236312064', 'e.setiyapurnawan@gmail.com');
  126.  
  127. -- ----------------------------
  128. -- Table structure for tbl_stasiun
  129. -- ----------------------------
  130. DROP TABLE IF EXISTS `tbl_stasiun`;
  131. CREATE TABLE `tbl_stasiun` (
  132. `id` int(11) NOT NULL AUTO_INCREMENT,
  133. `wmoid` int(5) NOT NULL,
  134. `nama_stasiun` varchar(30) NOT NULL,
  135. `lat` float(10,4) NOT NULL,
  136. `long` float(10,4) NOT NULL,
  137. `elev` varchar(5) NOT NULL,
  138. `alamat` varchar(50) NOT NULL,
  139. `kontak` varchar(13) NOT NULL,
  140. `email` varchar(30) NOT NULL,
  141. `website` varchar(20) NOT NULL,
  142. `nama_kaupt` varchar(30) NOT NULL,
  143. PRIMARY KEY (`id`),
  144. UNIQUE KEY `wmoid` (`wmoid`)
  145. ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
  146.  
  147. -- ----------------------------
  148. -- Records of tbl_stasiun
  149. -- ----------------------------
  150. INSERT INTO `tbl_stasiun` VALUES ('3', '96745', 'stasiun kemayoran', '0.0000', '0.0000', '', '', '', '', '', '');
  151. INSERT INTO `tbl_stasiun` VALUES ('4', '96733', 'stasiun pondok betung', '0.0000', '0.0000', '', '', '', '', '', '');
  152. INSERT INTO `tbl_stasiun` VALUES ('5', '96749', 'Stamet Cengkareng', '0.0000', '0.0000', '', '', '', '', '', '');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!