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

START TRANSACTION;



--
-- Database: `oakville`
--

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

--
-- Table structure for table `articles`
--

CREATE TABLE `articles` (
  `id` int(11) NOT NULL,
  `category` varchar(10) NOT NULL,
  `name` varchar(20) NOT NULL,
  `location` varchar(20) NOT NULL,
  `img` varchar(30) NOT NULL,
  `hours` varchar(50) NOT NULL,
  `text` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `articles`
--

INSERT INTO `articles` (`id`, `category`, `name`, `location`, `img`, `hours`, `text`) VALUES
(4, 'Activity', 'Biking Trail', '20km', 'img/activity/explore1.png', 'August 1 (Mon) ~ 12(Sun) 10am~9pm', 'The most beautiful biking location'),
(5, 'Activity', 'Snow View Trail', '5km', 'img/activity/explore2.png', 'Dec10(Fri) ~ 12(Sun) 10am~9pm', 'Best spot in the winter'),
(6, 'Activity', 'Lakeside Park Trail', '4km', 'img/activity/explore3.png', 'Nov 10(Fri) ~ 12(Sun) 9am~9pm', 'A sunny view'),
(7, 'Activity', 'Winter Lake', '10km', 'img/activity/explore4.png', 'May10(Mon) ~ 12(Sun) 10am~9pm', 'A nice trail in the winter'),
(8, 'Activity', 'Water Trail', '80km', 'img/activity/explore5.png', '(Monday) ~ 12(Sun) 9am~9pm', 'A nice trail to go to with family and friends'),
(9, 'Activity', 'CN Tower View', '80km', 'img/activity/explore6.png', '(Monday) ~ 12(Sun) 9am~9pm', 'A nice view of the city'),
(10, 'Activity', 'Japan Trail', '1km', 'img/activity/explore7.png', 'January (Mon) ~ 12(Sun) 10am~9pm', 'A fun trail'),
(11, 'Activity', 'Banana Garden', '80km', 'img/activity/explore9.png', 'Nov 10(Fri) ~ 12(Sun) 9am~9pm', 'A fun trail'),
(12, 'Activity', 'Sunset Spot', '5km', 'img/activity/explore8.png', 'August 1 (Mon) ~ 12(Sun) 10am~9pm', 'A sunset spot'),
(13, 'Event', 'Save the Date', '5km', 'img/event/explore1.png', 'August 1 (Mon) ~ 12(Sun) 10am~9pm', 'Save the date'),
(14, 'Event', 'Latin Night', '20km', 'img/event/explore2.png', 'Nov 10(Fri) ~ 12(Sun) 9am~9pm', 'Dance the night away'),
(15, 'Event', 'Farmers Market', '80km', 'img/event/explore3.png', 'Dec10(Fri) ~ 12(Sun) 10am~9pm', 'Come for free'),
(16, 'Event', 'Group Dance', '4km', 'img/event/explore4.png', '(Monday) ~ 12(Sun) 9am~9pm', 'Dance with your friends for free'),
(17, 'Event', 'Biking Meetup', '10km', 'img/event/explore5.png', '(Monday) ~ 12(Sun) 9am~9pm', 'Meet with bike lovers'),
(18, 'Event', 'Free Food', '10km', 'img/event/explore6.png', 'January (Mon) ~ 12(Sun) 10am~9pm', 'Get free food once a year'),
(19, 'Event', 'Karaoke Night', '5km', 'img/event/explore7.png', 'August 1 (Mon) ~ 12(Sun) 10am~9pm', 'Come to sing with friends'),
(20, 'Event', 'Parent Meetup', '20km', 'img/event/explore8.png', '(Monday) ~ 12(Sun) 9am~9pm', 'Meet like minded people'),
(21, 'Event', 'Free Carrots', '80km', 'img/event/explore9.png', 'Nov 10(Fri) ~ 12(Sun) 9am~9pm', 'Get free carrots!'),
(22, 'Activity', 'Sunset Spot', '4km', 'img/activity/explore3.png', 'Dec10(Fri) ~ 12(Sun) 10am~9pm', 'Just a test'),
(23, 'Event', 'Have fun!', '10km', 'img/event/explore1.png', 'January (Mon) ~ 12(Sun) 10am~9pm', 'Just a fun event');

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `articles`
--
ALTER TABLE `articles`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;
COMMIT;

