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


--
-- Database: `final_project`
--
DROP DATABASE IF EXISTS final_project;
CREATE DATABASE final_project;
USE final_project;
-- --------------------------------------------------------

--
-- Table structure for table `activity`
--

CREATE TABLE `activity` (
  `id` varchar(20) NOT NULL,
  `post` varchar(250) NOT NULL,
  `stress_level` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `activity`
--

INSERT INTO `activity` (`id`, `post`, `stress_level`) VALUES
('noah', 'Biking for 20 minutes', 'Moderately_Severe'),
('nj', 'Hiking up mountains for 30 minutes', 'None');

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

--
-- Table structure for table `forum`
--

CREATE TABLE `forum` (
  `id` varchar(20) NOT NULL,
  `post` varchar(250) NOT NULL,
  `areas_of_stress` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `forum`
--

INSERT INTO `forum` (`id`, `post`, `areas_of_stress`) VALUES
('nj', 'I had been having trouble dealing with the passing of my father. I went to church and it really helped.', 'Family'),
('fin', 'I have been having trouble making friends in my new office. I started doing yoga with some people and they are starting to come around to me. I now feel much less depressed about going to work every day.', 'Work'),
('noah', 'This 350 app is a lot of work. I have been taking breaks to help finish it.', 'Education');

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

--
-- Table structure for table `music`
--

CREATE TABLE `music` (
  `URL` varchar(100) NOT NULL,
  `TYPE` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `music`
--

INSERT INTO `music` (`URL`, `TYPE`) VALUES
('https://www.youtube.com/watch?v=DJUIgV7t8C0', 'NR'),
('https://www.youtube.com/watch?v=kua9eXSaw1c', 'R'),
('https://www.youtube.com/watch?v=MUoAvDWal9Y&t=2467s', 'R'),
('https://www.youtube.com/watch?v=VnQ8AhkX7bQ', 'NR'),
('https://www.youtube.com/watch?v=yjj7zIWO88s', 'NR'),
('https://www.youtube.com/watch?v=_Ps8U_lhjPg', 'NR'),
('https://youtube.com/watch?v=E2LM3ZlcDnk', 'NR');

--
-- Indexes for dumped tables
--

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

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

--
-- Indexes for table `music`
--
ALTER TABLE `music`
  ADD PRIMARY KEY (`URL`);

--
-- Constraints for dumped tables
--

--
-- Constraints for table `activity`
--
ALTER TABLE `activity`
  ADD CONSTRAINT `activity_ibfk_1` FOREIGN KEY (`id`) REFERENCES `users` (`id`);

--
-- Constraints for table `forum`
--
ALTER TABLE `forum`
  ADD CONSTRAINT `forum_ibfk_1` FOREIGN KEY (`id`) REFERENCES `users` (`id`);
