-- Table structure for table `tcx_wpefc_layeredimages`
--

CREATE TABLE `tcx_wpefc_layeredimages` (
  `id` mediumint(9) NOT NULL,
  `formID` smallint(5) NOT NULL,
  `itemID` smallint(5) NOT NULL,
  `title` varchar(120) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `ordersort` mediumint(9) NOT NULL,
  `image` varchar(250) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `showConditions` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `showConditionsOperator` varchar(8) COLLATE utf8mb4_unicode_520_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tcx_wpefc_links`
--

CREATE TABLE `tcx_wpefc_links` (
  `id` mediumint(9) NOT NULL,
  `formID` mediumint(9) NOT NULL,
  `originID` int(9) NOT NULL,
  `destinationID` int(9) NOT NULL,
  `conditions` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `operator` varchar(8) COLLATE utf8mb4_unicode_520_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `tcx_wpefc_links`
--

INSERT INTO `tcx_wpefc_links` (`id`, `formID`, `originID`, `destinationID`, `conditions`, `operator`) VALUES
(619, 1, 32, 39, '[{\"interaction\":\"32_149\",\"action\":\"clicked\"}]', ''),
(620, 1, 33, 38, '[]', ''),
(621, 1, 39, 42, '[]', ''),
(622, 1, 5, 4, '[]', ''),
(623, 1, 2, 5, '[]', ''),
(644, 5, 66, 43, '[]', ''),
(33, 2, 20, 21, '[]', ''),
(34, 2, 18, 19, '[{\"interaction\":\"18_77\",\"action\":\"clicked\"}]', ''),
(35, 2, 19, 20, '[{\"interaction\":\"19_80\",\"action\":\"clicked\"}]', ''),
(36, 2, 14, 15, '[]', ''),
(37, 2, 18, 14, '[{\"interaction\":\"18_76\",\"action\":\"clicked\"}]', ''),
(38, 2, 15, 16, '[]', ''),
(39, 2, 16, 17, '[]', ''),
(40, 2, 19, 21, '[]', ''),
(625, 1, 32, 33, '[{\"interaction\":\"32_150\",\"action\":\"clicked\"}]', 'OR'),
(626, 1, 27, 28, '[{\"interaction\":\"27_135\",\"action\":\"clicked\"},{\"interaction\":\"27_133\",\"action\":\"clicked\"},{\"interaction\":\"27_134\",\"action\":\"clicked\"}]', 'OR'),
(624, 1, 9, 1, '[{\"interaction\":\"9_22\",\"action\":\"clicked\"}]', ''),
(617, 1, 11, 12, '[{\"interaction\":\"11_25\",\"action\":\"clicked\"},{\"interaction\":\"11_26\",\"action\":\"clicked\"},{\"interaction\":\"11_27\",\"action\":\"clicked\"}]', 'OR'),
(618, 1, 12, 25, '[{\"interaction\":\"12_111\",\"action\":\"clicked\"},{\"interaction\":\"12_28\",\"action\":\"clicked\"},{\"interaction\":\"12_112\",\"action\":\"clicked\"},{\"interaction\":\"12_113\",\"action\":\"clicked\"}]', 'OR'),
(611, 1, 28, 29, '[{\"interaction\":\"28_138\",\"action\":\"clicked\"},{\"interaction\":\"28_136\",\"action\":\"clicked\"},{\"interaction\":\"28_137\",\"action\":\"clicked\"}]', 'OR'),
(615, 1, 12, 12, '[]', ''),
(616, 1, 9, 11, '[{\"interaction\":\"9_24\",\"action\":\"clicked\"}]', ''),
(613, 1, 31, 32, '[{\"interaction\":\"31_147\",\"action\":\"clicked\"},{\"interaction\":\"31_146\",\"action\":\"clicked\"},{\"interaction\":\"31_145\",\"action\":\"clicked\"}]', 'OR'),
(614, 1, 1, 4, '[]', ''),
(354, 4, 35, 36, '[{\"interaction\":\"35_155\",\"action\":\"clicked\"}]', 'OR'),
(612, 1, 26, 27, '[{\"interaction\":\"26_129\",\"action\":\"clicked\"},{\"interaction\":\"26_128\",\"action\":\"clicked\"},{\"interaction\":\"26_130\",\"action\":\"clicked\"},{\"interaction\":\"26_131\",\"action\":\"clicked\"}]', ''),
(609, 1, 25, 26, '[{\"interaction\":\"25_125\",\"action\":\"clicked\"},{\"interaction\":\"25_124\",\"action\":\"clicked\"},{\"interaction\":\"25_126\",\"action\":\"clicked\"}]', 'OR'),
(610, 1, 9, 31, '[{\"interaction\":\"9_86\",\"action\":\"clicked\"}]', ''),
(629, 9, 47, 48, '[{\"interaction\":\"47_254\",\"action\":\"clicked\"},{\"interaction\":\"47_265\",\"action\":\"clicked\"}]', 'OR'),
(744, 11, 80, 81, '[]', ''),
(643, 5, 43, 64, '[]', ''),
(645, 6, 67, 44, '[]', ''),
(646, 8, 68, 46, '[]', ''),
(745, 11, 82, 78, '[{\"interaction\":\"82_439\",\"action\":\"clicked\"}]', 'OR'),
(758, 3, 58, 59, '[]', ''),
(759, 3, 69, 53, '[{\"interaction\":\"69_367\",\"action\":\"clicked\"}]', ''),
(757, 3, 69, 62, '[{\"interaction\":\"69_369\",\"action\":\"clicked\"}]', 'OR'),
(742, 7, 74, 75, '[{\"interaction\":\"74_398\",\"action\":\"clicked\"},{\"interaction\":\"74_399\",\"action\":\"clicked\"},{\"interaction\":\"74_400\",\"action\":\"clicked\"},{\"interaction\":\"74_401\",\"action\":\"clicked\"},{\"interaction\":\"74_404\",\"action\":\"clicked\"}]', 'OR'),
(743, 7, 72, 74, '[{\"interaction\":\"72_388\",\"action\":\"clicked\"},{\"interaction\":\"72_389\",\"action\":\"clicked\"},{\"interaction\":\"72_390\",\"action\":\"clicked\"},{\"interaction\":\"72_392\",\"action\":\"clicked\"},{\"interaction\":\"72_394\",\"action\":\"clicked\"},{\"interaction\":\"72_397\",\"action\":\"clicked\"}]', 'OR'),
(746, 11, 82, 80, '[]', ''),
(747, 11, 77, 82, '[]', ''),
(748, 11, 82, 76, '[{\"interaction\":\"82_437\",\"action\":\"clicked\"}]', ''),
(749, 7, 74, 74, '[]', ''),
(750, 7, 75, 84, '[]', ''),
(760, 3, 22, 69, '[]', ''),
(756, 3, 69, 58, '[]', '');

-- --------------------------------------------------------

--
-- Table structure for table `tcx_wpefc_logs`
--

CREATE TABLE `tcx_wpefc_logs` (
  `id` mediumint(9) NOT NULL,
  `formID` mediumint(9) NOT NULL,
  `ref` varchar(120) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `email` varchar(120) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `content` mediumtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `dateLog` varchar(64) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `sendToUser` tinyint(1) DEFAULT NULL,
  `contentUser` mediumtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `checked` tinyint(1) DEFAULT NULL,
  `phone` varchar(250) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `lastName` varchar(250) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `firstName` varchar(250) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `address` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `city` varchar(250) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `country` varchar(250) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `state` varchar(250) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `zip` varchar(250) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `totalPrice` float NOT NULL,
  `totalSubscription` float NOT NULL,
  `subscriptionFrequency` varchar(64) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `formTitle` varchar(250) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `contentTxt` mediumtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `paid` tinyint(1) NOT NULL,
  `paymentKey` varchar(250) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `finalUrl` varchar(250) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `pdfContent` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `pdfContentUser` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `eventsData` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `customerID` mediumint(9) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `tcx_wpefc_logs`
--

INSERT INTO `tcx_wpefc_logs` (`id`, `formID`, `ref`, `email`, `content`, `dateLog`, `sendToUser`, `contentUser`, `checked`, `phone`, `lastName`, `firstName`, `address`, `city`, `country`, `state`, `zip`, `totalPrice`, `totalSubscription`, `subscriptionFrequency`, `formTitle`, `contentTxt`, `paid`, `paymentKey`, `finalUrl`, `pdfContent`, `pdfContentUser`, `eventsData`, `customerID`) VALUES
(1, 1, 'A0005', 'L2JrQ1Y5c3QxZml2SnF0ckgzOWI1bE9FVWdlZXhwL3ZYUG1lbi9TRU1RYz06Oow42i1CYm_EXB3IifL6BJk', '[encoded data, 12344 characters]', '2018-03-20', 1, '[encoded data, 12483 characters]', 1, '', '', '', '', '', '', '', '', 3000, 0, '', 'My Estimation Form', 'UUwwUmtraDVTZXo3dldieEQzLytTWGl3T09TU0ptODNJZ3RrbDUwOVJBV3Y3MVVJY0NRbjYzVE03NzJWZ05rNjRRQmkwZnlsSUtGRjZjVGdKeXdhTXk4d0RBaHE5UkJFVFRoSnczOUdiU09pUy9uVllQc0IzZkFya0dtOEZIZitWNGcxazhqcjZGeUhOQXM3ZkxONGVVYklyVUtOVElFelU5b1ZMMWNRN1JhSWJTUmh3WkcwMy9XM3lOakJydXNpbzFJcjhkWHBsS1phU3FuYVZnTlJMcVlTR05rcjIzYzhGa2NqSHVTLzhUczJrajRBMW93NDZMaUhydzk5d3BCWG1icVNSZ1BXZkV2bmlqVjR2ZkY4a3g4eFpxNVRkNlAvL0hxTDJ1aVhlRG5WZzZSYWxCejRETWhFYlZjd1RGa1k6OjBvrEdUWEACj5FsNFULn5c', 0, '8aa3b31747e739de583c68e83124903e', '#', '', '', '', 3);
INSERT INTO `tcx_wpefc_logs` (`id`, `formID`, `ref`, `email`, `content`, `dateLog`, `sendToUser`, `contentUser`, `checked`, `phone`, `lastName`, `firstName`, `address`, `city`, `country`, `state`, `zip`, `totalPrice`, `totalSubscription`, `subscriptionFrequency`, `formTitle`, `contentTxt`, `paid`, `paymentKey`, `finalUrl`, `pdfContent`, `pdfContentUser`, `eventsData`, `customerID`) VALUES
(2, 1, 'A0002', 'M0NwUmFVZGtkV3FSVXN0RUhRNEhjcTU3a1hRcjNQQlNzdVVnVTg2VGRYTT06Opu1jQ1SU-Ruty6_Gv1dCiY', '[encoded data, 29779 characters]', '2018-03-21', 1, '[encoded data, 29923 characters]', 1, '', '', '', '', '', '', '', '', 8500, 0, '', 'My Estimation Form', 'dDFxR20veFZNbkNobUlrSjl5YjIyckdpcUV4NDM3QkZmYjh1RVVrV0dDWDFhV2VHVXFJckU5SzQvMFFpS3FkdEVNeEdoQ3RHM0JrZjlNamRwa3BMVVl3NzdUdnFTOGI1SGRmZkdrc0VYd2Vvd0JKVXJHdzNBTTBhUEZud3NuVk1VbHNnWnBxcWlmc0tCa1J0Z1FQQnh3aTJyZTUyOFpWSkVxR3ZEeEpkZWk4T25TaHNSYXRsUnhzenJZNnZ2QWU3ZFRCRnNZN0FVZ3cxdGpPL1R3YzV1OVlRTXIrdU5xb0o0R094K0cvS01hcnQ0Zmk1emRtaitqOVZSZlJkZ1FIQWVacTVhVWl4QWkrTHM4TlRRanlZT1l2RHF4M01Td002TlEwVGxnT0swcFd4ZFlPUUlyU0hwMGtDbWt4UWF3Zy9Sc09rZnFxbjc0MUpOZ0VGc1JocHFGUzJDekdDeUVrQkV0bTRUbHlMRnhoUWJkTmQxcUNHNHpvVWNXTk1hL2F4TkNuUmZaL3RFdTh6SlkyU1NobjJ0TVdnSXRaZ3VLK2JDeXRWaU1tdVZET3NLTEtjUFdwcVhwYzBCL0hEa29FQTBtcGpsRTNEdWdXL0VzaldnLzZKcm9jNEh1bzlTbVF6d0U5QVRFamtTdzFTczE4QXhxMm9nQSthV2tNSDd4bVZhRVZMNGRvV2k4UFY0T2s3RGs3OXg4b0gvSmZJTGxqY0pTL3V5NitrbE1acnl6NVd1U1RGeXFsVEZTYy95QzgxWllZQ2RvamZxZE03WGZyUDdxNDZGVVd2Zm5XdGZkMDB0a25EM3loQnc1eGxuY2lNeW1PcVRpOVdrMTlRUnZsazFhZkVSSnl6cGRFZ3M1cEQzRHNlUmJOVTFYZ29IMEVXUWFqTnIvdHdWUEtuYTBZanVjbjlWN1hZQUNaOUl4dDZsQUUyNVp1YWhnSlFsdmtIQlhoUkxIQm42Q1VRdGY5d21LSWc5L3VTelFJZzVCM1VnT0w0alZuVm1kV25PcHgvd1lqc0t1TGc4ZEM2dWFPdk9GRjhOb0lvQ0xaS1pUUWh1RlExRXR5MkRxVT06Om0KlrTMZL-mpwTdGUG3Db8', 0, 'a9f346a5f7718b8448d8e084e99e520d', '#', '[encoded data, 29779 characters]', '[encoded data, 29923 characters]', '[]', 4);
INSERT INTO `tcx_wpefc_logs` (`id`, `formID`, `ref`, `email`, `content`, `dateLog`, `sendToUser`, `contentUser`, `checked`, `phone`, `lastName`, `firstName`, `address`, `city`, `country`, `state`, `zip`, `totalPrice`, `totalSubscription`, `subscriptionFrequency`, `formTitle`, `contentTxt`, `paid`, `paymentKey`, `finalUrl`, `pdfContent`, `pdfContentUser`, `eventsData`, `customerID`) VALUES
(3, 1, 'A0003', 'ZmZsWEJSVUhZN1NJN2ZIM2szN2lRQkFYVG94M3dmU2Yra3ZtUDk4dHh3RT06Ol51A2320TaQEqoc6PJ4IP0', '[encoded data, 16894 characters]', '2018-03-21', 1, '[encoded data, 17038 characters]', 1, '', '', '', '', '', '', '', '', 5550, 0, '', 'My Estimation Form', 'aFB6YjVmbklxU3picnl2MS9IcGVXYlRsWmV5NEtXUlBYeUhoVWhuN1lYUXdYb1ZUVEd3bVExUmwxRzhLelZPbCtSTlJyNXhTRm10eWZhSUE0eVIrY0N1K0s2M2hXcERlV2Y3L21waEhNWmQxYWFoOWhGR0h6NmZjSk1FOXoyNXZEcFRkd0NFN0dORVp5RVBYS2lCYU85OVZYQkRKYUtGN3R3ZXRGbTd6c0ZBNlMza1dWOHh5Q01FWTVUR0VEQTZRRCtTcjJCTjhtOU1zOGNjaC9qeWc0RU1OMlgvQm5tL0d2U2RTTFZzY3lQdGJsWDloMUVTUXIwSklHQUUxTmN3YVZLODk0dXRMMldIbVRmdlI3TDIvb3QvRG8rZVY5T2tVdFNCdHZFZHcrdkNZOUpiMFQrOEVpa2R3L3JRT01sSGxjclhwekdWTlh2UE56SU1MWE9OR0x3MnhjUDNxVWZucDAxV2JWdk5lVjByYVR5WGNaV0F3anhhZ3dRQ2dNRVJZMEVMT041akVOUUhhRFNGQkVXeVFZZDd6QUEzbTFPQ2h4VzlZU2d6NDVXdDFxRkt6UU4yeHBWWTJDQ3cycW0wQzo6LJEz6KYvl8osPhtUUjZWQg', 0, '8c5e17b2a7d0801c40c34722cbc79cfc', '#', '[encoded data, 16894 characters]', '[encoded data, 17038 characters]', '[]', 12);
INSERT INTO `tcx_wpefc_logs` (`id`, `formID`, `ref`, `email`, `content`, `dateLog`, `sendToUser`, `contentUser`, `checked`, `phone`, `lastName`, `firstName`, `address`, `city`, `country`, `state`, `zip`, `totalPrice`, `totalSubscription`, `subscriptionFrequency`, `formTitle`, `contentTxt`, `paid`, `paymentKey`, `finalUrl`, `pdfContent`, `pdfContentUser`, `eventsData`, `customerID`) VALUES
(4, 3, 'A0002', 'R09VTTB0YWdCVVMyd1RGZVlQcHJOVTdOeHBzTkpQYUZTWi94dTRRSlZFTT06OmQhxfgq8xxwOu0Z1sehPI8', '[encoded data, 11544 characters]', '2018-03-29', 0, '', 1, '', '', '', '', '', '', '', '', 850, 0, '', 'Shopify Connectors', 'Snc2cGtDZGt5UFZLaGVNS0t6NnJ5ZzM0a3Z4THArUnZIQmJMUytvNEY5L05PVTk5eERwN1RWT3Zic2hiSkx1dDMxTG9EMDU1QlBGRGZUYTQ4QkhONVJZOFJ5Zm4ya3NYZy9VZk5QeWdTNVBac3REVU9LcldRWjlodktOWFZsb0lkQnJZcWZTYnIybldHSE5BUlFYOVlzMEtWZFVYL2FsNXlwb3hBOUE3WXhWQzl2ZE9ycGZNcUdJNS9sTUwxUXpDTTJ1aDlmZlp5ZTZ0b2hETHNxWFJqN3pEc0drSVBJQkJKZDFJZVRQMTZDbk1STzRNQkpRWkFQL2lmamZiTmxHVGFqZDV2TVBUNkhNMkh2TmoxNVFtVHUzd1FwYmFZSm5tc3JTUG1aS0Z1aXJQSFM2VW9rck1XZ1BkVGM0NytPWUM6OpQbXeUq4FtcJYCOaRy9Lbw', 0, 'c3d8775300674c680b8216eb83872d56', '#', '[encoded data, 11544 characters]', '', '[]', 5),
(5, 3, 'A0003', 'blZFbC81QmxsWkx0cnBHczRWR1hTU1hCR2s0SlVQV0RkZjhrTzFEQ2dUYz06OvhnolWl9227GdsAgfKwhfY', '[encoded data, 11576 characters]', '2018-04-05', 0, '', 1, '', '', '', '', '', '', '', '', 1050, 0, '', 'Shopify Connectors', 'dTJ4Nys5Y0pQZmx0Tm5aZW9MWWJVa3QvSVMwYTJGWGJLYytSdit6dFZSS3ZIcnVNTjRpbFhRa095ajNjTUhPUklObExGRHIwdGNJY2hxT1E5alZFZ2tpK0l6MUdMeUJCZnhKdmNuSFM5eThNbzArbU1EUkFVaWlvUi9oVGJNUWl2Q1p5ZFRNdHMvdEZpZit4VURWVU5iNC9pMlVOZ2YwTFU3Y0FITGFKU0ZkaFN5MjhEVEMrL0xCem1IdUc2R3VoRW5HaXkwNnJ6UDRVaU0xS0xSc2VtTzNoVHpaNDE3RmNqdGVoOTFkWnppTjBrM3VUU3lqK2tQTXQxakYyV2NkQjNtc3crSUxYUTFTZXR5MUx6aVpZQXdHc0ZISFVERUttMnlpQWRmUzlPSFE4bjBrd1FwZE1ZcDErV3lwbzlZM046OvxvnEtH-S2JFD7WcHQfNH0', 0, '4d8ba44b5f98ffde66b08b234efc68e3', '#', '[encoded data, 11576 characters]', '', '[]', 1);
INSERT INTO `tcx_wpefc_logs` (`id`, `formID`, `ref`, `email`, `content`, `dateLog`, `sendToUser`, `contentUser`, `checked`, `phone`, `lastName`, `firstName`, `address`, `city`, `country`, `state`, `zip`, `totalPrice`, `totalSubscription`, `subscriptionFrequency`, `formTitle`, `contentTxt`, `paid`, `paymentKey`, `finalUrl`, `pdfContent`, `pdfContentUser`, `eventsData`, `customerID`) VALUES
(6, 1, 'A0004', 'UlowMndIcHNEK2NtWjl2U0VvV3JvTGRMSXdaZHZKUTJsWnJTc0x1alNoaz06OmQfRvyKsro-xHHjWtkTSeM', '[encoded data, 19368 characters]', '2018-06-21', 1, '[encoded data, 19512 characters]', 1, '', '', '', '', '', '', '', '', 1850, 0, '', 'My Estimation Form', 'ajArZUZBaW05UG55eUIxdXJMdXpYWnE4eTVpeVBydW55TXc0RXpwcUJrdXIzMlhwUUM3bVU5ZkVhc1lzQmlmMksyQjZGa2E5aGk2Z0o3WE9WaGRjTzF0eFJzYll1NElMYVhVbTFOZEFzQVE1R3pnVE1HYXI4SXlCampUSVpXK1NxNGlVR001OEtMSExxSnBzenVYY2ZiTWNyUnM2TzhkMEtvSUxNL1F2YTZSMmhNOFRoRHZ3cnJlR3RSWEo4T1FwS1FmNEMycWNsVmFtS3gzRjZkQVR5ZG9CMTlIUzMvV0hqYVBtbWlaTkpuTTVOSVpNanpEWWxYOFdlYWxXSjI2NlcvcE9iaTlYR0FCQjdwMkEyckdyUDBXZ0pZbDJtc2tPUWpyYll4bWZhZHVOYWJWU2FUTzhHbVphNHcrRkMwQ0VKVGNhTXNUMVNTdTBYeFdqZDl3S3FYNXpxWERuR2h6ajMyN1pTOEJnb2lHeThDcktYWmtMUmw4b2U2cDQxaXY5WnMxYmhaUWl2OW53TU1YZURTYit4UHpYbE1sT0lIUXlkUWJXdlRlcDFWaVE2MmVxRnpVVGZSWCtWaU9ycXBCRElrY3NFMmZsZVZMRUhjS0dMaVZWK2w2WGt0bzBTZzQ0ODVoYmdYYndldFJNVXlkR0taQVBFVC9ibE1wQWdCdzVqYndWWHNwOU5NQlgzZnNlUVAvVWxRPT06Oob8FSg-63rh95_OfzpiKLM', 0, '678648d62e36713d9360f2be906e3c3c', '#', '[encoded data, 19368 characters]', '[encoded data, 19512 characters]', '[]', 6);
INSERT INTO `tcx_wpefc_logs` (`id`, `formID`, `ref`, `email`, `content`, `dateLog`, `sendToUser`, `contentUser`, `checked`, `phone`, `lastName`, `firstName`, `address`, `city`, `country`, `state`, `zip`, `totalPrice`, `totalSubscription`, `subscriptionFrequency`, `formTitle`, `contentTxt`, `paid`, `paymentKey`, `finalUrl`, `pdfContent`, `pdfContentUser`, `eventsData`, `customerID`) VALUES
(7, 3, 'A0004', 'VXBrZFhsL1lIamcxbjJwLzdSTm5VWDFrdHE3UjlnSkxPclZKZkdHK09xTT06OuY14dD4Qo5obZ3v8mRV3wg', '[encoded data, 26595 characters]', '2018-06-22', 1, '[encoded data, 26734 characters]', 1, '', '', '', '', '', '', '', '', 100, 0, '', 'Shopify Connectors', 'RU83Z3NmZnExTGIvMk5mdjJEeWM2ZW5idk9TSkE5R3VDYVdzNmUyeFRUam52OW5SYklnMk5OaEJ1Zk5xMnNvZU01WkJDTjJ2RmtCeGxaNHh2TDhjbTNnMmVzbFdEODNTZG5aWW0zZXYvRmFHSzd5YnN6aklVM2tjOUZPVElQcmd5alVzSzNxTUpBWFh0cUhLZUljOStTT2VFei91d21pem8zdnp3Z0Z5UWpqZjcrekVZN1Exb1dTOXpjaUNMdjIvVlhTdUFMNzUyUmZwTUIrd05HRWkrVzlKcWNaNDhUN2J4RzQrYUpZWU9kay9rNmswZGdWdmVGNytpNzgwVGVKcjVsbUZqOURIOWNQY1NDcXhxR3NDZmVqeTFUUlBiS2JwaUNNWnYxcDk4VVNUMTV1ZEFEVW1XbzROeGFzdmRzWlJ6U0tGUGVGeEs5TmkzRklTNmROaHYyZmRlWnl4UWM5bFoyODBFS3FiemhKZkJ6bmJtdnhuNDY4UlFsSHcvaWg3QjVONGtpbkRQeTArLzVpdnNlOUszZlA1VGovWFhqYWgwdUhqUFl1aCsrc2MrUlREMXR2V1FkelVaeGZORGN6eGRvNER6Ulo0ZkQ2Wnhwc3JUZytncWJWYzlaemVzT0poeHExNlhEVk96eTNzWE9rV1p3SHdnL1A5d3ozbmFkbnF0UnF6K1BpbnVXOGlXdzVGT3ZFY1VSUFJKa0VGMm42WnMxL2FHQW4vY09NcEVRNzF1N0Z1cEJURWk1cDh5VDlLMjVmMDU3Z1pINUh5VVkxaFIvSWxkVkdabFJENU05QkFCZEdQM3hTUzNWS2k0MjFyR1VDZVpFUUNNa08wdjdpM2o5Zit2TFpmSTRTVTFuMUNlejFESnpjRVZkTW5Ic1lBMzY5cHFWeGFWaEtsZVRSTUpNZWkrOEJqcGZEOTZXSEZLQyt1N2Q5RGRLZ1dncDdHWUZFaUZYZy9CWFZtZ3JudG9hc2FCKzhxU2ErblVxUjYyTm1SS0FoamtCTExITHVLOjoAlUFbS0ucPyA2_tw2chqt', 0, '93b6e2ef96064ca7bf9a920b784f191f', '#', '[encoded data, 26595 characters]', '[encoded data, 26734 characters]', '[]', 8);
