-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Jan 06, 2025 at 03:14 PM
-- Server version: 10.6.20-MariaDB-cll-lve-log
-- PHP Version: 8.3.14

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: `tokebavl_test`
--

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

--
-- Table structure for table `transactions`
--

CREATE TABLE `transactions` (
  `id` int(10) NOT NULL,
  `amount` varchar(100) DEFAULT NULL,
  `fromwallet` varchar(100) DEFAULT NULL,
  `towallet` varchar(100) DEFAULT NULL,
  `wallet` varchar(20) DEFAULT NULL,
  `type` enum('Sent','Received') NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `sent_date` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `transactions`
--

INSERT INTO `transactions` (`id`, `amount`, `fromwallet`, `towallet`, `wallet`, `type`, `created_at`, `sent_date`) VALUES
(33, '11.24535151', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', '41TRYTGJHMB0277QWSDCVBNzzcfRTTGK', '1', 'Sent', '2024-07-01 06:14:06', '2024-07-01 06:14:06'),
(34, '45.19503587', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', 'POKJNBCFRweWEDFGHNMwerfc6432ertRQQ', '1', 'Sent', '2024-07-01 06:46:36', '2024-07-01 06:46:36'),
(32, '1.18365854', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', 'RT3AASookTFVJ0NBGEER546GGGFerfUUYa', '1', 'Sent', '2024-06-28 12:35:51', '2024-06-28 12:35:51'),
(31, '8.73839312', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', '0xxsaeGGHUJ257UGVZCCOO07UYCCSA1ZX', '1', 'Sent', '2024-06-28 12:11:06', '2024-06-28 12:11:06'),
(27, '1.20977045', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', '31rfEDFYUIN578HHBVDLMMtv335DGGHJJK', '1', 'Sent', '2024-06-28 10:27:02', '2024-06-28 10:27:02'),
(30, '0.80345768', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', 'WWES0897FCXS45YB98YTJIO0JRSE42S221', '1', 'Sent', '2024-06-28 11:36:05', '2024-06-28 11:36:05'),
(29, '4.36859398', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', 'Kaw45QWXXCFCXXGHJT576XXSH9JJ0IUNB', '1', 'Sent', '2024-06-28 11:04:20', '2024-06-28 11:04:20'),
(28, '25.85682927', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', 'RRF96DFac660wr22wJHFUyyl9674GCMC44', '1', 'Sent', '2024-06-28 10:31:20', '2024-06-28 10:31:20'),
(26, '6.75252511', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', '1IOEWJjhg98HBDSIhsb08373YGNDShbBDSU', '1', 'Sent', '2024-06-28 10:23:48', '2024-06-28 10:23:48'),
(25, '0.17520804', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', '8SYADHBKSDXNGU8jhdajOhb98hijNDSHS83', '1', 'Sent', '2024-06-28 10:11:09', '2024-06-28 10:11:09'),
(35, '1.00431851', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', 'EamnOIUYHBNMZERTGVCX6032CVMKOYTG', '1', 'Sent', '2024-07-01 06:55:47', '2024-07-01 06:55:47'),
(36, '11.24535151', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', '41TRYTGJHMB0277QWSDCVBNzzcfRTTGK', '1', 'Sent', '2024-07-01 18:14:12', '2024-07-01 18:14:12'),
(37, '45.19503587', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', 'POKJNBCFRweWEDFGHNMwerfc6432ertRQQ', '1', 'Sent', '2024-07-01 18:46:09', '2024-07-01 18:46:09'),
(38, '1.00431851', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', 'EamnOIUYHBNMZERTGVCX6032CVMKOYTG', '1', 'Sent', '2024-07-01 19:04:22', '2024-07-01 19:04:22'),
(39, '4.60546629', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', '0o0hhgQWEDFGBHNMIUYTFDXCVBNHUYHGF', '1', 'Sent', '2024-07-01 19:21:22', '2024-07-01 19:21:22'),
(40, '7.8048924', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', 'BAMOIUYJKJ479HBVCXZ765DXZAQ1S6RCVB', '1', 'Sent', '2024-07-01 19:39:22', '2024-07-01 19:39:22'),
(41, '7.27117647', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', 'YPLKMNBVCXDFGH3221wddBHJRrr30zASDEW', '1', 'Sent', '2024-07-01 19:50:22', '2024-07-01 19:50:22'),
(42, '28.75898135', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', '2ZXSDCFGYHUJIO98UYHJNBVGSDXD4SXSDCV', '1', 'Sent', '2024-07-01 19:54:22', '2024-07-01 19:54:22'),
(43, '14.30129125', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', 'TRGHJKMNBVqCDXS2RDbCXVBH6we88lQWNGg', '1', 'Sent', '2024-07-01 20:01:22', '2024-07-01 20:01:22'),
(44, '0.21522238', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', '2OBAGDQBKVMWL2NMHAOZGOOE23PQAJLGZY', '1', 'Sent', '2024-07-01 20:09:22', '2024-07-01 20:09:22'),
(45, '2.13774749', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', 'XCDAHSGVZ6TDGWBA3WRUEASYG34SDNBHSAY', '1', 'Sent', '2024-07-08 10:05:02', '2024-07-08 10:05:02'),
(46, '0.52942611', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', '221wddBHJRrr30zASDEWJNBVGSDXD4SXSDCV', '1', 'Sent', '2024-07-08 10:26:11', '2024-07-08 10:26:11'),
(47, '54.79197992', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', 'HJT576XXSH9JJltc1qu3sawh0w23n347y0IUNB', '1', 'Sent', '2024-07-08 10:33:27', '2024-07-08 10:33:27'),
(48, '1.13344333', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', '727gfJHGSATGHJQOIKJWEQEMFSDVOPKJNDFABS', '1', 'Sent', '2024-07-08 10:42:00', '2024-07-08 10:42:00'),
(49, '6.02583931', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', 'TRYTGJHMB0277QWSB98YTJIO0JRSE42S221kjaws', '1', 'Sent', '2024-07-08 10:58:00', '2024-07-08 10:58:00'),
(50, '31.22606887', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', '22OBAGDQBKVMWL2NMHAOZGOOE23PQ07', '1', 'Sent', '2024-07-08 11:16:00', '2024-07-08 11:16:00'),
(51, '10.51651363', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', '21wddBHJRrr30zASDEWJNBVGSDXoomz9', '1', 'Sent', '2024-07-15 20:20:00', '2024-07-15 20:20:00'),
(52, '2.07160689', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', 'FDGNCMVYUIYT78654324567VCFDX', '1', 'Sent', '2024-07-15 20:17:00', '2024-07-15 20:17:00'),
(53, '2.07160689', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', 'XCDAHSGVZ6TDGWBA3WRUEASYG34SDNBHSAY', '1', 'Sent', '2024-07-22 17:23:00', '2024-07-22 17:23:00'),
(54, '5.3084792', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', '221wddBHJRrr30zASDEWJNBVGSDXD4SXSDCV', '1', 'Sent', '2024-07-22 18:02:00', '2024-07-22 18:02:00'),
(55, '0.74578193', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', 'HJT576XXSH9JJltc1qu3sawh0w23n347y0IUNB', '1', 'Sent', '2024-07-22 18:51:00', '2024-07-22 18:51:00'),
(56, '34.86371593', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', '727gfJHGSATGHJQOIKJWEQEMFSDVOPKJNDFABS', '1', 'Sent', '2024-07-22 19:16:00', '2024-07-22 19:16:00'),
(57, '9.77045911', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', 'TRYTGJHMB0277QWSB98YTJIO0JRSE42S221kjaws', '1', 'Sent', '2024-07-22 19:33:00', '2024-07-22 19:33:00'),
(58, '15.78193688', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', '22OBAGDQBKVMWL2NMHAOZGOOE23PQ07adS', '1', 'Sent', '2024-07-22 21:02:00', '2024-07-22 21:02:00'),
(59, '0.14348637', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', 'FDGNCMVYUIYT78654324567VCFDX29OODKa', '1', 'Sent', '2024-07-22 21:15:00', '2024-07-22 21:15:00'),
(60, '10.67436155', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', '21wddBHJRrr30zASDEWJNBVGSDXoomz90oOO', '1', 'Sent', '2024-07-22 21:46:00', '2024-07-22 21:46:00'),
(61, '0.21522238', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', '2OBAGDQBKVMWL2NMHAOZGOOE23PQAJLGZY', '1', 'Sent', '2024-07-23 08:41:00', '2024-07-23 08:41:00'),
(62, '13.28552368', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', 'TRGHJKMNBVqCDXS2RDbCXVBH6we88lQWNGg', '1', 'Sent', '2024-07-23 08:58:00', '2024-07-23 08:58:00'),
(63, '68.89843616', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', '2ZXSDCFGYHUJIO98UYHJNBVGSDXD4SXSDCV', '1', 'Sent', '2024-07-23 09:06:00', '2024-07-23 09:06:00'),
(64, '9.62698709', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', 'YPLKMNBVCXDFGH3221wddBHJRrr30zASDEW', '1', 'Sent', '2024-07-23 09:38:00', '2024-07-23 09:38:00'),
(65, '7.8048924', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', 'BAMOIUYJKJ479HBVCXZ765DXZAQ1S6RCVB', '1', 'Sent', '2024-07-23 09:55:00', '2024-07-23 09:55:00'),
(66, '4.28344333', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', '0o0hhgQWEDFGBHNMIUYTFDXCVBNHUYHGF', '1', 'Sent', '2024-07-23 10:12:00', '2024-07-23 10:12:00'),
(67, '0.93331421', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', 'EamnOIUYHBNMZERTGVCX6032CVMKOYTG', '1', 'Sent', '2024-07-23 10:27:00', '2024-07-23 10:27:00'),
(68, '41.99430416', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', 'POKJNBCFRweWEDFGHNMwerfc6432ertRQQ', '1', 'Sent', '2024-07-23 10:32:00', '2024-07-23 10:32:00'),
(69, '7.71450502', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', 'MNBVqC0879685CXVBH6wHJT576Xe88lQW', '1', 'Sent', '2024-07-31 09:28:00', '2024-07-31 09:28:00'),
(70, '0.44908178', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', 'gf865JHGDXWEDCK9809S2RDbSATGHJ', '1', 'Sent', '2024-07-31 09:47:00', '2024-07-31 09:47:00'),
(71, '28.19239599', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', '73BNJKJYPOLKJFuuDDSCH665UYZAWT55', '1', 'Sent', '2024-07-31 10:05:00', '2024-07-31 10:05:00'),
(72, '12.62555237', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', '0OoxzUHGYJ4308XSRnb56UBNHTTTRWZrf', '1', 'Sent', '2024-07-31 10:12:00', '2024-07-31 10:12:00'),
(73, '12.62555237', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', 'QRS8HNV6DTerfh776QQSIJN0PKMBG76A', '1', 'Sent', '2024-07-31 10:16:00', '2024-07-31 10:16:00'),
(74, '0.90388809', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', 'LVRloooBVGHY69903DXZqecxxXCDYT554F', '1', 'Sent', '2024-07-31 10:38:00', '2024-07-31 10:38:00'),
(75, '464.6772023', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', 'RT3AASookTFVJ0NBGEER546GGGFerfUUYa', '1', 'Sent', '2024-07-31 10:44:00', '2024-07-31 10:44:00'),
(76, '107.73315639', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', '8SYADHBKSDXNGU8jhdajOhb98hijNDSHS83', '1', 'Sent', '2024-07-31 11:01:00', '2024-07-31 11:01:00'),
(77, '0.87519369', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', 'Kaw45QWXXfdsaWD45T6Y76XXSH9JJ0IUNB', '1', 'Sent', '2024-07-31 11:09:00', '2024-07-31 11:09:00'),
(78, '3.70159254', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', '0ws17…72cba', '1', 'Sent', '2024-08-22 04:00:00', '2024-08-22 04:00:00'),
(79, '3.70159254', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', '0ws17…72cba', '1', 'Sent', '2024-08-22 20:06:00', '2024-08-22 20:06:00'),
(80, '11.73470589', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', 'B33xh…0mh1a', '1', 'Sent', '2024-08-22 20:35:00', '2024-08-22 20:35:00'),
(81, '0.84011478', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', 'rtcc7…92ssz', '1', 'Sent', '2024-08-22 20:58:00', '2024-08-22 20:58:00'),
(82, '90.9612769', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', '8syad…jhdap', '1', 'Sent', '2024-08-22 21:26:00', '2024-08-22 21:26:00'),
(83, '6.19657102', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', 'Kaw45…6xxsh', '1', 'Sent', '2024-08-22 21:49:00', '2024-08-22 21:49:00'),
(84, '13.16942611', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', 'Lbrlo…oobv4', '1', 'Sent', '2024-08-22 22:27:00', '2024-08-22 22:27:00'),
(85, '0.38147776', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', '3ov20…vkgpp', '1', 'Sent', '2024-08-22 22:44:00', '2024-08-22 22:44:00'),
(86, '10.01911048', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', 'vnxxd…438sd', '1', 'Sent', '2024-08-22 23:03:00', '2024-08-22 23:03:00');

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

--
-- Table structure for table `wallet`
--

CREATE TABLE `wallet` (
  `id` int(11) NOT NULL,
  `name` varchar(30) NOT NULL,
  `address` varchar(100) DEFAULT NULL,
  `symbol` varchar(20) NOT NULL,
  `balance` varchar(30) NOT NULL DEFAULT '0',
  `logo` varchar(100) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `wallet`
--

INSERT INTO `wallet` (`id`, `name`, `address`, `symbol`, `balance`, `logo`, `created_at`, `updated_at`) VALUES
(1, 'bitcoin', 'bc1qytxpfp5ac9pgjdr77sg3tw82778tm58ax5adtyb', 'btc', '1033', 'bitlogo.png', '2024-08-22 23:14:35', '0000-00-00 00:00:00'),
(2, 'ethereum', 'OXbis092920jd929d928d9hd9', 'eth', '1.02', 'ethlogo.png', '2024-06-28 11:17:13', '0000-00-00 00:00:00'),
(3, 'tether', NULL, 'usdt', '0.02', 'usdtlogo.png', '2024-06-21 14:35:15', '0000-00-00 00:00:00');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `transactions`
--
ALTER TABLE `transactions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `wallet`
--
ALTER TABLE `wallet`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `transactions`
--
ALTER TABLE `transactions`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=87;

--
-- AUTO_INCREMENT for table `wallet`
--
ALTER TABLE `wallet`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
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 */;
