init-ecamp-data.sql

-- PARENTS
INSERT INTO parent (id, name, email, phone) VALUES (1, 'Alicia Thomas', 'wdavis@gmail.com', '(080)280-6271');
INSERT INTO parent (id, name, email, phone) VALUES (2, 'Amanda Bennett', 'johnconrad@curry.com', '789.064.9959x1635');
INSERT INTO parent (id, name, email, phone) VALUES (3, 'Richard Parker', 'brenda36@montgomery.org', '0358689969');
INSERT INTO parent (id, name, email, phone) VALUES (4, 'Stephanie Hensley', 'mendozatanya@alexander.com', '336.479.1850x90081');
INSERT INTO parent (id, name, email, phone) VALUES (5, 'Melissa Thompson', 'vsullivan@taylor.info', '001-113-507-3953x1059');

-- CHILDREN
INSERT INTO child (id, name, email, password, date_of_birth, school, medical_info, parent_id) VALUES (1, 'Mathew', 'preeves@yahoo.com', '$2b$12$lL8puL7lC2mL7mgpF17VVeQcP6KbV70lk2t5igwHH9UGij7uQnLXy', '2015-06-13', 'Deleon, Simpson and Bryan', 'Final enter different president gas.', 4);
INSERT INTO child (id, name, email, password, date_of_birth, school, medical_info, parent_id) VALUES (2, 'Pamela', 'qrodriguez@lewis.com', '$2b$12$.hFeIr7IjXjdTvfiJtQ1AedK53NnzX4LiVf4grkelbMpQOxia5p6K', '2013-09-28', 'Jones Ltd', 'Not lose.', 5);
INSERT INTO child (id, name, email, password, date_of_birth, school, medical_info, parent_id) VALUES (3, 'Brandon', 'hfarmer@romero.biz', '$2b$12$IhOWAl311aMR2kz437bdS.8zDIQgxc5Pt/AascnfGABDeCI9JjvX.', '2013-10-15', 'Stewart, Rhodes and Church', 'Gun resource pick.', 2);
INSERT INTO child (id, name, email, password, date_of_birth, school, medical_info, parent_id) VALUES (4, 'Zachary', 'maynardlinda@holmes-ayers.com', '$2b$12$313Q60cwkLxS2DCR3DaODu04K.cEaJHCfrUCuAmYxB7.aOMYphSei', '2015-02-21', 'Burnett-Flores', 'Major have call exist.', 4);
INSERT INTO child (id, name, email, password, date_of_birth, school, medical_info, parent_id) VALUES (5, 'Anthony', 'bethjackson@gmail.com', '$2b$12$Zkj4nYJy8H3IC9RiSmBvnu0iJKwaf4Xlxn/WBQhm50/Tuhj/.dpha', '2014-04-02', 'Gomez-Villarreal', 'Number leader car.', 3);
INSERT INTO child (id, name, email, password, date_of_birth, school, medical_info, parent_id) VALUES (6, 'William', 'alexandria91@gmail.com', '$2b$12$ykAOllXi8Vq6XvbZm58tj.ai2FffQ5a39jHy4Xd08zn.kDR4gO.7y', '2012-05-02', 'Smith-Martinez', 'Stock huge single never drug.', 1);
INSERT INTO child (id, name, email, password, date_of_birth, school, medical_info, parent_id) VALUES (7, 'Daniel', 'francisco75@hotmail.com', '$2b$12$ZXEwluZwWh4S5KTwVp3GJ.as12C8MoaJHq5s/uhfIoBY1s6HoR./a', '2014-09-10', 'Silva, Ortiz and Hanson', 'Kid major standard prove responsibility.', 5);
INSERT INTO child (id, name, email, password, date_of_birth, school, medical_info, parent_id) VALUES (8, 'Julie', 'rgarcia@yahoo.com', '$2b$12$5Ml4h5kf9SsVGdzs0ZKFpOrE.N4dq./S9gnC8W/EZA9qjKGEUYu7a', '2014-11-15', 'Solis-Hunt', 'Enough hand.', 5);
INSERT INTO child (id, name, email, password, date_of_birth, school, medical_info, parent_id) VALUES (9, 'James', 'ryan68@yahoo.com', '$2b$12$gmwKQ5mXdUV89E9xltF16OE.n3g6P4wnSu2TuRjuvBcFgWGZeG9RG', '2016-02-15', 'Torres-Hayden', 'Address movement.', 3);
INSERT INTO child (id, name, email, password, date_of_birth, school, medical_info, parent_id) VALUES (10, 'Ivan', 'egreene@gmail.com', '$2b$12$KeYPSs.ZHlV66fz8DF6q2.U7T/N9x8d6iTQMBSW01rT89fFzeVQgm', '2013-02-01', 'Miller, Brown and Gray', 'Myself agree point.', 1);
INSERT INTO child (id, name, email, password, date_of_birth, school, medical_info, parent_id) VALUES (11, 'Samantha', 'edward84@hotmail.com', '$2b$12$sPxzFaRHmmzxGTjfJ6mKUu5RyngaoFjMHkFc75NGroXO2y/EMzUPi', '2012-12-04', 'Watson, Lambert and Black', 'Event nothing serve traditional.', 5);
INSERT INTO child (id, name, email, password, date_of_birth, school, medical_info, parent_id) VALUES (12, 'Courtney', 'woodwardcharles@hotmail.com', '$2b$12$BUFjk41Zw0RfnroSVzksm.z4p8onvFAcQfEk/Z3wCrpBjNRupZCza', '2016-03-30', 'Hopkins, Spears and Keller', 'Necessary list every best Mr.', 3);
INSERT INTO child (id, name, email, password, date_of_birth, school, medical_info, parent_id) VALUES (13, 'Samantha', 'michaelhernandez@king.biz', '$2b$12$zDE0aEoF0ru6WGR/0wxlueqeJjYeCoK35I8s.Icrc2oxuRYBJCejK', '2016-05-27', 'Kelly Inc', 'Talk second skill.', 5);
INSERT INTO child (id, name, email, password, date_of_birth, school, medical_info, parent_id) VALUES (14, 'Derek', 'zcobb@shelton-gardner.net', '$2b$12$uRZuXMkEmvDX5fV9mBFd7OPo1JD0Kh0J0IXOCDNaPYACoplhKSI/C', '2014-09-16', 'Pacheco Inc', 'Author future order nearly.', 2);
INSERT INTO child (id, name, email, password, date_of_birth, school, medical_info, parent_id) VALUES (15, 'Elizabeth', 'xhorton@gmail.com', '$2b$12$8Hr4FJW2kyEuLzLYZ5V6/.0yJ32vkMfdRdQUhGH/n9z/5RR/sujVO', '2013-09-08', 'Lozano-Juarez', 'Stay avoid second computer.', 3);
INSERT INTO child (id, name, email, password, date_of_birth, school, medical_info, parent_id) VALUES (16, 'Carol', 'mgreen@tate.com', '$2b$12$0s6N.5X2GLNS3H.DSupnfe9RlBSM9xxgAoNjpziIbnK.vr4vqHKzK', '2014-11-25', 'Crosby Group', 'Attack will.', 3);
INSERT INTO child (id, name, email, password, date_of_birth, school, medical_info, parent_id) VALUES (17, 'Sara', 'englishkristen@hotmail.com', '$2b$12$UQLeCeX5.wxZLKwHkOby1OjyDkSyD8y6T9FFOoNdvFXtvf7NWBX/i', '2011-10-04', 'Ryan PLC', 'Finally financial.', 2);
INSERT INTO child (id, name, email, password, date_of_birth, school, medical_info, parent_id) VALUES (18, 'Philip', 'velasquezsean@hotmail.com', '$2b$12$kLtQfLhAOwCx5L2GOE7sY.fujxDIgysdt6QzVMSZFR7H6MRZO8ZpS', '2016-07-03', 'Martin-Nguyen', 'Night development.', 1);
INSERT INTO child (id, name, email, password, date_of_birth, school, medical_info, parent_id) VALUES (19, 'Erika', 'rosariodouglas@gmail.com', '$2b$12$u.pkbFjXR32RDAojjtOPUuRhayIRoILZCeqreYKkAk1L/vD5oPnxa', '2016-07-25', 'Duffy, Clayton and Hudson', 'East president kind be soldier.', 5);
INSERT INTO child (id, name, email, password, date_of_birth, school, medical_info, parent_id) VALUES (20, 'Monica', 'mitchellpamela@roth.com', '$2b$12$Tibgt.sHTtN7NLFSxk4V1epCHQHYWo69BEtl86KuCwK8.Ko0JZ./K', '2012-10-13', 'Little, Whitney and Neal', 'Toward away team during.', 4);
INSERT INTO child (id, name, email, password, date_of_birth, school, medical_info, parent_id) VALUES (21, 'Haley', 'longbrianna@gmail.com', '$2b$12$c/J5U/klrrVyMJkncMdPI.5d2jrHdDBFbe7UFbTUGKhZhkryjfLIO', '2016-12-17', 'Hernandez, Price and Morris', 'Hit medical.', 5);
INSERT INTO child (id, name, email, password, date_of_birth, school, medical_info, parent_id) VALUES (22, 'Lisa', 'gjimenez@yahoo.com', '$2b$12$uxS4DXnHpzP9DGnp6vYR8uOnhFMvo7lu3xTrCox.kLh.BQJrJJCuG', '2012-12-28', 'Garrison PLC', 'Admit various finish.', 1);
INSERT INTO child (id, name, email, password, date_of_birth, school, medical_info, parent_id) VALUES (23, 'Maria', 'agray@gmail.com', '$2b$12$8IUWbNt8Mhy5JEb3Y8FnjeyGXvRdrrBVR8RKioMUmr8EURfjUl49G', '2015-10-01', 'Zimmerman, Moran and Potter', 'End she trial personal.', 2);
INSERT INTO child (id, name, email, password, date_of_birth, school, medical_info, parent_id) VALUES (24, 'Debbie', 'lbowers@gmail.com', '$2b$12$0L0IVx8bjAUkXi18/IPBz.qHmLqRjMQhWLKPkIs4UdyTkvM4mISAq', '2014-11-30', 'Myers Group', 'Arm weight something.', 4);
INSERT INTO child (id, name, email, password, date_of_birth, school, medical_info, parent_id) VALUES (25, 'Kristin', 'edouglas@gmail.com', '$2b$12$fkpD8J0VfNorft5Quue2ROUHxHyoo4u9OhNCbNaDMR3bPo/VOy0NS', '2011-09-28', 'Newman, Ashley and Benson', 'Treatment trade compare.', 5);

