-- phpMyAdmin SQL Dump
-- version 5.1.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Apr 22, 2022 at 04:24 PM
-- Server version: 10.4.20-MariaDB
-- PHP Version: 7.3.29

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

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

--
-- Table structure for table `helicopter_item`
--

CREATE TABLE `helicopter_item` (
  `id` int(11) NOT NULL,
  `item_name` varchar(100) NOT NULL,
  `item_desc` varchar(600) NOT NULL,
  `item_image` varchar(300) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `helicopter_item`
--

INSERT INTO `helicopter_item` (`id`, `item_name`, `item_desc`, `item_image`) VALUES
(1, 'Bell 206', 'Bell 206: The Bell 206 is a family of two-bladed, single- and twin-engined helicopters, manufactured by Bell Helicopter at its Mirabel, Quebec, plant.', 'https://i.picsum.photos/id/24/300/200.jpg?hmac=rFnVuhzWI4p2XnILFP457L9swCydQVDhy41H1YHy7sY'),
(2, 'Bell OH-58 Kiowa', 'Bell OH-58 Kiowa: The Bell OH-58 Kiowa is a family of single-engine, single-rotor, military helicopters used for observation, utility, and direct fire support. ', 'https://i.picsum.photos/id/1050/300/300.jpg?hmac=MzZ6NnFKMcvQmvsR62WBLnw-iQOV0kl7STcTcizUGrw'),
(3, 'Lockheed AH-56 Cheyenne', 'Lockheed AH-56 Cheyenne: The Lockheed AH-56 Cheyenne was an attack helicopter developed by Lockheed for the United States Army. It rose from the Army\'s Advanced Aerial Fire Support System (AAFSS) program to field the service\'s first dedicated attack helicopter.', 'https://i.picsum.photos/id/919/300/200.jpg?hmac=K_Gj_rFLdlNccZlZmHNxUdGfeky4_uZMR2c8-x264xo'),
(4, 'Sikorsky UH-60 Black Hawk', 'Sikorsky UH-60 Black Hawk: The Sikorsky UH-60 Black Hawk is a four-blade, twin-engine, medium-lift utility military helicopter manufactured by Sikorsky Aircraft. ', 'https://i.picsum.photos/id/809/300/300.jpg?hmac=pY1ro5QXv8h9gdbuiv88ST_iF7fx5Zxlq0-Tyrh-2Y0');

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

--
-- Table structure for table `outdoor_item`
--

CREATE TABLE `outdoor_item` (
  `id` int(11) NOT NULL,
  `item_name` varchar(100) NOT NULL,
  `item_desc` varchar(600) NOT NULL,
  `item_image` varchar(300) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `outdoor_item`
--

INSERT INTO `outdoor_item` (`id`, `item_name`, `item_desc`, `item_image`) VALUES
(1, 'Eat outside ', 'Eat Outside: It is great to eat outside occasionally. It connects you with community and friends and impact your life in a positive way.', 'https://i.picsum.photos/id/723/300/200.jpg?hmac=r-Bu4Me1tZJW3ncPjx4Pj2nhJ2sV0XQhDEeM1kH9EyY'),
(2, 'Take a hike', 'Take a hike: Taking a hike is good for health. It makes you physically and mentally healthy. You also get to enjoy outdoors.', 'https://i.picsum.photos/id/866/300/200.jpg?hmac=vwkhhp_0HQtgJfxWytDiH1t2GX4YyYyWs3_18hlicBY'),
(3, 'Camp in a tent', 'Camp in a tent: Camping in a tent a great escape from an everyday hassle. Weather it is in a park, forest, or a primitive site. It’s always fun. ', 'https://i.picsum.photos/id/99/300/200.jpg?grayscale&hmac=kLPXDj2iVbIbHWYHn421twWFJNwmtGDMDgkB4GJ3Rzg'),
(4, 'Watch a sunrise', 'Watch a sunrise: Watching a sunrise is a great feeling. It takes one’s breath away if they get to see sunrise in a mountain.', 'https://i.picsum.photos/id/237/300/200.jpg?hmac=WSdbBEXvCVSqNN1HnCzm7ohp6DhAJfl9t3TcqBNDn_Q');

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

--
-- Table structure for table `racing_item`
--

CREATE TABLE `racing_item` (
  `id` int(11) NOT NULL,
  `item_name` varchar(100) NOT NULL,
  `item_desc` varchar(600) NOT NULL,
  `item_image` varchar(300) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `racing_item`
--

INSERT INTO `racing_item` (`id`, `item_name`, `item_desc`, `item_image`) VALUES
(1, 'Formula-1', 'Formula-1: Formula One (also known as Formula 1 or F1) is the highest class of international racing for open wheel single seater formula car sanctioned by the FIA.', 'https://i.picsum.photos/id/22/300/200.jpg?hmac=uKInwwdP0VvkT8bkRkjdQrF1HC8D6DnebTdCJUnZfWw'),
(2, 'Grand prix', 'Grand prix: Each race in a season is called a \'Grand Prix\' or GP and all the races in a season combined are called \'Grands Prix\' (plural of Grand Prix). The term \'Grand Prix\' is derived from French which means \'great prize\'.', 'https://i.picsum.photos/id/870/300/200.jpg?grayscale&hmac=_GNLZMNS5QDXL_0R1ypYn1yAYSR3XT-hxYs2GmhNHzs'),
(3, 'Moto GP', 'Moto GP: Moto gp is basically formula 1 for bikes. The lap times for F1 cars are much shorter than those of MotoGP. F1 cars lap much faster than MotoGP bikes because they have much more downforce, which allows them to corner much faster.', 'https://i.picsum.photos/id/741/300/200.jpg?hmac=6PSa-ow0BGRd5tNp6POHZR0qH5zbB0hKgzR7KGY8tus'),
(4, 'Hill Climb', 'Hill Climb: It is a racing done in hills. Basically whoever is successful climbing a hill in their vehicle fastest is the winner.', 'https://i.picsum.photos/id/437/300/200.webp?hmac=CkpLNTvZYVLC9PsGO-DGbIq84IvpSeFw0ixueAfIDLI');

--
-- Indexes for dumped tables
--

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

--
-- AUTO_INCREMENT for table `racing_item`
--
ALTER TABLE `racing_item`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
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 */;
