-- phpMyAdmin SQL Dump
-- version 5.0.2
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jun 16, 2022 at 04:07 PM
-- Server version: 10.4.11-MariaDB
-- PHP Version: 7.4.5

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

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

--
-- Table structure for table `engineer`
--

CREATE TABLE `engineer` (
  `engineer_id` int(100) NOT NULL,
  `engineer_name` varchar(255) NOT NULL,
  `passcode` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `engineer`
--

INSERT INTO `engineer` (`engineer_id`, `engineer_name`, `passcode`) VALUES
(1, 'abdul', '6516'),
(2, 'rehman bhai', '1234');

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

--
-- Table structure for table `equipment`
--

CREATE TABLE `equipment` (
  `equipment_id` int(100) NOT NULL,
  `record_id` int(100) NOT NULL,
  `title` varchar(255) NOT NULL,
  `location` varchar(255) NOT NULL,
  `equipment_type` varchar(255) NOT NULL,
  `equipment_description` varchar(255) NOT NULL,
  `notes` varchar(255) NOT NULL,
  `service_interval` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `equipment`
--

INSERT INTO `equipment` (`equipment_id`, `record_id`, `title`, `location`, `equipment_type`, `equipment_description`, `notes`, `service_interval`, `image`) VALUES
(1, 123, 'hh', 'll', 'et', 'ed', 'n', '6', '0'),
(2, 14, 'hello', 'L', 'Ety', 'EDN', 'NS', '6', ''),
(3, 545, 'DFJK', 'FSHDJ', 'FHDJ', 'HJ', 'HFJ', '3', ''),
(4, 45, 'df', 'fsr', 'fs', 's', 'fs', '6', ''),
(5, 11, '455', 'jk', 'n', ',mn,', 'h', '6', ''),
(6, 4566, 'jkjk', '', 'hjgh', 'ghf', 'v', '6', ''),
(7, 21654, 'jkl', 'gjh', 'gj', 'bn', 'bmnvb', '6', ''),
(8, 45646643, 'kgj', 'm', 'm', 'gj', 'gjvj', '6', ''),
(9, 15645, 'hfkjahkj', 'fkjhk', 'fajkeh', 'khakjk', 'jhkjqkh', '6', ''),
(10, 6546535, '1', 'klh', 'kjh', 'kjkj', 'hjk', '6', '14-145502_linkedin-color-icon-linkedin-logo-round-png.png'),
(11, 1316546, 'hjkk', 'kjh', 'kh', 'kjjh', 'jh', '6', 'png-clipart-satisfaction-guarantee-100-logo-money-back-guarantee-customer-service-technical-support-guarantee-s-label-text.png'),
(12, 32246, 'HJKH', 'K', 'JHJH', 'JH', 'BNM', '6', 'youtube video SEO specialist.jpg'),
(13, 16546123, 'hj', 'nm', 'h', 'ghkj', 'fggj', '6', 'youtube video SEO specialist.jpg'),
(14, 98, 'testing title', 'testing location', 'eq test', 'ed test', 'no test', '6', 'develop-a-website-using-php-and-mysql-database(4).jpg'),
(15, 0, '', '', '', '', 'test not', '6', '');

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

--
-- Table structure for table `log`
--

CREATE TABLE `log` (
  `log_id` int(100) NOT NULL,
  `equipment_id` int(100) NOT NULL,
  `type` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `notes` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `next_service` varchar(255) NOT NULL,
  `completed_by` varchar(255) NOT NULL,
  `message` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `log`
--

INSERT INTO `log` (`log_id`, `equipment_id`, `type`, `date`, `description`, `notes`, `image`, `next_service`, `completed_by`, `message`) VALUES
(1, 2, 'report', '30/5/2022', 'testing description', 'testing_notes', 'youtube video SEO specialist.jpg', 'testing service', 'test', ''),
(2, 14, 'report', '2022-05-27', 'td', 'tn', 'GUARANTEED.png', '2023-05-27', 'tcb', ''),
(3, 2, 'report', '2022-05-28', 'tdd', 'tnn', 'download (1).png', '2023-05-28', 'tccbb', ''),
(4, 0, 'report', '2022-05-24', 'this is testing des', 'this is test notes', '11.jpg', '2023-05-24', 'it is complete', ''),
(5, 2, 'report', '2022-06-02', 'sdf', 'fgdh', '6.jpg', '2023-06-02', 'jkjh', ''),
(6, 3, 'report', '2022-05-21', 'ui', 'op', 'images (2).jpg', '2023-05-21', 'yu', ''),
(7, 3, 'report', '2022-05-26', 'qw', 'we', 'download (5).jpg', '', 'er', ''),
(8, 3, 'report', '2022-05-17', 'sa', 'sd', 'download (9).jpg', '', 'df', ''),
(9, 3, 'report', '2022-05-04', 'as', 'vc', 'images (7).jpg', '', 'gf', ''),
(10, 3, 'repair', '2022-05-09', 'we', 'er', 'images (2).jpg', '', 'ty', ''),
(11, 3, 'service', '2022-05-28', 'io', 'ui', '10.jpg', '2023-05-28', 'yu', ''),
(12, 6, 'report', '2022-05-12', 'this is testing description', 'this is testing notes', 'images (3).jpg', '', 'it is completed by me', ''),
(13, 6, 'service', '2022-05-22', 'i added testing description', 'it is just testing notes', 'download.jpg', '2023-05-22', 'this is completed by me', ''),
(14, 6, 'repair', '2022-05-13', 'testing repair description', 'testing notes just for checking', 'download (6).jpg', '', 'it is completed by someone else', ''),
(15, 2, 'repair', '2022-05-05', 'td', 'HFJ', '1.jpg', '', 'it is complete', ''),
(16, 2, 'report', '2022-06-10', 'td', 'v', 'images (4).jpg', '', 'me', ''),
(17, 2, 'report', '2022-06-21', 'dad', 'das', 'download (7).jpg', '', 'gf', ''),
(18, 2, 'report', '2022-06-16', 'test des', 'n', 'images.jpg', '', 'tccbb', ''),
(19, 2, 'report', '2022-06-16', 'test des', 'n', 'images.jpg', '', 'tccbb', ''),
(20, 2, 'report', '2022-06-21', 'testing description', 'testing notes', 'images (2).jpg', '', 'testing completed by', ''),
(21, 2, 'repair', '2022-06-22', 'td', 'da', 'download (8).jpg', '', 'dfsf', ''),
(22, 2, 'repair', '2022-06-23', 'asdasd', 'qweqw', '4.png', '', 'czxczxc', ''),
(23, 2, 'report', '2022-06-24', 'ted', 'ten', 'images (3).jpg', '', 'tecb', ''),
(24, 2, 'repair', '2022-06-21', 'babo', 'v', 'images.jpg', '', 'gf', ''),
(25, 2, 'repair', '2022-06-21', 'babo', 'v', 'images.jpg', '', 'gf', ''),
(26, 2, 'service', '2022-06-25', 'des', 'not', '10.jpg', '2022-12-25', 'cb', ''),
(27, 3, 'service', '2022-06-25', 'testing d', 'test n', 'download (3).jpg', '2022-09-25', 'tes cb', ''),
(28, 2, 'repair', '2022-06-08', 'tst', 'test', 'download (7).jpg', '', 'testing', ''),
(29, 2, 'repair', '2022-06-08', 'tst', 'test', 'download (7).jpg', '', 'testing', ''),
(30, 2, 'repair', '2022-06-22', 'ygjh', 'fg', 'images.jpg', '', 'fhgfg', ''),
(31, 2, 'repair', '2022-06-17', 'gjh', 'gfg', 'download (8).jpg', '', 'nvn', ''),
(32, 2, 'repair', '2022-06-24', 'd', 'fsd', 'images (5).jpg', '', 'fds', ''),
(33, 3, 'repair', '2022-06-15', 'ds', 'sd', 'images (3).jpg', '', 'fd', ''),
(34, 3, 'repair', '2022-06-18', 'sf', 'fdf', 'images (3).jpg', '', 'fsdf', ''),
(35, 3, 'repair', '2022-06-17', 'this is just a testing description', 'testing notes', 'images (1).jpg', '', 'testing completed by', ''),
(36, 3, 'repair', '2022-06-23', 'fs', 'fds', 'images (4).jpg', '', 'fd', ''),
(37, 3, 'repair', '2022-06-22', 'sdsa', 'da', 'images (8).jpg', '', 'sfdfs', ''),
(38, 2, 'repair', '2022-06-03', 'dsad', 'v', 'images (8).jpg', '', 'testing completed by', ''),
(39, 2, 'service', '2022-06-03', 'io', 'jkk', 'istockphoto-974238866-612x612.jpg', '2022-12-03', 'bm', ''),
(40, 2, 'service', '2022-06-03', 'io', 'jkk', 'istockphoto-974238866-612x612.jpg', '2022-12-03', 'bm', ''),
(41, 2, 'service', '2022-06-03', 'io', 'jkk', 'istockphoto-974238866-612x612.jpg', '2022-12-03', 'bm', ''),
(42, 2, 'report', '2022-06-15', 'babo', 'czx', 'images (6).jpg', '', 'vxv', 'this is testing email');

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

--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `user_id` int(100) NOT NULL,
  `email` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `user_type` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `user`
--

INSERT INTO `user` (`user_id`, `email`, `password`, `user_type`) VALUES
(1, 'admin@gmail.com', '123', 'admin');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `engineer`
--
ALTER TABLE `engineer`
  ADD PRIMARY KEY (`engineer_id`);

--
-- Indexes for table `equipment`
--
ALTER TABLE `equipment`
  ADD PRIMARY KEY (`equipment_id`);

--
-- Indexes for table `log`
--
ALTER TABLE `log`
  ADD PRIMARY KEY (`log_id`);

--
-- Indexes for table `user`
--
ALTER TABLE `user`
  ADD PRIMARY KEY (`user_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `engineer`
--
ALTER TABLE `engineer`
  MODIFY `engineer_id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `equipment`
--
ALTER TABLE `equipment`
  MODIFY `equipment_id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `log`
--
ALTER TABLE `log`
  MODIFY `log_id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=43;

--
-- AUTO_INCREMENT for table `user`
--
ALTER TABLE `user`
  MODIFY `user_id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
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 */;
