-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Oct 30, 2025 at 04:40 PM
-- Server version: 10.6.23-MariaDB
-- PHP Version: 8.4.13

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

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

--
-- Table structure for table `app_reviews`
--

CREATE TABLE `app_reviews` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `rating` int(11) NOT NULL CHECK (`rating` >= 1 and `rating` <= 5),
  `review` text NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `app_reviews`
--

INSERT INTO `app_reviews` (`id`, `name`, `rating`, `review`, `created_at`) VALUES
(1, 'Yusuf', 4, 'Absolutely fantastic app! I have been using EasePay for a while and it has truly transformed the way I make payments. The customer support is top notch.', '2025-09-06 22:49:46'),
(2, 'Abdul', 5, 'I will give them five stars! Instant delivery, 99.9% successful transactions, stable network, cheapest fees I ever come across.', '2025-09-06 22:49:46'),
(3, 'David', 4, 'EasePay is the best payment app I have ever come across. I have been using it for the past two years and it keeps getting better with each update.', '2025-09-06 22:49:46'),
(4, 'Chioma', 5, 'This app has made my life so much easier. Bill payments are now a breeze with EasePay. Highly recommended!', '2025-09-06 22:49:46'),
(5, 'Emeka', 3, 'Good app but sometimes transactions fail. When they work, they are very fast though.', '2025-09-06 22:49:46');

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

--
-- Table structure for table `page_visits`
--

