INSERT INTO `wp_posts` VALUES (286,1,'2016-03-10 14:40:52','2016-03-10 14:40:52','<iframe class=\"desktop-calculator\" style=\"width: 860px; height: 615px;\" src=\"http://www.visionabacus.com/Finance/Australia/1/SuiteA100/640/Loan-Repayment-Calculator.aspx?ID=VestaCapital\" width=\"860\" height=\"240\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"></iframe><br />\r\n\r\n<iframe class=\"mobile-calculator\" style=\"width: 100%; height: 650px;\" src=\"http://australia.visionabacus.com/Module48/SuiteA100/LoanRepaymentCalculator/VestaCapital\" frameborder=\"0\"></iframe>','Loan Repayment Calculator','','inherit','closed','closed','','54-revision-v1','','','2016-03-10 14:40:52','2016-03-10 14:40:52','',54,'http://www.vestacapital.com.au/54-revision-v1/',0,'revision','',0),(287,1,'2016-03-10 14:41:56','2016-03-10 14:41:56','<iframe class=\"desktop-calculator\" style=\"width: 860px; height: 615px;\" src=\"http://www.visionabacus.com/Finance/Australia/1/SuiteA100/640/Loan-Repayment-Calculator.aspx?ID=VestaCapital\" width=\"860\" height=\"240\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"></iframe><br />\r\n\r\n<iframe class=\"mobile-calculator\" style=\"width: 320px; height: 650px;\" src=\"http://australia.visionabacus.com/Module48/SuiteA100/LoanRepaymentCalculator/VestaCapital\" frameborder=\"0\"></iframe>','Loan Repayment Calculator','','inherit','closed','closed','','54-revision-v1','','','2016-03-10 14:41:56','2016-03-10 14:41:56','',54,'http://www.vestacapital.com.au/54-revision-v1/',0,'revision','',0),(288,1,'2016-03-10 14:42:53','2016-03-10 14:42:53','<iframe class=\"desktop-calculator\" style=\"width: 860px; height: 615px;\" src=\"http://www.visionabacus.com/Finance/Australia/1/SuiteA100/640/Loan-Repayment-Calculator.aspx?ID=VestaCapital\" width=\"860\" height=\"240\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"></iframe><br />\r\n\r\n<iframe class=\"mobile-calculator\" style=\"width: 320px; height: 650px;\" src=\"http://australia.visionabacus.com/Module48/SuiteA100/LoanRepaymentCalculator/VestaCapital\" frameborder=\"0\" width=\"100%\"></iframe>','Loan Repayment Calculator','','inherit','closed','closed','','54-revision-v1','','','2016-03-10 14:42:53','2016-03-10 14:42:53','',54,'http://www.vestacapital.com.au/54-revision-v1/',0,'revision','',0),(289,1,'2016-03-10 14:45:43','2016-03-10 14:45:43','/*\nWelcome to Custom CSS!\n\nTo learn how this works, see http://wp.me/PEmnE-Bt\n*/\n.desktop-calculator {\n	display: inline-block;\n}\n\n.mobile-calculator {\n	display: none;\n}\n\n@media (max-width: 1000px) {\n	.desktop-calculator {\n		display: none;\n	}\n	\n	.mobile-calculator {\n		display: inline-block;\n	}\n}\n\n/* #### Mobile Phones Portrait #### */\n@media screen and (max-device-width: 480px) and (orientation: portrait) {\n	/* some CSS here */\n	\n}\n\n/* #### Mobile Phones Landscape #### */\n@media screen and (max-device-width: 640px) and (orientation: landscape) {\n	/* some CSS here */\n	\n}\n\n/* #### Mobile Phones Portrait or Landscape #### */\n@media screen and (max-device-width: 640px) {\n	/* some CSS here */\n	\n}\n\n/* #### iPhone 4+ Portrait or Landscape #### */\n@media screen and (min-device-width: 320px) and (-webkit-min-device-pixel-ratio: 2) {\n	/* some CSS here */\n	\n}\n\n/* #### iPhone 5 Portrait or Landscape #### */\n@media (device-height: 568px) and (device-width: 320px) and (-webkit-min-device-pixel-ratio: 2) {\n	/* some CSS here */\n	\n}\n\n/* #### iPhone 6 and 6 plus Portrait or Landscape #### */\n@media (min-device-height: 667px) and (min-device-width: 375px) and (-webkit-min-device-pixel-ratio: 3) {\n	/* some CSS here */\n	\n}\n\n/* #### Tablets Portrait or Landscape #### */\n@media screen and (min-device-width: 768px) and (max-device-width: 1024px) {\n	/* some CSS here */\n	\n}\n\n/* #### Desktops #### */\n@media screen and (min-width: 1024px) {\n	/* some CSS here */\n	\n}','safecss','Zerif PRO','inherit','closed','closed','','209-revision-v1','','','2016-03-10 14:45:43','2016-03-10 14:45:43','',209,'http://www.vestacapital.com.au/209-revision-v1/',0,'revision','',0),(290,1,'2016-03-11 03:35:32','2016-03-11 03:35:32','[WPL]','Properties','','publish','closed','closed','','properties','','','2016-03-11 03:35:32','2016-03-11 03:35:32','',0,'http://www.vestacapital.com.au/properties/',0,'page','',0),(291,1,'2016-03-11 03:35:32','2016-03-11 03:35:32','[WPL sf_select_listing=\"9\"]','For Sale','','publish','closed','closed','','for-sale','','','2016-03-11 03:35:32','2016-03-11 03:35:32','',0,'http://www.vestacapital.com.au/for-sale/',0,'page','',0),(292,1,'2016-03-11 03:35:32','2016-03-11 03:35:32','[WPL sf_select_listing=\"10\"]','For Rent','','publish','closed','closed','','for-rent','','','2016-03-11 03:35:32','2016-03-11 03:35:32','',0,'http://www.vestacapital.com.au/for-rent/',0,'page','',0),(293,1,'2016-03-11 03:35:32','2016-03-11 03:35:32','[WPL sf_select_listing=\"12\"]','Vacation Rental','','publish','closed','closed','','vacation-rental','','','2016-03-11 03:35:32','2016-03-11 03:35:32','',0,'http://www.vestacapital.com.au/vacation-rental/',0,'page','',0),(294,1,'2016-03-11 04:20:31','2016-03-11 04:20:31','<iframe class=\"desktop-calculator\" style=\"width: 860px; height: 615px;\" src=\"http://www.visionabacus.com/Finance/Australia/1/SuiteA100/640/Loan-Repayment-Calculator.aspx?ID=VestaCapital\" width=\"860\" height=\"240\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"></iframe><br />\r\n\r\n<iframe class=\"mobile-calculator\" style=\"width: 100%; height: 650px;\" src=\"http://australia.visionabacus.com/Module48/SuiteA100/LoanRepaymentCalculator/VestaCapital\" frameborder=\"0\" width=\"100%\" height=\"650px\"></iframe>','Loan Repayment Calculator','','inherit','closed','closed','','54-revision-v1','','','2016-03-11 04:20:31','2016-03-11 04:20:31','',54,'http://www.vestacapital.com.au/54-revision-v1/',0,'revision','',0),(295,1,'2016-03-11 04:24:45','2016-03-11 04:24:45','/*\nWelcome to Custom CSS!\n\nTo learn how this works, see http://wp.me/PEmnE-Bt\n*/\n.desktop-calculator {\n	display: inline-block;\n}\n\n.mobile-calculator {\n	display: none;\n}\n\n@media (max-width: 1000px) {\n	.desktop-calculator {\n		display: none;\n	}\n	\n	.mobile-calculator {\n		display: inline-block;\n	}\n}\n\n/* #### Mobile Phones Portrait #### */\n@media screen and (max-device-width: 480px) and (orientation: portrait) {\n	/* some CSS here */\n	.mobile-calculator {\n		display: inline-block;\n	}\n}\n\n	\n}\n\n/* #### Mobile Phones Landscape #### */\n@media screen and (max-device-width: 640px) and (orientation: landscape) {\n	/* some CSS here */\n	\n}\n\n/* #### Mobile Phones Portrait or Landscape #### */\n@media screen and (max-device-width: 640px) {\n	/* some CSS here */\n	\n}\n\n/* #### iPhone 4+ Portrait or Landscape #### */\n@media screen and (min-device-width: 320px) and (-webkit-min-device-pixel-ratio: 2) {\n	/* some CSS here */\n	.mobile-calculator {\n		display: inline-block;\n	}\n}\n\n	\n}\n\n/* #### iPhone 5 Portrait or Landscape #### */\n@media (device-height: 568px) and (device-width: 320px) and (-webkit-min-device-pixel-ratio: 2) {\n	/* some CSS here */\n	\n}\n\n/* #### iPhone 6 and 6 plus Portrait or Landscape #### */\n@media (min-device-height: 667px) and (min-device-width: 375px) and (-webkit-min-device-pixel-ratio: 3) {\n	/* some CSS here */\n	\n}\n\n/* #### Tablets Portrait or Landscape #### */\n@media screen and (min-device-width: 768px) and (max-device-width: 1024px) {\n	/* some CSS here */\n	\n}\n\n/* #### Desktops #### */\n@media screen and (min-width: 1024px) {\n	/* some CSS here */\n	\n}','safecss','Zerif PRO','inherit','closed','closed','','209-revision-v1','','','2016-03-11 04:24:45','2016-03-11 04:24:45','',209,'http://www.vestacapital.com.au/209-revision-v1/',0,'revision','',0),(296,1,'2016-03-11 04:27:06','2016-03-11 04:27:06','/*\nWelcome to Custom CSS!\n\nTo learn how this works, see http://wp.me/PEmnE-Bt\n*/\n.desktop-calculator {\n	display: inline-block;\n}\n\n.mobile-calculator {\n	display: none;\n}\n\n@media (max-width: 1000px) {\n	.desktop-calculator {\n		display: none;\n	}\n}\n\n/* #### Mobile Phones Portrait #### */\n@media screen and (max-device-width: 480px) and (orientation: portrait) {\n	/* some CSS here */\n	.mobile-calculator {\n		display: inline-block;\n	}\n}\n\n	\n}\n\n/* #### Mobile Phones Landscape #### */\n@media screen and (max-device-width: 640px) and (orientation: landscape) {\n	/* some CSS here */\n	\n}\n\n/* #### Mobile Phones Portrait or Landscape #### */\n@media screen and (max-device-width: 640px) {\n	/* some CSS here */\n	\n}\n\n/* #### iPhone 4+ Portrait or Landscape #### */\n@media screen and (min-device-width: 320px) and (-webkit-min-device-pixel-ratio: 2) {\n	/* some CSS here */\n	.mobile-calculator {\n		display: inline-block;\n	}\n}\n\n	\n}\n\n/* #### iPhone 5 Portrait or Landscape #### */\n@media (device-height: 568px) and (device-width: 320px) and (-webkit-min-device-pixel-ratio: 2) {\n	/* some CSS here */\n	\n}\n\n/* #### iPhone 6 and 6 plus Portrait or Landscape #### */\n@media (min-device-height: 667px) and (min-device-width: 375px) and (-webkit-min-device-pixel-ratio: 3) {\n	/* some CSS here */\n	\n}\n\n/* #### Tablets Portrait or Landscape #### */\n@media screen and (min-device-width: 768px) and (max-device-width: 1024px) {\n	/* some CSS here */\n	\n}\n\n/* #### Desktops #### */\n@media screen and (min-width: 1024px) {\n	/* some CSS here */\n	\n}','safecss','Zerif PRO','inherit','closed','closed','','209-revision-v1','','','2016-03-11 04:27:06','2016-03-11 04:27:06','',209,'http://www.vestacapital.com.au/209-revision-v1/',0,'revision','',0),(298,1,'2016-03-11 04:43:38','2016-03-11 04:43:38','','Working-Men-Money-Growth','','inherit','closed','closed','','working-men-money-growth','','','2016-03-11 04:43:38','2016-03-11 04:43:38','',0,'http://www.vestacapital.com.au/wp-content/uploads/2016/03/Working-Men-Money-Growth.jpg',0,'attachment','image/jpeg',0),(299,1,'2016-03-11 04:55:02','2016-03-11 04:55:02','','Investment Growth','','inherit','closed','closed','','investment','','','2016-03-11 04:55:13','2016-03-11 04:55:13','',0,'http://www.vestacapital.com.au/wp-content/uploads/2016/03/Investment.jpg',0,'attachment','image/jpeg',0),(305,1,'2016-03-11 05:06:21','2016-03-11 05:06:21','','Trade Finance','','inherit','closed','closed','','tradefinance2','','','2016-03-11 05:06:30','2016-03-11 05:06:30','',0,'http://www.vestacapital.com.au/wp-content/uploads/2016/03/tradefinance2.jpg',0,'attachment','image/jpeg',0),(306,1,'2016-03-11 05:20:47','2016-03-11 05:20:47','','Future','','inherit','closed','closed','','future','','','2016-03-11 05:21:12','2016-03-11 05:21:12','',0,'http://www.vestacapital.com.au/wp-content/uploads/2016/03/future.jpg',0,'attachment','image/jpeg',0),(307,1,'2016-03-11 18:31:46','0000-00-00 00:00:00','','Auto Draft','','auto-draft','closed','open','','','','','2016-03-11 18:31:46','0000-00-00 00:00:00','',0,'http://www.vestacapital.com.au/?p=307',0,'post','',0),(308,1,'2016-03-12 11:51:05','2016-03-12 11:51:05','<script type=\"text/javascript\" src=\"https://forms.zohopublic.com/damiennguwen/form/ClientDetails/jsperma/0dH2GF3f2614j60014afjjd2H\" id=\"ZFScript\"></script>','Contact Us','','inherit','closed','closed','','242-revision-v1','','','2016-03-12 11:51:05','2016-03-12 11:51:05','',242,'http://www.vestacapital.com.au/242-revision-v1/',0,'revision','',0),(309,1,'2016-03-12 11:54:18','2016-03-12 11:54:18','<iframe frameborder=\"0\" style=\"position:absolute;height:100%;width:99%;border:none;\" src=\'https://forms.zohopublic.com/damiennguwen/form/ClientDetails/formperma/0dH2GF3f2614j60014afjjd2H\'/>','Contact Us','','inherit','closed','closed','','242-revision-v1','','','2016-03-12 11:54:18','2016-03-12 11:54:18','',242,'http://www.vestacapital.com.au/242-revision-v1/',0,'revision','',0),(310,1,'2016-03-12 11:56:47','2016-03-12 11:56:47','<iframe frameborder=\"0\" style=\"position:relative;height:100%;width:99%;border:none;\" src=\'https://forms.zohopublic.com/damiennguwen/form/ClientDetails/formperma/0dH2GF3f2614j60014afjjd2H\'/>','Contact Us','','inherit','closed','closed','','242-revision-v1','','','2016-03-12 11:56:47','2016-03-12 11:56:47','',242,'http://www.vestacapital.com.au/242-revision-v1/',0,'revision','',0),(311,1,'2016-03-12 11:57:41','2016-03-12 11:57:41','<iframe frameborder=\"0\" style=\"height:100%;width:99%;border:none;\" src=\'https://forms.zohopublic.com/damiennguwen/form/ClientDetails/formperma/0dH2GF3f2614j60014afjjd2H\'/>','Contact Us','','inherit','closed','closed','','242-revision-v1','','','2016-03-12 11:57:41','2016-03-12 11:57:41','',242,'http://www.vestacapital.com.au/242-revision-v1/',0,'revision','',0),(312,1,'2016-03-12 11:59:07','2016-03-12 11:59:07','<iframe frameborder=\"0\"  src=\'https://forms.zohopublic.com/damiennguwen/form/ClientDetails/formperma/0dH2GF3f2614j60014afjjd2H\'/>','Contact Us','','inherit','closed','closed','','242-revision-v1','','','2016-03-12 11:59:07','2016-03-12 11:59:07','',242,'http://www.vestacapital.com.au/242-revision-v1/',0,'revision','',0),(313,1,'2016-03-12 12:18:13','2016-03-12 12:18:13','[iframe frameborder=\"0\"  src=\'https://forms.zohopublic.com/damiennguwen/form/ClientDetails/formperma/0dH2GF3f2614j60014afjjd2H\']','Contact Us','','inherit','closed','closed','','242-revision-v1','','','2016-03-12 12:18:13','2016-03-12 12:18:13','',242,'http://www.vestacapital.com.au/242-revision-v1/',0,'revision','',0),(314,1,'2016-03-13 04:24:23','2016-03-13 04:24:23','','Damien Nguyen Profile','Damien Nguyen - Vesta Capital','inherit','closed','closed','','image-3','','','2016-03-13 04:36:29','2016-03-13 04:36:29','',0,'http://www.vestacapital.com.au/wp-content/uploads/2016/03/image.png',0,'attachment','image/png',0),(315,1,'2016-03-13 05:16:57','2016-03-13 05:16:57','','Headshot Silhoutte','','inherit','closed','closed','','image-5','','','2016-03-13 05:18:31','2016-03-13 05:18:31','',0,'http://www.vestacapital.com.au/wp-content/uploads/2016/03/image-1.png',0,'attachment','image/png',0),(316,1,'2016-03-13 11:48:47','2016-03-13 11:48:47','<strong><span style=\"color: #000000;\">Vesta Capital</span></strong> is always looking for like minded strategic partners such as accountants, real estate agents, lawyers &amp; solicitors, community groups, car dealerships and any other business that can benefit from our services.\r\n\r\n<span style=\"text-decoration: underline; color: #ff6600;\"><strong>Benefits to Partners</strong></span>\r\n<ul>\r\n	<li>A dedicated advisor to service your client</li>\r\n	<li>A full suite of lenders available</li>\r\n	<li>A network of professional services to look after other areas of your clients needs</li>\r\n	<li>Earn extra income</li>\r\n</ul>\r\nIf you would like more information, please fill the enquiry form below.\r\n\r\n<script src=\'https://crm.zoho.com/crm/WebFormServeServlet?rid=d68ebb69fcda42c9b29cf9dbe32225f80d863d2ad48e9a0fbfc9b95ecfac0f26gidee51932afb05ed16952ffffea8cf063dec8979d42e44a6273c30fdddc2514039&script=$sYG\'></script>\r\n\r\n&nbsp;','Become A Partner','','inherit','closed','closed','','272-revision-v1','','','2016-03-13 11:48:47','2016-03-13 11:48:47','',272,'http://www.vestacapital.com.au/272-revision-v1/',0,'revision','',0),(317,1,'2016-03-14 08:20:57','2016-03-14 08:20:57','','safecss','ZerifProChild','inherit','closed','closed','','209-revision-v1','','','2016-03-14 08:20:57','2016-03-14 08:20:57','',209,'http://www.vestacapital.com.au/209-revision-v1/',0,'revision','',0),(318,1,'2016-03-14 08:33:06','2016-03-14 08:33:06','','safecss','Zerif PRO','inherit','closed','closed','','209-revision-v1','','','2016-03-14 08:33:06','2016-03-14 08:33:06','',209,'http://www.vestacapital.com.au/209-revision-v1/',0,'revision','',0),(319,1,'2016-03-14 08:34:12','2016-03-14 08:34:12','','safecss','ZerifProChild','inherit','closed','closed','','209-revision-v1','','','2016-03-14 08:34:12','2016-03-14 08:34:12','',209,'http://www.vestacapital.com.au/209-revision-v1/',0,'revision','',0),(320,1,'2016-03-14 10:18:15','2016-03-14 10:18:15','','safecss','Zerif PRO','inherit','closed','closed','','209-revision-v1','','','2016-03-14 10:18:15','2016-03-14 10:18:15','',209,'http://www.vestacapital.com.au/209-revision-v1/',0,'revision','',0),(321,1,'2016-03-14 10:23:01','2016-03-14 10:23:01','','safecss','Twenty Fifteen','inherit','closed','closed','','209-revision-v1','','','2016-03-14 10:23:01','2016-03-14 10:23:01','',209,'http://www.vestacapital.com.au/209-revision-v1/',0,'revision','',0),(322,1,'2016-03-14 10:25:09','2016-03-14 10:25:09','','safecss','ZerifProChild','inherit','closed','closed','','209-revision-v1','','','2016-03-14 10:25:09','2016-03-14 10:25:09','',209,'http://www.vestacapital.com.au/209-revision-v1/',0,'revision','',0),(323,1,'2016-03-14 10:31:35','2016-03-14 10:31:35','','safecss','Zerif PRO','inherit','closed','closed','','209-revision-v1','','','2016-03-14 10:31:35','2016-03-14 10:31:35','',209,'http://www.vestacapital.com.au/209-revision-v1/',0,'revision','',0),(324,1,'2016-03-14 10:36:33','2016-03-14 10:36:33','','safecss','Twenty Fifteen','inherit','closed','closed','','209-revision-v1','','','2016-03-14 10:36:33','2016-03-14 10:36:33','',209,'http://www.vestacapital.com.au/209-revision-v1/',0,'revision','',0),(325,1,'2016-03-14 10:37:13','2016-03-14 10:37:13','','safecss','Zerif PRO','inherit','closed','closed','','209-revision-v1','','','2016-03-14 10:37:13','2016-03-14 10:37:13','',209,'http://www.vestacapital.com.au/209-revision-v1/',0,'revision','',0),(326,1,'2016-03-14 10:38:04','2016-03-14 10:38:04','','safecss','Twenty Fifteen','inherit','closed','closed','','209-revision-v1','','','2016-03-14 10:38:04','2016-03-14 10:38:04','',209,'http://www.vestacapital.com.au/209-revision-v1/',0,'revision','',0),(327,1,'2016-03-14 10:38:37','2016-03-14 10:38:37','','safecss','ZerifProChild','inherit','closed','closed','','209-revision-v1','','','2016-03-14 10:38:37','2016-03-14 10:38:37','',209,'http://www.vestacapital.com.au/209-revision-v1/',0,'revision','',0),(328,1,'2016-03-14 21:00:23','2016-03-14 11:00:23','','safecss','Twenty Fifteen','inherit','closed','closed','','209-revision-v1','','','2016-03-14 21:00:23','2016-03-14 11:00:23','',209,'http://www.vestacapital.com.au/209-revision-v1/',0,'revision','',0),(329,1,'2016-03-14 21:00:50','2016-03-14 11:00:50','','safecss','Zerif PRO','inherit','closed','closed','','209-revision-v1','','','2016-03-14 21:00:50','2016-03-14 11:00:50','',209,'http://www.vestacapital.com.au/209-revision-v1/',0,'revision','',0),(330,1,'2016-03-14 21:34:31','2016-03-14 11:34:31','','safecss','Twenty Fifteen','inherit','closed','closed','','209-revision-v1','','','2016-03-14 21:34:31','2016-03-14 11:34:31','',209,'http://www.vestacapital.com.au/209-revision-v1/',0,'revision','',0),(331,1,'2016-03-14 21:44:54','2016-03-14 11:44:54','','safecss','Zerif PRO','inherit','closed','closed','','209-revision-v1','','','2016-03-14 21:44:54','2016-03-14 11:44:54','',209,'http://www.vestacapital.com.au/209-revision-v1/',0,'revision','',0),(332,1,'2016-03-14 21:58:37','2016-03-14 11:58:37','','safecss','Zerif Pro Child','inherit','closed','closed','','209-revision-v1','','','2016-03-14 21:58:37','2016-03-14 11:58:37','',209,'http://www.vestacapital.com.au/209-revision-v1/',0,'revision','',0),(333,1,'2016-03-14 22:16:43','2016-03-14 12:16:43','','safecss','ZerifProChild','inherit','closed','closed','','209-revision-v1','','','2016-03-14 22:16:43','2016-03-14 12:16:43','',209,'http://www.vestacapital.com.au/209-revision-v1/',0,'revision','',0),(334,1,'2016-03-14 22:18:49','2016-03-14 12:18:49','','safecss','Zerif Pro Child','inherit','closed','closed','','209-revision-v1','','','2016-03-14 22:18:49','2016-03-14 12:18:49','',209,'http://www.vestacapital.com.au/209-revision-v1/',0,'revision','',0);
CREATE TABLE `wp_term_relationships` (
  `object_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `term_taxonomy_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `term_order` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`object_id`,`term_taxonomy_id`),
  KEY `term_taxonomy_id` (`term_taxonomy_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `wp_term_relationships` VALUES (1,1,0),(1,2,0),(2,2,0),(3,2,0),(4,2,0),(5,2,0),(6,2,0),(7,2,0),(8,2,0),(23,1,0),(59,4,0),(60,4,0),(61,4,0),(62,4,0),(71,4,0),(91,1,0),(266,4,0),(274,4,0);
CREATE TABLE `wp_term_taxonomy` (
  `term_taxonomy_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `term_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `taxonomy` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `description` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `parent` bigint(20) unsigned NOT NULL DEFAULT '0',
  `count` bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`term_taxonomy_id`),
  UNIQUE KEY `term_id_taxonomy` (`term_id`,`taxonomy`),
  KEY `taxonomy` (`taxonomy`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
INSERT INTO `wp_term_taxonomy` VALUES (1,1,'category','',0,0),(2,2,'link_category','',0,8),(3,3,'wplss_logo_showcase_cat','Lender Panel',0,0),(4,4,'nav_menu','',0,7);
CREATE TABLE `wp_termmeta` (
  `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `term_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `meta_key` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_value` longtext COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`meta_id`),
  KEY `term_id` (`term_id`),
  KEY `meta_key` (`meta_key`(191))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `wp_terms` (
  `term_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `slug` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `term_group` bigint(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`term_id`),
  KEY `slug` (`slug`(191)),
  KEY `name` (`name`(191))
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
INSERT INTO `wp_terms` VALUES (1,'Uncategorized','uncategorized',0),(2,'Blogroll','blogroll',0),(3,'Banks','banks',0),(4,'Main Menu','main-menu',0);
CREATE TABLE `wp_usermeta` (
  `umeta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `meta_key` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_value` longtext COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`umeta_id`),
  KEY `user_id` (`user_id`),
  KEY `meta_key` (`meta_key`(191))
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
INSERT INTO `wp_usermeta` VALUES (1,1,'first_name',''),(2,1,'last_name',''),(3,1,'nickname','admin'),(4,1,'description',''),(5,1,'rich_editing','true'),(6,1,'comment_shortcuts','false'),(7,1,'admin_color','fresh'),(8,1,'use_ssl','0'),(9,1,'aim',''),(10,1,'yim',''),(11,1,'jabber',''),(12,1,'wp_capabilities','a:1:{s:13:\"administrator\";s:1:\"1\";}'),(13,1,'wp_user_level','10'),(14,1,'session_tokens','a:22:{s:64:\"ba23fa9aebacb76ca2939c60f1afbbb016cf0c1db93004d0821e7423a2f1fb7a\";a:4:{s:10:\"expiration\";i:1458033822;s:2:\"ip\";s:12:\"49.195.3.155\";s:2:\"ua\";s:124:\"Mozilla/5.0 (iPad; CPU OS 9_0 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13A344 Safari/601.1\";s:5:\"login\";i:1456824222;}s:64:\"712bc2233bf3ca785d6b6ddd24c2c66995d124158339c0808c74a6ff5ef42b0f\";a:4:{s:10:\"expiration\";i:1458044144;s:2:\"ip\";s:15:\"120.152.131.250\";s:2:\"ua\";s:66:\"Mozilla/5.0 (Windows NT 10.0; rv:44.0) Gecko/20100101 Firefox/44.0\";s:5:\"login\";i:1456834544;}s:64:\"284f5d3f7e0e97bffb2557b9f8322f39f43b046ab74c22f140ddc763b5403d2b\";a:4:{s:10:\"expiration\";i:1458073556;s:2:\"ip\";s:15:\"120.152.131.250\";s:2:\"ua\";s:140:\"Mozilla/5.0 (iPhone; CPU iPhone OS 9_2 like Mac OS X) AppleWebKit/601.1 (KHTML, like Gecko) CriOS/47.0.2526.107 Mobile/13C75 Safari/601.1.46\";s:5:\"login\";i:1456863956;}s:64:\"e1fd297af2f8b1e3f03d33ba5d5151f4e90fd6d791f9bad74121f4c9eade74f6\";a:4:{s:10:\"expiration\";i:1458203702;s:2:\"ip\";s:15:\"120.152.131.250\";s:2:\"ua\";s:132:\"Mozilla/5.0 (iPad; CPU OS 9_0 like Mac OS X) AppleWebKit/601.1 (KHTML, like Gecko) CriOS/48.0.2564.104 Mobile/13A344 Safari/601.1.46\";s:5:\"login\";i:1456994102;}s:64:\"73822c1e6054c566c3f56c76fd91b299a0322bcd5508b80e61422f279d6b8d30\";a:4:{s:10:\"expiration\";i:1458881542;s:2:\"ip\";s:15:\"120.152.131.250\";s:2:\"ua\";s:103:\"Mozilla/5.0 (Windows NT 10.0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/48.0.2564.116 Safari/537.36\";s:5:\"login\";i:1457671942;}s:64:\"64b27a065fffc8f438889b825210f3e51f3d6a27c9bbdb47c3e3b5b0344e9b87\";a:4:{s:10:\"expiration\";i:1458882013;s:2:\"ip\";s:15:\"120.152.131.250\";s:2:\"ua\";s:117:\"Mozilla/5.0 (Windows NT 10.0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/42.0.2311.135 Safari/537.36 Edge/12.10240\";s:5:\"login\";i:1457672413;}s:64:\"feefc0d141907d65587b0c15965f44421cec31d8f9fa0ea59682b3eb51fe8069\";a:4:{s:10:\"expiration\";i:1458882488;s:2:\"ip\";s:15:\"120.152.131.250\";s:2:\"ua\";s:66:\"Mozilla/5.0 (Windows NT 10.0; rv:44.0) Gecko/20100101 Firefox/44.0\";s:5:\"login\";i:1457672888;}s:64:\"510b23147b2fd98c6c40e73112bace1f9dd2fb7e53cdad82413d06c41e756997\";a:4:{s:10:\"expiration\";i:1458024989;s:2:\"ip\";s:13:\"49.14.100.128\";s:2:\"ua\";s:72:\"Mozilla/5.0 (Windows NT 6.3; WOW64; rv:44.0) Gecko/20100101 Firefox/44.0\";s:5:\"login\";i:1457852189;}s:64:\"b70ab282e6993ff3839563db412a70d30fcb9d15c78cb439e651237beef1e8f1\";a:4:{s:10:\"expiration\";i:1458036208;s:2:\"ip\";s:12:\"106.67.49.67\";s:2:\"ua\";s:72:\"Mozilla/5.0 (Windows NT 6.3; WOW64; rv:44.0) Gecko/20100101 Firefox/44.0\";s:5:\"login\";i:1457863408;}s:64:\"61171b46b3f995aa611529a923681e6e4ad647dda2e830ea76fde393272f01b8\";a:4:{s:10:\"expiration\";i:1458054694;s:2:\"ip\";s:13:\"106.67.69.102\";s:2:\"ua\";s:72:\"Mozilla/5.0 (Windows NT 6.3; WOW64; rv:44.0) Gecko/20100101 Firefox/44.0\";s:5:\"login\";i:1457881894;}s:64:\"7ddc4d01cb8d3065d457dfcb3da27ba634315bd5110d692f383100528ae4780c\";a:4:{s:10:\"expiration\";i:1458089250;s:2:\"ip\";s:12:\"1.187.178.85\";s:2:\"ua\";s:72:\"Mozilla/5.0 (Windows NT 6.3; WOW64; rv:44.0) Gecko/20100101 Firefox/44.0\";s:5:\"login\";i:1457916450;}s:64:\"a3e30308fc24c09723c09e4655f1ce0d2d91c411103b09d1cf9afe5c3edc72c8\";a:4:{s:10:\"expiration\";i:1459145301;s:2:\"ip\";s:15:\"101.191.194.211\";s:2:\"ua\";s:125:\"Mozilla/5.0 (iPad; CPU OS 8_4 like Mac OS X) AppleWebKit/600.1.4 (KHTML, like Gecko) Version/8.0 Mobile/12H143 Safari/600.1.4\";s:5:\"login\";i:1457935701;}s:64:\"6cc029efd3ddbb9ef0f33da1f3b63f5fcd1dcd69856a5909f8ef89af89c1c2bc\";a:4:{s:10:\"expiration\";i:1458108581;s:2:\"ip\";s:12:\"103.36.78.83\";s:2:\"ua\";s:109:\"Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/48.0.2564.116 Safari/537.36\";s:5:\"login\";i:1457935781;}s:64:\"8313e8d57e1cf130ab1d48e65f6ba09059203fe45045de9b72aa9c9ea27c4dd8\";a:4:{s:10:\"expiration\";i:1458108856;s:2:\"ip\";s:12:\"103.36.78.83\";s:2:\"ua\";s:72:\"Mozilla/5.0 (Windows NT 6.3; WOW64; rv:44.0) Gecko/20100101 Firefox/44.0\";s:5:\"login\";i:1457936056;}s:64:\"4bb31f60686eb272ce101d7613dfb38e656ad4d4bb5a765fc3fe46ea68b89dc5\";a:4:{s:10:\"expiration\";i:1458109279;s:2:\"ip\";s:12:\"103.36.78.83\";s:2:\"ua\";s:72:\"Mozilla/5.0 (Windows NT 6.3; WOW64; rv:44.0) Gecko/20100101 Firefox/44.0\";s:5:\"login\";i:1457936479;}s:64:\"53f8f9a3bdec68ff5b9220d492c0a427794229222320c4c39ac275b2e8276d78\";a:4:{s:10:\"expiration\";i:1458109810;s:2:\"ip\";s:12:\"103.36.78.83\";s:2:\"ua\";s:72:\"Mozilla/5.0 (Windows NT 6.3; WOW64; rv:44.0) Gecko/20100101 Firefox/44.0\";s:5:\"login\";i:1457937010;}s:64:\"ad581a703d1de8ab29c567a1d74b21c07c0d4ac1e0a8286484fd8733844b3c09\";a:4:{s:10:\"expiration\";i:1458114264;s:2:\"ip\";s:12:\"103.36.78.83\";s:2:\"ua\";s:72:\"Mozilla/5.0 (Windows NT 6.3; WOW64; rv:44.0) Gecko/20100101 Firefox/44.0\";s:5:\"login\";i:1457941464;}s:64:\"21db0e6442bda600fa1cb9b105023f63f19596e3d530f3a767060c432d7e3491\";a:4:{s:10:\"expiration\";i:1458116213;s:2:\"ip\";s:14:\"101.191.233.24\";s:2:\"ua\";s:131:\"Mozilla/5.0 (iPad; CPU OS 9_0 like Mac OS X) AppleWebKit/601.1 (KHTML, like Gecko) CriOS/49.0.2623.73 Mobile/13A344 Safari/601.1.46\";s:5:\"login\";i:1457943413;}s:64:\"19406398e6e60adf86e4dc3dc54e41751a31a2d90e6f7c3bdbd4c326fbdb337b\";a:4:{s:10:\"expiration\";i:1458119030;s:2:\"ip\";s:14:\"101.191.233.24\";s:2:\"ua\";s:140:\"Mozilla/5.0 (iPhone; CPU iPhone OS 9_2 like Mac OS X) AppleWebKit/601.1 (KHTML, like Gecko) CriOS/48.0.2564.104 Mobile/13C75 Safari/601.1.46\";s:5:\"login\";i:1457946230;}s:64:\"f56855595b45af3ca978a663ec9bfd9db71dea9351a814826f9d748012f2b132\";a:4:{s:10:\"expiration\";i:1458122983;s:2:\"ip\";s:14:\"101.191.233.24\";s:2:\"ua\";s:72:\"Mozilla/5.0 (Windows NT 6.3; WOW64; rv:43.0) Gecko/20100101 Firefox/43.0\";s:5:\"login\";i:1457950183;}s:64:\"bc253850c5f4e30134c5595eb2c0868915f4c2ee22932991f3dd08ffcc7db313\";a:4:{s:10:\"expiration\";i:1458122993;s:2:\"ip\";s:14:\"101.191.233.24\";s:2:\"ua\";s:72:\"Mozilla/5.0 (Windows NT 6.3; WOW64; rv:43.0) Gecko/20100101 Firefox/43.0\";s:5:\"login\";i:1457950193;}s:64:\"5a67954dcbf30f67c9f053f8bd14cf94ec6b797c0c77dc850441762e69c72e4e\";a:4:{s:10:\"expiration\";i:1458126865;s:2:\"ip\";s:14:\"101.191.233.24\";s:2:\"ua\";s:66:\"Mozilla/5.0 (Windows NT 10.0; rv:44.0) Gecko/20100101 Firefox/44.0\";s:5:\"login\";i:1457954065;}}'),(15,1,'wp_user-settings','editor=html&editor_expand=on&libraryContent=browse&siteorigin_settings_tab=0&mfold=o&imgsize=zerifourfocus&align=center&urlbutton=file&hidetb=1&widgets_access=off'),(16,1,'wp_user-settings-time','1457957770'),(17,1,'wp_dashboard_quick_press_last_post_id','307'),(18,1,'wporg_favorites',''),(19,1,'closedpostboxes_dashboard','a:3:{i:0;s:18:\"dashboard_activity\";i:1;s:22:\"jetpack_summary_widget\";i:2;s:21:\"dashboard_quick_press\";}'),(20,1,'metaboxhidden_dashboard','a:0:{}'),(21,1,'default_password_nag',''),(22,1,'closedpostboxes_page','a:0:{}'),(23,1,'metaboxhidden_page','a:7:{i:0;s:16:\"so-panels-panels\";i:1;s:13:\"pageparentdiv\";i:2;s:12:\"postimagediv\";i:3;s:10:\"postcustom\";i:4;s:7:\"slugdiv\";i:5;s:9:\"authordiv\";i:6;s:12:\"revisionsdiv\";}'),(26,1,'meta-box-order_toplevel_page_ngfb-essential','a:0:{}'),(27,1,'metaboxhidden_toplevel_page_ngfb-essential','a:0:{}'),(28,1,'closedpostboxes_toplevel_page_ngfb-essential','a:0:{}'),(31,1,'meta-box-order_ngfb-free_page_ngfb-style','a:0:{}'),(32,1,'metaboxhidden_ngfb-free_page_ngfb-style','a:0:{}'),(33,1,'closedpostboxes_ngfb-free_page_ngfb-style','a:0:{}'),(34,1,'metaseo_posts_per_page','10'),(35,1,'metaseo_link_per_page','10'),(41,1,'closedpostboxes_ngfb-free_page_ngfb-sharing','a:9:{i:0;s:37:\"ngfb-free_page_ngfb-sharing_pinterest\";i:1;s:36:\"ngfb-free_page_ngfb-sharing_linkedin\";i:2;s:34:\"ngfb-free_page_ngfb-sharing_buffer\";i:3;s:34:\"ngfb-free_page_ngfb-sharing_reddit\";i:4;s:36:\"ngfb-free_page_ngfb-sharing_managewp\";i:5;s:39:\"ngfb-free_page_ngfb-sharing_stumbleupon\";i:6;s:34:\"ngfb-free_page_ngfb-sharing_tumblr\";i:7;s:35:\"ngfb-free_page_ngfb-sharing_youtube\";i:8;s:33:\"ngfb-free_page_ngfb-sharing_skype\";}'),(42,1,'meta-box-order_ngfb-free_page_ngfb-sharing','a:0:{}'),(43,1,'metaboxhidden_ngfb-free_page_ngfb-sharing','a:0:{}'),(44,1,'meta-box-order_page','a:3:{s:4:\"side\";s:36:\"submitdiv,pageparentdiv,postimagediv\";s:6:\"normal\";s:82:\"wpmseo_meta,commentsdiv,postcustom,commentstatusdiv,slugdiv,authordiv,revisionsdiv\";s:8:\"advanced\";s:9:\"at_widget\";}'),(45,1,'screen_layout_page','2'),(46,1,'closedpostboxes_attachment','a:1:{i:0;s:11:\"wpmseo_meta\";}'),(47,1,'metaboxhidden_attachment','a:2:{i:0;s:7:\"slugdiv\";i:1;s:9:\"authordiv\";}'),(48,1,'jetpack_tracks_wpcom_id','88706587'),(49,1,'managenav-menuscolumnshidden','a:5:{i:0;s:11:\"link-target\";i:1;s:11:\"css-classes\";i:2;s:3:\"xfn\";i:3;s:11:\"description\";i:4;s:15:\"title-attribute\";}'),(50,1,'metaboxhidden_nav-menus','a:5:{i:0;s:26:\"add-post-type-logoshowcase\";i:1;s:24:\"add-post-type-portofolio\";i:2;s:12:\"add-post_tag\";i:3;s:15:\"add-post_format\";i:4;s:27:\"add-wplss_logo_showcase_cat\";}'),(51,1,'nav_menu_recently_edited','5'),(52,1,'meta-box-order_link','a:3:{s:4:\"side\";s:13:\"linksubmitdiv\";s:6:\"normal\";s:56:\"linkxfndiv,linkcategorydiv,linktargetdiv,linkadvanceddiv\";s:8:\"advanced\";s:0:\"\";}'),(53,1,'screen_layout_link','2'),(54,1,'closedpostboxes_logoshowcase','a:1:{i:0;s:12:\"postimagediv\";}'),(55,1,'metaboxhidden_logoshowcase','a:1:{i:0;s:7:\"slugdiv\";}'),(56,1,'wp_tablepress_user_options','{\"user_options_db_version\":32,\"admin_menu_parent_page\":\"middle\",\"message_first_visit\":true}'),(57,1,'so_panels_directory_enabled','1'),(58,1,'closedpostboxes_toplevel_page_maintenance','a:1:{i:0;s:24:\"maintenance-excludepages\";}'),(59,1,'metaboxhidden_toplevel_page_maintenance','a:0:{}'),(60,1,'metaseo_imgs_per_page','10'),(61,1,'wp_metaseo_imgs_per_page','10'),(62,1,'meta-box-order_dashboard','a:4:{s:6:\"normal\";s:61:\"dashboard_right_now,dashboard_activity,jetpack_summary_widget\";s:4:\"side\";s:39:\"dashboard_quick_press,dashboard_primary\";s:7:\"column3\";s:0:\"\";s:7:\"column4\";s:0:\"\";}'),(63,1,'wp_metaseo_posts_per_page','10'),(64,1,'edit_page_per_page','40'),(65,1,'managetablepress_listcolumnshidden','a:1:{i:0;s:22:\"table_last_modified_by\";}'),(66,1,'dismissed_wp_pointers','wp390_widgets');
CREATE TABLE `wp_users` (
  `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_login` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `user_pass` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `user_nicename` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `user_email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `user_url` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `user_registered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `user_activation_key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `user_status` int(11) NOT NULL DEFAULT '0',
  `display_name` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`ID`),
  KEY `user_login_key` (`user_login`),
  KEY `user_nicename` (`user_nicename`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
INSERT INTO `wp_users` VALUES (1,'damien','$P$BLohsjQvd0OGITzqj/zVSBzvHfZwMO/','admin','info@2niteshow.com','','2016-02-04 11:52:06','',0,'admin');
CREATE TABLE `wp_visual_form_builder_entries` (
  `entries_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `form_id` bigint(20) NOT NULL,
  `data` longtext NOT NULL,
  `subject` text,
  `sender_name` varchar(255) DEFAULT NULL,
  `sender_email` varchar(255) DEFAULT NULL,
  `emails_to` text,
  `date_submitted` datetime DEFAULT NULL,
  `ip_address` varchar(25) DEFAULT NULL,
  `entry_approved` varchar(20) DEFAULT '1',
  PRIMARY KEY (`entries_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `wp_visual_form_builder_fields` (
  `field_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `form_id` bigint(20) NOT NULL,
  `field_key` varchar(255) NOT NULL,
  `field_type` varchar(25) NOT NULL,
  `field_options` text,
  `field_description` text,
  `field_name` text NOT NULL,
  `field_sequence` bigint(20) DEFAULT '0',
  `field_parent` bigint(20) DEFAULT '0',
  `field_validation` varchar(25) DEFAULT NULL,
  `field_required` varchar(25) DEFAULT NULL,
  `field_size` varchar(25) DEFAULT 'medium',
  `field_css` varchar(255) DEFAULT NULL,
  `field_layout` varchar(255) DEFAULT NULL,
  `field_default` text,
  PRIMARY KEY (`field_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `wp_visual_form_builder_forms` (
  `form_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `form_key` tinytext NOT NULL,
  `form_title` text NOT NULL,
  `form_email_subject` text,
  `form_email_to` text,
  `form_email_from` varchar(255) DEFAULT NULL,
  `form_email_from_name` varchar(255) DEFAULT NULL,
  `form_email_from_override` varchar(255) DEFAULT NULL,
  `form_email_from_name_override` varchar(255) DEFAULT NULL,
  `form_success_type` varchar(25) DEFAULT 'text',
  `form_success_message` text,
  `form_notification_setting` varchar(25) DEFAULT NULL,
  `form_notification_email_name` varchar(255) DEFAULT NULL,
  `form_notification_email_from` varchar(255) DEFAULT NULL,
  `form_notification_email` varchar(25) DEFAULT NULL,
  `form_notification_subject` varchar(255) DEFAULT NULL,
  `form_notification_message` text,
  `form_notification_entry` varchar(25) DEFAULT NULL,
  `form_label_alignment` varchar(25) DEFAULT NULL,
  PRIMARY KEY (`form_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `wp_woo_transition` (
  `woo_id` int(11) NOT NULL AUTO_INCREMENT,
  `woo_path` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `woo_link` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `woo_target` varchar(50) NOT NULL,
  `woo_title` varchar(200) NOT NULL,
  `woo_order` int(11) NOT NULL,
  `woo_status` varchar(10) NOT NULL,
  `woo_type` varchar(100) NOT NULL,
  `woo_date` int(11) NOT NULL,
  PRIMARY KEY (`woo_id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
INSERT INTO `wp_woo_transition` VALUES (1,'http://www.vestacapital.com.au/wp-content/plugins/woo-superb-slideshow-transition-gallery-with-random-effect/images/250x167_1.jpg','#','_blank','',1,'YES','widget',0),(2,'http://www.vestacapital.com.au/wp-content/plugins/woo-superb-slideshow-transition-gallery-with-random-effect/images/250x167_2.jpg','#','_blank','',2,'YES','widget',0),(3,'http://www.vestacapital.com.au/wp-content/plugins/woo-superb-slideshow-transition-gallery-with-random-effect/images/250x167_3.jpg','#','_blank','',3,'YES','PAGE',0),(4,'http://www.vestacapital.com.au/wp-content/plugins/woo-superb-slideshow-transition-gallery-with-random-effect/images/250x167_4.jpg','#','_blank','',4,'YES','PAGE',0);
CREATE TABLE `wp_wpl_activities` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `activity` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `position` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `enabled` tinyint(4) NOT NULL DEFAULT '1',
  `index` float(5,2) NOT NULL DEFAULT '99.00',
  `params` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `show_title` tinyint(4) NOT NULL DEFAULT '1',
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `association_type` tinyint(4) NOT NULL DEFAULT '1',
  `associations` text,
  `client` tinyint(4) NOT NULL DEFAULT '2',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;
INSERT INTO `wp_wpl_activities` VALUES (2,'listing_links','plisting_position2',1,0.03,'{\"facebook\":\"1\",\"google_plus\":\"1\",\"twitter\":\"1\",\"pinterest\":\"1\"}',0,'',1,NULL,2),(3,'listing_gallery:pshow','pshow_gallery',1,0.05,'{\"image_width\":\"1600\",\"image_height\":\"420\",\"image_class\":\"\",\"rewrite\":\"0\",\"watermark\":\"0\"}',0,'',1,NULL,2),(4,'listing_links:pshow','pshow_position2',1,0.04,'{\"facebook\":\"1\",\"google_plus\":\"1\",\"twitter\":\"1\",\"pinterest\":\"1\"}',0,'',1,NULL,2),(5,'property_manager_actions','pmanager_position2',1,2.00,'',0,'',1,NULL,2),(6,'listing_gallery:pmanager','pmanager_position3',1,0.12,'',0,'',1,NULL,2),(7,'agent_info','pshow_position2',1,0.06,'',1,'Agent info',1,NULL,2),(8,'listing_rooms','pshow_position2',1,0.07,'',1,'Property Rooms',1,NULL,2),(9,'listing_attachments','pshow_position2',1,0.08,'',1,'Attachments',1,NULL,2),(10,'qrcode:default','pshow_qr_code',1,0.10,'{\"picture_width\":\"90\",\"picture_height\":\"90\",\"outer_margin\":\"2\",\"size\":\"4\"}',1,'QR Code',1,NULL,2),(11,'listing_videos','pshow_video',0,0.14,'',0,'',1,NULL,2),(12,'agent_info:profileshow','profile_show_position1',1,0.02,'',1,'Agent info',1,NULL,2),(13,'listing_gallery','wpl_property_listing_image',1,0.01,'{\"image_width\":\"285\",\"image_height\":\"200\",\"image_class\":\"\",\"rewrite\":\"0\",\"watermark\":\"0\"}',0,'',1,NULL,2),(14,'googlemap','plisting_position1',1,0.11,'',0,'',1,NULL,2),(15,'googlemap:pshow','pshow_googlemap',1,1.00,'{\"default_lt\":\"38.685516\",\"default_ln\":\"-101.073324\",\"default_zoom\":\"4\"}',0,'',1,NULL,2),(23,'listing_contact','pshow_position2',1,99.00,'',1,'Contact Agent',1,'',2),(24,'user_contact','profile_show_position1',0,99.00,'{\"top_comment\":\"\"}',1,'Contact',1,'',2);
CREATE TABLE `wp_wpl_addons` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `version` varchar(15) DEFAULT NULL,
  `addon_name` varchar(100) DEFAULT NULL,
  `params` text,
  `update` varchar(200) DEFAULT NULL,
  `update_key` varchar(100) DEFAULT NULL,
  `support_key` varchar(100) DEFAULT NULL,
  `updatable` tinyint(4) NOT NULL DEFAULT '1',
  `message` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `wp_wpl_cronjobs` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `cronjob_name` varchar(255) NOT NULL,
  `period` float(6,2) NOT NULL,
  `class_location` varchar(255) NOT NULL,
  `class_name` varchar(100) NOT NULL,
  `function_name` varchar(100) NOT NULL,
  `params` text NOT NULL,
  `enabled` tinyint(4) NOT NULL,
  `latest_run` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
INSERT INTO `wp_wpl_cronjobs` VALUES (1,'Location Text Update',24.00,'libraries.locations','wpl_locations','update_locationtextsearch_data','',1,'2016-03-11 03:48:56'),(2,'Remove Expired tmp Directories',24.00,'global','wpl_global','delete_expired_tmp','',1,'2016-03-11 03:48:56'),(3,'Check All Updates',24.00,'global','wpl_global','check_all_update','',1,'2016-03-11 03:48:56'),(5,'Maintenance',24.00,'global','wpl_global','execute_maintenance_job','',1,'2016-03-11 03:48:56'),(9,'Auto-Update Exchange Rates',24.00,'libraries.units','wpl_units','auto_update_rates','',1,'2016-03-11 03:48:56');
CREATE TABLE `wp_wpl_dbcat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `kind` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0=property, 1=complex',
  `name` varchar(30) DEFAULT NULL,
  `index` float NOT NULL DEFAULT '99',
  `enabled` tinyint(4) NOT NULL DEFAULT '1',
  `pshow` tinyint(4) NOT NULL DEFAULT '1',
  `pdf` tinyint(4) NOT NULL DEFAULT '0',
  `searchmod` tinyint(4) NOT NULL DEFAULT '1',
  `prefix` varchar(5) DEFAULT NULL,
  `listing_specific` varchar(200) DEFAULT NULL,
  `property_type_specific` varchar(200) DEFAULT NULL,
  `params` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
INSERT INTO `wp_wpl_dbcat` VALUES (1,0,'Basic Details',1,1,1,1,1,'b','','',NULL),(2,0,'Address Map',2,1,1,1,1,'ad','','',NULL),(3,0,'Image Gallery',3,1,0,0,1,'gal','','',NULL),(4,0,'Features',1.5,1,1,1,1,'f','','',NULL),(5,0,'Appliances',1.7,1,1,1,1,'app','','',NULL),(6,0,'Neighborhood',2.5,1,1,1,1,'n','','',NULL),(7,0,'Video',7,1,0,0,0,'v','','',NULL),(9,0,'Attachments',9,1,0,0,0,'att','','',NULL),(10,2,'Basic Details',1,1,1,1,1,'b','','',NULL),(11,0,'Specialties',10,1,0,0,1,'sp','','',NULL);
CREATE TABLE `wp_wpl_dbst` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `kind` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0=property, 1=complex',
  `mandatory` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0=no,1=yes,2=always,3=never',
  `name` varchar(150) DEFAULT NULL,
  `type` varchar(20) DEFAULT NULL,
  `options` text,
  `enabled` tinyint(4) NOT NULL DEFAULT '1' COMMENT '0=no,1=yes,2=always',
  `pshow` varchar(255) NOT NULL DEFAULT '1' COMMENT 'To show in propertyshow or not',
  `pdf` tinyint(4) NOT NULL DEFAULT '0',
  `plisting` tinyint(4) NOT NULL DEFAULT '0',
  `searchmod` tinyint(4) NOT NULL DEFAULT '0',
  `editable` tinyint(4) NOT NULL DEFAULT '1',
  `deletable` tinyint(4) NOT NULL DEFAULT '1',
  `index` float(9,4) NOT NULL DEFAULT '99.0000',
  `css` varchar(50) DEFAULT NULL,
  `style` text,
  `specificable` tinyint(4) NOT NULL DEFAULT '1' COMMENT '0=no,1=yes',
  `listing_specific` varchar(200) DEFAULT NULL,
  `property_type_specific` varchar(200) DEFAULT NULL,
  `user_specific` varchar(200) DEFAULT NULL,
  `accesses` text,
  `accesses_message` varchar(100) DEFAULT NULL,
  `table_name` varchar(30) DEFAULT NULL COMMENT 'table which the data is stored to',
  `table_column` varchar(30) DEFAULT NULL COMMENT 'column of table which datat is stored to',
  `category` int(11) NOT NULL DEFAULT '1' COMMENT 'in propertywizard category',
  `rankable` tinyint(4) NOT NULL DEFAULT '1',
  `rank_point` int(11) NOT NULL DEFAULT '0',
  `comments` text,
  `pwizard` varchar(255) NOT NULL DEFAULT '1' COMMENT '0=no,1=yes,2=always',
  `text_search` tinyint(4) DEFAULT NULL,
  `params` text,
  `flex` tinyint(4) NOT NULL DEFAULT '1',
  `sortable` tinyint(4) NOT NULL DEFAULT '1' COMMENT '0=not sortable,1=sortable,2=always',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=919 DEFAULT CHARSET=utf8;
INSERT INTO `wp_wpl_dbst` VALUES (1,0,0,'Listing Setting','separator','',1,'0',0,0,1,1,0,1.0100,'','font-weight:bold',0,'','',NULL,NULL,NULL,'','',1,1,0,'','1',1,'',1,0),(2,0,2,'Listing Type','listings','',2,'1',1,1,1,1,0,1.0300,'','',0,'','',NULL,NULL,NULL,'wpl_properties','listing',1,0,0,'','1',1,'',1,1),(3,0,2,'Property Type','property_types','',2,'1',1,1,1,1,0,1.0200,'','',0,'','',NULL,NULL,NULL,'wpl_properties','property_type',1,0,0,'','1',1,'',1,1),(4,0,0,'Ref ID','text','',1,'0',0,0,1,1,0,1.0500,'','',1,'','',NULL,NULL,NULL,'wpl_properties','ref_id',1,1,10,'','1',1,'',1,1),(5,0,3,'Listing ID','text','{\"readonly\":\"1\"}',1,'1',1,1,1,1,0,1.0400,'','',1,'','',NULL,NULL,NULL,'wpl_properties','mls_id',1,0,0,'','1',1,'',1,2),(6,0,1,'Price','price','',1,'1',1,1,1,1,1,1.0800,'','',1,'','',NULL,NULL,NULL,'wpl_properties','price',1,0,0,'','1',1,'',1,1),(7,0,1,'View','select','{\"params\":{\"1\":{\"key\":\"1\",\"enabled\":\"1\",\"value\":\"Garden\"},\"2\":{\"key\":\"2\",\"enabled\":\"1\",\"value\":\"Street\"},\"3\":{\"key\":\"3\",\"enabled\":\"1\",\"value\":\"Sea\"}}}',1,'1',1,0,1,1,1,1.1000,'','',1,'','',NULL,NULL,NULL,'wpl_properties','field_7',1,1,0,'','1',1,'',1,1),(8,0,1,'Bedrooms','number','',1,'1',1,1,1,1,1,1.1100,'','',1,'','6,7,',NULL,NULL,NULL,'wpl_properties','bedrooms',1,1,0,'','1',1,'',1,1),(9,0,1,'Bathrooms','number','',1,'1',1,1,1,1,1,1.1300,'','',1,'','6,7,13,',NULL,NULL,NULL,'wpl_properties','bathrooms',1,1,0,'','1',1,'',1,1),(10,0,1,'Built Up Area','area','',1,'1',1,1,1,1,1,1.1500,'','',1,'','6,7,13,',NULL,NULL,NULL,'wpl_properties','living_area',1,1,0,'','1',1,'',1,1),(11,0,0,'Lot Area','area','',1,'1',1,1,1,1,1,1.1700,'','',1,'','',NULL,NULL,NULL,'wpl_properties','lot_area',1,1,0,'','1',1,'',1,1),(12,0,0,'Year Built','number','',1,'1',1,0,1,1,1,1.1600,'','',1,'','',NULL,NULL,NULL,'wpl_properties','build_year',1,1,0,'','1',1,'',1,1),(13,0,1,'Rooms','number','',1,'1',1,1,1,1,1,1.1200,'','',1,'','13,',NULL,NULL,NULL,'wpl_properties','rooms',1,1,0,'','1',1,'',1,1),(14,0,1,'Price Type','select','{\"params\":{\"1\":{\"key\":\"30\",\"enabled\":\"1\",\"value\":\"Per Month\"},\"2\":{\"key\":\"7\",\"enabled\":\"1\",\"value\":\"Per Week\"},\"3\":{\"key\":\"365\",\"enabled\":\"1\",\"value\":\"Per Year\"},\"4\":{\"key\":\"1\",\"enabled\":\"1\",\"value\":\"Per Day\"}}}',1,'1',1,1,1,1,1,1.0700,'','',1,'10,12,','',NULL,NULL,NULL,'wpl_properties','price_period',1,1,0,'','1',1,'',1,1),(17,0,0,'Half Bathrooms','number','',1,'1',1,1,1,1,1,1.1400,'','',1,'','6,7,13,',NULL,NULL,NULL,'wpl_properties','half_bathrooms',1,1,0,'','1',1,'',1,1),(18,0,0,'Text Search','textsearch','',2,'0',0,0,1,0,0,1.2200,'','',0,'','',NULL,NULL,NULL,'wpl_properties','textsearch',1,0,0,'','0',0,'',1,1),(19,0,0,'List Date','date','',1,'0',0,0,1,0,0,1.0900,'','',0,'','',NULL,NULL,NULL,'wpl_properties','add_date',1,0,0,'','0',0,'',1,1),(20,0,0,'Alias / Permalink','text','',2,'0',0,0,0,1,0,1.0200,'','',0,'','','',NULL,NULL,'wpl_properties','alias',1,0,0,'','0',0,'',1,1),(21,0,0,'Location Text','text','{\"if_zero\":\"1\",\"call_text\":\"Call\"}',2,'0',0,0,0,1,0,1.0210,'','',0,'','','',NULL,NULL,'wpl_properties','location_text',2,0,0,'','0',0,'',1,1),(22,0,0,'Category','ptcategory','',2,'0',0,0,1,0,0,1.0450,'','',0,'','','',NULL,NULL,NULL,NULL,1,0,0,'','0',0,'',0,0),(40,0,0,'Address Location','separator','',1,'0',0,0,1,1,0,1.0000,'','font-weight:bold',0,'','',NULL,NULL,NULL,'','',2,1,0,'','1',1,'',1,0),(41,0,2,'Location','locations','',1,'1',1,1,1,1,0,2.0000,'','',1,'','',NULL,NULL,NULL,'wpl_properties','locations',2,0,0,'','1',1,'',1,1),(42,0,0,'Street','text','',1,'1',1,1,1,1,1,12.0000,'class','style',1,'','',NULL,NULL,NULL,'wpl_properties','field_42',2,1,0,'','1',1,'',1,1),(43,0,0,'Postal Code','text','',1,'1',1,1,1,1,1,21.0000,'','',1,'','',NULL,NULL,NULL,'wpl_properties','post_code',2,1,30,'','1',1,'',1,1),(45,0,0,'Street Number','text','',1,'1',1,1,1,1,1,13.0000,'','',1,'','',NULL,NULL,NULL,'wpl_properties','street_no',2,0,0,NULL,'1',1,'',1,1),(50,0,0,'Google Map','separator','',1,'0',0,0,1,1,0,48.0000,'','',0,'','',NULL,NULL,NULL,'','',2,1,0,'','1',0,'',1,0),(51,0,3,'Longitude','text','{\"readonly\":\"1\"}',2,'1',1,0,0,1,0,49.0000,'','',0,'','',NULL,NULL,NULL,'wpl_properties','googlemap_ln',2,0,0,'','1',0,'',1,1),(52,0,3,'Latitude','text','{\"readonly\":\"1\"}',2,'1',1,0,0,1,0,58.0000,'','',0,'','',NULL,NULL,NULL,'wpl_properties','googlemap_lt',2,0,0,'','1',0,'',1,1),(53,0,3,'Map','googlemap','',1,'0',0,0,0,0,0,67.0000,'','',1,'','',NULL,NULL,NULL,'','',2,1,50,'','1',0,'',1,0),(54,0,0,'Building Name','text','',1,'1',1,1,1,1,1,30.0000,'','',1,'','',NULL,NULL,NULL,'wpl_properties','field_54',2,1,30,'','1',1,'',1,1),(55,0,0,'Floor Number','number','',1,'1',1,1,1,1,1,39.0000,'','',1,'','',NULL,NULL,NULL,'wpl_properties','field_55',2,1,10,'','1',1,'',1,1),(91,0,0,'Appliances','separator','',1,'0',0,0,1,1,0,1.0000,'','font-weight:bold',0,'','',NULL,NULL,NULL,'','',5,1,0,'','1',1,'',1,0),(92,0,0,'Neighborhood','separator','',1,'0',0,0,1,1,0,1.0000,'','font-weight:bold',0,'','',NULL,NULL,NULL,'','',6,1,0,'','1',1,'',1,0),(100,0,3,'Shopping Center','neighborhood','',1,'1',1,0,1,1,1,1.0000,'','',1,'','',NULL,NULL,NULL,'wpl_properties','n_100',6,1,10,'','1',1,'',1,1),(101,0,3,'Hospital','neighborhood','',1,'1',1,0,1,1,1,21.0000,'','',1,'','',NULL,NULL,NULL,'wpl_properties','n_101',6,1,10,'','1',1,'',1,1),(102,0,3,'Cinema','neighborhood','',1,'1',1,0,1,1,1,101.0000,'','',1,'','',NULL,NULL,NULL,'wpl_properties','n_102',6,1,0,'','1',1,'',1,1),(103,0,3,'Park','neighborhood','',1,'1',1,0,1,1,1,111.0000,'','',1,'','',NULL,NULL,NULL,'wpl_properties','n_103',6,1,10,'','1',1,'',1,1),(105,0,3,'Beach','neighborhood','',1,'1',1,0,1,1,1,81.0000,'','',1,'','',NULL,NULL,NULL,'wpl_properties','n_105',6,1,20,'','1',1,'',1,1),(106,0,3,'Coffee Shop','neighborhood','',1,'1',1,0,1,1,1,71.0000,'','',1,'','',NULL,NULL,NULL,'wpl_properties','n_106',6,1,0,'','1',1,'',1,1),(107,0,3,'Airport','neighborhood','',1,'1',1,0,1,1,1,61.0000,'','',1,'','',NULL,NULL,NULL,'wpl_properties','n_107',6,1,0,'','1',1,'',1,1),(108,0,3,'Bus Station','neighborhood','',1,'1',1,0,1,1,1,51.0000,'','',1,'','',NULL,NULL,NULL,'wpl_properties','n_108',6,1,0,'','1',1,'',1,1),(109,0,3,'Train Station','neighborhood','',1,'1',1,0,1,1,1,41.0000,'','',1,'','',NULL,NULL,NULL,'wpl_properties','n_109',6,1,0,'','1',1,'',1,1),(110,0,3,'School','neighborhood','',1,'1',1,0,1,1,1,121.0000,'','',1,'','',NULL,NULL,NULL,'wpl_properties','n_110',6,1,10,'','1',1,'',1,1),(111,0,3,'University','neighborhood','',1,'1',1,0,1,1,1,131.0000,'','',1,'','',NULL,NULL,NULL,'wpl_properties','n_111',6,1,0,'','1',1,'',1,1),(112,0,3,'Police Station','neighborhood','',1,'1',1,0,1,1,1,31.0000,'','',1,'','',NULL,NULL,NULL,'wpl_properties','n_112',6,1,10,'','1',1,'',1,1),(113,0,3,'Town Center','neighborhood','',1,'1',1,0,1,1,1,11.0000,'','',1,'','',NULL,NULL,NULL,'wpl_properties','n_113',6,1,20,'','1',1,'',1,1),(114,0,3,'Exhibition','neighborhood','',1,'1',1,0,1,1,1,151.0000,'','',1,'','',NULL,NULL,NULL,'wpl_properties','n_114',6,1,0,'','1',1,'',1,1),(115,0,3,'Tourist Site','neighborhood','',1,'1',1,0,1,1,1,141.0000,'','',1,'','',NULL,NULL,NULL,'wpl_properties','n_115',6,1,0,'','1',1,'',1,1),(129,0,0,'Features','separator','',1,'0',0,0,1,1,0,4.0000,'','font-weight:bold',0,'','',NULL,NULL,NULL,'','',4,1,0,'','1',1,'',1,0),(130,0,3,'Heating System','feature','{\"type\":\"single\",\"values\":[{\"key\":\"1\",\"value\":\"Split\"},{\"key\":\"2\",\"value\":\"Heat Pump\"},{\"key\":\"3\",\"value\":\"Central\"}]}',1,'1',1,0,1,1,1,4.0400,'','',1,'','',NULL,NULL,NULL,'wpl_properties','f_130',4,1,5,'','1',1,'',1,1),(131,0,3,'Swimming Pool','feature','{\"type\":\"none\"}',1,'1',1,0,1,1,1,4.0200,'','',1,'','',NULL,NULL,NULL,'wpl_properties','f_131',4,1,30,'','1',1,'',1,1),(132,0,3,'Jacuzzi','feature','{\"type\":\"none\"}',1,'1',1,0,1,1,1,4.0300,'','',1,'','',NULL,NULL,NULL,'wpl_properties','f_132',4,1,10,'','1',1,'',1,1),(133,0,3,'Elevator','feature','{\"type\":\"none\"}',1,'1',1,0,1,1,1,4.0600,'','',1,'','',NULL,NULL,NULL,'wpl_properties','f_133',4,1,5,'','1',1,'',1,1),(134,0,3,'Cooling System','feature','{\"type\":\"single\",\"values\":[{\"key\":\"1\",\"value\":\"Split\"},{\"key\":\"2\",\"value\":\"Central\"}]}',1,'1',1,0,1,1,1,4.0500,'','',1,'','',NULL,NULL,NULL,'wpl_properties','f_134',4,1,10,'','1',1,'',1,1),(135,0,3,'Garden','feature','{\"type\":\"none\"}',1,'1',1,0,1,1,1,4.0700,'','',1,'','',NULL,NULL,NULL,'wpl_properties','f_135',4,1,0,'','1',1,'',1,1),(136,0,3,'Balcony','feature','{\"type\":\"none\"}',1,'1',1,1,1,1,1,4.0800,'','',1,'','',NULL,NULL,NULL,'wpl_properties','f_136',4,1,5,'','1',1,'',1,1),(137,0,3,'Basement','feature','{\"type\":\"none\"}',1,'1',1,0,1,1,1,4.1000,'','',1,'','',NULL,NULL,NULL,'wpl_properties','f_137',4,1,0,'','1',1,'',1,1),(138,0,3,'Fence','feature','{\"type\":\"none\"}',1,'1',1,0,1,1,1,4.1100,'','',1,'','',NULL,NULL,NULL,'wpl_properties','f_138',4,1,0,'','1',1,'',1,1),(139,0,3,'View','feature','{\"type\":\"none\"}',1,'1',1,0,1,1,1,4.1200,'','',1,'','',NULL,NULL,NULL,'wpl_properties','f_139',4,1,0,'','1',1,'',1,1),(140,0,3,'Pet Policy','feature','{\"type\":\"single\",\"values\":[{\"key\":\"1\",\"value\":\"Allowed\"},{\"key\":\"2\",\"value\":\"Not Allowed\"}]}',1,'1',1,0,1,1,1,4.1300,'','',1,'','',NULL,NULL,NULL,'wpl_properties','f_140',4,1,0,'','1',1,'',1,1),(141,0,3,'Kitchen','feature','{\"type\":\"single\",\"values\":[{\"key\":\"1\",\"value\":\"Fully Equipped\"},{\"key\":\"2\",\"value\":\"Semi Equipped\"},{\"key\":\"3\",\"value\":\"Not Equipped\"}]}',1,'1',1,0,1,1,1,4.1400,'','',1,'','',NULL,NULL,NULL,'wpl_properties','f_141',4,1,0,'','1',1,'',1,1),(142,0,3,'Steam','feature','{\"type\":\"none\"}',1,'1',1,0,1,1,1,4.1500,'','',1,'','',NULL,NULL,NULL,'wpl_properties','f_142',4,1,0,'','1',1,'',1,1),(143,0,3,'Gymnasium','feature','{\"type\":\"none\"}',1,'1',1,0,1,1,1,4.1600,'','',1,'','',NULL,NULL,NULL,'wpl_properties','f_143',4,1,0,'','1',1,'',1,1),(144,0,3,'Fireplace','feature','{\"type\":\"none\"}',1,'1',1,0,1,1,1,4.1700,'','',1,'','',NULL,NULL,NULL,'wpl_properties','f_144',4,1,0,'','1',1,'',1,1),(146,0,3,'Patio','feature','{\"type\":\"none\"}',1,'1',1,0,1,1,1,4.1900,'','',1,'','',NULL,NULL,NULL,'wpl_properties','f_146',4,1,0,'','1',1,'',1,1),(147,0,3,'Roof Deck','feature','{\"type\":\"none\"}',1,'1',1,0,1,1,1,4.2000,'','',1,'','',NULL,NULL,NULL,'wpl_properties','f_147',4,1,0,'','1',1,'',1,1),(148,0,3,'High Ceiling','feature','{\"type\":\"none\"}',1,'1',1,0,1,1,1,4.2100,'','',1,'','',NULL,NULL,NULL,'wpl_properties','f_148',4,1,0,'','1',1,'',1,1),(149,0,3,'Storage','feature','{\"type\":\"none\"}',1,'1',1,0,1,1,1,4.2200,'','',1,'','',NULL,NULL,NULL,'wpl_properties','f_149',4,1,0,'','1',1,'',1,1),(150,0,3,'Parking','feature','{\"type\":\"single\",\"values\":[{\"key\":\"1\",\"value\":\"1\"},{\"key\":\"2\",\"value\":\"2\"},{\"key\":\"3\",\"value\":\"3\"},{\"key\":\"4\",\"value\":\"4\"},{\"key\":\"5\",\"value\":\"5\"},{\"key\":\"6\",\"value\":\"6\"}]}',1,'1',1,1,1,1,1,4.2300,'','',1,'','',NULL,NULL,NULL,'wpl_properties','f_150',4,1,10,'','1',1,'',1,1),(151,0,3,'Furnished','feature','{\"type\":\"single\",\"values\":[{\"key\":\"1\",\"value\":\"Fully Furnished\"},{\"key\":\"2\",\"value\":\"Semi Furnished\"},{\"key\":\"3\",\"value\":\"Not Furnished\"}]}',1,'1',1,0,1,1,1,4.2400,'','',1,'','',NULL,NULL,NULL,'wpl_properties','f_151',4,1,10,'','1',1,'',1,1),(152,0,3,'Security','feature','{\"type\":\"multiple\",\"values\":[{\"key\":\"1\",\"value\":\"Watchman\"},{\"key\":\"2\",\"value\":\"Digicode\"},{\"key\":\"3\",\"value\":\"Alarm\"},{\"key\":\"4\",\"value\":\"Lock\"},{\"key\":\"5\",\"value\":\"Cctv\"},{\"key\":\"6\",\"value\":\"No\"},{\"key\":\"7\",\"value\":\"Other\"}]}',1,'1',1,0,1,1,1,4.1800,'','',1,'','',NULL,NULL,NULL,'wpl_properties','f_152',4,1,10,'','1',1,'',1,1),(153,0,3,'Refrigerator','feature','{\"type\":\"single\",\"values\":[{\"key\":\"1\",\"value\":\"Simple\"},{\"key\":\"2\",\"value\":\"Side By Side\"}]}',1,'1',1,0,1,1,1,1.0000,'','',1,'','',NULL,NULL,NULL,'wpl_properties','f_153',5,1,5,'','1',1,'',1,1),(154,0,3,'Stove','feature','{\"type\":\"none\"}',1,'1',1,0,1,1,1,21.0000,'','',1,'','',NULL,NULL,NULL,'wpl_properties','f_154',5,1,5,'','1',1,'',1,1),(155,0,3,'Microwave','feature','{\"type\":\"none\"}',1,'1',1,0,1,1,1,11.0000,'','',1,'','',NULL,NULL,NULL,'wpl_properties','f_155',5,1,5,'','1',1,'',1,1),(156,0,3,'Washing Machine','feature','{\"type\":\"none\"}',1,'1',1,0,1,1,1,31.0000,'','',1,'','',NULL,NULL,NULL,'wpl_properties','f_156',5,1,5,'','1',1,'',1,1),(157,0,3,'TV','feature','{\"type\":\"none\"}',1,'1',1,0,1,1,1,41.0000,'','',1,'','',NULL,NULL,NULL,'wpl_properties','f_157',5,1,5,'','1',1,'',1,1),(158,0,3,'CD Player','feature','{\"type\":\"none\"}',1,'1',1,0,1,1,1,51.0000,'','',1,'','',NULL,NULL,NULL,'wpl_properties','f_158',5,1,5,'','1',1,'',1,1),(159,0,3,'Internet','feature','{\"type\":\"single\",\"values\":[{\"key\":\"1\",\"value\":\"Exclusive\"},{\"key\":\"2\",\"value\":\"Inclusive\"},{\"key\":\"3\",\"value\":\"Wireless\"}]}',1,'1',1,0,1,1,1,171.0000,'','',1,'','',NULL,NULL,NULL,'wpl_properties','f_159',5,1,5,'','1',1,'',1,1),(160,0,3,'Hair Dryer','feature','{\"type\":\"none\"}',1,'1',1,0,1,1,1,61.0000,'','',1,'','',NULL,NULL,NULL,'wpl_properties','f_160',5,1,5,'','1',1,'',1,1),(161,0,3,'Cleaning Service','feature','{\"type\":\"none\"}',1,'1',1,0,1,1,1,71.0000,'','',1,'','',NULL,NULL,NULL,'wpl_properties','f_161',5,1,5,'','1',1,'',1,1),(162,0,3,'Oven','feature','{\"type\":\"none\"}',1,'1',1,0,1,1,1,81.0000,'','',1,'','',NULL,NULL,NULL,'wpl_properties','f_162',5,1,5,'','1',1,'',1,1),(163,0,3,'Dishwasher','feature','{\"type\":\"none\"}',1,'1',1,0,1,1,1,91.0000,'','',1,'','',NULL,NULL,NULL,'wpl_properties','f_163',5,1,5,'','1',1,'',1,1),(164,0,3,'Dishes','feature','{\"type\":\"none\"}',1,'1',1,0,1,1,1,101.0000,'','',1,'','',NULL,NULL,NULL,'wpl_properties','f_164',5,1,5,'','1',1,'',1,1),(165,0,3,'Satellite','feature','{\"type\":\"none\"}',1,'1',1,0,1,1,1,111.0000,'','',1,'','',NULL,NULL,NULL,'wpl_properties','f_165',5,1,5,'','1',1,'',1,1),(166,0,3,'Telephone','feature','{\"type\":\"none\"}',1,'1',1,0,1,1,1,121.0000,'','',1,'','',NULL,NULL,NULL,'wpl_properties','f_166',5,1,5,'','1',1,'',1,1),(167,0,3,'Towels','feature','{\"type\":\"none\"}',1,'1',1,0,1,1,1,131.0000,'','',1,'','',NULL,NULL,NULL,'wpl_properties','f_167',5,1,5,'','1',1,'',1,1),(168,0,3,'Hot Tub','feature','{\"type\":\"none\"}',1,'1',1,0,1,1,1,151.0000,'','',1,'','',NULL,NULL,NULL,'wpl_properties','f_168',5,1,5,'','1',1,'',1,1),(169,0,3,'Iron','feature','{\"type\":\"none\"}',1,'1',1,0,1,1,1,161.0000,'','',1,'','',NULL,NULL,NULL,'wpl_properties','f_169',5,1,5,'','1',1,'',1,1),(171,0,0,'Rooms and Sizes','rooms','',1,'0',0,0,0,0,1,3.5000,'','',1,'','',NULL,NULL,NULL,'','',4,0,0,'','1',0,'',1,0),(300,0,3,'Gallery','gallery','{\"ext_file\":\"gif,jpeg,png,jpg\",\"file_size\":\"500\"}',1,'0',0,0,1,1,0,1.0000,'','',1,'','',NULL,NULL,NULL,'','',3,0,0,'','1',0,'',1,0),(301,0,0,'Attachments','attachments','{\"ext_file\":\"pdf,doc,docx,zip,tar,rar,mp3,txt\",\"file_size\":\"5000\"}',1,'0',0,0,1,1,0,1.0000,'','',0,'','',NULL,NULL,NULL,'','',9,0,0,'','1',0,'',1,0),(302,0,0,'Details','separator','',1,'0',0,0,1,1,0,1.0600,'','font-weight:bold',0,'','',NULL,NULL,NULL,'','',1,1,0,'','1',1,'',1,0),(308,0,0,'Property Description','textarea','{\"advanced_editor\":\"1\",\"rows\":\"7\",\"cols\":\"41\"}',2,'0',0,0,1,1,0,1.0000,'','',1,'','',NULL,NULL,NULL,'wpl_properties','field_308',1,1,140,'','1',1,'',1,1),(309,0,0,'Description Meta Data','separator','',1,'0',0,0,1,1,0,1.1800,'','font-weight:bold',0,'','',NULL,NULL,NULL,'','',1,1,0,'','1',0,'',1,0),(310,0,3,'Meta Description','meta_desc','{\"advanced_editor\":\"0\",\"rows\":\"6\",\"cols\":\"60\",\"readonly\":\"1\"}',1,'0',0,0,1,1,1,1.2000,'','',0,'','',NULL,NULL,NULL,'wpl_properties','meta_description',1,0,0,'','1',0,'',1,1),(311,0,3,'Meta Keywords','meta_key','{\"advanced_editor\":\"0\",\"rows\":\"6\",\"cols\":\"60\",\"readonly\":\"1\"}',1,'0',0,0,1,1,1,1.2100,'','',0,'','',NULL,NULL,NULL,'wpl_properties','meta_keywords',1,0,0,'','1',0,'',1,1),(312,0,3,'Property Page Title','text','null',2,'0',0,1,1,1,0,0.6000,'','',1,'','',NULL,NULL,NULL,'wpl_properties','field_312',1,0,0,'','1',1,'',1,1),(313,0,3,'Property Title','text','null',2,'0',0,1,1,1,0,0.5000,'','',1,'','',NULL,NULL,NULL,'wpl_properties','field_313',1,0,0,'','1',1,'[]',1,1),(400,0,3,'Featured','tag','{\"ribbon\":\"1\",\"widget\":\"1\",\"color\":\"29a9df\",\"text_color\":\"ffffff\",\"default_value\":\"0\"}',1,'1',1,1,1,1,0,2.0000,'','',1,'','',NULL,NULL,NULL,'wpl_properties','sp_featured',11,1,50,NULL,'1',1,'',1,1),(401,0,3,'Hot Offer','tag','{\"ribbon\":\"1\",\"widget\":\"1\",\"color\":\"d21a10\",\"text_color\":\"ffffff\",\"default_value\":\"0\"}',1,'1',1,1,1,1,0,3.0000,'','',1,'','',NULL,NULL,NULL,'wpl_properties','sp_hot',11,1,50,NULL,'1',1,'',1,1),(402,0,3,'Open House','tag','{\"ribbon\":\"1\",\"widget\":\"1\",\"color\":\"3cae2c\",\"text_color\":\"ffffff\",\"default_value\":\"0\"}',1,'1',1,1,1,1,0,4.0000,'','',1,'','',NULL,NULL,NULL,'wpl_properties','sp_openhouse',11,1,60,NULL,'1',1,'',1,1),(403,0,3,'Foreclosure','tag','{\"ribbon\":\"1\",\"widget\":\"1\",\"color\":\"666666\",\"text_color\":\"ffffff\",\"default_value\":\"0\"}',1,'1',1,1,1,1,0,6.0000,'','',1,'','',NULL,NULL,NULL,'wpl_properties','sp_forclosure',11,1,60,NULL,'1',1,'',1,1),(567,0,0,'Add On Video','addon_video','{\"ext_file\":\"avi,flv,mp4,swf,wmv\",\"file_size\":\"100000\"}',1,'0',0,0,1,1,0,1.0000,'','',1,'','',NULL,NULL,NULL,'wpl_properties','',7,1,0,'','1',0,'',1,0),(900,2,1,'First Name','text','',1,'1',1,1,1,1,0,1.0000,'','',1,'','',NULL,NULL,NULL,'wpl_users','first_name',10,1,0,NULL,'1',1,'',1,1),(901,2,1,'Last Name','text','',1,'1',1,1,1,1,0,2.0000,'','',1,'','',NULL,NULL,NULL,'wpl_users','last_name',10,1,0,NULL,'1',1,'',1,1),(902,2,0,'Company Name','text','',1,'1',1,1,1,1,0,3.0000,'','',1,'','',NULL,NULL,NULL,'wpl_users','company_name',10,1,0,NULL,'1',1,'',1,1),(903,2,0,'Company Address','text','',1,'1',1,1,1,1,0,4.0000,'','',1,'','',NULL,NULL,NULL,'wpl_users','company_address',10,1,0,NULL,'1',1,'',1,1),(904,2,0,'Website','text','',1,'1',1,1,1,1,1,5.0000,'','',1,'','',NULL,NULL,NULL,'wpl_users','website',10,1,0,NULL,'1',1,'',1,1),(905,2,0,'Secondary Email','text','',1,'1',1,1,1,1,0,6.0000,'','',1,'','',NULL,NULL,NULL,'wpl_users','secondary_email',10,1,0,NULL,'1',1,'',1,1),(906,2,0,'Gender','select','{\"params\":{\"1\":{\"key\":\"1\",\"enabled\":\"1\",\"value\":\"Male\"},\"2\":{\"key\":\"2\",\"enabled\":\"1\",\"value\":\"Female\"}}}',1,'1',1,1,1,1,0,2.2000,'','',1,'','',NULL,NULL,NULL,'wpl_users','sex',10,1,0,NULL,'1',1,'',1,1),(907,2,0,'Tel','text','',1,'1',1,1,1,1,1,8.0000,'','',1,'','',NULL,NULL,NULL,'wpl_users','tel',10,1,0,NULL,'1',1,'',1,1),(908,2,0,'Fax','text','',1,'1',1,1,1,1,1,9.0000,'','',1,'','',NULL,NULL,NULL,'wpl_users','fax',10,1,0,NULL,'1',1,'',1,1),(909,2,0,'Mobile','text','',1,'1',1,1,1,1,1,10.0000,'','',1,'','',NULL,NULL,NULL,'wpl_users','mobile',10,1,0,NULL,'1',1,'',1,1),(910,2,0,'Location Text','text','{\"if_zero\":\"1\",\"call_text\":\"Call\"}',2,'0',0,0,0,1,0,10.0550,'','',0,'','','','','','wpl_users','location_text',10,0,0,'','0',0,'',1,1),(911,2,0,'Location','locations','',1,'1',1,1,1,1,0,11.0000,'','',1,'','',NULL,NULL,NULL,'wpl_users','locations',10,0,0,'','1',1,'',1,2),(912,2,0,'Profile Picture','upload','{\"params\":{\"request_str\":\"?wpl_format=b:users:ajax&wpl_function=upload_file&file_name=[html_element_id]&item_id=[item_id]\"},\"preview\":1,\"remove_str\":\"wpl_format=b:users:ajax&wpl_function=delete_file&item_id=[item_id]\"}',1,'0',0,0,0,0,0,2.2500,'','',1,'','',NULL,NULL,NULL,'wpl_users','profile_picture',10,0,0,'','1',0,'',1,1),(913,2,0,'Company Logo','upload','{\"params\":{\"request_str\":\"?wpl_format=b:users:ajax&wpl_function=upload_file&file_name=[html_element_id]&item_id=[item_id]\"},\"preview\":1,\"remove_str\":\"wpl_format=b:users:ajax&wpl_function=delete_file&item_id=[item_id]\"}',1,'0',0,0,0,0,0,2.3000,'','',1,'','',NULL,NULL,NULL,'wpl_users','company_logo',10,0,0,'','1',0,'',1,1),(914,2,0,'Email','text','',1,'1',1,1,1,1,0,5.5000,'','',1,'','',NULL,NULL,NULL,'wpl_users','main_email',10,1,0,NULL,'1',1,'',1,1),(915,2,0,'Personal Data','separator','null',1,'0',0,0,1,1,1,10.0000,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,'wpl_users',NULL,10,1,0,NULL,'1',1,NULL,1,0),(916,2,0,'Company Data','separator','null',1,'0',0,0,1,1,1,10.0600,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,'wpl_users',NULL,10,1,0,NULL,'1',1,NULL,1,0),(917,2,0,'Contact information','separator','null',1,'0',0,0,1,1,1,10.1000,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,'wpl_users',NULL,10,1,0,NULL,'1',1,NULL,1,0),(918,2,0,'About','textarea','{\"advanced_editor\":\"0\",\"rows\":\"7\",\"cols\":\"41\"}',1,'1',1,1,1,1,1,10.0350,NULL,NULL,1,'','','',NULL,NULL,'wpl_users','about',10,1,0,NULL,'1',1,NULL,1,1);
CREATE TABLE `wp_wpl_dbst_types` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `kind` varchar(255) NOT NULL DEFAULT '[0][1]',
  `type` varchar(20) NOT NULL,
  `enabled` tinyint(4) NOT NULL COMMENT '0=no,1=yes,2=always',
  `index` float(5,2) NOT NULL DEFAULT '1.00',
  `queries_add` text NOT NULL,
  `queries_delete` text NOT NULL,
  `options` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;
INSERT INTO `wp_wpl_dbst_types` VALUES (1,'[0][1][2][4]','text',1,1.00,'ALTER TABLE `wp_[TABLE_NAME]` ADD `field_[FIELD_ID]` varchar(50) NULL; UPDATE `wp_wpl_dbst` SET `table_name`=\'[TABLE_NAME]\', `table_column`=\'field_[FIELD_ID]\' WHERE id=[FIELD_ID];','ALTER TABLE `wp_[TABLE_NAME]`\nDROP `field_[FIELD_ID]`;',NULL),(2,'[0][1][2][4]','number',1,1.00,'ALTER TABLE `wp_[TABLE_NAME]` ADD `field_[FIELD_ID]` float NULL; UPDATE `wp_wpl_dbst` SET `table_name`=\'[TABLE_NAME]\', `table_column`=\'field_[FIELD_ID]\' WHERE id=[FIELD_ID];','ALTER TABLE `wp_[TABLE_NAME]`\nDROP `field_[FIELD_ID]`;',NULL),(3,'[0][1][2][4]','select',1,1.00,'ALTER TABLE `wp_[TABLE_NAME]` ADD `field_[FIELD_ID]` int(11) NULL; UPDATE `wp_wpl_dbst` SET `table_name`=\'[TABLE_NAME]\', `table_column`=\'field_[FIELD_ID]\' WHERE id=[FIELD_ID];','ALTER TABLE `wp_[TABLE_NAME]` DROP `field_[FIELD_ID]`;',NULL),(4,'[0][1][4]','feature',1,1.00,'ALTER TABLE `wp_[TABLE_NAME]` ADD `f_[FIELD_ID]_options` text NULL; ALTER TABLE `wp_[TABLE_NAME]` ADD `f_[FIELD_ID]` tinyint(4) NULL; UPDATE `wp_wpl_dbst` SET `table_name`=\'[TABLE_NAME]\', `table_column`=\'f_[FIELD_ID]\' WHERE id=[FIELD_ID];','ALTER TABLE `wp_[TABLE_NAME]`\nDROP `f_[FIELD_ID]_options`;ALTER TABLE `wp_[TABLE_NAME]`\nDROP `f_[FIELD_ID]`;',NULL),(5,'[0][1][2][4]','textarea',1,1.00,'ALTER TABLE `wp_[TABLE_NAME]` ADD `field_[FIELD_ID]` text NULL; UPDATE `wp_wpl_dbst` SET `table_name`=\'[TABLE_NAME]\', `table_column`=\'field_[FIELD_ID]\' WHERE id=[FIELD_ID];','ALTER TABLE `wp_[TABLE_NAME]` DROP `field_[FIELD_ID]`;',NULL),(6,'[0][1][2][4]','separator',1,1.00,'','',NULL),(7,'[0][1][4]','neighborhood',1,1.00,'ALTER TABLE `wp_[TABLE_NAME]` ADD `n_[FIELD_ID]` tinyint(4) NULL; ALTER TABLE `wp_[TABLE_NAME]` ADD `n_[FIELD_ID]_distance` int NULL; ALTER TABLE `wp_[TABLE_NAME]` ADD `n_[FIELD_ID]_distance_by` tinyint(4) NULL; UPDATE `wp_wpl_dbst` SET `table_name`=\'[TABLE_NAME]\', `table_column`=\'n_[FIELD_ID]\' WHERE id=[FIELD_ID];','ALTER TABLE `wp_[TABLE_NAME]`\nDROP `n_[FIELD_ID]`;ALTER TABLE `wp_[TABLE_NAME]`\nDROP `n_[FIELD_ID]_distance`;ALTER TABLE `wp_[TABLE_NAME]`\nDROP `n_[FIELD_ID]_distance_by`;',NULL),(8,'[0][1][4]','area',1,1.00,'ALTER TABLE `wp_[TABLE_NAME]` ADD `field_[FIELD_ID]` double NOT NULL DEFAULT \'0\'; ALTER TABLE `wp_[TABLE_NAME]` ADD `field_[FIELD_ID]_si` double NOT NULL DEFAULT \'0\'; ALTER TABLE `wp_[TABLE_NAME]` ADD `field_[FIELD_ID]_unit` int NULL; UPDATE `wp_wpl_dbst` SET `table_name`=\'[TABLE_NAME]\', `table_column`=\'field_[FIELD_ID]\' WHERE id=[FIELD_ID];','ALTER TABLE `wp_[TABLE_NAME]`\nDROP `field_[FIELD_ID]`;ALTER TABLE `wp_[TABLE_NAME]`\nDROP `field_[FIELD_ID]_unit`;ALTER TABLE `wp_[TABLE_NAME]`\nDROP `field_[FIELD_ID]_si`;',NULL),(9,'[0][1][4]','length',1,1.00,'ALTER TABLE `wp_[TABLE_NAME]` ADD `field_[FIELD_ID]` double NOT NULL DEFAULT \'0\'; ALTER TABLE `wp_[TABLE_NAME]` ADD `field_[FIELD_ID]_si` double NOT NULL DEFAULT \'0\'; ALTER TABLE `wp_[TABLE_NAME]` ADD `field_[FIELD_ID]_unit` int NULL; UPDATE `wp_wpl_dbst` SET `table_name`=\'[TABLE_NAME]\', `table_column`=\'field_[FIELD_ID]\' WHERE id=[FIELD_ID];','ALTER TABLE `wp_[TABLE_NAME]`\nDROP `field_[FIELD_ID]`;ALTER TABLE `wp_[TABLE_NAME]`\nDROP `field_[FIELD_ID]_unit`;ALTER TABLE `wp_[TABLE_NAME]`\nDROP `field_[FIELD_ID]_si`;',NULL),(10,'[0][1][4]','volume',1,1.00,'ALTER TABLE `wp_[TABLE_NAME]` ADD `field_[FIELD_ID]` double NOT NULL DEFAULT \'0\'; ALTER TABLE `wp_[TABLE_NAME]` ADD `field_[FIELD_ID]_si` double NOT NULL DEFAULT \'0\'; ALTER TABLE `wp_[TABLE_NAME]` ADD `field_[FIELD_ID]_unit` int NULL; UPDATE `wp_wpl_dbst` SET `table_name`=\'[TABLE_NAME]\', `table_column`=\'field_[FIELD_ID]\' WHERE id=[FIELD_ID];','ALTER TABLE `wp_[TABLE_NAME]`\nDROP `field_[FIELD_ID]`;ALTER TABLE `wp_[TABLE_NAME]`\nDROP `field_[FIELD_ID]_unit`;ALTER TABLE `wp_[TABLE_NAME]`\nDROP `field_[FIELD_ID]_si`;',NULL),(11,'[0][1][2][4]','price',1,1.00,'ALTER TABLE `wp_[TABLE_NAME]` ADD `field_[FIELD_ID]` double NOT NULL DEFAULT \'0\'; ALTER TABLE `wp_[TABLE_NAME]` ADD `field_[FIELD_ID]_si` double NOT NULL DEFAULT \'0\'; ALTER TABLE `wp_[TABLE_NAME]` ADD `field_[FIELD_ID]_unit` int NULL; UPDATE `wp_wpl_dbst` SET `table_name`=\'[TABLE_NAME]\', `table_column`=\'field_[FIELD_ID]\' WHERE id=[FIELD_ID];','ALTER TABLE `wp_[TABLE_NAME]`\nDROP `field_[FIELD_ID]`;ALTER TABLE `wp_[TABLE_NAME]`\nDROP `field_[FIELD_ID]_unit`;ALTER TABLE `wp_[TABLE_NAME]`\nDROP `field_[FIELD_ID]_si`;',NULL),(12,'[0][1][2][4]','date',1,1.00,'ALTER TABLE `wp_[TABLE_NAME]` ADD `field_[FIELD_ID]` date NULL; UPDATE `wp_wpl_dbst` SET `table_name`=\'[TABLE_NAME]\', `table_column`=\'field_[FIELD_ID]\' WHERE id=[FIELD_ID];','ALTER TABLE `wp_[TABLE_NAME]`\nDROP `field_[FIELD_ID]`;',NULL),(13,'[0][1][2][4]','datetime',1,1.00,'ALTER TABLE `wp_[TABLE_NAME]` ADD `field_[FIELD_ID]` datetime NULL; UPDATE `wp_wpl_dbst` SET `table_name`=\'[TABLE_NAME]\', `table_column`=\'field_[FIELD_ID]\' WHERE id=[FIELD_ID];','ALTER TABLE `wp_[TABLE_NAME]`\nDROP `field_[FIELD_ID]`;',NULL),(14,'[0][1][2][4]','url',1,1.00,'ALTER TABLE `wp_[TABLE_NAME]` ADD `field_[FIELD_ID]` varchar(100) NULL; UPDATE `wp_wpl_dbst` SET `table_name`=\'[TABLE_NAME]\', `table_column`=\'field_[FIELD_ID]\' WHERE id=[FIELD_ID];','ALTER TABLE `wp_[TABLE_NAME]`\r\nDROP `field_[FIELD_ID]`;',NULL),(19,'[0][1][2][4]','boolean',1,19.00,'ALTER TABLE `wp_[TABLE_NAME]` ADD `field_[FIELD_ID]` TINYINT( 4 ) NOT NULL DEFAULT \'[DEFAULT_VALUE]\'; UPDATE `wp_wpl_dbst` SET `table_name`=\'[TABLE_NAME]\', `table_column`=\'field_[FIELD_ID]\' WHERE id=[FIELD_ID];','ALTER TABLE `wp_[TABLE_NAME]`\r\nDROP `field_[FIELD_ID]`;',NULL),(20,'[0][1][2][4]','checkbox',1,20.00,'ALTER TABLE `wp_[TABLE_NAME]` ADD `field_[FIELD_ID]` TINYINT( 4 ) NOT NULL DEFAULT \'0\'; UPDATE `wp_wpl_dbst` SET `table_name`=\'[TABLE_NAME]\', `table_column`=\'field_[FIELD_ID]\' WHERE id=[FIELD_ID];','ALTER TABLE `wp_[TABLE_NAME]`\r\nDROP `field_[FIELD_ID]`;',NULL);
CREATE TABLE `wp_wpl_events` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(50) NOT NULL,
  `trigger` varchar(100) NOT NULL,
  `class_location` varchar(200) NOT NULL,
  `class_name` varchar(100) NOT NULL,
  `function_name` varchar(100) NOT NULL,
  `params` text NOT NULL,
  `enabled` tinyint(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8;
INSERT INTO `wp_wpl_events` VALUES (4,'notification','contact_agent','libraries.event_handlers.notifications','wpl_events_notifications','contact_agent','',1),(5,'notification','contact_profile','libraries.event_handlers.notifications','wpl_events_notifications','contact_profile','',1),(39,'notification','user_registered','libraries.event_handlers.notifications','wpl_events_notifications','user_registered','',1),(40,'notification','request_a_visit_send','libraries.event_handlers.notifications','wpl_events_notifications','request_a_visit','',1),(41,'notification','send_to_friend','libraries.event_handlers.notifications','wpl_events_notifications','send_to_friend','',1),(42,'notification','add_property','libraries.event_handlers.notifications','wpl_events_notifications','listing_create','',1);
CREATE TABLE `wp_wpl_extensions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(20) CHARACTER SET latin1 NOT NULL,
  `title` varchar(200) CHARACTER SET latin1 NOT NULL,
  `parent` int(10) NOT NULL DEFAULT '0',
  `description` text CHARACTER SET latin1 NOT NULL,
  `enabled` tinyint(4) NOT NULL DEFAULT '1',
  `param1` varchar(200) CHARACTER SET latin1 NOT NULL,
  `param2` text CHARACTER SET latin1 NOT NULL,
  `param3` varchar(200) CHARACTER SET latin1 NOT NULL,
  `param4` varchar(200) CHARACTER SET latin1 NOT NULL,
  `param5` varchar(200) CHARACTER SET latin1 NOT NULL,
  `params` text CHARACTER SET latin1 NOT NULL,
  `editable` tinyint(4) NOT NULL DEFAULT '1',
  `index` float(5,2) NOT NULL DEFAULT '99.99',
  `client` tinyint(4) NOT NULL DEFAULT '2',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=132 DEFAULT CHARSET=utf8;
INSERT INTO `wp_wpl_extensions` VALUES (1,'action','Admin menu',0,'This extension generates admin menu',1,'admin_menu','wpl_extensions->wpl_admin_menus','','','','',0,99.99,2),(2,'shortcode','property listing shortcode',0,'it used for showing property listing',1,'wpl_property_listings','wpl_controller->f:property_listing:display','','','','',0,99.99,2),(3,'style','WPL backend stylesheet',0,'',1,'wpl_backend_main_style','css/backend.css','','','','',0,99.99,1),(5,'javascript','jQuery',0,'',1,'jquery','','','','','',0,0.00,2),(6,'javascript','WPL backend javascript',0,'',1,'wpl_backend_javascript','js/backend.min.js','','','','',0,100.10,1),(9,'widget','WPL Search Widget',0,'',1,'widgets.search.main','widgets_init','WPL_search_widget','','','',0,99.99,2),(10,'shortcode','Property Show shortcode',0,'it can be used for showing a specific listing',1,'wpl_property_show','wpl_controller->f:property_show:display','','','','',0,99.99,2),(11,'service','SEF service',0,'For running SEF service',1,'template_redirect','sef->run','9999','','','',0,99.99,2),(12,'shortcode','Profile Listing shortcode',0,'it can be used for showing a profile (Agent) listing',1,'wpl_profile_listing','wpl_controller->f:profile_listing:display','','','','',0,99.99,2),(13,'style','WPL frontend stylesheet',0,'',1,'wpl_frontend_main_style','css/frontend.css','','','','',0,99.99,0),(14,'widget','WPL Carousel Widget',0,'',1,'widgets.carousel.main','widgets_init','WPL_carousel_widget','','','',0,99.99,2),(15,'action','Admin bar menu',0,'This extension generates admin bar menu',1,'admin_bar_menu','wpl_extensions->wpl_admin_bar_menu','999','','','',0,99.99,2),(16,'javascript','WPL frontend javascript',0,'',1,'wpl_frontend_javascript','js/frontend.min.js','','','','',0,100.10,0),(18,'service','IO service',0,'For running IO commands',1,'wp','io->run','9999','','','',0,99.99,0),(20,'widget','WPL Agents Widget',0,'',1,'widgets.agents.main','widgets_init','WPL_agents_widget','','','',0,99.99,2),(21,'sidebar','Property Show Bottom',0,'Appears on bottom of single property/property show page',1,'wpl-pshow-bottom','','','','','',0,99.99,2),(22,'sidebar','Profile Show Top',0,'Appears on top of agent show/profile show page',1,'wpl-profileshow-top','','','','','',0,99.99,2),(24,'sidebar','Property Listing Top',0,'Appears below of Google map in property listing page',1,'wpl-plisting-top','','','','','',0,99.99,2),(26,'sidebar','Profile Listing Top',0,'Appears in Profile listing page',1,'wpl-profile-listing-top','','','','','',0,99.99,2),(27,'sidebar','WPL Hidden',0,'Appears no where! Use it for widget short-codes.',1,'wpl-hidden','','','','','',0,99.99,2),(31,'shortcode','my profile shortcode',0,'it used for showing my profile',1,'wpl_my_profile','wpl_html->load_profile_wizard','','','','',0,99.99,2),(34,'shortcode','Profile show shortcode',0,'it used for showing a profile',1,'wpl_profile_show','wpl_controller->f:profile_show:display','','','','',0,99.99,2),(36,'service','Helps Service',0,'For running WPL Helps',1,'init','helps->run','9999','','','',0,99.99,1),(88,'javascript','jQuery UI',0,'',1,'jquery-ui-core','','','','','',0,88.00,2),(89,'javascript','jQuery UI sortable',0,'',1,'jquery-ui-sortable','','','','','',0,89.00,2),(99,'style','Googlefont',0,'',1,'wpl-google-font','//fonts.googleapis.com/css?family=Droid+Serif:400,700,400italic,700italic|Open+Sans:300italic,400italic,600italic,700italic,400,300,600,700|Scada:400italic,700italic,400,700|Archivo+Narrow:400,40|Lato:400,700,900,400italic|BenchNine|Roboto:400,700','','','1','',0,35.00,2),(101,'javascript','Chosen',0,'',1,'ChosenJS','js/libraries/wpl.jquery.chosen.min.js','','','','',0,100.00,2),(102,'javascript','customScrollBarJS',0,'',1,'customScrollBarJS','js/libraries/wpl.jquery.mcustomscrollbar.min.js','','','','',0,100.00,2),(103,'javascript','Transit',0,'',1,'transit','js/libraries/wpl.jquery.transit.min.js','','','','',0,100.00,1),(104,'javascript','HoverIntent',0,'',1,'hoverIntent','js/libraries/wpl.jquery.hoverintent.js','','','','',0,100.00,1),(105,'javascript','AjaxFileUpload',0,'',1,'ajaxFileUpload','js/libraries/wpl.ajaxfileupload.min.js','','','','',0,100.00,2),(108,'javascript','Modernizr',0,'',1,'modernizer','js/libraries/wpl.modernizr.min.js','','','','',0,99.99,0),(109,'javascript','Handlebars',0,'',1,'handlebars','js/libraries/wpl.handlebars.min.js','','','','',0,109.99,2),(110,'javascript','qTips',0,'',1,'qtips','js/libraries/wpl.jquery.qtip.min.js','','','','',0,110.00,2),(111,'javascript','ImageLoaded',0,'',1,'imageloaded','js/libraries/wpl.imagesloaded.min.js','','','','',0,110.01,1),(114,'javascript','Spinner',0,'',1,'spinner','js/libraries/wpl.jquery.spin.min.js','','','','',0,100.10,2),(115,'javascript','Realtyna-Lightbox',0,'',1,'realtyna-lightbox','js/libraries/realtyna/realtyna.lightbox.min.js','','','','',0,200.10,2),(116,'javascript','Realtyna Framework',0,'',1,'realtyna-framework','js/libraries/realtyna/realtyna.min.js','','','','',0,200.00,2),(117,'javascript','Realtyna Utility',0,'',1,'realtyna-utility','js/libraries/realtyna/realtyna.utility.min.js','','','','',0,200.01,2),(118,'javascript','Realtyna Tagging',0,'',1,'realtyna-tagging','js/libraries/realtyna/realtyna.tagging.min.js','','','','',0,202.00,2),(123,'javascript','jQuery Time Picker',0,'',1,'jquery-time-picker','js/libraries/wpl.jquery.timepicker.min.js','','','','',0,202.00,2),(124,'action','User Login',0,'Calls after user login',1,'wp_login','wpl_users->user_loggedin','10','2','','',0,99.99,2),(129,'javascript','WPL Common javascript',0,'',1,'wpl_common_javascript','js/wpl.commons.min.js','','','','',0,100.11,2),(131,'service','WPL Service',0,'For running WPL service',1,'init','wpl->run','9999','','','',0,99.99,2);
CREATE TABLE `wp_wpl_filters` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(50) NOT NULL,
  `trigger` varchar(100) NOT NULL,
  `class_location` varchar(200) NOT NULL,
  `class_name` varchar(100) NOT NULL,
  `function_name` varchar(100) NOT NULL,
  `params` text NOT NULL,
  `enabled` tinyint(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `wp_wpl_item_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_type` varchar(100) DEFAULT NULL,
  `category_name` varchar(100) DEFAULT NULL,
  `index` float(5,2) NOT NULL DEFAULT '99.00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
INSERT INTO `wp_wpl_item_categories` VALUES (1,'gallery','image',99.00),(2,'gallery','floorplan',99.01),(3,'attachment','attachment',99.00),(4,'addon_video','video',99.00);
CREATE TABLE `wp_wpl_items` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `parent_kind` varchar(20) NOT NULL DEFAULT '0',
  `parent_id` int(10) DEFAULT NULL,
  `item_type` varchar(100) DEFAULT NULL,
  `item_cat` varchar(100) DEFAULT NULL,
  `item_name` varchar(255) DEFAULT NULL,
  `creation_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `edit_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `enabled` tinyint(4) NOT NULL DEFAULT '1',
  `item_extra1` text,
  `item_extra2` text,
  `item_extra3` text,
  `item_extra4` text,
  `item_extra5` text,
  `params` text,
  `index` float(5,2) NOT NULL DEFAULT '99.00',
  PRIMARY KEY (`id`),
  KEY `parent_type` (`parent_kind`,`parent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `wp_wpl_kinds` (
  `id` int(10) unsigned NOT NULL,
  `name` varchar(100) NOT NULL,
  `table` varchar(100) NOT NULL,
  `plural` varchar(100) DEFAULT NULL,
  `dbcat` tinyint(4) NOT NULL DEFAULT '1',
  `addon_name` varchar(100) DEFAULT NULL,
  `map` varchar(10) DEFAULT 'marker',
  `index` float(6,3) NOT NULL DEFAULT '99.000',
  `params` text,
  `enabled` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `wp_wpl_kinds` VALUES (0,'Property','wpl_properties','Properties',1,'','marker',99.000,NULL,1),(2,'User','wpl_users','Users',0,'membership','marker',99.000,NULL,1);
CREATE TABLE `wp_wpl_listing_types` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `parent` int(10) unsigned NOT NULL DEFAULT '0',
  `enabled` tinyint(4) NOT NULL DEFAULT '1',
  `editable` tinyint(4) NOT NULL DEFAULT '2',
  `index` float(5,2) NOT NULL DEFAULT '99.00',
  `gicon` varchar(100) DEFAULT NULL,
  `caption_img` varchar(100) DEFAULT NULL,
  `name` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;
INSERT INTO `wp_wpl_listing_types` VALUES (1,0,0,1,1.00,'','','Sale'),(2,0,0,1,2.00,'','','Rental'),(3,0,0,1,3.00,'','','Vacational'),(9,1,1,2,0.00,'dot-blue.png','','For sale'),(10,2,1,2,12.00,'dot-green.png','','For Rent'),(12,3,1,2,19.00,'dot-orange.png','','Vacation Rental');
CREATE TABLE `wp_wpl_location1` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `enabled` tinyint(4) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `abbr` varchar(100) DEFAULT NULL,
  `tax_percent` double DEFAULT NULL,
  `latitude` varchar(25) DEFAULT NULL,
  `longitude` varchar(25) DEFAULT NULL,
  `params` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=277 DEFAULT CHARSET=utf8;
INSERT INTO `wp_wpl_location1` VALUES (1,0,'Afghanistan',NULL,0,'','',''),(2,0,'albania',NULL,0,'','',''),(3,0,'Algeria',NULL,0,'','',''),(4,0,'American Samoa',NULL,0,'','',''),(5,0,'Andorra',NULL,0,'','',''),(6,0,'Angola',NULL,0,'','',''),(7,0,'Anguilla',NULL,0,'','',''),(8,0,'Antarctica',NULL,0,'','',''),(9,0,'Antigua and Barbuda',NULL,0,'','',''),(10,0,'Argentina',NULL,0,'','',''),(11,0,'Armenia',NULL,0,'','',''),(12,0,'Aruba',NULL,0,'','',''),(13,0,'Ashmore and Cartier',NULL,0,'','',''),(14,0,'Australia',NULL,0,'','',''),(15,0,'Austria',NULL,0,'','',''),(16,0,'Azerbaijan',NULL,0,'','',''),(17,0,'The Bahamas',NULL,0,'','',''),(18,0,'Bahrain',NULL,0,'','',''),(19,0,'Baker Island',NULL,0,'','',''),(20,0,'Bangladesh',NULL,0,'','',''),(21,0,'Barbados',NULL,0,'','',''),(22,0,'Bassas da India',NULL,0,'','',''),(23,0,'Belarus',NULL,0,'','',''),(24,0,'Belgium',NULL,0,'','',''),(25,0,'Belize',NULL,0,'','',''),(26,0,'Benin',NULL,0,'','',''),(27,0,'Bermuda',NULL,0,'','',''),(28,0,'Bhutan',NULL,0,'','',''),(29,0,'Bolivia',NULL,0,'','',''),(30,0,'Bosnia and Herzegovina',NULL,0,'','',''),(31,0,'Botswana',NULL,0,'','',''),(32,0,'Bouvet Island',NULL,0,'','',''),(33,0,'Brazil',NULL,0,'','',''),(34,0,'British Indian Ocean Territory',NULL,0,'','',''),(35,0,'British Virgin Islands',NULL,0,'','',''),(36,0,'Brunei Darussalam',NULL,0,'','',''),(37,0,'Bulgaria',NULL,0,'','',''),(38,0,'Burkina Faso',NULL,0,'','',''),(39,0,'Burma',NULL,0,'','',''),(40,0,'Burundi',NULL,0,'','',''),(41,0,'Cambodia',NULL,0,'','',''),(42,0,'Cameroon',NULL,0,'','',''),(43,0,'Canada',NULL,0,'','',''),(44,0,'Cape Verde',NULL,0,'','',''),(45,0,'Cayman Islands',NULL,0,'','',''),(46,0,'Central African Republic',NULL,0,'','',''),(47,0,'Chad',NULL,0,'','',''),(48,0,'Chile',NULL,0,'','',''),(49,0,'China',NULL,0,'','',''),(50,0,'Christmas Island',NULL,0,'','',''),(51,0,'Clipperton Island',NULL,0,'','',''),(52,0,'Cocos (Keeling) Islands',NULL,0,'','',''),(53,0,'Colombia',NULL,0,'','',''),(54,0,'Comoros',NULL,0,'','',''),(55,0,'Congo ,  Democratic Republic of the',NULL,0,'','',''),(56,0,'Congo ,  Republic of the',NULL,0,'','',''),(57,0,'Cook Islands',NULL,0,'','',''),(58,0,'Coral Sea Islands',NULL,0,'','',''),(59,0,'Costa Rica',NULL,0,'','',''),(60,0,'Cote d\'Ivoire',NULL,0,'','',''),(61,0,'Croatia',NULL,0,'','',''),(62,0,'Cuba',NULL,0,'','',''),(63,0,'Cyprus',NULL,0,'','',''),(64,0,'Czech Republic',NULL,0,'','',''),(65,0,'Denmark',NULL,0,'','',''),(66,0,'Djibouti',NULL,0,'','',''),(67,0,'Dominica',NULL,0,'','',''),(68,0,'Dominican Republic',NULL,0,'','',''),(69,0,'East Timor',NULL,0,'','',''),(70,0,'Ecuador',NULL,0,'','',''),(71,0,'Egypt',NULL,0,'','',''),(72,0,'El Salvador',NULL,0,'','',''),(73,0,'Equatorial Guinea',NULL,0,'','',''),(74,0,'Eritrea',NULL,0,'','',''),(75,0,'Estonia',NULL,0,'','',''),(76,0,'Ethiopia',NULL,0,'','',''),(77,0,'Europa Island',NULL,0,'','',''),(78,0,'Falkland Islands (Islas Malvinas)',NULL,0,'','',''),(79,0,'Faroe Islands',NULL,0,'','',''),(80,0,'Fiji',NULL,0,'','',''),(81,0,'Finland',NULL,0,'','',''),(82,0,'France',NULL,0,'','',''),(83,0,'France ,  Metropolitan',NULL,0,'','',''),(84,0,'French Guiana',NULL,0,'','',''),(85,0,'French Polynesia',NULL,0,'','',''),(86,0,'French Southern and Antarctic Lands',NULL,0,'','',''),(87,0,'Gabon',NULL,0,'','',''),(88,0,'The Gambia',NULL,0,'','',''),(89,0,'Gaza Strip',NULL,0,'','',''),(90,0,'Georgia',NULL,0,'','',''),(91,0,'Germany',NULL,0,'','',''),(92,0,'Ghana',NULL,0,'','',''),(93,0,'Gibraltar',NULL,0,'','',''),(94,0,'Glorioso Islands',NULL,0,'','',''),(95,0,'Greece',NULL,0,'','',''),(96,0,'Greenland',NULL,0,'','',''),(97,0,'Grenada',NULL,0,'','',''),(98,0,'Guadeloupe',NULL,0,'','',''),(99,0,'Guam',NULL,0,'','',''),(100,0,'Guatemala',NULL,0,'','',''),(101,0,'Guernsey',NULL,0,'','',''),(102,0,'Guinea',NULL,0,'','',''),(103,0,'Guinea-Bissau',NULL,0,'','',''),(104,0,'Guyana',NULL,0,'','',''),(105,0,'Haiti',NULL,0,'','',''),(106,0,'Heard Island and McDonald Islands',NULL,0,'','',''),(107,0,'Holy See (Vatican City)',NULL,0,'','',''),(108,0,'Honduras',NULL,0,'','',''),(109,0,'Hong Kong (SAR)',NULL,0,'','',''),(110,0,'Howland Island',NULL,0,'','',''),(111,0,'Hungary',NULL,0,'','',''),(112,0,'Iceland',NULL,0,'','',''),(113,0,'India',NULL,0,'','',''),(114,0,'Indonesia',NULL,0,'','',''),(115,0,'Iran',NULL,0,'','',''),(116,0,'Iraq',NULL,0,'','',''),(117,0,'Ireland',NULL,0,'','',''),(118,0,'Israel',NULL,0,'','',''),(119,0,'Italy',NULL,0,'','',''),(120,0,'Jamaica',NULL,0,'','',''),(121,0,'Jan Mayen',NULL,0,'','',''),(122,0,'Japan',NULL,0,'','',''),(123,0,'Jarvis Island',NULL,0,'','',''),(124,0,'Jersey',NULL,0,'','',''),(125,0,'Johnston Atoll',NULL,0,'','',''),(126,0,'Jordan',NULL,0,'','',''),(127,0,'Juan de Nova Island',NULL,0,'','',''),(128,0,'Kazakhstan',NULL,0,'','',''),(129,0,'Kenya',NULL,0,'','',''),(130,0,'Kingman Reef',NULL,0,'','',''),(131,0,'Kiribati',NULL,0,'','',''),(132,0,'Korea ,  North',NULL,0,'','',''),(133,0,'Korea ,  South',NULL,0,'','',''),(134,0,'Kuwait',NULL,0,'','',''),(135,0,'Kyrgyzstan',NULL,0,'','',''),(136,0,'Laos',NULL,0,'','',''),(137,0,'Latvia',NULL,0,'','',''),(138,0,'Lebanon',NULL,0,'','',''),(139,0,'Lesotho',NULL,0,'','',''),(140,0,'Liberia',NULL,0,'','',''),(141,0,'Libya',NULL,0,'','',''),(142,0,'Liechtenstein',NULL,0,'','',''),(143,0,'Lithuania',NULL,0,'','',''),(144,0,'Luxembourg',NULL,0,'','',''),(145,0,'Macao',NULL,0,'','',''),(146,0,'Macedonia ,  The Former Yugoslav Republic of',NULL,0,'','',''),(147,0,'Madagascar',NULL,0,'','',''),(148,0,'Malawi',NULL,0,'','',''),(149,0,'Malaysia',NULL,0,'','',''),(150,0,'Maldives',NULL,0,'','',''),(151,0,'Mali',NULL,0,'','',''),(152,0,'Malta',NULL,0,'','',''),(153,0,'Man ,  Isle of',NULL,0,'','',''),(154,0,'Marshall Islands',NULL,0,'','',''),(155,0,'Martinique',NULL,0,'','',''),(156,0,'Mauritania',NULL,0,'','',''),(157,0,'Mauritius',NULL,0,'','',''),(158,0,'Mayotte',NULL,0,'','',''),(159,0,'Mexico',NULL,0,'','',''),(160,0,'Micronesia ,  Federated States of',NULL,0,'','',''),(161,0,'Midway Islands',NULL,0,'','',''),(162,0,'Miscellaneous (French)',NULL,0,'','',''),(163,0,'Moldova',NULL,0,'','',''),(164,0,'Monaco',NULL,0,'','',''),(165,0,'Mongolia',NULL,0,'','',''),(166,0,'Montenegro',NULL,0,'','',''),(167,0,'Montserrat',NULL,0,'','',''),(168,0,'Morocco',NULL,0,'','',''),(169,0,'Mozambique',NULL,0,'','',''),(170,0,'Myanmar',NULL,0,'','',''),(171,0,'Namibia',NULL,0,'','',''),(172,0,'Nauru',NULL,0,'','',''),(173,0,'Navassa Island',NULL,0,'','',''),(174,0,'Nepal',NULL,0,'','',''),(175,0,'Netherlands',NULL,0,'','',''),(176,0,'Netherlands Antilles',NULL,0,'','',''),(177,0,'New Caledonia',NULL,0,'','',''),(178,0,'New Zealand',NULL,0,'','',''),(179,0,'Nicaragua',NULL,0,'','',''),(180,0,'Niger',NULL,0,'','',''),(181,0,'Nigeria',NULL,0,'','',''),(182,0,'Niue',NULL,0,'','',''),(183,0,'Norfolk Island',NULL,0,'','',''),(184,0,'Northern Mariana Islands',NULL,0,'','',''),(185,0,'Norway',NULL,0,'','',''),(186,0,'Oman',NULL,0,'','',''),(187,0,'Pakistan',NULL,0,'','',''),(188,0,'Palau',NULL,0,'','',''),(189,0,'Palmyra Atoll',NULL,0,'','',''),(190,0,'Panama',NULL,0,'','',''),(191,0,'Papua New Guinea',NULL,0,'','',''),(192,0,'Paracel Islands',NULL,0,'','',''),(193,0,'Paraguay',NULL,0,'','',''),(194,0,'Peru',NULL,0,'','',''),(195,0,'Philippines',NULL,0,'','',''),(196,0,'Pitcairn Islands',NULL,0,'','',''),(197,0,'Poland',NULL,0,'','',''),(198,0,'Portugal',NULL,0,'','',''),(199,0,'Puerto Rico',NULL,0,'','',''),(200,0,'Qatar',NULL,0,'','',''),(201,0,'R',NULL,0,'','',''),(202,0,'Romania',NULL,0,'','',''),(203,0,'Russia',NULL,0,'','',''),(204,0,'Rwanda',NULL,0,'','',''),(205,0,'Saint Helena',NULL,0,'','',''),(206,0,'Saint Kitts and Nevis',NULL,0,'','',''),(207,0,'Saint Lucia',NULL,0,'','',''),(208,0,'Saint Pierre and Miquelon',NULL,0,'','',''),(209,0,'Saint Vincent and the Grenadines',NULL,0,'','',''),(210,0,'Samoa',NULL,0,'','',''),(211,0,'San Marino',NULL,0,'','',''),(212,0,'S?o Tom',NULL,0,'','',''),(213,0,'Saudi Arabia',NULL,0,'','',''),(214,0,'Senegal',NULL,0,'','',''),(215,0,'Serbia',NULL,0,'','',''),(216,0,'Serbia and Montenegro',NULL,0,'','',''),(217,0,'Seychelles',NULL,0,'','',''),(218,0,'Sierra Leone',NULL,0,'','',''),(219,0,'Singapore',NULL,0,'','',''),(220,0,'Slovakia',NULL,0,'','',''),(221,0,'Slovenia',NULL,0,'','',''),(222,0,'Solomon Islands',NULL,0,'','',''),(223,0,'Somalia',NULL,0,'','',''),(224,0,'South Africa',NULL,0,'','',''),(225,0,'South Georgia and the South Sandwich Islands',NULL,0,'','',''),(226,0,'Spain',NULL,0,'','',''),(227,0,'Spratly Islands',NULL,0,'','',''),(228,0,'Sri Lanka',NULL,0,'','',''),(229,0,'Sudan',NULL,0,'','',''),(230,0,'Suriname',NULL,0,'','',''),(231,0,'Svalbard',NULL,0,'','',''),(232,0,'Swaziland',NULL,0,'','',''),(233,0,'Sweden',NULL,0,'','',''),(234,0,'Switzerland',NULL,0,'','',''),(235,0,'Syria',NULL,0,'','',''),(236,0,'Taiwan',NULL,0,'','',''),(237,0,'Tajikistan',NULL,0,'','',''),(238,0,'Tanzania',NULL,0,'','',''),(239,0,'Thailand',NULL,0,'','',''),(240,0,'Togo',NULL,0,'','',''),(241,0,'Tokelau',NULL,0,'','',''),(242,0,'Tonga',NULL,0,'','',''),(243,0,'Trinidad and Tobago',NULL,0,'','',''),(244,0,'Tromelin Island',NULL,0,'','',''),(245,0,'Tunisia',NULL,0,'','',''),(246,0,'Turkey',NULL,0,'','',''),(247,0,'Turkmenistan',NULL,0,'','',''),(248,0,'Turks and Caicos Islands',NULL,0,'','',''),(249,0,'Tuvalu',NULL,0,'','',''),(250,0,'Uganda',NULL,0,'','',''),(251,0,'Ukraine',NULL,0,'','',''),(252,0,'United Arab Emirates',NULL,0,'','',''),(253,0,'United Kingdom',NULL,0,'','',''),(254,1,'United States','US',0,'','',''),(255,0,'United States Minor Outlying Islands',NULL,0,'','',''),(256,0,'Uruguay',NULL,0,'','',''),(257,0,'Uzbekistan',NULL,0,'','',''),(258,0,'Vanuatu',NULL,0,'','',''),(259,0,'Venezuela',NULL,0,'','',''),(260,0,'Vietnam',NULL,0,'','',''),(261,0,'Virgin Islands',NULL,0,'','',''),(262,0,'Virgin Islands (UK)',NULL,0,'','',''),(263,0,'Virgin Islands (US)',NULL,0,'','',''),(264,0,'Wake Island',NULL,0,'','',''),(265,0,'Wallis and Futuna',NULL,0,'','',''),(266,0,'West Bank',NULL,0,'','',''),(267,0,'Western Sahara',NULL,0,'','',''),(268,0,'Western Samoa',NULL,0,'','',''),(269,0,'World',NULL,0,'','',''),(270,0,'Yemen',NULL,0,'','',''),(271,0,'Yugoslavia',NULL,0,'','',''),(272,0,'Zaire',NULL,0,'','',''),(273,0,'Zambia',NULL,0,'','',''),(274,0,'Zimbabwe',NULL,0,'','',''),(275,0,'Palestinian Territory ,  Occupied',NULL,0,'','',''),(276,1,'Australia','AU',NULL,NULL,NULL,NULL);
CREATE TABLE `wp_wpl_location2` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `parent` bigint(20) unsigned NOT NULL DEFAULT '0',
  `name` varchar(100) DEFAULT NULL,
  `abbr` varchar(100) DEFAULT NULL,
  `tax_percent` double DEFAULT NULL,
  `latitude` varchar(25) DEFAULT NULL,
  `longitude` varchar(25) DEFAULT NULL,
  `params` text,
  PRIMARY KEY (`id`),
  KEY `parent` (`parent`)
) ENGINE=InnoDB AUTO_INCREMENT=6064 DEFAULT CHARSET=utf8;
INSERT INTO `wp_wpl_location2` VALUES (6001,254,'Alabama','AL',0,'','',''),(6002,254,'Alaska','AK',0,'','',''),(6003,254,'American Samoa','AS',0,'','',''),(6004,254,'Arizona','AZ',0,'','',''),(6005,254,'Arkansas','AR',0,'','',''),(6006,254,'California','CA',0,'','',''),(6007,254,'Colorado','CO',0,'','',''),(6008,254,'Connecticut','CT',0,'','',''),(6009,254,'Delaware','DE',0,'','',''),(6010,254,'District Of Columbia','DC',0,'','',''),(6011,254,'Federated States of Micronesia','FM',0,'','',''),(6012,254,'Florida','FL',0,'','',''),(6013,254,'Georgia','GA',0,'','',''),(6014,254,'Guam','GU',0,'','',''),(6015,254,'Hawaii','HI',0,'','',''),(6016,254,'Idaho','ID',0,'','',''),(6017,254,'Illinois','IL',0,'','',''),(6018,254,'Indiana','IN',0,'','',''),(6019,254,'Iowa','IA',0,'','',''),(6020,254,'Kansas','KS',0,'','',''),(6021,254,'Kentucky','KY',0,'','',''),(6022,254,'Louisiana','LA',0,'','',''),(6023,254,'Maine','ME',0,'','',''),(6024,254,'Marshall Islands','MH',0,'','',''),(6025,254,'Maryland','MD',0,'','',''),(6026,254,'Massachusetts','MA',0,'','',''),(6027,254,'Michigan','MI',0,'','',''),(6028,254,'Minnesota','MN',0,'','',''),(6029,254,'Minor Outlying Islands','UM',0,'','',''),(6030,254,'Mississippi','MS',0,'','',''),(6031,254,'Missouri','MO',0,'','',''),(6032,254,'Montana','MT',0,'','',''),(6033,254,'Nebraska','NE',0,'','',''),(6034,254,'Nevada','NV',0,'','',''),(6035,254,'New Hampshire','NH',0,'','',''),(6036,254,'New Jersey','NJ',0,'','',''),(6037,254,'New Mexico','NM',0,'','',''),(6038,254,'New York','NY',0,'','',''),(6039,254,'North Carolina','NC',0,'','',''),(6040,254,'North Dakota','ND',0,'','',''),(6041,254,'Northern Mariana Islands','MP',0,'','',''),(6042,254,'Ohio','OH',0,'','',''),(6043,254,'Oklahoma','OK',0,'','',''),(6044,254,'Oregon','OR',0,'','',''),(6045,254,'Palau','PW',0,'','',''),(6046,254,'Pennsylvania','PA',0,'','',''),(6047,254,'Puerto Rico','PR',0,'','',''),(6048,254,'Rhode Island','RI',0,'','',''),(6049,254,'South Carolina','SC',0,'','',''),(6050,254,'South Dakota','SD',0,'','',''),(6051,254,'Tennessee','TN',0,'','',''),(6052,254,'Texas','TX',0,'','',''),(6053,254,'Utah','UT',0,'','',''),(6054,254,'Vermont','VT',0,'','',''),(6055,254,'Virgin Islands','VI',0,'','',''),(6056,254,'Virginia','VA',0,'','',''),(6057,254,'Washington','WA',0,'','',''),(6058,254,'West Virginia','WV',0,'','',''),(6059,254,'Wisconsin','WI',0,'','',''),(6060,254,'Wyoming','WY',0,'','',''),(6061,14,'Sydney','SYD',NULL,NULL,NULL,NULL),(6062,14,'Melbourne','MEL',NULL,NULL,NULL,NULL),(6063,14,'Queensland','QLD',NULL,NULL,NULL,NULL);
CREATE TABLE `wp_wpl_location3` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `parent` bigint(20) unsigned NOT NULL DEFAULT '0',
  `name` varchar(100) DEFAULT NULL,
  `abbr` varchar(100) DEFAULT NULL,
  `tax_percent` double DEFAULT NULL,
  `latitude` varchar(25) DEFAULT NULL,
  `longitude` varchar(25) DEFAULT NULL,
  `params` text,
  PRIMARY KEY (`id`),
  KEY `parent` (`parent`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `wp_wpl_location4` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `parent` bigint(20) unsigned NOT NULL DEFAULT '0',
  `name` varchar(100) DEFAULT NULL,
  `abbr` varchar(100) DEFAULT NULL,
  `tax_percent` double DEFAULT NULL,
  `latitude` varchar(25) DEFAULT NULL,
  `longitude` varchar(25) DEFAULT NULL,
  `params` text,
  PRIMARY KEY (`id`),
  KEY `parent` (`parent`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `wp_wpl_location5` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `parent` bigint(20) unsigned NOT NULL DEFAULT '0',
  `name` varchar(100) DEFAULT NULL,
  `abbr` varchar(100) DEFAULT NULL,
  `tax_percent` double DEFAULT NULL,
  `latitude` varchar(25) DEFAULT NULL,
  `longitude` varchar(25) DEFAULT NULL,
  `params` text,
  PRIMARY KEY (`id`),
  KEY `parent` (`parent`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `wp_wpl_location6` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `parent` bigint(20) unsigned NOT NULL DEFAULT '0',
  `name` varchar(100) DEFAULT NULL,
  `abbr` varchar(100) DEFAULT NULL,
  `tax_percent` double DEFAULT NULL,
  `latitude` varchar(25) DEFAULT NULL,
  `longitude` varchar(25) DEFAULT NULL,
  `params` text,
  PRIMARY KEY (`id`),
  KEY `parent` (`parent`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `wp_wpl_location7` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `parent` bigint(20) unsigned NOT NULL DEFAULT '1',
  `name` varchar(100) DEFAULT NULL,
  `abbr` varchar(100) DEFAULT NULL,
  `tax_percent` double DEFAULT NULL,
  `latitude` varchar(25) DEFAULT NULL,
  `longitude` varchar(25) DEFAULT NULL,
  `params` text,
  PRIMARY KEY (`id`),
  KEY `parent` (`parent`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `wp_wpl_locationtextsearch` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `location_text` text,
  `count` int(10) DEFAULT NULL,
  `counts` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `wp_wpl_locationzips` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `parent` int(11) DEFAULT NULL,
  `country_id` int(11) DEFAULT NULL,
  `median_income` int(11) DEFAULT NULL,
  `average_hvalue` int(11) DEFAULT NULL,
  `distance_to_downtown` int(11) DEFAULT NULL,
  `school_rating` tinyint(4) DEFAULT NULL,
  `tax_rate` int(11) DEFAULT NULL,
  `population` int(11) DEFAULT NULL,
  `boundary` text,
  `color` varchar(6) DEFAULT '',
  `hcolor` varchar(6) DEFAULT '',
  `longitude` varchar(25) DEFAULT NULL,
  `latitude` varchar(25) DEFAULT NULL,
  `params` text,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `parent` (`parent`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `wp_wpl_logs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) NOT NULL,
  `addon_id` int(10) unsigned NOT NULL,
  `section` varchar(100) NOT NULL,
  `status` varchar(100) NOT NULL,
  `log_text` text NOT NULL,
  `log_date` datetime NOT NULL,
  `ip` varchar(50) NOT NULL,
  `priority` tinyint(4) NOT NULL,
  `params` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `wp_wpl_menus` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `client` varchar(20) CHARACTER SET latin1 NOT NULL DEFAULT 'backend',
  `type` varchar(10) CHARACTER SET latin1 NOT NULL DEFAULT 'submenu',
  `parent` varchar(50) CHARACTER SET latin1 NOT NULL DEFAULT 'WPL_main_menu',
  `page_title` varchar(100) CHARACTER SET latin1 NOT NULL,
  `menu_title` varchar(100) CHARACTER SET latin1 NOT NULL,
  `capability` varchar(100) CHARACTER SET latin1 NOT NULL DEFAULT 'current',
  `menu_slug` varchar(100) CHARACTER SET latin1 NOT NULL,
  `function` varchar(100) CHARACTER SET latin1 NOT NULL,
  `separator` tinyint(4) NOT NULL DEFAULT '0',
  `enabled` tinyint(4) NOT NULL DEFAULT '1',
  `index` float(6,3) NOT NULL DEFAULT '1.000',
  `position` float NOT NULL,
  `dashboard` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;
INSERT INTO `wp_wpl_menus` VALUES (1,'backend','menu','','WPL','WPL','admin','WPL_main_menu','b:wpl:admin_home',0,1,1.000,4.5,1),(2,'backend','submenu','WPL_main_menu','Data Structure','Data Structure','admin','wpl_admin_data_structure','b:data_structure:home',0,1,1.000,0,1),(3,'backend','submenu','WPL_main_menu','Settings','Settings','admin','wpl_admin_settings','b:settings:home',0,1,2.000,0,1),(4,'backend','submenu','WPL_main_menu','User Manager','User Manager','admin','wpl_admin_user_manager','b:users:user_manager',1,1,3.000,0,1),(5,'backend','submenu','WPL_main_menu','My Profile','My Profile','current','wpl_admin_profile','b:users:profile',0,1,5.000,0,1),(6,'backend','submenu','WPL_main_menu','Add Listing','Add Listing','current','wpl_admin_add_listing','b:listing:wizard',1,1,6.000,0,1),(7,'backend','submenu','WPL_main_menu','Listing Manager','Listing Manager','current','wpl_admin_listings','b:listings:manager',0,1,7.000,0,1),(8,'backend','submenu','WPL_main_menu','Locations','Locations','admin','wpl_admin_locations','b:location_manager:home',0,1,1.100,0,1),(11,'backend','submenu','WPL_main_menu','Flex','Flex','admin','wpl_admin_flex','b:flex:home',0,1,1.050,0,1),(12,'backend','submenu','WPL_main_menu','Activity Manager','Activity Manager','admin','wpl_admin_activity','b:activity_manager:home',0,1,2.010,0,0),(13,'backend','submenu','WPL_main_menu','Notifications','Notifications','admin','wpl_admin_notifications','b:notifications:home',0,1,2.050,0,0);
CREATE TABLE `wp_wpl_notifications` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `description` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `template` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `subject` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `additional_memberships` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `additional_users` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `additional_emails` text COLLATE utf8_unicode_ci,
  `options` text COLLATE utf8_unicode_ci,
  `params` text COLLATE utf8_unicode_ci,
  `enabled` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
INSERT INTO `wp_wpl_notifications` VALUES (2,'Contact to listing agent from listing page','contact_agent','New Contact','','','',NULL,'',1),(3,'Contact to agent from profile page','contact_profile','New Profile Contact','','','',NULL,'',1),(5,'Sends after registration process.','user_registered','Your Account has been registered.','','','',NULL,'',1),(6,'Send to friend','send_to_friend','Send to friend','','','',NULL,'',1),(7,'Request a visit','request_a_visit','Request a visit','','','',NULL,'',1),(8,'When a listing creates','listing_create','New listing','','','',NULL,'',0);
CREATE TABLE `wp_wpl_properties` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `kind` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '0=property,1=complex',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  `mls_id` varchar(30) DEFAULT NULL,
  `parent` int(11) unsigned NOT NULL COMMENT 'Parent',
  `pic_numb` mediumint(9) NOT NULL DEFAULT '0',
  `att_numb` mediumint(9) NOT NULL DEFAULT '0',
  `sent_numb` mediumint(9) NOT NULL DEFAULT '0',
  `contact_numb` mediumint(9) NOT NULL DEFAULT '0',
  `user_id` smallint(6) NOT NULL DEFAULT '0',
  `listing` int(11) NOT NULL DEFAULT '0',
  `property_type` int(11) NOT NULL DEFAULT '0',
  `location1_id` int(11) NOT NULL DEFAULT '0',
  `location2_id` int(11) NOT NULL DEFAULT '0',
  `location3_id` int(11) NOT NULL DEFAULT '0',
  `location4_id` int(11) NOT NULL DEFAULT '0',
  `location5_id` int(11) NOT NULL DEFAULT '0',
  `location6_id` int(11) NOT NULL DEFAULT '0',
  `location7_id` int(11) NOT NULL DEFAULT '0',
  `location1_name` varchar(50) DEFAULT NULL,
  `location2_name` varchar(50) DEFAULT NULL,
  `location3_name` varchar(50) DEFAULT NULL,
  `location4_name` varchar(50) DEFAULT NULL,
  `location5_name` varchar(50) DEFAULT NULL,
  `location6_name` varchar(50) DEFAULT NULL,
  `location7_name` varchar(50) DEFAULT NULL,
  `show_address` tinyint(4) NOT NULL DEFAULT '1',
  `view` tinyint(4) NOT NULL DEFAULT '0',
  `price` double NOT NULL DEFAULT '0',
  `price_unit` int(11) NOT NULL DEFAULT '0',
  `price_si` double NOT NULL DEFAULT '0',
  `price_period` smallint(6) NOT NULL DEFAULT '0',
  `bedrooms` float NOT NULL DEFAULT '0',
  `rooms` float NOT NULL DEFAULT '0',
  `bathrooms` float NOT NULL DEFAULT '0',
  `living_area` float NOT NULL DEFAULT '0',
  `living_area_unit` int(11) NOT NULL DEFAULT '0',
  `living_area_si` float NOT NULL DEFAULT '0',
  `lot_area` float NOT NULL DEFAULT '0',
  `lot_area_unit` int(11) NOT NULL DEFAULT '0',
  `lot_area_si` float NOT NULL DEFAULT '0',
  `parkings` float NOT NULL DEFAULT '0',
  `googlemap_lt` varchar(20) NOT NULL DEFAULT '0',
  `googlemap_ln` varchar(20) NOT NULL DEFAULT '0',
  `finalized` tinyint(4) NOT NULL DEFAULT '0',
  `add_date` datetime DEFAULT NULL,
  `expire_days` int(11) NOT NULL DEFAULT '0',
  `confirmed` tinyint(4) NOT NULL DEFAULT '0',
  `expired` tinyint(4) NOT NULL DEFAULT '0',
  `visit_time` mediumint(9) NOT NULL DEFAULT '0',
  `visit_date` datetime DEFAULT NULL,
  `build_year` int(11) NOT NULL DEFAULT '0',
  `zip_id` int(11) NOT NULL DEFAULT '0',
  `zip_name` varchar(20) DEFAULT NULL,
  `last_modified_time_stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `post_code` varchar(50) DEFAULT NULL,
  `meta_description` text,
  `meta_keywords` text,
  `street` varchar(50) DEFAULT NULL,
  `street_no` varchar(50) DEFAULT NULL,
  `sp_featured` tinyint(4) NOT NULL DEFAULT '0',
  `sp_hot` tinyint(4) NOT NULL DEFAULT '0',
  `sp_openhouse` tinyint(4) NOT NULL DEFAULT '0',
  `sp_forclosure` tinyint(4) NOT NULL DEFAULT '0',
  `textsearch` text,
  `property_title` varchar(100) DEFAULT NULL,
  `location_text` varchar(255) DEFAULT NULL,
  `vids_numb` int(10) NOT NULL DEFAULT '0',
  `field_42` varchar(50) DEFAULT NULL,
  `field_312` varchar(70) DEFAULT NULL,
  `field_313` varchar(70) DEFAULT NULL,
  `field_308` text,
  `field_7` int(11) NOT NULL DEFAULT '0',
  `n_100` tinyint(4) DEFAULT NULL,
  `n_100_distance` int(11) DEFAULT NULL,
  `n_100_distance_by` tinyint(4) DEFAULT NULL,
  `n_101` tinyint(4) DEFAULT NULL,
  `n_101_distance` int(11) DEFAULT NULL,
  `n_101_distance_by` tinyint(4) DEFAULT NULL,
  `n_102` tinyint(4) DEFAULT NULL,
  `n_102_distance` int(11) DEFAULT NULL,
  `n_102_distance_by` tinyint(4) DEFAULT NULL,
  `n_103` tinyint(4) DEFAULT NULL,
  `n_103_distance` int(11) DEFAULT NULL,
  `n_103_distance_by` tinyint(4) DEFAULT NULL,
  `n_105` tinyint(4) DEFAULT NULL,
  `n_105_distance` int(11) DEFAULT NULL,
  `n_105_distance_by` tinyint(4) DEFAULT NULL,
  `n_106` tinyint(4) DEFAULT NULL,
  `n_106_distance` int(11) DEFAULT NULL,
  `n_106_distance_by` tinyint(4) DEFAULT NULL,
  `n_107` tinyint(4) DEFAULT NULL,
  `n_107_distance` int(11) DEFAULT NULL,
  `n_107_distance_by` tinyint(4) DEFAULT NULL,
  `n_108` tinyint(4) DEFAULT NULL,
  `n_108_distance` int(11) DEFAULT NULL,
  `n_108_distance_by` tinyint(4) DEFAULT NULL,
  `n_109` tinyint(4) DEFAULT NULL,
  `n_109_distance` int(11) DEFAULT NULL,
  `n_109_distance_by` tinyint(4) DEFAULT NULL,
  `n_110` tinyint(4) DEFAULT NULL,
  `n_110_distance` int(11) DEFAULT NULL,
  `n_110_distance_by` tinyint(4) DEFAULT NULL,
  `n_111` tinyint(4) DEFAULT NULL,
  `n_111_distance` int(11) DEFAULT NULL,
  `n_111_distance_by` tinyint(4) DEFAULT NULL,
  `n_112` tinyint(4) DEFAULT NULL,
  `n_112_distance` int(11) DEFAULT NULL,
  `n_112_distance_by` tinyint(4) DEFAULT NULL,
  `n_113` tinyint(4) DEFAULT NULL,
  `n_113_distance` int(11) DEFAULT NULL,
  `n_113_distance_by` tinyint(4) DEFAULT NULL,
  `n_114` tinyint(4) DEFAULT NULL,
  `n_114_distance` int(11) DEFAULT NULL,
  `n_114_distance_by` tinyint(4) DEFAULT NULL,
  `n_115` tinyint(4) DEFAULT NULL,
  `n_115_distance` int(11) DEFAULT NULL,
  `n_115_distance_by` tinyint(4) DEFAULT NULL,
  `f_130_options` text,
  `f_130` tinyint(4) DEFAULT NULL,
  `f_131_options` text,
  `f_131` tinyint(4) DEFAULT NULL,
  `f_132_options` text,
  `f_132` tinyint(4) DEFAULT NULL,
  `f_133_options` text,
  `f_133` tinyint(4) DEFAULT NULL,
  `f_134_options` text,
  `f_134` tinyint(4) DEFAULT NULL,
  `f_135_options` text,
  `f_135` tinyint(4) DEFAULT NULL,
  `f_136_options` text,
  `f_136` tinyint(4) DEFAULT NULL,
  `f_137_options` text,
  `f_137` tinyint(4) DEFAULT NULL,
  `f_138_options` text,
  `f_138` tinyint(4) DEFAULT NULL,
  `f_139_options` text,
  `f_139` tinyint(4) DEFAULT NULL,
  `f_140_options` text,
  `f_140` tinyint(4) DEFAULT NULL,
  `f_141_options` text,
  `f_141` tinyint(4) DEFAULT NULL,
  `f_142_options` text,
  `f_142` tinyint(4) DEFAULT NULL,
  `f_143_options` text,
  `f_143` tinyint(4) DEFAULT NULL,
  `f_144_options` text,
  `f_144` tinyint(4) DEFAULT NULL,
  `f_146_options` text,
  `f_146` tinyint(4) DEFAULT NULL,
  `f_147_options` text,
  `f_147` tinyint(4) DEFAULT NULL,
  `f_148_options` text,
  `f_148` tinyint(4) DEFAULT NULL,
  `f_149_options` text,
  `f_149` tinyint(4) DEFAULT NULL,
  `f_150_options` text,
  `f_150` tinyint(4) DEFAULT NULL,
  `f_151_options` text,
  `f_151` tinyint(4) DEFAULT NULL,
  `f_152_options` text,
  `f_152` tinyint(4) DEFAULT NULL,
  `f_153_options` text,
  `f_153` tinyint(4) DEFAULT NULL,
  `f_154_options` text,
  `f_154` tinyint(4) DEFAULT NULL,
  `f_155_options` text,
  `f_155` tinyint(4) DEFAULT NULL,
  `f_156_options` text,
  `f_156` tinyint(4) DEFAULT NULL,
  `f_157_options` text,
  `f_157` tinyint(4) DEFAULT NULL,
  `f_158_options` text,
  `f_158` tinyint(4) DEFAULT NULL,
  `f_159_options` text,
  `f_159` tinyint(4) DEFAULT NULL,
  `f_160_options` text,
  `f_160` tinyint(4) DEFAULT NULL,
  `f_161_options` text,
  `f_161` tinyint(4) DEFAULT NULL,
  `f_162_options` text,
  `f_162` tinyint(4) DEFAULT NULL,
  `f_163_options` text,
  `f_163` tinyint(4) DEFAULT NULL,
  `f_164_options` text,
  `f_164` tinyint(4) DEFAULT NULL,
  `f_165_options` text,
  `f_165` tinyint(4) DEFAULT NULL,
  `f_166_options` text,
  `f_166` tinyint(4) DEFAULT NULL,
  `f_167_options` text,
  `f_167` tinyint(4) DEFAULT NULL,
  `f_168_options` text,
  `f_168` tinyint(4) DEFAULT NULL,
  `f_169_options` text,
  `f_169` tinyint(4) DEFAULT NULL,
  `ref_id` varchar(50) DEFAULT NULL,
  `field_54` varchar(50) DEFAULT NULL,
  `half_bathrooms` float NOT NULL DEFAULT '0',
  `field_55` float NOT NULL DEFAULT '0',
  `rendered` text,
  `alias` text,
  `source` varchar(100) NOT NULL DEFAULT 'wpl',
  `last_sync_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `category_id` (`property_type`),
  KEY `city_id` (`location3_id`),
  KEY `state_id` (`location2_id`),
  KEY `country_id` (`location1_id`),
  KEY `zone_id` (`location4_id`),
  KEY `listing_type_id` (`listing`),
  KEY `price` (`price`),
  KEY `bedrooms` (`bedrooms`),
  KEY `bathrooms` (`bathrooms`),
  KEY `last_modified_time_stamp` (`last_modified_time_stamp`),
  KEY `location_text` (`location_text`),
  KEY `deleted` (`deleted`),
  KEY `confirmed` (`confirmed`),
  KEY `finalized` (`finalized`),
  KEY `mls_id` (`mls_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
INSERT INTO `wp_wpl_properties` VALUES (1,0,0,'1000',0,0,0,0,0,1,9,6,276,0,0,0,0,0,0,'Australia',NULL,'Windsor','Brisbane',NULL,NULL,NULL,1,0,452000,260,452000,0,2,0,2,0,2,0,0,1,0,0,'0','0',0,'2016-03-11 03:45:47',0,1,0,0,NULL,0,0,NULL,'2016-03-11 11:48:52',NULL,'2 Bedrooms With 2 Bathrooms Apartment For sale Mode Apartments In Brisbane, Windsor, Australia, Listing ID 1000','2 Bedrooms, Apartment, For sale, Mode Apartments, 2 Bathrooms, Listing ID 1000, Brisbane, Windsor, Australia,',NULL,NULL,1,0,0,0,'Property Title Mode Apartments  Property Page Title Mode Apartments ? Brisbane City fringe Boutique Development Property Description Location ? Windsor, Brisbane ? 3.5km from Brisbane CBD\nDevelopment Size ? 28 Apartments\nConstruction: started\nCompletion: late 2016\nWindow furnishings included\n Property Type Apartment Listing Type For sale Listing ID 1000 Price $452,000 View Street Bedrooms 2 Bedrooms two Bathrooms 2 Bathrooms two Built Up Area 0 m&sup2; Lot Area 0 Sqft LOC-Country LOC-Australia LOC-County LOC-Windsor LOC-City LOC-Brisbane LOC-Mode LOC-Apartments LOC-Avenue LOC-Ave LOC-Boulevard LOC-Blvd LOC-Highway LOC-Hwy LOC-Lane LOC-Ln LOC-Square LOC-Sq LOC-Street LOC-St LOC-Road LOC-Rd Featured Yes Building Name Mode Apartments',NULL,'Brisbane, Windsor, Australia',0,NULL,'Mode Apartments – Brisbane City fringe Boutique Development','Mode Apartments ','Location – Windsor, Brisbane – 3.5km from Brisbane CBD\nDevelopment Size – 28 Apartments\nConstruction: started\nCompletion: late 2016\nWindow furnishings included\n',2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Mode Apartments',0,0,'{\"rendered\":{\"313\":{\"field_id\":\"313\",\"type\":\"text\",\"name\":\"Property Title\",\"value\":\"Mode Apartments \"},\"312\":{\"field_id\":\"312\",\"type\":\"text\",\"name\":\"Property Page Title\",\"value\":\"Mode Apartments ? Brisbane City fringe Boutique Development\"},\"3\":{\"field_id\":\"3\",\"type\":\"property_types\",\"name\":\"Property Type\",\"value\":\"Apartment\"},\"2\":{\"field_id\":\"2\",\"type\":\"listings\",\"name\":\"Listing Type\",\"value\":\"For sale\"},\"5\":{\"field_id\":\"5\",\"type\":\"text\",\"name\":\"Listing ID\",\"value\":\"1000\"},\"6\":{\"field_id\":\"6\",\"type\":\"price\",\"name\":\"Price\",\"value\":\"$452,000\",\"price_only\":\"$452,000\"},\"8\":{\"field_id\":\"8\",\"type\":\"number\",\"name\":\"Bedrooms\",\"value\":\"2\"},\"9\":{\"field_id\":\"9\",\"type\":\"number\",\"name\":\"Bathrooms\",\"value\":\"2\"},\"17\":{\"field_id\":\"17\",\"type\":\"number\",\"name\":\"Half Bathrooms\",\"value\":\"0\"},\"10\":{\"field_id\":\"10\",\"type\":\"area\",\"name\":\"Built Up Area\",\"value\":\"0 m&sup2;\"},\"11\":{\"field_id\":\"11\",\"type\":\"area\",\"name\":\"Lot Area\",\"value\":\"0 Sqft\"},\"41\":{\"field_id\":\"41\",\"type\":\"locations\",\"name\":\"Location\",\"location_ids\":{\"1\":\"276\",\"3\":\"0\",\"4\":\"0\"},\"locations\":{\"1\":\"Australia\",\"3\":\"Windsor\",\"4\":\"Brisbane\"},\"raw\":{\"1\":\"Australia\",\"3\":\"Windsor\",\"4\":\"Brisbane\"},\"keywords\":{\"1\":\"Country\",\"3\":\"County\",\"4\":\"City\"}},\"400\":{\"field_id\":\"400\",\"type\":\"tag\",\"name\":\"Featured\",\"value\":\"Yes\"},\"54\":{\"field_id\":\"54\",\"type\":\"text\",\"name\":\"Building Name\",\"value\":\"Mode Apartments\"},\"55\":{\"field_id\":\"55\",\"type\":\"number\",\"name\":\"Floor Number\",\"value\":\"0\"}},\"materials\":{\"field_313\":{\"field_id\":\"313\",\"type\":\"text\",\"name\":\"Property Title\",\"value\":\"Mode Apartments \"},\"field_312\":{\"field_id\":\"312\",\"type\":\"text\",\"name\":\"Property Page Title\",\"value\":\"Mode Apartments ? Brisbane City fringe Boutique Development\"},\"property_type\":{\"field_id\":\"3\",\"type\":\"property_types\",\"name\":\"Property Type\",\"value\":\"Apartment\"},\"listing\":{\"field_id\":\"2\",\"type\":\"listings\",\"name\":\"Listing Type\",\"value\":\"For sale\"},\"mls_id\":{\"field_id\":\"5\",\"type\":\"text\",\"name\":\"Listing ID\",\"value\":\"1000\"},\"price\":{\"field_id\":\"6\",\"type\":\"price\",\"name\":\"Price\",\"value\":\"$452,000\",\"price_only\":\"$452,000\"},\"bedrooms\":{\"field_id\":\"8\",\"type\":\"number\",\"name\":\"Bedrooms\",\"value\":\"2\"},\"bathrooms\":{\"field_id\":\"9\",\"type\":\"number\",\"name\":\"Bathrooms\",\"value\":\"2\"},\"half_bathrooms\":{\"field_id\":\"17\",\"type\":\"number\",\"name\":\"Half Bathrooms\",\"value\":\"0\"},\"living_area\":{\"field_id\":\"10\",\"type\":\"area\",\"name\":\"Built Up Area\",\"value\":\"0 m&sup2;\"},\"lot_area\":{\"field_id\":\"11\",\"type\":\"area\",\"name\":\"Lot Area\",\"value\":\"0 Sqft\"},\"locations\":{\"field_id\":\"41\",\"type\":\"locations\",\"name\":\"Location\",\"location_ids\":{\"1\":\"276\",\"3\":\"0\",\"4\":\"0\"},\"locations\":{\"1\":\"Australia\",\"3\":\"Windsor\",\"4\":\"Brisbane\"},\"raw\":{\"1\":\"Australia\",\"3\":\"Windsor\",\"4\":\"Brisbane\"},\"keywords\":{\"1\":\"Country\",\"3\":\"County\",\"4\":\"City\"}},\"sp_featured\":{\"field_id\":\"400\",\"type\":\"tag\",\"name\":\"Featured\",\"value\":\"Yes\"},\"field_54\":{\"field_id\":\"54\",\"type\":\"text\",\"name\":\"Building Name\",\"value\":\"Mode Apartments\"},\"field_55\":{\"field_id\":\"55\",\"type\":\"number\",\"name\":\"Floor Number\",\"value\":\"0\"}},\"location_text\":\"Brisbane, Windsor, Australia\"}','Apartment-Brisbane-Windsor-Australia-2Bedrooms-2Bathrooms-USD452000','wpl','0000-00-00 00:00:00');
CREATE TABLE `wp_wpl_property_types` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `parent` int(11) NOT NULL DEFAULT '0',
  `enabled` tinyint(4) NOT NULL DEFAULT '1',
  `editable` tinyint(4) NOT NULL DEFAULT '1',
  `index` float(5,2) NOT NULL DEFAULT '99.00',
  `listing` int(11) NOT NULL DEFAULT '0',
  `name` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;
INSERT INTO `wp_wpl_property_types` VALUES (1,0,0,2,0.00,0,'Residential'),(2,0,0,2,0.00,0,'Commercial'),(3,0,0,2,0.00,0,'Land'),(6,1,1,2,7.00,0,'Apartment'),(7,1,1,2,32.00,0,'Villa'),(13,2,1,2,6.00,0,'Office'),(14,3,1,2,14.00,0,'Land'),(15,1,1,2,15.00,0,'House');
CREATE TABLE `wp_wpl_room_types` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL,
  `index` float(5,2) NOT NULL DEFAULT '99.00',
  `enabled` tinyint(4) NOT NULL DEFAULT '1',
  `icon` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;
INSERT INTO `wp_wpl_room_types` VALUES (1,'Master Bedroom',7.00,1,'default.png'),(2,'Guest Room',3.00,1,'default.png'),(3,'Living Room',2.00,1,'default.png'),(4,'Walk in Closet',8.00,1,'hanger.png'),(5,'Bathroom',9.00,1,'shower.png'),(6,'Laundry room',10.00,1,'cloth.png'),(7,'Kitchen',5.00,1,'default.png'),(8,'Story room',11.00,1,'default.png'),(9,'Study room',12.00,1,'book.png'),(20,'Bedroom',1.00,1,'bed.png'),(21,'Dining Room',4.00,1,'spoon_fork.png'),(22,'Extra Room',6.00,1,'default.png'),(23,'Family room',14.00,1,'tv.png');
CREATE TABLE `wp_wpl_setting_categories` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(200) DEFAULT NULL,
  `showable` tinyint(4) NOT NULL DEFAULT '1',
  `index` float(5,2) NOT NULL DEFAULT '99.00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
INSERT INTO `wp_wpl_setting_categories` VALUES (1,'Global',1,99.00),(2,'Gallery',1,99.00),(3,'Locations',1,99.00),(4,'SEO',1,99.00),(5,'Notifications',1,99.00);
CREATE TABLE `wp_wpl_settings` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `setting_name` varchar(250) CHARACTER SET latin1 DEFAULT NULL,
  `setting_value` text,
  `showable` tinyint(4) NOT NULL DEFAULT '1',
  `category` int(10) NOT NULL DEFAULT '1',
  `type` varchar(100) CHARACTER SET latin1 NOT NULL DEFAULT 'text',
  `title` varchar(200) DEFAULT NULL,
  `params` text,
  `options` text,
  `index` float(5,2) NOT NULL DEFAULT '99.00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=201 DEFAULT CHARSET=utf8;
INSERT INTO `wp_wpl_settings` VALUES (1,'zipcode_parent_level','4',1,3,'select','Zipcode parent level','','{\"values\":[{\"key\":1,\"value\":\"Location1\"},{\"key\":2,\"value\":\"Location2\"},{\"key\":3,\"value\":\"Location3\"},{\"key\":4,\"value\":\"Location4\"},{\"key\":5,\"value\":\"Location5\"},{\"key\":6,\"value\":\"Location6\"},\r\n{\"key\":7,\"value\":\"Location7\"}]} ',5.00),(2,'cache','1',1,1,'select','Cache','','{\"values\":[{\"key\":0,\"value\":\"Disabled\"},{\"key\":1,\"value\":\"Enabled\"}]}',0.10),(5,'image_resize_method','0',1,2,'select','Image resize method','','{\"values\":[{\"key\":0,\"value\":\"Resize\"},{\"key\":1,\"value\":\"Crop Resize\"}, {\"key\":2,\"value\":\"Crop Resize (Center)\"}]} ',2.00),(6,'default_resize_width','500',1,2,'text','Default resize width','','',3.00),(7,'default_resize_height','450',1,2,'text','Default resize height','','',4.00),(8,'watermark_status','0',1,2,'select','Watermark','','{\"values\":[{\"key\":0,\"value\":\"No\"},{\"key\":1,\"value\":\"Yes\"}]} ',5.00),(9,'watermark_position','center',1,2,'select','Watermark Position ','','{\"values\":[{\"key\":\"center\",\"value\":\"Center\"},{\"key\":\"top\",\"value\":\"Top\"}, {\"key\":\"left\",\"value\":\"Left\"}, {\"key\":\"right\",\"value\":\"Right\"},{\"key\":\"bottom\",\"value\":\"Bottom\"}, {\"key\":\"top-right\",\"value\":\"Top-Right\"}, {\"key\":\"top-left\",\"value\":\"Top-Left\"}, {\"key\":\"bottom-right\",\"value\":\"Bottom-Right\"}, {\"key\":\"bottom-left\",\"value\":\"Bottom-Left\"}]} ',6.00),(10,'watermark_opacity','40',1,2,'text','Watermark Opacity','','',7.00),(11,'watermark_url','',1,2,'upload','Watermark Logo','{\"html_element_id\":\"wpl_watermark_uploader\",\"request_str\":\"admin.php?wpl_format=b:settings:ajax&wpl_function=save_watermark_image\"}','',8.00),(12,'video_uploader','0',1,1,'checkbox','Video uploader','','',50.00),(13,'location1_keyword','Country',1,3,'text','Location1 keyword','','',99.00),(14,'location2_keyword','State',1,3,'text','Location2 keyword','','',99.00),(15,'location3_keyword','Suburb',1,3,'text','Location3 keyword','','',99.00),(16,'location4_keyword','City',1,3,'text','Location4 keyword','','',99.00),(17,'location5_keyword','',1,3,'text','Location5 keyword','','',99.00),(18,'location6_keyword','',1,3,'text','Location6 keyword','','',99.00),(19,'location7_keyword','',1,3,'text','Location7 keyword','','',99.00),(20,'locationzips_keyword','Postcode',1,3,'text','Zipcode Keyword','','',99.00),(21,'default_page_size','12',1,1,'text','Default page size','','{\"show_shortcode\":1,\"shortcode_key\":\"limit\"}',99.00),(22,'page_sizes','6,12,18,24,30,100',1,1,'text','Page size options','','',51.00),(23,'default_orderby','p.price_si',1,1,'sort_option','Default sort option','','{\"show_shortcode\":1,\"shortcode_key\":\"wplorderby\",\"kind\":0}',99.00),(24,'default_order','DESC',1,1,'select','Default sort type','','{\"show_shortcode\":1,\"shortcode_key\":\"wplorder\",\"values\":[{\"key\":\"ASC\",\"value\":\"Ascending\"},{\"key\":\"DESC\",\"value\":\"Descending\"}]} ',99.00),(25,'main_permalink','290',1,4,'wppages','Main Permalink','','{\"show_empty\":\"1\"}',1.00),(26,'sef_main_separator','/',0,4,'text','SEF separator','','',2.00),(27,'main_date_format','d/m/Y:dd/mm/yy',1,1,'select','Date Format','','{\"values\":[{\"key\":\"Y-m-d:yy-mm-dd\",\"value\":\"2013-10-19\"},{\"key\":\"Y/m/d:yy/mm/dd\",\"value\":\"2013/10/19\"},{\"key\":\"m-d-Y:mm-dd-yy\",\"value\":\"10-19-2013\"},{\"key\":\"m/d/Y:mm/dd/yy\",\"value\":\"10/19/2013\"},{\"key\":\"d-m-Y:dd-mm-yy\",\"value\":\"19-10-2013\"},{\"key\":\"d/m/Y:dd/mm/yy\",\"value\":\"19/10/2013\"}]}',52.00),(28,'location_method','1',1,3,'select','Location Method','{\"tooltip\":\"Location Text is recommended.\"}','{\"values\":[{\"key\":1,\"value\":\"Location Text\"},{\"key\":2,\"value\":\"Location Database\"}]}',6.00),(29,'default_profile_orderby','p.first_name',1,1,'sort_option','Profile sort option','','{\"show_shortcode\":1,\"shortcode_key\":\"wplorderby\",\"kind\":2}',110.00),(30,'default_profile_order','DESC',1,1,'select','Profile sort type','','{\"show_shortcode\":1,\"shortcode_key\":\"wplorder\",\"values\":[{\"key\":\"ASC\",\"value\":\"Ascending\"},{\"key\":\"DESC\",\"value\":\"Descending\"}]} ',111.00),(31,'default_profile_page_size','12',1,1,'text','Profile page size','','{\"show_shortcode\":1,\"shortcode_key\":\"limit\"}',109.00),(33,'io_status','1',1,1,'select','I/O API','','{\"values\":[{\"key\":0,\"value\":\"Disabled\"},{\"key\":1,\"value\":\"Enabled\"}]}',117.00),(34,'io_public_key','U7hdbv673YhdjplzzX7wU7hdbv673YhdjplzzX7w',1,1,'text','API key','{\"readonly\":\"readonly\"}','',118.00),(35,'io_private_key','Eft76bdh0o2uyhJkbG3T',1,1,'text','API secret','{\"readonly\":\"readonly\"}','',119.00),(36,'realtyna_username',NULL,0,1,'text','','','',99.00),(37,'realtyna_password',NULL,0,1,'text','','','',99.00),(38,'realtyna_verified','0',0,1,'text','','','',99.00),(50,'backend_listing_target_page',NULL,1,4,'wppages','Backend Listing Target','{\"tooltip\":\"Used for backend views\"}','{\"show_empty\":1} ',3.00),(51,'log','1',1,1,'select','WPL log',NULL,'{\"values\":[{\"key\":0,\"value\":\"Disabled\" },{\"key\":1,\"value\":\"Enabled\"}]}',53.00),(53,'wpl_sender_email','',1,5,'text','Sender email',NULL,'',121.00),(54,'wpl_sender_name','',1,5,'text','Sender name',NULL,'',122.00),(55,'property_location_pattern','[street_no] [street][glue] [location4_name][glue] [location3_name][glue] [location2_name][glue] [location1_name] [zip_name]',1,3,'pattern','Property Pattern',NULL,'',123.00),(56,'user_location_pattern','[location5_name][glue][location4_name][glue][location3_name][glue][location2_name][glue][location1_name] [zip_name]',1,3,'pattern','User Pattern',NULL,'',124.00),(63,'location_separator1','',1,3,'separator','Location Keywords','','',98.00),(64,'location_separator2','',1,3,'separator','Location Patterns','','',122.00),(65,'location_separator3','',1,3,'separator','Locations','','',4.50),(66,'permalink_separator','',1,4,'separator','WPL Permalink','','',0.90),(67,'sender_separator',NULL,1,5,'separator','Notification Sender',NULL,NULL,120.50),(68,'resize_separator',NULL,1,2,'separator','Resize',NULL,NULL,1.50),(69,'watermark_separator',NULL,1,2,'separator','Watermark',NULL,NULL,4.50),(70,'global_separator',NULL,1,1,'separator','Global',NULL,NULL,0.05),(71,'listing_pages_separator',NULL,1,1,'separator','Listings',NULL,NULL,98.00),(72,'users_separator',NULL,1,1,'separator','Users',NULL,NULL,107.00),(73,'io_separator',NULL,1,1,'separator','I/O Application',NULL,NULL,116.00),(90,'property_alias_pattern','[property_type][glue][listing_type][glue][location][glue][rooms][glue][bedrooms][glue][bathrooms][glue][price]',1,4,'pattern','Property Link Pattern','{\"tooltip\":\"You can remove the parameters or change the positions. Don\'t add new parameters!\"}','',4.00),(107,'js_default_path','js/libraries',0,1,'text','JS Default Path','','',106.00),(126,'google_api_key',NULL,1,1,'text','Google API key',NULL,NULL,55.00),(141,'location_suffix_prefix','County, Avenue, Ave, Boulevard, Blvd, Highway, Hwy, Lane, Ln, Square, Sq, Street, St, Road, Rd',0,3,'text','Location Suffixes/Prefixes','{\"html_class\":\"long\"}','',141.00),(166,'txtimg_color1','000000',0,1,'text','Text to Image color',NULL,NULL,166.00),(188,'wizard_map_zoomlevel','11',1,3,'text','Wizard Map Zoom-level','','',7.00),(200,'autoupdate_exchange_rates','0',1,1,'select','Auto-update exchange rates','','{\"values\":[{\"key\":0,\"value\":\"Disabled\"},{\"key\":1,\"value\":\"Enabled\"}]}',97.00);
CREATE TABLE `wp_wpl_sort_options` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kind` varchar(50) NOT NULL DEFAULT '[0][1]',
  `name` text,
  `field_name` varchar(255) DEFAULT NULL,
  `enabled` tinyint(4) NOT NULL DEFAULT '1',
  `index` float(5,2) NOT NULL DEFAULT '99.00',
  PRIMARY KEY (`id`),
  KEY `kind` (`kind`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8;
INSERT INTO `wp_wpl_sort_options` VALUES (1,'[0][1]','Listing ID','p.mls_id',1,4.00),(2,'[0][1]','Price','p.price_si',1,6.00),(3,'[0][1]','Built up Area','p.living_area_si',1,5.00),(4,'[0][1]','Bedrooms','p.bedrooms',0,9.00),(5,'[0][1]','Rank','p.property_rank',0,8.00),(6,'[0][1]','Pictures','p.pic_numb',1,10.00),(7,'[0][1]','Listing','p.listing',0,12.00),(8,'[0][1]','Property Type','p.property_type',0,13.00),(9,'[0][1]','Add date','p.add_date',1,11.00),(10,'[0][1]','View','p.view',0,15.00),(11,'[0][1]','Lot Area','p.lot_area_si',0,16.00),(12,'[0][1]','Zipcode','p.zip_name',0,17.00),(31,'[2]','Name','p.first_name',1,99.00),(32,'[2]','Country','p.location1_name',1,99.00),(33,'[2]','State','p.location2_name',0,99.00);
CREATE TABLE `wp_wpl_unit_types` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
INSERT INTO `wp_wpl_unit_types` VALUES (1,'Length'),(2,'Area'),(3,'Volume'),(4,'Currency');
CREATE TABLE `wp_wpl_units` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `type` tinyint(4) NOT NULL DEFAULT '2' COMMENT '1=length,2=area,3=volume 4=price',
  `enabled` tinyint(4) NOT NULL DEFAULT '0',
  `tosi` double NOT NULL DEFAULT '0',
  `index` int(11) NOT NULL DEFAULT '999',
  `extra` varchar(50) DEFAULT NULL COMMENT 'iso code',
  `extra2` varchar(50) DEFAULT NULL COMMENT 'currency name',
  `extra3` varchar(50) DEFAULT NULL COMMENT 'icon',
  `extra4` varchar(50) DEFAULT NULL,
  `seperator` varchar(2) DEFAULT NULL,
  `d_seperator` varchar(2) DEFAULT NULL,
  `after_before` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0=before,1=after',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=271 DEFAULT CHARSET=utf8;
INSERT INTO `wp_wpl_units` VALUES (1,'Sqft',2,1,0.093,1,'','','','','','',0),(2,'m&sup2;',2,1,1,2,'','','','','','',0),(3,'Acre',2,0,4046.873,3,'','','','','','',0),(4,'km&sup2;',2,0,1000000,4,'','','','','','',0),(5,'sq mi',2,0,2589988,6,'','','','','','',0),(6,'sq yd',2,0,0.836,5,'','','','','','',0),(7,'Hectare',2,0,10000,7,'','','','','','',0),(11,'m',1,1,1,0,'','','','','','',0),(12,'ft',1,1,0.305,0,'','','','','','',0),(13,'km',1,1,1000,2,'','','','','','',0),(14,'mi',1,1,1609.344,5,'','','','','','',0),(15,'yd',1,0,0.9144,6,'','','','','','',0),(16,'cm',1,0,0.01,7,'','','','','','',0),(17,'in',1,0,0.0254,0,'','','','','','',0),(21,'m&sup3;',3,0,1,1,'','','','','','',0),(100,'ლ',4,0,0.5977,9,'GEL','Georgian Lari','Abkhazia','Tetri','','',0),(101,'؋',4,0,0.0184,11,'AFN','Afghan Afghani','Afghanistan','Pul','','',0),(102,'L',4,0,0.0094,12,'ALL','Albania Lek','Albanian','Qintar','','',0),(103,'£',4,0,87.9,13,'GBP','Alderney Pound','Alderney','Penny','','',0),(104,'د.ج',4,0,0.0126,14,'DZD','Algerian Dinar','Algeria','Centime','','',0),(105,'Kz',4,0,0.0104,15,'AOA','Angolan Kwanza','Angola','Cêntimo','','',0),(106,'$',4,0,0.1886,16,'ARS','Argentine Peso','Argentina','Centavo','','',0),(107,'դր.',4,0,0.0024,17,'AMD','Armenian Dram','Armenia','Luma','','',0),(108,'Afl.',4,0,0.5587,18,'AWG','Aruban Florin','Aruba','Cent','','',0),(109,'$, A$ or AU$',4,0,0.9435,6,'AUD','Australian Dollar','Australia','Cent','','',0),(110,'m, ман. or man.',4,0,1.2742,19,'AZN','Azerbaijani Manat','Azerbaijan','qəpik','','',0),(111,'B$',4,0,1,20,'BSD','Bahamian dollar','Bahamas','Cent','','',0),(112,'.د.ب (Arabic), or BD (Latin),',4,0,2.652,21,'BHD','Bahraini Dollar','Bahrain','Fils','','',0),(113,'৳, ৲',4,0,0.0129,22,'BDT','Bangladeshi Taka','Bangladesh','Poisha','','',0),(114,'Bds$',4,0,0.5,23,'BBD','Barbadian Dollar','Barbados','Cent','','',0),(115,'Br',4,0,0.0001,24,'BYR','Belarusian Ruble','Belarus','Kapeyka','','',0),(116,'BZ$',4,0,0.5,25,'BZD','Belize Dollar','Belize','Cent','','',0),(117,'BD$',4,0,1,26,'BMD','Bermudian Dollar','Bermuda','Cent','','',0),(118,'Nu. or Ch.',4,0,0.0173,27,'BTN','Bhutanese Ngultrum','Bhutan','Chhertum','','',0),(119,'Bs.',4,0,0.1447,28,'BOB','Bolivian Boliviano','Bolivia','Centavo','','',0),(120,'KM (Latin), or КМ (Cyrillic),',4,0,0.6733,29,'BAM','Bosnia and Herzegovina Marka','Bosnia and Herzegovina','fening (Latin), or фенинг (Cyrillic),','','',0),(121,'P',4,0,0.1175,30,'BWP','Botswana Pula','Botswana','thebe','','',0),(122,'R$ or Ɽ',4,0,0.4678,31,'BRL','Brazillian Real','Brazil','Centavo','','',0),(123,'B$',4,0,0.7969,32,'BND','Brunei Dollar','Sultanate of Brunei','Sen','','',0),(124,'лв',4,0,0.676,33,'BGN','Bulgarian Lev','Bulgaria','Stotinka','','',0),(125,'FBu',4,0,0.0006,34,'BIF','Burundian Franc','Burundi','Centime','','',0),(126,'៛',4,0,0.0003,35,'KHR','Cambodian Riel','Cambodia','1/10 Kak','','',0),(127,'C$',4,0,0.9805,5,'CAD','Canadian Dollar','Canada','Cent','','',0),(128,'Esc or $',4,0,0.012,36,'CVE','Cap Werdean Escudo','Cape Verde','Centavo','','',0),(129,'$',4,0,1.2195,37,'KYD','Cayman Islands Dollar','Caymen Islands','Cent','','',0),(130,'FCFA, c',4,0,0.002,38,'XAF','Central African CFA franc','Central Africa','Centime','','',0),(131,'$',4,0,0.002,39,'CLP','Chilean Peso','Chile','Centavo','','',0),(132,'$',4,0,0.0005,40,'COP','Colombian Peso','Republic of Colombia','Centavo','','',0),(133,'CF',4,0,0.0027,41,'KMF','Comorian Franc','Comoros','Centime','','',0),(134,'Fr',4,0,0.0011,42,'CDF','Congolese Franc','Democratic Republic of Congo','Centime','','',0),(135,'$ or c',4,0,87.6,43,'NZD','Cook Islands Dollar','Cook Islands','Cent','','',0),(136,'₡',4,0,0.002,44,'CRC','Costa Rican colón','Costa Rica','Céntimo','','',0),(137,'kn or lp',4,0,0.1714,45,'HRK','Croatian Kuna','Croatia','Lipa','','',0),(138,'$, CUC or CUC$',4,0,87.6,46,'CUC','Cuban Convertible Peso','Cuba','Centavo','','',0),(139,'$ or $MN',4,0,1,47,'CUP','Cuban Peso','Cuba','Centavo','','',0),(140,'K�? or h',4,0,0.0505,48,'CZK','Czech Koruna','Czech Republic','Haléř','','',0),(141,'kr',4,0,0.1743,49,'DKK','Danish Krone','Denmark','øre or kroner','','',0),(142,'Fdj',4,0,0.0056,50,'DJF','Djiboutian Franc','Djibouti','Centime','','',0),(143,'RD$',4,0,0.0243,51,'DOP','Dominican Peso','Dominican Republic','Centavo','','',0),(144,'$',4,0,0.3704,52,'XCD','East Caribbean Dollar','East Caribbean','Cent','','',0),(145,'$',4,0,1,10,'USD','Ecuadorian Centavo Coins','Ecuador','Cent','','',0),(146,'£, LE, or ج.م or Pt.',4,0,0.1431,53,'EGP','Egyptian Pound','Egypt','qirsh or','','',0),(147,'Nfk',4,0,0.0888,54,'ERN','Eritrean Nakfa','Eritrea','Cent','','',0),(148,'KR',4,0,0,55,'EEK','Estonian Kroon','Estonia','Sent','','',0),(149,'Br',4,0,0.0536,56,'ETB','Ethiopian Birr','Ethiopia','Santim','','',0),(150,'€',4,1,1.3634,2,'EUR','Euro','European-Union','Euro',',','',0),(151,'£ or p',4,0,1.5193,57,'FKP','Flakland Islands Pound','Falkland Islands','Penny','','',0),(152,'kr',4,0,0.1743,58,'DKK','Faroese Króna','Faroe Islands','Oyra','','',0),(153,'FJ$',4,0,0.5433,59,'FJD','Fijian Dollar','Fiji','Cent','','',0),(154,'D',4,0,0.0295,60,'GMD','Gambian Dalasi','Gambia','Butut','','',0),(155,'ლ',4,0,0.6091,61,'GEL','Georgian Lari','Georgia','Tetri','','',0),(156,'GH₵',4,0,0.5007,62,'GHS','Ghanaian Cedi','Ghana','Pesewa','','',0),(157,'£ or p',4,0,1.5194,63,'GIP','Gibraltar Pound','Gibraltar','Penny','','',0),(158,'Q',4,0,0.1283,64,'GTQ','Guatemalan Quetzal','Guatemala','Centavo','','',0),(159,'£ or p',4,0,87.6,65,'GBP','Guernsey Pound','Guernsey','Penny','','',0),(160,'FG or Fr/GFr',4,0,0.0001,66,'GNF','Guinean Franc','Guinea','Centime','','',0),(161,'$',4,0,0.0049,67,'GYD','Guyanese Dollar','Guyana','Cent','','',0),(162,'G',4,0,0.0236,68,'HTG','Haitian Gourde','Haiti','Centime','','',0),(163,'L',4,0,0.0494,69,'HNL','Hondyran Lempira','Honduras','Centavo','','',0),(164,'£ or HK$',4,0,0.1288,70,'HKD','Hong Kong Dollar','Hong Kong','Cent','','',0),(165,'Ft',4,0,0.0044,71,'HUF','Hungarian Forint','Hungary','Fillér','','',0),(166,'kr, �?kr',4,0,0.0081,72,'ISK','Icelandic Króna','Iceland','Eyrir','','',0),(167,'',4,0,0.0177,73,'INR','Indian Rupee','India','Paisa','','',0),(168,'Rp',4,0,0.0001,74,'IDR','Indonesian Rupiah','Indonesia','Sen','','',0),(169,'﷼',4,0,0.0001,75,'IRR','Iranian Rial','Iran','Toman or Dinar','','',0),(170,'ع.د',4,0,0.0009,76,'IQD','Iraqi Dinar','Iraq','Fils','','',0),(171,'₪',4,0,0.2711,77,'ILS','Israeli New Sheqel','Israel','Agora','','',0),(172,'$',4,0,0.0101,78,'JMD','Jamaican Dollar','Jamaica','Cent','','',0),(173,'¥',4,0,0.0102,7,'JPY','Japanese Yen','Japan','Sen or Rin','','',0),(174,'£ or p',4,0,87.6,79,'GBP','Jersey Pound','Jersey','Penny','','',0),(175,'د.ا',4,0,1.4104,80,'JOD','Jordanian Dinar','Jordan','Dirham','','',0),(176,'',4,0,0.0066,81,'KZT','Kazakhstani tenge','Kazakhstan','tiyn (тиын),','','',0),(177,'KSh',4,0,0.0117,82,'KES','Kenyan Shilling','Kenya','Cent','','',0),(178,'$ or ¢',4,0,87.6,83,'AUD','Kiribati Dollar','Kiribati','Cent','','',0),(179,'د.ك',4,0,3.4955,84,'KWD','Kuwaiti Dinar','Kuwait','Fils','','',0),(180,'N/A',4,0,0.0207,85,'KGS','Kyrgyzstani som','Kyrgyz Republic','Tyiyn','','',0),(181,'₭ or ₭N',4,0,0.0001,86,'LAK','Lao Kip','Laos','Att','','',0),(182,'Ls or s',4,0,1.8505,87,'LVL','Latvian Lats','Lativa','Santims','','',0),(183,'ل.ل',4,0,0.0007,88,'LBP','Lebanese Pound','Lebanon','Piastre','','',0),(184,'L or M',4,0,0.0994,89,'LSL','Lesotho Loti','Lesotho','Sente','','',0),(185,'L$',4,0,0.0133,90,'LRD','Liberian Dollar','Liberia','Cent','','',0),(186,'LD and ل.د',4,0,0.78,91,'LYD','Libyan Dinar','Libya','Dirham','','',0),(187,'Lt',4,0,0.376,92,'LTL','Lithuanian Litas','Lithuania','Centas','','',0),(188,'MOP$',4,0,0.1251,93,'MOP','Macanese Pataca','Macau','Avo','','',0),(189,'ден',4,0,0.0208,94,'MKD','Macedonian Denar','Republic of Macedonia','Deni','','',0),(190,'N/A',4,0,0.0005,95,'MGA','Malagasy Ariary','Madagascar','Iraimbilanja','','',0),(191,'MK',4,0,0.003,96,'MWK','Malawian Kwacha','Malawi','Tambala','','',0),(192,'RM',4,0,0.3227,97,'MYR','Malaysian Ringgit','Malaysia','Sen','','',0),(193,'Rf, MRf, or .ރ',4,0,0.0649,98,'MVR','Maldivian Rufiyaa','Maldives','Laari','','',0),(194,'£ or p',4,0,87.6,99,'GBP','Manx Pound','Isle Of Man','Penny','','',0),(195,'UM',4,0,0.0034,100,'MRO','Mauritanian Ouguiya','Mauritania','Khoums','','',0),(196,'Rs',4,0,0.032,101,'MUR','Mauritian Rupee','Mauritius','Cent','','',0),(197,'$ or Mex$ / ¢',4,0,0.078,102,'MXN','Mexican Peso','Mexico','Centavo','','',0),(198,'L',4,0,0.08,103,'MDL','Moldovan Leu','Moldova','Ban','','',0),(199,'₮',4,0,0.0007,104,'MNT','Mongolian Tögrög','Mongolia','Möngö(мөнгө),','','',0),(200,'د.م',4,0,0.1168,105,'MAD','Moroccan Dirham','Morocco','Santim','','',0),(201,'MTn',4,0,0.0336,106,'MZN','Mozambican Metical','Mozambique','Centavo','','',0),(202,'K',4,0,0.0011,107,'MMK','Myanma Kyat','Myanmar/Burma','Pya','','',0),(203,'N$',4,0,0.0993,108,'NAD','Namibian Dollar','Namibia','Cent','','',0),(204,'Rs',4,0,0.0111,109,'NPR','Nepalese Rupee','Nepal','Paisa','','',0),(205,'NAƒ, NAf, ƒ, or f',4,0,0.5587,110,'ANG','Netherlands Antillean Guilder','Netherlands Antilles','Cent','','',0),(206,'$ or NT$',4,0,0.0333,111,'TWD','New Taiwan Dollar','New Taiwan','Cent','','',0),(207,'$ or c',4,0,0.7947,112,'NZD','New Zealand Dollar','New Zealand','Cent','','',0),(208,'C$',4,0,0.0402,113,'NIO','Nicaraguan Córdoba','Nicaragua','Centavo','','',0),(209,'₦',4,0,0.0063,114,'NGN','Nigerian Naira','Nigeria','Kobo','','',0),(210,'₩',4,0,0.0011,115,'KPW','North Korean Won','North Korea','Ch�?n','','',0),(211,'kr',4,0,0.1703,116,'NOK','Norweigian Krone','Norway','øre','','',0),(212,'ر.ع.',4,0,2.5998,117,'OMR','Omani Rial','Oman','Baisa','','',0),(213,'Rs',4,0,0.0102,118,'PKR','Pakistani Rupee','Pakistan','Paisa','','',0),(214,'B/. or B',4,0,1,119,'PAB','Panamanian Blaboa','Panama','Centesimo','','',0),(215,'K',4,0,0.4401,120,'PGK','Papua New Guinea Kina','Papua New Guinea','Toea','','',0),(216,'₲',4,0,0.0002,121,'PYG','Paraguayan Guarani','Paraguay','Centimo','','',0),(217,'S/.',4,0,0.3655,122,'PEN','Peruvian Nuevo Sol','Peru','Centimo','','',0),(218,'',4,0,0.0237,123,'PHP','Philippine Peso','Philippines','Sentimo','','',0),(219,'zł or gr',4,0,0.304,124,'PLN','Polish złoty','Poland','Grosz','','',0),(220,'£',4,1,1.6412,3,'GBP','Pound Sterling','England','Penny',',','',0),(221,'QR or ر.ق',4,0,0.2746,125,'QAR','Qatari Riyal','Qatar','Dirham','','',0),(222,'¥',4,0,0.1629,126,'CNY','Renminbi','PRC','jiǎo (角','','',0),(223,'L',4,0,0.2954,127,'RON','Romanian Leu','Romania','Bani','','',0),(224,'руб. / Р. / р. or',4,0,0.0313,128,'RUB','Russian Ruble','Russia','Kopek','','',0),(225,'RF',4,0,0.0016,129,'RWF','Rwandan Franc','Rwanda','Centime','','',0),(226,'£',4,0,1.5194,130,'SHP','Saint Helena Pound','Saint Helena','Penny','','',0),(227,'₡',4,0,0.1143,131,'SVC','Salvadorian Colón','El Salvador','Centavo','','',0),(228,'WS$',4,0,0.4364,132,'WST','Samoan Tala','Samoa','Sene','','',0),(229,'ر.س (Arabic),, SR (Latin),',4,0,0.2666,133,'SAR','Saudi Riyal','Saudi Arabia','Halala','','',0),(230,'РСД and RSD',4,0,0.0115,134,'RSD','Serbian Dinar','Serbia','Para','','',0),(231,'SR or SRe',4,0,0.0847,135,'SCR','Seychellois Rupee','Seychelles','Cent','','',0),(232,'Le',4,0,0.0002,136,'SLL','Sierra Leonean Leone','Sierra Leone','Cent','','',0),(233,'S$',4,0,0.7908,137,'SGD','Singapore Dollar','Singapore','Cent','','',0),(234,'SI$',4,0,0.1391,138,'SBD','Solomon Islands Dollar','Solomon Islands','Cent','','',0),(235,'So. Sh.',4,0,0.0007,139,'SOS','Somali Shilling','Somalia','Cent','','',0),(236,'Sl. Sh.',4,0,0.0007,140,'SOS','Somaliland Shilling','Somaliland','Cent','','',0),(237,'R or c',4,0,0.0993,141,'ZAR','South African Rand','South Africa','Cent','','',0),(238,'₩',4,0,0.0009,142,'KRW','South Korean Won','South Korea','Jeon','','',0),(239,'Rs or SLRss/SLRs',4,0,0.0079,143,'LKR','Sri Lankan Rupee','Sri Lanka','Cents','','',0),(240,'£',4,0,0.2272,144,'SDG','Sudanese Pound','Sudan','Qirsh','','',0),(241,'$',4,0,0.3042,145,'SRD','Surinamese Dollar','Suriname','Cent','','',0),(242,'L or E',4,0,0.0993,146,'SZL','Swazi Lilangeni','Swaziland','Cent','','',0),(243,'kr, :-',4,0,0.1521,8,'SEK','Swedish Krona','Sweden','öre','','',0),(244,'CHF, Fr., SFr. (old),',4,0,1.1024,4,'CHF','Swiss Franc','Switzerland','Centime',',','',0),(245,'£ or ل.س',4,0,0.0103,147,'SYP','Syrian Pound','Syria','Piastre','','',0),(246,'Db',4,0,0.0001,148,'STD','São Tomé and Príncipe dobra','São Tomé and Príncipe','cêntimo','','',0),(247,'SM',4,0,0.2103,149,'TJS','Tajikistani Somoni','Tajikistan','Dirham','','',0),(248,'x/y',4,0,0.0006,150,'TZS','Tanzanian Shilling','Tanzania','Senti','','',0),(249,'฿',4,0,0.0329,151,'THB','Thai Baht','Thailand','Satang','','',0),(250,'T$ or PT - ¢',4,0,0.5743,152,'TOP','Tongan Pa\'anga','Tonga','Seniti','','',0),(251,'p.',4,0,87.6,153,'PRB','Transnistrian Ruble','Transnistria','Kopecks','','',0),(252,'$',4,0,0.1558,154,'TTD','Trinidad and Tobago Dollar','Trinidad and Tobago','Cent','','',0),(253,'د.ت (Arabic), or DT (Latin),',4,0,0.6085,155,'TND','Tunisian Dollar','Tunisia','Milim','','',0),(254,'TL',4,0,0.5333,156,'TRY','Turkish Lira','Turkey','kuruş','','',0),(255,'m',4,0,0.3506,157,'TMT','Turkmenistani manat','Turkmenistan','tennesi (tenge),','','',0),(256,'$ or ¢',4,0,0,158,'TVD','Tuvaluan Dollar','Tivalu','Cent','','',0),(257,'USh',4,0,0.0004,159,'UGX','Ugandan Shilling','Uganda','Cent','','',0),(258,'₴',4,0,0.1226,160,'UAH','Ukrainian hryvnia','Ukraine','kopiyka (копійка),','','',0),(259,'د.إ',4,0,0.2722,161,'AED','United Arab Emirates dirham','United Arab Emirates','fils','','',0),(260,'$',4,1,1,1,'USD','United States dollar','United-States','Dime/ Cent /Mill',',','',0),(261,'$',4,0,0.0496,162,'UYU','Uruguayan peso','Uruguay','centésimo','','',0),(262,'N/A',4,0,0.0005,163,'UZS','Uzbekistani som','Uzbekistan','tiyin','','',0),(263,'Vt',4,0,0.0106,164,'VUV','Vanuatu vatu','Vanuatu','none','','',0),(264,'Bs. F',4,0,0.1589,165,'VEF','Venezuelan bolívar','Venezuela','céntimo','','',0),(265,'₫',4,0,0,166,'VND','Vietnamese đồng','Vietnam','hào or xu','','',0),(266,'CFA or c',4,0,0.002,167,'XOF','West African CFA franc','West Africa','centime','','',0),(267,'﷼',4,0,0.0047,168,'YER','Yemeni Rial','Yemen','Fils','','',0),(268,'ZK',4,0,0.0002,169,'ZMK','Zambian Kwacha','Zambia','Ngwee','','',0),(269,'$',4,0,0.0031,170,'ZWL','Zimbabwean Dollar','Zimbabwe','Cent','','',0),(270,'¥',4,0,0.16,999,'CNY','Chinese Yuan Renminbi','china','Fen',NULL,NULL,0);
CREATE TABLE `wp_wpl_user_group_types` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `default_membership_id` int(10) NOT NULL DEFAULT '-1',
  `description` text,
  `editable` tinyint(4) unsigned NOT NULL DEFAULT '1',
  `deletable` tinyint(4) unsigned NOT NULL DEFAULT '1',
  `index` float(5,2) NOT NULL DEFAULT '99.00',
  `params` text,
  `enabled` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
INSERT INTO `wp_wpl_user_group_types` VALUES (1,'Agents',-1,NULL,1,0,1.00,NULL,1),(2,'Owners',-1,NULL,1,0,2.00,NULL,1),(3,'Guests',-1,NULL,1,0,0.50,NULL,1);
CREATE TABLE `wp_wpl_users` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `membership_name` varchar(255) DEFAULT NULL,
  `membership_id` int(10) DEFAULT NULL,
  `membership_type` varchar(10) DEFAULT NULL,
  `index` float(5,2) NOT NULL DEFAULT '99.00',
  `access_propertywizard` tinyint(4) NOT NULL DEFAULT '0',
  `access_propertyshow` tinyint(4) NOT NULL DEFAULT '1',
  `access_propertylisting` tinyint(4) NOT NULL DEFAULT '1',
  `access_profilewizard` tinyint(4) NOT NULL DEFAULT '1',
  `access_confirm` tinyint(4) NOT NULL DEFAULT '0',
  `access_propertymanager` tinyint(4) NOT NULL DEFAULT '0',
  `access_delete` tinyint(4) NOT NULL DEFAULT '0',
  `access_public_profile` tinyint(4) NOT NULL DEFAULT '1',
  `access_change_user` tinyint(4) NOT NULL DEFAULT '0',
  `access_receive_notifications` tinyint(4) NOT NULL DEFAULT '1',
  `first_name` varchar(255) DEFAULT NULL,
  `last_name` varchar(255) DEFAULT NULL,
  `about` text,
  `company_name` varchar(255) DEFAULT NULL,
  `company_address` varchar(255) DEFAULT NULL,
  `website` varchar(255) DEFAULT NULL,
  `main_email` varchar(255) DEFAULT NULL,
  `secondary_email` varchar(255) DEFAULT NULL,
  `sex` tinyint(4) DEFAULT NULL,
  `tel` varchar(20) DEFAULT NULL,
  `fax` varchar(20) DEFAULT NULL,
  `mobile` varchar(20) DEFAULT NULL,
  `languages` text,
  `location1_id` int(11) NOT NULL DEFAULT '0',
  `location2_id` int(11) NOT NULL DEFAULT '0',
  `location3_id` int(11) NOT NULL DEFAULT '0',
  `location4_id` int(11) NOT NULL DEFAULT '0',
  `location5_id` int(11) NOT NULL DEFAULT '0',
  `location6_id` int(11) NOT NULL DEFAULT '0',
  `location7_id` int(11) NOT NULL DEFAULT '0',
  `location1_name` varchar(50) DEFAULT NULL,
  `location2_name` varchar(50) DEFAULT NULL,
  `location3_name` varchar(50) DEFAULT NULL,
  `location4_name` varchar(50) DEFAULT NULL,
  `location5_name` varchar(50) DEFAULT NULL,
  `location6_name` varchar(50) DEFAULT NULL,
  `location7_name` varchar(50) DEFAULT NULL,
  `zip_id` int(11) NOT NULL DEFAULT '0',
  `zip_name` varchar(20) DEFAULT NULL,
  `maccess_num_prop` int(10) DEFAULT NULL,
  `maccess_num_feat` int(10) DEFAULT NULL,
  `maccess_num_hot` int(10) DEFAULT NULL,
  `maccess_num_pic` int(10) DEFAULT NULL,
  `maccess_period` int(10) DEFAULT NULL,
  `maccess_price` double DEFAULT NULL,
  `maccess_price_unit` int(10) DEFAULT NULL,
  `maccess_lrestrict` int(4) DEFAULT NULL,
  `maccess_listings` varchar(255) DEFAULT NULL,
  `maccess_ptrestrict` int(4) DEFAULT NULL,
  `maccess_property_types` varchar(255) DEFAULT NULL,
  `maccess_renewable` int(4) DEFAULT NULL,
  `maccess_renewal_price` double DEFAULT NULL,
  `maccess_renewal_price_unit` int(11) DEFAULT NULL,
  `maccess_upgradable` int(4) DEFAULT NULL,
  `maccess_upgradable_to` text,
  `maccess_short_description` text,
  `maccess_long_description` text,
  `maccess_wpl_color` varchar(10) DEFAULT NULL,
  `expired` tinyint(4) NOT NULL DEFAULT '0',
  `expiry_date` datetime DEFAULT NULL,
  `textsearch` text,
  `location_text` varchar(255) DEFAULT NULL,
  `rendered` text,
  `last_modified_time_stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `profile_picture` varchar(255) DEFAULT NULL,
  `company_logo` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
INSERT INTO `wp_wpl_users` VALUES (-2,'Guest',0,'3',99.00,0,1,1,0,0,0,0,0,0,1,'','',NULL,'','','','','',0,'','','','',0,0,0,0,0,0,0,'','','','','','','',0,'',0,0,0,0,0,0,0,0,'',0,'',0,0,0,0,'',NULL,NULL,NULL,0,NULL,'',NULL,'','2016-03-11 11:35:33','',''),(-1,'Default',-1,'1',99.00,1,1,1,1,0,1,1,0,0,1,'','',NULL,'','','','','',0,'','','','',0,0,0,0,0,0,0,'','','','','','','',0,'',-1,-1,-1,-1,0,0,0,0,'',0,'',0,0,0,0,'',NULL,NULL,NULL,0,NULL,'',NULL,'','2016-03-11 11:35:33','',''),(0,'Guest',-2,'3',99.00,0,1,1,0,0,0,0,0,0,1,'','',NULL,'','','','','',0,'','','','',0,0,0,0,0,0,0,'','','','','','','',0,'',0,0,0,0,0,0,0,0,'',0,'',0,0,0,0,'',NULL,NULL,NULL,0,NULL,'',NULL,'','2016-03-11 11:35:33','',''),(1,'Default',-1,'1',99.00,1,1,1,1,0,1,1,0,0,1,'','',NULL,'','','','info@2niteshow.com','',0,'','','','',0,0,0,0,0,0,0,'','','','','','','',0,'',-1,-1,-1,-1,0,0,0,0,'',0,'',0,0,0,0,'',NULL,NULL,NULL,0,NULL,'Email info@2niteshow.com ','','{\"rendered\":{\"914\":{\"field_id\":\"914\",\"type\":\"text\",\"name\":\"Email\",\"value\":\"info@2niteshow.com\"},\"911\":{\"field_id\":\"911\",\"type\":\"locations\",\"name\":\"Location\"}},\"materials\":{\"main_email\":{\"field_id\":\"914\",\"type\":\"text\",\"name\":\"Email\",\"value\":\"info@2niteshow.com\"}},\"location_text\":\"\"}','2016-03-11 11:35:33','','');
CREATE TABLE `wp_wpms_links` (
  `id` int(20) unsigned NOT NULL AUTO_INCREMENT,
  `link_url` text CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL,
  `link_final_url` text CHARACTER SET latin1 COLLATE latin1_general_cs,
  `link_url_redirect` text CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL,
  `link_text` text NOT NULL,
  `source_id` int(20) DEFAULT '0',
  `type` varchar(100) DEFAULT '',
  `status_code` varchar(100) DEFAULT '',
  `status_text` varchar(250) DEFAULT '',
  `hit` int(20) NOT NULL DEFAULT '1',
  `redirect` tinyint(1) NOT NULL DEFAULT '0',
  `broken_indexed` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `broken_internal` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `warning` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `dismissed` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=latin1;
INSERT INTO `wp_wpms_links` VALUES (1,'www.vestacapital.com.au/wp-content/themes/images/transparency-grid.png',NULL,'','',0,'404_automaticaly','404 Not Found','404 Not Found',22,0,1,0,0,0),(2,'www.vestacapital.com.au/.well-known/autoconfig/mail/config-v1.1.xml',NULL,'','',0,'404_automaticaly','404 Not Found','404 Not Found',1,0,1,0,0,0),(3,'www.vestacapital.com.au/cpanel_account_suspended.html',NULL,'','',0,'404_automaticaly','404 Not Found','404 Not Found',3,0,1,0,0,0),(27,'http://www.vestacapital.com.au/wp-content/uploads/2016/02/image-3-300x200.jpeg','http://www.vestacapital.com.au/wp-content/uploads/2016/02/image-3-300x200.jpeg','','',2,'image','HTTP/1.1 200 OK','200 OK',1,0,0,0,0,0),(28,'http://www.vestacapital.com.au/wp-content/uploads/2016/02/image-8-300x173.jpeg','http://www.vestacapital.com.au/wp-content/uploads/2016/02/image-8-300x173.jpeg','','',2,'image','HTTP/1.1 200 OK','200 OK',1,0,0,0,0,0),(29,'http://www.vestacapital.com.au/wp-content/uploads/2016/02/image-5-300x298.jpeg','http://www.vestacapital.com.au/wp-content/uploads/2016/02/image-5-300x298.jpeg','','',2,'image','HTTP/1.1 200 OK','200 OK',1,0,0,0,0,0),(30,'http://www.vestacapital.com.au/wp-content/uploads/2016/02/image-9-300x225.jpeg','http://www.vestacapital.com.au/wp-content/uploads/2016/02/image-9-300x225.jpeg','','',2,'image','HTTP/1.1 200 OK','200 OK',1,0,0,0,0,0),(31,'http://www.vestacapital.com.au/wp-content/uploads/2016/02/image-300x94.gif','http://www.vestacapital.com.au/wp-content/uploads/2016/02/image-300x94.gif','','',2,'image','HTTP/1.1 200 OK','200 OK',1,0,0,0,0,0),(32,'http://www.vestacapital.com.au/wp-content/uploads/2016/02/image-3-300x100.png','http://www.vestacapital.com.au/wp-content/uploads/2016/02/image-3-300x100.png','','',2,'image','HTTP/1.1 200 OK','200 OK',1,0,0,0,0,0),(33,'http://www.vestacapital.com.au/wp-content/uploads/2016/02/image-11-300x125.jpeg','http://www.vestacapital.com.au/wp-content/uploads/2016/02/image-11-300x125.jpeg','','',2,'image','HTTP/1.1 200 OK','200 OK',1,0,0,0,0,0),(34,'http://www.vestacapital.com.au/wp-content/uploads/2016/02/image-10.jpeg','http://www.vestacapital.com.au/wp-content/uploads/2016/02/image-10.jpeg','','',2,'image','HTTP/1.1 200 OK','200 OK',1,0,0,0,0,0),(35,'http://www.vestacapital.com.au/wp-content/uploads/2016/02/image-5-283x300.png','http://www.vestacapital.com.au/wp-content/uploads/2016/02/image-5-283x300.png','','',2,'image','HTTP/1.1 200 OK','200 OK',1,0,0,0,0,0),(36,'http://www.vestacapital.com.au/wp-content/uploads/2016/02/image-4-300x285.png','http://www.vestacapital.com.au/wp-content/uploads/2016/02/image-4-300x285.png','','',2,'image','HTTP/1.1 200 OK','200 OK',1,0,0,0,0,0),(37,'http://www.vestacapital.com.au/wp-content/uploads/2016/02/image-13-300x107.jpeg','http://www.vestacapital.com.au/wp-content/uploads/2016/02/image-13-300x107.jpeg','','',2,'image','HTTP/1.1 200 OK','200 OK',1,0,0,0,0,0),(38,'http://www.vestacapital.com.au/wp-content/uploads/2016/02/image-8-300x112.png','http://www.vestacapital.com.au/wp-content/uploads/2016/02/image-8-300x112.png','','',2,'image','HTTP/1.1 200 OK','200 OK',1,0,0,0,0,0),(39,'http://www.vestacapital.com.au/wp-content/uploads/2016/02/image-14-300x118.jpeg','http://www.vestacapital.com.au/wp-content/uploads/2016/02/image-14-300x118.jpeg','','',2,'image','HTTP/1.1 200 OK','200 OK',1,0,0,0,0,0),(40,'http://www.vestacapital.com.au/wp-content/uploads/2016/02/image-6-300x200.png','http://www.vestacapital.com.au/wp-content/uploads/2016/02/image-6-300x200.png','','',2,'image','HTTP/1.1 200 OK','200 OK',1,0,0,0,0,0),(41,'http://www.vestacapital.com.au/wp-content/uploads/2016/02/image-7-300x96.png','http://www.vestacapital.com.au/wp-content/uploads/2016/02/image-7-300x96.png','','',2,'image','HTTP/1.1 200 OK','200 OK',1,0,0,0,0,0),(42,'http://www.vestacapital.com.au/wp-content/uploads/2016/02/image-15-300x100.jpeg','http://www.vestacapital.com.au/wp-content/uploads/2016/02/image-15-300x100.jpeg','','',2,'image','HTTP/1.1 200 OK','200 OK',1,0,0,0,0,0),(43,'http://www.vestacapital.com.au/wp-content/uploads/2016/02/image-12-300x145.jpeg','http://www.vestacapital.com.au/wp-content/uploads/2016/02/image-12-300x145.jpeg','','',2,'image','HTTP/1.1 200 OK','200 OK',1,0,0,0,0,0),(44,'http://www.vestacapital.com.au/wp-content/uploads/2016/02/image-9-300x74.png','http://www.vestacapital.com.au/wp-content/uploads/2016/02/image-9-300x74.png','','',2,'image','HTTP/1.1 200 OK','200 OK',1,0,0,0,0,0),(45,'http://www.vestacapital.com.au/wp-content/uploads/2016/02/image-16-257x300.jpeg','http://www.vestacapital.com.au/wp-content/uploads/2016/02/image-16-257x300.jpeg','','',2,'image','HTTP/1.1 200 OK','200 OK',1,0,0,0,0,0),(46,'http://www.vestacapital.com.au/wp-content/uploads/2016/02/image-10-300x200.png','http://www.vestacapital.com.au/wp-content/uploads/2016/02/image-10-300x200.png','','',2,'image','HTTP/1.1 200 OK','200 OK',1,0,0,0,0,0),(47,'http://www.vestacapital.com.au/wp-content/uploads/2016/02/image-17-237x300.jpeg','http://www.vestacapital.com.au/wp-content/uploads/2016/02/image-17-237x300.jpeg','','',2,'image','HTTP/1.1 200 OK','200 OK',1,0,0,0,0,0),(48,'http://www.vestacapital.com.au/wp-content/uploads/2016/02/image-18-300x107.jpeg','http://www.vestacapital.com.au/wp-content/uploads/2016/02/image-18-300x107.jpeg','','',2,'image','HTTP/1.1 200 OK','200 OK',1,0,0,0,0,0),(49,'http://www.vestacapital.com.au/wp-content/uploads/2016/02/image-11-300x194.png','http://www.vestacapital.com.au/wp-content/uploads/2016/02/image-11-300x194.png','','',2,'image','HTTP/1.1 200 OK','200 OK',1,0,0,0,0,0),(50,'www.vestacapital.com.au/wp-content/uploads/2016/02/10463183-business-finance-chart-diagram-bar-graphic-Stock-Photo-growth-150x150.jpg',NULL,'','',0,'404_automaticaly','404 Not Found','404 Not Found',462,0,1,0,0,0),(51,'www.vestacapital.com.au/wp-cron.php?doing_wp_cron=1457772332.9259760379791259765625',NULL,'','',0,'404_automaticaly','404 Not Found','404 Not Found',1,0,1,0,0,0),(52,'www.vestacapital.com.au/formstatic/fonts?family=Open+Sans:400,700i,700,600i,600,400i,300i,300',NULL,'','',0,'404_automaticaly','404 Not Found','404 Not Found',1,0,1,0,0,0),(53,'www.vestacapital.com.au/wp-cron.php?doing_wp_cron=1457788202.9464869499206542968750',NULL,'','',0,'404_automaticaly','404 Not Found','404 Not Found',1,0,1,0,0,0),(54,'www.vestacapital.com.au/wp-cron.php?doing_wp_cron=1457877386.2414119243621826171875',NULL,'','',0,'404_automaticaly','404 Not Found','404 Not Found',1,0,1,0,0,0),(55,'www.vestacapital.com.au/wp-content/themes/finance-business/css/animate.css?ver=1.0.0',NULL,'','',0,'404_automaticaly','404 Not Found','404 Not Found',1,0,1,0,0,0),(56,'www.vestacapital.com.au/wp-content/uploads/2016/02/The-UK-Fianc%C3%A9-Visa-The-Financial-Requirement.jpg',NULL,'','',0,'404_automaticaly','404 Not Found','404 Not Found',8,0,1,0,0,0),(57,'www.vestacapital.com.au/wp-admin/undefined',NULL,'','',0,'404_automaticaly','404 Not Found','404 Not Found',7,0,1,0,0,0),(58,'www.vestacapital.com.au/wp-content/themes/zerifprochild/custom.css?ver=4.4.2',NULL,'','',0,'404_automaticaly','404 Not Found','404 Not Found',63,0,1,0,0,0),(59,'www.vestacapital.com.au/wp-admin/',NULL,'','',0,'404_automaticaly','404 Not Found','404 Not Found',1,0,1,0,0,0),(60,'www.vestacapital.com.au/wp-content/themes/zerifprochild/style.css?ver=v1',NULL,'','',0,'404_automaticaly','404 Not Found','404 Not Found',1,0,1,0,0,0),(61,'www.vestacapital.com.au/wp-content/themes/zerifproCHILD/custom.css?ver=4.4.2',NULL,'','',0,'404_automaticaly','404 Not Found','404 Not Found',36,0,1,0,0,0),(62,'www.vestacapital.com.au/wp-content/uploads/2016/02/The-UK-Fianc%C3%A9-Visa-The-Financial-Requirement-150x150.jpg',NULL,'','',0,'404_automaticaly','404 Not Found','404 Not Found',3,0,1,0,0,0),(63,'www.vestacapital.com.au/wp-content/uploads/2016/02/The-UK-Fiancé-Visa-The-Financial-Requirement.jpg',NULL,'','',0,'404_automaticaly','404 Not Found','404 Not Found',1,0,1,0,0,0),(64,'www.vestacapital.com.au/Perspma;',NULL,'','',0,'404_automaticaly','404 Not Found','404 Not Found',3,0,1,0,0,0),(65,'www.vestacapital.com.au/wp-content/themes/finance-business/js/%7Btweet_url%7D',NULL,'','',0,'404_automaticaly','404 Not Found','404 Not Found',1,0,1,0,0,0);
