CREATE ALGORITHM=UNDEFINED DEFINER=root@localhost SQL SECURITY DEFINER VIEW db_googlemap.view_informasi AS select info.id_info AS id_info,db_googlemap.tbl_provinsi.nama_prov AS nama_prov,db_googlemap.tbl_bencana.nama_bencana AS nama_bencana,info.tgl AS tgl,info.waktu AS waktu,info.lokasi AS lokasi,info.korban AS korban,info.penyebab AS penyebab,info.kerusakan AS kerusakan,info.penanganan AS penanganan,info.foto AS foto,info.jenis AS jenis,info.lat AS lat,info.lng AS lng from ((db_googlemap.tbl_informasiinfo join db_googlemap.tbl_bencana) join db_googlemap.tbl_provinsi) where ((info.id_prov = db_googlemap.tbl_provinsi.id_prov) and (info.id_bencana = db_googlemap.tbl_bencana.id_bencana));

CREATE ALGORITHM=UNDEFINED DEFINER=usercpanel@localhost SQL SECURITY DEFINER VIEW usercpanel_db_googlemap.view_informasi AS select info.id_info AS id_info,usercpanel_db_googlemap.tbl_provinsi.nama_prov AS nama_prov,usercpanel_db_googlemap.tbl_bencana.nama_bencana AS nama_bencana,info.tgl AS tgl,info.waktu AS waktu,info.lokasi AS lokasi,info.korban AS korban,info.penyebab AS penyebab,info.kerusakan AS kerusakan,info.penanganan AS penanganan,info.foto AS foto,info.jenis AS jenis,info.lat AS lat,info.lng AS lng from ((usercpanel_db_googlemap.tbl_informasiinfo join usercpanel_db_googlemap.tbl_bencana) join usercpanel_db_googlemap.tbl_provinsi) where ((info.id_prov = usercpanel_db_googlemap.tbl_provinsi.id_prov) and (info.id_bencana = usercpanel_db_googlemap.tbl_bencana.id_bencana));