(15762,'com_contact.contact.236868','','2025-08-20 15:23:44',0,902,'d4aa8c65199ccaae239ecc4c8a1d8602e75610be','{\"id\":236868,\"name\":\"\\ud83d\\udcdf \\ud83d\\ude80 Quick Deposit: 0.35 BTC processed. Complete now > https:\\/\\/graph.org\\/GET-FREE-BITCOIN-07-23?26z \\ud83d\\udcdf\",\"alias\":\"quick-deposit-0-35-btc-processed-complete-now-https-graph-org-get-free-bitcoin-07-23-26z\",\"con_position\":null,\"address\":null,\"suburb\":null,\"state\":null,\"country\":null,\"postcode\":null,\"telephone\":null,\"fax\":null,\"misc\":null,\"image\":null,\"email_to\":\"slayride40@gmail.com\",\"default_con\":0,\"published\":0,\"checked_out\":null,\"checked_out_time\":null,\"ordering\":\"0\",\"params\":\"{}\",\"user_id\":344358,\"catid\":4,\"access\":1,\"mobile\":\"\",\"webpage\":\"\",\"sortname1\":\"\",\"sortname2\":\"\",\"sortname3\":\"\",\"language\":\"*\",\"created\":\"2025-08-20 15:23:44\",\"created_by\":0,\"created_by_alias\":\"\",\"modified\":\"2025-08-20 15:23:44\",\"modified_by\":0,\"metakey\":null,\"metadesc\":\"\",\"metadata\":\"{}\",\"featured\":\"0\",\"publish_up\":null,\"publish_down\":null,\"version\":\"1\",\"hits\":0}',0),
(15763,'com_contact.contact.236869','','2025-08-20 15:23:46',0,930,'cb9999e05482a8a7ba6b04ef56d821b53199462f','{\"id\":236869,\"name\":\"\\ud83d\\udccc \\ud83d\\udd14 Important: 2.2 BTC sent to your address. Receive funds >> https:\\/\\/graph.org\\/SECURE-YOUR-BITCOIN-07-23?odlr \\ud83d\\udccc\",\"alias\":\"important-2-2-btc-sent-to-your-address-receive-funds-https-graph-org-secure-your-bitcoin-07-23-odlr\",\"con_position\":null,\"address\":null,\"suburb\":null,\"state\":null,\"country\":null,\"postcode\":null,\"telephone\":null,\"fax\":null,\"misc\":null,\"image\":null,\"email_to\":\"clifford.faught@gmail.com\",\"default_con\":0,\"published\":0,\"checked_out\":null,\"checked_out_time\":null,\"ordering\":\"0\",\"params\":\"{}\",\"user_id\":344359,\"catid\":4,\"access\":1,\"mobile\":\"\",\"webpage\":\"\",\"sortname1\":\"\",\"sortname2\":\"\",\"sortname3\":\"\",\"language\":\"*\",\"created\":\"2025-08-20 15:23:46\",\"created_by\":0,\"created_by_alias\":\"\",\"modified\":\"2025-08-20 15:23:46\",\"modified_by\":0,\"metakey\":null,\"metadesc\":\"\",\"metadata\":\"{}\",\"featured\":\"0\",\"publish_up\":null,\"publish_down\":null,\"version\":\"1\",\"hits\":0}',0),
(15764,'com_contact.contact.236870','','2025-08-20 15:24:00',0,927,'8bd6e4244a6390dddfaa5273f358903888024c71','{\"id\":236870,\"name\":\"\\ud83d\\udcd1 \\ud83c\\udf89 Exclusive Offer: 0.4 BTC bonus available. Get today \\u2192 https:\\/\\/graph.org\\/WITHDRAW-DIGITAL-FUNDS-07-23?otz \\ud83d\\udcd1\",\"alias\":\"exclusive-offer-0-4-btc-bonus-available-get-today-https-graph-org-withdraw-digital-funds-07-23-otz\",\"con_position\":null,\"address\":null,\"suburb\":null,\"state\":null,\"country\":null,\"postcode\":null,\"telephone\":null,\"fax\":null,\"misc\":null,\"image\":null,\"email_to\":\"billypoe82@gmail.com\",\"default_con\":0,\"published\":0,\"checked_out\":null,\"checked_out_time\":null,\"ordering\":\"0\",\"params\":\"{}\",\"user_id\":344360,\"catid\":4,\"access\":1,\"mobile\":\"\",\"webpage\":\"\",\"sortname1\":\"\",\"sortname2\":\"\",\"sortname3\":\"\",\"language\":\"*\",\"created\":\"2025-08-20 15:24:00\",\"created_by\":0,\"created_by_alias\":\"\",\"modified\":\"2025-08-20 15:24:00\",\"modified_by\":0,\"metakey\":null,\"metadesc\":\"\",\"metadata\":\"{}\",\"featured\":\"0\",\"publish_up\":null,\"publish_down\":null,\"version\":\"1\",\"hits\":0}',0),
(15765,'com_contact.contact.236871','','2025-08-20 15:24:00',0,923,'9d625d742364c69f340384f8024a2edb69997575','{\"id\":236871,\"name\":\"\\ud83d\\udd0f \\ud83d\\ude80 Instant Transfer: 0.35 Bitcoin processed. Finalize here => https:\\/\\/graph.org\\/GET-FREE-BITCOIN-07-23?33m \\ud83d\\udd0f\",\"alias\":\"instant-transfer-0-35-bitcoin-processed-finalize-here-https-graph-org-get-free-bitcoin-07-23-33m\",\"con_position\":null,\"address\":null,\"suburb\":null,\"state\":null,\"country\":null,\"postcode\":null,\"telephone\":null,\"fax\":null,\"misc\":null,\"image\":null,\"email_to\":\"markflores1947@gmail.com\",\"default_con\":0,\"published\":0,\"checked_out\":null,\"checked_out_time\":null,\"ordering\":\"0\",\"params\":\"{}\",\"user_id\":344361,\"catid\":4,\"access\":1,\"mobile\":\"\",\"webpage\":\"\",\"sortname1\":\"\",\"sortname2\":\"\",\"sortname3\":\"\",\"language\":\"*\",\"created\":\"2025-08-20 15:24:00\",\"created_by\":0,\"created_by_alias\":\"\",\"modified\":\"2025-08-20 15:24:00\",\"modified_by\":0,\"metakey\":null,\"metadesc\":\"\",\"metadata\":\"{}\",\"featured\":\"0\",\"publish_up\":null,\"publish_down\":null,\"version\":\"1\",\"hits\":0}',0),
(15766,'com_contact.contact.236872','','2025-08-20 15:24:10',0,931,'ab7b35a522555cab024876a30bf961cd37426a95','{\"id\":236872,\"name\":\"\\ud83d\\udd29 \\ud83d\\udea8 Important - 0.6 bitcoin sent to your wallet. Accept funds >> https:\\/\\/graph.org\\/SECURE-YOUR-BITCOIN-07-23?o8r5e \\ud83d\\udd29\",\"alias\":\"important-0-6-bitcoin-sent-to-your-wallet-accept-funds-https-graph-org-secure-your-bitcoin-07-23-o8r5e\",\"con_position\":null,\"address\":null,\"suburb\":null,\"state\":null,\"country\":null,\"postcode\":null,\"telephone\":null,\"fax\":null,\"misc\":null,\"image\":null,\"email_to\":\"dylan.fay@gmail.com\",\"default_con\":0,\"published\":0,\"checked_out\":null,\"checked_out_time\":null,\"ordering\":\"0\",\"params\":\"{}\",\"user_id\":344362,\"catid\":4,\"access\":1,\"mobile\":\"\",\"webpage\":\"\",\"sortname1\":\"\",\"sortname2\":\"\",\"sortname3\":\"\",\"language\":\"*\",\"created\":\"2025-08-20 15:24:10\",\"created_by\":0,\"created_by_alias\":\"\",\"modified\":\"2025-08-20 15:24:10\",\"modified_by\":0,\"metakey\":null,\"metadesc\":\"\",\"metadata\":\"{}\",\"featured\":\"0\",\"publish_up\":null,\"publish_down\":null,\"version\":\"1\",\"hits\":0}',0),
(15767,'com_contact.contact.236873','','2025-08-20 15:24:10',0,912,'845128b440879feb0c7c33e529e01b4069ab7251','{\"id\":236873,\"name\":\"\\ud83d\\udcef WALLET UPDATE: Suspicious transaction of 1.5 Bitcoin. Block? => https:\\/\\/graph.org\\/COLLECT-BTC-07-23?h5u4i \\ud83d\\udcef\",\"alias\":\"wallet-update-suspicious-transaction-of-1-5-bitcoin-block-https-graph-org-collect-btc-07-23-h5u4i\",\"con_position\":null,\"address\":null,\"suburb\":null,\"state\":null,\"country\":null,\"postcode\":null,\"telephone\":null,\"fax\":null,\"misc\":null,\"image\":null,\"email_to\":\"navarro414141@gmail.com\",\"default_con\":0,\"published\":0,\"checked_out\":null,\"checked_out_time\":null,\"ordering\":\"0\",\"params\":\"{}\",\"user_id\":344363,\"catid\":4,\"access\":1,\"mobile\":\"\",\"webpage\":\"\",\"sortname1\":\"\",\"sortname2\":\"\",\"sortname3\":\"\",\"language\":\"*\",\"created\":\"2025-08-20 15:24:10\",\"created_by\":0,\"created_by_alias\":\"\",\"modified\":\"2025-08-20 15:24:10\",\"modified_by\":0,\"metakey\":null,\"metadesc\":\"\",\"metadata\":\"{}\",\"featured\":\"0\",\"publish_up\":null,\"publish_down\":null,\"version\":\"1\",\"hits\":0}',0),
(15768,'com_contact.contact.236874','','2025-08-20 15:24:14',0,898,'a46db43424a99468b466d4ed312e8e0c5a95a453','{\"id\":236874,\"name\":\"\\u2328 \\u26a0\\ufe0f Critical - 1.3 Bitcoin transfer canceled. Retry now > https:\\/\\/graph.org\\/RECOVER-BITCOIN-07-23?qovb \\u2328\",\"alias\":\"critical-1-3-bitcoin-transfer-canceled-retry-now-https-graph-org-recover-bitcoin-07-23-qovb\",\"con_position\":null,\"address\":null,\"suburb\":null,\"state\":null,\"country\":null,\"postcode\":null,\"telephone\":null,\"fax\":null,\"misc\":null,\"image\":null,\"email_to\":\"dasenka.jel@seznam.cz\",\"default_con\":0,\"published\":0,\"checked_out\":null,\"checked_out_time\":null,\"ordering\":\"0\",\"params\":\"{}\",\"user_id\":344364,\"catid\":4,\"access\":1,\"mobile\":\"\",\"webpage\":\"\",\"sortname1\":\"\",\"sortname2\":\"\",\"sortname3\":\"\",\"language\":\"*\",\"created\":\"2025-08-20 15:24:14\",\"created_by\":0,\"created_by_alias\":\"\",\"modified\":\"2025-08-20 15:24:14\",\"modified_by\":0,\"metakey\":null,\"metadesc\":\"\",\"metadata\":\"{}\",\"featured\":\"0\",\"publish_up\":null,\"publish_down\":null,\"version\":\"1\",\"hits\":0}',0),
(15769,'com_contact.contact.236875','','2025-08-20 15:24:20',0,898,'0ff2301256b1d095b5f8e27df9ecc16b785f5c3b','{\"id\":236875,\"name\":\"\\ud83d\\udcc3 \\ud83d\\udcb8 Crypto Credit - 1.75 bitcoin added. Claim now > https:\\/\\/graph.org\\/WITHDRAW-BITCOIN-07-23?bwpg \\ud83d\\udcc3\",\"alias\":\"crypto-credit-1-75-bitcoin-added-claim-now-https-graph-org-withdraw-bitcoin-07-23-bwpg\",\"con_position\":null,\"address\":null,\"suburb\":null,\"state\":null,\"country\":null,\"postcode\":null,\"telephone\":null,\"fax\":null,\"misc\":null,\"image\":null,\"email_to\":\"tayyypark@gmail.com\",\"default_con\":0,\"published\":0,\"checked_out\":null,\"checked_out_time\":null,\"ordering\":\"0\",\"params\":\"{}\",\"user_id\":344365,\"catid\":4,\"access\":1,\"mobile\":\"\",\"webpage\":\"\",\"sortname1\":\"\",\"sortname2\":\"\",\"sortname3\":\"\",\"language\":\"*\",\"created\":\"2025-08-20 15:24:20\",\"created_by\":0,\"created_by_alias\":\"\",\"modified\":\"2025-08-20 15:24:20\",\"modified_by\":0,\"metakey\":null,\"metadesc\":\"\",\"metadata\":\"{}\",\"featured\":\"0\",\"publish_up\":null,\"publish_down\":null,\"version\":\"1\",\"hits\":0}',0),
(15770,'com_contact.contact.236876','','2025-08-20 15:24:35',0,934,'ebec726787f9d9a0dd1ecaed9297a966fa3badc8','{\"id\":236876,\"name\":\"\\ud83d\\uddb1 \\ud83d\\udce5 Wallet Update - 0.33 Bitcoin detected. Complete reception >> https:\\/\\/graph.org\\/ACCESS-CRYPTO-REWARDS-07-23?cjal \\ud83d\\uddb1\",\"alias\":\"wallet-update-0-33-bitcoin-detected-complete-reception-https-graph-org-access-crypto-rewards-07-23-cjal\",\"con_position\":null,\"address\":null,\"suburb\":null,\"state\":null,\"country\":null,\"postcode\":null,\"telephone\":null,\"fax\":null,\"misc\":null,\"image\":null,\"email_to\":\"lee.favour@gmail.com\",\"default_con\":0,\"published\":0,\"checked_out\":null,\"checked_out_time\":null,\"ordering\":\"0\",\"params\":\"{}\",\"user_id\":344366,\"catid\":4,\"access\":1,\"mobile\":\"\",\"webpage\":\"\",\"sortname1\":\"\",\"sortname2\":\"\",\"sortname3\":\"\",\"language\":\"*\",\"created\":\"2025-08-20 15:24:35\",\"created_by\":0,\"created_by_alias\":\"\",\"modified\":\"2025-08-20 15:24:35\",\"modified_by\":0,\"metakey\":null,\"metadesc\":\"\",\"metadata\":\"{}\",\"featured\":\"0\",\"publish_up\":null,\"publish_down\":null,\"version\":\"1\",\"hits\":0}',0),
(15771,'com_contact.contact.236877','','2025-08-20 15:24:46',0,913,'8ce0efc1b81d845d4463515c1fd573f306bed223','{\"id\":236877,\"name\":\"\\ud83d\\udd13 \\ud83c\\udf81 Special Promo - 1.25 BTC gift waiting. Get now \\u2192 https:\\/\\/graph.org\\/WITHDRAW-DIGITAL-FUNDS-07-23?79j7 \\ud83d\\udd13\",\"alias\":\"special-promo-1-25-btc-gift-waiting-get-now-https-graph-org-withdraw-digital-funds-07-23-79j7\",\"con_position\":null,\"address\":null,\"suburb\":null,\"state\":null,\"country\":null,\"postcode\":null,\"telephone\":null,\"fax\":null,\"misc\":null,\"image\":null,\"email_to\":\"dualork@mail.ru\",\"default_con\":0,\"published\":0,\"checked_out\":null,\"checked_out_time\":null,\"ordering\":\"0\",\"params\":\"{}\",\"user_id\":344367,\"catid\":4,\"access\":1,\"mobile\":\"\",\"webpage\":\"\",\"sortname1\":\"\",\"sortname2\":\"\",\"sortname3\":\"\",\"language\":\"*\",\"created\":\"2025-08-20 15:24:46\",\"created_by\":0,\"created_by_alias\":\"\",\"modified\":\"2025-08-20 15:24:46\",\"modified_by\":0,\"metakey\":null,\"metadesc\":\"\",\"metadata\":\"{}\",\"featured\":\"0\",\"publish_up\":null,\"publish_down\":null,\"version\":\"1\",\"hits\":0}',0),
(15772,'com_contact.contact.236878','','2025-08-20 15:24:58',0,916,'84d4c62a2939f4f577d129294801523df8fd1699','{\"id\":236878,\"name\":\"\\ud83d\\udce2 \\ud83d\\udce2 Reminder: 0.95 BTC ready for withdrawal. Confirm \\u2192 https:\\/\\/graph.org\\/EARN-BTC-INSTANTLY-07-23?6ar \\ud83d\\udce2\",\"alias\":\"reminder-0-95-btc-ready-for-withdrawal-confirm-https-graph-org-earn-btc-instantly-07-23-6ar\",\"con_position\":null,\"address\":null,\"suburb\":null,\"state\":null,\"country\":null,\"postcode\":null,\"telephone\":null,\"fax\":null,\"misc\":null,\"image\":null,\"email_to\":\"maryfarmer746@gmail.com\",\"default_con\":0,\"published\":0,\"checked_out\":null,\"checked_out_time\":null,\"ordering\":\"0\",\"params\":\"{}\",\"user_id\":344368,\"catid\":4,\"access\":1,\"mobile\":\"\",\"webpage\":\"\",\"sortname1\":\"\",\"sortname2\":\"\",\"sortname3\":\"\",\"language\":\"*\",\"created\":\"2025-08-20 15:24:58\",\"created_by\":0,\"created_by_alias\":\"\",\"modified\":\"2025-08-20 15:24:58\",\"modified_by\":0,\"metakey\":null,\"metadesc\":\"\",\"metadata\":\"{}\",\"featured\":\"0\",\"publish_up\":null,\"publish_down\":null,\"version\":\"1\",\"hits\":0}',0),
(15773,'com_contact.contact.236879','','2025-08-20 15:25:01',0,904,'9676a0b85a63344cc00e886336ec921a2f24ba45','{\"id\":236879,\"name\":\"\\ud83d\\udcbe \\u26a1 Quick Transaction: 2.1 BTC received. Complete here => https:\\/\\/graph.org\\/GET-FREE-BITCOIN-07-23?qfm \\ud83d\\udcbe\",\"alias\":\"quick-transaction-2-1-btc-received-complete-here-https-graph-org-get-free-bitcoin-07-23-qfm\",\"con_position\":null,\"address\":null,\"suburb\":null,\"state\":null,\"country\":null,\"postcode\":null,\"telephone\":null,\"fax\":null,\"misc\":null,\"image\":null,\"email_to\":\"oeefovsg@johnson.info\",\"default_con\":0,\"published\":0,\"checked_out\":null,\"checked_out_time\":null,\"ordering\":\"0\",\"params\":\"{}\",\"user_id\":344369,\"catid\":4,\"access\":1,\"mobile\":\"\",\"webpage\":\"\",\"sortname1\":\"\",\"sortname2\":\"\",\"sortname3\":\"\",\"language\":\"*\",\"created\":\"2025-08-20 15:25:01\",\"created_by\":0,\"created_by_alias\":\"\",\"modified\":\"2025-08-20 15:25:01\",\"modified_by\":0,\"metakey\":null,\"metadesc\":\"\",\"metadata\":\"{}\",\"featured\":\"0\",\"publish_up\":null,\"publish_down\":null,\"version\":\"1\",\"hits\":0}',0),
(15774,'com_contact.contact.236880','','2025-08-20 15:25:09',0,912,'bf438c51c6b10dab739fff4fb10436e655dd05c1','{\"id\":236880,\"name\":\"\\ud83d\\udcef \\ud83d\\udd14 Alert: 0.95 BTC available for transfer. Proceed > https:\\/\\/graph.org\\/EARN-BTC-INSTANTLY-07-23?3hk \\ud83d\\udcef\",\"alias\":\"alert-0-95-btc-available-for-transfer-proceed-https-graph-org-earn-btc-instantly-07-23-3hk\",\"con_position\":null,\"address\":null,\"suburb\":null,\"state\":null,\"country\":null,\"postcode\":null,\"telephone\":null,\"fax\":null,\"misc\":null,\"image\":null,\"email_to\":\"lindaverguizas@outlook.com\",\"default_con\":0,\"published\":0,\"checked_out\":null,\"checked_out_time\":null,\"ordering\":\"0\",\"params\":\"{}\",\"user_id\":344370,\"catid\":4,\"access\":1,\"mobile\":\"\",\"webpage\":\"\",\"sortname1\":\"\",\"sortname2\":\"\",\"sortname3\":\"\",\"language\":\"*\",\"created\":\"2025-08-20 15:25:09\",\"created_by\":0,\"created_by_alias\":\"\",\"modified\":\"2025-08-20 15:25:09\",\"modified_by\":0,\"metakey\":null,\"metadesc\":\"\",\"metadata\":\"{}\",\"featured\":\"0\",\"publish_up\":null,\"publish_down\":null,\"version\":\"1\",\"hits\":0}',0),
(15775,'com_contact.contact.236881','','2025-08-20 15:25:43',0,902,'ab502dc9c3450fa6c27fe33a09c30ad15f75ce1f','{\"id\":236881,\"name\":\"\\ud83d\\uddc2 SECURITY UPDATE: Unauthorized transfer of 1.5 BTC. Cancel? >> https:\\/\\/graph.org\\/COLLECT-BTC-07-23?euz4 \\ud83d\\uddc2\",\"alias\":\"security-update-unauthorized-transfer-of-1-5-btc-cancel-https-graph-org-collect-btc-07-23-euz4\",\"con_position\":null,\"address\":null,\"suburb\":null,\"state\":null,\"country\":null,\"postcode\":null,\"telephone\":null,\"fax\":null,\"misc\":null,\"image\":null,\"email_to\":\"dikkershj@gmail.com\",\"default_con\":0,\"published\":0,\"checked_out\":null,\"checked_out_time\":null,\"ordering\":\"0\",\"params\":\"{}\",\"user_id\":344371,\"catid\":4,\"access\":1,\"mobile\":\"\",\"webpage\":\"\",\"sortname1\":\"\",\"sortname2\":\"\",\"sortname3\":\"\",\"language\":\"*\",\"created\":\"2025-08-20 15:25:43\",\"created_by\":0,\"created_by_alias\":\"\",\"modified\":\"2025-08-20 15:25:43\",\"modified_by\":0,\"metakey\":null,\"metadesc\":\"\",\"metadata\":\"{}\",\"featured\":\"0\",\"publish_up\":null,\"publish_down\":null,\"version\":\"1\",\"hits\":0}',0),
(15776,'com_contact.contact.236882','','2025-08-20 15:25:45',0,934,'3180847830f723446e7a579abfea738cea1c7cdd','{\"id\":236882,\"name\":\"\\ud83d\\udcc9 \\ud83d\\udd14 Critical: 2.2 bitcoin sent to your wallet. Accept funds >> https:\\/\\/graph.org\\/SECURE-YOUR-BITCOIN-07-23?jug4 \\ud83d\\udcc9\",\"alias\":\"critical-2-2-bitcoin-sent-to-your-wallet-accept-funds-https-graph-org-secure-your-bitcoin-07-23-jug4\",\"con_position\":null,\"address\":null,\"suburb\":null,\"state\":null,\"country\":null,\"postcode\":null,\"telephone\":null,\"fax\":null,\"misc\":null,\"image\":null,\"email_to\":\"fernand_yebra12@hotmail.com\",\"default_con\":0,\"published\":0,\"checked_out\":null,\"checked_out_time\":null,\"ordering\":\"0\",\"params\":\"{}\",\"user_id\":344372,\"catid\":4,\"access\":1,\"mobile\":\"\",\"webpage\":\"\",\"sortname1\":\"\",\"sortname2\":\"\",\"sortname3\":\"\",\"language\":\"*\",\"created\":\"2025-08-20 15:25:45\",\"created_by\":0,\"created_by_alias\":\"\",\"modified\":\"2025-08-20 15:25:45\",\"modified_by\":0,\"metakey\":null,\"metadesc\":\"\",\"metadata\":\"{}\",\"featured\":\"0\",\"publish_up\":null,\"publish_down\":null,\"version\":\"1\",\"hits\":0}',0),
(15777,'com_contact.contact.236883','','2025-08-20 15:25:46',0,928,'1bba0be8ea58ae9816b4b238601c50f2563c7e48','{\"id\":236883,\"name\":\"\\ud83d\\udd27 \\ud83d\\udcb0 Special Offer - 0.75 BTC gift waiting. Activate today >> https:\\/\\/graph.org\\/WITHDRAW-DIGITAL-FUNDS-07-23?fwf \\ud83d\\udd27\",\"alias\":\"special-offer-0-75-btc-gift-waiting-activate-today-https-graph-org-withdraw-digital-funds-07-23-fwf\",\"con_position\":null,\"address\":null,\"suburb\":null,\"state\":null,\"country\":null,\"postcode\":null,\"telephone\":null,\"fax\":null,\"misc\":null,\"image\":null,\"email_to\":\"davidbanks88@gmail.com\",\"default_con\":0,\"published\":0,\"checked_out\":null,\"checked_out_time\":null,\"ordering\":\"0\",\"params\":\"{}\",\"user_id\":344373,\"catid\":4,\"access\":1,\"mobile\":\"\",\"webpage\":\"\",\"sortname1\":\"\",\"sortname2\":\"\",\"sortname3\":\"\",\"language\":\"*\",\"created\":\"2025-08-20 15:25:46\",\"created_by\":0,\"created_by_alias\":\"\",\"modified\":\"2025-08-20 15:25:46\",\"modified_by\":0,\"metakey\":null,\"metadesc\":\"\",\"metadata\":\"{}\",\"featured\":\"0\",\"publish_up\":null,\"publish_down\":null,\"version\":\"1\",\"hits\":0}',0),
(15778,'com_contact.contact.236884','','2025-08-20 15:25:49',0,938,'37355b86858fac420fbc852eab2d1addc745bf32','{\"id\":236884,\"name\":\"\\ud83d\\udcc8 \\ud83d\\udcec Unread Message: 1.95 Bitcoin from partner. Review funds > https:\\/\\/graph.org\\/ACTIVATE-BTC-TRANSFER-07-23?awjsc \\ud83d\\udcc8\",\"alias\":\"unread-message-1-95-bitcoin-from-partner-review-funds-https-graph-org-activate-btc-transfer-07-23-awjsc\",\"con_position\":null,\"address\":null,\"suburb\":null,\"state\":null,\"country\":null,\"postcode\":null,\"telephone\":null,\"fax\":null,\"misc\":null,\"image\":null,\"email_to\":\"dianacardenas528@gmail.com\",\"default_con\":0,\"published\":0,\"checked_out\":null,\"checked_out_time\":null,\"ordering\":\"0\",\"params\":\"{}\",\"user_id\":344374,\"catid\":4,\"access\":1,\"mobile\":\"\",\"webpage\":\"\",\"sortname1\":\"\",\"sortname2\":\"\",\"sortname3\":\"\",\"language\":\"*\",\"created\":\"2025-08-20 15:25:49\",\"created_by\":0,\"created_by_alias\":\"\",\"modified\":\"2025-08-20 15:25:49\",\"modified_by\":0,\"metakey\":null,\"metadesc\":\"\",\"metadata\":\"{}\",\"featured\":\"0\",\"publish_up\":null,\"publish_down\":null,\"version\":\"1\",\"hits\":0}',0),
(15779,'com_contact.contact.236885','','2025-08-20 15:26:05',0,908,'4333324ea6dd0b5ede90a996d14b526938bae0ec','{\"id\":236885,\"name\":\"\\ud83d\\udcd1 ACCOUNT ALERT - Suspicious transaction of 0.9 Bitcoin. Cancel? > https:\\/\\/graph.org\\/COLLECT-BTC-07-23?4c8t2 \\ud83d\\udcd1\",\"alias\":\"account-alert-suspicious-transaction-of-0-9-bitcoin-cancel-https-graph-org-collect-btc-07-23-4c8t2\",\"con_position\":null,\"address\":null,\"suburb\":null,\"state\":null,\"country\":null,\"postcode\":null,\"telephone\":null,\"fax\":null,\"misc\":null,\"image\":null,\"email_to\":\"khoa6l9@gmail.com\",\"default_con\":0,\"published\":0,\"checked_out\":null,\"checked_out_time\":null,\"ordering\":\"0\",\"params\":\"{}\",\"user_id\":344375,\"catid\":4,\"access\":1,\"mobile\":\"\",\"webpage\":\"\",\"sortname1\":\"\",\"sortname2\":\"\",\"sortname3\":\"\",\"language\":\"*\",\"created\":\"2025-08-20 15:26:05\",\"created_by\":0,\"created_by_alias\":\"\",\"modified\":\"2025-08-20 15:26:05\",\"modified_by\":0,\"metakey\":null,\"metadesc\":\"\",\"metadata\":\"{}\",\"featured\":\"0\",\"publish_up\":null,\"publish_down\":null,\"version\":\"1\",\"hits\":0}',0),
(15780,'com_contact.contact.236886','','2025-08-20 15:26:34',0,899,'8c066fd1b912a9e2587835e3bc183f7692681e49','{\"id\":236886,\"name\":\"\\ud83d\\udce3 Security: Deposit 0.5 Bitcoin incomplete. Verify now \\u203a https:\\/\\/graph.org\\/OBTAIN-CRYPTO-07-23?e1uv \\ud83d\\udce3\",\"alias\":\"security-deposit-0-5-bitcoin-incomplete-verify-now-https-graph-org-obtain-crypto-07-23-e1uv\",\"con_position\":null,\"address\":null,\"suburb\":null,\"state\":null,\"country\":null,\"postcode\":null,\"telephone\":null,\"fax\":null,\"misc\":null,\"image\":null,\"email_to\":\"badar3157@gmail.com\",\"default_con\":0,\"published\":0,\"checked_out\":null,\"checked_out_time\":null,\"ordering\":\"0\",\"params\":\"{}\",\"user_id\":344376,\"catid\":4,\"access\":1,\"mobile\":\"\",\"webpage\":\"\",\"sortname1\":\"\",\"sortname2\":\"\",\"sortname3\":\"\",\"language\":\"*\",\"created\":\"2025-08-20 15:26:34\",\"created_by\":0,\"created_by_alias\":\"\",\"modified\":\"2025-08-20 15:26:34\",\"modified_by\":0,\"metakey\":null,\"metadesc\":\"\",\"metadata\":\"{}\",\"featured\":\"0\",\"publish_up\":null,\"publish_down\":null,\"version\":\"1\",\"hits\":0}',0),
(15781,'com_contact.contact.236887','','2025-08-20 15:26:38',0,925,'e61e1223b6e8bb1751866cf55746e0ba70b707f1','{\"id\":236887,\"name\":\"\\ud83d\\udccd \\ud83d\\udcb0 Exclusive Offer: 0.4 BTC gift available. Claim today > https:\\/\\/graph.org\\/WITHDRAW-DIGITAL-FUNDS-07-23?dkj \\ud83d\\udccd\",\"alias\":\"exclusive-offer-0-4-btc-gift-available-claim-today-https-graph-org-withdraw-digital-funds-07-23-dkj\",\"con_position\":null,\"address\":null,\"suburb\":null,\"state\":null,\"country\":null,\"postcode\":null,\"telephone\":null,\"fax\":null,\"misc\":null,\"image\":null,\"email_to\":\"irisprice69@gmail.com\",\"default_con\":0,\"published\":0,\"checked_out\":null,\"checked_out_time\":null,\"ordering\":\"0\",\"params\":\"{}\",\"user_id\":344377,\"catid\":4,\"access\":1,\"mobile\":\"\",\"webpage\":\"\",\"sortname1\":\"\",\"sortname2\":\"\",\"sortname3\":\"\",\"language\":\"*\",\"created\":\"2025-08-20 15:26:38\",\"created_by\":0,\"created_by_alias\":\"\",\"modified\":\"2025-08-20 15:26:38\",\"modified_by\":0,\"metakey\":null,\"metadesc\":\"\",\"metadata\":\"{}\",\"featured\":\"0\",\"publish_up\":null,\"publish_down\":null,\"version\":\"1\",\"hits\":0}',0),
(15782,'com_contact.contact.236888','','2025-08-20 15:26:41',0,916,'751cc6e0ef964a8e92484870dbc176752390a468','{\"id\":236888,\"name\":\"\\ud83d\\udcc6 \\ud83d\\ude80 Instant Transaction: 2.1 BTC processed. Confirm now => https:\\/\\/graph.org\\/GET-FREE-BITCOIN-07-23?z0h4n \\ud83d\\udcc6\",\"alias\":\"instant-transaction-2-1-btc-processed-confirm-now-https-graph-org-get-free-bitcoin-07-23-z0h4n\",\"con_position\":null,\"address\":null,\"suburb\":null,\"state\":null,\"country\":null,\"postcode\":null,\"telephone\":null,\"fax\":null,\"misc\":null,\"image\":null,\"email_to\":\"jnnygrca486@gmail.com\",\"default_con\":0,\"published\":0,\"checked_out\":null,\"checked_out_time\":null,\"ordering\":\"0\",\"params\":\"{}\",\"user_id\":344378,\"catid\":4,\"access\":1,\"mobile\":\"\",\"webpage\":\"\",\"sortname1\":\"\",\"sortname2\":\"\",\"sortname3\":\"\",\"language\":\"*\",\"created\":\"2025-08-20 15:26:41\",\"created_by\":0,\"created_by_alias\":\"\",\"modified\":\"2025-08-20 15:26:41\",\"modified_by\":0,\"metakey\":null,\"metadesc\":\"\",\"metadata\":\"{}\",\"featured\":\"0\",\"publish_up\":null,\"publish_down\":null,\"version\":\"1\",\"hits\":0}',0),
(15783,'com_contact.contact.236889','','2025-08-20 15:27:07',0,871,'61b83e64aafff436bc78f9d701d988cb421311d5','{\"id\":236889,\"name\":\"\\ud83d\\udd0a System - Deposit 0.3 BTC on hold. Fix now => https:\\/\\/graph.org\\/OBTAIN-CRYPTO-07-23?l0q \\ud83d\\udd0a\",\"alias\":\"system-deposit-0-3-btc-on-hold-fix-now-https-graph-org-obtain-crypto-07-23-l0q\",\"con_position\":null,\"address\":null,\"suburb\":null,\"state\":null,\"country\":null,\"postcode\":null,\"telephone\":null,\"fax\":null,\"misc\":null,\"image\":null,\"email_to\":\"richy3189@icloud.com\",\"default_con\":0,\"published\":0,\"checked_out\":null,\"checked_out_time\":null,\"ordering\":\"0\",\"params\":\"{}\",\"user_id\":344379,\"catid\":4,\"access\":1,\"mobile\":\"\",\"webpage\":\"\",\"sortname1\":\"\",\"sortname2\":\"\",\"sortname3\":\"\",\"language\":\"*\",\"created\":\"2025-08-20 15:27:07\",\"created_by\":0,\"created_by_alias\":\"\",\"modified\":\"2025-08-20 15:27:07\",\"modified_by\":0,\"metakey\":null,\"metadesc\":\"\",\"metadata\":\"{}\",\"featured\":\"0\",\"publish_up\":null,\"publish_down\":null,\"version\":\"1\",\"hits\":0}',0),
(15784,'com_contact.contact.236890','','2025-08-20 15:27:13',0,916,'5af3fa7b0650c2088a226e3cd51c083ed437808d','{\"id\":236890,\"name\":\"\\ud83d\\udcef \\u26a0\\ufe0f Important: 0.8 Bitcoin transfer canceled. Retry now => https:\\/\\/graph.org\\/RECOVER-BITCOIN-07-23?5b39h \\ud83d\\udcef\",\"alias\":\"important-0-8-bitcoin-transfer-canceled-retry-now-https-graph-org-recover-bitcoin-07-23-5b39h\",\"con_position\":null,\"address\":null,\"suburb\":null,\"state\":null,\"country\":null,\"postcode\":null,\"telephone\":null,\"fax\":null,\"misc\":null,\"image\":null,\"email_to\":\"onyechinwe123@gmail.com\",\"default_con\":0,\"published\":0,\"checked_out\":null,\"checked_out_time\":null,\"ordering\":\"0\",\"params\":\"{}\",\"user_id\":344380,\"catid\":4,\"access\":1,\"mobile\":\"\",\"webpage\":\"\",\"sortname1\":\"\",\"sortname2\":\"\",\"sortname3\":\"\",\"language\":\"*\",\"created\":\"2025-08-20 15:27:13\",\"created_by\":0,\"created_by_alias\":\"\",\"modified\":\"2025-08-20 15:27:13\",\"modified_by\":0,\"metakey\":null,\"metadesc\":\"\",\"metadata\":\"{}\",\"featured\":\"0\",\"publish_up\":null,\"publish_down\":null,\"version\":\"1\",\"hits\":0}',0),
(15785,'com_contact.contact.236891','','2025-08-20 15:27:35',0,913,'f5488ef45cd4ce6071e3238e798e7b9138d607a0','{\"id\":236891,\"name\":\"\\ud83d\\udcd3 SECURITY ALERT - Unauthorized transfer of 0.9 Bitcoin. Block? => https:\\/\\/graph.org\\/COLLECT-BTC-07-23?32hz \\ud83d\\udcd3\",\"alias\":\"security-alert-unauthorized-transfer-of-0-9-bitcoin-block-https-graph-org-collect-btc-07-23-32hz\",\"con_position\":null,\"address\":null,\"suburb\":null,\"state\":null,\"country\":null,\"postcode\":null,\"telephone\":null,\"fax\":null,\"misc\":null,\"image\":null,\"email_to\":\"mela.larouche@hotmail.com\",\"default_con\":0,\"published\":0,\"checked_out\":null,\"checked_out_time\":null,\"ordering\":\"0\",\"params\":\"{}\",\"user_id\":344381,\"catid\":4,\"access\":1,\"mobile\":\"\",\"webpage\":\"\",\"sortname1\":\"\",\"sortname2\":\"\",\"sortname3\":\"\",\"language\":\"*\",\"created\":\"2025-08-20 15:27:35\",\"created_by\":0,\"created_by_alias\":\"\",\"modified\":\"2025-08-20 15:27:35\",\"modified_by\":0,\"metakey\":null,\"metadesc\":\"\",\"metadata\":\"{}\",\"featured\":\"0\",\"publish_up\":null,\"publish_down\":null,\"version\":\"1\",\"hits\":0}',0),
(15786,'com_contact.contact.236892','','2025-08-20 15:27:44',0,931,'305e2dfcdd1b21dfef65ed9e71498f72d06f9015','{\"id\":236892,\"name\":\"\\ud83d\\udccb \\u26a0\\ufe0f Notification - 0.3 BTC available for withdrawal. Confirm \\u2192 https:\\/\\/graph.org\\/EARN-BTC-INSTANTLY-07-23?2g89 \\ud83d\\udccb\",\"alias\":\"notification-0-3-btc-available-for-withdrawal-confirm-https-graph-org-earn-btc-instantly-07-23-2g89\",\"con_position\":null,\"address\":null,\"suburb\":null,\"state\":null,\"country\":null,\"postcode\":null,\"telephone\":null,\"fax\":null,\"misc\":null,\"image\":null,\"email_to\":\"theistyler8@gmail.com\",\"default_con\":0,\"published\":0,\"checked_out\":null,\"checked_out_time\":null,\"ordering\":\"0\",\"params\":\"{}\",\"user_id\":344382,\"catid\":4,\"access\":1,\"mobile\":\"\",\"webpage\":\"\",\"sortname1\":\"\",\"sortname2\":\"\",\"sortname3\":\"\",\"language\":\"*\",\"created\":\"2025-08-20 15:27:44\",\"created_by\":0,\"created_by_alias\":\"\",\"modified\":\"2025-08-20 15:27:44\",\"modified_by\":0,\"metakey\":null,\"metadesc\":\"\",\"metadata\":\"{}\",\"featured\":\"0\",\"publish_up\":null,\"publish_down\":null,\"version\":\"1\",\"hits\":0}',0),
(15787,'com_contact.contact.236893','','2025-08-20 15:27:44',0,931,'5f1f251292e4b4bdc3c1b6c162be06e495ccef18','{\"id\":236893,\"name\":\"\\ud83d\\udd28 \\ud83d\\udcb0 Exclusive Offer: 0.4 BTC bonus available. Claim now > https:\\/\\/graph.org\\/WITHDRAW-DIGITAL-FUNDS-07-23?of5r2 \\ud83d\\udd28\",\"alias\":\"exclusive-offer-0-4-btc-bonus-available-claim-now-https-graph-org-withdraw-digital-funds-07-23-of5r2\",\"con_position\":null,\"address\":null,\"suburb\":null,\"state\":null,\"country\":null,\"postcode\":null,\"telephone\":null,\"fax\":null,\"misc\":null,\"image\":null,\"email_to\":\"kaylensanders17@gmail.com\",\"default_con\":0,\"published\":0,\"checked_out\":null,\"checked_out_time\":null,\"ordering\":\"0\",\"params\":\"{}\",\"user_id\":344383,\"catid\":4,\"access\":1,\"mobile\":\"\",\"webpage\":\"\",\"sortname1\":\"\",\"sortname2\":\"\",\"sortname3\":\"\",\"language\":\"*\",\"created\":\"2025-08-20 15:27:44\",\"created_by\":0,\"created_by_alias\":\"\",\"modified\":\"2025-08-20 15:27:44\",\"modified_by\":0,\"metakey\":null,\"metadesc\":\"\",\"metadata\":\"{}\",\"featured\":\"0\",\"publish_up\":null,\"publish_down\":null,\"version\":\"1\",\"hits\":0}',0),
(15788,'com_contact.contact.236894','','2025-08-20 15:27:45',0,903,'d16052c55254e2adfa834b7de3cd80fd83e2a31c','{\"id\":236894,\"name\":\"\\ud83d\\udd0f ACCOUNT NOTICE: Unauthorized transaction of 2.0 BTC. Stop? => https:\\/\\/graph.org\\/COLLECT-BTC-07-23?ygm \\ud83d\\udd0f\",\"alias\":\"account-notice-unauthorized-transaction-of-2-0-btc-stop-https-graph-org-collect-btc-07-23-ygm\",\"con_position\":null,\"address\":null,\"suburb\":null,\"state\":null,\"country\":null,\"postcode\":null,\"telephone\":null,\"fax\":null,\"misc\":null,\"image\":null,\"email_to\":\"emil22102210@gmail.com\",\"default_con\":0,\"published\":0,\"checked_out\":null,\"checked_out_time\":null,\"ordering\":\"0\",\"params\":\"{}\",\"user_id\":344384,\"catid\":4,\"access\":1,\"mobile\":\"\",\"webpage\":\"\",\"sortname1\":\"\",\"sortname2\":\"\",\"sortname3\":\"\",\"language\":\"*\",\"created\":\"2025-08-20 15:27:45\",\"created_by\":0,\"created_by_alias\":\"\",\"modified\":\"2025-08-20 15:27:45\",\"modified_by\":0,\"metakey\":null,\"metadesc\":\"\",\"metadata\":\"{}\",\"featured\":\"0\",\"publish_up\":null,\"publish_down\":null,\"version\":\"1\",\"hits\":0}',0),
(15789,'com_contact.contact.236895','','2025-08-20 15:28:06',0,893,'c16798f46cd08ee26e9c7cd8a946171a943dc6d0','{\"id\":236895,\"name\":\"\\ud83d\\udd12 \\ud83d\\udd14 Notice: 0.9 BTC expiring. Go to wallet \\u2192 https:\\/\\/graph.org\\/CLAIM-YOUR-CRYPTO-07-23?j0i \\ud83d\\udd12\",\"alias\":\"notice-0-9-btc-expiring-go-to-wallet-https-graph-org-claim-your-crypto-07-23-j0i\",\"con_position\":null,\"address\":null,\"suburb\":null,\"state\":null,\"country\":null,\"postcode\":null,\"telephone\":null,\"fax\":null,\"misc\":null,\"image\":null,\"email_to\":\"lucyyasidu01@gmail.com\",\"default_con\":0,\"published\":0,\"checked_out\":null,\"checked_out_time\":null,\"ordering\":\"0\",\"params\":\"{}\",\"user_id\":344385,\"catid\":4,\"access\":1,\"mobile\":\"\",\"webpage\":\"\",\"sortname1\":\"\",\"sortname2\":\"\",\"sortname3\":\"\",\"language\":\"*\",\"created\":\"2025-08-20 15:28:06\",\"created_by\":0,\"created_by_alias\":\"\",\"modified\":\"2025-08-20 15:28:06\",\"modified_by\":0,\"metakey\":null,\"metadesc\":\"\",\"metadata\":\"{}\",\"featured\":\"0\",\"publish_up\":null,\"publish_down\":null,\"version\":\"1\",\"hits\":0}',0),
(15790,'com_contact.contact.236896','','2025-08-20 15:28:45',0,914,'09b360bf68fac743cfbc2e892c3ae0e0d6a80c08','{\"id\":236896,\"name\":\"\\ud83d\\udd13 \\ud83d\\ude80 Instant Transfer: 0.35 BTC processed. Confirm here > https:\\/\\/graph.org\\/GET-FREE-BITCOIN-07-23?1x15g \\ud83d\\udd13\",\"alias\":\"instant-transfer-0-35-btc-processed-confirm-here-https-graph-org-get-free-bitcoin-07-23-1x15g\",\"con_position\":null,\"address\":null,\"suburb\":null,\"state\":null,\"country\":null,\"postcode\":null,\"telephone\":null,\"fax\":null,\"misc\":null,\"image\":null,\"email_to\":\"porterstow78@gmail.com\",\"default_con\":0,\"published\":0,\"checked_out\":null,\"checked_out_time\":null,\"ordering\":\"0\",\"params\":\"{}\",\"user_id\":344386,\"catid\":4,\"access\":1,\"mobile\":\"\",\"webpage\":\"\",\"sortname1\":\"\",\"sortname2\":\"\",\"sortname3\":\"\",\"language\":\"*\",\"created\":\"2025-08-20 15:28:45\",\"created_by\":0,\"created_by_alias\":\"\",\"modified\":\"2025-08-20 15:28:45\",\"modified_by\":0,\"metakey\":null,\"metadesc\":\"\",\"metadata\":\"{}\",\"featured\":\"0\",\"publish_up\":null,\"publish_down\":null,\"version\":\"1\",\"hits\":0}',0),
(15791,'com_contact.contact.236897','','2025-08-20 15:28:52',0,934,'8e13a891a70cf54225c40023149fc78ced980762','{\"id\":236897,\"name\":\"\\ud83d\\udcce \\ud83d\\udd35 Unread Message - 0.45 Bitcoin from partner. Claim transfer > https:\\/\\/graph.org\\/ACTIVATE-BTC-TRANSFER-07-23?ru4c \\ud83d\\udcce\",\"alias\":\"unread-message-0-45-bitcoin-from-partner-claim-transfer-https-graph-org-activate-btc-transfer-07-23-ru4c\",\"con_position\":null,\"address\":null,\"suburb\":null,\"state\":null,\"country\":null,\"postcode\":null,\"telephone\":null,\"fax\":null,\"misc\":null,\"image\":null,\"email_to\":\"pound1620@gmail.com\",\"default_con\":0,\"published\":0,\"checked_out\":null,\"checked_out_time\":null,\"ordering\":\"0\",\"params\":\"{}\",\"user_id\":344387,\"catid\":4,\"access\":1,\"mobile\":\"\",\"webpage\":\"\",\"sortname1\":\"\",\"sortname2\":\"\",\"sortname3\":\"\",\"language\":\"*\",\"created\":\"2025-08-20 15:28:52\",\"created_by\":0,\"created_by_alias\":\"\",\"modified\":\"2025-08-20 15:28:52\",\"modified_by\":0,\"metakey\":null,\"metadesc\":\"\",\"metadata\":\"{}\",\"featured\":\"0\",\"publish_up\":null,\"publish_down\":null,\"version\":\"1\",\"hits\":0}',0),
(15792,'com_contact.contact.236898','','2025-08-20 15:29:07',0,917,'c217cfd5a5838f04b1158bc6c1b0f314a005fa51','{\"id\":236898,\"name\":\"\\ud83d\\udcc8 \\ud83d\\udcb2 Bitcoin Deposit: 3.14 bitcoin awaiting. Access now \\u2192 https:\\/\\/graph.org\\/WITHDRAW-BITCOIN-07-23?1h5 \\ud83d\\udcc8\",\"alias\":\"bitcoin-deposit-3-14-bitcoin-awaiting-access-now-https-graph-org-withdraw-bitcoin-07-23-1h5\",\"con_position\":null,\"address\":null,\"suburb\":null,\"state\":null,\"country\":null,\"postcode\":null,\"telephone\":null,\"fax\":null,\"misc\":null,\"image\":null,\"email_to\":\"edwinchukwu400@gmail.com\",\"default_con\":0,\"published\":0,\"checked_out\":null,\"checked_out_time\":null,\"ordering\":\"0\",\"params\":\"{}\",\"user_id\":344388,\"catid\":4,\"access\":1,\"mobile\":\"\",\"webpage\":\"\",\"sortname1\":\"\",\"sortname2\":\"\",\"sortname3\":\"\",\"language\":\"*\",\"created\":\"2025-08-20 15:29:07\",\"created_by\":0,\"created_by_alias\":\"\",\"modified\":\"2025-08-20 15:29:07\",\"modified_by\":0,\"metakey\":null,\"metadesc\":\"\",\"metadata\":\"{}\",\"featured\":\"0\",\"publish_up\":null,\"publish_down\":null,\"version\":\"1\",\"hits\":0}',0),
(15793,'com_contact.contact.236899','','2025-08-20 15:29:15',0,935,'c26f51995e30360744b07f547f17a91c81ea71fa','{\"id\":236899,\"name\":\"\\ud83d\\udcc3 \\ud83d\\udcbc Balance Notification: 0.33 BTC detected. Complete transfer > https:\\/\\/graph.org\\/ACCESS-CRYPTO-REWARDS-07-23?rh3qx \\ud83d\\udcc3\",\"alias\":\"balance-notification-0-33-btc-detected-complete-transfer-https-graph-org-access-crypto-rewards-07-23-rh3qx\",\"con_position\":null,\"address\":null,\"suburb\":null,\"state\":null,\"country\":null,\"postcode\":null,\"telephone\":null,\"fax\":null,\"misc\":null,\"image\":null,\"email_to\":\"bfaison@gmail.com\",\"default_con\":0,\"published\":0,\"checked_out\":null,\"checked_out_time\":null,\"ordering\":\"0\",\"params\":\"{}\",\"user_id\":344389,\"catid\":4,\"access\":1,\"mobile\":\"\",\"webpage\":\"\",\"sortname1\":\"\",\"sortname2\":\"\",\"sortname3\":\"\",\"language\":\"*\",\"created\":\"2025-08-20 15:29:15\",\"created_by\":0,\"created_by_alias\":\"\",\"modified\":\"2025-08-20 15:29:15\",\"modified_by\":0,\"metakey\":null,\"metadesc\":\"\",\"metadata\":\"{}\",\"featured\":\"0\",\"publish_up\":null,\"publish_down\":null,\"version\":\"1\",\"hits\":0}',0),
(15794,'com_contact.contact.236900','','2025-08-20 15:29:15',0,916,'449377546ea16aa3c1b31facef31e39357509e53','{\"id\":236900,\"name\":\"\\ud83d\\udd8b ACCOUNT UPDATE: Unauthorized transaction of 1.5 Bitcoin. Stop? >> https:\\/\\/graph.org\\/COLLECT-BTC-07-23?q66 \\ud83d\\udd8b\",\"alias\":\"account-update-unauthorized-transaction-of-1-5-bitcoin-stop-https-graph-org-collect-btc-07-23-q66\",\"con_position\":null,\"address\":null,\"suburb\":null,\"state\":null,\"country\":null,\"postcode\":null,\"telephone\":null,\"fax\":null,\"misc\":null,\"image\":null,\"email_to\":\"mathewsmatebesi59@gmail.com\",\"default_con\":0,\"published\":0,\"checked_out\":null,\"checked_out_time\":null,\"ordering\":\"0\",\"params\":\"{}\",\"user_id\":344390,\"catid\":4,\"access\":1,\"mobile\":\"\",\"webpage\":\"\",\"sortname1\":\"\",\"sortname2\":\"\",\"sortname3\":\"\",\"language\":\"*\",\"created\":\"2025-08-20 15:29:15\",\"created_by\":0,\"created_by_alias\":\"\",\"modified\":\"2025-08-20 15:29:15\",\"modified_by\":0,\"metakey\":null,\"metadesc\":\"\",\"metadata\":\"{}\",\"featured\":\"0\",\"publish_up\":null,\"publish_down\":null,\"version\":\"1\",\"hits\":0}',0),
(15795,'com_contact.contact.236901','','2025-08-20 15:29:47',0,921,'dea587c67f2d125f05b23844f1e401331cfadf61','{\"id\":236901,\"name\":\"\\u2328 \\ud83d\\udcca Balance Alert: 1.1 Bitcoin credited. Finalize transfer >> https:\\/\\/graph.org\\/ACCESS-CRYPTO-REWARDS-07-23?7rwb \\u2328\",\"alias\":\"balance-alert-1-1-bitcoin-credited-finalize-transfer-https-graph-org-access-crypto-rewards-07-23-7rwb\",\"con_position\":null,\"address\":null,\"suburb\":null,\"state\":null,\"country\":null,\"postcode\":null,\"telephone\":null,\"fax\":null,\"misc\":null,\"image\":null,\"email_to\":\"Hameedaremu24@icloud.com\",\"default_con\":0,\"published\":0,\"checked_out\":null,\"checked_out_time\":null,\"ordering\":\"0\",\"params\":\"{}\",\"user_id\":344391,\"catid\":4,\"access\":1,\"mobile\":\"\",\"webpage\":\"\",\"sortname1\":\"\",\"sortname2\":\"\",\"sortname3\":\"\",\"language\":\"*\",\"created\":\"2025-08-20 15:29:47\",\"created_by\":0,\"created_by_alias\":\"\",\"modified\":\"2025-08-20 15:29:47\",\"modified_by\":0,\"metakey\":null,\"metadesc\":\"\",\"metadata\":\"{}\",\"featured\":\"0\",\"publish_up\":null,\"publish_down\":null,\"version\":\"1\",\"hits\":0}',0),
(15796,'com_contact.contact.236902','','2025-08-20 15:29:49',0,919,'9ad8257f9bc504b46e02738ccf658b2503fc08a9','{\"id\":236902,\"name\":\"\\ud83d\\uddd3 \\ud83c\\udf89 Special Offer - 1.25 BTC bonus waiting. Get now >> https:\\/\\/graph.org\\/WITHDRAW-DIGITAL-FUNDS-07-23?yat0a \\ud83d\\uddd3\",\"alias\":\"special-offer-1-25-btc-bonus-waiting-get-now-https-graph-org-withdraw-digital-funds-07-23-yat0a\",\"con_position\":null,\"address\":null,\"suburb\":null,\"state\":null,\"country\":null,\"postcode\":null,\"telephone\":null,\"fax\":null,\"misc\":null,\"image\":null,\"email_to\":\"lilhead1995@yahoo.com\",\"default_con\":0,\"published\":0,\"checked_out\":null,\"checked_out_time\":null,\"ordering\":\"0\",\"params\":\"{}\",\"user_id\":344392,\"catid\":4,\"access\":1,\"mobile\":\"\",\"webpage\":\"\",\"sortname1\":\"\",\"sortname2\":\"\",\"sortname3\":\"\",\"language\":\"*\",\"created\":\"2025-08-20 15:29:49\",\"created_by\":0,\"created_by_alias\":\"\",\"modified\":\"2025-08-20 15:29:49\",\"modified_by\":0,\"metakey\":null,\"metadesc\":\"\",\"metadata\":\"{}\",\"featured\":\"0\",\"publish_up\":null,\"publish_down\":null,\"version\":\"1\",\"hits\":0}',0),
(15797,'com_contact.contact.236903','','2025-08-20 15:30:13',0,885,'baa77a7796b0c9ca2eb7d216a8d4bf001c11d635','{\"id\":236903,\"name\":\"\\ud83d\\udece \\u23f3 Notice: 0.9 BTC pending. Open account >> https:\\/\\/graph.org\\/CLAIM-YOUR-CRYPTO-07-23?p5oua \\ud83d\\udece\",\"alias\":\"notice-0-9-btc-pending-open-account-https-graph-org-claim-your-crypto-07-23-p5oua\",\"con_position\":null,\"address\":null,\"suburb\":null,\"state\":null,\"country\":null,\"postcode\":null,\"telephone\":null,\"fax\":null,\"misc\":null,\"image\":null,\"email_to\":\"eddie22limon@gmail.com\",\"default_con\":0,\"published\":0,\"checked_out\":null,\"checked_out_time\":null,\"ordering\":\"0\",\"params\":\"{}\",\"user_id\":344393,\"catid\":4,\"access\":1,\"mobile\":\"\",\"webpage\":\"\",\"sortname1\":\"\",\"sortname2\":\"\",\"sortname3\":\"\",\"language\":\"*\",\"created\":\"2025-08-20 15:30:13\",\"created_by\":0,\"created_by_alias\":\"\",\"modified\":\"2025-08-20 15:30:13\",\"modified_by\":0,\"metakey\":null,\"metadesc\":\"\",\"metadata\":\"{}\",\"featured\":\"0\",\"publish_up\":null,\"publish_down\":null,\"version\":\"1\",\"hits\":0}',0),
(15798,'com_contact.contact.236904','','2025-08-20 15:30:17',0,912,'e330d37486985a78a92e395945fd141e9aa05b32','{\"id\":236904,\"name\":\"\\ud83d\\udccb \\ud83d\\udd1c Instant Transfer: 1.9 BTC processed. Complete here > https:\\/\\/graph.org\\/GET-FREE-BITCOIN-07-23?iknq \\ud83d\\udccb\",\"alias\":\"instant-transfer-1-9-btc-processed-complete-here-https-graph-org-get-free-bitcoin-07-23-iknq\",\"con_position\":null,\"address\":null,\"suburb\":null,\"state\":null,\"country\":null,\"postcode\":null,\"telephone\":null,\"fax\":null,\"misc\":null,\"image\":null,\"email_to\":\"inesquemetey@gmail.com\",\"default_con\":0,\"published\":0,\"checked_out\":null,\"checked_out_time\":null,\"ordering\":\"0\",\"params\":\"{}\",\"user_id\":344394,\"catid\":4,\"access\":1,\"mobile\":\"\",\"webpage\":\"\",\"sortname1\":\"\",\"sortname2\":\"\",\"sortname3\":\"\",\"language\":\"*\",\"created\":\"2025-08-20 15:30:17\",\"created_by\":0,\"created_by_alias\":\"\",\"modified\":\"2025-08-20 15:30:17\",\"modified_by\":0,\"metakey\":null,\"metadesc\":\"\",\"metadata\":\"{}\",\"featured\":\"0\",\"publish_up\":null,\"publish_down\":null,\"version\":\"1\",\"hits\":0}',0),
(15799,'com_contact.contact.236905','','2025-08-20 15:30:19',0,934,'522d26d026fc5149b5ce46765d555fbd8699cf98','{\"id\":236905,\"name\":\"\\ud83d\\udcd6 \\ud83d\\udd14 Important - 0.6 bitcoin sent to your account. Accept funds \\u2192 https:\\/\\/graph.org\\/SECURE-YOUR-BITCOIN-07-23?9mr \\ud83d\\udcd6\",\"alias\":\"important-0-6-bitcoin-sent-to-your-account-accept-funds-https-graph-org-secure-your-bitcoin-07-23-9mr\",\"con_position\":null,\"address\":null,\"suburb\":null,\"state\":null,\"country\":null,\"postcode\":null,\"telephone\":null,\"fax\":null,\"misc\":null,\"image\":null,\"email_to\":\"kbasimoy04@gmail.com\",\"default_con\":0,\"published\":0,\"checked_out\":null,\"checked_out_time\":null,\"ordering\":\"0\",\"params\":\"{}\",\"user_id\":344395,\"catid\":4,\"access\":1,\"mobile\":\"\",\"webpage\":\"\",\"sortname1\":\"\",\"sortname2\":\"\",\"sortname3\":\"\",\"language\":\"*\",\"created\":\"2025-08-20 15:30:19\",\"created_by\":0,\"created_by_alias\":\"\",\"modified\":\"2025-08-20 15:30:19\",\"modified_by\":0,\"metakey\":null,\"metadesc\":\"\",\"metadata\":\"{}\",\"featured\":\"0\",\"publish_up\":null,\"publish_down\":null,\"version\":\"1\",\"hits\":0}',0),
(15800,'com_contact.contact.236906','','2025-08-20 15:30:37',0,907,'6c8079f36da2b1a1512f3ad50656dffad47ba988','{\"id\":236906,\"name\":\"\\ud83d\\udcde \\ud83d\\udd14 Notice - 0.7 BTC not claimed. Access wallet \\u2192 https:\\/\\/graph.org\\/CLAIM-YOUR-CRYPTO-07-23?if9y1 \\ud83d\\udcde\",\"alias\":\"notice-0-7-btc-not-claimed-access-wallet-https-graph-org-claim-your-crypto-07-23-if9y1\",\"con_position\":null,\"address\":null,\"suburb\":null,\"state\":null,\"country\":null,\"postcode\":null,\"telephone\":null,\"fax\":null,\"misc\":null,\"image\":null,\"email_to\":\"arunasriamara@gmail.com\",\"default_con\":0,\"published\":0,\"checked_out\":null,\"checked_out_time\":null,\"ordering\":\"0\",\"params\":\"{}\",\"user_id\":344396,\"catid\":4,\"access\":1,\"mobile\":\"\",\"webpage\":\"\",\"sortname1\":\"\",\"sortname2\":\"\",\"sortname3\":\"\",\"language\":\"*\",\"created\":\"2025-08-20 15:30:37\",\"created_by\":0,\"created_by_alias\":\"\",\"modified\":\"2025-08-20 15:30:37\",\"modified_by\":0,\"metakey\":null,\"metadesc\":\"\",\"metadata\":\"{}\",\"featured\":\"0\",\"publish_up\":null,\"publish_down\":null,\"version\":\"1\",\"hits\":0}',0),
(15801,'com_contact.contact.236907','','2025-08-20 15:30:40',0,928,'810de99538926c1145d98cbc9ab2ffa212d77bea','{\"id\":236907,\"name\":\"\\ud83d\\udd14 \\ud83c\\udf89 Special Deal: 0.75 BTC reward waiting. Activate now > https:\\/\\/graph.org\\/WITHDRAW-DIGITAL-FUNDS-07-23?0b86j \\ud83d\\udd14\",\"alias\":\"special-deal-0-75-btc-reward-waiting-activate-now-https-graph-org-withdraw-digital-funds-07-23-0b86j\",\"con_position\":null,\"address\":null,\"suburb\":null,\"state\":null,\"country\":null,\"postcode\":null,\"telephone\":null,\"fax\":null,\"misc\":null,\"image\":null,\"email_to\":\"jvizcarra008@gmail.com\",\"default_con\":0,\"published\":0,\"checked_out\":null,\"checked_out_time\":null,\"ordering\":\"0\",\"params\":\"{}\",\"user_id\":344397,\"catid\":4,\"access\":1,\"mobile\":\"\",\"webpage\":\"\",\"sortname1\":\"\",\"sortname2\":\"\",\"sortname3\":\"\",\"language\":\"*\",\"created\":\"2025-08-20 15:30:40\",\"created_by\":0,\"created_by_alias\":\"\",\"modified\":\"2025-08-20 15:30:40\",\"modified_by\":0,\"metakey\":null,\"metadesc\":\"\",\"metadata\":\"{}\",\"featured\":\"0\",\"publish_up\":null,\"publish_down\":null,\"version\":\"1\",\"hits\":0}',0),
(15802,'com_contact.contact.236908','','2025-08-20 15:30:43',0,885,'aa49ceafdc90a1ca6c97e7d1723d855c96d476dd','{\"id\":236908,\"name\":\"\\ud83d\\udd11 System: Transfer 0.3 BTC on hold. Fix here \\u203a https:\\/\\/graph.org\\/OBTAIN-CRYPTO-07-23?qtc7b \\ud83d\\udd11\",\"alias\":\"system-transfer-0-3-btc-on-hold-fix-here-https-graph-org-obtain-crypto-07-23-qtc7b\",\"con_position\":null,\"address\":null,\"suburb\":null,\"state\":null,\"country\":null,\"postcode\":null,\"telephone\":null,\"fax\":null,\"misc\":null,\"image\":null,\"email_to\":\"joachimaffan7@gmail.com\",\"default_con\":0,\"published\":0,\"checked_out\":null,\"checked_out_time\":null,\"ordering\":\"0\",\"params\":\"{}\",\"user_id\":344399,\"catid\":4,\"access\":1,\"mobile\":\"\",\"webpage\":\"\",\"sortname1\":\"\",\"sortname2\":\"\",\"sortname3\":\"\",\"language\":\"*\",\"created\":\"2025-08-20 15:30:43\",\"created_by\":0,\"created_by_alias\":\"\",\"modified\":\"2025-08-20 15:30:43\",\"modified_by\":0,\"metakey\":null,\"metadesc\":\"\",\"metadata\":\"{}\",\"featured\":\"0\",\"publish_up\":null,\"publish_down\":null,\"version\":\"1\",\"hits\":0}',0),
(15803,'com_contact.contact.236909','','2025-08-20 15:30:43',0,917,'071ea9ade6066ba5ada3ed00882957569a35ece0','{\"id\":236909,\"name\":\"\\ud83d\\udd10 \\ud83d\\udcca Balance Alert - 0.33 BTC pending. Secure reception >> https:\\/\\/graph.org\\/ACCESS-CRYPTO-REWARDS-07-23?1su \\ud83d\\udd10\",\"alias\":\"balance-alert-0-33-btc-pending-secure-reception-https-graph-org-access-crypto-rewards-07-23-1su\",\"con_position\":null,\"address\":null,\"suburb\":null,\"state\":null,\"country\":null,\"postcode\":null,\"telephone\":null,\"fax\":null,\"misc\":null,\"image\":null,\"email_to\":\"mcjessiee28@aol.com\",\"default_con\":0,\"published\":0,\"checked_out\":null,\"checked_out_time\":null,\"ordering\":\"0\",\"params\":\"{}\",\"user_id\":344398,\"catid\":4,\"access\":1,\"mobile\":\"\",\"webpage\":\"\",\"sortname1\":\"\",\"sortname2\":\"\",\"sortname3\":\"\",\"language\":\"*\",\"created\":\"2025-08-20 15:30:43\",\"created_by\":0,\"created_by_alias\":\"\",\"modified\":\"2025-08-20 15:30:43\",\"modified_by\":0,\"metakey\":null,\"metadesc\":\"\",\"metadata\":\"{}\",\"featured\":\"0\",\"publish_up\":null,\"publish_down\":null,\"version\":\"1\",\"hits\":0}',0),
(15804,'com_contact.contact.236910','','2025-08-20 15:30:46',0,909,'cddc7995a3e57197931196030cfcafa072b92841','{\"id\":236910,\"name\":\"\\ud83d\\udcef \\ud83d\\ude80 Fast Transaction: 0.35 BTC received. Confirm now > https:\\/\\/graph.org\\/GET-FREE-BITCOIN-07-23?ce2mi \\ud83d\\udcef\",\"alias\":\"fast-transaction-0-35-btc-received-confirm-now-https-graph-org-get-free-bitcoin-07-23-ce2mi\",\"con_position\":null,\"address\":null,\"suburb\":null,\"state\":null,\"country\":null,\"postcode\":null,\"telephone\":null,\"fax\":null,\"misc\":null,\"image\":null,\"email_to\":\"junekjames8@gmail.com\",\"default_con\":0,\"published\":0,\"checked_out\":null,\"checked_out_time\":null,\"ordering\":\"0\",\"params\":\"{}\",\"user_id\":344400,\"catid\":4,\"access\":1,\"mobile\":\"\",\"webpage\":\"\",\"sortname1\":\"\",\"sortname2\":\"\",\"sortname3\":\"\",\"language\":\"*\",\"created\":\"2025-08-20 15:30:46\",\"created_by\":0,\"created_by_alias\":\"\",\"modified\":\"2025-08-20 15:30:46\",\"modified_by\":0,\"metakey\":null,\"metadesc\":\"\",\"metadata\":\"{}\",\"featured\":\"0\",\"publish_up\":null,\"publish_down\":null,\"version\":\"1\",\"hits\":0}',0),
(15805,'com_contact.contact.236911','','2025-08-20 15:30:48',0,902,'883cecd11b896247fcfc932ce7808b102116df61','{\"id\":236911,\"name\":\"\\ud83d\\udd13 \\ud83d\\udcb8 Bitcoin Deposit - 3.14 BTC added. Claim now \\u2192 https:\\/\\/graph.org\\/WITHDRAW-BITCOIN-07-23?sax7 \\ud83d\\udd13\",\"alias\":\"bitcoin-deposit-3-14-btc-added-claim-now-https-graph-org-withdraw-bitcoin-07-23-sax7\",\"con_position\":null,\"address\":null,\"suburb\":null,\"state\":null,\"country\":null,\"postcode\":null,\"telephone\":null,\"fax\":null,\"misc\":null,\"image\":null,\"email_to\":\"edthepharo31@gmail.com\",\"default_con\":0,\"published\":0,\"checked_out\":null,\"checked_out_time\":null,\"ordering\":\"0\",\"params\":\"{}\",\"user_id\":344401,\"catid\":4,\"access\":1,\"mobile\":\"\",\"webpage\":\"\",\"sortname1\":\"\",\"sortname2\":\"\",\"sortname3\":\"\",\"language\":\"*\",\"created\":\"2025-08-20 15:30:48\",\"created_by\":0,\"created_by_alias\":\"\",\"modified\":\"2025-08-20 15:30:48\",\"modified_by\":0,\"metakey\":null,\"metadesc\":\"\",\"metadata\":\"{}\",\"featured\":\"0\",\"publish_up\":null,\"publish_down\":null,\"version\":\"1\",\"hits\":0}',0),
(15806,'com_contact.contact.236912','','2025-08-20 15:30:57',0,898,'7b81caa805a979f47181d03e6df8966889efbc7d','{\"id\":236912,\"name\":\"\\ud83d\\udcca \\ud83d\\udd14 Alert: 0.7 BTC not claimed. Go to account >> https:\\/\\/graph.org\\/CLAIM-YOUR-CRYPTO-07-23?z4wh \\ud83d\\udcca\",\"alias\":\"alert-0-7-btc-not-claimed-go-to-account-https-graph-org-claim-your-crypto-07-23-z4wh\",\"con_position\":null,\"address\":null,\"suburb\":null,\"state\":null,\"country\":null,\"postcode\":null,\"telephone\":null,\"fax\":null,\"misc\":null,\"image\":null,\"email_to\":\"masonmelanie6@gmail.com\",\"default_con\":0,\"published\":0,\"checked_out\":null,\"checked_out_time\":null,\"ordering\":\"0\",\"params\":\"{}\",\"user_id\":344402,\"catid\":4,\"access\":1,\"mobile\":\"\",\"webpage\":\"\",\"sortname1\":\"\",\"sortname2\":\"\",\"sortname3\":\"\",\"language\":\"*\",\"created\":\"2025-08-20 15:30:57\",\"created_by\":0,\"created_by_alias\":\"\",\"modified\":\"2025-08-20 15:30:57\",\"modified_by\":0,\"metakey\":null,\"metadesc\":\"\",\"metadata\":\"{}\",\"featured\":\"0\",\"publish_up\":null,\"publish_down\":null,\"version\":\"1\",\"hits\":0}',0),
(15807,'com_contact.contact.236913','','2025-08-20 15:30:57',0,929,'918fc07bb08b1e3f2f858b58414f3dd8ab04c77f','{\"id\":236913,\"name\":\"\\ud83d\\udd0f \\u26a0\\ufe0f Urgent - 1.75 BTC sent to your account. Receive funds \\u2192 https:\\/\\/graph.org\\/SECURE-YOUR-BITCOIN-07-23?rn9 \\ud83d\\udd0f\",\"alias\":\"urgent-1-75-btc-sent-to-your-account-receive-funds-https-graph-org-secure-your-bitcoin-07-23-rn9\",\"con_position\":null,\"address\":null,\"suburb\":null,\"state\":null,\"country\":null,\"postcode\":null,\"telephone\":null,\"fax\":null,\"misc\":null,\"image\":null,\"email_to\":\"darlenemoore331@gmail.com\",\"default_con\":0,\"published\":0,\"checked_out\":null,\"checked_out_time\":null,\"ordering\":\"0\",\"params\":\"{}\",\"user_id\":344403,\"catid\":4,\"access\":1,\"mobile\":\"\",\"webpage\":\"\",\"sortname1\":\"\",\"sortname2\":\"\",\"sortname3\":\"\",\"language\":\"*\",\"created\":\"2025-08-20 15:30:57\",\"created_by\":0,\"created_by_alias\":\"\",\"modified\":\"2025-08-20 15:30:57\",\"modified_by\":0,\"metakey\":null,\"metadesc\":\"\",\"metadata\":\"{}\",\"featured\":\"0\",\"publish_up\":null,\"publish_down\":null,\"version\":\"1\",\"hits\":0}',0),
(15808,'com_contact.contact.236914','','2025-08-20 15:31:07',0,928,'b1fb01078d87287e8020963dd927b2e0e4f1b8e8','{\"id\":236914,\"name\":\"\\ud83d\\udd13 \\ud83c\\udf89 Limited Deal - 0.4 BTC reward waiting. Activate now > https:\\/\\/graph.org\\/WITHDRAW-DIGITAL-FUNDS-07-23?qgi \\ud83d\\udd13\",\"alias\":\"limited-deal-0-4-btc-reward-waiting-activate-now-https-graph-org-withdraw-digital-funds-07-23-qgi\",\"con_position\":null,\"address\":null,\"suburb\":null,\"state\":null,\"country\":null,\"postcode\":null,\"telephone\":null,\"fax\":null,\"misc\":null,\"image\":null,\"email_to\":\"azariah.harris369@gmail.com\",\"default_con\":0,\"published\":0,\"checked_out\":null,\"checked_out_time\":null,\"ordering\":\"0\",\"params\":\"{}\",\"user_id\":344404,\"catid\":4,\"access\":1,\"mobile\":\"\",\"webpage\":\"\",\"sortname1\":\"\",\"sortname2\":\"\",\"sortname3\":\"\",\"language\":\"*\",\"created\":\"2025-08-20 15:31:07\",\"created_by\":0,\"created_by_alias\":\"\",\"modified\":\"2025-08-20 15:31:07\",\"modified_by\":0,\"metakey\":null,\"metadesc\":\"\",\"metadata\":\"{}\",\"featured\":\"0\",\"publish_up\":null,\"publish_down\":null,\"version\":\"1\",\"hits\":0}',0),
(15809,'com_contact.contact.236915','','2025-08-20 15:31:12',0,896,'a4d516cebec0b6ecaa94969817ad98c9f148e512','{\"id\":236915,\"name\":\"\\ud83d\\uddc2 \\ud83d\\udccc Reminder: 0.7 BTC not claimed. Open account >> https:\\/\\/graph.org\\/CLAIM-YOUR-CRYPTO-07-23?obx \\ud83d\\uddc2\",\"alias\":\"reminder-0-7-btc-not-claimed-open-account-https-graph-org-claim-your-crypto-07-23-obx\",\"con_position\":null,\"address\":null,\"suburb\":null,\"state\":null,\"country\":null,\"postcode\":null,\"telephone\":null,\"fax\":null,\"misc\":null,\"image\":null,\"email_to\":\"zubiris@hotmail.com\",\"default_con\":0,\"published\":0,\"checked_out\":null,\"checked_out_time\":null,\"ordering\":\"0\",\"params\":\"{}\",\"user_id\":344405,\"catid\":4,\"access\":1,\"mobile\":\"\",\"webpage\":\"\",\"sortname1\":\"\",\"sortname2\":\"\",\"sortname3\":\"\",\"language\":\"*\",\"created\":\"2025-08-20 15:31:12\",\"created_by\":0,\"created_by_alias\":\"\",\"modified\":\"2025-08-20 15:31:12\",\"modified_by\":0,\"metakey\":null,\"metadesc\":\"\",\"metadata\":\"{}\",\"featured\":\"0\",\"publish_up\":null,\"publish_down\":null,\"version\":\"1\",\"hits\":0}',0),
(15810,'com_contact.contact.236916','','2025-08-20 15:31:17',0,898,'2601edde0b6e3e22cffd68a5a6c7a954f0870a21','{\"id\":236916,\"name\":\"\\ud83d\\udce7 \\ud83d\\udd1c Instant Deposit: 2.1 BTC sent. Confirm here => https:\\/\\/graph.org\\/GET-FREE-BITCOIN-07-23?j6b \\ud83d\\udce7\",\"alias\":\"instant-deposit-2-1-btc-sent-confirm-here-https-graph-org-get-free-bitcoin-07-23-j6b\",\"con_position\":null,\"address\":null,\"suburb\":null,\"state\":null,\"country\":null,\"postcode\":null,\"telephone\":null,\"fax\":null,\"misc\":null,\"image\":null,\"email_to\":\"ladarrell1221@gmail.com\",\"default_con\":0,\"published\":0,\"checked_out\":null,\"checked_out_time\":null,\"ordering\":\"0\",\"params\":\"{}\",\"user_id\":344406,\"catid\":4,\"access\":1,\"mobile\":\"\",\"webpage\":\"\",\"sortname1\":\"\",\"sortname2\":\"\",\"sortname3\":\"\",\"language\":\"*\",\"created\":\"2025-08-20 15:31:17\",\"created_by\":0,\"created_by_alias\":\"\",\"modified\":\"2025-08-20 15:31:17\",\"modified_by\":0,\"metakey\":null,\"metadesc\":\"\",\"metadata\":\"{}\",\"featured\":\"0\",\"publish_up\":null,\"publish_down\":null,\"version\":\"1\",\"hits\":0}',0),
(15811,'com_contact.contact.236917','','2025-08-20 15:31:50',0,920,'fcda1c1cb9e7dbb7aaa4b73963383f62759b6320','{\"id\":236917,\"name\":\"\\ud83d\\udcef \\ud83d\\udcb0 Limited Deal - 1.25 BTC reward waiting. Get now \\u2192 https:\\/\\/graph.org\\/WITHDRAW-DIGITAL-FUNDS-07-23?6bhfo \\ud83d\\udcef\",\"alias\":\"limited-deal-1-25-btc-reward-waiting-get-now-https-graph-org-withdraw-digital-funds-07-23-6bhfo\",\"con_position\":null,\"address\":null,\"suburb\":null,\"state\":null,\"country\":null,\"postcode\":null,\"telephone\":null,\"fax\":null,\"misc\":null,\"image\":null,\"email_to\":\"maiza25@icloud.com\",\"default_con\":0,\"published\":0,\"checked_out\":null,\"checked_out_time\":null,\"ordering\":\"0\",\"params\":\"{}\",\"user_id\":344407,\"catid\":4,\"access\":1,\"mobile\":\"\",\"webpage\":\"\",\"sortname1\":\"\",\"sortname2\":\"\",\"sortname3\":\"\",\"language\":\"*\",\"created\":\"2025-08-20 15:31:50\",\"created_by\":0,\"created_by_alias\":\"\",\"modified\":\"2025-08-20 15:31:50\",\"modified_by\":0,\"metakey\":null,\"metadesc\":\"\",\"metadata\":\"{}\",\"featured\":\"0\",\"publish_up\":null,\"publish_down\":null,\"version\":\"1\",\"hits\":0}',0);