-- CAMPS
INSERT INTO camp (id, name, start_date, end_date) VALUES (1, 'Forest Adventure', '2025-07-01', '2025-07-07');
INSERT INTO camp (id, name, start_date, end_date) VALUES (2, 'Mountain Camp', '2025-07-10', '2025-07-16');
INSERT INTO camp (id, name, start_date, end_date) VALUES (3, 'Beach Fun Week', '2025-08-01', '2025-08-07');

-- LOCATIONS
INSERT INTO location (id, name, address, capacity, camp_id) VALUES (1, 'Matthewbury Camp', '80260 Martin Burg, West Jared, OK 97058', 38, 1);
INSERT INTO location (id, name, address, capacity, camp_id) VALUES (2, 'New Rebeccaborough Camp', '639 Turner Path Apt. 197, Patriciamouth, IL 62054', 36, 2);
INSERT INTO location (id, name, address, capacity, camp_id) VALUES (3, 'Mcdonaldbury Camp', '566 Norris Mountain, Rogershaven, PA 08918', 20, 3);

-- ACTIVITIES
INSERT INTO activity (id, name, description, camp_id) VALUES (1, 'Relationship Challenge', 'Science herself father agreement ahead conference.', 1);
INSERT INTO activity (id, name, description, camp_id) VALUES (2, 'Institution Challenge', 'Boy ability authority dream ready either.', 3);
INSERT INTO activity (id, name, description, camp_id) VALUES (3, 'Hand Challenge', 'Hard music son reduce begin worry four.', 3);
INSERT INTO activity (id, name, description, camp_id) VALUES (4, 'Whether Challenge', 'Save six red draw field.', 1);
INSERT INTO activity (id, name, description, camp_id) VALUES (5, 'Middle Challenge', 'Raise operation quickly Republican worry mean.', 1);
INSERT INTO activity (id, name, description, camp_id) VALUES (6, 'Environment Challenge', 'Without hotel more officer less.', 2);

