Untitled

-- phpMyAdmin SQL Dump
-- version 5.2.0
-- https://www.phpmyadmin.net/
--
-- Host: 10.1.39.179
-- Generation Time: Mar 17, 2023 at 07:17 AM
-- Server version: 5.7.35
-- PHP Version: 8.0.22

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

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

--
-- Table structure for table `ticket`
--

CREATE TABLE `ticket` (
  `id` int(11) NOT NULL,
  `sender_id` text COLLATE utf8_vietnamese_ci,
  `customer_phone` text COLLATE utf8_vietnamese_ci,
  `data` longtext COLLATE utf8_vietnamese_ci,
  `ticket_code` text COLLATE utf8_vietnamese_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_vietnamese_ci;

--
-- Dumping data for table `ticket`
--

INSERT INTO `ticket` (`id`, `sender_id`, `customer_phone`, `data`, `ticket_code`) VALUES
(7, '1655286278091', '0383842124', '{\"account_number\": \"0001905476761\", \"transaction_date\": \"20/04/2022\", \"transaction_code\": \"736310\", \"transaction_amount\": \"1745660\", \"ticket_code\": \"E22060162\"}', 'E22060162'),
(9, '1655550184381', '0383842124', '{\"account_number\": \"0020108625008\", \"transaction_date\": \"03/05/2022\", \"transaction_code\": \"123457\", \"transaction_amount\": \"23000\", \"ticket_code\": \"E22060257\"}', 'E22060257'),
(10, '1655550260986', '0383842124', '{\"account_number\": \"0020108625008\", \"transaction_date\": \"03/05/2022\", \"transaction_code\": \"123458\", \"transaction_amount\": \"1234\", \"ticket_code\": \"E22060258\"}', 'E22060258'),
(11, '1655550345332', '0383842124', '{\"account_number\": \"0020101337007\", \"transaction_date\": \"03/05/2022\", \"transaction_code\": \"123459\", \"transaction_amount\": \"10000\", \"ticket_code\": \"E22060259\"}', 'E22060259'),
(12, '1655550466036', '0383842124', '{\"account_number\": \"0020101337007\", \"transaction_date\": \"03/05/2022\", \"transaction_code\": \"123460\", \"transaction_amount\": \"121212\", \"ticket_code\": \"E22060260\"}', 'E22060260'),
(18, '1655621766028', '0968221530', '{\"account_number\": \"0020108625008\", \"transaction_date\": \"03/05/2022\", \"transaction_code\": \"123456\", \"transaction_amount\": \"123456\", \"ticket_code\": \"E22060267\"}', 'E22060267'),
(19, '20220619151542-318ec0c7-d7ea-4740-b586-c1c1195b86b8', '0903214455', '{\"account_number\": \"0020101337007\", \"transaction_date\": \"03/05/2022\", \"transaction_code\": \"123461\", \"transaction_amount\": \"9000\", \"ticket_code\": \"E22060270\"}', 'E22060270'),
(20, '20220620165219-2a8bf458-abb0-442b-a2d8-8f1bdeee2e4b', '0984001273', '{\"account_number\": \"0984001273\", \"transaction_date\": \"03/05/2022\", \"transaction_code\": \"123469\", \"transaction_amount\": \"20000\", \"ticket_code\": \"E22060283\"}', 'E22060283'),
(21, '20220620170415-f99e4d0a-414d-47fd-9e55-f639d2b0e2b2', '0362008090', '{\"account_number\": \"7800100338008\", \"transaction_date\": \"03/05/2022\", \"transaction_code\": \"123463\", \"transaction_amount\": \"23420\", \"ticket_code\": \"E22060285\"}', 'E22060285'),
(22, '20220621170606-a98abf32-1c4a-42e5-8861-0aaad6aea5e3', '0392348904', '{\"account_number\": \"0020183207009\", \"transaction_date\": \"03/05/2022\", \"transaction_code\": \"123465\", \"transaction_amount\": \"45000\", \"ticket_code\": \"E22060299\"}', 'E22060299'),
(23, '20220621170632-ed9380c1-a748-4d35-894d-31dd0ccb5132', '0984001273', '{\"account_number\": \"0984001273\", \"transaction_date\": \"03/05/2022\", \"transaction_code\": \"123468\", \"transaction_amount\": \"10000\", \"ticket_code\": \"E22060300\"}', 'E22060300'),
(24, '20220621172321-845932a7-5e09-4e4a-b7f1-7a318ad509ca', '0392348904', '{\"account_number\": \"0020183207009\", \"transaction_date\": \"03/05/2022\", \"transaction_code\": \"123466\", \"transaction_amount\": \"55050\", \"ticket_code\": \"E22060305\"}', 'E22060305'),
(25, '20220622133441-0544bf80-e0b8-48d7-93a3-67b45f27de16', '0362008090', '{\"account_number\": \"7800100338008\", \"transaction_date\": \"03/05/2022\", \"transaction_code\": \"123463\", \"transaction_amount\": \"12000\", \"ticket_code\": \"E22060320\"}', 'E22060320'),
(26, '20230103133200-751c7a2a-be84-451b-853b-e4e1074f4e2b', '0984001273', '{\"account_number\": \"4433900088157\", \"transaction_date\": \"08/11/2022\", \"transaction_code\": \"123456\", \"transaction_amount\": \"45000000\", \"ft_code\": \"FT22312139090140\", \"payment_detail\": \"Trace 123456 \", \"ticket_code\": \"E23010006\"}', 'E23010006');

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

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