-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Feb 23, 2024 at 08:58 AM
-- Server version: 10.6.17-MariaDB
-- PHP Version: 8.1.27

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

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

--
-- Table structure for table `lphone`
--

CREATE TABLE `lphone` (
  `imei` varchar(80) NOT NULL,
  `userid` varchar(80) NOT NULL,
  `lripoti` varchar(255) NOT NULL,
  `regDate` date NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `lphone`
--

INSERT INTO `lphone` (`imei`, `userid`, `lripoti`, `regDate`) VALUES
('1234567890987654321', '20230412033238', 'images/AAA22.pdf', '2023-04-05'),
('2134567890987654312', '20230412033238', 'images/AAA.pdf', '2023-04-07'),
('9876543210123456789', '20230412033238', 'images/kiapo.pdf', '2023-05-17');

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

--
-- Table structure for table `phone`
--

CREATE TABLE `phone` (
  `userid` varchar(80) NOT NULL,
  `imei` varchar(80) NOT NULL,
  `ilini` int(11) NOT NULL,
  `ptype` varchar(255) NOT NULL,
  `regDate` date NOT NULL,
  `lineone` varchar(80) NOT NULL,
  `Status` varchar(200) NOT NULL DEFAULT 'Inamilikiwa'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `phone`
--

INSERT INTO `phone` (`userid`, `imei`, `ilini`, `ptype`, `regDate`, `lineone`, `Status`) VALUES
('20230412033238', '1234567890987654321', 0, 'Nokia 3.4', '2023-04-13', '0758912113', 'Imepotea'),
('20230412033238', '2134567890987654312', 0, 'Tacno spark2', '2023-04-13', '0689749960', 'Imepotea'),
('20230412033238', '9876543210123456789', 0, 'iPhone 11', '2023-04-13', '0689749960', 'Imepotea'),
('20230412033238', '43535467578-66464559009', 2, 'iPhone X', '2023-04-30', '0768578979', 'Inamilikiwa'),
('20230412033238', '342445353563-', 1, 'iphone 8 plus', '2023-05-17', '0689749960', 'Inamilikiwa');

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `fname` varchar(80) NOT NULL,
  `lname` varchar(80) NOT NULL,
  `phoneno` varchar(80) NOT NULL,
  `email` varchar(123) NOT NULL,
  `regDate` datetime NOT NULL DEFAULT current_timestamp(),
  `userid` varchar(25) NOT NULL,
  `password` varchar(80) NOT NULL,
  `lastLogin` date NOT NULL,
  `lastlogTime` time NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`fname`, `lname`, `phoneno`, `email`, `regDate`, `userid`, `password`, `lastLogin`, `lastlogTime`) VALUES
('Hassan', 'Jeremiah', '0758912113', 'hjeremiah24@gmail.com', '2023-04-12 06:32:38', '20230412033238', 'jere1717', '2023-05-17', '12:49:18');

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

--
-- Table structure for table `userss`
--

CREATE TABLE `userss` (
  `fname` varchar(80) NOT NULL,
  `lname` varchar(80) NOT NULL,
  `phoneno` varchar(15) NOT NULL,
  `email` varchar(185) NOT NULL,
  `regDate` datetime NOT NULL DEFAULT current_timestamp(),
  `userid` varchar(80) NOT NULL,
  `password` varchar(80) NOT NULL,
  `lostlogTime` time NOT NULL,
  `lastLogin` date NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
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 */;