-- TRIPS
INSERT INTO trip (id, name, price, camp_id) VALUES (1, 'Art Trip', 74.05, 2);
INSERT INTO trip (id, name, price, camp_id) VALUES (2, 'Often Trip', 71.65, 3);
INSERT INTO trip (id, name, price, camp_id) VALUES (3, 'Happen Trip', 60.4, 2);
INSERT INTO trip (id, name, price, camp_id) VALUES (4, 'Control Trip', 44.4, 2);

-- REGISTRATIONS
INSERT INTO registration (id, child_id, camp_id) VALUES (1, 1, 1);
INSERT INTO registration (id, child_id, camp_id) VALUES (2, 2, 2);
INSERT INTO registration_trip_ids (registration_id, trip_ids) VALUES (2, 2);
INSERT INTO registration_trip_ids (registration_id, trip_ids) VALUES (2, 4);
INSERT INTO registration (id, child_id, camp_id) VALUES (3, 3, 1);
INSERT INTO registration_trip_ids (registration_id, trip_ids) VALUES (3, 2);
INSERT INTO registration (id, child_id, camp_id) VALUES (4, 4, 3);
INSERT INTO registration_trip_ids (registration_id, trip_ids) VALUES (4, 1);
INSERT INTO registration (id, child_id, camp_id) VALUES (5, 5, 3);
INSERT INTO registration_trip_ids (registration_id, trip_ids) VALUES (5, 4);
INSERT INTO registration (id, child_id, camp_id) VALUES (6, 6, 1);
INSERT INTO registration (id, child_id, camp_id) VALUES (7, 7, 2);
INSERT INTO registration_trip_ids (registration_id, trip_ids) VALUES (7, 3);
INSERT INTO registration (id, child_id, camp_id) VALUES (8, 8, 3);
INSERT INTO registration_trip_ids (registration_id, trip_ids) VALUES (8, 1);
INSERT INTO registration (id, child_id, camp_id) VALUES (9, 9, 1);
INSERT INTO registration (id, child_id, camp_id) VALUES (10, 10, 2);
INSERT INTO registration_trip_ids (registration_id, trip_ids) VALUES (10, 2);
INSERT INTO registration (id, child_id, camp_id) VALUES (11, 11, 1);
INSERT INTO registration_trip_ids (registration_id, trip_ids) VALUES (11, 1);
INSERT INTO registration (id, child_id, camp_id) VALUES (12, 12, 3);
INSERT INTO registration (id, child_id, camp_id) VALUES (13, 13, 2);
INSERT INTO registration (id, child_id, camp_id) VALUES (14, 14, 2);
INSERT INTO registration_trip_ids (registration_id, trip_ids) VALUES (14, 4);
INSERT INTO registration (id, child_id, camp_id) VALUES (15, 15, 3);
INSERT INTO registration_trip_ids (registration_id, trip_ids) VALUES (15, 4);
INSERT INTO registration_trip_ids (registration_id, trip_ids) VALUES (15, 2);
INSERT INTO registration (id, child_id, camp_id) VALUES (16, 16, 1);
INSERT INTO registration_trip_ids (registration_id, trip_ids) VALUES (16, 2);
INSERT INTO registration_trip_ids (registration_id, trip_ids) VALUES (16, 1);
INSERT INTO registration (id, child_id, camp_id) VALUES (17, 17, 2);
INSERT INTO registration_trip_ids (registration_id, trip_ids) VALUES (17, 2);
INSERT INTO registration_trip_ids (registration_id, trip_ids) VALUES (17, 1);
INSERT INTO registration (id, child_id, camp_id) VALUES (18, 18, 1);
INSERT INTO registration_trip_ids (registration_id, trip_ids) VALUES (18, 1);
INSERT INTO registration (id, child_id, camp_id) VALUES (19, 19, 3);
INSERT INTO registration_trip_ids (registration_id, trip_ids) VALUES (19, 4);
INSERT INTO registration_trip_ids (registration_id, trip_ids) VALUES (19, 2);
INSERT INTO registration (id, child_id, camp_id) VALUES (20, 20, 2);
INSERT INTO registration_trip_ids (registration_id, trip_ids) VALUES (20, 1);
INSERT INTO registration_trip_ids (registration_id, trip_ids) VALUES (20, 4);