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

START TRANSACTION;



--
-- Database: `checkpoint`
--

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

--
-- Table structure for table `admin`
--

CREATE TABLE `admin` (
  `id` int(11) NOT NULL,
  `username` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `admin`
--

INSERT INTO `admin` (`id`, `username`, `password`) VALUES
(1, 'test', '1234'),
(3, 'brad', '$2y$10$AhhjrrB1Rej2mFi5wfvxBO2w9kvHr/DIdSx15sZMOsFw77UP2gIzO'),
(4, 'admin', '$2y$10$JoUqKBo6kmhVA5QZS9QmXOY8rCXtRXyZGcLiC23RSVptewn/UVK5i');

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

--
-- Table structure for table `subjects`
--

CREATE TABLE `subjects` (
  `id` int(11) NOT NULL,
  `lastname` varchar(255) NOT NULL,
  `firstname` varchar(255) NOT NULL,
  `middlename` varchar(255) DEFAULT NULL,
  `preferred_name` varchar(255) DEFAULT NULL,
  `campus` varchar(255) NOT NULL,
  `campusInitiated` varchar(255) NOT NULL,
  `typeOfPersonStudent` int(11) DEFAULT 0,
  `typeOfPersonEmployee` int(11) DEFAULT 0,
  `typeOfPersonAlumni` int(11) DEFAULT 0,
  `typeOfPersonOther` int(11) DEFAULT 0,
  `comments` text DEFAULT NULL,
  `notifyIfEntryAttempt` int(11) DEFAULT 0,
  `notifyIfEntryAttemptComments` text DEFAULT NULL,
  `added` datetime NOT NULL DEFAULT current_timestamp(),
  `exclusion_end` datetime DEFAULT NULL,
  `picture_path` varchar(512) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `subjects`
--

INSERT INTO `subjects` (`id`, `lastname`, `firstname`, `middlename`, `preferred_name`, `campus`, `campusInitiated`, `typeOfPersonStudent`, `typeOfPersonEmployee`, `typeOfPersonAlumni`, `typeOfPersonOther`, `comments`, `notifyIfEntryAttempt`, `notifyIfEntryAttemptComments`, `added`, `exclusion_end`, `picture_path`) VALUES
(10, '          Akuma', '          Jean', '', '.', 'Elsah', 'Elsah', 1, 0, 0, 0, 'Restricted from campus indefinitely.  Repeated sexual harassment allegations.                         ', 0, 'Campus Security Director and Dean of Students', '2023-08-24 13:06:01', '2023-08-24 00:00:00', '/uploads/JP.jpg'),
(11, 'Asare', 'Yaw', 'Darko', '.', 'Elsah', 'Elsah', 1, 0, 0, 0, 'Restricted until further notice                         ', 0, '', '2023-08-24 13:09:15', '2023-08-24 00:00:00', '/uploads/yaw.jpg'),
(12, 'Blok', 'Josh', '.', '.', 'Elsah', 'Elsah', 1, 0, 0, 0, 'Restricted from campus indefinitely.  Vandalism in excess of thousands of dollars. He vandalized the large painting in the Howard Center Concourse of The Triumph of Good over Evil.                        ', 1, 'Director of Campus Security', '2023-08-24 13:10:24', '2023-08-24 00:00:00', '/uploads/josh_.jpg'),
(13, 'Francisco', 'Franklin', '.', '.', 'Elsah', 'Elsah', 1, 0, 0, 0, 'Sexual Harassment                         ', 0, '', '2023-08-24 13:11:25', '2023-08-24 00:00:00', '/uploads/franklin.jpg'),
(14, 'Melendez', 'Anthony', '.', '.', 'Elsah', 'Elsah', 1, 0, 0, 0, 'Arrested and made threats to students.                         ', 0, '', '2023-08-24 13:12:25', '2023-08-24 00:00:00', '/uploads/tony.jpg'),
(15, 'Retzlaff', 'Zach', '.', '.', 'Town and Country', 'Town and Country', 0, 1, 0, 0, 'Former dual campus employee (alumni and parent) whose contract was terminated for staff-student policy violations, including sexual relations with a student (minor)and supplying alcohol to minors.  \r\n\r\nUpdate:\r\nNever prosecuted because he married the underage victim when she turned 18. Though the marriage is legal, and he can argue he was charged but never prosecuted, he is still excluded from campus indefinitely.             ', 1, 'Director of Campus Security', '2023-08-24 13:15:29', '2023-08-24 00:00:00', '/uploads/zach.jpg'),
(16, 'Bay', 'Tommy', '.', '.', 'Elsah', 'Elsah', 0, 0, 0, 1, 'White male adult 50+ years old. Threatened St. Louis campus with harm. Has a history of theft and drugs. Lives in St. Louis, MO. Son of Principia Alumni Everett Bay and brother of retired faculty Howard Bay. \r\nShould remain on list until threats of harm can be resolved.                            ', 1, 'Campus Security Director', '2023-08-24 13:16:40', '2023-08-24 00:00:00', '/uploads/Tommy.jpg'),
(17, 'Dunn', 'Douglas', '.', '.', 'Elsah', 'Elsah', 0, 0, 0, 1, 'Threatened a staff member.  May be mentally unstable.  Danne Rhaesa was asked on 3/8/17 about this subject and she confirmed mental health concerns.  \r\nSubject should remain on list until mental health issues are resolved.                       ', 1, 'Danne Rhaesa and Campus Security Director', '2023-08-24 13:18:14', '2023-08-24 00:00:00', '/uploads/No_image_available.svg.png'),
(18, 'Bemis', 'Jason', '.', '.', 'Town and Country', 'Town and Country', 0, 0, 0, 0, 'Violating Principia School standards while in boys dorm during Fall 2014 sports camp.                         ', 1, 'Campus Security Director', '2023-08-24 13:19:27', '2023-08-24 00:00:00', '/uploads/Jason.jpg'),
(19, 'Brewer', 'Josh', '.', '.', 'Town and Country', 'Town and Country', 1, 0, 0, 0, 'Violating Principia School standards (hazing) and charged with a crime while in boys dorm during Fall 2014 sports camp.                         ', 1, 'Campus Security Director', '2023-08-24 13:20:49', '2023-08-24 00:00:00', '/uploads/brewer.jpg'),
(20, 'Bushong', 'Asher', '.', '.', 'Elsah', 'Elsah', 1, 0, 0, 0, 'Former student - distribution of drugs.                         ', 0, '', '2023-08-24 13:21:55', '2023-08-24 00:00:00', '/uploads/Asher.jpg'),
(21, 'DeNicholas', 'Luke', '.', '.', 'Town and Country', 'Town and Country', 1, 0, 0, 0, 'Violating Principia School standards (hazing) while in boys dorm during Fall 2014 school sports camp.                         ', 0, 'Campus Security Director', '2023-08-24 13:22:59', '2023-08-24 00:00:00', '/uploads/Luke.jpg'),
(22, 'Holmsley', 'Maverick', '.', '.', 'Town and Country', 'Town and Country', 1, 0, 0, 0, 'Violating Principia School standards (hazing) while in boys dorm during Fall 2014 school sports camp.                         ', 1, 'Campus Security Director', '2023-08-24 13:24:07', '2023-08-24 00:00:00', '/uploads/Meverick.jpg'),
(23, 'Loma', 'Ricky', '.', '.', 'Town and Country', 'Town and Country', 1, 0, 0, 0, 'Violating Principia School standards (hazing) while in boys dorm during Fall 2014 school sports camp.                         ', 0, 'Campus Security Director', '2023-08-24 13:25:14', '2023-08-24 00:00:00', '/uploads/Ricky.jpg'),
(24, 'Stringer', 'Gabe', '.', '.', 'Elsah', 'Elsah', 1, 0, 0, 1, 'Aggressive behavior; may be on campus with DOS permission or when accompanied by his parents.                         ', 1, 'Dean of Students', '2023-08-24 13:26:33', '2023-08-24 00:00:00', '/uploads/Gabe.jpg'),
(25, 'Bartlestone', 'David', '.', '.', 'Town and Country', 'Town and Country', 1, 0, 0, 0, 'Identified by numerous current US students as a former student still dealing/arranging marijuana sales to Upper Schoolers on and near campus.                         ', 0, '', '2023-08-24 13:27:45', '2023-08-24 00:00:00', '/uploads/David.jpg'),
(26, 'Stewart', 'Stephen', '.', '.', 'Town and Country', 'Town and Country', 1, 0, 0, 0, 'On-going investigation.  Steven (current Prin College student) has been accused of stalking type behavior by current US student with whom he had previous dating relationship. \r\n\r\nIf seen on STL campus, he is to be asked to leave immediately. If there is resistance (verbal or otherwise) , contact Security Director Lesky (314)933-0351\r\n                  ', 1, 'Melanie Duffy (314) 275-3572', '2023-08-24 13:29:30', '2023-08-24 00:00:00', '/uploads/stewart.jpg'),
(27, 'Miotke', 'Julian ', '.', '.', 'Town and Country', 'Town and Country', 1, 0, 0, 0, 'Julian was expelled for theft in Nov, 2017. Was on a probation of sorts where re-admittance would be granted if certain conditions were met.  But in February 2020, an investigation into slanderous postings on a fake \'Prin\' Instagram site was spearheaded by Julian. \r\nHe is now a legal adult and is restricted from both campuses indefinitely. ', 1, 'Andrew Lesky ', '2023-08-24 13:31:04', '2023-08-24 00:00:00', '/uploads/Miotke -julian.png'),
(28, 'Hey', 'Nathan', '.', 'Nate', 'Elsah', 'Elsah', 0, 0, 0, 1, 'Helen Wills has come forward and asked we extra patrol her home and to be aware of a family issue she is concerned about.  \r\n\r\nHer son-in-law, Nathan Hey, is set to be released, at any time, from a mental health facility. Her daughter has filed for divorce from Nathan, but he will not be aware of that until his release.  Helen’s daughter will be staying one night, tonight, with her, at her home, at 24137 Crescent Drive. After that her daughter will be moving to an unknown location out of the area. Helen is concerned that when Nathan is released he will come her to see her, to try and find out where the daughter is located. She has always had a positive relationship with Nathan, but is concerned that with the mental health problems he has had, she doesn’t know what to expect from Nathan. Nathan attended Principia, at the St. Louis Campus, but has no relationship with the Elsah campus, outside of Helen. Helen is aware that Crescent Dr. is off campus and has purchased a Simply Safe home security system. She has let Jersey County know about the security system and the issue she is having. She has no idea if Nathan will come here, but she wants us all to be aware of the issue in case he does. She has also requested that Nathan be excluded from campus, due to the mental health issues he has had, which I will be adding him to the list today.\r\n\r\nNathan served for several years in the military, but it is unknown if he has access to any weapons. Nathan’s parents live in Minneapolis, MN and the facility he is currently housed at is in Indiana.\r\n\r\nNathan Hey is a white male adult, 30-32 years old, 5’7” to 5’9”, medium build and is muscular/in shape, he has brown hair and brown eyes.  He has no vehicle at this time. The attached photos are pretty current, but it is unknown if he currently has any facial hair or not.\r\n\r\nIf Nathan does come to the front gate, please contact me immediately and do not allow him on campus. If he tries to get on campus or is seen driving towards Crescent Drive please contact Jersey County immediately, with as much information as possible.\r\n\r\nShould stay on list until Helen Wills informs us of any positive change.    ', 1, 'Matthew Brill', '2023-08-24 13:32:07', '2023-08-24 00:00:00', '/uploads/NathanHeyPhoto.jpg'),
(29, 'Hodgson', 'Celia ', '.', 'Hope', 'Town and Country', 'Town and Country', 0, 0, 1, 0, 'Ms. Hodgson, who goes by Hope, has unresolved issues with Principia regarding allegations of sexual abuse during her time as an upper school student (US\'08). She calls campus frequently to speak with Lee Barron, but if he cannot be reached, she often demands to speak to security. She has repeatedly threatened harm to herself but does have a criminal history for battery and also involuntary mental health evaluations. Local law enforcement may be called to assist in asking her to leave either campus.               ', 1, 'Lee Barron ', '2023-08-24 13:33:46', '2023-08-24 00:00:00', '/uploads/IMG_2717.jpg'),
(30, 'Baraza', 'Alphonce ', '.', '.', 'Elsah', 'Elsah', 1, 0, 0, 0, 'He is excluded from Principia campuses pending Administrative review. \r\nAlphonse was attempting to commit possible suicide by jumping off the bluffs, until he was talked off the bluffs and taken into protective custody by local law enforcement. Issue was over grades at school and relationship with family. Need to be aware of cultural issues and how those effect interactions with others from his home country. \r\nHe currently has a girlfriend on the Principia College campus, who he has tried to see since the incident. He has had to be removed from campus due to this a couple of different occasions. \r\nUnknown if a break-up with the girlfriend could be a potential trigger. \r\nShould stay on list, but may need to be reevaluated in the future.                        ', 1, 'Head of Campus Security, Dean of Students', '2023-08-24 13:36:05', '0000-00-00 00:00:00', '/uploads/574687991.jpg'),
(31, 'Warnhoff', 'Sally', '.', '.', 'Elsah', 'Elsah', 0, 0, 0, 1, 'Former temp Dining Services employee who had student complaints regarding her trying to recruit students into her cult. Also she made threats to want to see Principia burn. Should remain on list due to the nature of the complaints against her, recruiting for a cult, and the threats to the Principia College Campus.                     ', 1, 'Director of Campus Security or Director of Human Resources', '2023-08-24 13:37:31', '2023-08-24 00:00:00', '/uploads/SallyWarnhoff.jpg'),
(32, 'Redington', 'Alec', '.', '.', 'Elsah', 'Elsah', 0, 0, 0, 1, 'Non Principia student who was possibly involved in the sexual assault of a Principia Student, on campus, in September 2019. Principia Student is Kiki Holmes and is still on campus. Subject drives a red Kia Soul. The two meet via the Tinder app.\r\nShould remain on list while Kiki Holmes is still a student at Principia College.                      ', 1, 'Campus Security Director', '2023-08-24 13:39:10', '2023-08-24 00:00:00', '/uploads/RedKia1.jpg'),
(33, 'Marquardt', 'Tatyana', 'Claire', 'Tanya Marquardt', 'Elsah', 'Elsah', 0, 0, 0, 1, 'Due to formal grievance under Title IX. Please contact HR Director Beth Trevino for details. She is a former employee and student. Her twin sister is still a student at Principia College                        ', 0, 'Matthew Brill and Beth Trevino', '2023-08-24 13:40:37', '2023-08-24 00:00:00', '/uploads/TanyaMarquardt.jpg'),
(34, 'Peterson', 'Devin', '.', '.', 'Elsah', 'Elsah', 0, 0, 0, 1, 'Was in a relationship with Patty Gray (Margaret Sotos daughter, Director of Guest House) and she has a new born child from the relationship. She is now not in the relationship with him and does not want contact with him. He lives in Wisconsin and does not currently have access to a vehicle. He travels throughout the midwest for construction work. If he tries to come on campus and refuses to leave call Jersey County Sheriff\'s Office to have him removed.                     ', 1, 'Director of Campus Security Matthew Brill, Margaret Sotos', '2023-08-24 13:41:45', '2023-08-24 00:00:00', '/uploads/DevinPeterson.jpg');

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `username` varchar(50) NOT NULL,
  `password` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `username`, `password`) VALUES
(1, 'user', '$2y$10$v1inLdGLASHG9EfXkCIU3eE8YcaKthMfNwM1I28WoharL5SSwh66W');

--
-- Indexes for dumped tables
--

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

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

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `username` (`username`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `admin`
--
ALTER TABLE `admin`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `subjects`
--
ALTER TABLE `subjects`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=51;

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