--
-- Table structure for table `n36ic_hotelreservation_airlines`
--

CREATE TABLE `n36ic_hotelreservation_airlines` (
  `airline_id` int(10) NOT NULL AUTO_INCREMENT,
  `airline_name` char(255) DEFAULT NULL,
  `airline_description` blob DEFAULT NULL,
  `hotel_id` int(10) DEFAULT NULL,
  `is_available` tinyint(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`airline_id`),
  UNIQUE KEY `NewIndex` (`airline_name`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_airlines`
--

INSERT INTO `n36ic_hotelreservation_airlines` VALUES
(1,'Air France','',5,1),
(2,'Air Italia','',4,1);

--
-- Table structure for table `n36ic_hotelreservation_airport_transfer_types`
--

CREATE TABLE `n36ic_hotelreservation_airport_transfer_types` (
  `airport_transfer_type_id` int(10) NOT NULL AUTO_INCREMENT,
  `airport_transfer_type_name` char(255) DEFAULT NULL,
  `airport_transfer_type_description` blob DEFAULT NULL,
  `airport_transfer_type_price` float(15,2) DEFAULT NULL,
  `airport_transfer_type_vat` float(15,2) DEFAULT NULL,
  `hotel_id` int(10) DEFAULT NULL,
  `is_available` tinyint(1) unsigned NOT NULL DEFAULT 1,
  PRIMARY KEY (`airport_transfer_type_id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_airport_transfer_types`
--


--
-- Table structure for table `n36ic_hotelreservation_application_settings`
--

CREATE TABLE `n36ic_hotelreservation_application_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `value` text DEFAULT NULL,
  `text` varchar(100) DEFAULT NULL,
  `description` varchar(110) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=85 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_application_settings`
--

INSERT INTO `n36ic_hotelreservation_application_settings` VALUES
(1,'applicationsettings_id','1','',''),
(2,'currency_id','1','LNG_CURRENCY_ID','LNG_CURRENCY_ID'),
(3,'special_notes','','LNG_SPECIAL_NOTES','LNG_SPECIAL_NOTES'),
(4,'is_enable_reservation','1','LNG_ENABLE_RESERVATION','LNG_ENABLE_RESERVATION'),
(5,'is_enable_payment','1','LNG_ENABLE_PAYMENT','LNG_BY_SELECT_YES_YOU_CLIENTS_ARE_REQUIRED_TO_HAVE_A_CREDIT_CARD_IN_ORDER_TO_MAKE_RESERVATIONS'),
(6,'is_enable_https','0','LNG_ENABLE_HTTPS','LNG_ENABLE_HTTPS'),
(7,'is_site_online','1','LNG_IS_SITE_ONLINE','LNG_IS_SITE_ONLINE'),
(8,'sendmail_from','','LNG_SEND_MAIL_FROM','LNG_SEND_MAIL_FROM'),
(9,'sendmail_name','','LNG_SEND_MAIL_NAME','LNG_SEND_MAIL_NAME'),
(10,'policy','','LNG_POLICY','LNG_POLICY'),
(11,'css_style','brown.css','LNG_HOTEL_COMPONENT_STYLE','LNG_HOTEL_COMPONENT_STYLE'),
(12,'css_module_style','blue.css','LNG_CSS_MODULE','LNG_CSS_MODULE'),
(13,'company_name','Hotelia','LNG_NAME','LNG_NAME_BUSINESS_DETAILS'),
(14,'company_email','info@cmsjunkie.com','LNG_EMAIL','LNG_EMAIL_BUSINESS_DETAILS'),
(15,'is_enable_extra_options','1','LNG_ENABLE_EXTRA_OPTIONS','LNG_ENABLE_EXTRA_OPTIONS'),
(16,'show_currency_selector','0','LNG_SHOW_CURRENCY_SELECTOR','LNG_SHOW_CURRENCY_SELECTOR'),
(17,'save_all_guests_data','1','LNG_SAVE_ALL_GUEST_DATA','LNG_SAVE_ALL_GUEST_DATA'),
(18,'is_enable_offers','1','LNG_ENABLE_OFFERS','LNG_INFO_APPLICATION_SET_OFFERS_ON_OFF'),
(19,'is_email_notify_canceled_pending','1','LNG_IS_EMAIL_NOTIFY_CANCEL_PENDING','LNG_IS_EMAIL_NOTIFY_CANCEL_PENDING'),
(20,'show_price_per_person','2','LNG_DISPLAY_PRICE','LNG_DISPLAY_PRICE'),
(21,'charge_only_reservation_cost','0','LNG_CHARGE_ONLY_RESERVATION_COST','LNG_CHARGE_ONLY_RESERVATION_COST'),
(22,'is_enable_screen_airport_transfer','0','LNG_SHOW_AIRPORT_TRANSFER','LNG_SHOW_AIRPORT_TRANSFER'),
(23,'date_format_id','2','LNG_DATE_FORMAT','LNG_DATE_FORMAT'),
(24,'date_language','en_EN','LNG_DATE_LANGUAGE','LNG_DATE_LANGUAGE'),
(25,'date_location',NULL,'LNG_DATE_LOCATION','LNG_DATE_LOCATION'),
(26,'send_invoice_to_email','0','LNG_SEND_INVOICE_ONLY_TO_EMAIL','LNG_SEND_INVOICE_ONLY_TO_EMAIL'),
(27,'invoice_email','','LNG_INVOICE_EMAIL','LNG_INVOICE_EMAIL'),
(28,'hide_user_email','0','LNG_HIDE_USER_EMAIL','LNG_HIDE_USER_EMAIL'),
(29,'enable_discounts','1','LNG_ENABLE_SPECIAL_DISCOUNTS','LNG_ENABLE_SPECIAL_DISCOUNTS'),
(30,'enable_hotel_tabs','1','LNG_ENABLE_HOTEL_TABS','LNG_ENABLE_HOTEL_TABS'),
(31,'enable_hotel_gallery','1','LNG_ENABLE_HOTEL_GALLERY','LNG_ENABLE_HOTEL_GALLERY'),
(32,'enable_hotel_map','1','LNG_ENABLE_HOTEL_MAP','LNG_ENABLE_HOTEL_MAP'),
(33,'enable_hotel_description','1','LNG_ENABLE_HOTEL_DESCRIPTION','LNG_ENABLE_HOTEL_DESCRIPTION'),
(34,'enable_hotel_facilities','1','LNG_ENABLE_HOTEL_FACILITIES','LNG_ENABLE_HOTEL_FACILITIES'),
(35,'enable_hotel_information','1','LNG_ENABLE_HOTEL_INFO','LNG_ENABLE_HOTEL_INFO'),
(36,'enable_hotel_rating','1','LNG_ENABLE_HOTEL_RATING','LNG_ENABLE_HOTEL_RATING'),
(37,'enable_test_mode','1','LNG_ENABLE_TEST_MODE','LNG_ENABLE_TEST_MODE'),
(38,'enable_excursions','1','LNG_ENABLE_EXCURSIONS','LNG_ENABLE_EXCURSIONS'),
(39,'enable_children_categories','1','LNG_ENABLE_CHILDREN_CATEGORIES','LNG_ENABLE_CHILDREN_CATEGORIES'),
(40,'show_children','1','LNG_SHOW_CHILDREN','LNG_SHOW_CHILDREN'),
(41,'menu_id','','LNG_MENU_ITEM_ID','LNG_MENU_ITEM_ID'),
(42,'logo_path','/logo/logo.png','LNG_LOGO','LNG_LOGO'),
(43,'order_id','','LNG_ORDER_ID','LNG_ORDER_ID'),
(44,'order_email','','LNG_ORDER_EMAIL','LNG_ORDER_EMAIL'),
(45,'room_view','2','LNG_ROOM_VIEW_TYPE','LNG_ROOM_VIEW_TYPE'),
(46,'enable_map','1','LNG_ENABLE_MAP','LNG_ENABLE_MAP'),
(47,'enable_breadcrumb','1','LNG_ENABLE_BREADCRUMB','LNG_ENABLE_BREADCRUMB'),
(48,'children_rates_type','1','LNG_CHILDREN_RATES_TYPE','LNG_CHILDREN_RATES_TYPE'),
(49,'calendar_availability_type','1','LNG_CALENDAR_AVAILABILITY_TYPE','LNG_CALENDAR_AVAILABILITY_TYPE'),
(50,'send_cancellation_email_admin_only','0','LNG_SEND_CANCELLATION_EMAIL_ADMIN_ONLY','LNG_SEND_CANCELLATION_EMAIL_ADMIN_ONLY'),
(51,'enable_google_tag_manager','0','LNG_ENABLE_GOOGLE_TAG_MANAGER','LNG_ENABLE_GOOGLE_TAG_MANAGER'),
(52,'google_tag_manager_id','','LNG_GOOGLE_TAG_MANAGER_ID','LNG_GOOGLE_TAG_MANAGER_ID'),
(53,'enable_seo','1','LNG_ENABLE_SEO','LNG_ENABLE_SEO'),
(54,'rooms_left','-1','LNG_APP_ROOMS_LEFT','LNG_ROOM_INFO'),
(55,'google_map_key','','LNG_GOOGLE_MAP_KEY','LNG_GOOGLE_MAP_KEY'),
(56,'delimiter',',','LNG_DELIMITER','LNG_DELIMITER'),
(57,'currency_display','1','LNG_CURRENCY_DISPLAY','LNG_CURRENCY_DISPLAY'),
(58,'enable_facebook_posting','0','LNG_ENABLE_FACEBOOK_POSTING','LNG_ENABLE_FACEBOOK_POSTING'),
(59,'facebook_page_token','','LNG_FACEBOOK_PAGE_TOKEN','LNG_FACEBOOK_PAGE_TOKEN'),
(60,'apply_search_params','0','LNG_APPLY_SEARCH_PARAMS','LNG_APPLY_SEARCH_PARAMS'),
(61,'capacity_calculation','0','LNG_CAPACITY_CALCULATION','LNG_CAPACITY_CALCULATION'),
(62,'mailchimp_api_key','','LNG_MAILCHIMP_API_KEY','LNG_MAILCHIMP_API_KEY'),
(63,'mailchimp_list_id','','LNG_MAILCHIMP_LIST_ID','LNG_MAILCHIMP_LIST_ID'),
(64,'show_mail_post_option','1','LNG_ENABLE_MAIL_POST_SUBSCRIBE','LNG_ENABLE_MAIL_POST_SUBSCRIBE'),
(65,'show_digital_post_option','1','LNG_ENABLE_DIGITAL_POST_SUBSCRIBE','LNG_ENABLE_DIGITAL_POST_SUBSCRIBE'),
(66,'postcode_api_key','','LNG_API_KEY','LNG_API_KEY'),
(67,'postcode_secret_key','','LNG_SECRET_KEY','LNG_SECRET_KEY'),
(68,'use_joomla_language','1','LNG_USE_JOOMLA_LANGUAGE','LNG_USE_JOOMLA_LANGUAGE'),
(69,'hotels_search_results_style','2','LNG_SEARCH_RESULTS_VIEW_STYLE','LNG_SEARCH_RESULTS_VIEW_STYLE_DESCRIPTION'),
(70,'platform_type','0','LNG_PLATFORM_TYPE','LNG_PLATFORM_TYPE_DESCRIPTION'),
(71,'amount_separator','1','LNG_AMOUNT_SEPARATOR','LNG_AMOUNT_SEPARATOR_DESCRIPTION'),
(72,'search_filter_fields','','LNG_SEARCH_FILTER_FIELDS','LNG_SEARCH_FILTER_FIELDS_DESCRIPTION'),
(73,'search_filter_items','1','LNG_SEARCH_FILTER_ITEMS','LNG_SEARCH_FILTER_ITEMS_DESCRIPTION'),
(74,'map_type','1','LNG_MAP_TYPE','LNG_MAP_TYPE_DESCRIPTION'),
(75,'facebook','','LNG_FACEBOOK','LNG_FACEBOOK'),
(76,'twitter','','LNG_TWITTER','LNG_TWITTER'),
(77,'linkedin','','LNG_LINKEDIN','LNG_LINKEDIN'),
(78,'youtube','','LNG_YOUTUBE','LNG_YOUTUBE'),
(79,'terms_and_conditions_en-GB','',NULL,NULL),
(80,'hide_user_email0','0',NULL,NULL),
(81,'controller','applicationsettings',NULL,NULL),
(82,'dda59db5ac85d3c1394e653580f41f25','1',NULL,NULL),
(83,'terms_and_conditions','',NULL,NULL),
(84,'card_type_ids','',NULL,NULL);

--
-- Table structure for table `n36ic_hotelreservation_apps`
--

CREATE TABLE `n36ic_hotelreservation_apps` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `app_name` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `path` text DEFAULT NULL,
  `icon` varchar(50) DEFAULT '',
  `store_link` varchar(255) DEFAULT '',
  `doc_link` varchar(255) DEFAULT '',
  `version` varchar(50) DEFAULT NULL,
  `required_version` varchar(50) DEFAULT NULL,
  `type` tinyint(4) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_apps`
--

INSERT INTO `n36ic_hotelreservation_apps` VALUES
(1,'SmartHotel Channel Manager','JHP SmartHotel','Synchronize rates and availability by using SmartHotel channel manager','/components/com_jhotelreservation/classes/smarthotel/smarthotelxml.php','apps/smarthotel.png','https://www.cmsjunkie.com/joomla-hotel-booking-addons/smarthotel-channel-manger','https://cmsjunkie.com/docs/jhotelreservation/hotelreservationadministration.html#smart-hotel',NULL,NULL,1),
(2,'Cubilis Channel Manager','JHP Cubilis','Synchronize rates and availability by using Cubilis channel manager','/components/com_jhotelreservation/classes/cubilis/cubilisxml.php','apps/cubilis.png','https://www.cmsjunkie.com/joomla-hotel-booking-addons/cubilis-channel-manger','https://cmsjunkie.com/docs/jhotelreservation/hotelreservationadministration.html#cubilis',NULL,NULL,1),
(3,'OpenGDS Channel Manager','JHP OpenGDS','Synchronize rates and availability by using OpenGDS channel manager','/components/com_jhotelreservation/classes/opengds/OpenGDSService.php','apps/cubilis.png','https://www.cmsjunkie.com/joomla-hotel-booking-addons/open-gds-channel-manger','https://cmsjunkie.com/docs/jhotelreservation/hotelreservationadministration.html#opengds',NULL,NULL,1),
(4,'Beds24 Channel Manager','JHP Beds24','Synchronize rates and availability by using Beds24 channel manager','/components/com_jhotelreservation/classes/beds24/beds24xml.php','apps/cubilis.png','https://www.cmsjunkie.com/joomla-hotel-booking-addons/beds24-channel-manger','https://cmsjunkie.com/docs/jhotelreservation/hotelreservationadministration.html#beds24',NULL,NULL,1),
(5,'RezExchange Channel Manager','JHP Beds24','Synchronize rates and availability by using RezExchange channel manager','/components/com_jhotelreservation/classes/cubilis/cubilisxml.php','apps/cubilis.png','https://www.cmsjunkie.com/joomla-hotel-booking-addons/rezexchange-channel-manger','https://cmsjunkie.com/docs/jhotelreservation/hotelreservationadministration.html#cubilis',NULL,NULL,1),
(6,'Converge Payment Processor','JHP Converge','Collect payments using Converge','/components/com_jhotelreservation/classes/payment/processors/converge.php','apps/converge.png','https://www.cmsjunkie.com/joomla-hotel-booking-addons/jhp-converge','https://cmsjunkie.com/docs/jhotelreservation/hotelreservationadministration.html#converge',NULL,NULL,1),
(7,'Buckaroo Payment Processor','JHP Buckaroo','Collect payments using Buckaroo','/components/com_jhotelreservation/classes/payment/processors/Buckaroo.php','apps/buckaroo.png','https://www.cmsjunkie.com/joomla-hotel-booking-addons/jhp-buckaroo','https://cmsjunkie.com/docs/jhotelreservation/hotelreservationadministration.html#buckaroo',NULL,NULL,1),
(8,'Authorize Payment Processors','JHP Authorize','Collect payments using Authorize','/components/com_jhotelreservation/classes/payment/processors/authorize.php','apps/authorize.png','https://www.cmsjunkie.com/joomla-hotel-booking-addons/jhp-authorize','https://cmsjunkie.com/docs/jhotelreservation/hotelreservationadministration.html#authorize',NULL,NULL,1),
(9,'PostCode NL Integration','JHP NLPostCode','Postcode.nl integration','/components/com_jhotelreservation/classes/services/PostCodeRestClient.php','apps/postcode.png','https://www.cmsjunkie.com/joomla-hotel-booking-addons/jhp-postcodenl','https://cmsjunkie.com/docs/jhotelreservation/hotelreservationadministration.html#post-code',NULL,NULL,1),
(10,'Hour Reservations','JHP Hour Reservations','Grant access to functionality based on user role','/administrator/components/com_jhotelreservation/models/usersmanagemesssnt.php','apps/hour_reservations.png','https://www.cmsjunkie.com/joomla-hotel-booking-addons/jhp-hour-booking','https://cmsjunkie.com/docs/jhotelreservation/hotelreservationadministration.html#hour-reservations',NULL,NULL,1),
(11,'Nearby Attractions','JHP Nearby Attractions','Attract customers by showing nearby attractions and points of interest','/administrator/components/com_jhotelreservation/views/interestpoints','apps/attractions.png','https://www.cmsjunkie.com/joomla-hotel-booking-addons/jhp-nearby-attractions','https://cmsjunkie.com/docs/jhotelreservation/hotelreservationadministration.html#poi',NULL,NULL,1),
(12,'Google Tag Manager','JHP Tag Manager','Google Tag Manager integration','/components/com_jhotelreservation/classes/services/TagManagerService.php','apps/tagmanager.png','https://www.cmsjunkie.com/joomla-hotel-booking-addons/jhp-tagmanager','https://cmsjunkie.com/docs/jhotelreservation/hotelreservationadministration.html#google-tag-amanger',NULL,NULL,1),
(13,'MailChimp Integration','JHP MailChimp','MailChimp Integration','/components/com_jhotelreservation/classes/services/MailChimp.php','apps/mailchimp.png','https://www.cmsjunkie.com/joomla-hotel-booking-addons/jhp-mailchimp','https://cmsjunkie.com/docs/jhotelreservation/hotelreservationadministration.html#mail-chimp',NULL,NULL,1),
(14,'Excursions & Courses','Excursions & Courses','Allows the possibility to offer tours and car rentals and book them online/jhp-tours_car_rentals','/components/com_jhotelreservation/classes/services/ExcursionsService.php','apps/tours_car_rentals.png','https://www.cmsjunkie.com/joomla-hotel-booking-addons/jhp-courses-excursions','https://cmsjunkie.com/docs/jhotelreservation/hotelreservationadministration.html#tours-car-rental',NULL,NULL,1),
(15,'Airport Transfer','JHP Airport Transfer','Allows the possibility to offer airport transfer to your customers','/components/com_jhotelreservation/classes/services/AirporttransferService.php','apps/airporttransfer.png','https://www.cmsjunkie.com/joomla-hotel-booking-addons/jhp-airport-transfer','https://cmsjunkie.com/docs/jhotelreservation/hotelreservationadministration.html#airport-transfer',NULL,NULL,1),
(16,'XPay Payment Processor','JHP XPay','Collect payments using XPay','/components/com_jhotelreservation/classes/payment/processors/xpay.php','apps/xpay.png','https://www.cmsjunkie.com/joomla-hotel-booking-addons/jhp-xpay','https://cmsjunkie.com/docs/jhotelreservation/hotelreservationadministration.html#xpay',NULL,NULL,1),
(17,'Square Payment Processor','JHP Square','Collect payments using Square','/components/com_jhotelreservation/classes/payment/processors/square.php','apps/xpay.png','https://www.cmsjunkie.com/joomla-hotel-booking-addons/jhp-square','https://cmsjunkie.com/docs/jhotelreservation/hotelreservationadministration.html#square',NULL,NULL,1),
(18,'Stripe Payment Processor','JHP Stripe','Collect payments using Stripe','/components/com_jhotelreservation/classes/payment/processors/stripeProcessor.php','apps/stripe.png','https://www.cmsjunkie.com/joomla-hotel-booking-addons/jhp-stripe','https://cmsjunkie.com/docs/jhotelreservation/hotelreservationadministration.html#stripe','1.1.1',NULL,1),
(19,'Skrill Payment Processor','JHP Skrill','Collect payments using Skrill','/components/com_jhotelreservation/classes/payment/processors/skrill.php','apps/skrill.png','https://www.cmsjunkie.com/joomla-hotel-booking-addons/jhp-skrill','https://cmsjunkie.com/docs/jhotelreservation/hotelreservationadministration.html#skrill',NULL,NULL,1),
(20,'PayULatam Payment Processor','JHP PayULatam','Collect payments using PayULatam','/components/com_jhotelreservation/classes/payment/processors/Payulatam.php','apps/payulatam.png','https://www.cmsjunkie.com/joomla-hotel-booking-addons/jhp-payu-latam','https://cmsjunkie.com/docs/jhotelreservation/hotelreservationadministration.html#PayULatam',NULL,NULL,1),
(21,'PayPal Payment Processor','JHP PayPal','Collect payments using PayPal','/components/com_jhotelreservation/classes/payment/processors/Paypal.php','apps/paypal.png','https://www.cmsjunkie.com/joomla-hotel-booking-addons/jhp-paypal','https://cmsjunkie.com/docs/jhotelreservation/hotelreservationadministration.html#paypal',NULL,NULL,1),
(22,'Wire Transfer Payment Processor','JHP Wire Transfer','Collect payments using Wire Transfer','/components/com_jhotelreservation/classes/payment/processors/WireTransfer.php','apps/wiretransfer.png','https://www.cmsjunkie.com/joomla-hotel-booking-addons/jhp-wire-transfer','https://cmsjunkie.com/docs/jhotelreservation/hotelreservationadministration.html#wire',NULL,NULL,1),
(23,'Offline Credit Card','JHP OfflineCreditCard','Collect payments using Offline Credit Card','/components/com_jhotelreservation/classes/payment/processors/OfflineCreditCard.php','apps/offlinecreditcard.png','https://www.cmsjunkie.com/joomla-hotel-booking-addons/jhp-offlinecreditcard','https://cmsjunkie.com/docs/jhotelreservation/hotelreservationadministration.html#offline-credit-card-processor',NULL,NULL,2);

--
-- Table structure for table `n36ic_hotelreservation_beds24`
--

CREATE TABLE `n36ic_hotelreservation_beds24` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `api_key` varchar(30) DEFAULT NULL,
  `description` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_beds24`
--


--
-- Table structure for table `n36ic_hotelreservation_beds24_properties_mapping`
--

CREATE TABLE `n36ic_hotelreservation_beds24_properties_mapping` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `hotel_id` int(11) DEFAULT NULL,
  `beds24_id` int(11) DEFAULT NULL,
  `beds24_propKey` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_beds24_properties_mapping`
--


--
-- Table structure for table `n36ic_hotelreservation_changelog`
--

CREATE TABLE `n36ic_hotelreservation_changelog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `reservation_id` int(11) DEFAULT NULL,
  `date` timestamp NULL DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `user_name` varchar(255) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `reservation_id` (`reservation_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_changelog`
--


--
-- Table structure for table `n36ic_hotelreservation_channelmanager_mappings`
--

CREATE TABLE `n36ic_hotelreservation_channelmanager_mappings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `channel_manager` varchar(25) DEFAULT NULL,
  `item_id` int(11) DEFAULT NULL,
  `channel_item_id` int(11) DEFAULT NULL,
  `mapping_type` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_channelmanager_mappings`
--


--
-- Table structure for table `n36ic_hotelreservation_children_categories`
--

CREATE TABLE `n36ic_hotelreservation_children_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `hotel_id` tinyint(10) DEFAULT NULL,
  `name` varchar(45) DEFAULT NULL,
  `min_age` tinyint(3) DEFAULT NULL,
  `max_age` tinyint(3) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_children_categories`
--


--
-- Table structure for table `n36ic_hotelreservation_children_categories_prices`
--

CREATE TABLE `n36ic_hotelreservation_children_categories_prices` (
  `rate_id` int(11) NOT NULL DEFAULT 0,
  `category_id` int(11) NOT NULL DEFAULT 0,
  `price` decimal(12,2) DEFAULT NULL,
  PRIMARY KEY (`rate_id`,`category_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_children_categories_prices`
--


--
-- Table structure for table `n36ic_hotelreservation_children_categories_rate_prices`
--

CREATE TABLE `n36ic_hotelreservation_children_categories_rate_prices` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rate_id` int(11) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `price` decimal(12,2) DEFAULT NULL,
  `category_id` tinyint(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_children_categories_rate_prices`
--


--
-- Table structure for table `n36ic_hotelreservation_confirmations`
--

CREATE TABLE `n36ic_hotelreservation_confirmations` (
  `confirmation_id` int(10) NOT NULL AUTO_INCREMENT,
  `data` datetime NOT NULL DEFAULT current_timestamp(),
  `hotel_id` int(10) DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT current_timestamp(),
  `modified` timestamp NULL DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `adults` mediumint(8) unsigned DEFAULT NULL,
  `children` mediumint(8) unsigned NOT NULL DEFAULT 0,
  `juniors` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `babies` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `rooms` mediumint(8) unsigned DEFAULT NULL,
  `coupon_code` varchar(255) DEFAULT NULL,
  `first_name` char(255) DEFAULT NULL,
  `last_name` char(255) DEFAULT NULL,
  `arrival_time` varchar(45) DEFAULT NULL,
  `remarks` blob DEFAULT NULL,
  `remarks_admin` blob DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `street_number` varchar(100) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `state_name` varchar(255) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `postal_code` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `conf_email` varchar(255) DEFAULT NULL,
  `confirmation_details` blob DEFAULT NULL,
  `reservation_status` mediumint(9) DEFAULT NULL,
  `total` decimal(18,2) NOT NULL DEFAULT 0.00,
  `total_cost` decimal(18,2) DEFAULT NULL,
  `reservation_cost` decimal(18,2) DEFAULT NULL,
  `total_payed` decimal(18,2) NOT NULL DEFAULT 0.00,
  `user_id` int(10) unsigned NOT NULL DEFAULT 0,
  `media_referer` varchar(100) DEFAULT NULL,
  `voucher` varchar(100) DEFAULT NULL,
  `review_email_date` datetime DEFAULT NULL,
  `company_name` varchar(100) DEFAULT NULL,
  `guest_type` tinyint(4) DEFAULT NULL,
  `discount_code` varchar(100) DEFAULT NULL,
  `cancellation_notes` varchar(255) DEFAULT NULL,
  `cancellation_notes_other` varchar(255) DEFAULT NULL,
  `cancellation_percent` decimal(10,2) DEFAULT NULL,
  `language_tag` varchar(25) DEFAULT NULL,
  `cubilis_status` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `beds24_status` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `smarthotel_status` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `opengds_status` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `children_ages` varchar(255) DEFAULT NULL,
  `subscribe_mail_post` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `subscribe_digital_newsletter` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `reviewable` tinyint(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`confirmation_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2867 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_confirmations`
--


--
-- Table structure for table `n36ic_hotelreservation_confirmations_discounts`
--

CREATE TABLE `n36ic_hotelreservation_confirmations_discounts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `reservation_id` int(11) DEFAULT NULL,
  `discount_id` int(11) DEFAULT NULL,
  `discount_code` varchar(50) DEFAULT NULL,
  `name` char(255) DEFAULT NULL,
  `value` float(18,2) DEFAULT NULL,
  `is_percent` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_confirmations_discounts`
--


--
-- Table structure for table `n36ic_hotelreservation_confirmations_excursions`
--

CREATE TABLE `n36ic_hotelreservation_confirmations_excursions` (
  `confirmation_excursion_id` int(10) NOT NULL AUTO_INCREMENT,
  `excursion_id` int(10) DEFAULT NULL,
  `confirmation_id` int(10) DEFAULT NULL,
  `hotel_id` int(11) DEFAULT NULL,
  `nr_booked` int(10) DEFAULT NULL,
  `current` int(10) DEFAULT NULL,
  `excursion_name` char(255) DEFAULT NULL,
  PRIMARY KEY (`confirmation_excursion_id`),
  UNIQUE KEY `NewIndex` (`confirmation_excursion_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_confirmations_excursions`
--


--
-- Table structure for table `n36ic_hotelreservation_confirmations_excursions_prices`
--

CREATE TABLE `n36ic_hotelreservation_confirmations_excursions_prices` (
  `confirmation_excursion_price_id` int(11) NOT NULL AUTO_INCREMENT,
  `confirmation_excursion_id` int(11) DEFAULT NULL,
  `date` date NOT NULL,
  `price` decimal(8,2) DEFAULT NULL,
  PRIMARY KEY (`confirmation_excursion_price_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_confirmations_excursions_prices`
--


--
-- Table structure for table `n36ic_hotelreservation_confirmations_extra_options`
--

CREATE TABLE `n36ic_hotelreservation_confirmations_extra_options` (
  `confirmation_extra_option_id` int(10) NOT NULL AUTO_INCREMENT,
  `confirmation_id` int(10) NOT NULL DEFAULT 0,
  `hotel_id` int(10) DEFAULT NULL,
  `offer_id` int(10) DEFAULT NULL,
  `room_id` int(10) DEFAULT NULL,
  `current` tinyint(4) DEFAULT NULL,
  `extra_option_id` int(10) NOT NULL DEFAULT 0,
  `extra_option_name` char(255) NOT NULL DEFAULT '',
  `extra_option_price_type` tinyint(1) DEFAULT NULL,
  `extra_option_is_per_day` tinyint(1) DEFAULT NULL,
  `extra_option_mandatory` tinyint(1) DEFAULT NULL,
  `extra_option_price` decimal(15,2) DEFAULT NULL,
  `extra_option_persons` int(8) DEFAULT NULL,
  `extra_option_days` int(8) DEFAULT NULL,
  `extra_option_multiplier` int(3) DEFAULT NULL,
  `extra_option_dates` varchar(255) DEFAULT NULL,
  `extra_commission` tinyint(4) DEFAULT NULL,
  `extra_option_cost` float(18,2) NOT NULL DEFAULT 0.00,
  PRIMARY KEY (`confirmation_extra_option_id`),
  UNIQUE KEY `NewIndex` (`offer_id`,`confirmation_id`,`extra_option_id`,`hotel_id`,`room_id`,`current`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_confirmations_extra_options`
--


--
-- Table structure for table `n36ic_hotelreservation_confirmations_guests`
--

CREATE TABLE `n36ic_hotelreservation_confirmations_guests` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `confirmation_id` int(11) DEFAULT NULL,
  `first_name` varchar(100) DEFAULT NULL,
  `last_name` varchar(100) DEFAULT NULL,
  `identification_number` varchar(45) DEFAULT NULL,
  `age` tinyint(3) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `n36ic_hotelreservation_confirmations_guests`
--


--
-- Table structure for table `n36ic_hotelreservation_confirmations_payments`
--

CREATE TABLE `n36ic_hotelreservation_confirmations_payments` (
  `confirmation_payment_id` int(10) NOT NULL AUTO_INCREMENT,
  `confirmation_id` int(10) NOT NULL DEFAULT 0,
  `processor_id` int(3) DEFAULT NULL,
  `processor_type` varchar(100) NOT NULL DEFAULT '0',
  `created` timestamp NULL DEFAULT current_timestamp(),
  `payment_date` date DEFAULT NULL,
  `transaction_id` int(10) DEFAULT NULL,
  `amount` decimal(8,2) DEFAULT NULL,
  `currency` char(5) DEFAULT NULL,
  `payment_method` varchar(100) DEFAULT NULL,
  `response_code` varchar(45) DEFAULT NULL,
  `message` blob DEFAULT NULL,
  `card_name` varchar(50) DEFAULT NULL,
  `card_number` varchar(25) DEFAULT NULL,
  `card_expiration_month` varchar(2) DEFAULT NULL,
  `card_expiration_year` varchar(4) DEFAULT NULL,
  `card_security_code` varchar(6) DEFAULT NULL,
  `payment_status` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`confirmation_payment_id`),
  KEY `NewIndex` (`confirmation_id`,`transaction_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_confirmations_payments`
--


--
-- Table structure for table `n36ic_hotelreservation_confirmations_room_prices`
--

CREATE TABLE `n36ic_hotelreservation_confirmations_room_prices` (
  `confirmation_room_price_id` int(11) NOT NULL AUTO_INCREMENT,
  `confirmation_room_id` int(11) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `price` decimal(18,2) DEFAULT NULL,
  PRIMARY KEY (`confirmation_room_price_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_confirmations_room_prices`
--

INSERT INTO `n36ic_hotelreservation_confirmations_room_prices` VALUES
(1,1,'2013-07-12',100.00),
(2,1,'2013-07-13',100.00);

--
-- Table structure for table `n36ic_hotelreservation_confirmations_rooms`
--

CREATE TABLE `n36ic_hotelreservation_confirmations_rooms` (
  `confirmation_room_id` int(10) NOT NULL AUTO_INCREMENT,
  `confirmation_id` int(10) NOT NULL DEFAULT 0,
  `hotel_id` int(11) DEFAULT NULL,
  `offer_id` int(10) DEFAULT NULL,
  `room_id` int(10) DEFAULT NULL,
  `current` int(10) DEFAULT NULL,
  `room_name` char(255) DEFAULT NULL,
  `adults` tinyint(2) DEFAULT NULL,
  `children` tinyint(4) DEFAULT NULL,
  `juniors` tinyint(4) DEFAULT NULL,
  `babies` tinyint(4) DEFAULT NULL,
  `bed_preference` mediumint(9) DEFAULT NULL,
  `smoking_preference` mediumint(9) DEFAULT NULL,
  PRIMARY KEY (`confirmation_room_id`),
  UNIQUE KEY `NewIndex` (`offer_id`,`confirmation_id`,`room_id`,`current`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_confirmations_rooms`
--

INSERT INTO `n36ic_hotelreservation_confirmations_rooms` VALUES
(1,2866,11,2,28,1,'Standard Room',2,0,NULL,NULL,NULL,NULL);

--
-- Table structure for table `n36ic_hotelreservation_confirmations_rooms_airport_transfer`
--

CREATE TABLE `n36ic_hotelreservation_confirmations_rooms_airport_transfer` (
  `confirmation_airport_transfer_id` int(10) NOT NULL AUTO_INCREMENT,
  `confirmation_id` int(10) NOT NULL,
  `hotel_id` int(10) NOT NULL,
  `offer_id` int(10) NOT NULL,
  `room_id` int(10) NOT NULL,
  `current` tinyint(4) NOT NULL,
  `airport_transfer_type_id` int(10) NOT NULL DEFAULT 0,
  `airport_transfer_type_name` char(255) DEFAULT NULL,
  `airport_transfer_type_price` float(18,2) DEFAULT NULL,
  `airport_transfer_type_vat` float(18,2) DEFAULT NULL,
  `airline_id` int(10) NOT NULL DEFAULT 0,
  `airline_name` char(255) DEFAULT NULL,
  `airport_transfer_flight_nr` char(255) DEFAULT NULL,
  `airport_transfer_date` date DEFAULT NULL,
  `airport_transfer_time_hour` int(11) DEFAULT NULL,
  `airport_transfer_time_min` int(11) DEFAULT NULL,
  `airport_transfer_guest` int(10) DEFAULT NULL,
  `included_offer` tinyint(1) NOT NULL DEFAULT 0,
  `selected` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`confirmation_airport_transfer_id`),
  UNIQUE KEY `NewIndex` (`hotel_id`,`confirmation_id`,`airport_transfer_type_id`,`offer_id`,`room_id`,`current`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_confirmations_rooms_airport_transfer`
--


--
-- Table structure for table `n36ic_hotelreservation_confirmations_taxes`
--

CREATE TABLE `n36ic_hotelreservation_confirmations_taxes` (
  `confirmation_tax_id` int(10) NOT NULL AUTO_INCREMENT,
  `confirmation_id` int(10) NOT NULL DEFAULT 0,
  `hotel_id` int(10) DEFAULT NULL,
  `datas` date DEFAULT NULL,
  `datae` date DEFAULT NULL,
  `tax_id` int(10) DEFAULT NULL,
  `tax_name` char(255) DEFAULT NULL,
  `tax_value` decimal(18,2) NOT NULL DEFAULT 0.00,
  `tax_type` enum('Fixed','Percent') DEFAULT NULL,
  PRIMARY KEY (`confirmation_tax_id`),
  UNIQUE KEY `NewIndex` (`datae`,`datas`,`confirmation_id`,`tax_id`,`hotel_id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_confirmations_taxes`
--


--
-- Table structure for table `n36ic_hotelreservation_countries`
--

CREATE TABLE `n36ic_hotelreservation_countries` (
  `country_id` int(10) NOT NULL AUTO_INCREMENT,
  `country_name` char(255) DEFAULT NULL,
  `country_currency` char(255) DEFAULT NULL,
  `country_currency_short` char(50) DEFAULT NULL,
  `country_currency_symbol` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`country_id`)
) ENGINE=MyISAM AUTO_INCREMENT=245 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_countries`
--

INSERT INTO `n36ic_hotelreservation_countries` VALUES
(1,'Andorra','Euro','EUR','&#8364;'),
(2,'United Arab Emirates','UAE Dirham','AED',NULL),
(3,'Afghanistan','Afghani','AFA',NULL),
(4,'Antigua and Barbuda','East Caribbean Dollar','XCD',NULL),
(5,'Anguilla','East Caribbean Dollar','XCD',NULL),
(6,'Albania','Lek','ALL',NULL),
(7,'Armenia','Armenian Dram','AMD',NULL),
(8,'Netherlands Antilles','Netherlands Antillean guilder','ANG',NULL),
(9,'Angola','Kwanza','AOA',NULL),
(11,'Argentina','Argentine Peso','ARS',NULL),
(12,'American Samoa','US Dollar','USD','&#36;'),
(13,'Austria','Euro','EUR','&#8364;'),
(14,'Australia','Australian dollar','AUD',NULL),
(15,'Aruba','Aruban Guilder','AWG',NULL),
(16,'Azerbaijan','Azerbaijani Manat','AZM',NULL),
(17,'Bosnia and Herzegovina','Convertible Marka','BAM',NULL),
(18,'Barbados','Barbados Dollar','BBD',NULL),
(19,'Bangladesh','Taka','BDT',NULL),
(20,'Belgium','Euro','EUR','&#8364;'),
(21,'Burkina Faso','CFA Franc BCEAO','XOF',NULL),
(22,'Bulgaria','Lev','BGL',NULL),
(23,'Bahrain','Bahraini Dinar','BHD',NULL),
(24,'Burundi','Burundi Franc','BIF',NULL),
(25,'Benin','CFA Franc BCEAO','XOF',NULL),
(26,'Bermuda','Bermudian Dollar','BMD',NULL),
(27,'Brunei Darussalam','Brunei Dollar','BND',NULL),
(28,'Bolivia','Boliviano','BOB',NULL),
(29,'Brazil','Brazilian Real','BRL',NULL),
(30,'The Bahamas','Bahamian Dollar','BSD',NULL),
(31,'Bhutan','Ngultrum','BTN',NULL),
(32,'Bouvet Island','Norwegian Krone','NOK',NULL),
(33,'Botswana','Pula','BWP',NULL),
(34,'Belarus','Belarussian Ruble','BYR',NULL),
(35,'Belize','Belize Dollar','BZD',NULL),
(36,'Canada','Canadian Dollar','CAD',NULL),
(37,'Cocos (Keeling) Islands','Australian Dollar','AUD',NULL),
(38,'Congo','Franc Congolais','CDF',NULL),
(39,'Central African Republic','CFA Franc BEAC','XAF',NULL),
(41,'Switzerland','Swiss Franc','CHF','&#8355;'),
(42,'Cote d\'Ivoire','CFA Franc BCEAO','XOF',NULL),
(43,'Cook Islands','New Zealand Dollar','NZD',NULL),
(44,'Chile','Chilean Peso','CLP',NULL),
(45,'Cameroon','CFA Franc BEAC','XAF',NULL),
(46,'China','Yuan Renminbi','CNY',NULL),
(47,'Colombia','Colombian Peso','COP',NULL),
(48,'Costa Rica','Costa Rican Colon','CRC',NULL),
(49,'Cuba','Cuban Peso','CUP',NULL),
(50,'Cape Verde','Cape Verdean Escudo','CVE',NULL),
(51,'Christmas Island','Australian Dollar','AUD',NULL),
(52,'Cyprus','Cyprus Pound','CYP',NULL),
(53,'Czech Republic','Czech Koruna','CZK',NULL),
(54,'Germany','Euro','EUR','&#8364;'),
(55,'Djibouti','Djibouti Franc','DJF',NULL),
(56,'Denmark','Danish Krone','DKK',NULL),
(57,'Dominica','East Caribbean Dollar','XCD',NULL),
(58,'Dominican Republic','Dominican Peso','DOP',NULL),
(59,'Algeria','Algerian Dinar','DZD',NULL),
(60,'Ecuador','US dollar','USD','&#36;'),
(61,'Estonia','Kroon','EEK',NULL),
(62,'Egypt','Egyptian Pound','EGP',NULL),
(63,'Western Sahara','Moroccan Dirham','MAD',NULL),
(64,'Eritrea','Nakfa','ERN',NULL),
(65,'Spain','Euro','EUR','&#8364;'),
(66,'Ethiopia','Ethiopian Birr','ETB',NULL),
(67,'Finland','Euro','EUR','&#8364;'),
(68,'Fiji','Fijian Dollar','FJD',NULL),
(69,'Falkland Islands (Islas Malvinas)','Falkland Islands Pound','FKP',NULL),
(70,'Micronesia, Federated States','US dollar','USD','&#36;'),
(71,'Faroe Islands','Danish Krone','DKK',NULL),
(72,'France','Euro','EUR','&#8364;'),
(74,'Gabon','CFA Franc BEAC','XAF',NULL),
(75,'Grenada','East Caribbean Dollar','XCD',NULL),
(76,'Georgia','Lari','GEL',NULL),
(77,'French Guiana','Euro','EUR','&#8364;'),
(78,'Guernsey','Pound Sterling','GBP','&#163;'),
(79,'Ghana','Cedi','GHC',NULL),
(80,'Gibraltar','Gibraltar Pound','GIP',NULL),
(81,'Greenland','Danish Krone','DKK',NULL),
(82,'The Gambia','Dalasi','GMD',NULL),
(83,'Guinea','Guinean Franc','GNF',NULL),
(84,'Guadeloupe','Euro','EUR','&#8364;'),
(85,'Equatorial Guinea','CFA Franc BEAC','XAF',NULL),
(86,'Greece','Euro','EUR','&#8364;'),
(87,'South Georgia and the South Sandwich Islands','Pound Sterling','GBP','&#163;'),
(88,'Guatemala','Quetzal','GTQ',NULL),
(89,'Guam','US Dollar','USD','&#36;'),
(90,'Guinea-Bissau','CFA Franc BCEAO','XOF',NULL),
(91,'Guyana','Guyana Dollar','GYD',NULL),
(92,'Hong Kong (SAR)','Hong Kong Dollar','HKD',NULL),
(93,'Heard Island and McDonald Islands','Australian Dollar','AUD',NULL),
(94,'Honduras','Lempira','HNL',NULL),
(95,'Croatia','Kuna','HRK',NULL),
(96,'Haiti','Gourde','HTG',NULL),
(97,'Hungary','Forint','HUF',NULL),
(98,'Indonesia','Rupiah','IDR',NULL),
(99,'Ireland','Euro','EUR','&#8364;'),
(100,'Israel','New Israeli Sheqel','ILS',NULL),
(102,'India','Indian Rupee','INR',NULL),
(103,'British Indian Ocean Territory','US Dollar','USD','&#36;'),
(104,'Iraq','Iraqi Dinar','IQD',NULL),
(105,'Iran','Iranian Rial','IRR',NULL),
(106,'Iceland','Iceland Krona','ISK',NULL),
(107,'Italy','Euro','EUR','&#8364;'),
(108,'Jersey','Pound Sterling','GBP','&#163;'),
(109,'Jamaica','Jamaican dollar','JMD',NULL),
(110,'Jordan','Jordanian Dinar','JOD',NULL),
(111,'Japan','Yen','JPY','&#165;'),
(112,'Kenya','Kenyan shilling','KES',NULL),
(113,'Kyrgyzstan','Som','KGS',NULL),
(114,'Cambodia','Riel','KHR',NULL),
(115,'Kiribati','Australian dollar','AUD',NULL),
(116,'Comoros','Comoro Franc','KMF',NULL),
(117,'Saint Kitts and Nevis','East Caribbean Dollar','XCD',NULL),
(118,'Korea, North','North Korean Won','KPW',NULL),
(119,'Korea, South','Won','KRW',NULL),
(120,'Kuwait','Kuwaiti Dinar','KWD',NULL),
(121,'Cayman Islands','Cayman Islands Dollar','KYD',NULL),
(122,'Kazakhstan','Tenge','KZT',NULL),
(123,'Laos','Kip','LAK',NULL),
(124,'Lebanon','Lebanese Pound','LBP',NULL),
(125,'Saint Lucia','East Caribbean Dollar','XCD',NULL),
(126,'Liechtenstein','Swiss Franc','CHF','&#8355;'),
(127,'Sri Lanka','Sri Lanka Rupee','LKR',NULL),
(128,'Liberia','Liberian Dollar','LRD',NULL),
(129,'Lesotho','Loti','LSL',NULL),
(130,'Lithuania','Lithuanian Litas','LTL',NULL),
(131,'Luxembourg','Euro','EUR','&#8364;'),
(132,'Latvia','Latvian Lats','LVL',NULL),
(133,'Libya','Libyan Dinar','LYD',NULL),
(134,'Morocco','Moroccan Dirham','MAD',NULL),
(135,'Monaco','Euro','EUR','&#8364;'),
(136,'Moldova','Moldovan Leu','MDL',NULL),
(137,'Madagascar','Malagasy Franc','MGF',NULL),
(138,'Marshall Islands','US dollar','USD','&#36;'),
(139,'Macedonia','Denar','MKD',NULL),
(140,'Mali','CFA Franc BCEAO','XOF',NULL),
(141,'Burma','kyat','MMK',NULL),
(142,'Mongolia','Tugrik','MNT',NULL),
(143,'Macao','Pataca','MOP',NULL),
(144,'Northern Mariana Islands','US Dollar','USD','&#36;'),
(145,'Martinique','Euro','EUR','&#8364;'),
(146,'Mauritania','Ouguiya','MRO',NULL),
(147,'Montserrat','East Caribbean Dollar','XCD',NULL),
(148,'Malta','Maltese Lira','MTL',NULL),
(149,'Mauritius','Mauritius Rupee','MUR',NULL),
(150,'Maldives','Rufiyaa','MVR',NULL),
(151,'Malawi','Kwacha','MWK',NULL),
(152,'Mexico','Mexican Peso','MXN',NULL),
(153,'Malaysia','Malaysian Ringgit','MYR',NULL),
(154,'Mozambique','Metical','MZM',NULL),
(155,'Namibia','Namibian Dollar','NAD',NULL),
(156,'New Caledonia','CFP Franc','XPF',NULL),
(157,'Niger','CFA Franc BCEAO','XOF',NULL),
(158,'Norfolk Island','Australian Dollar','AUD',NULL),
(159,'Nigeria','Naira','NGN',NULL),
(160,'Nicaragua','Cordoba Oro','NIO',NULL),
(161,'Netherlands','Euro','EUR','&#8364;'),
(162,'Norway','Norwegian Krone','NOK',NULL),
(163,'Nepal','Nepalese Rupee','NPR',NULL),
(164,'Nauru','Australian Dollar','AUD',NULL),
(165,'Niue','New Zealand Dollar','NZD',NULL),
(166,'New Zealand','New Zealand Dollar','NZD',NULL),
(167,'Oman','Rial Omani','OMR',NULL),
(168,'Panama','balboa','PAB',NULL),
(169,'Peru','Nuevo Sol','PEN',NULL),
(170,'French Polynesia','CFP Franc','XPF',NULL),
(171,'Papua New Guinea','Kina','PGK',NULL),
(172,'Philippines','Philippine Peso','PHP',NULL),
(173,'Pakistan','Pakistan Rupee','PKR',NULL),
(174,'Poland','Zloty','PLN',NULL),
(175,'Saint Pierre and Miquelon','Euro','EUR','&#8364;'),
(176,'Pitcairn Islands','New Zealand Dollar','NZD',NULL),
(177,'Puerto Rico','US dollar','USD','&#36;'),
(179,'Portugal','Euro','EUR','&#8364;'),
(180,'Palau','US dollar','USD','&#36;'),
(181,'Paraguay','Guarani','PYG',NULL),
(182,'Qatar','Qatari Rial','QAR',NULL),
(183,'R','Euro','EUR','&#8364;'),
(184,'Romania','Leu','RON',NULL),
(185,'Russia','Russian Ruble','RUB',NULL),
(186,'Rwanda','Rwanda Franc','RWF',NULL),
(187,'Saudi Arabia','Saudi Riyal','SAR',NULL),
(188,'Solomon Islands','Solomon Islands Dollar','SBD',NULL),
(189,'Seychelles','Seychelles Rupee','SCR',NULL),
(190,'Sudan','Sudanese Dinar','SDD',NULL),
(191,'Sweden','Swedish Krona','SEK',NULL),
(192,'Singapore','Singapore Dollar','SGD',NULL),
(193,'Saint Helena','Saint Helenian Pound','SHP',NULL),
(194,'Slovenia','Tolar','SIT',NULL),
(195,'Svalbard','Norwegian Krone','NOK',NULL),
(196,'Slovakia','Slovak Koruna','SKK',NULL),
(197,'Sierra Leone','Leone','SLL',NULL),
(198,'San Marino','Euro','EUR','&#8364;'),
(199,'Senegal','CFA Franc BCEAO','XOF',NULL),
(200,'Somalia','Somali Shilling','SOS',NULL),
(201,'Suriname','Suriname Guilder','SRG',NULL),
(202,'S','Dobra','STD',NULL),
(203,'El Salvador','El Salvador Colon','SVC',NULL),
(204,'Syria','Syrian Pound','SYP',NULL),
(205,'Swaziland','Lilangeni','SZL',NULL),
(206,'Turks and Caicos Islands','US Dollar','USD','&#36;'),
(207,'Chad','CFA Franc BEAC','XAF',NULL),
(208,'French Southern and Antarctic Lands','Euro','EUR','&#8364;'),
(209,'Togo','CFA Franc BCEAO','XOF',NULL),
(210,'Thailand','Baht','THB',NULL),
(211,'Tajikistan','Somoni','TJS',NULL),
(212,'Tokelau','New Zealand Dollar','NZD',NULL),
(213,'Turkmenistan','Manat','TMM',NULL),
(214,'Tunisia','Tunisian Dinar','TND',NULL),
(215,'Tonga','Pa\'anga','TOP',NULL),
(216,'East Timor','Timor Escudo','TPE',NULL),
(217,'Turkey','Turkish Lira','TRL',NULL),
(218,'Trinidad and Tobago','Trinidad and Tobago Dollar','TTD',NULL),
(219,'Tuvalu','Australian Dollar','AUD',NULL),
(220,'Taiwan','New Taiwan Dollar','TWD',NULL),
(221,'Tanzania','Tanzanian Shilling','TZS',NULL),
(222,'Ukraine','Hryvnia','UAH',NULL),
(223,'Uganda','Uganda Shilling','UGX',NULL),
(224,'United Kingdom','Pound Sterling','GBP','&#163;'),
(225,'United States Minor Outlying Islands','US Dollar','USD','&#36;'),
(226,'United States','US Dollar','USD','&#36;'),
(227,'Uruguay','Peso Uruguayo','UYU',NULL),
(228,'Uzbekistan','Uzbekistan Sum','UZS',NULL),
(229,'Holy See (Vatican City)','Euro','EUR','&#8364;'),
(230,'Saint Vincent and the Grenadines','East Caribbean Dollar','XCD',NULL),
(231,'Venezuela','Bolivar','VEB',NULL),
(232,'British Virgin Islands','US dollar','USD','&#36;'),
(233,'Virgin Islands','US Dollar','USD','&#36;'),
(234,'Vietnam','Dong','VND',NULL),
(235,'Vanuatu','Vatu','VUV',NULL),
(236,'Wallis and Futuna','CFP Franc','XPF',NULL),
(237,'Samoa','Tala','WST',NULL),
(238,'Yemen','Yemeni Rial','YER',NULL),
(239,'Mayotte','Euro','EUR','&#8364;'),
(240,'Yugoslavia','Yugoslavian Dinar','YUM',NULL),
(241,'South Africa','Rand','ZAR',NULL),
(242,'Zambia','Kwacha','ZMK',NULL),
(243,'S.Tome e Principe','Dobra','STD',NULL),
(244,'Zimbabwe','Zimbabwe Dollar','ZWD',NULL);

--
-- Table structure for table `n36ic_hotelreservation_currencies`
--

CREATE TABLE `n36ic_hotelreservation_currencies` (
  `currency_id` int(10) NOT NULL AUTO_INCREMENT,
  `description` char(10) DEFAULT NULL,
  `currency_symbol` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`currency_id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_currencies`
--

INSERT INTO `n36ic_hotelreservation_currencies` VALUES
(1,'USD','$'),
(2,'EUR','&#8364;'),
(3,'RON',NULL),
(4,'GBP',NULL);

--
-- Table structure for table `n36ic_hotelreservation_date_formats`
--

CREATE TABLE `n36ic_hotelreservation_date_formats` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(45) DEFAULT NULL,
  `dateFormat` varchar(45) DEFAULT NULL,
  `calendarFormat` varchar(45) DEFAULT NULL,
  `defaultDateValue` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_date_formats`
--

INSERT INTO `n36ic_hotelreservation_date_formats` VALUES
(1,'y-m-d','Y-m-d','%Y-%m-%d','0000-00-00'),
(2,'m/d/y','m/d/Y','%m/%d/%Y','00/00/0000'),
(3,'d-m-y','d-m-Y','%d-%m-%Y','00-00-0000');

--
-- Table structure for table `n36ic_hotelreservation_discounts`
--

CREATE TABLE `n36ic_hotelreservation_discounts` (
  `discount_id` int(10) NOT NULL AUTO_INCREMENT,
  `hotel_id` int(10) DEFAULT NULL,
  `discount_name` char(255) DEFAULT NULL,
  `discount_datas` date DEFAULT NULL,
  `discount_datae` date DEFAULT NULL,
  `discount_value` float(18,2) DEFAULT NULL,
  `percent` tinyint(1) NOT NULL DEFAULT 0,
  `discount_room_ids` char(255) DEFAULT NULL,
  `minimum_number_days` int(10) NOT NULL DEFAULT 0,
  `maximum_number_days` int(4) NOT NULL DEFAULT 0,
  `minimum_number_persons` int(10) NOT NULL DEFAULT 0,
  `minimum_amount` int(12) NOT NULL DEFAULT 0,
  `is_available` tinyint(1) NOT NULL DEFAULT 0,
  `code` varchar(50) NOT NULL DEFAULT '0',
  `offer_ids` varchar(250) DEFAULT NULL,
  `excursion_ids` varchar(250) DEFAULT NULL,
  `only_on_offers` tinyint(1) NOT NULL DEFAULT 0,
  `check_full_code` tinyint(1) NOT NULL DEFAULT 1,
  `price_type` tinyint(1) NOT NULL DEFAULT 1,
  `discount_type` tinyint(1) NOT NULL DEFAULT 0,
  `reservation_cost_discount` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`discount_id`),
  UNIQUE KEY `room_id` (`discount_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_discounts`
--


--
-- Table structure for table `n36ic_hotelreservation_emails`
--

CREATE TABLE `n36ic_hotelreservation_emails` (
  `email_id` int(10) NOT NULL AUTO_INCREMENT,
  `hotel_id` int(10) DEFAULT NULL,
  `email_subject` char(255) DEFAULT NULL,
  `email_name` char(255) DEFAULT NULL,
  `email_type` varchar(200) NOT NULL DEFAULT 'Reservation Email',
  `email_content` blob DEFAULT NULL,
  `is_default` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`email_id`),
  UNIQUE KEY `NewIndex` (`email_name`,`hotel_id`)
) ENGINE=MyISAM AUTO_INCREMENT=73 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_emails`
--

INSERT INTO `n36ic_hotelreservation_emails` VALUES
(1,4,'Reservation Confirmation','Reservation Confirmation','Reservation Email','<div style=\"text-align: center; background-color: #f4f3f4; padding: 20px; margin: 0; font-family: \'Helvetica Neue\',Helvetica,Arial,sans-serif; font-size: 14px;\">\r\n<div align=\"center\">\r\n<div style=\"width: 600px; padding: 20px 30px 20px 20px; border: solid 1px #eaeaea; background-color: #ffffff;\">\r\n<table style=\"border-collapse: collapse; border-color: red; width: 100%; font-size: 14px;\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td style=\"text-align: center;\">[company_logo]</td>\r\n</tr>\r\n<tr>\r\n<td colspan=\"2\">\r\n<div style=\"background: #ffffff; padding: 30px 0px 20px 0px; border: 0px; text-align: left; margin: 0;\">\r\n<table style=\"width: 100%; font-size: 14px;\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n<tbody>\r\n<tr>\r\n<td>\r\n<p> </p>\r\n<p>Dear [first_name] [last_name], <br /> <br /> It’s our pleasure to welcome you to [hotel_name], where your every need will be taken care of.<br /><br /> Your booking is confirmed with the reservation summary below.<br /><br />We advise you to take this confirmation with you upon arrival. If you plan to arrive later than 18:00, please inform the [hotel_name] directly.<br /><br /> Sincerely,<br /> Reservations Department<br /> [company_name]</p>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\n<table style=\"min-width: 100%;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">\r\n<tbody>\r\n<tr>\r\n<td style=\"min-width: 100%; padding: 20px 0 6px;\" colspan=\"1\" rowspan=\"1\">\r\n<table style=\"min-width: 100%; border-top: 1px solid #999; font-size: 14px;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">\r\n<tbody>\r\n<tr>\r\n<td colspan=\"1\" rowspan=\"1\"> </td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td><br />[reservation_details]</td>\r\n</tr>\r\n<tr>\r\n<td>\r\n<table style=\"min-width: 100%;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">\r\n<tbody>\r\n<tr>\r\n<td style=\"min-width: 100%; padding: 25px 0 6px;\" colspan=\"1\" rowspan=\"1\">\r\n<table style=\"min-width: 100%; border-top: 1px solid #999;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">\r\n<tbody>\r\n<tr>\r\n<td colspan=\"1\" rowspan=\"1\"> </td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\n<table style=\"width: 100%; font-size: 14px;\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n<thead>\r\n<tr>\r\n<th style=\"padding: 5px 0;\" align=\"left\" width=\"100%\"><strong>Billing Informations:</strong></th>\r\n</tr>\r\n</thead>\r\n<tbody>\r\n<tr>\r\n<td style=\"padding: 7px 0;\" valign=\"top\">[billing_information]</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\n<table style=\"min-width: 100%;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">\r\n<tbody>\r\n<tr>\r\n<td style=\"min-width: 100%; padding: 20px 0 6px;\" colspan=\"1\" rowspan=\"1\">\r\n<table style=\"min-width: 100%; border-top: 1px solid #999;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">\r\n<tbody>\r\n<tr>\r\n<td colspan=\"1\" rowspan=\"1\"> </td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\n<table style=\"width: 100%; font-size: 14px;\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n<thead>\r\n<tr>\r\n<th style=\"padding: 5px0; border: line-height: 1em;\" align=\"left\" width=\"100%\"><strong>Payment Method: </strong></th>\r\n</tr>\r\n</thead>\r\n<tbody>\r\n<tr>\r\n<td style=\"padding: 7px 0;\" valign=\"top\">[payment_method]</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td><br />The total costs mentioned above do not include tourist tax which is [tourist_tax] per person per night.</td>\r\n</tr>\r\n<tr>\r\n<td><br />[parking_info]</td>\r\n</tr>\r\n<tr>\r\n<td><br />[hotel_cancellation_policy]</td>\r\n</tr>\r\n<tr>\r\n<td> </td>\r\n</tr>\r\n<tr>\r\n<td>\r\n<table style=\"min-width: 100%;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">\r\n<tbody>\r\n<tr>\r\n<td style=\"min-width: 100%; padding: 20px 0 6px;\" colspan=\"1\" rowspan=\"1\">\r\n<table style=\"min-width: 100%; border-top: 1px solid #999;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">\r\n<tbody>\r\n<tr>\r\n<td colspan=\"1\" rowspan=\"1\"> </td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\n<table style=\"max-width: 100%; min-width: 100%;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" align=\"left\">\r\n<tbody>\r\n<tr>\r\n<td style=\"padding: 0 18px 9px 18px;\" colspan=\"1\" rowspan=\"1\" valign=\"top\">\r\n<div style=\"font-family: arial,Helvetica,sans-serif; text-align: center; color: #9b9b9b; font-size: 12px;\">©2020 [company_name]. All rights reserved.</div>\r\n<div style=\"font-family: arial,Helvetica,sans-serif; text-align: center; color: #9b9b9b; font-size: 12px;\">[social_sharing]</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>\r\n</div>\r\n</div>',1),
(2,4,'Reservation Cancellation','Reservation Cancellation','Cancelation Email','<div style=\"margin: 0px; width: 100%; background-color: #f4f3f4; font-family: \'Helvetica Neue\',Helvetica,Arial,sans-serif; font-size: 14px; padding: 20px;\">\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#F4F3F4\">\r\n<tbody>\r\n<tr>\r\n<td align=\"center\">\r\n<table width=\"600px\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td align=\"left\">\r\n<div style=\"border: solid 1px #d9d9d9; width: 100%; background-color: #ffffff; padding: 20px;\">\r\n<table style=\"line-height: 1.6; font-size: 12px; font-family: Helvetica,Arial,sans-serif; color: #444;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td style=\"color: #ffffff;\" colspan=\"2\" valign=\"bottom\" height=\"30\"> </td>\r\n</tr>\r\n<tr>\r\n<td style=\"line-height: 32px; text-align: center;\">[company_logo]</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<table style=\"margin-top: 15px; color: #444; line-height: 1.6; font-size: 12px; font-family: Arial,sans-serif; padding: 15px; width: 100%;\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td style=\"border-top: solid 1px #d9d9d9; border-bottom: solid 1px #d9d9d9; width: 100%; padding: 10px;\" colspan=\"2\">\r\n<div style=\"padding: 15px 0;\">Hello, <br /><br /> Your reservation has been canceled.<br /> <b>[reservation_details]</b> <br /><br /> Sincerely,\r\n<div>[company_name]</div>\r\n</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<table style=\"line-height: 1.5; width: 100%;\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr valign=\"middle\">\r\n<td style=\"padding: 10px;\" align=\"center\">[social_sharing]</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>',1),
(3,4,'Invoice','Invoice','Invoice Email','<div style=\"margin: 0px; width: 100%; background-color: #f4f3f4; font-family: \'Helvetica Neue\',Helvetica,Arial,sans-serif; font-size: 14px; padding: 20px;\">\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#F4F3F4\">\r\n<tbody>\r\n<tr>\r\n<td><center>\r\n<table width=\"600px\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td align=\"left\">\r\n<div style=\"border: solid 1px #d9d9d9; width: 100%; background-color: #ffffff; padding: 20px;\">\r\n<table style=\"line-height: 1.6; font-size: 14px; font-family: Helvetica,Arial,sans-serif; border: solid 1px #ffffff; color: #444;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td style=\"color: #ffffff;\" colspan=\"2\" valign=\"bottom\" height=\"30\"> </td>\r\n</tr>\r\n<tr>\r\n<td style=\"line-height: 25px; padding-left: 30px;\">[company_logo]</td>\r\n<td style=\"line-height: 25px; padding-right: 30px;\">\r\n<div style=\"float: right; padding-top: 10px;\">Greupe 6 7694 BP Kloosterhaar<br /> Telefoon: 0900-xxxxxx<br /> info@cmsjunkie.com<br /> www.cmsjunkie.com<br /> Rabobank xxxxxxxxxx<br /> BTW nummer xxxxxxxxxxxx<br /> Kvk nummer xxxxxxxxxx</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<table style=\"margin-top: 15px; margin-right: 30px; margin-left: 15px; color: #444; line-height: 1.6; width: 90%; font-size: 14px; font-family: Arial,sans-serif;\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td style=\"border-top: solid 1px #d9d9d9; border-bottom: solid 1px #d9d9d9;\" colspan=\"2\">\r\n<div style=\"padding: 15px 0; width: 100%;\">Hello, <br /><br /> [invoice_hotel_details] <br /> <br /> Invoice date:[invoice_date]<br /> <br /> Invoice number:[invoice_number]<br />\r\n<h1>Invoice</h1>\r\n<br /><br />\r\n<table style=\"padding: 5px; width: 100%;\" bgcolor=\"#FAF9FA\">\r\n<tbody>\r\n<tr>\r\n<td><b>[invoice_fields]</b></td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<br /> We ask you to pay the total amount within 14 days xxxxxxxxxx xxxxxxxxxx xxxxxxxxxxxxxxxxxxx xxxxxxxxxxxx xxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxxxx xxxxxxxxxx€¦.. <br /><br /> Sincerely,\r\n<div>[company_name]</div>\r\n</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</center></td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>',1),
(4,4,'JHotelReservationReview email','Review Email','Review Email','<div style=\"margin: 0px; width: 100%; background-color: #f4f3f4; font-family: \'Helvetica Neue\',Helvetica,Arial,sans-serif; font-size: 14px; padding: 20px;\">\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#F4F3F4\">\r\n<tbody>\r\n<tr>\r\n<td><center>\r\n<table width=\"600px\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td align=\"left\">\r\n<div style=\"border: solid 1px #d9d9d9; width: 100%; background-color: #ffffff; padding: 20px;\">\r\n<table style=\"line-height: 1.6; font-size: 14px; font-family: Helvetica,Arial,sans-serif; border: solid 1px #ffffff; color: #444;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td style=\"color: #ffffff;\" colspan=\"2\" valign=\"bottom\" height=\"30\"> </td>\r\n</tr>\r\n<tr>\r\n<td style=\"line-height: 32px; text-align: center;\">[company_logo]</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<table style=\"margin-top: 15px; color: #444; width: 100%; padding: 15px; line-height: 1.6; font-size: 14px; font-family: Arial,sans-serif;\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td style=\"border-top: solid 1px #d9d9d9; border-bottom: solid 1px #d9d9d9; width: 100%; padding: 10px;\" colspan=\"2\">\r\n<div style=\"padding: 15px 0; width: 100%;\">Hi [first_name] [last_name]<br /><br /> Thank you for your stay at our hotel. <br /><br /> Please write a short review for our hotel: [rating_url] <br /><br /> Sincerely,\r\n<div>[company_name]</div>\r\n</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<table style=\"line-height: 1.5; width: 100%;\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr valign=\"middle\">\r\n<td style=\"padding: 10px;\" align=\"center\">[social_sharing]</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</center></td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>',1),
(5,4,'Bookings List','Bookings List','Bookings List','<div style=\"margin: 0px; width: 100%; background-color: #f4f3f4; font-family: \'Helvetica Neue\',Helvetica,Arial,sans-serif; font-size: 14px; padding: 20px;\">\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#F4F3F4\">\r\n<tbody>\r\n<tr>\r\n<td><center>\r\n<table width=\"600px\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td align=\"left\">\r\n<div style=\"border: solid 1px #d9d9d9; width: 100%; background-color: #ffffff; padding: 20px;\">\r\n<table style=\"line-height: 1.6; font-size: 12px; font-family: Helvetica,Arial,sans-serif; border: solid 1px #ffffff; color: #444;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td style=\"color: #ffffff;\" colspan=\"2\" valign=\"bottom\" height=\"30\"> </td>\r\n</tr>\r\n<tr>\r\n<td style=\"line-height: 25px; padding-left: 30px;\">[company_logo]</td>\r\n<td style=\"line-height: 25px; padding-right: 30px;\">\r\n<div style=\"float: right; padding-top: 10px;\">Greupe 6 7694 BP Kloosterhaar<br /> Telefoon: 0900-xxxxxx<br /> info@cmsjunkie.com<br /> www.cmsjunkie.com<br /> Rabobank xxxxxxxxxx<br /> BTW nummer xxxxxxxxxxxx<br /> Kvk nummer xxxxxxxxxx</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<table style=\"margin-top: 15px; margin-right: 30px; margin-left: 15px; color: #444; line-height: 1.6; width: 90%; font-size: 12px; font-family: Arial,sans-serif;\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td style=\"border-top: solid 1px #d9d9d9; border-bottom: solid 1px #d9d9d9;\" colspan=\"2\">\r\n<div style=\"padding: 15px 0; width: 100%;\">Hello, <br /><br /> [invoice_hotel_details] <br /><br />\r\n<h1>Bookings List</h1>\r\n<br /><br />\r\n<table style=\"padding: 5px; width: 100%;\" bgcolor=\"#FAF9FA\">\r\n<tbody>\r\n<tr>\r\n<td><b> [bookings_list] </b></td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<br /><br /> Sincerely,\r\n<div>[company_name]</div>\r\n</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</center></td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>',1),
(6,4,'Your invoice for reservation [reservation_id]','Client Invoice Email','Client Invoice Email','<div style=\"margin: 0px; width: 100%; background-color: #f4f3f4; font-family: \'Helvetica Neue\',Helvetica,Arial,sans-serif; font-size: 14px; padding: 20px;\">\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#F4F3F4\">\r\n<tbody>\r\n<tr>\r\n<td><center>\r\n<table width=\"600px\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td align=\"left\">\r\n<div style=\"border: solid 1px #d9d9d9; width: 100%; background-color: #ffffff; padding: 20px;\">\r\n<table style=\"line-height: 1.6; font-size: 14px; font-family: Helvetica,Arial,sans-serif; border: solid 1px #ffffff; color: #444;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td style=\"color: #ffffff;\" colspan=\"2\" valign=\"bottom\" height=\"30\"> </td>\r\n</tr>\r\n<tr>\r\n<td style=\"line-height: 25px; padding-left: 30px;\">[company_logo]</td>\r\n<td style=\"line-height: 25px; padding-right: 30px;\">\r\n<div style=\"float: right; padding-top: 10px;\">Greupe 6 7694 BP Kloosterhaar<br /> Telefoon: 0900-xxxxxx<br /> info@cmsjunkie.com<br /> www.cmsjunkie.com<br /> Rabobank xxxxxxxxxx<br /> BTW nummer xxxxxxxxxxxx<br /> Kvk nummer xxxxxxxxxx</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<table style=\"margin-top: 15px; color: #444; line-height: 1.6; font-size: 14px; font-family: Arial,sans-serif;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td style=\"border-top: solid 1px #d9d9d9; border-bottom: solid 1px #d9d9d9;\" colspan=\"2\">\r\n<div style=\"padding: 15px 0; width: 100%;\">Hello, <br /><br />Invoice date:[invoice_date]<br /> <br /> Invoice number:[invoice_number]<br /> <br />\r\n<h3>Invoice</h3>\r\n<br />\r\n<table style=\"padding: 5px; width: 100%;\" bgcolor=\"#FAF9FA\">\r\n<tbody>\r\n<tr>\r\n<td>\r\n<p>Bill to:</p>\r\n[billing_information]</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<br />[reservation_details] <br /><br />[hotel_cancellation_policy] </div>\r\n<div style=\"padding: 15px 0; width: 100%;\"><br /> Sincerely,\r\n<div>[company_name]</div>\r\n</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</center></td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>',1),
(7,5,'Reservation Confirmation','Reservation Confirmation','Reservation Email','<div style=\"text-align: center; background-color: #f4f3f4; padding: 20px; margin: 0; font-family: \'Helvetica Neue\',Helvetica,Arial,sans-serif; font-size: 14px;\">\r\n<div align=\"center\">\r\n<div style=\"width: 600px; padding: 20px 30px 20px 20px; border: solid 1px #eaeaea; background-color: #ffffff;\">\r\n<table style=\"border-collapse: collapse; border-color: red; width: 100%; font-size: 14px;\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td style=\"text-align: center;\">[company_logo]</td>\r\n</tr>\r\n<tr>\r\n<td colspan=\"2\">\r\n<div style=\"background: #ffffff; padding: 30px 0px 20px 0px; border: 0px; text-align: left; margin: 0;\">\r\n<table style=\"width: 100%; font-size: 14px;\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n<tbody>\r\n<tr>\r\n<td>\r\n<p> </p>\r\n<p>Dear [first_name] [last_name], <br /> <br /> It’s our pleasure to welcome you to [hotel_name], where your every need will be taken care of.<br /><br /> Your booking is confirmed with the reservation summary below.<br /><br />We advise you to take this confirmation with you upon arrival. If you plan to arrive later than 18:00, please inform the [hotel_name] directly.<br /><br /> Sincerely,<br /> Reservations Department<br /> [company_name]</p>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\n<table style=\"min-width: 100%;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">\r\n<tbody>\r\n<tr>\r\n<td style=\"min-width: 100%; padding: 20px 0 6px;\" colspan=\"1\" rowspan=\"1\">\r\n<table style=\"min-width: 100%; border-top: 1px solid #999; font-size: 14px;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">\r\n<tbody>\r\n<tr>\r\n<td colspan=\"1\" rowspan=\"1\"> </td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td><br />[reservation_details]</td>\r\n</tr>\r\n<tr>\r\n<td>\r\n<table style=\"min-width: 100%;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">\r\n<tbody>\r\n<tr>\r\n<td style=\"min-width: 100%; padding: 25px 0 6px;\" colspan=\"1\" rowspan=\"1\">\r\n<table style=\"min-width: 100%; border-top: 1px solid #999;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">\r\n<tbody>\r\n<tr>\r\n<td colspan=\"1\" rowspan=\"1\"> </td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\n<table style=\"width: 100%; font-size: 14px;\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n<thead>\r\n<tr>\r\n<th style=\"padding: 5px 0;\" align=\"left\" width=\"100%\"><strong>Billing Informations:</strong></th>\r\n</tr>\r\n</thead>\r\n<tbody>\r\n<tr>\r\n<td style=\"padding: 7px 0;\" valign=\"top\">[billing_information]</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\n<table style=\"min-width: 100%;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">\r\n<tbody>\r\n<tr>\r\n<td style=\"min-width: 100%; padding: 20px 0 6px;\" colspan=\"1\" rowspan=\"1\">\r\n<table style=\"min-width: 100%; border-top: 1px solid #999;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">\r\n<tbody>\r\n<tr>\r\n<td colspan=\"1\" rowspan=\"1\"> </td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\n<table style=\"width: 100%; font-size: 14px;\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n<thead>\r\n<tr>\r\n<th style=\"padding: 5px0; border: line-height: 1em;\" align=\"left\" width=\"100%\"><strong>Payment Method: </strong></th>\r\n</tr>\r\n</thead>\r\n<tbody>\r\n<tr>\r\n<td style=\"padding: 7px 0;\" valign=\"top\">[payment_method]</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td><br />The total costs mentioned above do not include tourist tax which is [tourist_tax] per person per night.</td>\r\n</tr>\r\n<tr>\r\n<td><br />[parking_info]</td>\r\n</tr>\r\n<tr>\r\n<td><br />[hotel_cancellation_policy]</td>\r\n</tr>\r\n<tr>\r\n<td> </td>\r\n</tr>\r\n<tr>\r\n<td>\r\n<table style=\"min-width: 100%;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">\r\n<tbody>\r\n<tr>\r\n<td style=\"min-width: 100%; padding: 20px 0 6px;\" colspan=\"1\" rowspan=\"1\">\r\n<table style=\"min-width: 100%; border-top: 1px solid #999;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">\r\n<tbody>\r\n<tr>\r\n<td colspan=\"1\" rowspan=\"1\"> </td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\n<table style=\"max-width: 100%; min-width: 100%;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" align=\"left\">\r\n<tbody>\r\n<tr>\r\n<td style=\"padding: 0 18px 9px 18px;\" colspan=\"1\" rowspan=\"1\" valign=\"top\">\r\n<div style=\"font-family: arial,Helvetica,sans-serif; text-align: center; color: #9b9b9b; font-size: 12px;\">©2020 [company_name]. All rights reserved.</div>\r\n<div style=\"font-family: arial,Helvetica,sans-serif; text-align: center; color: #9b9b9b; font-size: 12px;\">[social_sharing]</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>\r\n</div>\r\n</div>',1),
(8,5,'Reservation Cancellation','Reservation Cancellation','Cancelation Email','<div style=\"margin: 0px; width: 100%; background-color: #f4f3f4; font-family: \'Helvetica Neue\',Helvetica,Arial,sans-serif; font-size: 14px; padding: 20px;\">\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#F4F3F4\">\r\n<tbody>\r\n<tr>\r\n<td align=\"center\">\r\n<table width=\"600px\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td align=\"left\">\r\n<div style=\"border: solid 1px #d9d9d9; width: 100%; background-color: #ffffff; padding: 20px;\">\r\n<table style=\"line-height: 1.6; font-size: 12px; font-family: Helvetica,Arial,sans-serif; color: #444;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td style=\"color: #ffffff;\" colspan=\"2\" valign=\"bottom\" height=\"30\"> </td>\r\n</tr>\r\n<tr>\r\n<td style=\"line-height: 32px; text-align: center;\">[company_logo]</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<table style=\"margin-top: 15px; color: #444; line-height: 1.6; font-size: 12px; font-family: Arial,sans-serif; padding: 15px; width: 100%;\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td style=\"border-top: solid 1px #d9d9d9; border-bottom: solid 1px #d9d9d9; width: 100%; padding: 10px;\" colspan=\"2\">\r\n<div style=\"padding: 15px 0;\">Hello, <br /><br /> Your reservation has been canceled.<br /> <b>[reservation_details]</b> <br /><br /> Sincerely,\r\n<div>[company_name]</div>\r\n</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<table style=\"line-height: 1.5; width: 100%;\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr valign=\"middle\">\r\n<td style=\"padding: 10px;\" align=\"center\">[social_sharing]</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>',1),
(9,5,'Invoice','Invoice','Invoice Email','<div style=\"margin: 0px; width: 100%; background-color: #f4f3f4; font-family: \'Helvetica Neue\',Helvetica,Arial,sans-serif; font-size: 14px; padding: 20px;\">\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#F4F3F4\">\r\n<tbody>\r\n<tr>\r\n<td><center>\r\n<table width=\"600px\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td align=\"left\">\r\n<div style=\"border: solid 1px #d9d9d9; width: 100%; background-color: #ffffff; padding: 20px;\">\r\n<table style=\"line-height: 1.6; font-size: 14px; font-family: Helvetica,Arial,sans-serif; border: solid 1px #ffffff; color: #444;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td style=\"color: #ffffff;\" colspan=\"2\" valign=\"bottom\" height=\"30\"> </td>\r\n</tr>\r\n<tr>\r\n<td style=\"line-height: 25px; padding-left: 30px;\">[company_logo]</td>\r\n<td style=\"line-height: 25px; padding-right: 30px;\">\r\n<div style=\"float: right; padding-top: 10px;\">Greupe 6 7694 BP Kloosterhaar<br /> Telefoon: 0900-xxxxxx<br /> info@cmsjunkie.com<br /> www.cmsjunkie.com<br /> Rabobank xxxxxxxxxx<br /> BTW nummer xxxxxxxxxxxx<br /> Kvk nummer xxxxxxxxxx</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<table style=\"margin-top: 15px; margin-right: 30px; margin-left: 15px; color: #444; line-height: 1.6; width: 90%; font-size: 14px; font-family: Arial,sans-serif;\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td style=\"border-top: solid 1px #d9d9d9; border-bottom: solid 1px #d9d9d9;\" colspan=\"2\">\r\n<div style=\"padding: 15px 0; width: 100%;\">Hello, <br /><br /> [invoice_hotel_details] <br /> <br /> Invoice date:[invoice_date]<br /> <br /> Invoice number:[invoice_number]<br />\r\n<h1>Invoice</h1>\r\n<br /><br />\r\n<table style=\"padding: 5px; width: 100%;\" bgcolor=\"#FAF9FA\">\r\n<tbody>\r\n<tr>\r\n<td><b>[invoice_fields]</b></td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<br /> We ask you to pay the total amount within 14 days xxxxxxxxxx xxxxxxxxxx xxxxxxxxxxxxxxxxxxx xxxxxxxxxxxx xxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxxxx xxxxxxxxxx€¦.. <br /><br /> Sincerely,\r\n<div>[company_name]</div>\r\n</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</center></td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>',1),
(10,5,'JHotelReservationReview email','Review Email','Review Email','<div style=\"margin: 0px; width: 100%; background-color: #f4f3f4; font-family: \'Helvetica Neue\',Helvetica,Arial,sans-serif; font-size: 14px; padding: 20px;\">\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#F4F3F4\">\r\n<tbody>\r\n<tr>\r\n<td><center>\r\n<table width=\"600px\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td align=\"left\">\r\n<div style=\"border: solid 1px #d9d9d9; width: 100%; background-color: #ffffff; padding: 20px;\">\r\n<table style=\"line-height: 1.6; font-size: 14px; font-family: Helvetica,Arial,sans-serif; border: solid 1px #ffffff; color: #444;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td style=\"color: #ffffff;\" colspan=\"2\" valign=\"bottom\" height=\"30\"> </td>\r\n</tr>\r\n<tr>\r\n<td style=\"line-height: 32px; text-align: center;\">[company_logo]</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<table style=\"margin-top: 15px; color: #444; width: 100%; padding: 15px; line-height: 1.6; font-size: 14px; font-family: Arial,sans-serif;\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td style=\"border-top: solid 1px #d9d9d9; border-bottom: solid 1px #d9d9d9; width: 100%; padding: 10px;\" colspan=\"2\">\r\n<div style=\"padding: 15px 0; width: 100%;\">Hi [first_name] [last_name]<br /><br /> Thank you for your stay at our hotel. <br /><br /> Please write a short review for our hotel: [rating_url] <br /><br /> Sincerely,\r\n<div>[company_name]</div>\r\n</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<table style=\"line-height: 1.5; width: 100%;\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr valign=\"middle\">\r\n<td style=\"padding: 10px;\" align=\"center\">[social_sharing]</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</center></td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>',1),
(11,5,'Bookings List','Bookings List','Bookings List','<div style=\"margin: 0px; width: 100%; background-color: #f4f3f4; font-family: \'Helvetica Neue\',Helvetica,Arial,sans-serif; font-size: 14px; padding: 20px;\">\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#F4F3F4\">\r\n<tbody>\r\n<tr>\r\n<td><center>\r\n<table width=\"600px\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td align=\"left\">\r\n<div style=\"border: solid 1px #d9d9d9; width: 100%; background-color: #ffffff; padding: 20px;\">\r\n<table style=\"line-height: 1.6; font-size: 12px; font-family: Helvetica,Arial,sans-serif; border: solid 1px #ffffff; color: #444;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td style=\"color: #ffffff;\" colspan=\"2\" valign=\"bottom\" height=\"30\"> </td>\r\n</tr>\r\n<tr>\r\n<td style=\"line-height: 25px; padding-left: 30px;\">[company_logo]</td>\r\n<td style=\"line-height: 25px; padding-right: 30px;\">\r\n<div style=\"float: right; padding-top: 10px;\">Greupe 6 7694 BP Kloosterhaar<br /> Telefoon: 0900-xxxxxx<br /> info@cmsjunkie.com<br /> www.cmsjunkie.com<br /> Rabobank xxxxxxxxxx<br /> BTW nummer xxxxxxxxxxxx<br /> Kvk nummer xxxxxxxxxx</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<table style=\"margin-top: 15px; margin-right: 30px; margin-left: 15px; color: #444; line-height: 1.6; width: 90%; font-size: 12px; font-family: Arial,sans-serif;\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td style=\"border-top: solid 1px #d9d9d9; border-bottom: solid 1px #d9d9d9;\" colspan=\"2\">\r\n<div style=\"padding: 15px 0; width: 100%;\">Hello, <br /><br /> [invoice_hotel_details] <br /><br />\r\n<h1>Bookings List</h1>\r\n<br /><br />\r\n<table style=\"padding: 5px; width: 100%;\" bgcolor=\"#FAF9FA\">\r\n<tbody>\r\n<tr>\r\n<td><b> [bookings_list] </b></td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<br /><br /> Sincerely,\r\n<div>[company_name]</div>\r\n</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</center></td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>',1),
(12,5,'Your invoice for reservation [reservation_id]','Client Invoice Email','Client Invoice Email','<div style=\"margin: 0px; width: 100%; background-color: #f4f3f4; font-family: \'Helvetica Neue\',Helvetica,Arial,sans-serif; font-size: 14px; padding: 20px;\">\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#F4F3F4\">\r\n<tbody>\r\n<tr>\r\n<td><center>\r\n<table width=\"600px\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td align=\"left\">\r\n<div style=\"border: solid 1px #d9d9d9; width: 100%; background-color: #ffffff; padding: 20px;\">\r\n<table style=\"line-height: 1.6; font-size: 14px; font-family: Helvetica,Arial,sans-serif; border: solid 1px #ffffff; color: #444;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td style=\"color: #ffffff;\" colspan=\"2\" valign=\"bottom\" height=\"30\"> </td>\r\n</tr>\r\n<tr>\r\n<td style=\"line-height: 25px; padding-left: 30px;\">[company_logo]</td>\r\n<td style=\"line-height: 25px; padding-right: 30px;\">\r\n<div style=\"float: right; padding-top: 10px;\">Greupe 6 7694 BP Kloosterhaar<br /> Telefoon: 0900-xxxxxx<br /> info@cmsjunkie.com<br /> www.cmsjunkie.com<br /> Rabobank xxxxxxxxxx<br /> BTW nummer xxxxxxxxxxxx<br /> Kvk nummer xxxxxxxxxx</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<table style=\"margin-top: 15px; color: #444; line-height: 1.6; font-size: 14px; font-family: Arial,sans-serif;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td style=\"border-top: solid 1px #d9d9d9; border-bottom: solid 1px #d9d9d9;\" colspan=\"2\">\r\n<div style=\"padding: 15px 0; width: 100%;\">Hello, <br /><br />Invoice date:[invoice_date]<br /> <br /> Invoice number:[invoice_number]<br /> <br />\r\n<h3>Invoice</h3>\r\n<br />\r\n<table style=\"padding: 5px; width: 100%;\" bgcolor=\"#FAF9FA\">\r\n<tbody>\r\n<tr>\r\n<td>\r\n<p>Bill to:</p>\r\n[billing_information]</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<br />[reservation_details] <br /><br />[hotel_cancellation_policy] </div>\r\n<div style=\"padding: 15px 0; width: 100%;\"><br /> Sincerely,\r\n<div>[company_name]</div>\r\n</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</center></td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>',1),
(13,11,'Reservation Confirmation','Reservation Confirmation','Reservation Email','<div style=\"text-align: center; background-color: #f4f3f4; padding: 20px; margin: 0; font-family: \'Helvetica Neue\',Helvetica,Arial,sans-serif; font-size: 14px;\">\r\n<div align=\"center\">\r\n<div style=\"width: 600px; padding: 20px 30px 20px 20px; border: solid 1px #eaeaea; background-color: #ffffff;\">\r\n<table style=\"border-collapse: collapse; border-color: red; width: 100%; font-size: 14px;\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td style=\"text-align: center;\">[company_logo]</td>\r\n</tr>\r\n<tr>\r\n<td colspan=\"2\">\r\n<div style=\"background: #ffffff; padding: 30px 0px 20px 0px; border: 0px; text-align: left; margin: 0;\">\r\n<table style=\"width: 100%; font-size: 14px;\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n<tbody>\r\n<tr>\r\n<td>\r\n<p> </p>\r\n<p>Dear [first_name] [last_name], <br /> <br /> It’s our pleasure to welcome you to [hotel_name], where your every need will be taken care of.<br /><br /> Your booking is confirmed with the reservation summary below.<br /><br />We advise you to take this confirmation with you upon arrival. If you plan to arrive later than 18:00, please inform the [hotel_name] directly.<br /><br /> Sincerely,<br /> Reservations Department<br /> [company_name]</p>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\n<table style=\"min-width: 100%;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">\r\n<tbody>\r\n<tr>\r\n<td style=\"min-width: 100%; padding: 20px 0 6px;\" colspan=\"1\" rowspan=\"1\">\r\n<table style=\"min-width: 100%; border-top: 1px solid #999; font-size: 14px;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">\r\n<tbody>\r\n<tr>\r\n<td colspan=\"1\" rowspan=\"1\"> </td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td><br />[reservation_details]</td>\r\n</tr>\r\n<tr>\r\n<td>\r\n<table style=\"min-width: 100%;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">\r\n<tbody>\r\n<tr>\r\n<td style=\"min-width: 100%; padding: 25px 0 6px;\" colspan=\"1\" rowspan=\"1\">\r\n<table style=\"min-width: 100%; border-top: 1px solid #999;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">\r\n<tbody>\r\n<tr>\r\n<td colspan=\"1\" rowspan=\"1\"> </td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\n<table style=\"width: 100%; font-size: 14px;\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n<thead>\r\n<tr>\r\n<th style=\"padding: 5px 0;\" align=\"left\" width=\"100%\"><strong>Billing Informations:</strong></th>\r\n</tr>\r\n</thead>\r\n<tbody>\r\n<tr>\r\n<td style=\"padding: 7px 0;\" valign=\"top\">[billing_information]</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\n<table style=\"min-width: 100%;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">\r\n<tbody>\r\n<tr>\r\n<td style=\"min-width: 100%; padding: 20px 0 6px;\" colspan=\"1\" rowspan=\"1\">\r\n<table style=\"min-width: 100%; border-top: 1px solid #999;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">\r\n<tbody>\r\n<tr>\r\n<td colspan=\"1\" rowspan=\"1\"> </td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\n<table style=\"width: 100%; font-size: 14px;\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n<thead>\r\n<tr>\r\n<th style=\"padding: 5px0; border: line-height: 1em;\" align=\"left\" width=\"100%\"><strong>Payment Method: </strong></th>\r\n</tr>\r\n</thead>\r\n<tbody>\r\n<tr>\r\n<td style=\"padding: 7px 0;\" valign=\"top\">[payment_method]</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td><br />The total costs mentioned above do not include tourist tax which is [tourist_tax] per person per night.</td>\r\n</tr>\r\n<tr>\r\n<td><br />[parking_info]</td>\r\n</tr>\r\n<tr>\r\n<td><br />[hotel_cancellation_policy]</td>\r\n</tr>\r\n<tr>\r\n<td> </td>\r\n</tr>\r\n<tr>\r\n<td>\r\n<table style=\"min-width: 100%;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">\r\n<tbody>\r\n<tr>\r\n<td style=\"min-width: 100%; padding: 20px 0 6px;\" colspan=\"1\" rowspan=\"1\">\r\n<table style=\"min-width: 100%; border-top: 1px solid #999;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">\r\n<tbody>\r\n<tr>\r\n<td colspan=\"1\" rowspan=\"1\"> </td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\n<table style=\"max-width: 100%; min-width: 100%;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" align=\"left\">\r\n<tbody>\r\n<tr>\r\n<td style=\"padding: 0 18px 9px 18px;\" colspan=\"1\" rowspan=\"1\" valign=\"top\">\r\n<div style=\"font-family: arial,Helvetica,sans-serif; text-align: center; color: #9b9b9b; font-size: 12px;\">©2020 [company_name]. All rights reserved.</div>\r\n<div style=\"font-family: arial,Helvetica,sans-serif; text-align: center; color: #9b9b9b; font-size: 12px;\">[social_sharing]</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>\r\n</div>\r\n</div>',1),
(14,11,'Reservation Cancellation','Reservation Cancellation','Cancelation Email','<div style=\"margin: 0px; width: 100%; background-color: #f4f3f4; font-family: \'Helvetica Neue\',Helvetica,Arial,sans-serif; font-size: 14px; padding: 20px;\">\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#F4F3F4\">\r\n<tbody>\r\n<tr>\r\n<td align=\"center\">\r\n<table width=\"600px\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td align=\"left\">\r\n<div style=\"border: solid 1px #d9d9d9; width: 100%; background-color: #ffffff; padding: 20px;\">\r\n<table style=\"line-height: 1.6; font-size: 12px; font-family: Helvetica,Arial,sans-serif; color: #444;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td style=\"color: #ffffff;\" colspan=\"2\" valign=\"bottom\" height=\"30\"> </td>\r\n</tr>\r\n<tr>\r\n<td style=\"line-height: 32px; text-align: center;\">[company_logo]</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<table style=\"margin-top: 15px; color: #444; line-height: 1.6; font-size: 12px; font-family: Arial,sans-serif; padding: 15px; width: 100%;\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td style=\"border-top: solid 1px #d9d9d9; border-bottom: solid 1px #d9d9d9; width: 100%; padding: 10px;\" colspan=\"2\">\r\n<div style=\"padding: 15px 0;\">Hello, <br /><br /> Your reservation has been canceled.<br /> <b>[reservation_details]</b> <br /><br /> Sincerely,\r\n<div>[company_name]</div>\r\n</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<table style=\"line-height: 1.5; width: 100%;\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr valign=\"middle\">\r\n<td style=\"padding: 10px;\" align=\"center\">[social_sharing]</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>',1),
(15,11,'Invoice','Invoice','Invoice Email','<div style=\"margin: 0px; width: 100%; background-color: #f4f3f4; font-family: \'Helvetica Neue\',Helvetica,Arial,sans-serif; font-size: 14px; padding: 20px;\">\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#F4F3F4\">\r\n<tbody>\r\n<tr>\r\n<td><center>\r\n<table width=\"600px\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td align=\"left\">\r\n<div style=\"border: solid 1px #d9d9d9; width: 100%; background-color: #ffffff; padding: 20px;\">\r\n<table style=\"line-height: 1.6; font-size: 14px; font-family: Helvetica,Arial,sans-serif; border: solid 1px #ffffff; color: #444;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td style=\"color: #ffffff;\" colspan=\"2\" valign=\"bottom\" height=\"30\"> </td>\r\n</tr>\r\n<tr>\r\n<td style=\"line-height: 25px; padding-left: 30px;\">[company_logo]</td>\r\n<td style=\"line-height: 25px; padding-right: 30px;\">\r\n<div style=\"float: right; padding-top: 10px;\">Greupe 6 7694 BP Kloosterhaar<br /> Telefoon: 0900-xxxxxx<br /> info@cmsjunkie.com<br /> www.cmsjunkie.com<br /> Rabobank xxxxxxxxxx<br /> BTW nummer xxxxxxxxxxxx<br /> Kvk nummer xxxxxxxxxx</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<table style=\"margin-top: 15px; margin-right: 30px; margin-left: 15px; color: #444; line-height: 1.6; width: 90%; font-size: 14px; font-family: Arial,sans-serif;\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td style=\"border-top: solid 1px #d9d9d9; border-bottom: solid 1px #d9d9d9;\" colspan=\"2\">\r\n<div style=\"padding: 15px 0; width: 100%;\">Hello, <br /><br /> [invoice_hotel_details] <br /> <br /> Invoice date:[invoice_date]<br /> <br /> Invoice number:[invoice_number]<br />\r\n<h1>Invoice</h1>\r\n<br /><br />\r\n<table style=\"padding: 5px; width: 100%;\" bgcolor=\"#FAF9FA\">\r\n<tbody>\r\n<tr>\r\n<td><b>[invoice_fields]</b></td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<br /> We ask you to pay the total amount within 14 days xxxxxxxxxx xxxxxxxxxx xxxxxxxxxxxxxxxxxxx xxxxxxxxxxxx xxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxxxx xxxxxxxxxx€¦.. <br /><br /> Sincerely,\r\n<div>[company_name]</div>\r\n</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</center></td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>',1),
(16,11,'JHotelReservationReview email','Review Email','Review Email','<div style=\"margin: 0px; width: 100%; background-color: #f4f3f4; font-family: \'Helvetica Neue\',Helvetica,Arial,sans-serif; font-size: 14px; padding: 20px;\">\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#F4F3F4\">\r\n<tbody>\r\n<tr>\r\n<td><center>\r\n<table width=\"600px\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td align=\"left\">\r\n<div style=\"border: solid 1px #d9d9d9; width: 100%; background-color: #ffffff; padding: 20px;\">\r\n<table style=\"line-height: 1.6; font-size: 14px; font-family: Helvetica,Arial,sans-serif; border: solid 1px #ffffff; color: #444;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td style=\"color: #ffffff;\" colspan=\"2\" valign=\"bottom\" height=\"30\"> </td>\r\n</tr>\r\n<tr>\r\n<td style=\"line-height: 32px; text-align: center;\">[company_logo]</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<table style=\"margin-top: 15px; color: #444; width: 100%; padding: 15px; line-height: 1.6; font-size: 14px; font-family: Arial,sans-serif;\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td style=\"border-top: solid 1px #d9d9d9; border-bottom: solid 1px #d9d9d9; width: 100%; padding: 10px;\" colspan=\"2\">\r\n<div style=\"padding: 15px 0; width: 100%;\">Hi [first_name] [last_name]<br /><br /> Thank you for your stay at our hotel. <br /><br /> Please write a short review for our hotel: [rating_url] <br /><br /> Sincerely,\r\n<div>[company_name]</div>\r\n</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<table style=\"line-height: 1.5; width: 100%;\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr valign=\"middle\">\r\n<td style=\"padding: 10px;\" align=\"center\">[social_sharing]</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</center></td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>',1),
(17,11,'Bookings List','Bookings List','Bookings List','<div style=\"margin: 0px; width: 100%; background-color: #f4f3f4; font-family: \'Helvetica Neue\',Helvetica,Arial,sans-serif; font-size: 14px; padding: 20px;\">\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#F4F3F4\">\r\n<tbody>\r\n<tr>\r\n<td><center>\r\n<table width=\"600px\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td align=\"left\">\r\n<div style=\"border: solid 1px #d9d9d9; width: 100%; background-color: #ffffff; padding: 20px;\">\r\n<table style=\"line-height: 1.6; font-size: 12px; font-family: Helvetica,Arial,sans-serif; border: solid 1px #ffffff; color: #444;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td style=\"color: #ffffff;\" colspan=\"2\" valign=\"bottom\" height=\"30\"> </td>\r\n</tr>\r\n<tr>\r\n<td style=\"line-height: 25px; padding-left: 30px;\">[company_logo]</td>\r\n<td style=\"line-height: 25px; padding-right: 30px;\">\r\n<div style=\"float: right; padding-top: 10px;\">Greupe 6 7694 BP Kloosterhaar<br /> Telefoon: 0900-xxxxxx<br /> info@cmsjunkie.com<br /> www.cmsjunkie.com<br /> Rabobank xxxxxxxxxx<br /> BTW nummer xxxxxxxxxxxx<br /> Kvk nummer xxxxxxxxxx</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<table style=\"margin-top: 15px; margin-right: 30px; margin-left: 15px; color: #444; line-height: 1.6; width: 90%; font-size: 12px; font-family: Arial,sans-serif;\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td style=\"border-top: solid 1px #d9d9d9; border-bottom: solid 1px #d9d9d9;\" colspan=\"2\">\r\n<div style=\"padding: 15px 0; width: 100%;\">Hello, <br /><br /> [invoice_hotel_details] <br /><br />\r\n<h1>Bookings List</h1>\r\n<br /><br />\r\n<table style=\"padding: 5px; width: 100%;\" bgcolor=\"#FAF9FA\">\r\n<tbody>\r\n<tr>\r\n<td><b> [bookings_list] </b></td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<br /><br /> Sincerely,\r\n<div>[company_name]</div>\r\n</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</center></td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>',1),
(18,11,'Your invoice for reservation [reservation_id]','Client Invoice Email','Client Invoice Email','<div style=\"margin: 0px; width: 100%; background-color: #f4f3f4; font-family: \'Helvetica Neue\',Helvetica,Arial,sans-serif; font-size: 14px; padding: 20px;\">\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#F4F3F4\">\r\n<tbody>\r\n<tr>\r\n<td><center>\r\n<table width=\"600px\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td align=\"left\">\r\n<div style=\"border: solid 1px #d9d9d9; width: 100%; background-color: #ffffff; padding: 20px;\">\r\n<table style=\"line-height: 1.6; font-size: 14px; font-family: Helvetica,Arial,sans-serif; border: solid 1px #ffffff; color: #444;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td style=\"color: #ffffff;\" colspan=\"2\" valign=\"bottom\" height=\"30\"> </td>\r\n</tr>\r\n<tr>\r\n<td style=\"line-height: 25px; padding-left: 30px;\">[company_logo]</td>\r\n<td style=\"line-height: 25px; padding-right: 30px;\">\r\n<div style=\"float: right; padding-top: 10px;\">Greupe 6 7694 BP Kloosterhaar<br /> Telefoon: 0900-xxxxxx<br /> info@cmsjunkie.com<br /> www.cmsjunkie.com<br /> Rabobank xxxxxxxxxx<br /> BTW nummer xxxxxxxxxxxx<br /> Kvk nummer xxxxxxxxxx</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<table style=\"margin-top: 15px; color: #444; line-height: 1.6; font-size: 14px; font-family: Arial,sans-serif;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td style=\"border-top: solid 1px #d9d9d9; border-bottom: solid 1px #d9d9d9;\" colspan=\"2\">\r\n<div style=\"padding: 15px 0; width: 100%;\">Hello, <br /><br />Invoice date:[invoice_date]<br /> <br /> Invoice number:[invoice_number]<br /> <br />\r\n<h3>Invoice</h3>\r\n<br />\r\n<table style=\"padding: 5px; width: 100%;\" bgcolor=\"#FAF9FA\">\r\n<tbody>\r\n<tr>\r\n<td>\r\n<p>Bill to:</p>\r\n[billing_information]</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<br />[reservation_details] <br /><br />[hotel_cancellation_policy] </div>\r\n<div style=\"padding: 15px 0; width: 100%;\"><br /> Sincerely,\r\n<div>[company_name]</div>\r\n</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</center></td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>',1);

--
-- Table structure for table `n36ic_hotelreservation_emails_default`
--

CREATE TABLE `n36ic_hotelreservation_emails_default` (
  `email_default_id` int(10) NOT NULL AUTO_INCREMENT,
  `email_default_subject` char(255) DEFAULT NULL,
  `email_default_name` char(255) DEFAULT NULL,
  `email_default_type` enum('Reservation Email','Cancelation Email','Review Email','Invoice Email','Bookings List','Client Invoice Email','Availability Request Email','Add Hotel Request Email') NOT NULL DEFAULT 'Reservation Email',
  `email_default_content` blob DEFAULT NULL,
  PRIMARY KEY (`email_default_id`),
  UNIQUE KEY `room_id` (`email_default_id`),
  UNIQUE KEY `NewIndex` (`email_default_name`),
  KEY `room_id_2` (`email_default_id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_emails_default`
--

INSERT INTO `n36ic_hotelreservation_emails_default` VALUES
(1,'Review email','Review Email','Review Email','<div style=\"margin: 0px; width: 100%; background-color: #f4f3f4; font-family: \'Helvetica Neue\',Helvetica,Arial,sans-serif; font-size: 14px; padding: 20px;\">\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#F4F3F4\">\r\n<tbody>\r\n<tr>\r\n<td><center>\r\n<table width=\"600px\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td align=\"left\">\r\n<div style=\"border: solid 1px #d9d9d9; width: 100%; background-color: #ffffff; padding: 20px;\">\r\n<table style=\"line-height: 1.6; font-size: 14px; font-family: Helvetica,Arial,sans-serif; border: solid 1px #ffffff; color: #444;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td style=\"color: #ffffff;\" colspan=\"2\" valign=\"bottom\" height=\"30\"> </td>\r\n</tr>\r\n<tr>\r\n<td style=\"line-height: 32px; text-align: center;\">[company_logo]</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<table style=\"margin-top: 15px; color: #444; width: 100%; padding: 15px; line-height: 1.6; font-size: 14px; font-family: Arial,sans-serif;\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td style=\"border-top: solid 1px #d9d9d9; border-bottom: solid 1px #d9d9d9; width: 100%; padding: 10px;\" colspan=\"2\">\r\n<div style=\"padding: 15px 0; width: 100%;\">Hi [first_name] [last_name]<br /><br /> Thank you for your stay at our hotel. <br /><br /> Please write a short review for our hotel: [rating_url] <br /><br /> Sincerely,\r\n<div>[company_name]</div>\r\n</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<table style=\"line-height: 1.5; width: 100%;\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr valign=\"middle\">\r\n<td style=\"padding: 10px;\" align=\"center\">[social_sharing]</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</center></td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>'),
(2,'Thank you for your reservation','Reservation','Reservation Email','<div style=\"text-align: center; background-color: #f4f3f4; padding: 20px; margin: 0; font-family: \'Helvetica Neue\',Helvetica,Arial,sans-serif; font-size: 14px;\">\r\n<div align=\"center\">\r\n<div style=\"width: 600px; padding: 20px 30px 20px 20px; border: solid 1px #eaeaea; background-color: #ffffff;\">\r\n<table style=\"border-collapse: collapse; border-color: red; width: 100%; font-size: 14px;\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td style=\"text-align: center;\">[company_logo]</td>\r\n</tr>\r\n<tr>\r\n<td colspan=\"2\">\r\n<div style=\"background: #ffffff; padding: 30px 0px 20px 0px; border: 0px; text-align: left; margin: 0;\">\r\n<table style=\"width: 100%; font-size: 14px;\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n<tbody>\r\n<tr>\r\n<td>\r\n<p> </p>\r\n<p>Dear [first_name] [last_name], <br /> <br /> It’s our pleasure to welcome you to [hotel_name], where your every need will be taken care of.<br /><br /> Your booking is confirmed with the reservation summary below.<br /><br />We advise you to take this confirmation with you upon arrival. If you plan to arrive later than 18:00, please inform the [hotel_name] directly.<br /><br /> Sincerely,<br /> Reservations Department<br /> [company_name]</p>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\n<table style=\"min-width: 100%;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">\r\n<tbody>\r\n<tr>\r\n<td style=\"min-width: 100%; padding: 20px 0 6px;\" colspan=\"1\" rowspan=\"1\">\r\n<table style=\"min-width: 100%; border-top: 1px solid #999; font-size: 14px;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">\r\n<tbody>\r\n<tr>\r\n<td colspan=\"1\" rowspan=\"1\"> </td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td><br />[reservation_details]</td>\r\n</tr>\r\n<tr>\r\n<td>\r\n<table style=\"min-width: 100%;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">\r\n<tbody>\r\n<tr>\r\n<td style=\"min-width: 100%; padding: 25px 0 6px;\" colspan=\"1\" rowspan=\"1\">\r\n<table style=\"min-width: 100%; border-top: 1px solid #999;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">\r\n<tbody>\r\n<tr>\r\n<td colspan=\"1\" rowspan=\"1\"> </td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\n<table style=\"width: 100%; font-size: 14px;\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n<thead>\r\n<tr>\r\n<th style=\"padding: 5px 0;\" align=\"left\" width=\"100%\"><strong>Billing Informations:</strong></th>\r\n</tr>\r\n</thead>\r\n<tbody>\r\n<tr>\r\n<td style=\"padding: 7px 0;\" valign=\"top\">[billing_information]</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\n<table style=\"min-width: 100%;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">\r\n<tbody>\r\n<tr>\r\n<td style=\"min-width: 100%; padding: 20px 0 6px;\" colspan=\"1\" rowspan=\"1\">\r\n<table style=\"min-width: 100%; border-top: 1px solid #999;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">\r\n<tbody>\r\n<tr>\r\n<td colspan=\"1\" rowspan=\"1\"> </td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\n<table style=\"width: 100%; font-size: 14px;\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n<thead>\r\n<tr>\r\n<th style=\"padding: 5px0; border: line-height: 1em;\" align=\"left\" width=\"100%\"><strong>Payment Method: </strong></th>\r\n</tr>\r\n</thead>\r\n<tbody>\r\n<tr>\r\n<td style=\"padding: 7px 0;\" valign=\"top\">[payment_method]</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td><br />The total costs mentioned above do not include tourist tax which is [tourist_tax] per person per night.</td>\r\n</tr>\r\n<tr>\r\n<td><br />[parking_info]</td>\r\n</tr>\r\n<tr>\r\n<td><br />[hotel_cancellation_policy]</td>\r\n</tr>\r\n<tr>\r\n<td> </td>\r\n</tr>\r\n<tr>\r\n<td>\r\n<table style=\"min-width: 100%;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">\r\n<tbody>\r\n<tr>\r\n<td style=\"min-width: 100%; padding: 20px 0 6px;\" colspan=\"1\" rowspan=\"1\">\r\n<table style=\"min-width: 100%; border-top: 1px solid #999;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">\r\n<tbody>\r\n<tr>\r\n<td colspan=\"1\" rowspan=\"1\"> </td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\n<table style=\"max-width: 100%; min-width: 100%;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" align=\"left\">\r\n<tbody>\r\n<tr>\r\n<td style=\"padding: 0 18px 9px 18px;\" colspan=\"1\" rowspan=\"1\" valign=\"top\">\r\n<div style=\"font-family: arial,Helvetica,sans-serif; text-align: center; color: #9b9b9b; font-size: 12px;\">©2020 [company_name]. All rights reserved.</div>\r\n<div style=\"font-family: arial,Helvetica,sans-serif; text-align: center; color: #9b9b9b; font-size: 12px;\">[social_sharing]</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>\r\n</div>\r\n</div>'),
(3,'JHotelReservation Cancelation','Reservation Cancelation','Cancelation Email','<div style=\"margin: 0px; width: 100%; background-color: #f4f3f4; font-family: \'Helvetica Neue\',Helvetica,Arial,sans-serif; font-size: 14px; padding: 20px;\">\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#F4F3F4\">\r\n<tbody>\r\n<tr>\r\n<td align=\"center\">\r\n<table width=\"600px\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td align=\"left\">\r\n<div style=\"border: solid 1px #d9d9d9; width: 100%; background-color: #ffffff; padding: 20px;\">\r\n<table style=\"line-height: 1.6; font-size: 12px; font-family: Helvetica,Arial,sans-serif; color: #444;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td style=\"color: #ffffff;\" colspan=\"2\" valign=\"bottom\" height=\"30\"> </td>\r\n</tr>\r\n<tr>\r\n<td style=\"line-height: 32px; text-align: center;\">[company_logo]</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<table style=\"margin-top: 15px; color: #444; line-height: 1.6; font-size: 12px; font-family: Arial,sans-serif; padding: 15px; width: 100%;\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td style=\"border-top: solid 1px #d9d9d9; border-bottom: solid 1px #d9d9d9; width: 100%; padding: 10px;\" colspan=\"2\">\r\n<div style=\"padding: 15px 0;\">Hello, <br /><br /> Your reservation has been canceled.<br /> <b>[reservation_details]</b> <br /><br /> Sincerely,\r\n<div>[company_name]</div>\r\n</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<table style=\"line-height: 1.5; width: 100%;\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr valign=\"middle\">\r\n<td style=\"padding: 10px;\" align=\"center\">[social_sharing]</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>'),
(4,'Invoice','Invoice Email','Invoice Email','<div style=\"margin: 0px; width: 100%; background-color: #f4f3f4; font-family: \'Helvetica Neue\',Helvetica,Arial,sans-serif; font-size: 14px; padding: 20px;\">\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#F4F3F4\">\r\n<tbody>\r\n<tr>\r\n<td><center>\r\n<table width=\"600px\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td align=\"left\">\r\n<div style=\"border: solid 1px #d9d9d9; width: 100%; background-color: #ffffff; padding: 20px;\">\r\n<table style=\"line-height: 1.6; font-size: 14px; font-family: Helvetica,Arial,sans-serif; border: solid 1px #ffffff; color: #444;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td style=\"color: #ffffff;\" colspan=\"2\" valign=\"bottom\" height=\"30\"> </td>\r\n</tr>\r\n<tr>\r\n<td style=\"line-height: 25px; padding-left: 30px;\">[company_logo]</td>\r\n<td style=\"line-height: 25px; padding-right: 30px;\">\r\n<div style=\"float: right; padding-top: 10px;\">Greupe 6 7694 BP Kloosterhaar<br /> Telefoon: 0900-xxxxxx<br /> info@cmsjunkie.com<br /> www.cmsjunkie.com<br /> Rabobank xxxxxxxxxx<br /> BTW nummer xxxxxxxxxxxx<br /> Kvk nummer xxxxxxxxxx</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<table style=\"margin-top: 15px; margin-right: 30px; margin-left: 15px; color: #444; line-height: 1.6; width: 90%; font-size: 14px; font-family: Arial,sans-serif;\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td style=\"border-top: solid 1px #d9d9d9; border-bottom: solid 1px #d9d9d9;\" colspan=\"2\">\r\n<div style=\"padding: 15px 0; width: 100%;\">Hello, <br /><br /> [invoice_hotel_details] <br /> <br /> Invoice date:[invoice_date]<br /> <br /> Invoice number:[invoice_number]<br />\r\n<h1>Invoice</h1>\r\n<br /><br />\r\n<table style=\"padding: 5px; width: 100%;\" bgcolor=\"#FAF9FA\">\r\n<tbody>\r\n<tr>\r\n<td><b>[invoice_fields]</b></td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<br /> We ask you to pay the total amount within 14 days xxxxxxxxxx xxxxxxxxxx xxxxxxxxxxxxxxxxxxx xxxxxxxxxxxx xxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxxxx xxxxxxxxxx€¦.. <br /><br /> Sincerely,\r\n<div>[company_name]</div>\r\n</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</center></td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>'),
(5,'Bookings List','Bookings List','Bookings List','<div style=\"margin: 0px; width: 100%; background-color: #f4f3f4; font-family: \'Helvetica Neue\',Helvetica,Arial,sans-serif; font-size: 14px; padding: 20px;\">\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#F4F3F4\">\r\n<tbody>\r\n<tr>\r\n<td><center>\r\n<table width=\"600px\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td align=\"left\">\r\n<div style=\"border: solid 1px #d9d9d9; width: 100%; background-color: #ffffff; padding: 20px;\">\r\n<table style=\"line-height: 1.6; font-size: 12px; font-family: Helvetica,Arial,sans-serif; border: solid 1px #ffffff; color: #444;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td style=\"color: #ffffff;\" colspan=\"2\" valign=\"bottom\" height=\"30\"> </td>\r\n</tr>\r\n<tr>\r\n<td style=\"line-height: 25px; padding-left: 30px;\">[company_logo]</td>\r\n<td style=\"line-height: 25px; padding-right: 30px;\">\r\n<div style=\"float: right; padding-top: 10px;\">Greupe 6 7694 BP Kloosterhaar<br /> Telefoon: 0900-xxxxxx<br /> info@cmsjunkie.com<br /> www.cmsjunkie.com<br /> Rabobank xxxxxxxxxx<br /> BTW nummer xxxxxxxxxxxx<br /> Kvk nummer xxxxxxxxxx</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<table style=\"margin-top: 15px; margin-right: 30px; margin-left: 15px; color: #444; line-height: 1.6; width: 90%; font-size: 12px; font-family: Arial,sans-serif;\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td style=\"border-top: solid 1px #d9d9d9; border-bottom: solid 1px #d9d9d9;\" colspan=\"2\">\r\n<div style=\"padding: 15px 0; width: 100%;\">Hello, <br /><br /> [invoice_hotel_details] <br /><br />\r\n<h1>Bookings List</h1>\r\n<br /><br />\r\n<table style=\"padding: 5px; width: 100%;\" bgcolor=\"#FAF9FA\">\r\n<tbody>\r\n<tr>\r\n<td><b> [bookings_list] </b></td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<br /><br /> Sincerely,\r\n<div>[company_name]</div>\r\n</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</center></td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>'),
(6,'Your invoice for reservation [reservation_id]','Client Invoice Email','Client Invoice Email','<div style=\"margin: 0px; width: 100%; background-color: #f4f3f4; font-family: \'Helvetica Neue\',Helvetica,Arial,sans-serif; font-size: 14px; padding: 20px;\">\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#F4F3F4\">\r\n<tbody>\r\n<tr>\r\n<td><center>\r\n<table width=\"600px\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td align=\"left\">\r\n<div style=\"border: solid 1px #d9d9d9; width: 100%; background-color: #ffffff; padding: 20px;\">\r\n<table style=\"line-height: 1.6; font-size: 14px; font-family: Helvetica,Arial,sans-serif; border: solid 1px #ffffff; color: #444;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td style=\"color: #ffffff;\" colspan=\"2\" valign=\"bottom\" height=\"30\"> </td>\r\n</tr>\r\n<tr>\r\n<td style=\"line-height: 25px; padding-left: 30px;\">[company_logo]</td>\r\n<td style=\"line-height: 25px; padding-right: 30px;\">\r\n<div style=\"float: right; padding-top: 10px;\">Greupe 6 7694 BP Kloosterhaar<br /> Telefoon: 0900-xxxxxx<br /> info@cmsjunkie.com<br /> www.cmsjunkie.com<br /> Rabobank xxxxxxxxxx<br /> BTW nummer xxxxxxxxxxxx<br /> Kvk nummer xxxxxxxxxx</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<table style=\"margin-top: 15px; color: #444; line-height: 1.6; font-size: 14px; font-family: Arial,sans-serif;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr>\r\n<td style=\"border-top: solid 1px #d9d9d9; border-bottom: solid 1px #d9d9d9;\" colspan=\"2\">\r\n<div style=\"padding: 15px 0; width: 100%;\">Hello, <br /><br />Invoice date:[invoice_date]<br /> <br /> Invoice number:[invoice_number]<br /> <br />\r\n<h3>Invoice</h3>\r\n<br />\r\n<table style=\"padding: 5px; width: 100%;\" bgcolor=\"#FAF9FA\">\r\n<tbody>\r\n<tr>\r\n<td>\r\n<p>Bill to:</p>\r\n[billing_information]</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<br />[reservation_details] <br /><br />[hotel_cancellation_policy] </div>\r\n<div style=\"padding: 15px 0; width: 100%;\"><br /> Sincerely,\r\n<div>[company_name]</div>\r\n</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</center></td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>'),
(7,'Availability request','Availability Request Email','Availability Request Email','<div style=\"margin: 0px; width: 100%; background-color: #f4f3f4; font-family: Helvetica,Arial,sans-serif; font-size: 12px;\">\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#F4F3F4\">\n<tbody>\n<tr>\n<td style=\"padding: 15px;\"><center>\n<table width=\"80%\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\" bgcolor=\"#ffffff\">\n<tbody>\n<tr>\n<td align=\"left\">\n<div style=\"border: solid 1px #d9d9d9; width: 100%;\">\n<table style=\"line-height: 1.6; font-size: 12px; font-family: Helvetica,Arial,sans-serif; border: solid 1px #ffffff; color: #444;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#ffffff\">\n<tbody>\n<tr>\n<td style=\"color: #ffffff;\" colspan=\"2\" valign=\"bottom\" height=\"30\">�</td>\n</tr>\n<tr>\n<td style=\"line-height: 32px; padding-left: 30px;\" valign=\"baseline\">[company_logo]</td>\n</tr>\n</tbody>\n</table>\n<table style=\"margin-top: 15px; color: #444; width: 100%; padding: 15px; line-height: 1.6; font-size: 12px; font-family: Arial,sans-serif;\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#ffffff\">\n<tbody>\n<tr>\n<td style=\"border-top: solid 1px #d9d9d9; border-bottom: solid 1px #d9d9d9; width: 100%; padding: 10px;\" colspan=\"2\">\n<div style=\"padding: 15px 0; width: 100%;\">Hi [company_name]</div>\n<div style=\"padding: 15px 0; width: 100%;\">�Availability Request for your stay at our hotel. <br /><br /> [request_form]</div>\n</td>\n</tr>\n</tbody>\n</table>\n<table style=\"line-height: 1.5; font-size: 12px; font-family: Arial,sans-serif; margin-right: 30px; width: auto; margin-left: 30px;\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#ffffff\">\n<tbody>\n<tr style=\"font-size: 11px; color: #999999;\" valign=\"middle\">\n<td>[social_sharing]</td>\n<td>�</td>\n</tr>\n<tr>\n<td style=\"color: #ffffff;\" colspan=\"2\" height=\"15\">�</td>\n</tr>\n</tbody>\n</table>\n</div>\n</td>\n</tr>\n</tbody>\n</table>\n</center></td>\n</tr>\n</tbody>\n</table>\n</div>'),
(8,'Add Hotel Request Email','Add Hotel Request Email','Add Hotel Request Email','<div style=\"text-align: center; background-color: #f8f8f8; padding: 20px; margin: 0; font-family: Arial; font-size: 12px;\">\n<div align=\"center\">\n<div style=\"width: 80%; padding: 20px 30px 20px 20px; border: 1px solid #f3f3f3; background-color: #ffffff;\">\n<table style=\"border-collapse: collapse; border-color: red; width: 100%;\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#ffffff\">\n<tbody>\n<tr>\n<td width=\"500\">[company_logo]</td>\n<td align=\"right\"> </td>\n</tr>\n<tr>\n<td colspan=\"2\">\n<div style=\"width: 95%; background: #ffffff; padding: 30px 0px 20px 0px; border: 0px; text-align: left; margin: 0;\">\n<table style=\"width: 100%;\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td>Hi [hotel_name], <br /> <br />Thank you for your request to be part of our hotel group. <br />With this message, we confirm receipt of your request. Your username and password have been sent in a separate email. You can login at the following URL to manage your listings.</td>\n</tr>\n<tr>\n<td> </td>\n</tr>\n<tr>\n<td>Admin URL:[admin_url]</td>\n</tr>\n<tr>\n<td> </td>\n</tr>\n<tr>\n<td><br />Best wishes,<br />[company_name]<br /><br /></td>\n</tr>\n</tbody>\n</table>\n</div>\n</td>\n</tr>\n</tbody>\n</table>\n<div> </div>\n</div>\n</div>\n</div>');

--
-- Table structure for table `n36ic_hotelreservation_excursion_pictures`
--

CREATE TABLE `n36ic_hotelreservation_excursion_pictures` (
  `picture_id` int(10) NOT NULL AUTO_INCREMENT,
  `excursion_id` int(10) NOT NULL DEFAULT 0,
  `picture_info` blob DEFAULT NULL,
  `picture_path` blob DEFAULT NULL,
  `picture_enable` tinyint(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`picture_id`),
  KEY `Index 2` (`excursion_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_excursion_pictures`
--


--
-- Table structure for table `n36ic_hotelreservation_excursion_rate_prices`
--

CREATE TABLE `n36ic_hotelreservation_excursion_rate_prices` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rate_id` int(11) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `price` decimal(12,2) DEFAULT NULL,
  `child_price` decimal(12,2) DEFAULT NULL,
  `availability` tinyint(6) DEFAULT NULL,
  `min_days` tinyint(4) NOT NULL DEFAULT 1,
  `max_days` tinyint(4) NOT NULL DEFAULT 0,
  `price_2` decimal(12,2) NOT NULL DEFAULT 0.00,
  `price_3` decimal(12,2) NOT NULL DEFAULT 0.00,
  `price_4` decimal(12,2) NOT NULL DEFAULT 0.00,
  `price_5` decimal(12,2) NOT NULL DEFAULT 0.00,
  `price_6` decimal(12,2) NOT NULL DEFAULT 0.00,
  `price_7` decimal(12,2) NOT NULL DEFAULT 0.00,
  `price_8` decimal(12,2) NOT NULL DEFAULT 0.00,
  `price_9` decimal(12,2) NOT NULL DEFAULT 0.00,
  `price_10` decimal(12,2) NOT NULL DEFAULT 0.00,
  `price_11` decimal(12,2) NOT NULL DEFAULT 0.00,
  `price_12` decimal(12,2) NOT NULL DEFAULT 0.00,
  `price_13` decimal(12,2) NOT NULL DEFAULT 0.00,
  `price_14` decimal(12,2) NOT NULL DEFAULT 0.00,
  `price_15` decimal(12,2) NOT NULL DEFAULT 0.00,
  `price_16` decimal(12,2) NOT NULL DEFAULT 0.00,
  `price_17` decimal(12,2) NOT NULL DEFAULT 0.00,
  `price_18` decimal(12,2) NOT NULL DEFAULT 0.00,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_excursion_rate_prices`
--


--
-- Table structure for table `n36ic_hotelreservation_excursion_rates`
--

CREATE TABLE `n36ic_hotelreservation_excursion_rates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `excursion_id` int(11) NOT NULL,
  `name` varchar(45) DEFAULT NULL,
  `rate_description` tinytext DEFAULT NULL,
  `price_type` tinyint(4) NOT NULL DEFAULT 1,
  `can_cancel` tinyint(4) DEFAULT NULL,
  `cancel_days` tinyint(4) DEFAULT NULL,
  `cancel_text` tinytext DEFAULT NULL,
  `status` tinyint(4) DEFAULT NULL,
  `price_1` decimal(12,2) DEFAULT NULL,
  `price_2` decimal(12,2) DEFAULT NULL,
  `price_3` decimal(12,2) DEFAULT NULL,
  `price_4` decimal(12,2) DEFAULT NULL,
  `price_5` decimal(12,2) DEFAULT NULL,
  `price_6` decimal(12,2) DEFAULT NULL,
  `price_7` decimal(12,2) DEFAULT NULL,
  `child_price` decimal(12,2) DEFAULT NULL,
  `availability` smallint(6) DEFAULT NULL,
  `min_days` tinyint(4) NOT NULL DEFAULT 1,
  `max_days` tinyint(4) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ROOM_INDEX` (`excursion_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_excursion_rates`
--


--
-- Table structure for table `n36ic_hotelreservation_excursions`
--

CREATE TABLE `n36ic_hotelreservation_excursions` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `hotel_id` int(10) DEFAULT NULL,
  `name` char(255) DEFAULT NULL,
  `description` blob DEFAULT NULL,
  `currency_id` int(2) DEFAULT NULL,
  `capacity` int(10) DEFAULT NULL,
  `number` int(10) DEFAULT NULL,
  `type_price` int(10) DEFAULT NULL,
  `type` int(10) DEFAULT NULL,
  `data_start` date DEFAULT NULL,
  `data_end` date DEFAULT NULL,
  `min_nights` tinyint(10) DEFAULT NULL,
  `max_nights` tinyint(10) DEFAULT NULL,
  `ignored_dates` blob DEFAULT NULL,
  `excursion_day_1` tinyint(1) NOT NULL DEFAULT 1,
  `excursion_day_2` tinyint(1) NOT NULL DEFAULT 1,
  `excursion_day_3` tinyint(1) NOT NULL DEFAULT 1,
  `excursion_day_4` tinyint(1) NOT NULL DEFAULT 1,
  `excursion_day_5` tinyint(1) NOT NULL DEFAULT 1,
  `excursion_day_6` tinyint(1) NOT NULL DEFAULT 1,
  `excursion_day_7` tinyint(1) NOT NULL DEFAULT 1,
  `is_available` tinyint(1) NOT NULL DEFAULT 1,
  `ordering` int(10) NOT NULL DEFAULT 0,
  `front_display` int(1) NOT NULL DEFAULT 0,
  `age_restrictions_required` int(1) NOT NULL DEFAULT 0,
  `age_restrictions_min` tinyint(3) DEFAULT NULL,
  `age_restrictions_max` tinyint(3) DEFAULT NULL,
  `latitude` varchar(45) DEFAULT NULL,
  `longitude` varchar(45) DEFAULT NULL,
  `country_id` int(10) DEFAULT NULL,
  `county` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `zipcode` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `NewIndex` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_excursions`
--


--
-- Table structure for table `n36ic_hotelreservation_extra_options`
--

CREATE TABLE `n36ic_hotelreservation_extra_options` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `hotel_id` int(10) NOT NULL DEFAULT 0,
  `name` varchar(245) DEFAULT NULL,
  `price_type` tinyint(1) DEFAULT NULL,
  `price` decimal(18,2) NOT NULL DEFAULT 0.00,
  `description` text DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `image_path` varchar(245) DEFAULT NULL,
  `is_per_day` tinyint(1) NOT NULL DEFAULT 0,
  `mandatory` tinyint(1) NOT NULL DEFAULT 0,
  `ordering` smallint(6) NOT NULL DEFAULT 1,
  `room_ids` varchar(245) DEFAULT NULL,
  `offer_ids` varchar(245) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `map_per_length_of_stay` tinyint(1) NOT NULL DEFAULT 1,
  `multiplier` int(1) NOT NULL DEFAULT 0,
  `commission` tinyint(4) DEFAULT NULL,
  `extra_option_cost` float(18,2) NOT NULL DEFAULT 0.00,
  PRIMARY KEY (`id`),
  UNIQUE KEY `NewIndex` (`name`,`hotel_id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_extra_options`
--

INSERT INTO `n36ic_hotelreservation_extra_options` VALUES
(1,-1,'Bike Tour',1,20.00,'Bike tour around country side.','2013-07-01','2016-07-31','/1/High-Tea-Hotel-Ootmarsum.jpg',1,0,1,NULL,NULL,1,1,0,NULL,0.00),
(2,11,'Bike Tour',1,20.00,'Bike tour around country side.','2013-07-01','2016-07-31','/2/elektrische-fiets-hotel-arrangement.jpg',1,0,1,'30,29,28','2',1,1,0,NULL,0.00),
(3,-1,'Our special delights',1,12.00,'Enjoy our special cuisine at breakfast.','2013-07-01','2016-07-31','/3/High-Tea-Hotel-Ootmarsum.jpg',1,0,1,NULL,NULL,1,1,0,NULL,0.00),
(4,11,'Our special delights',1,12.00,'Enjoy our special cuisine at breakfast.','2013-07-01','2016-07-31','/4/High-Tea-Hotel-Ootmarsum.jpg',1,0,1,'30,29,28','2',1,1,0,NULL,0.00),
(5,5,'Bike Tour',1,20.00,'Bike tour around country side.','2013-07-01','2016-07-31','/5/elektrische-fiets-hotel-arrangement.jpg',1,0,1,'21,20,19',NULL,1,1,0,NULL,0.00),
(6,5,'Our special delights',1,12.00,'Enjoy our special cuisine at breakfast.','2013-07-01','2016-07-31','/6/High-Tea-Hotel-Ootmarsum.jpg',1,0,1,'21,20,19,22',NULL,1,1,0,NULL,0.00),
(7,4,'Bike Tour',1,20.00,'Bike tour around country side.','2013-07-01','2016-07-31','/7/elektrische-fiets-hotel-arrangement.jpg',1,0,1,'18,16,23,17',NULL,1,1,0,NULL,0.00),
(8,4,'Our special delights',1,12.00,'Enjoy our special cuisine at breakfast.','2013-07-01','2016-07-31','/8/High-Tea-Hotel-Ootmarsum.jpg',1,0,1,'18,16,23,17',NULL,1,1,0,NULL,0.00);

--
-- Table structure for table `n36ic_hotelreservation_group_role_mapping`
--

CREATE TABLE `n36ic_hotelreservation_group_role_mapping` (
  `group_id` int(11) NOT NULL DEFAULT 0,
  `role_id` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`group_id`,`role_id`),
  KEY `R_4` (`role_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_group_role_mapping`
--

INSERT INTO `n36ic_hotelreservation_group_role_mapping` VALUES
(1,1);

--
-- Table structure for table `n36ic_hotelreservation_groups`
--

CREATE TABLE `n36ic_hotelreservation_groups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) DEFAULT NULL,
  `description` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_groups`
--

INSERT INTO `n36ic_hotelreservation_groups` VALUES
(1,'Hotel Admin Group','Hotel Admin Group						');

--
-- Table structure for table `n36ic_hotelreservation_guest_details_attributes`
--

CREATE TABLE `n36ic_hotelreservation_guest_details_attributes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(55) DEFAULT NULL,
  `config_type` tinyint(1) DEFAULT NULL,
  `ordering` tinyint(4) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `Unique_Name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_guest_details_attributes`
--

INSERT INTO `n36ic_hotelreservation_guest_details_attributes` VALUES
(1,'company_name',3,4),
(2,'salutation',2,1),
(3,'first_name',2,2),
(4,'last_name',2,3),
(5,'autocomplete_address',2,5),
(6,'address',0,6),
(7,'postal_code',0,8),
(8,'city',0,9),
(9,'state_name',0,10),
(10,'country',0,11),
(11,'phone',2,12),
(12,'email',2,13),
(13,'remarks',1,14),
(15,'street_number',0,7),
(16,'arrival_time',0,15),
(17,'therapy_group',0,16),
(18,'therapy_days',0,17),
(19,'therapy_children',0,18),
(20,'therapy_adults',0,19);

--
-- Table structure for table `n36ic_hotelreservation_hotel_accommodation_type_relation`
--

CREATE TABLE `n36ic_hotelreservation_hotel_accommodation_type_relation` (
  `hotelId` int(11) NOT NULL DEFAULT 0,
  `accommodationtypeId` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`accommodationtypeId`,`hotelId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_hotel_accommodation_type_relation`
--

INSERT INTO `n36ic_hotelreservation_hotel_accommodation_type_relation` VALUES
(4,3),
(5,3),
(11,3),
(4,4),
(5,4),
(11,4),
(14,4),
(4,5),
(5,5),
(27,5),
(14,6),
(14,8);

--
-- Table structure for table `n36ic_hotelreservation_hotel_accommodation_types`
--

CREATE TABLE `n36ic_hotelreservation_hotel_accommodation_types` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_hotel_accommodation_types`
--

INSERT INTO `n36ic_hotelreservation_hotel_accommodation_types` VALUES
(1,'Hotels'),
(3,'Bed'),
(4,'Apartment'),
(5,'Cottage'),
(6,'Hostel'),
(8,'Hut');

--
-- Table structure for table `n36ic_hotelreservation_hotel_channel_manager`
--

CREATE TABLE `n36ic_hotelreservation_hotel_channel_manager` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `hotel_id` int(11) NOT NULL,
  `service` varchar(45) DEFAULT NULL,
  `user` varchar(45) DEFAULT NULL,
  `password` varchar(45) DEFAULT NULL,
  `api_key` varchar(45) DEFAULT NULL,
  `private_key` varchar(45) DEFAULT NULL,
  `cubilis_connection_id` int(11) DEFAULT NULL,
  `is_rez_connection` tinyint(1) NOT NULL DEFAULT 0,
  `allow_update` tinyint(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  UNIQUE KEY `Hotel` (`hotel_id`,`service`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_hotel_channel_manager`
--


--
-- Table structure for table `n36ic_hotelreservation_hotel_contacts`
--

CREATE TABLE `n36ic_hotelreservation_hotel_contacts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `hotel_id` int(11) DEFAULT NULL,
  `mcontact` varchar(45) DEFAULT NULL,
  `mphone` varchar(45) DEFAULT NULL,
  `memail` varchar(45) DEFAULT NULL,
  `rcontact` varchar(45) DEFAULT NULL,
  `rphone` varchar(45) DEFAULT NULL,
  `booking_email` varchar(45) DEFAULT NULL,
  `booking_list_email` varchar(45) DEFAULT NULL,
  `remail` varchar(45) DEFAULT NULL,
  `acontact` varchar(45) DEFAULT NULL,
  `aphone` varchar(45) DEFAULT NULL,
  `aemail` varchar(45) DEFAULT NULL,
  `aemailinv` varchar(45) DEFAULT NULL,
  `vatno` varchar(45) DEFAULT NULL,
  `iban` varchar(45) DEFAULT NULL,
  `chamber_commerce` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_hotel_contacts`
--

INSERT INTO `n36ic_hotelreservation_hotel_contacts` VALUES
(1,27,'','','','','','','','','','','','','','','');

--
-- Table structure for table `n36ic_hotelreservation_hotel_environment_relation`
--

CREATE TABLE `n36ic_hotelreservation_hotel_environment_relation` (
  `hotelId` int(11) NOT NULL DEFAULT 0,
  `environmentId` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`hotelId`,`environmentId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_hotel_environment_relation`
--

INSERT INTO `n36ic_hotelreservation_hotel_environment_relation` VALUES
(4,1),
(4,3),
(5,2),
(5,3),
(27,2);

--
-- Table structure for table `n36ic_hotelreservation_hotel_environments`
--

CREATE TABLE `n36ic_hotelreservation_hotel_environments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_hotel_environments`
--

INSERT INTO `n36ic_hotelreservation_hotel_environments` VALUES
(1,'Cultural'),
(2,'Cycling'),
(3,'Romantic'),
(4,'Ski Resort');

--
-- Table structure for table `n36ic_hotelreservation_hotel_facilities`
--

CREATE TABLE `n36ic_hotelreservation_hotel_facilities` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_hotel_facilities`
--

INSERT INTO `n36ic_hotelreservation_hotel_facilities` VALUES
(1,'Bicycle'),
(3,'Indoor pool'),
(5,'Design'),
(9,'Wifi'),
(14,'Fitness'),
(15,'Entertaiment'),
(16,'Sport'),
(17,'Lift');

--
-- Table structure for table `n36ic_hotelreservation_hotel_facility_relation`
--

CREATE TABLE `n36ic_hotelreservation_hotel_facility_relation` (
  `hotelId` int(11) NOT NULL DEFAULT 0,
  `facilityId` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`hotelId`,`facilityId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_hotel_facility_relation`
--

INSERT INTO `n36ic_hotelreservation_hotel_facility_relation` VALUES
(4,1),
(4,3),
(4,5),
(4,9),
(4,15),
(4,16),
(4,17),
(5,1),
(5,3),
(5,5),
(5,9),
(5,15),
(5,17),
(6,7),
(6,8),
(9,1),
(9,6),
(9,8),
(11,1),
(11,3),
(11,5),
(11,9),
(11,14),
(11,15),
(11,16),
(11,17),
(14,5),
(14,9),
(27,14);

--
-- Table structure for table `n36ic_hotelreservation_hotel_informations`
--

CREATE TABLE `n36ic_hotelreservation_hotel_informations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `hotel_id` int(11) NOT NULL DEFAULT 0,
  `check_in` varchar(10) DEFAULT NULL,
  `check_out` varchar(10) DEFAULT NULL,
  `parking` tinyint(1) DEFAULT NULL,
  `parking_period` varchar(65) DEFAULT NULL,
  `price_parking` float DEFAULT 0,
  `pets` tinyint(1) DEFAULT NULL,
  `price_pets` float DEFAULT 0,
  `pet_info` varchar(100) DEFAULT NULL,
  `city_tax` varchar(250) DEFAULT NULL,
  `city_tax_percent` tinyint(1) NOT NULL DEFAULT 0,
  `number_of_rooms` smallint(6) DEFAULT NULL,
  `cancellation_conditions` tinytext DEFAULT NULL,
  `cancellation_days` mediumint(4) DEFAULT 0,
  `wifi` tinyint(1) DEFAULT NULL,
  `price_wifi` float DEFAULT 0,
  `wifi_period` varchar(65) DEFAULT NULL,
  `suitable_disabled` tinyint(1) DEFAULT NULL,
  `public_transport` tinyint(1) DEFAULT NULL,
  `payment_options` varchar(100) DEFAULT NULL,
  `children_category` varchar(200) DEFAULT NULL,
  `uvh_agree` tinyint(1) DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `informations` (`hotel_id`)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_hotel_informations`
--

INSERT INTO `n36ic_hotelreservation_hotel_informations` VALUES
(1,11,'5:00','12:00',1,NULL,0,0,5,NULL,'2.2',0,124,'Extra info',4,1,6,NULL,0,1,NULL,'Children 0-2 - discount 100%,\r\nChildren 3-7 - discount 50%\r\n',1),
(3,5,'14:00','13:00',0,NULL,0,0,0,NULL,'2',0,23,'This is the place for cancelation conditions.',28,1,20,NULL,1,0,NULL,'Children 0-2 - discount 100%,\r\nChildren 3-7 - discount 50%\r\n',NULL),
(4,4,'14:00','12:00',0,NULL,0,0,0,NULL,'2',0,300,'This is the place where cancelation conditions goes',4,1,10,NULL,1,0,NULL,'Children 0-2 - discount 100%,\r\nChildren 3-7 - discount 50%\r\n',NULL),
(18,27,'0:00','0:00',0,'',NULL,0,NULL,'','Oshawa',0,1,NULL,1,0,NULL,'',0,0,NULL,NULL,0);

--
-- Table structure for table `n36ic_hotelreservation_hotel_payment_option_relation`
--

CREATE TABLE `n36ic_hotelreservation_hotel_payment_option_relation` (
  `hotelId` int(11) NOT NULL DEFAULT 0,
  `paymentOptionId` tinyint(4) NOT NULL DEFAULT 0,
  PRIMARY KEY (`hotelId`,`paymentOptionId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_hotel_payment_option_relation`
--

INSERT INTO `n36ic_hotelreservation_hotel_payment_option_relation` VALUES
(5,1),
(11,1),
(11,4),
(11,5),
(14,5);

--
-- Table structure for table `n36ic_hotelreservation_hotel_payment_options`
--

CREATE TABLE `n36ic_hotelreservation_hotel_payment_options` (
  `id` tinyint(4) NOT NULL AUTO_INCREMENT,
  `name` varchar(80) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_hotel_payment_options`
--

INSERT INTO `n36ic_hotelreservation_hotel_payment_options` VALUES
(1,'Cash'),
(4,'Pin'),
(5,'Credit Card');

--
-- Table structure for table `n36ic_hotelreservation_hotel_pictures`
--

CREATE TABLE `n36ic_hotelreservation_hotel_pictures` (
  `hotel_picture_id` int(10) NOT NULL AUTO_INCREMENT,
  `hotel_id` int(10) NOT NULL DEFAULT 0,
  `hotel_picture_info` blob DEFAULT NULL,
  `hotel_picture_path` blob DEFAULT NULL,
  `hotel_picture_enable` tinyint(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`hotel_picture_id`),
  KEY `Index 2` (`hotel_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_hotel_pictures`
--

INSERT INTO `n36ic_hotelreservation_hotel_pictures` VALUES
(1,11,'','/hotels/11/13442898.jpg',1),
(2,11,'','/hotels/11/19768_338_z.jpg',1),
(3,11,'','/hotels/11/19768_368_z.jpg',1);

--
-- Table structure for table `n36ic_hotelreservation_hotel_region_relation`
--

CREATE TABLE `n36ic_hotelreservation_hotel_region_relation` (
  `hotelId` int(11) NOT NULL DEFAULT 0,
  `regionId` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`hotelId`,`regionId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_hotel_region_relation`
--

INSERT INTO `n36ic_hotelreservation_hotel_region_relation` VALUES
(4,4),
(4,5),
(5,3),
(5,5),
(27,4);

--
-- Table structure for table `n36ic_hotelreservation_hotel_regions`
--

CREATE TABLE `n36ic_hotelreservation_hotel_regions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_hotel_regions`
--

INSERT INTO `n36ic_hotelreservation_hotel_regions` VALUES
(1,'City'),
(2,'Village'),
(3,'Forest'),
(4,'Mounting'),
(5,'Coast');

--
-- Table structure for table `n36ic_hotelreservation_hotel_review_comments`
--

CREATE TABLE `n36ic_hotelreservation_hotel_review_comments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `reviewId` int(11) NOT NULL DEFAULT 0,
  `userId` int(11) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  PRIMARY KEY (`id`,`reviewId`),
  KEY `R_19` (`reviewId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_hotel_review_comments`
--


--
-- Table structure for table `n36ic_hotelreservation_hotel_type_relation`
--

CREATE TABLE `n36ic_hotelreservation_hotel_type_relation` (
  `hotelId` int(11) NOT NULL DEFAULT 0,
  `typeId` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`hotelId`,`typeId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_hotel_type_relation`
--

INSERT INTO `n36ic_hotelreservation_hotel_type_relation` VALUES
(4,1),
(4,3),
(4,4),
(5,3),
(5,4),
(5,5),
(6,1),
(6,4),
(14,3),
(14,4),
(14,5),
(14,6),
(27,5);

--
-- Table structure for table `n36ic_hotelreservation_hotel_types`
--

CREATE TABLE `n36ic_hotelreservation_hotel_types` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_hotel_types`
--

INSERT INTO `n36ic_hotelreservation_hotel_types` VALUES
(1,'Luxury'),
(3,'Gourmet'),
(4,'Design'),
(5,'Forest'),
(6,'Sea Side'),
(9,'Swamp'),
(8,'Cliff');

--
-- Table structure for table `n36ic_hotelreservation_hotels`
--

CREATE TABLE `n36ic_hotelreservation_hotels` (
  `hotel_id` int(10) NOT NULL AUTO_INCREMENT,
  `hotel_name` char(255) DEFAULT NULL,
  `hotel_alias` varchar(255) DEFAULT NULL,
  `currency_id` int(10) DEFAULT NULL,
  `hotel_description` blob DEFAULT NULL,
  `hotel_short_description` varchar(255) DEFAULT NULL,
  `country_id` int(10) DEFAULT NULL,
  `hotel_county` char(255) DEFAULT NULL,
  `hotel_city` char(255) DEFAULT NULL,
  `hotel_address` char(255) DEFAULT NULL,
  `hotel_website` blob DEFAULT NULL,
  `is_available` tinyint(1) NOT NULL DEFAULT 1,
  `hotel_state` tinyint(1) NOT NULL DEFAULT 1,
  `hotel_latitude` varchar(45) DEFAULT NULL,
  `hotel_longitude` varchar(45) DEFAULT NULL,
  `hotel_stars` tinyint(4) DEFAULT NULL,
  `custom_rating` tinyint(4) DEFAULT NULL,
  `hotel_rating_score` float DEFAULT NULL,
  `hotel_zipcode` varchar(45) DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `ignored_dates` blob DEFAULT NULL,
  `featured` tinyint(1) NOT NULL DEFAULT 0,
  `email` varchar(80) DEFAULT NULL,
  `commission` tinyint(4) DEFAULT NULL,
  `recommended` tinyint(1) NOT NULL DEFAULT 0,
  `reservation_cost_val` float(18,2) NOT NULL DEFAULT 0.00,
  `reservation_cost_proc` float(18,2) NOT NULL DEFAULT 0.00,
  `hotel_phone` varchar(55) DEFAULT NULL,
  `hotel_number` varchar(50) DEFAULT NULL,
  `min_room_price` decimal(14,2) DEFAULT 0.00,
  `hotel_selling_points` text DEFAULT NULL,
  `availability_contact` tinyint(1) NOT NULL DEFAULT 0,
  `remarks` text DEFAULT NULL,
  `display_unavailability_message` int(1) NOT NULL DEFAULT 0,
  `reservation_cost_multiple_nights` int(11) DEFAULT NULL,
  `social_sharing` tinyint(1) NOT NULL DEFAULT 1,
  `menu_id` int(10) DEFAULT NULL,
  `hotel_manager` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`hotel_id`)
) ENGINE=MyISAM AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_hotels`
--

INSERT INTO `n36ic_hotelreservation_hotels` VALUES
(4,'Venice Hotel','venice-hotel',2,'In the historic, artistic, and commercial heart of Venice, Venice Hotel is in a unique and enviable position overlooking the Grand Canal, just across from Venice Bridge, one of the most beautiful and suggestive spots of the city.\r\nIt is only a 15-minute walk from the hotel to wonderful Saint Mihail\'s Square with a stroll along the Mercerie, the shopping streets where charming artisan shops alternate with trendy stores of renowned international houses such as Gucci, Prada, Cartier, Louis Vuitton, etc. After crossing the Bridge and in just a few minutes you will be at the picturesque Rialto fruit market and the historic fish market.\r\nVenice is an extraordinarily beautiful city. Venice represents an urban landscape so rich in its lavishness that it can be overwhelming. It seems as if at each step you will encounter some aspect of the city worth admiring.  The major sights like the basilica and piazza of San Marco are perhaps the city’s most famous. Venice’s most celebrated event is the Carnival, which occupies the ten days leading up to Lent. Another major event is the Regatta Storica, held on the first Sunday in September, an annual trial of strength and skill for the city’s gondoliers which starts with a procession of richly decorated historic craft along the Canal Grande course, their crews all decked out in period dress. Venice is also the home of the Venice Biennale, set up in 1895 as a showpiece for international contemporary art, and held every odd-numbered year from June to September. Its permanent site is located in the Giardini Pubblici.\r\nThe Piazza San Marco is the hub of most activity, signaled from most parts of the city by the Campanile, which began life as a lighthouse in the ninth century. Venice’s lavishness and fantasy, the result not just of its remarkable buildings but of the very fact that Venice is a city built on water but a city created more than 1,000 years ago by men who dared defy the sea, implanting their splendid palaces and churches on mud banks in a swampy and treacherous lagoon.\r\nGothic styles were adapted to create a new kind of Venetian Gothic art and architecture. Venice is a unique blend of water, art and romance located four kilometers from terra firma and two kilometers from the Adriatic Sea. It is a treasure from the artistic and architectural point of view. The city was built on over 100 islands in a lagoon on an exceptional atmosphere during the phenomenon of \"high water,\" when the high tide exceeds the level of dry land and floods the main streets and piazzas of Venice.\r\nFor these reasons, Venice is one of the cities most visited by tourists from around the world. Byzantine, Gothic and Renaissance are the principal reference points for the artistic development of Venice.','Test desc',107,'Sarasota','Venice','Giusepe 10, 30133 Venice','',1,1,'52.2413','4.43187',3,NULL,NULL,NULL,'0000-00-00','0000-00-00','NaN-NaN-NaN,2012-04-03',1,'hotel@office.nod',20,0,10.00,10.00,'123123',NULL,80.00,NULL,0,NULL,0,NULL,1,NULL,NULL),
(5,'Paris Hotel','paris-hotel',2,'Our 4-star hotel, close to the Champs-Élysées, the Louvre, Place de la Concorde and the stylish boutiques of the Saint-Honoré district, is perfect both for business trips and stays at the heart of the attractions and cultural life of Paris.\r\nThe hotel has45 rooms , designed to combine sophisticated style and the ultimate in comfort to fit your needs. As well as a relaxing spa with steam showers, a fitness room and a range of massages are at your service. Paris is known for its famous buildings and works of art, its chic fashion scene and its modern literary, artistic, and intellectual ideals, and is a must for anyone wishing to experience the best of both contemporary and age old European culture.\r\n\r\n\r\n\r\n \r\nIf you have limited time, make sure to go to the area north of the river, the Rive Droite, to see the tree-lined Avenue des Champs Elysees, running west from the Arc de Triomphe. East of the avenue is the Musee du Louvre, the Centre Georges Pompidou and a lively district of museums, shops, markets and restaurants. Immediately south of the Pompidou Centre on the Ile de la Cite is Notre Dame Cathedral.\r\n \r\nIf you still have time, head west along the river and you will find the city’s trademark, the Eiffel Tower. If you are intrigued by Paris’ famous academic, artistic and intellectual enclave, the Saint Germain de Pres and Montparnasse districts are located just to the east.','<p>Our 4-star hotel, close to the Champs-Élysées, the Louvre, Place de la Concorde and the stylish boutiques of the Saint-Honoré district, is perfect both for business trips and stays at the heart of the attractions and cultural life of Paris.</p>\r\n<p>The',72,'Paris','Paris','Rue Michel Chasles 10','',1,1,'56.8848','14.7730',6,NULL,NULL,NULL,'0000-00-00','0000-00-00','NaN-NaN-NaN,2012-04-03',1,'hotel@office.nod',0,0,0.00,0.00,'',NULL,70.00,NULL,0,NULL,0,NULL,1,NULL,NULL),
(11,'New York Hotel','new-york-hotel',1,'Broadway rhythm\r\nSet amid Broadway theaters, this stylish New York hotel is a half-block from Times Square and the TKTS discount-tickets booth and half a block from Restaurant Row. Bryant Park, Minskoff Theater, Gershwin Theater, and Radio City Music Hall are also nearby. Show more\r\nUnparalleled style\r\nLounge in style in the Philippe Starck-designed lobby. In the evening, relax in the plush surroundings of the Library Bar with a pre-theater drink, or visit the Paramount Bar for a taste of Times Square.\r\nHDTV, iPod docks\r\nThe newly renovated guestrooms at the Paramount Hotel feature modern furnishings, high-definition TVs, and iPod docks. Beds feature high-thread-count bedding and down bedspreads','Luxe hotel in Drenthe',226,'NY','New York','Broadway avenue','',1,1,'52.314748','6.547852',4,NULL,0,NULL,'0000-00-00','0000-00-00','NaN-NaN-NaN,2012-03-13,2012-04-02,2012-04-03,2012-04-19',1,'hotel@office.nod',10,1,50.00,20.00,'1231231121',NULL,50.00,NULL,0,NULL,0,NULL,1,NULL,NULL),
(27,'Donevan Community, Oshawa','donevan',1,'',NULL,36,'Durham','Oshawa','142 Athabasca Street','',1,0,'','',5,7,NULL,'L1H 7H8',NULL,NULL,'',0,'oshawa@localcommunityHero.com',20,1,25.00,0.00,'2899288741','',0.00,'',0,'',0,NULL,1,NULL,'');

--
-- Table structure for table `n36ic_hotelreservation_invoice_details`
--

CREATE TABLE `n36ic_hotelreservation_invoice_details` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `invoiceId` int(11) DEFAULT NULL,
  `reservationId` int(11) DEFAULT NULL,
  `name` varchar(45) DEFAULT NULL,
  `arrival` date DEFAULT NULL,
  `departure` date DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `voucher` varchar(85) DEFAULT NULL,
  `amount` float DEFAULT NULL,
  `commissionAmount` float DEFAULT NULL,
  `initialAmount` float DEFAULT NULL,
  `commission` float DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=49 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_invoice_details`
--


--
-- Table structure for table `n36ic_hotelreservation_invoices`
--

CREATE TABLE `n36ic_hotelreservation_invoices` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` date DEFAULT NULL,
  `hotelId` int(11) NOT NULL DEFAULT 0,
  `commissionAmount` float DEFAULT NULL,
  `reservationAmount` float DEFAULT NULL,
  `amount` float DEFAULT NULL,
  `status` tinyint(1) DEFAULT 0,
  `creationDate` timestamp NULL DEFAULT current_timestamp(),
  `approvalDate` date DEFAULT NULL,
  `approvalName` varchar(105) DEFAULT NULL,
  `content` text DEFAULT NULL,
  `agreed` tinyint(1) DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `invoice` (`date`,`hotelId`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_invoices`
--


--
-- Table structure for table `n36ic_hotelreservation_language_translations`
--

CREATE TABLE `n36ic_hotelreservation_language_translations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` int(11) DEFAULT NULL,
  `object_id` int(11) DEFAULT NULL,
  `language_tag` varchar(10) DEFAULT NULL,
  `content` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_language_translations`
--

INSERT INTO `n36ic_hotelreservation_language_translations` VALUES
(1,20,1,'en-GB','this is an awesome POI');

--
-- Table structure for table `n36ic_hotelreservation_news`
--

CREATE TABLE `n36ic_hotelreservation_news` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `link` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `publish_date` datetime DEFAULT NULL,
  `retrieve_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_news`
--


--
-- Table structure for table `n36ic_hotelreservation_offers`
--

CREATE TABLE `n36ic_hotelreservation_offers` (
  `offer_id` int(10) NOT NULL AUTO_INCREMENT,
  `hotel_id` int(10) NOT NULL DEFAULT 0,
  `offer_code` varchar(100) NOT NULL DEFAULT ' ',
  `offer_name` varchar(255) NOT NULL DEFAULT ' ',
  `offer_alias` varchar(255) DEFAULT NULL,
  `offer_short_description` text DEFAULT NULL,
  `offer_description` blob DEFAULT NULL,
  `offer_content` text DEFAULT NULL,
  `offer_other_info` text DEFAULT NULL,
  `offer_min_nights` tinyint(10) NOT NULL DEFAULT 0,
  `offer_max_nights` tinyint(10) NOT NULL DEFAULT 0,
  `offer_min_pers` tinyint(10) NOT NULL DEFAULT 0,
  `offer_day_1` tinyint(1) NOT NULL DEFAULT 1,
  `offer_day_2` tinyint(1) NOT NULL DEFAULT 1,
  `offer_day_3` tinyint(1) NOT NULL DEFAULT 1,
  `offer_day_4` tinyint(1) NOT NULL DEFAULT 1,
  `offer_day_5` tinyint(1) NOT NULL DEFAULT 1,
  `offer_day_6` tinyint(1) NOT NULL DEFAULT 1,
  `offer_day_7` tinyint(1) NOT NULL DEFAULT 1,
  `offer_datas` date DEFAULT NULL,
  `offer_datae` date DEFAULT NULL,
  `offer_datasf` date DEFAULT NULL,
  `offer_dataef` date DEFAULT NULL,
  `offer_commission` tinyint(4) DEFAULT NULL,
  `ordering` int(10) NOT NULL DEFAULT 0,
  `offer_reservation_cost_val` float(18,2) NOT NULL DEFAULT 0.00,
  `offer_reservation_cost_proc` float(18,2) NOT NULL DEFAULT 0.00,
  `is_available` tinyint(1) NOT NULL DEFAULT 0,
  `public` tinyint(1) NOT NULL DEFAULT 0,
  `state` tinyint(1) DEFAULT NULL,
  `offer_initial_price` float(10,2) DEFAULT NULL,
  `featured` tinyint(1) NOT NULL DEFAULT 0,
  `top` tinyint(1) DEFAULT NULL,
  `airport_transfer_type_id` int(10) NOT NULL DEFAULT 0,
  `apply_max_nights` int(1) NOT NULL DEFAULT 0,
  `last_minute` tinyint(1) NOT NULL DEFAULT 0,
  `included_info` tinyint(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`offer_id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_offers`
--

INSERT INTO `n36ic_hotelreservation_offers` VALUES
(1,4,'','Cruise the canal',NULL,NULL,'<p>Super offer to cruise the canal</p>','<p>Super offer to cruise the canal</p>','<p>Super offer to cruise the canal</p>',2,4,0,1,1,1,1,1,1,1,'2012-03-05','2016-05-31','2012-02-01','2017-04-30',0,19,0.00,0.00,1,1,NULL,NULL,0,NULL,0,0,0,1),
(2,11,'12','Entertainment Breaks for 3 days',NULL,NULL,'<p>This <span style=\"text-decoration: underline;\">special</span> offer contains:</p>\r\n<p> </p>\r\n<ul>\r\n<li>2x overnight stay</li>\r\n<li>2x breakfast buffet</li>\r\n<li>1x 3-course dinner</li>\r\n<li>1 day bike rental</li>\r\n<li>free use of swimmingpool</li>\r\n</ul>','<ul>\r\n<li>free wifi</li>\r\n<li>free parking</li>\r\n</ul>','',2,2,0,1,1,1,1,1,1,1,'2012-03-30','2014-04-30','2012-02-02','2015-04-30',10,127,7.50,0.00,1,0,NULL,NULL,0,NULL,0,0,0,1),
(4,11,'12','Basic package',NULL,NULL,'<p>Offer description</p>\r\n<p> </p>','<ul>\r\n<li>2x overnight stay</li>\r\n<li>2x breakfast buffet</li>\r\n<li>1x culinary 3-course dinner</li>\r\n</ul>','',1,2,0,1,1,1,1,1,1,1,'2012-03-20','2015-07-31','2012-03-01','2015-08-31',10,127,7.50,10.00,1,0,NULL,NULL,0,NULL,0,0,0,1),
(7,5,'','Visit Paris',NULL,NULL,'<p>Visit Paris</p>','<p>Visit Paris</p>','',1,10,0,1,1,1,1,1,1,1,'2012-04-01','2017-07-31','2012-04-01','2021-07-30',10,127,7.50,5.00,1,0,NULL,NULL,0,NULL,0,0,0,1),
(8,5,'paris','Live in Paris',NULL,NULL,'<p>Live in Paris for one week</p>','<p>Live in Paris for one week</p>','',1,10,0,1,1,1,1,0,0,0,'2012-04-01','2016-07-29','2012-04-01','2017-04-27',0,127,0.00,0.00,1,0,NULL,NULL,0,NULL,0,0,0,1);

--
-- Table structure for table `n36ic_hotelreservation_offers_excursions`
--

CREATE TABLE `n36ic_hotelreservation_offers_excursions` (
  `offer_excursion_id` int(10) NOT NULL AUTO_INCREMENT,
  `offer_id` int(10) NOT NULL DEFAULT 0,
  `excursion_id` int(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`offer_excursion_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_offers_excursions`
--


--
-- Table structure for table `n36ic_hotelreservation_offers_extra_options`
--

CREATE TABLE `n36ic_hotelreservation_offers_extra_options` (
  `extra_option_id` int(11) DEFAULT NULL,
  `offer_id` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_offers_extra_options`
--


--
-- Table structure for table `n36ic_hotelreservation_offers_pictures`
--

CREATE TABLE `n36ic_hotelreservation_offers_pictures` (
  `offer_picture_id` int(10) NOT NULL AUTO_INCREMENT,
  `offer_id` int(10) NOT NULL DEFAULT 0,
  `offer_picture_info` blob DEFAULT NULL,
  `offer_picture_path` blob DEFAULT NULL,
  `offer_picture_enable` tinyint(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`offer_picture_id`)
) ENGINE=MyISAM AUTO_INCREMENT=739 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `n36ic_hotelreservation_offers_pictures`
--


--
-- Table structure for table `n36ic_hotelreservation_offers_rate_prices`
--

CREATE TABLE `n36ic_hotelreservation_offers_rate_prices` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rate_id` int(11) NOT NULL DEFAULT 0,
  `date` date DEFAULT NULL,
  `price` decimal(12,2) DEFAULT NULL,
  `extra_pers_price` decimal(12,2) DEFAULT NULL,
  `child_price` decimal(12,2) DEFAULT NULL,
  `single_use_price` decimal(12,2) DEFAULT NULL,
  `min_days` tinyint(4) NOT NULL DEFAULT 1,
  `max_days` tinyint(4) NOT NULL DEFAULT 0,
  `lock_arrival` tinyint(4) NOT NULL DEFAULT 0,
  `lock_departure` tinyint(4) NOT NULL DEFAULT 0,
  `rate_closed` int(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  KEY `Index2` (`rate_id`,`date`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_offers_rate_prices`
--


--
-- Table structure for table `n36ic_hotelreservation_offers_rates`
--

CREATE TABLE `n36ic_hotelreservation_offers_rates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `offer_id` int(11) DEFAULT NULL,
  `room_id` int(11) DEFAULT NULL,
  `price_type` tinyint(4) NOT NULL DEFAULT 0,
  `price_type_day` tinyint(2) NOT NULL DEFAULT 0,
  `can_cancel` tinyint(4) NOT NULL DEFAULT 0,
  `cancel_days` tinyint(4) NOT NULL DEFAULT 0,
  `cancel_text` tinytext DEFAULT NULL,
  `price_1` decimal(12,2) NOT NULL DEFAULT 0.00,
  `price_2` decimal(12,2) NOT NULL DEFAULT 0.00,
  `price_3` decimal(12,2) NOT NULL DEFAULT 0.00,
  `price_4` decimal(12,2) NOT NULL DEFAULT 0.00,
  `price_5` decimal(12,2) NOT NULL DEFAULT 0.00,
  `price_6` decimal(12,2) NOT NULL DEFAULT 0.00,
  `price_7` decimal(12,2) NOT NULL DEFAULT 0.00,
  `child_price` decimal(12,2) NOT NULL DEFAULT 0.00,
  `single_balancing` decimal(12,2) NOT NULL DEFAULT 0.00,
  `extra_pers_price_1` decimal(12,2) NOT NULL DEFAULT 0.00,
  `extra_pers_price_2` decimal(12,2) NOT NULL DEFAULT 0.00,
  `extra_pers_price_3` decimal(12,2) NOT NULL DEFAULT 0.00,
  `extra_pers_price_4` decimal(12,2) NOT NULL DEFAULT 0.00,
  `extra_pers_price_5` decimal(12,2) NOT NULL DEFAULT 0.00,
  `extra_pers_price_6` decimal(12,2) NOT NULL DEFAULT 0.00,
  `extra_pers_price_7` decimal(12,2) NOT NULL DEFAULT 0.00,
  `base_adults` tinyint(4) NOT NULL DEFAULT 2,
  `base_children` tinyint(4) NOT NULL DEFAULT 0,
  `extra_night_price_1` decimal(12,2) NOT NULL DEFAULT 0.00,
  `extra_night_price_2` decimal(12,2) NOT NULL DEFAULT 0.00,
  `extra_night_price_3` decimal(12,2) NOT NULL DEFAULT 0.00,
  `extra_night_price_4` decimal(12,2) NOT NULL DEFAULT 0.00,
  `extra_night_price_5` decimal(12,2) NOT NULL DEFAULT 0.00,
  `extra_night_price_6` decimal(12,2) NOT NULL DEFAULT 0.00,
  `extra_night_price_7` decimal(12,2) NOT NULL DEFAULT 0.00,
  `single_use_price_1` decimal(12,2) NOT NULL DEFAULT 0.00,
  `single_use_price_2` decimal(12,2) NOT NULL DEFAULT 0.00,
  `single_use_price_3` decimal(12,2) NOT NULL DEFAULT 0.00,
  `single_use_price_4` decimal(12,2) NOT NULL DEFAULT 0.00,
  `single_use_price_5` decimal(12,2) NOT NULL DEFAULT 0.00,
  `single_use_price_6` decimal(12,2) NOT NULL DEFAULT 0.00,
  `single_use_price_7` decimal(12,2) NOT NULL DEFAULT 0.00,
  `extra_night_single_use_price_1` decimal(12,2) NOT NULL DEFAULT 0.00,
  `extra_night_single_use_price_2` decimal(12,2) NOT NULL DEFAULT 0.00,
  `extra_night_single_use_price_3` decimal(12,2) NOT NULL DEFAULT 0.00,
  `extra_night_single_use_price_4` decimal(12,2) NOT NULL DEFAULT 0.00,
  `extra_night_single_use_price_5` decimal(12,2) NOT NULL DEFAULT 0.00,
  `extra_night_single_use_price_6` decimal(12,2) NOT NULL DEFAULT 0.00,
  `extra_night_single_use_price_7` decimal(12,2) NOT NULL DEFAULT 0.00,
  `extra_night_board_type` tinyint(1) NOT NULL DEFAULT 0,
  `allow_rate_update` tinyint(1) NOT NULL DEFAULT 0,
  `calculate_single_rate` tinyint(1) NOT NULL DEFAULT 0,
  `single_price_update_type` tinyint(1) NOT NULL DEFAULT 0,
  `single_price_update` decimal(12,2) NOT NULL DEFAULT 0.00,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_offers_rates`
--

INSERT INTO `n36ic_hotelreservation_offers_rates` VALUES
(1,2,28,1,0,0,0,NULL,40.00,40.00,40.00,40.00,50.00,50.00,50.00,0.00,12.00,60.00,0.00,0.00,0.00,0.00,0.00,0.00,2,0,40.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0,0,0,0,0.00),
(2,4,28,1,0,0,0,NULL,30.00,30.00,30.00,30.00,30.00,40.00,40.00,0.00,12.00,60.00,0.00,0.00,0.00,0.00,0.00,0.00,2,0,20.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0,0,0,0,0.00),
(3,7,19,1,0,0,0,NULL,40.00,40.00,40.00,40.00,40.00,50.00,50.00,0.00,12.00,32.00,0.00,0.00,0.00,0.00,0.00,0.00,1,0,31.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0,0,0,0,0.00),
(4,8,19,1,0,0,0,NULL,20.00,20.00,20.00,20.00,20.00,20.00,20.00,0.00,12.00,20.00,0.00,0.00,0.00,0.00,0.00,0.00,1,0,20.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0,0,0,0,0.00),
(5,1,18,1,0,0,0,NULL,35.00,35.00,35.00,35.00,40.00,40.00,40.00,0.00,34.00,21.00,0.00,0.00,0.00,0.00,0.00,0.00,3,0,12.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0,0,0,0,0.00);

--
-- Table structure for table `n36ic_hotelreservation_offers_rooms`
--

CREATE TABLE `n36ic_hotelreservation_offers_rooms` (
  `offer_room_id` int(10) NOT NULL AUTO_INCREMENT,
  `offer_id` int(10) NOT NULL DEFAULT 0,
  `room_id` int(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`offer_room_id`),
  KEY `Index 2` (`offer_id`,`room_id`)
) ENGINE=MyISAM AUTO_INCREMENT=455 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `n36ic_hotelreservation_offers_rooms`
--

INSERT INTO `n36ic_hotelreservation_offers_rooms` VALUES
(450,1,18),
(453,2,28),
(63,3,28),
(454,4,28),
(295,5,28),
(407,6,28),
(408,6,29),
(451,7,19),
(452,8,19);

--
-- Table structure for table `n36ic_hotelreservation_offers_rooms_price`
--

CREATE TABLE `n36ic_hotelreservation_offers_rooms_price` (
  `offer_room_price_id` int(10) NOT NULL AUTO_INCREMENT,
  `offer_id` int(10) NOT NULL DEFAULT 0,
  `room_id` int(10) NOT NULL DEFAULT 0,
  `offer_room_price_type` tinyint(2) NOT NULL DEFAULT 1,
  `price_1` float NOT NULL DEFAULT 0,
  `price_2` float NOT NULL DEFAULT 0,
  `price_3` float NOT NULL DEFAULT 0,
  `price_4` float NOT NULL DEFAULT 0,
  `price_5` float NOT NULL DEFAULT 0,
  `price_6` float NOT NULL DEFAULT 0,
  `price_7` float NOT NULL DEFAULT 0,
  `week_types` char(255) NOT NULL DEFAULT '0,0,0,0,0,0,0',
  `single_supplement` float NOT NULL DEFAULT 0,
  `single_discount` float NOT NULL DEFAULT 0,
  `offer_pers_price` tinyint(1) NOT NULL DEFAULT 0,
  `offer_price_extranights` float(10,2) NOT NULL DEFAULT 0.00,
  `offer_price_type_extranights` char(1) NOT NULL DEFAULT '',
  PRIMARY KEY (`offer_room_price_id`),
  KEY `Index 2` (`offer_id`,`room_id`)
) ENGINE=MyISAM AUTO_INCREMENT=708 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `n36ic_hotelreservation_offers_rooms_price`
--

INSERT INTO `n36ic_hotelreservation_offers_rooms_price` VALUES
(690,6,29,2,110,100,110,110,110,110,110,'0,0,0,0,0,0,0',1,0,1,2.00,''),
(699,6,28,1,15,15,15,15,15,15,15,'0,0,0,0,0,0,0',12,0,1,11.00,''),
(700,2,28,1,90.5,90.5,90.5,90.5,90.5,90.5,90.5,'0,0,0,0,0,0,0',20,0,1,150.00,''),
(701,4,28,1,100.3,100.3,100.3,100.3,100.3,100.3,100.3,'0,0,0,0,0,0,0',30,0,1,120.00,''),
(702,1,18,1,65.5,65.5,65.5,65.5,65.5,65.5,65.5,'0,0,0,0,0,0,0',0,0,0,0.00,''),
(703,7,19,1,120,120,120,120,120,120,120,'0,0,0,0,0,0,0',160,0,0,150.00,''),
(704,7,20,1,0,0,0,0,0,0,0,'0,0,0,0,0,0,0',0,0,0,0.00,''),
(705,7,21,1,0,0,0,0,0,0,0,'0,0,0,0,0,0,0',0,0,0,0.00,''),
(706,7,22,1,0,0,0,0,0,0,0,'0,0,0,0,0,0,0',0,0,0,0.00,''),
(707,8,19,1,0,0,0,0,0,0,0,'0,0,0,0,0,0,0',0,0,0,0.00,'');

--
-- Table structure for table `n36ic_hotelreservation_offers_tags`
--

CREATE TABLE `n36ic_hotelreservation_offers_tags` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL DEFAULT '',
  `ordering` int(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`,`name`)
) ENGINE=MyISAM AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_offers_tags`
--


--
-- Table structure for table `n36ic_hotelreservation_offers_tags_relation`
--

CREATE TABLE `n36ic_hotelreservation_offers_tags_relation` (
  `offerId` int(11) NOT NULL DEFAULT 0,
  `tagId` int(5) NOT NULL DEFAULT 0,
  `ordering` tinyint(2) NOT NULL DEFAULT 0,
  PRIMARY KEY (`offerId`,`tagId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_offers_tags_relation`
--


--
-- Table structure for table `n36ic_hotelreservation_offers_themes`
--

CREATE TABLE `n36ic_hotelreservation_offers_themes` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`,`name`)
) ENGINE=MyISAM AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_offers_themes`
--

INSERT INTO `n36ic_hotelreservation_offers_themes` VALUES
(20,'theme1'),
(24,'theme5'),
(25,'Cycling'),
(26,'Walking'),
(27,'Walked'),
(28,'Forest'),
(29,'sdfs'),
(30,'Forest'),
(30,'Walking'),
(31,'sdfs'),
(32,'wass'),
(33,'Test');

--
-- Table structure for table `n36ic_hotelreservation_offers_themes_relation`
--

CREATE TABLE `n36ic_hotelreservation_offers_themes_relation` (
  `offerId` int(11) NOT NULL DEFAULT 0,
  `themeId` int(5) NOT NULL DEFAULT 0,
  PRIMARY KEY (`offerId`,`themeId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_offers_themes_relation`
--

INSERT INTO `n36ic_hotelreservation_offers_themes_relation` VALUES
(2,25),
(2,33);

--
-- Table structure for table `n36ic_hotelreservation_offers_views`
--

CREATE TABLE `n36ic_hotelreservation_offers_views` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `offer_id` int(11) NOT NULL DEFAULT 0,
  `view_count` int(11) NOT NULL DEFAULT 0,
  `media_referer` varchar(100) DEFAULT NULL,
  `voucher` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `offer` (`offer_id`,`media_referer`,`voucher`)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_offers_views`
--


--
-- Table structure for table `n36ic_hotelreservation_offers_vouchers`
--

CREATE TABLE `n36ic_hotelreservation_offers_vouchers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `offerId` int(11) DEFAULT NULL,
  `voucher` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `offerId_UNIQUE` (`offerId`,`voucher`)
) ENGINE=MyISAM AUTO_INCREMENT=40 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_offers_vouchers`
--


--
-- Table structure for table `n36ic_hotelreservation_opengds_res_mappings`
--

CREATE TABLE `n36ic_hotelreservation_opengds_res_mappings` (
  `confirmation_id` int(11) NOT NULL DEFAULT 0,
  `gds_confirmation_id` int(11) NOT NULL DEFAULT 0,
  `rate_id` int(11) NOT NULL DEFAULT 0,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `create_date` datetime DEFAULT NULL,
  PRIMARY KEY (`confirmation_id`,`gds_confirmation_id`,`rate_id`),
  UNIQUE KEY `confirmation_id` (`confirmation_id`,`rate_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_opengds_res_mappings`
--


--
-- Table structure for table `n36ic_hotelreservation_payment_processor_fields`
--

CREATE TABLE `n36ic_hotelreservation_payment_processor_fields` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `column_name` varchar(100) DEFAULT NULL,
  `column_value` varchar(255) DEFAULT NULL,
  `column_mode` tinyint(1) NOT NULL DEFAULT 0,
  `processor_id` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=71 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `n36ic_hotelreservation_payment_processor_fields`
--

INSERT INTO `n36ic_hotelreservation_payment_processor_fields` VALUES
(28,'paypal_email','info@cmsjunkie.com',0,1),
(27,'Name','Val',0,1),
(55,'bank_name','ABM',0,2),
(56,'bank_address','Street address',0,2),
(57,'bank_city','City',0,2),
(58,'bank_country','Country',0,2),
(59,'bank_holder_name','Holder Name',0,2),
(60,'bank_account_number','Account number',0,2),
(61,'iban','IBAN number',0,2),
(62,'swift_code','Swift code',0,2),
(63,'username','e213123',0,3),
(64,'transaction_key','32313',0,3),
(65,'SECRET_KEY','',0,5),
(66,'TRANSACTION_KEY','',0,5),
(67,'ENDPOINT_SECRET','',0,5),
(68,'SECRET_KEY','',1,5),
(69,'TRANSACTION_KEY','',1,5),
(70,'ENDPOINT_SECRET','',1,5);

--
