/* CUSTOM VARS START */
/* REAL_TABLE_NAME: `wpk9bt_wps_wsfw_wallet_transaction`; */
/* PRE_TABLE_NAME: `1741599259_wpk9bt_wps_wsfw_wallet_transaction`; */
/* CUSTOM VARS END */

CREATE TABLE IF NOT EXISTS `1741599259_wpk9bt_wps_wsfw_wallet_transaction` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint(20) unsigned DEFAULT NULL, `amount` double DEFAULT NULL, `currency` varchar(20) NOT NULL, `transaction_type` varchar(200) DEFAULT NULL, `transaction_type_1` varchar(200) DEFAULT NULL, `payment_method` varchar(50) DEFAULT NULL, `transaction_id` varchar(50) DEFAULT NULL, `note` varchar(500) DEFAULT NULL, `date` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `user_id` (`user_id`)) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
INSERT INTO `1741599259_wpk9bt_wps_wsfw_wallet_transaction` (`id`, `user_id`, `amount`, `currency`, `transaction_type`, `transaction_type_1`, `payment_method`, `transaction_id`, `note`, `date`) VALUES (1,5,900,'ZAR','manual test','credit','Manually By Admin','','','2025-03-03 13:48:49'),(2,5,50,'ZAR','Wallet debited through purchasing  &lt;a href=&quot;https://www.maharajasspices.co.za/wp-admin/post.php?post=6462&amp;action=edit&quot; &gt;#6462&lt;/a&gt;','debit','Wallet Payment',6462,'','2025-03-03 13:51:35');
