-- 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 */;