CREATE TABLE `page_visits` (
  `id` int(11) NOT NULL,
  `page` varchar(255) NOT NULL,
  `url` text NOT NULL,
  `referrer` text DEFAULT NULL,
  `visited_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `page_visits`
--

INSERT INTO `page_visits` (`id`, `page`, `url`, `referrer`, `visited_at`, `ip_address`, `user_agent`) VALUES
(1, 'download', 'https://easepay.ng/appstore/', '', '2025-09-13 13:24:20', '102.90.100.32', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:142.0) Gecko/20100101 Firefox/142.0'),
(2, 'download', 'https://easepay.ng/appstore/', '', '2025-09-13 13:27:05', '102.90.100.32', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:142.0) Gecko/20100101 Firefox/142.0'),
(3, 'download', 'https://easepay.ng/appstore/', '', '2025-09-13 13:28:45', '102.90.100.32', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Mobile Safari/537.36'),
(4, 'download', 'https://easepay.ng/appstore/', '', '2025-09-13 14:03:22', '102.88.115.97', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Mobile Safari/537.36'),
(5, 'download', 'https://easepay.ng/appstore/', '', '2025-09-13 14:24:04', '102.88.115.97', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Mobile Safari/537.36'),
(6, 'download', 'https://easepay.ng/appstore/', '', '2025-09-13 14:24:35', '102.88.115.97', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Mobile Safari/537.36'),
(7, 'download', 'https://easepay.ng/appstore/', '', '2025-09-13 15:24:39', '102.90.117.189', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Mobile Safari/537.36'),
(8, 'download', 'https://easepay.ng/appstore/', '', '2025-09-13 18:23:45', '102.90.117.189', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Mobile Safari/537.36'),
(9, 'download', 'https://easepay.ng/appstore/', '', '2025-09-13 21:29:07', '102.90.117.189', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Mobile Safari/537.36'),
(10, 'download', 'https://easepay.ng/appstore/', '', '2025-09-13 21:29:11', '102.90.117.189', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Mobile Safari/537.36'),
(11, 'download', 'https://easepay.ng/appstore/', '', '2025-09-13 21:29:19', '102.90.117.189', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Mobile Safari/537.36'),
(12, 'download', 'https://easepay.ng/appstore/', '', '2025-09-13 21:30:37', '102.90.117.189', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Mobile Safari/537.36'),
(13, 'download', 'https://easepay.ng/appstore/', '', '2025-09-18 22:21:53', '102.90.118.81', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:142.0) Gecko/20100101 Firefox/142.0'),
(14, 'download', 'https://easepay.ng/appstore/', '', '2025-09-18 22:26:20', '102.90.118.81', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:142.0) Gecko/20100101 Firefox/142.0'),
(15, 'download', 'https://easepay.ng/appstore/', '', '2025-09-18 22:28:00', '102.90.118.81', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:142.0) Gecko/20100101 Firefox/142.0'),
(16, 'download', 'https://easepay.ng/appstore/', '', '2025-09-18 22:29:05', '102.90.118.81', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:142.0) Gecko/20100101 Firefox/142.0'),
(17, 'download', 'https://easepay.ng/appstore/', '', '2025-09-18 22:31:46', '102.90.118.81', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:142.0) Gecko/20100101 Firefox/142.0'),
(18, 'download', 'https://easepay.ng/appstore/', '', '2025-09-18 22:33:08', '102.90.118.81', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:142.0) Gecko/20100101 Firefox/142.0'),
(19, 'download', 'https://easepay.ng/appstore/', '', '2025-09-18 22:34:54', '102.90.118.81', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:142.0) Gecko/20100101 Firefox/142.0'),
(20, 'download', 'https://easepay.ng/appstore/', '', '2025-09-18 22:37:24', '102.90.118.81', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:142.0) Gecko/20100101 Firefox/142.0'),
(21, 'download', 'https://easepay.ng/appstore/', '', '2025-09-18 22:38:25', '102.90.118.81', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Mobile Safari/537.36'),
(22, 'download', 'https://easepay.ng/appstore/', '', '2025-09-18 22:38:40', '102.90.118.81', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Mobile Safari/537.36'),
(23, 'download', 'https://easepay.ng/appstore/', '', '2025-09-19 02:25:10', '102.90.102.25', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Mobile Safari/537.36'),
(24, 'download', 'https://easepay.ng/appstore/', '', '2025-09-19 12:12:46', '102.90.101.165', 'Mozilla/5.0 (Linux; Android 12; SM-G9730 Build/SP1A.210812.016; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/139.0.7258.160 Mobile Safari/537.36'),
(25, 'download', 'https://easepay.ng/appstore/', '', '2025-09-19 20:03:36', '102.90.97.225', 'Mozilla/5.0 (Linux; Android 12; SM-G9730 Build/SP1A.210812.016; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/139.0.7258.160 Mobile Safari/537.36'),
(26, 'download', 'https://easepay.ng/appstore/', '', '2025-09-20 18:26:26', '102.90.96.16', 'Mozilla/5.0 (Linux; Android 12; SM-G9730 Build/SP1A.210812.016; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/140.0.7339.51 Mobile Safari/537.36'),
(27, 'download', 'https://easepay.ng/appstore/', '', '2025-09-20 18:58:17', '102.90.103.111', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:142.0) Gecko/20100101 Firefox/142.0'),
(28, 'download', 'https://easepay.ng/appstore/', '', '2025-09-20 19:00:43', '102.90.103.111', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:142.0) Gecko/20100101 Firefox/142.0'),
(29, 'download', 'https://easepay.ng/appstore/', '', '2025-09-20 19:01:22', '102.90.103.111', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:142.0) Gecko/20100101 Firefox/142.0'),
(30, 'download', 'https://easepay.ng/appstore/', '', '2025-09-20 19:01:27', '102.90.103.111', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:142.0) Gecko/20100101 Firefox/142.0'),
(31, 'download', 'https://easepay.ng/appstore/', '', '2025-09-20 19:02:27', '102.90.103.111', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:142.0) Gecko/20100101 Firefox/142.0'),
(32, 'download', 'https://easepay.ng/appstore/', '', '2025-09-20 19:02:55', '102.90.103.111', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:142.0) Gecko/20100101 Firefox/142.0'),
(33, 'download', 'https://easepay.ng/appstore/', '', '2025-09-20 19:03:08', '102.90.103.111', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:142.0) Gecko/20100101 Firefox/142.0'),
(34, 'download', 'https://easepay.ng/appstore/', '', '2025-09-20 19:03:36', '102.90.103.111', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:142.0) Gecko/20100101 Firefox/142.0'),
(35, 'download', 'https://easepay.ng/appstore/', '', '2025-09-20 19:04:21', '102.90.103.111', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:142.0) Gecko/20100101 Firefox/142.0'),
(36, 'download', 'https://easepay.ng/appstore/', '', '2025-09-20 19:05:12', '102.90.103.111', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:142.0) Gecko/20100101 Firefox/142.0'),
(37, 'download', 'https://easepay.ng/appstore/', '', '2025-09-20 19:06:49', '102.90.103.111', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:142.0) Gecko/20100101 Firefox/142.0'),
(38, 'download', 'https://easepay.ng/appstore/', '', '2025-09-20 19:10:34', '102.90.103.111', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:142.0) Gecko/20100101 Firefox/142.0'),
(39, 'download', 'https://easepay.ng/appstore/', '', '2025-09-20 20:06:57', '102.90.101.162', 'Mozilla/5.0 (Linux; Android 12; SM-G9730 Build/SP1A.210812.016; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/140.0.7339.51 Mobile Safari/537.36'),
(40, 'download', 'https://easepay.ng/appstore/', '', '2025-09-20 20:09:54', '102.90.101.162', 'Mozilla/5.0 (Linux; Android 12; SM-G9730 Build/SP1A.210812.016; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/140.0.7339.51 Mobile Safari/537.36'),
(41, 'download', 'https://easepay.ng/appstore/', '', '2025-09-21 16:34:26', '102.90.100.10', 'Mozilla/5.0 (Linux; Android 12; SM-G9730 Build/SP1A.210812.016; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/140.0.7339.51 Mobile Safari/537.36'),
(42, 'download', 'https://easepay.ng/appstore/', '', '2025-09-21 16:55:52', '102.90.100.10', 'Mozilla/5.0 (Linux; Android 12; SM-G9730 Build/SP1A.210812.016; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/140.0.7339.51 Mobile Safari/537.36'),
(43, 'download', 'https://easepay.ng/appstore/', '', '2025-09-21 16:56:00', '102.90.100.10', 'Mozilla/5.0 (Linux; Android 12; SM-G9730 Build/SP1A.210812.016; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/140.0.7339.51 Mobile Safari/537.36'),
(44, 'download', 'https://easepay.ng/appstore/', '', '2025-09-21 16:56:40', '102.90.100.10', 'Mozilla/5.0 (Linux; Android 12; SM-G9730 Build/SP1A.210812.016; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/140.0.7339.51 Mobile Safari/537.36'),
(45, 'download', 'http://easepay.ng/appstore/', '', '2025-09-23 14:17:26', '102.90.117.143', 'Mozilla/5.0 (Linux; Android 12; SM-G9730 Build/SP1A.210812.016; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/140.0.7339.52 Mobile Safari/537.36'),
(46, 'download', 'http://easepay.ng/appstore/', '', '2025-10-02 20:33:34', '102.90.99.28', 'Mozilla/5.0 (Linux; Android 12; SM-G9730 Build/SP1A.210812.016; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/140.0.7339.207 Mobile Safari/537.36'),
(47, 'download', 'http://easepay.ng/appstore/', '', '2025-10-06 18:55:53', '102.90.97.58', 'Mozilla/5.0 (Linux; Android 12; SM-G9730 Build/SP1A.210812.016; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/140.0.7339.207 Mobile Safari/537.36'),
(48, 'download', 'http://easepay.ng/appstore/', '', '2025-10-08 18:48:44', '102.90.101.86', 'Mozilla/5.0 (Linux; Android 12; SM-G9730 Build/SP1A.210812.016; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/140.0.7339.207 Mobile Safari/537.36'),
(49, 'download', 'http://easepay.ng/appstore/', '', '2025-10-09 20:54:38', '102.90.101.114', 'Mozilla/5.0 (Linux; Android 12; SM-G9730 Build/SP1A.210812.016; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/140.0.7339.207 Mobile Safari/537.36'),
(50, 'download', 'https://easepay.ng/appstore/', '', '2025-10-11 18:51:07', '102.90.98.204', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Mobile Safari/537.36'),
(51, 'download', 'https://easepay.ng/appstore/', '', '2025-10-11 18:51:10', '102.90.98.204', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Mobile Safari/537.36'),
(52, 'download', 'https://easepay.ng/appstore/', '', '2025-10-11 18:52:56', '102.90.98.204', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Mobile Safari/537.36'),
(53, 'download', 'http://easepay.ng/appstore/', '', '2025-10-18 16:08:23', '102.90.103.13', 'Mozilla/5.0 (Linux; Android 12; SM-G9730 Build/SP1A.210812.016; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/140.0.7339.207 Mobile Safari/537.36'),
(54, 'download', 'http://easepay.ng/appstore/', '', '2025-10-26 15:24:29', '102.90.115.101', 'Mozilla/5.0 (Linux; Android 12; SM-G9730 Build/SP1A.210812.016; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/141.0.7390.98 Mobile Safari/537.36'),
(55, 'download', 'https://easepay.ng/appstore/', '', '2025-10-27 12:22:56', '102.90.103.68', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:144.0) Gecko/20100101 Firefox/144.0'),
(56, 'download', 'http://easepay.ng/appstore/', '', '2025-10-27 19:48:15', '102.90.101.189', 'Mozilla/5.0 (Linux; Android 12; SM-G9730 Build/SP1A.210812.016; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/141.0.7390.98 Mobile Safari/537.36');

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

--
-- Table structure for table `reviews`
--

CREATE TABLE `reviews` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `rating` tinyint(4) NOT NULL CHECK (`rating` >= 1 and `rating` <= 5),
  `review` text NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `status` enum('pending','approved') DEFAULT 'approved'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `reviews`
--

INSERT INTO `reviews` (`id`, `name`, `rating`, `review`, `created_at`, `status`) VALUES
(1, 'testing', 5, 'best app', '2025-09-13 13:27:22', 'approved'),
(2, 'David', 4, 'This is a very good and convenient app', '2025-09-20 20:07:40', 'approved');

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

--
-- Table structure for table `visits`
--

CREATE TABLE `visits` (
  `id` int(11) NOT NULL,
  `page` varchar(50) DEFAULT 'index',
  `visit_date` date DEFAULT curdate(),
  `hits` int(11) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `visits`
--

INSERT INTO `visits` (`id`, `page`, `visit_date`, `hits`) VALUES
(1, 'index', '2025-09-13', 2);

--
-- Indexes for dumped tables
--

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

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

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

--
-- Indexes for table `visits`
--
ALTER TABLE `visits`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `page_date` (`page`,`visit_date`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `app_reviews`
--
ALTER TABLE `app_reviews`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `page_visits`
--
ALTER TABLE `page_visits`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=57;

--
-- AUTO_INCREMENT for table `reviews`
--
ALTER TABLE `reviews`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

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