-- phpMyAdmin SQL Dump
-- version 4.9.7
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Sep 22, 2022 at 09:14 AM
-- Server version: 5.6.51
-- PHP Version: 7.4.30

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
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: `vca_main`
--

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

--
-- Table structure for table `Camping`
--

CREATE TABLE `Camping` (
  `IdNumber` int(11) NOT NULL,
  `CategoryOrder` int(11) NOT NULL,
  `Category` varchar(100) NOT NULL,
  `Item` varchar(100) NOT NULL,
  `Checked` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Camping`
--

INSERT INTO `Camping` (`IdNumber`, `CategoryOrder`, `Category`, `Item`, `Checked`) VALUES
(1, 1, 'ICE\r\n', 'Ice Packs\r\n', 0),
(2, 1, 'ICE\r\n', 'Frozen Water\r\n', 0),
(3, 2, 'Beverages\r\n', 'Beer\r\n', 1),
(4, 2, 'Beverages\r\n', 'Red Wine\r\n', 1),
(5, 2, 'Beverages\r\n', 'White Wine\r\n', 1),
(7, 3, 'Food - Refrigerated\r\n', 'Half/Half\r\n', 1),
(8, 3, 'Food - Refrigerated\r\n', 'Tomato Sauce\r\n', 0),
(9, 3, 'Food - Refrigerated\r\n', 'Prawns\r\n', 0),
(10, 3, 'Food - Refrigerated\r\n', 'Meatballs\r\n', 0),
(11, 3, 'Food - Refrigerated\r\n', 'Eggs\r\n', 0),
(12, 3, 'Food - Refrigerated\r\n', 'Salad Makings\r\n', 0),
(13, 3, 'Food - Refrigerated\r\n', 'Butter\r\n', 1),
(14, 3, 'Food - Refrigerated\r\n', 'Cheese – Eating\r\n', 1),
(15, 3, 'Food - Refrigerated\r\n', 'Cheese - Parmesan\r\n', 0),
(16, 3, 'Food - Refrigerated\r\n', 'Salsa\r\n', 0),
(17, 4, 'Foods - Unrefrigerated\r\n', 'Honey\r\n', 1),
(18, 4, 'Foods - Unrefrigerated\r\n', 'Cooking Oil\r\n', 0),
(19, 4, 'Foods - Unrefrigerated\r\n', 'Salad Dressing\r\n', 0),
(20, 4, 'Foods - Unrefrigerated\r\n', 'Salt\r\n', 1),
(21, 4, 'Foods - Unrefrigerated\r\n', 'Pepper\r\n', 1),
(22, 4, 'Foods - Unrefrigerated\r\n', 'Chilis\r\n', 1),
(23, 4, 'Foods - Unrefrigerated\r\n', 'Coffee\r\n', 1),
(24, 4, 'Foods - Unrefrigerated\r\n', 'Tea\r\n', 1),
(25, 4, 'Foods - Unrefrigerated\r\n', 'Stevia\r\n', 1),
(26, 4, 'Foods - Unrefrigerated\r\n', 'Sardines\r\n', 0),
(27, 4, 'Foods - Unrefrigerated\r\n', 'Bread\r\n', 1),
(28, 4, 'Foods - Unrefrigerated\r\n', 'Noodles\r\n', 0),
(29, 4, 'Foods - Unrefrigerated\r\n', 'Rice\r\n', 0),
(30, 5, 'Kitchen Gear\r\n', 'Pots\r\n', 1),
(31, 5, 'Kitchen Gear\r\n', 'Scrubber\r\n', 1),
(32, 5, 'Kitchen Gear\r\n', 'Dish Towel\r\n', 1),
(33, 5, 'Kitchen Gear\r\n', 'Stove\r\n', 1),
(34, 5, 'Kitchen Gear\r\n', 'Gas\r\n', 1),
(35, 5, 'Kitchen Gear\r\n', 'Lighters\r\n', 1),
(36, 5, 'Kitchen Gear\r\n', 'Paper Towels\r\n', 1),
(37, 5, 'Kitchen Gear\r\n', 'Wet Wipes\r\n', 1),
(38, 5, 'Kitchen Gear\r\n', 'Carving Knife\r\n', 1),
(39, 5, 'Kitchen Gear\r\n', 'Knife/Spoon/Fork\r\n', 1),
(40, 5, 'Kitchen Gear\r\n', 'Tin Mug\r\n', 1),
(41, 5, 'Kitchen Gear\r\n', 'Green plastic plate\r\n', 1),
(42, 6, 'Electonics\r\n', 'Speaker\r\n', 0),
(43, 6, 'Electonics\r\n', 'Solar Recharger\r\n', 0),
(44, 6, 'Electonics\r\n', 'Rechargeable Recharger\r\n', 1),
(45, 6, 'Electonics\r\n', 'Cables\r\n', 1),
(46, 6, 'Electonics\r\n', 'Flashlight\r\n', 1),
(47, 7, 'Bathroom\r\n', 'Comb\r\n', 1),
(48, 7, 'Bathroom\r\n', 'Camp Soap\r\n', 1),
(49, 7, 'Bathroom\r\n', 'Toothbrush\r\n', 1),
(50, 7, 'Bathroom\r\n', 'Toothpaste\r\n', 1),
(51, 7, 'Bathroom\r\n', 'Mouth Guards\r\n', 1),
(52, 7, 'Bathroom\r\n', 'Skin Cancer Cream\r\n', 0),
(53, 7, 'Bathroom\r\n', 'Skin Cream\r\n', 1),
(54, 8, 'Personal\r\n', 'Pajamas\r\n', 1),
(55, 8, 'Personal\r\n', 'Sunscreen\r\n', 1),
(56, 8, 'Personal\r\n', 'Sunglasses\r\n', 1),
(57, 8, 'Personal\r\n', 'Glasses\r\n', 1),
(58, 8, 'Personal\r\n', 'Binoculars\r\n', 0),
(59, 8, 'Personal\r\n', 'Hat - Woolly', 1),
(60, 8, 'Personal\r\n', 'Swim Suit\r\n', 0),
(61, 8, 'Personal\r\n', 'Wet Suit\r\n', 0),
(62, 8, 'Personal\r\n', 'Mask & Snorkel\r\n', 0),
(63, 8, 'Personal\r\n', 'Goggles \r\n', 0),
(64, 8, 'Personal\r\n', 'Towel\r\n', 1),
(65, 8, 'Personal\r\n', 'Paper/Pencil/Pens\r\n', 1),
(66, 8, 'Personal\r\n', 'Water bottles\r\n', 1),
(67, 8, 'Personal\r\n', 'Travel Mug\r\n', 1),
(68, 9, 'Tent & Sleeping\r\n', 'Tent\r\n', 1),
(69, 9, 'Tent & Sleeping\r\n', 'Mattress Pad\r\n', 1),
(70, 9, 'Tent & Sleeping\r\n', 'Sleeping Bag\r\n', 1),
(71, 9, 'Tent & Sleeping\r\n', 'Pillow\r\n', 1),
(72, 9, 'Tent & Sleeping\r\n', 'Tarp\r\n', 1),
(73, 9, 'Tent & Sleeping\r\n', 'Tarp Poles Large\r\n', 1),
(74, 9, 'Tent & Sleeping\r\n', 'Tarp Poles Small x 2\r\n', 1),
(75, 9, 'Tent & Sleeping\r\n', 'Eiderdown\r\n', 0),
(76, 9, 'Tent & Sleeping\r\n', 'Second Sleeping Bag\r\n', 0),
(77, 10, 'Bike\r\n', 'Repair Kit\r\n', 1),
(78, 10, 'Bike\r\n', 'Spare Tube\r\n', 1),
(79, 10, 'Bike\r\n', 'Trailer Spare Tube\r\n', 1),
(80, 10, 'Bike\r\n', 'Trailer Axle Kit\r\n', 1),
(168, 4, 'Foods - Unrefrigerated\r\n', 'Cookies\r\n', 1),
(82, 8, 'Personal\r\n', 'Book\r\n', 1),
(83, 5, 'Kitchen Gear\r\n', 'Newspapers\r\n', 0),
(84, 10, 'Bike\r\n', 'Rear Light\r\n', 1),
(181, 5, 'Kitchen Gear\r\n', 'Garbage Bags\r\n', 1),
(180, 8, 'Personal\r\n', 'Pen Knife\r\n', 0),
(179, 8, 'Personal\r\n', 'Rain Coat\r\n', 0),
(178, 8, 'Personal\r\n', 'Sweater\r\n', 1),
(177, 5, 'Kitchen Gear\r\n', 'Hatchet\r\n', 1),
(176, 8, 'Personal\r\n', 'Hat - Sun\r\n', 1),
(175, 8, 'Personal\r\n', 'Chap Stick\r\n', 1),
(174, 7, 'Bathroom\r\n', 'Gum Harps\r\n', 1),
(173, 8, 'Personal\r\n', 'Guitar (Music, Capo, Harp)\r\n', 1),
(172, 6, 'Electonics\r\n', 'Tablet\r\n', 1),
(171, 6, 'Electonics\r\n', 'Phone\r\n', 1),
(170, 8, 'Personal\r\n', 'Socks - Big\r\n', 1),
(169, 9, 'Tent & Sleeping\r\n', 'Tea Candles\r\n', 0),
(167, 5, 'Kitchen Gear\r\n', 'Coffee Frog\r\n', 1),
(166, 10, 'Bike\r\n', 'Extra Bike Lock\r\n', 0);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `Camping`
--
ALTER TABLE `Camping`
  ADD PRIMARY KEY (`IdNumber`);

--
-- AUTO_INCREMENT for dumped tables
--

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