| Server IP : 172.64.80.1 / Your IP : 172.70.50.62 Web Server : Apache System : Linux mail.federalpolyede.edu.ng 5.10.0-32-amd64 #1 SMP Debian 5.10.223-1 (2024-08-10) x86_64 User : federalpolyede.edu.ng_idh35skikv ( 10000) PHP Version : 7.4.33 Disable Function : opcache_get_status MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /var/www/vhosts/federalpolyede.edu.ng/phd_code/securitymodel/ |
Upload File : |
-- phpMyAdmin SQL Dump
-- version 5.2.0
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Aug 14, 2023 at 10:28 PM
-- Server version: 10.4.24-MariaDB
-- PHP Version: 8.1.6
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: `security_model`
--
-- --------------------------------------------------------
--
-- Table structure for table `admins`
--
CREATE TABLE `admins` (
`id` int(11) NOT NULL,
`username` varchar(128) DEFAULT NULL,
`contact` varchar(128) DEFAULT NULL,
`email` varchar(128) DEFAULT NULL,
`password` varchar(128) DEFAULT NULL,
`date` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `admins`
--
INSERT INTO `admins` (`id`, `username`, `contact`, `email`, `password`, `date`) VALUES
(1, 'admin', '08076738293', '[email protected]', 'pbkdf2:sha256:260000$3w4Nm6le1E1dGDTz$1ef66f57752432687528eeba878e73cc3d0c462110c34b6f69c0b8f599c66c3a', '2023-06-30 21:45:04');
-- --------------------------------------------------------
--
-- Table structure for table `alembic_version`
--
CREATE TABLE `alembic_version` (
`version_num` varchar(32) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `alembic_version`
--
INSERT INTO `alembic_version` (`version_num`) VALUES
('8b00a460f215');
-- --------------------------------------------------------
--
-- Table structure for table `classifications`
--
CREATE TABLE `classifications` (
`id` int(11) NOT NULL,
`username` varchar(128) DEFAULT NULL,
`password` varchar(128) DEFAULT NULL,
`ipaddress` varchar(128) DEFAULT NULL,
`time` datetime DEFAULT NULL,
`status` varchar(20) DEFAULT NULL,
`mode` int(11) DEFAULT NULL,
`attack` int(11) DEFAULT NULL,
`defence` int(11) DEFAULT NULL,
`type` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `classifications`
--
INSERT INTO `classifications` (`id`, `username`, `password`, `ipaddress`, `time`, `status`, `mode`, `attack`, `defence`, `type`) VALUES
(1, 'admin', 'ffgu', '197.211.58.200', '2023-07-10 06:45:42', '2', 0, 2, 2, 'Password Guessing'),
(2, 'admin', 'gdg', '197.211.58.200', '2023-07-10 07:00:19', '1', 0, 1, 1, 'Password Guessing'),
(3, '11', '1', '102.88.37.86', '2023-07-22 20:25:48', '2', 1, 2, 2, 'Password Guessing'),
(4, 'admin4', '144', '102.88.36.20', '2023-07-22 15:09:11', '2', 1, 1, 1, 'Password Guessing'),
(25, 'admin', '1662y', '129.205.124.156', '2023-07-11 18:48:26', '0', 1, 0, 0, NULL),
(28, 'test', '111111', '000000', '2023-07-13 12:51:25', '0', 1, 0, 0, NULL),
(29, 'MK20210206073', 'MK20210206073', '', '2023-07-24 14:05:13', '2', 1, 0, 0, NULL),
(30, 'MK20210206073', 'MK20210206073', '', '2023-07-24 14:05:13', '2', 1, 1, 1, 'Password Guessing'),
(31, 'MK20210206073', 'MK20210206073', '102.88.36.252', '2023-07-13 12:57:58', '0', 1, 0, 0, NULL),
(32, 'test', '111111', '000000', '2023-07-13 12:59:10', '1', 1, 1, 1, 'Password Guessing'),
(33, 'MK20210206073', 'MK20210206073', '102.88.36.252', '2023-07-13 13:13:03', '1', 1, 1, 1, 'Password Guessing'),
(34, 'adekola', '1222', '1243:5555:3', '2023-07-13 13:22:39', '0', 1, 0, 0, NULL),
(35, 'CS20200300927', 'cm20210100812', '102.88.36.207', '2023-07-14 21:40:24', '0', 1, 0, 0, NULL),
(36, 'CS20200300927', 'CS20200300927', '102.88.36.58', '2023-07-14 23:01:05', '0', 1, 0, 0, NULL),
(37, 'CS20200300927', 'CS20200300927', '102.88.36.58', '2023-07-14 23:01:27', '1', 1, 1, 1, 'Password Guessing'),
(38, 'HA20200205327', 'HA20200205327', '102.88.36.250', '2023-07-15 14:19:55', '0', 1, 0, 0, NULL),
(39, 'HA20200205327', 'HA20200205327', '102.88.36.250', '2023-07-15 14:20:14', '1', 1, 1, 1, 'Password Guessing'),
(40, 'yusroh', '122', '197.211.61.108', '2023-07-15 17:11:08', '0', 1, 0, 0, NULL),
(41, 'yusroh', '212', '197.211.61.108', '2023-07-15 17:11:16', '2', 1, 2, 2, 'Password Guessing'),
(45, '000webhost', 'adekola', '123:555:777', '2023-07-21 13:24:16', '2', 0, 2, 2, 'Password Guessing'),
(46, 'LT20190206764', 'LT20190206764', '102.89.23.97', '2023-07-21 13:56:25', '1', 0, 1, 1, 'Password Guessing'),
(48, 'CS20190206486', 'CS20190206486', '102.89.23.184', '2023-07-21 14:18:34', '2', 0, 2, 2, 'Password Guessing'),
(49, 'test', 'ade', '123:555:555', '2023-07-21 14:37:23', '2', 0, 2, 2, 'Password Guessing'),
(50, 'Bs20210100457', 'tggg', '102.89.41.195', '2023-07-25 13:36:12', '2', 0, 0, 2, 'Password Guessing'),
(51, 'academicaffairs', 'polytechnic', '102.89.32.46', '2023-07-29 22:01:31', '2', 0, 0, 2, 'Password Guessing'),
(52, 'academicaffairs', 'polytechnic', '102.89.33.109', '2023-07-29 22:11:27', '2', 0, 0, 2, 'Password Guessing'),
(53, 'Selim', '1', '197.211.58.191', '2023-08-05 18:17:28', '2', 0, 3, 2, 'Password Guessing');
-- --------------------------------------------------------
--
-- Table structure for table `comments`
--
CREATE TABLE `comments` (
`id` int(11) NOT NULL,
`content` varchar(4096) DEFAULT NULL,
`posted` datetime DEFAULT NULL,
`commenter_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `comments`
--
INSERT INTO `comments` (`id`, `content`, `posted`, `commenter_id`) VALUES
(1, 'Hi, there', '2023-07-01 05:00:05', 1);
-- --------------------------------------------------------
--
-- Table structure for table `logs`
--
CREATE TABLE `logs` (
`id` int(11) NOT NULL,
`username` varchar(128) DEFAULT NULL,
`password` varchar(128) DEFAULT NULL,
`ipaddress` varchar(128) DEFAULT NULL,
`time` datetime DEFAULT NULL,
`status` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `logs`
--
INSERT INTO `logs` (`id`, `username`, `password`, `ipaddress`, `time`, `status`) VALUES
(1, 'Selim', '1611', '197.211.58.200', '2023-07-10 06:45:08', '0'),
(2, 'admin', 'ffgu', '197.211.58.200', '2023-07-10 06:45:42', '1'),
(3, 'admin', 'gdg', '197.211.58.200', '2023-07-10 07:00:19', '1'),
(4, 'admin', 'sad', '197.211.58.200', '2023-07-10 07:01:43', '1'),
(5, 'admin', 'ewrew', '197.211.58.200', '2023-07-10 07:01:52', '1'),
(6, 'admin', 'aewew', '197.211.58.200', '2023-07-10 07:02:01', '1'),
(7, 'Selim ', '1611', '129.205.124.155', '2023-07-10 09:39:26', '0'),
(8, 'user', 'user', '102.88.37.180', '2023-07-10 20:35:06', '1'),
(9, 'www', 'wewe', '102.88.37.180', '2023-07-10 20:35:13', '1'),
(10, 'wewe', 'wewe', '102.88.37.180', '2023-07-10 20:35:17', '1'),
(11, 'wewew', 'wewe', '102.88.37.180', '2023-07-10 20:35:22', '1'),
(12, 'weewe', 'wewe', '102.88.37.180', '2023-07-10 20:35:28', '1'),
(13, 'wewew', 'weew', '102.88.37.180', '2023-07-10 20:35:34', '1'),
(14, 'aaaa', 'aaaa', '102.88.37.180', '2023-07-10 20:35:40', '1'),
(15, 'aaaa', 'aaa', '102.88.37.180', '2023-07-10 20:35:45', '1'),
(16, 'aaaa', 'aaa', '102.88.37.180', '2023-07-10 20:35:50', '1'),
(17, 'aaaa', 'aaaa', '102.88.37.180', '2023-07-10 20:35:57', '1'),
(18, 'aaaa', 'qwwqe', '102.88.36.184', '2023-07-10 20:41:01', '1'),
(19, '11', 'aa', '102.88.36.20', '2023-07-10 20:43:01', '1'),
(20, '11', '11', '102.88.36.20', '2023-07-10 20:43:06', '1'),
(21, '11', '1', '102.88.36.20', '2023-07-10 20:43:11', '1'),
(22, '11', '11', '102.88.36.20', '2023-07-10 20:43:17', '1'),
(23, '11', '1', '102.88.36.20', '2023-07-10 20:43:24', '1'),
(24, '11', '1', '102.88.36.20', '2023-07-10 20:43:33', '1'),
(25, '11', '1', '102.88.36.20', '2023-07-10 20:43:40', '1'),
(26, '11', '11', '102.88.36.20', '2023-07-10 20:43:50', '1'),
(27, '11', '1', '102.88.37.86', '2023-07-10 20:45:47', '1'),
(28, '11', '1', '102.88.37.86', '2023-07-10 20:45:53', '1'),
(29, '545', '14543', '102.88.36.20', '2023-07-10 22:13:01', '1'),
(30, 'admin4', '144', '102.88.36.20', '2023-07-10 22:13:09', '1'),
(31, 'admin', '1213', '197.211.61.103', '2023-07-11 07:43:19', '1'),
(32, 'admin', '1213', '197.211.61.103', '2023-07-11 07:50:09', '1'),
(33, 'admin', '1213', '197.211.61.103', '2023-07-11 08:00:27', '1'),
(34, 'admin', '1213', '197.211.61.103', '2023-07-11 08:02:38', '1'),
(35, 'admin', '1213', '197.211.61.103', '2023-07-11 08:05:06', '1'),
(36, 'admin', '1213', '197.211.61.103', '2023-07-11 08:12:34', '1'),
(37, 'admin', '1213', '197.211.61.103', '2023-07-11 08:13:43', '1'),
(38, 'admin', '1213', '197.211.61.103', '2023-07-11 08:19:00', '1'),
(39, 'admin', '1213', '197.211.61.103', '2023-07-11 08:20:23', '1'),
(40, 'admin', '1213', '197.211.61.103', '2023-07-11 08:21:41', '1'),
(41, 'admin', '223', '197.211.61.103', '2023-07-11 08:25:04', '1'),
(42, 'admin', '223', '197.211.61.103', '2023-07-11 08:26:52', '1'),
(43, 'admin', '223', '197.211.61.103', '2023-07-11 08:30:07', '1'),
(44, 'admin', '223', '197.211.61.103', '2023-07-11 08:31:23', '1'),
(45, 'yusroh', '21123', '197.211.61.103', '2023-07-11 08:34:02', '1'),
(46, 'yusroh', '1611', '197.211.61.103', '2023-07-11 08:39:54', '1'),
(47, 'yusroh', '1611', '197.211.61.103', '2023-07-11 08:40:03', '1'),
(48, 'yusroh', '1721727', '197.211.61.103', '2023-07-11 08:40:11', '1'),
(49, 'yusroh', '16216', '197.211.61.103', '2023-07-11 08:40:26', '1'),
(50, 'yusroh', '23', '197.211.61.103', '2023-07-11 08:40:32', '1'),
(51, 'yusroh', '21321', '197.211.61.103', '2023-07-11 08:40:37', '1'),
(52, 'yusroh', '2221', '197.211.61.103', '2023-07-11 08:40:44', '1'),
(53, 'yusroh', '212321', '197.211.61.103', '2023-07-11 08:40:49', '1'),
(54, 'yusroh', 'wqeq', '197.211.61.103', '2023-07-11 08:43:32', '1'),
(55, '[email protected]', '212', '197.211.61.103', '2023-07-11 08:46:32', '1'),
(56, 'root', '2131', '197.211.61.103', '2023-07-11 08:47:32', '1'),
(57, '[email protected]', '213', '197.211.61.103', '2023-07-11 08:49:36', '1'),
(58, 'admin', 'wqeqwe', '197.211.61.103', '2023-07-11 08:50:14', '1'),
(59, 'root', '16112', '197.211.61.103', '2023-07-11 08:56:21', '1'),
(60, 'selim', '232', '197.211.61.103', '2023-07-11 08:57:30', '1'),
(61, 'yusroh', 'ewqe', '197.211.61.103', '2023-07-11 08:57:36', '1'),
(62, '[email protected]', 'ewer', '197.211.61.103', '2023-07-11 08:57:43', '1'),
(63, 'admin', '1662y', '129.205.124.156', '2023-07-11 18:48:26', '1'),
(64, 'Selim', '1611', '129.205.124.156', '2023-07-11 18:48:38', '0'),
(71, 'adusat', 'sola', '123:555:555', '2023-07-13 11:25:16', '0'),
(167, 'RESULT_CHECKING', '', '', '2023-07-13 12:50:36', 'am here'),
(169, 'RESULT_CHECKING', '', '', '2023-07-13 12:51:58', '0'),
(170, 'MK20210206073', 'MK20210206073', '', '2023-07-13 12:55:19', '1'),
(171, 'MK20210206073', 'MK20210206073', '', '2023-07-13 12:57:43', '1'),
(172, 'MK20210206073', 'MK20210206073', '102.88.36.252', '2023-07-13 12:57:58', '1'),
(173, 'test', '111111', '000000', '2023-07-13 12:59:10', '1'),
(174, 'MK20210206073', 'MK20210206073', '102.88.36.252', '2023-07-13 13:13:03', '1'),
(175, 'adekola', '1222', '1243:5555:3', '2023-07-13 13:22:39', '1'),
(176, 'aaaa', '12sw', '00:00:00', '2023-07-14 13:29:14', '0'),
(177, 'aaaa', '12sw', '00:00:00', '2023-07-14 13:35:41', '0'),
(178, 'aaaa', '12sw', '00:00:00', '2023-07-14 13:36:10', '0'),
(179, 'aaaa', '12sw', '00:00:00', '2023-07-14 13:37:59', '0'),
(180, 'aaaa', '12sw', '00:00:00', '2023-07-14 13:39:15', '0'),
(181, 'aaaa', '12sw', '00:00:00', '2023-07-14 13:45:09', '0'),
(182, 'aaaa', '12sw', '00:00:00', '2023-07-14 13:48:02', '0'),
(183, 'aaaa', '12sw', '00:00:00', '2023-07-14 14:10:11', '0'),
(184, 'aaaa', '12sw', '00:00:00', '2023-07-14 14:14:26', '0'),
(185, 'aaaa', '12sw', '00:00:00', '2023-07-14 14:15:31', '0'),
(186, 'aaaa', '12sw', '00:00:00', '2023-07-14 14:16:23', '0'),
(187, 'aaaa', '12sw', '00:00:00', '2023-07-14 14:16:46', '0'),
(188, 'aaaa', '12sw', '00:00:00', '2023-07-14 14:31:33', '0'),
(189, 'aaaa', '12sw', '00:00:00', '2023-07-14 14:31:42', '0'),
(190, 'aaaa', '12sw', '00:00:00', '2023-07-14 14:33:42', '0'),
(191, 'aaaa', '12sw', '00:00:00', '2023-07-14 14:34:50', '0'),
(192, 'aaaa', '12sw', '00:00:00', '2023-07-14 14:35:16', '0'),
(193, 'aaaa', '12sw', '00:00:00', '2023-07-14 14:35:37', '0'),
(194, 'aaaa', '12sw', '00:00:00', '2023-07-14 14:36:15', '0'),
(195, 'aaaa', '12sw', '00:00:00', '2023-07-14 14:38:21', '0'),
(196, 'aaaa', '12sw', '00:00:00', '2023-07-14 14:41:44', '0'),
(197, 'aaaa', '12sw', '00:00:00', '2023-07-14 14:41:56', '0'),
(198, 'aaaa', '12sw', '00:00:00', '2023-07-14 14:50:35', '0'),
(199, 'aaaa', '12sw', '00:00:00', '2023-07-14 14:50:44', '0'),
(200, 'aaaa', '12sw', '00:00:00', '2023-07-14 14:51:32', '0'),
(201, 'aaaa', '12sw', '00:00:00', '2023-07-14 14:52:55', '0'),
(202, 'aaaa', '12sw', '00:00:00', '2023-07-14 14:56:32', '0'),
(203, 'aaaa', '12sw', '00:00:00', '2023-07-14 14:56:39', '0'),
(204, 'aaaa', '12sw', '00:00:00', '2023-07-14 14:57:35', '0'),
(205, 'aaaa', '12sw', '00:00:00', '2023-07-14 14:58:00', '0'),
(206, 'aaaa', '12sw', '00:00:00', '2023-07-14 14:58:33', '0'),
(207, 'aaaa', '12sw', '00:00:00', '2023-07-14 15:11:11', '0'),
(208, 'CS20200300927', 'cm20210100812', '102.88.36.207', '2023-07-14 21:40:24', '1'),
(209, 'CS20200300927', 'CS20200300927', '102.88.36.58', '2023-07-14 23:01:04', '1'),
(210, 'CS20200300927', 'CS20200300927', '102.88.36.58', '2023-07-14 23:01:27', '1'),
(211, 'test', 'adekola', '123:555:777', '2023-07-15 07:45:51', '0'),
(212, 'test', 'adekola', '123:555:777', '2023-07-15 07:50:32', '0'),
(213, 'test', 'adekola', '123:555:777', '2023-07-15 07:53:10', '0'),
(214, '1960001139', '1960001139', '102.88.36.172', '2023-07-15 14:01:07', ''),
(215, '1960001139', '1960001139', '102.88.37.89', '2023-07-15 14:01:49', ''),
(216, '1960001139', '1960001139', '102.88.37.89', '2023-07-15 14:02:30', ''),
(217, '1960001139', '1960001139', '102.88.36.250', '2023-07-15 14:03:04', ''),
(218, '1960001139', '1960001139', '102.88.36.250', '2023-07-15 14:04:30', ''),
(219, '1960001139', '1960001139', '102.88.37.89', '2023-07-15 14:09:28', ''),
(220, 'HA20200205327ewre', 'HA20200205327', '102.88.36.250', '2023-07-15 14:17:56', ''),
(221, 'HA20200205327ewre', 'HA20200205327', '102.88.36.250', '2023-07-15 14:19:27', '0'),
(222, 'HA20200205327', 'HA20200205327', '102.88.36.250', '2023-07-15 14:19:55', '1'),
(223, 'HA20200205327', 'HA20200205327', '102.88.36.250', '2023-07-15 14:20:14', '1'),
(224, 'test', 'adekola', '123:555:777', '2023-07-15 14:58:37', '0'),
(225, 'test', 'adekola', '123:555:777', '2023-07-15 17:09:04', '0'),
(226, 'test', 'adekola', '123:555:777', '2023-07-15 17:09:24', '0'),
(227, 'test', 'adekola', '123:555:777', '2023-07-15 17:09:28', '0'),
(228, 'test', 'adekola', '123:555:777', '2023-07-15 17:09:31', '0'),
(229, 'test', 'adekola', '123:555:777', '2023-07-15 17:09:33', '0'),
(230, 'test', 'adekola', '123:555:777', '2023-07-15 17:09:40', '0'),
(231, 'test', 'adekola', '123:555:777', '2023-07-15 17:09:41', '0'),
(232, 'test', 'adekola', '123:555:777', '2023-07-15 17:09:43', '0'),
(233, 'test', 'adekola', '123:555:777', '2023-07-15 17:09:45', '0'),
(234, 'test', 'adekola', '123:555:777', '2023-07-15 17:09:47', '0'),
(235, 'test', 'adekola', '123:555:777', '2023-07-15 17:10:05', '0'),
(236, 'test', 'adekola', '123:555:777', '2023-07-15 17:10:07', '0'),
(237, 'test', 'adekola', '123:555:777', '2023-07-15 17:10:09', '0'),
(238, 'yusroh', '122', '197.211.61.108', '2023-07-15 17:11:08', '1'),
(239, 'yusroh', '212', '197.211.61.108', '2023-07-15 17:11:16', '1'),
(240, 'test', 'adekola', '123:555:777', '2023-07-15 17:18:09', '1'),
(241, 'test', 'adekola', '123:555:777', '2023-07-15 17:18:15', '1'),
(242, 'test', 'adekola', '123:555:777', '2023-07-15 17:41:19', '1'),
(243, 'selim', '1611', '197.211.61.106', '2023-07-18 10:07:35', '0'),
(244, NULL, NULL, NULL, '2023-07-21 13:21:31', NULL),
(245, '2211800123', '09167969767', '102.89.23.67', '2023-07-21 13:21:45', '0'),
(246, '000webhost', 'adekola', '123:555:777', '2023-07-21 13:24:16', '1'),
(247, NULL, NULL, NULL, '2023-07-21 13:33:59', NULL),
(248, 'test', 'ade', '123:555:555', '2023-07-21 13:50:38', '0'),
(249, 'LT20190206764', 'LT20190206764', '102.89.23.97', '2023-07-21 13:56:25', '1'),
(250, 'LT20190206764', 'LT20190206764', '102.89.23.184', '2023-07-21 14:08:30', '1'),
(251, 'bursar', '@123456@', '102.89.22.53', '2023-07-21 14:11:33', '0'),
(252, 'bursar', '@123456@', '102.89.22.53', '2023-07-21 14:11:46', '0'),
(253, 'bursar', '@123456@', '102.89.22.53', '2023-07-21 14:11:52', '0'),
(254, 'bursar', '@123456@', '102.89.22.53', '2023-07-21 14:11:58', '0'),
(255, 'bursar', '@123456@', '102.89.22.53', '2023-07-21 14:12:03', '0'),
(256, 'bursar', '@123456@', '102.89.22.53', '2023-07-21 14:12:08', '0'),
(257, 'bursar', '@123456@', '102.89.22.53', '2023-07-21 14:12:14', '0'),
(258, 'bursar', '@123456@', '102.89.22.53', '2023-07-21 14:12:20', '0'),
(259, 'bursar', '@123456@', '102.89.22.53', '2023-07-21 14:12:27', '0'),
(260, 'oluoluolu', '1231233123', '102.89.23.200', '2023-07-21 14:17:48', '0'),
(261, 'CS20190206486', 'CS20190206486', '102.89.23.184', '2023-07-21 14:18:34', '1'),
(262, 'test', 'ade', '123:555:555', '2023-07-21 14:28:16', '0'),
(263, 'test', 'ade', '123:555:555', '2023-07-21 14:31:57', '0'),
(264, 'test', 'ade', '123:555:555', '2023-07-21 14:32:18', '0'),
(265, 'test', 'ade', '123:555:555', '2023-07-21 14:32:21', '0'),
(266, 'test', 'ade', '123:555:555', '2023-07-21 14:33:37', '0'),
(267, '000webhost', 'adekola', '123:555:777', '2023-07-21 14:35:25', '1'),
(268, '000webhost', 'adekola', '123:555:777', '2023-07-21 14:35:30', '1'),
(269, 'test', 'ade', '123:555:555', '2023-07-21 14:35:53', '0'),
(270, 'test', 'ade', '123:555:555', '2023-07-21 14:36:21', '0'),
(271, 'test', 'ade', '123:555:555', '2023-07-21 14:37:23', '0'),
(272, 'CS20190206486', 'CS20190206486', '102.89.23.127', '2023-07-21 14:37:51', '1'),
(273, NULL, NULL, NULL, '2023-07-22 14:18:54', NULL),
(274, 'Bs20210100457', 'tggg', '102.89.41.195', '2023-07-25 13:36:12', '0'),
(275, 'academicaffairs', 'polytechnic', '102.89.32.46', '2023-07-29 22:01:31', '0'),
(276, 'academicaffairs', 'polytechnic', '102.89.33.109', '2023-07-29 22:11:27', '0'),
(277, 'Selim', '1', '197.211.58.191', '2023-08-05 18:17:28', '1'),
(278, 'selim', '11', '127.0.0.1', '2023-08-11 18:59:41', '1'),
(279, 'salim', '1', '127.0.0.1', '2023-08-11 19:02:45', '1'),
(280, 'salim', '1', '127.0.0.1', '2023-08-11 19:22:34', '1'),
(281, 'salim', '1', '127.0.0.1', '2023-08-11 19:27:13', '1'),
(282, 'salim', '1', '127.0.0.1', '2023-08-11 19:29:36', '1'),
(283, 'salim', '1', '127.0.0.1', '2023-08-11 19:31:22', '1'),
(284, 'salim', '1', '127.0.0.1', '2023-08-11 19:31:24', '1'),
(285, 'salim', '1', '127.0.0.1', '2023-08-11 19:31:50', '1'),
(286, 'salim', '1', '127.0.0.1', '2023-08-11 19:36:08', '1'),
(287, 'salim', '1', '127.0.0.1', '2023-08-11 19:36:55', '1'),
(288, 'salim', '1', '127.0.0.1', '2023-08-11 19:38:14', '1'),
(289, 'salim', '1', '127.0.0.1', '2023-08-11 19:46:33', '1'),
(290, 'salim', '1', '127.0.0.1', '2023-08-11 19:46:35', '1'),
(291, 'salim', '1', '127.0.0.1', '2023-08-11 19:48:35', '1'),
(292, 'salim', '1611', '127.0.0.1', '2023-08-11 19:48:56', '1'),
(293, 'salim', '1111', '127.0.0.1', '2023-08-11 19:49:14', '1'),
(294, 'salim', '1', '127.0.0.1', '2023-08-11 19:49:20', '1'),
(295, 'salim', '1234', '127.0.0.1', '2023-08-11 19:49:32', '1'),
(296, 'salim', '1234', '127.0.0.1', '2023-08-11 19:49:40', '1'),
(297, 'salim', '1', '127.0.0.1', '2023-08-11 19:49:46', '1'),
(298, 'selim', '1', '127.0.0.1', '2023-08-11 19:51:30', '1'),
(299, 'Selim', '1', '127.0.0.1', '2023-08-11 19:51:37', '1'),
(300, 'selim', '1234', '127.0.0.1', '2023-08-11 19:51:52', '1'),
(301, 'selim', '1111', '127.0.0.1', '2023-08-11 19:52:03', '1'),
(302, 'Selim', '1234', '127.0.0.1', '2023-08-11 19:52:16', '1'),
(303, 'Selim', '1611', '127.0.0.1', '2023-08-11 19:52:28', '0'),
(304, 'salim', '1611', '127.0.0.1', '2023-08-14 18:18:35', '1'),
(305, 'salim', '1611', '127.0.0.1', '2023-08-14 18:18:42', '1'),
(306, 'salim', '1611', '127.0.0.1', '2023-08-14 18:18:48', '1'),
(307, 'salim', '111', '127.0.0.1', '2023-08-14 18:18:54', '1'),
(308, 'salim', '1611', '127.0.0.1', '2023-08-14 18:19:00', '1'),
(309, 'salim', '1611', '127.0.0.1', '2023-08-14 18:19:05', '1'),
(310, 'salim', '1611', '127.0.0.1', '2023-08-14 18:19:12', '1'),
(311, 'salim', '1611', '127.0.0.1', '2023-08-14 18:19:18', '1'),
(312, 'selim', '1611', '127.0.0.1', '2023-08-14 18:19:56', '0'),
(313, 'salim', '1611', '127.0.0.1', '2023-08-14 18:20:10', '1'),
(314, 'salim', '1611', '127.0.0.1', '2023-08-14 18:20:17', '1'),
(315, 'salim', '1611', '127.0.0.1', '2023-08-14 18:20:21', '1'),
(316, 'salim', '1611', '127.0.0.1', '2023-08-14 18:20:27', '1'),
(317, 'selim', '11', '127.0.0.1', '2023-08-14 18:20:33', '1'),
(318, 'salim', '1611', '127.0.0.1', '2023-08-14 18:20:38', '1'),
(319, 'salim', '1y1y2', '127.0.0.1', '2023-08-14 18:20:47', '1'),
(320, 'salim', '1', '127.0.0.1', '2023-08-14 18:36:35', '1'),
(321, 'salim', '1', '127.0.0.1', '2023-08-14 20:37:02', '1'),
(322, 'salim', '1', '127.0.0.1', '2023-08-14 20:39:52', '1'),
(323, 'selim', '1611', '127.0.0.1', '2023-08-14 20:41:37', '0'),
(324, 'salim', '1', '127.0.0.1', '2023-08-14 20:42:05', '1'),
(325, '', '', '127.0.0.1', '2023-08-14 20:44:34', '1'),
(326, 'salim', '1', '127.0.0.1', '2023-08-14 20:52:30', '1'),
(327, 'salim', '1', '127.0.0.1', '2023-08-14 21:04:36', '1'),
(328, 'salim', '1', '127.0.0.1', '2023-08-14 21:04:42', '1'),
(329, 'salim', '1', '127.0.0.1', '2023-08-14 21:06:11', '1'),
(330, 'salim', '1', '127.0.0.1', '2023-08-14 21:08:17', '1'),
(331, 'salim', '1', '127.0.0.1', '2023-08-14 21:11:19', '1'),
(332, 'salim', '1', '127.0.0.1', '2023-08-14 21:12:08', '1'),
(333, 'salim', '1', '127.0.0.1', '2023-08-14 21:13:20', '1'),
(334, 'salim', '1', '127.0.0.1', '2023-08-14 21:18:28', '1'),
(335, 'salim', '1', '127.0.0.1', '2023-08-14 21:26:50', '1'),
(336, 'salim', '1', '127.0.0.1', '2023-08-14 21:26:59', '1');
-- --------------------------------------------------------
--
-- Table structure for table `questions`
--
CREATE TABLE `questions` (
`id` int(11) NOT NULL,
`question` varchar(128) DEFAULT NULL,
`date` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `questions`
--
INSERT INTO `questions` (`id`, `question`, `date`) VALUES
(6, 'contact', '2023-07-08 10:31:48'),
(9, 'email', '2023-07-10 22:17:52');
-- --------------------------------------------------------
--
-- Table structure for table `settings`
--
CREATE TABLE `settings` (
`id` int(11) NOT NULL,
`noOfAttemptFailed` int(11) DEFAULT NULL,
`timeInterval` int(11) DEFAULT NULL,
`modeOfPlay` int(11) DEFAULT NULL,
`reportTime` varchar(128) DEFAULT NULL,
`emailResponse` varchar(128) DEFAULT NULL,
`date` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `settings`
--
INSERT INTO `settings` (`id`, `noOfAttemptFailed`, `timeInterval`, `modeOfPlay`, `reportTime`, `emailResponse`, `date`) VALUES
(1, 5, 10, 1, '1', '[email protected]', '2023-07-01 07:54:51');
-- --------------------------------------------------------
--
-- Table structure for table `transactions`
--
CREATE TABLE `transactions` (
`id` int(11) NOT NULL,
`username` varchar(128) DEFAULT NULL,
`password` varchar(128) DEFAULT NULL,
`ipaddress` varchar(128) DEFAULT NULL,
`time` datetime DEFAULT NULL,
`status` varchar(20) DEFAULT NULL,
`mode` int(11) DEFAULT NULL,
`attack` int(11) DEFAULT NULL,
`defence` int(11) DEFAULT NULL,
`type` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `transactions`
--
INSERT INTO `transactions` (`id`, `username`, `password`, `ipaddress`, `time`, `status`, `mode`, `attack`, `defence`, `type`) VALUES
(3, '11', '1', '102.88.37.86', '2023-07-22 20:25:48', '2', 1, 2, 2, 'Password Guessing'),
(4, 'admin4', '144', '102.88.36.20', '2023-07-22 15:09:11', '2', 1, 1, 1, 'Password Guessing'),
(13, 'MK20210206073', 'MK20210206073', '', '2023-07-24 14:05:13', '2', 1, 1, 1, 'Password Guessing'),
(14, 'test', '111111', '000000', '2023-07-13 12:59:10', '1', 1, 1, 1, 'Password Guessing'),
(15, 'MK20210206073', 'MK20210206073', '102.88.36.252', '2023-07-13 13:13:03', '1', 1, 1, 1, 'Password Guessing'),
(16, 'CS20200300927', 'CS20200300927', '102.88.36.58', '2023-07-14 23:01:27', '1', 1, 1, 1, 'Password Guessing'),
(17, 'HA20200205327', 'HA20200205327', '102.88.36.250', '2023-07-15 14:20:14', '1', 1, 1, 1, 'Password Guessing'),
(18, 'yusroh', '212', '197.211.61.108', '2023-07-15 17:11:16', '2', 1, 2, 2, 'Password Guessing'),
(21, '000webhost', 'adekola', '123:555:777', '2023-07-21 13:24:16', '2', 0, 2, 2, 'Password Guessing'),
(22, 'LT20190206764', 'LT20190206764', '102.89.23.97', '2023-07-21 13:56:25', '1', 0, 1, 1, 'Password Guessing'),
(24, 'CS20190206486', 'CS20190206486', '102.89.23.184', '2023-07-21 14:18:34', '2', 0, 2, 2, 'Password Guessing'),
(25, 'test', 'ade', '123:555:555', '2023-07-21 14:37:23', '2', 0, 2, 2, 'Password Guessing'),
(26, 'Bs20210100457', 'tggg', '102.89.41.195', '2023-07-25 13:36:12', '2', 0, 0, 2, 'Password Guessing'),
(27, 'academicaffairs', 'polytechnic', '102.89.32.46', '2023-07-29 22:01:31', '2', 0, 0, 2, 'Password Guessing'),
(28, 'academicaffairs', 'polytechnic', '102.89.33.109', '2023-07-29 22:11:27', '2', 0, 0, 2, 'Password Guessing'),
(29, 'Selim', '1', '197.211.58.191', '2023-08-05 18:17:28', '2', 0, 3, 2, 'Password Guessing'),
(30, 'salim', '1', '127.0.0.1', '2023-08-14 21:26:35', '0', 0, 1, 1, 'Password Guessing');
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE `users` (
`id` int(11) NOT NULL,
`username` varchar(128) DEFAULT NULL,
`contact` varchar(128) DEFAULT NULL,
`email` varchar(128) DEFAULT NULL,
`password` varchar(128) DEFAULT NULL,
`status` varchar(128) DEFAULT NULL,
`date` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `users`
--
INSERT INTO `users` (`id`, `username`, `contact`, `email`, `password`, `status`, `date`) VALUES
(1, 'Selim', '08076738293', '[email protected]', 'pbkdf2:sha256:260000$WgEPPV4AmfObs5Zm$6be3efeabeb5a398cb5f47427b8f2dd03a2554173ac3e7fd974759dbfee9b172', '0', '2023-06-29 10:41:11');
--
-- Indexes for dumped tables
--
--
-- Indexes for table `admins`
--
ALTER TABLE `admins`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `alembic_version`
--
ALTER TABLE `alembic_version`
ADD PRIMARY KEY (`version_num`);
--
-- Indexes for table `classifications`
--
ALTER TABLE `classifications`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `comments`
--
ALTER TABLE `comments`
ADD PRIMARY KEY (`id`),
ADD KEY `commenter_id` (`commenter_id`);
--
-- Indexes for table `logs`
--
ALTER TABLE `logs`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `questions`
--
ALTER TABLE `questions`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `transactions`
--
ALTER TABLE `transactions`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `users`
--
ALTER TABLE `users`
ADD PRIMARY KEY (`id`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `admins`
--
ALTER TABLE `admins`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `classifications`
--
ALTER TABLE `classifications`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=96;
--
-- AUTO_INCREMENT for table `comments`
--
ALTER TABLE `comments`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `logs`
--
ALTER TABLE `logs`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=337;
--
-- AUTO_INCREMENT for table `questions`
--
ALTER TABLE `questions`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `transactions`
--
ALTER TABLE `transactions`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;
--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- Constraints for dumped tables
--
--
-- Constraints for table `comments`
--
ALTER TABLE `comments`
ADD CONSTRAINT `comments_ibfk_1` FOREIGN KEY (`commenter_id`) REFERENCES `users` (`id`);
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 */;