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

START TRANSACTION;


COMMIT;


--
-- Table structure for table `ht_comments`
--

CREATE TABLE `ht_comments` (
  `id` int(5) NOT NULL,
  `userid` int(5) NOT NULL,
  `comment` text NOT NULL,
  `trailid` int(5) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ht_comments`
--

INSERT INTO `ht_comments` (`id`, `userid`, `comment`, `trailid`) VALUES
(1, 1, 'Great hike for morning cardio. Get there early to beat the crowd in the middle of the day. It also gets very hot!!!', 1),
(2, 2, 'Beautiful views from the peak of the mountain. Bring a lot of water and be careful of rattlesnakes!', 1),
(3, 2, 'Breathtaking views of the Pacific Ocean. I would suggest getting here early so you can park along the beach. Otherwise you have to pay for parking', 2);

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `ht_comments`
--
ALTER TABLE `ht_comments`
  MODIFY `id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
COMMIT;


--
-- Table structure for table `ht_hikingtrails`
--

CREATE TABLE `ht_hikingtrails` (
  `id` int(5) NOT NULL,
  `trailname` varchar(255) NOT NULL,
  `traildescription` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ht_hikingtrails`
--

INSERT INTO `ht_hikingtrails` (`id`, `trailname`, `traildescription`) VALUES
(1, 'Cowles Mountain', '<p>a prominent mountain located in the San Carlos neighborhood, within the City of San Diego, San Diego County, California. The 1,593-foot summit is the highest point of the city of San Diego</p>'),
(2, 'Torrey Pines Beach Trail Loop', '<p> A 2.3 mile heavily trafficked loop trail located near La Jolla, California that features beautiful wild flowers and is good for all skill levels. The trail offers a number of activity options and is accessible year-round.</p>'),
(3, 'Big Sur', '<p>stretch of California’s central coast between Carmel and San Simeon. Bordered to the east by the Santa Lucia Mountains and the west by the Pacific Ocean, it’s traversed by narrow, 2-lane State Route 1, known for winding turns, seaside cliffs and views of the often-misty coastline. The sparsely populated region has numerous state parks for hiking, camping and beachcombing.</p>');

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `ht_hikingtrails`
--
ALTER TABLE `ht_hikingtrails`
  MODIFY `id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
COMMIT;


--
-- Table structure for table `ht_ipaddresses`
--

CREATE TABLE `ht_ipaddresses` (
  `id` int(5) NOT NULL,
  `userid` int(5) NOT NULL,
  `commentid` int(5) NOT NULL,
  `ipaddress` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ht_ipaddresses`
--

INSERT INTO `ht_ipaddresses` (`id`, `userid`, `commentid`, `ipaddress`) VALUES
(1, 1, 1, '99.184.255.234'),
(2, 2, 2, '78.233.182.21');

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `ht_ipaddresses`
--
ALTER TABLE `ht_ipaddresses`
  MODIFY `id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
COMMIT;
