-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: com-linweb934.srv.combell-ops.net:3306
-- Gegenereerd op: 06 dec 2024 om 11:29
-- Serverversie: 8.0.36-28
-- PHP-versie: 7.4.33

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `ID128167_ac18`
--

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

--
-- Tabelstructuur voor tabel `ac18_cbsubs_history`
--

CREATE TABLE `ac18_cbsubs_history` (
  `id` bigint UNSIGNED NOT NULL,
  `event_type` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `message` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `table_name` varchar(48) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `table_key_id` int UNSIGNED DEFAULT NULL,
  `field_changed` varchar(48) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `change_type` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `old_value` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `new_value` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `event_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `user_id` int NOT NULL DEFAULT '0',
  `ip_addresses` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `log_priority` tinyint NOT NULL DEFAULT '0',
  `log_version` tinyint NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Gegevens worden geëxporteerd voor tabel `ac18_cbsubs_history`
--

INSERT INTO `ac18_cbsubs_history` (`id`, `event_type`, `message`, `table_name`, `table_key_id`, `field_changed`, `change_type`, `old_value`, `new_value`, `event_time`, `user_id`, `ip_addresses`, `log_priority`, `log_version`) VALUES
(6621, '2', 'Store payment basket', '#__cbsubs_payment_baskets', 782, '', 'insert', NULL, '<record type=\"sql:row\" table=\"#__cbsubs_payment_baskets\" class=\"cbpaidPaymentBasket\" key=\"id\" value=\"782\" valuetype=\"const:int\">\n	<field name=\"address_name\" value=\"Luc Wouters\" />\n	<field name=\"first_name\" value=\"Luc\" />\n	<field name=\"last_name\" value=\"Wouters\" />\n	<field name=\"payer_email\" value=\"wouters.l@telenet.be\" />\n	<field name=\"item_name\" value=\"1 jaar Standaardlidmaatschap voor Luc Wouters\" />\n	<field name=\"item_number\" value=\"S238-2550-35\" />\n	<field name=\"quantity\" value=\"1\" />\n	<field name=\"invoice\" value=\"R2024-558\" />\n	<field name=\"payment_status\" value=\"NotInitiated\" />\n	<field name=\"mc_currency\" value=\"EUR\" />\n	<field name=\"mc_gross\" value=\"35\" />\n	<field name=\"integrations\" value=\"[]\" />\n	<field name=\"user_id\" value=\"2550\" />\n	<field name=\"owner\" value=\"1\" />\n	<field name=\"time_initiated\" value=\"2024-12-05 10:14:09\" />\n	<field name=\"time_updated\" value=\"2024-12-05 10:14:09\" />\n	<field name=\"shared_secret\" value=\"cbp67517cf1b8335269120986\" />\n	<field name=\"ip_addresses\" value=\"2a09:bac3:4a1:30f::4e:9c\" />\n</record>\n', '2024-12-05 10:14:09', 2550, '2a09:bac3:4a1:30f::4e:9c', 6, 1),
(6622, '2', NULL, '#__cbsubs_config', 1025, '', 'insert', NULL, '<record type=\"sql:row\" table=\"#__cbsubs_config\" class=\"cbpaidConfig\" key=\"id\" value=\"1025\" valuetype=\"const:int\">\n	<field name=\"user_id\" value=\"2550\" />\n	<field name=\"type\" value=\"stripe\" />\n	<field name=\"last_updated_date\" value=\"2024-12-05 10:14:33\" />\n	<field name=\"params\" value=\"{&quot;customer_id&quot;:&quot;cus_RLIgryQ4lYLZVB&quot;}\" />\n</record>\n', '2024-12-05 10:14:33', 2550, '2a09:bac3:4a1:30f::4e:9c', 6, 1),
(6623, '2', NULL, '#__cbsubs_payment_baskets', 782, '', 'update', '<fields>\n	<field name=\"integrations\" value=\"[]\" />\n	<field name=\"time_updated\" value=\"2024-12-05 10:14:09\" />\n</fields>\n', '<fields>\n	<field name=\"integrations\" value=\"{&quot;checkout_hash&quot;:&quot;6d6897e5a779df85cfaa052eb049cc6f&quot;,&quot;checkout_session&quot;:{&quot;single&quot;:&quot;cs_live_a1FjStadv2Lt6TpSdWqOUTu86HdQb0fpx0hcBtHHAbutWbOZO53H7ObF34&quot;},&quot;checkout_url&quot;:{&quot;single&quot;:&quot;https:\\/\\/checkout.stripe.com\\/c\\/pay\\/cs_live_a1FjStadv2Lt6TpSdWqOUTu86HdQb0fpx0hcBtHHAbutWbOZO53H7ObF34#fid1d2BpamRhQ2prcSc%2FJ0p1YGslVmRrdicpJ2lqZmRpYCc%2FJ2tpJyknZHVsTmB8Jz8ndW5aaWxzYFowNEo2SGdgTm5ramYxTmdLcFdkR0YwYkd%2FdGRsUEdoNUk1YGJmXzJjTTY1T3R%2FQHdTMk9hQE9VdEdgSGxSRG9fYDNccW9zYVZzd0RIQ111YUJQb25LYGxNczU1SnNDTUJkQ2EnKSdjd2poVmB3c2B3Jz9xd3BgKSdpZHxqcHFRfHVgJz8ndmxrYmlgWmxxYGgnKSdga2RnaWBVaWRmYG1qaWFgd3YnP3F3cGB4JSUl&quot;},&quot;payment_intent&quot;:{&quot;single&quot;:&quot;&quot;},&quot;setup_intent&quot;:{&quot;single&quot;:&quot;&quot;}}\" />\n	<field name=\"time_updated\" value=\"2024-12-05 10:14:33\" />\n</fields>\n', '2024-12-05 10:14:33', 2550, '2a09:bac3:4a1:30f::4e:9c', 6, 1),
(6624, '2', 'Updating payment record because of new status of payment basket: Completed because of event received: web_accept. Previous status was: NotInitiated', '#__cbsubs_payments', 590, '', 'insert', NULL, '<record type=\"sql:row\" table=\"#__cbsubs_payments\" class=\"cbpaidPayment\" key=\"id\" value=\"590\" valuetype=\"const:int\">\n	<field name=\"charset\" value=\"utf-8\" />\n	<field name=\"test_ipn\" value=\"0\" />\n	<field name=\"payer_name\" value=\"Luc Wouters\" />\n	<field name=\"payer_status\" value=\"unverified\" />\n	<field name=\"item_name\" value=\"1 jaar Standaardlidmaatschap voor Luc Wouters\" />\n	<field name=\"item_number\" value=\"S238-2550-35\" />\n	<field name=\"quantity\" value=\"1\" />\n	<field name=\"custom\" value=\"782\" />\n	<field name=\"invoice\" value=\"R2024-558\" />\n	<field name=\"payment_date\" value=\"10:15:55 Dec 05, 2024 GMT\" />\n	<field name=\"payment_status\" value=\"Completed\" />\n	<field name=\"payment_type\" value=\"stripe\" />\n	<field name=\"txn_id\" value=\"py_3QSc5LKknoc4KbNu08JUVPB7\" />\n	<field name=\"txn_type\" value=\"web_accept\" />\n	<field name=\"mc_currency\" value=\"EUR\" />\n	<field name=\"mc_gross\" value=\"35.00000\" />\n	<field name=\"recurring\" value=\"0\" />\n	<field name=\"notify_version\" value=\"2.1\" />\n	<field name=\"payment_basket_id\" value=\"782\" />\n	<field name=\"payment_method\" value=\"stripe\" />\n	<field name=\"gateway_account\" value=\"4\" />\n	<field name=\"log_id\" value=\"597\" />\n	<field name=\"for_user_id\" value=\"2550\" />\n	<field name=\"by_user_id\" value=\"2550\" />\n	<field name=\"to_user_id\" value=\"0\" />\n	<field name=\"created_by_user_id\" value=\"0\" />\n	<field name=\"modified_by_user_id\" value=\"0\" />\n	<field name=\"time_paid\" value=\"2024-12-05 10:15:55\" />\n	<field name=\"time_paid_date\" value=\"2024-12-05\" />\n	<field name=\"time_paid_day_of_week\" value=\"5\" />\n	<field name=\"time_paid_yearweek\" value=\"2024-W49\" />\n	<field name=\"time_paid_yearmonth\" value=\"2024-12\" />\n	<field name=\"time_paid_hour\" value=\"11\" />\n	<field name=\"time_created\" value=\"2024-12-05 10:15:55\" />\n	<field name=\"ip_addresses\" value=\"2a09:bac2:4a1:30f::4e:a7\" />\n</record>\n', '2024-12-05 10:15:55', 2550, '2a09:bac2:4a1:30f::4e:a7', 6, 1),
(6625, '2', 'User subscription activated as Renewed', '#__cbsubs_subscriptions', 238, '', 'update', '<fields>\n	<field name=\"last_renewed_date\" value=\"2024-01-06 12:35:47\" />\n	<field name=\"expiry_date\" value=\"2024-12-31 22:59:59\" />\n	<field name=\"regular_recurrings_used\" value=\"2\" />\n	<field name=\"previous_expiry_date\" value=\"2023-12-31 22:59:59\" />\n	<field name=\"previous_recurrings_used\" value=\"1\" />\n</fields>\n', '<fields>\n	<field name=\"last_renewed_date\" value=\"2024-12-05 10:15:55\" />\n	<field name=\"expiry_date\" value=\"2025-12-31 22:59:59\" />\n	<field name=\"regular_recurrings_used\" value=\"3\" />\n	<field name=\"previous_expiry_date\" value=\"2024-12-31 22:59:59\" />\n	<field name=\"previous_recurrings_used\" value=\"2\" />\n</fields>\n', '2024-12-05 10:15:55', 2550, '2a09:bac2:4a1:30f::4e:a7', 6, 1),
(6626, '2', 'Updating payment basket status: Completed because of event received: web_accept. Previous status was: NotInitiated', '#__cbsubs_payment_baskets', 782, '', 'update', '<fields>\n	<field name=\"payment_status\" value=\"NotInitiated\" />\n	<field name=\"integrations\" value=\"{&quot;checkout_hash&quot;:&quot;6d6897e5a779df85cfaa052eb049cc6f&quot;,&quot;checkout_session&quot;:{&quot;single&quot;:&quot;cs_live_a1FjStadv2Lt6TpSdWqOUTu86HdQb0fpx0hcBtHHAbutWbOZO53H7ObF34&quot;},&quot;checkout_url&quot;:{&quot;single&quot;:&quot;https:\\/\\/checkout.stripe.com\\/c\\/pay\\/cs_live_a1FjStadv2Lt6TpSdWqOUTu86HdQb0fpx0hcBtHHAbutWbOZO53H7ObF34#fid1d2BpamRhQ2prcSc%2FJ0p1YGslVmRrdicpJ2lqZmRpYCc%2FJ2tpJyknZHVsTmB8Jz8ndW5aaWxzYFowNEo2SGdgTm5ramYxTmdLcFdkR0YwYkd%2FdGRsUEdoNUk1YGJmXzJjTTY1T3R%2FQHdTMk9hQE9VdEdgSGxSRG9fYDNccW9zYVZzd0RIQ111YUJQb25LYGxNczU1SnNDTUJkQ2EnKSdjd2poVmB3c2B3Jz9xd3BgKSdpZHxqcHFRfHVgJz8ndmxrYmlgWmxxYGgnKSdga2RnaWBVaWRmYG1qaWFgd3YnP3F3cGB4JSUl&quot;},&quot;payment_intent&quot;:{&quot;single&quot;:&quot;&quot;},&quot;setup_intent&quot;:{&quot;single&quot;:&quot;&quot;}}\" />\n	<field name=\"gateway_account\" value=\"0\" />\n	<field name=\"time_updated\" value=\"2024-12-05 10:14:33\" />\n	<field name=\"time_completed_date\" value=\"0000-00-00\" />\n</fields>\n', '<fields>\n	<field name=\"charset\" value=\"utf-8\" />\n	<field name=\"payer_name\" value=\"Luc Wouters\" />\n	<field name=\"payer_status\" value=\"unverified\" />\n	<field name=\"custom\" value=\"782\" />\n	<field name=\"payment_date\" value=\"10:15:55 Dec 05, 2024 GMT\" />\n	<field name=\"payment_status\" value=\"Completed\" />\n	<field name=\"payment_type\" value=\"stripe\" />\n	<field name=\"txn_id\" value=\"py_3QSc5LKknoc4KbNu08JUVPB7\" />\n	<field name=\"txn_type\" value=\"web_accept\" />\n	<field name=\"integrations\" value=\"{&quot;checkout_hash&quot;:&quot;6d6897e5a779df85cfaa052eb049cc6f&quot;,&quot;checkout_session&quot;:{&quot;single&quot;:&quot;cs_live_a1FjStadv2Lt6TpSdWqOUTu86HdQb0fpx0hcBtHHAbutWbOZO53H7ObF34&quot;},&quot;checkout_url&quot;:{&quot;single&quot;:&quot;https:\\/\\/checkout.stripe.com\\/c\\/pay\\/cs_live_a1FjStadv2Lt6TpSdWqOUTu86HdQb0fpx0hcBtHHAbutWbOZO53H7ObF34#fid1d2BpamRhQ2prcSc%2FJ0p1YGslVmRrdicpJ2lqZmRpYCc%2FJ2tpJyknZHVsTmB8Jz8ndW5aaWxzYFowNEo2SGdgTm5ramYxTmdLcFdkR0YwYkd%2FdGRsUEdoNUk1YGJmXzJjTTY1T3R%2FQHdTMk9hQE9VdEdgSGxSRG9fYDNccW9zYVZzd0RIQ111YUJQb25LYGxNczU1SnNDTUJkQ2EnKSdjd2poVmB3c2B3Jz9xd3BgKSdpZHxqcHFRfHVgJz8ndmxrYmlgWmxxYGgnKSdga2RnaWBVaWRmYG1qaWFgd3YnP3F3cGB4JSUl&quot;},&quot;payment_intent&quot;:{&quot;single&quot;:&quot;&quot;},&quot;setup_intent&quot;:{&quot;single&quot;:&quot;&quot;},&quot;stripe_timeout&quot;:1733393765}\" />\n	<field name=\"payment_method\" value=\"stripe\" />\n	<field name=\"gateway_account\" value=\"4\" />\n	<field name=\"time_updated\" value=\"2024-12-05 10:15:55\" />\n	<field name=\"time_completed\" value=\"2024-12-05 10:15:55\" />\n	<field name=\"time_completed_date\" value=\"2024-12-05\" />\n	<field name=\"time_completed_day_of_week\" value=\"5\" />\n	<field name=\"time_completed_yearweek\" value=\"2024-W49\" />\n	<field name=\"time_completed_yearmonth\" value=\"2024-12\" />\n	<field name=\"time_completed_hour\" value=\"11\" />\n</fields>\n', '2024-12-05 10:15:55', 2550, '2a09:bac2:4a1:30f::4e:a7', 6, 1),
(6627, '2', 'Store payment basket', '#__cbsubs_payment_baskets', 783, '', 'insert', NULL, '<record type=\"sql:row\" table=\"#__cbsubs_payment_baskets\" class=\"cbpaidPaymentBasket\" key=\"id\" value=\"783\" valuetype=\"const:int\">\n	<field name=\"address_name\" value=\"David Rombaut\" />\n	<field name=\"first_name\" value=\"David\" />\n	<field name=\"last_name\" value=\"Rombaut\" />\n	<field name=\"payer_email\" value=\"davidrombaut@mac.com\" />\n	<field name=\"item_name\" value=\"1 jaar Standaardlidmaatschap voor David Rombaut\" />\n	<field name=\"item_number\" value=\"S31-1243-35\" />\n	<field name=\"quantity\" value=\"1\" />\n	<field name=\"invoice\" value=\"R2024-559\" />\n	<field name=\"payment_status\" value=\"NotInitiated\" />\n	<field name=\"mc_currency\" value=\"EUR\" />\n	<field name=\"mc_gross\" value=\"35\" />\n	<field name=\"integrations\" value=\"[]\" />\n	<field name=\"user_id\" value=\"1243\" />\n	<field name=\"owner\" value=\"1\" />\n	<field name=\"time_initiated\" value=\"2024-12-05 18:49:14\" />\n	<field name=\"time_updated\" value=\"2024-12-05 18:49:14\" />\n	<field name=\"shared_secret\" value=\"cbp6751f5aa302ce017922954\" />\n	<field name=\"ip_addresses\" value=\"2a02:a020:82:1f17:69f8:d045:5f88:3f47\" />\n</record>\n', '2024-12-05 18:49:14', 1243, '2a02:a020:82:1f17:69f8:d045:5f88:3f47', 6, 1),
(6628, '2', NULL, '#__cbsubs_payment_baskets', 783, '', 'update', '<fields>\n	<field name=\"integrations\" value=\"[]\" />\n	<field name=\"time_updated\" value=\"2024-12-05 18:49:14\" />\n</fields>\n', '<fields>\n	<field name=\"integrations\" value=\"{&quot;checkout_hash&quot;:&quot;1ad456bf12c79a3451dbc9bfe625974e&quot;,&quot;checkout_session&quot;:{&quot;single&quot;:&quot;cs_live_a16wQ0c1uPfLuuPc2bFxUbGluTFG66atuuAza7UwX4Njc4IoJBEy7fb5L6&quot;},&quot;checkout_url&quot;:{&quot;single&quot;:&quot;https:\\/\\/checkout.stripe.com\\/c\\/pay\\/cs_live_a16wQ0c1uPfLuuPc2bFxUbGluTFG66atuuAza7UwX4Njc4IoJBEy7fb5L6#fid1d2BpamRhQ2prcSc%2FJ0p1YGslVmRrdicpJ2lqZmRpYCc%2FJ2tpJyknZHVsTmB8Jz8ndW5aaWxzYFowNEo2SGdgTm5ramYxTmdLcFdkR0YwYkd%2FdGRsUEdoNUk1YGJmXzJjTTY1T3R%2FQHdTMk9hQE9VdEdgSGxSRG9fYDNccW9zYVZzd0RIQ111YUJQb25LYGxNczU1SnNDTUJkQ2EnKSdjd2poVmB3c2B3Jz9xd3BgKSdpZHxqcHFRfHVgJz8ndmxrYmlgWmxxYGgnKSdga2RnaWBVaWRmYG1qaWFgd3YnP3F3cGB4JSUl&quot;},&quot;payment_intent&quot;:{&quot;single&quot;:&quot;&quot;},&quot;setup_intent&quot;:{&quot;single&quot;:&quot;&quot;}}\" />\n	<field name=\"time_updated\" value=\"2024-12-05 18:49:22\" />\n</fields>\n', '2024-12-05 18:49:22', 1243, '2a02:a020:82:1f17:69f8:d045:5f88:3f47', 6, 1),
(6629, '2', 'Basket timeout', '#__cbsubs_payment_baskets', 783, '', 'delete', '<record type=\"sql:row\" table=\"#__cbsubs_payment_baskets\" class=\"cbpaidPaymentBasket\" key=\"id\" value=\"783\" valuetype=\"const:int\">\n	<field name=\"owner\" value=\"0\" />\n</record>\n', NULL, '2024-12-06 09:46:24', 845, '2a02:1810:3f03:b500:bb9f:b8cd:9ef9:d839', 6, 1),
(6630, '2', 'User subscription activated as Renewed', '#__cbsubs_subscriptions', 31, '', 'update', '<fields>\n	<field name=\"last_renewed_date\" value=\"2023-12-04 19:54:39\" />\n	<field name=\"expiry_date\" value=\"2024-12-31 22:59:59\" />\n	<field name=\"regular_recurrings_used\" value=\"2\" />\n	<field name=\"previous_expiry_date\" value=\"2023-12-31 22:59:59\" />\n	<field name=\"previous_recurrings_used\" value=\"1\" />\n</fields>\n', '<fields>\n	<field name=\"last_renewed_date\" value=\"2024-12-06 09:47:57\" />\n	<field name=\"expiry_date\" value=\"2025-12-31 22:59:59\" />\n	<field name=\"regular_recurrings_used\" value=\"3\" />\n	<field name=\"previous_expiry_date\" value=\"2024-12-31 22:59:59\" />\n	<field name=\"previous_recurrings_used\" value=\"2\" />\n</fields>\n', '2024-12-06 09:47:57', 845, '2a02:1810:3f03:b500:bb9f:b8cd:9ef9:d839', 6, 1);

--
-- Indexen voor geëxporteerde tabellen
--

--
-- Indexen voor tabel `ac18_cbsubs_history`
--
ALTER TABLE `ac18_cbsubs_history`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_time_id` (`user_id`,`event_time`,`id`),
  ADD KEY `table_name_id_time_id` (`table_name`,`table_key_id`,`event_type`,`event_time`,`id`),
  ADD KEY `event_time_id` (`event_time`,`id`),
  ADD KEY `event_type_time_id` (`event_type`,`event_time`,`id`),
  ADD KEY `log_priority_time_id` (`log_priority`,`event_time`,`id`),
  ADD KEY `ip_addresses_time_id` (`ip_addresses`,`event_time`,`id`),
  ADD KEY `change_type` (`change_type`);

--
-- AUTO_INCREMENT voor geëxporteerde tabellen
--

--
-- AUTO_INCREMENT voor een tabel `ac18_cbsubs_history`
--
ALTER TABLE `ac18_cbsubs_history`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6631;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;