-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `adamlawrence_website`
--

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

--
-- Table structure for table `activitydata`
--

CREATE TABLE `activitydata` (
  `activityID` char(2) NOT NULL,
  `activity` varchar(20) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `description` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `activitydata`
--

INSERT INTO `activitydata` (`activityID`, `activity`, `price`, `description`) VALUES
('L1', 'Luge', 61.00, 'Gondola + 1 Luge Ride'),
('L2', 'Luge', 78.00, 'Gondola + 3 Luge Ride'),
('L3', 'Luge', 91.00, 'Gondola + 5 Luge Ride');

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

--
-- Table structure for table `userdata`
--

CREATE TABLE `userdata` (
  `userID` int(11) NOT NULL,
  `firstname` varchar(20) NOT NULL,
  `lastname` varchar(20) NOT NULL,
  `email` varchar(100) NOT NULL,
  `password_hash` varchar(100) NOT NULL,
  `date` date NOT NULL,
  `activityID` char(2) DEFAULT NULL,
  `admin` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `userdata`
--

INSERT INTO `userdata` (`userID`, `firstname`, `lastname`, `email`, `password_hash`, `date`, `activityID`, `admin`) VALUES
(7, 'Adam', 'Lawrence', 'glurvr1@gmail.com', '$2y$10$cS1rtAmW1AxMXey3lQQCgOwQPbLjHBEzsKPNG9UEKKElG0CI5WMDS', '0000-00-00', NULL, 1),
(8, 'Alison', 'Lawrence', 'glitchcreator999@gmail.com', '$2y$10$0GbSaah9232Ig4trzbFmkOp5pNfy2MN5rUi6wGJXyH.dkAobAqZHu', '0000-00-00', NULL, 0),
(9, 'Scott', 'Lawrence', 'epiccsgogamer6969@gmail.com', '$2y$10$9VBt3G/4k4PHjKn25B2pEe8YBOi1mRAysG0dg6qs1gy1hshEFPv5G', '0000-00-00', NULL, 0);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `activitydata`
--
ALTER TABLE `activitydata`
  ADD PRIMARY KEY (`activityID`);

--
-- Indexes for table `userdata`
--
ALTER TABLE `userdata`
  ADD PRIMARY KEY (`userID`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `userdata`
--
ALTER TABLE `userdata`
  MODIFY `userID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
COMMIT;

