-- phpMyAdmin SQL Dump
-- version 4.9.5
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Dec 26, 2020 at 06:43 PM
-- Server version: 5.7.32
-- PHP Version: 7.3.6

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
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: `mbazii0_register`
--

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

--
-- Table structure for table `app_save_payment`
--

CREATE TABLE `app_save_payment` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `amount` varchar(100) NOT NULL,
  `status` varchar(15) NOT NULL,
  `extras` text,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `products` longtext
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `app_save_payment`
--

INSERT INTO `app_save_payment` (`id`, `name`, `email`, `amount`, `status`, `extras`, `created_at`, `updated_at`, `products`) VALUES
(15, 'Test', 'try@try.com', '1', '270', '', '2020-12-09 18:15:15', '2020-12-09 18:15:15', NULL),
(14, 'Test', 'try@try.com', '1', '270', '', '2020-12-09 16:14:55', '2020-12-09 16:14:55', NULL),
(13, 'Test', 'poi489502@gmail.com', '1', '140', '', '2020-12-09 16:12:09', '2020-12-09 16:12:09', NULL),
(12, 'Test', 'poi489502@gmail.com', '1', '30', '', '2020-12-09 16:09:08', '2020-12-09 16:09:08', NULL),
(16, 'Test', 'poi489502@gmail.com', '750', '1', '', '2020-12-09 18:31:53', '2020-12-09 18:31:53', NULL),
(17, 'Test', 'poi489502@gmail.com', '30.00', '1', '[{\"description\":\"3 Pizzas\",\"product\":\"Pizza3\",\"cost\":30}]', '2020-12-10 12:38:55', '2020-12-10 12:38:55', NULL),
(18, 'Test', 'poi489502@gmail.com', '450.00', '1', '[{\"description\":\"3 Pizzas\",\"product\":\"Pizza3\",\"cost\":30},{\"description\":\"3 Shapes : 70 Flavor\",\"product\":\"Shapes\",\"cost\":420}]', '2020-12-10 12:47:56', '2020-12-10 12:47:56', NULL),
(19, 'Test', 'poi489502@gmail.com', '30.00', '1', '[{\"description\":\"3 Pizzas\",\"product\":\"Pizza3\",\"cost\":30,\"payment_type\":\"PayGate\"}]', '2020-12-10 16:05:51', '2020-12-10 16:05:51', NULL),
(20, 'Test', 'poi489502@gmail.com', '30.00', 'approved', '[{\"description\":\"3 Pizzas\",\"product\":\"Pizza3\",\"cost\":30,\"payment_type\":\"PayPal\"}]', '2020-12-10 16:29:40', '2020-12-10 16:29:40', NULL),
(21, 'Test', 'poi489502@gmail.com', '30.00', '1', '[{\"description\":\"3 Pizzas\",\"product\":\"Pizza3\",\"cost\":30,\"payment_type\":\"PayGate\"}]', '2020-12-10 16:32:42', '2020-12-10 16:32:42', NULL),
(22, 'Test', 'try@try.com', '590.00', 'approved', '[{\"description\":\"4 Shapes : 70 Flavor\",\"product\":\"Shapes\",\"cost\":560,\"payment_type\":\"PayPal\"},{\"description\":\"3 Pizzas\",\"product\":\"Pizza3\",\"cost\":30,\"payment_type\":\"PayPal\"}]', '2020-12-10 17:01:44', '2020-12-10 17:01:44', NULL),
(23, 'Test', 'poi489502@gmail.com', '140.00', 'approved', '[{\"description\":\"1 Shapes : 70 Flavor\",\"product\":\"Shapes\",\"cost\":140}]', '2020-12-10 18:03:03', '2020-12-10 18:03:03', 'PayPal'),
(24, 'Test', 'poi489502@gmail.com', '140.00', '1', '[{\"description\":\"1 Shapes : 70 Flavor\",\"product\":\"Shapes\",\"cost\":140}]', '2020-12-10 18:05:21', '2020-12-10 18:05:21', 'PayGate'),
(25, 'Test', 'mmbaz17@gmail.com', '30.00', '1', '[{\"description\":\"3 Pizzas\",\"product\":\"Pizza3\",\"cost\":30}]', '2020-12-11 09:49:40', '2020-12-11 09:49:40', 'PayGate'),
(26, 'Test', 'mmbaz17@gmail.com', '30.00', 'approved', '[{\"description\":\"3 Pizzas\",\"product\":\"Pizza3\",\"cost\":30}]', '2020-12-11 10:06:07', '2020-12-11 10:06:07', 'PayPal'),
(27, 'Live', 'poi489502@gmail.com', '30.00', 'approved', '[{\"description\":\"3 Pizzas\",\"product\":\"Pizza3\",\"cost\":30}]', '2020-12-15 10:43:45', '2020-12-15 10:43:45', 'PayPal'),
(28, 'Live', 'poi489502@gmail.com', '30.00', 'Error', '[{\"description\":\"3 Pizzas\",\"product\":\"Pizza3\",\"cost\":30}]', '2020-12-17 15:46:34', '2020-12-17 15:46:34', 'PayGate'),
(29, 'Live', 'poi489502@gmail.com', '30.00', 'Error', '[{\"description\":\"3 Pizzas\",\"product\":\"Pizza3\",\"cost\":30}]', '2020-12-17 15:48:53', '2020-12-17 15:48:53', 'PayGate'),
(30, 'Live', 'poi489502@gmail.com', '30.00', 'Error', '[{\"description\":\"3 Pizzas\",\"product\":\"Pizza3\",\"cost\":30}]', '2020-12-17 15:56:57', '2020-12-17 15:56:57', 'PayGate'),
(31, 'Live', 'poi489502@gmail.com', '30.00', 'Error', '[{\"description\":\"3 Pizzas\",\"product\":\"Pizza3\",\"cost\":30}]', '2020-12-18 07:46:13', '2020-12-18 07:46:13', 'PayGate'),
(32, 'Live', 'poi489502@gmail.com', '30.00', 'Error', '[{\"description\":\"3 Pizzas\",\"product\":\"Pizza3\",\"cost\":30}]', '2020-12-18 08:02:52', '2020-12-18 08:02:52', 'PayGate'),
(33, 'Live', 'poi489502@gmail.com', '30.00', 'Error', '[{\"description\":\"3 Pizzas\",\"product\":\"Pizza3\",\"cost\":30}]', '2020-12-18 08:05:37', '2020-12-18 08:05:37', 'PayGate'),
(34, 'Live', 'poi489502@gmail.com', '30.00', 'Error', '[{\"description\":\"3 Pizzas\",\"product\":\"Pizza3\",\"cost\":30}]', '2020-12-18 08:08:44', '2020-12-18 08:08:44', 'PayGate'),
(35, 'Live', 'poi489502@gmail.com', '30.00', 'Error', '[{\"description\":\"3 Pizzas\",\"product\":\"Pizza3\",\"cost\":30}]', '2020-12-18 17:22:27', '2020-12-18 17:22:27', 'PayGate'),
(36, 'Live', 'poi489502@gmail.com', '30.00', 'Error', '[{\"description\":\"3 Pizzas\",\"product\":\"Pizza3\",\"cost\":30}]', '2020-12-20 10:22:44', '2020-12-20 10:22:44', 'PayGate'),
(37, 'Live', 'poi489502@gmail.com', '270.00', 'Error', '[{\"description\":\"1 Shapes : 120 Flavor\",\"product\":\"Shapes\",\"cost\":240},{\"description\":\"3 Pizzas\",\"product\":\"Pizza3\",\"cost\":30}]', '2020-12-20 10:49:55', '2020-12-20 10:49:55', 'PayGate'),
(38, 'Live', 'poi489502@gmail.com', '30.00', 'Error', '[{\"description\":\"3 Pizzas\",\"product\":\"Pizza3\",\"cost\":30}]', '2020-12-20 10:53:33', '2020-12-20 10:53:33', 'PayGate'),
(39, 'Live', 'poi489502@gmail.com', '510.00', 'Error', '[{\"description\":\"3 Pizzas\",\"product\":\"Pizza3\",\"cost\":30},{\"description\":\"2 Shapes : 120 Flavor\",\"product\":\"Shapes\",\"cost\":480}]', '2020-12-20 10:55:27', '2020-12-20 10:55:27', 'PayGate'),
(40, 'Live', 'poi489502@gmail.com', '30.00', 'Error', '[{\"description\":\"3 Pizzas\",\"product\":\"Pizza3\",\"cost\":30}]', '2020-12-21 11:46:44', '2020-12-21 11:46:44', 'PayGate'),
(41, 'Live', 'poi489502@gmail.com', '30.00', 'Error', '[{\"description\":\"3 Pizzas\",\"product\":\"Pizza3\",\"cost\":30}]', '2020-12-21 13:16:50', '2020-12-21 13:16:50', 'PayGate'),
(42, 'Live', 'poi489502@gmail.com', '30.00', 'Error', '[{\"description\":\"3 Pizzas\",\"product\":\"Pizza3\",\"cost\":30}]', '2020-12-21 16:32:48', '2020-12-21 16:32:48', 'PayGate'),
(43, 'Live', 'poi489502@gmail.com', '30.00', 'Error', '[{\"description\":\"3 Pizzas\",\"product\":\"Pizza3\",\"cost\":30}]', '2020-12-21 16:36:18', '2020-12-21 16:36:18', 'PayGate'),
(44, 'Live', 'poi489502@gmail.com', '30.00', 'Error', '[{\"description\":\"3 Pizzas\",\"product\":\"Pizza3\",\"cost\":30}]', '2020-12-23 15:55:33', '2020-12-23 15:55:33', 'PayGate'),
(45, 'Live', 'poi489502@gmail.com', '30.00', 'Error', '[{\"description\":\"3 Pizzas\",\"product\":\"Pizza3\",\"cost\":30}]', '2020-12-23 15:56:53', '2020-12-23 15:56:53', 'PayGate'),
(46, 'Live', 'poi489502@gmail.com', '30.00', 'Error', '[{\"description\":\"3 Pizzas\",\"product\":\"Pizza3\",\"cost\":30}]', '2020-12-23 17:17:55', '2020-12-23 17:17:55', 'PayGate'),
(47, 'Live', 'poi489502@gmail.com', '30.00', 'Error', '[{\"description\":\"3 Pizzas\",\"product\":\"Pizza3\",\"cost\":30}]', '2020-12-23 17:34:32', '2020-12-23 17:34:32', 'PayGate'),
(48, 'Live', 'poi489502@gmail.com', '3000.00', 'success', '[{\"description\":\"3 Pizzas\",\"product\":\"Pizza3\",\"cost\":30}]', '2020-12-25 13:17:05', '2020-12-25 13:17:05', 'PayGate');

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

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