phplogin.sql

-- phpMyAdmin SQL Dump
-- version 5.1.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jan 03, 2022 at 05:00 AM
-- Server version: 10.4.22-MariaDB
-- PHP Version: 8.1.1

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

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

--
-- Table structure for table `accounts`
--

CREATE TABLE `accounts` (
  `id` int(11) NOT NULL,
  `username` varchar(50) NOT NULL,
  `password` varchar(255) NOT NULL,
  `email` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `accounts`
--

INSERT INTO `accounts` (`id`, `username`, `password`, `email`) VALUES
(1, 'test', '$2y$10$SfhYIDtn.iOuCW7zfoFLuuZHX6lja4lF4XA4JqNmpiH/.P3zB8JCa', 'test@test.com');

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

--
-- Table structure for table `logs`
--

CREATE TABLE `logs` (
  `id` int(11) NOT NULL,
  `airframe` varchar(50) NOT NULL,
  `engineer` varchar(50) NOT NULL,
  `fhr` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `logs`
--

INSERT INTO `logs` (`id`, `airframe`, `engineer`, `fhr`) VALUES
(1, '1', 'e1', '100'),
(2, 'Airframe 6', 'Avionic Engineer', '600 - 700');

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

--
-- Table structure for table `logs1`
--

CREATE TABLE `logs1` (
  `id` int(11) NOT NULL,
  `fhr1` varchar(50) NOT NULL,
  `mt1` varchar(255) NOT NULL,
  `eng1` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `logs1`
--

INSERT INTO `logs1` (`id`, `fhr1`, `mt1`, `eng1`) VALUES
(1, '400 - 600 Hours', '05/01/2022 : 12 PM - 6 PM', 'Aeronautical Engineer');

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

--
-- Table structure for table `logs2`
--

CREATE TABLE `logs2` (
  `id` int(11) NOT NULL,
  `fhr2` varchar(50) NOT NULL,
  `mt2` varchar(255) NOT NULL,
  `eng2` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `logs2`
--

INSERT INTO `logs2` (`id`, `fhr2`, `mt2`, `eng2`) VALUES
(1, '400 - 600 Hours', '06/01/2022 : 12 PM - 6 PM', 'Aeronautical Engineer');

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

--
-- Table structure for table `logs3`
--

CREATE TABLE `logs3` (
  `id` int(11) NOT NULL,
  `fhr3` varchar(50) NOT NULL,
  `mt3` varchar(255) NOT NULL,
  `eng3` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `logs3`
--

INSERT INTO `logs3` (`id`, `fhr3`, `mt3`, `eng3`) VALUES
(1, '600 - 700 Hours', '06/01/2022 : 12 PM - 8 PM', 'Mechanical Engineer');

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

--
-- Table structure for table `logs4`
--

CREATE TABLE `logs4` (
  `id` int(11) NOT NULL,
  `fhr4` varchar(50) NOT NULL,
  `mt4` varchar(255) NOT NULL,
  `eng4` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `logs4`
--

INSERT INTO `logs4` (`id`, `fhr4`, `mt4`, `eng4`) VALUES
(1, '700 - 800 Hours', '07/01/2022 : 12 PM - 8 PM', 'Mechanical & Aerospace Engineer');

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

--
-- Table structure for table `logs5`
--

CREATE TABLE `logs5` (
  `id` int(11) NOT NULL,
  `fhr5` varchar(50) NOT NULL,
  `mt5` varchar(255) NOT NULL,
  `eng5` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `logs5`
--

INSERT INTO `logs5` (`id`, `fhr5`, `mt5`, `eng5`) VALUES
(1, '750 - 900 Hours', '07/01/2022 : 12 PM - 8 PM', 'Avionic & Aerospace Engineer');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `accounts`
--
ALTER TABLE `accounts`
  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=3;

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

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

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

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

--
-- AUTO_INCREMENT for table `logs5`
--
ALTER TABLE `logs5`
  MODIFY `id` int(11) 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 */;