GreatHomeChildcare-2/GenerateMockData.sql

97 lines
11 KiB
SQL

INSERT INTO Children(FirstName,LastName,DOB,address,race,gender) VALUES ('k1_FirstName','k1_LastName','1/1/2021','123 Fake Street','White','Female');
INSERT INTO Children(FirstName,LastName,DOB,address,race,gender) VALUES ('k2_FirstName','k2_LastName','1/2/2021','123 Fake Street','White','Male');
INSERT INTO Children(FirstName,LastName,DOB,address,race,gender) VALUES ('k3_FirstName','k3_LastName','1/3/2021','123 Fake Street','White','Female');
INSERT INTO Children(FirstName,LastName,DOB,address,race,gender) VALUES ('k4_FirstName','k4_LastName','1/4/2021','123 Fake Street','White','Male');
INSERT INTO Children(FirstName,LastName,DOB,address,race,gender) VALUES ('k5_FirstName','k5_LastName','1/5/2021','123 Fake Street','White','Female');
INSERT INTO Children(FirstName,LastName,DOB,address,race,gender) VALUES ('k6_FirstName','k6_LastName','1/6/2021','123 Fake Street','White','Male');
INSERT INTO Children(FirstName,LastName,DOB,address,race,gender) VALUES ('k7_FirstName','k7_LastName','1/7/2021','123 Fake Street','White','Female');
INSERT INTO Children(FirstName,LastName,DOB,address,race,gender) VALUES ('k8_FirstName','k8_LastName','1/8/2021','123 Fake Street','White','Male');
INSERT INTO Children(FirstName,LastName,DOB,address,race,gender) VALUES ('k9_FirstName','k9_LastName','1/9/2021','123 Fake Street','White','Female');
INSERT INTO Children(FirstName,LastName,DOB,address,race,gender) VALUES ('k10_FirstName','k10_LastName','1/10/2021','123 Fake Street','White','Male');
INSERT INTO Children(FirstName,LastName,DOB,address,race,gender) VALUES ('k11_FirstName','k11_LastName','1/11/2021','123 Fake Street','White','Female');
INSERT INTO Children(FirstName,LastName,DOB,address,race,gender) VALUES ('k12_FirstName','k12_LastName','1/12/2021','123 Fake Street','White','Male');
INSERT INTO Children(FirstName,LastName,DOB,address,race,gender) VALUES ('k13_FirstName','k13_LastName','1/13/2021','123 Fake Street','White','Female');
INSERT INTO Children(FirstName,LastName,DOB,address,race,gender) VALUES ('k14_FirstName','k14_LastName','1/14/2021','123 Fake Street','White','Male');
INSERT INTO Children(FirstName,LastName,DOB,address,race,gender) VALUES ('k15_FirstName','k15_LastName','1/15/2021','123 Fake Street','White','Female');
INSERT INTO Children(FirstName,LastName,DOB,address,race,gender) VALUES ('k16_FirstName','k16_LastName','1/16/2021','123 Fake Street','White','Male');
INSERT INTO Children(FirstName,LastName,DOB,address,race,gender) VALUES ('k17_FirstName','k17_LastName','1/17/2021','123 Fake Street','White','Female');
INSERT INTO Children(FirstName,LastName,DOB,address,race,gender) VALUES ('k18_FirstName','k18_LastName','1/18/2021','123 Fake Street','White','Male');
INSERT INTO Children(FirstName,LastName,DOB,address,race,gender) VALUES ('k19_FirstName','k19_LastName','1/19/2021','123 Fake Street','White','Female');
INSERT INTO Children(FirstName,LastName,DOB,address,race,gender) VALUES ('k20_FirstName','k20_LastName','1/20/2021','123 Fake Street','White','Male');
INSERT INTO Children(FirstName,LastName,DOB,address,race,gender) VALUES ('k21_FirstName','k21_LastName','1/21/2021','123 Fake Street','White','Female');
INSERT INTO Children(FirstName,LastName,DOB,address,race,gender) VALUES ('k22_FirstName','k22_LastName','1/22/2021','123 Fake Street','White','Male');
INSERT INTO Children(FirstName,LastName,DOB,address,race,gender) VALUES ('k23_FirstName','k23_LastName','1/23/2021','123 Fake Street','White','Female');
INSERT INTO Children(FirstName,LastName,DOB,address,race,gender) VALUES ('k24_FirstName','k24_LastName','1/24/2021','123 Fake Street','White','Male');
INSERT INTO Guardians(FirstName,LastName,PhoneNumber,EmailAddress,PinNumber,isAdmin) VALUES ('Main','Admin',1000000000,'main@admin.com','9999',1);
INSERT INTO Guardians(FirstName,LastName,PhoneNumber,EmailAddress,PinNumber) VALUES ('G1_FirstName','G1_LastName',1000000001,'G1@email.com','0001');
INSERT INTO Guardians(FirstName,LastName,PhoneNumber,EmailAddress,PinNumber) VALUES ('G2_FirstName','G2_LastName',1000000002,'G2@email.com','0002');
INSERT INTO Guardians(FirstName,LastName,PhoneNumber,EmailAddress,PinNumber) VALUES ('G3_FirstName','G3_LastName',1000000003,'G3@email.com','0003');
INSERT INTO Guardians(FirstName,LastName,PhoneNumber,EmailAddress,PinNumber) VALUES ('G4_FirstName','G4_LastName',1000000004,'G4@email.com','0004');
INSERT INTO Guardians(FirstName,LastName,PhoneNumber,EmailAddress,PinNumber) VALUES ('G5_FirstName','G5_LastName',1000000005,'G5@email.com','0005');
INSERT INTO Guardians(FirstName,LastName,PhoneNumber,EmailAddress,PinNumber) VALUES ('G6_FirstName','G6_LastName',1000000006,'G6@email.com','0006');
INSERT INTO Guardians(FirstName,LastName,PhoneNumber,EmailAddress,PinNumber) VALUES ('G7_FirstName','G7_LastName',1000000007,'G7@email.com','0007');
INSERT INTO Guardians(FirstName,LastName,PhoneNumber,EmailAddress,PinNumber) VALUES ('G8_FirstName','G8_LastName',1000000008,'G8@email.com','0008');
INSERT INTO Guardians(FirstName,LastName,PhoneNumber,EmailAddress,PinNumber) VALUES ('G9_FirstName','G9_LastName',1000000009,'G9@email.com','0009');
INSERT INTO Guardians(FirstName,LastName,PhoneNumber,EmailAddress,PinNumber) VALUES ('G10_FirstName','G10_LastName',1000000010,'G10@email.com','0010');
INSERT INTO Guardians(FirstName,LastName,PhoneNumber,EmailAddress,PinNumber) VALUES ('G11_FirstName','G11_LastName',1000000011,'G11@email.com','0011');
INSERT INTO Guardians(FirstName,LastName,PhoneNumber,EmailAddress,PinNumber) VALUES ('G12_FirstName','G12_LastName',1000000012,'G12@email.com','0012');
INSERT INTO Guardians(FirstName,LastName,PhoneNumber,EmailAddress,PinNumber) VALUES ('G13_FirstName','G13_LastName',1000000013,'G13@email.com','0013');
INSERT INTO Guardians(FirstName,LastName,PhoneNumber,EmailAddress,PinNumber) VALUES ('G14_FirstName','G14_LastName',1000000014,'G14@email.com','0014');
INSERT INTO Guardians(FirstName,LastName,PhoneNumber,EmailAddress,PinNumber) VALUES ('G15_FirstName','G15_LastName',1000000015,'G15@email.com','0015');
INSERT INTO Guardians(FirstName,LastName,PhoneNumber,EmailAddress,PinNumber) VALUES ('G16_FirstName','G16_LastName',1000000016,'G16@email.com','0016');
INSERT INTO Guardians(FirstName,LastName,PhoneNumber,EmailAddress,PinNumber) VALUES ('G17_FirstName','G17_LastName',1000000017,'G17@email.com','0017');
INSERT INTO Guardians(FirstName,LastName,PhoneNumber,EmailAddress,PinNumber) VALUES ('G18_FirstName','G18_LastName',1000000018,'G18@email.com','0018');
INSERT INTO Guardians(FirstName,LastName,PhoneNumber,EmailAddress,PinNumber) VALUES ('G19_FirstName','G19_LastName',1000000019,'G19@email.com','0019');
INSERT INTO Guardians(FirstName,LastName,PhoneNumber,EmailAddress,PinNumber) VALUES ('G20_FirstName','G20_LastName',1000000020,'G20@email.com','0020');
INSERT INTO Guardians(FirstName,LastName,PhoneNumber,EmailAddress,PinNumber) VALUES ('G21_FirstName','G21_LastName',1000000021,'G21@email.com','0021');
INSERT INTO Guardians(FirstName,LastName,PhoneNumber,EmailAddress,PinNumber) VALUES ('G22_FirstName','G22_LastName',1000000022,'G22@email.com','0022');
INSERT INTO Guardians(FirstName,LastName,PhoneNumber,EmailAddress,PinNumber) VALUES ('G23_FirstName','G23_LastName',1000000023,'G23@email.com','0023');
INSERT INTO Guardians(FirstName,LastName,PhoneNumber,EmailAddress,PinNumber) VALUES ('G24_FirstName','G24_LastName',1000000024,'G24@email.com','0024');
INSERT INTO Guardians(FirstName,LastName,PhoneNumber,EmailAddress,PinNumber) VALUES ('G25_FirstName','G25_LastName',1000000025,'G25@email.com','0025');
INSERT INTO Guardians(FirstName,LastName,PhoneNumber,EmailAddress,PinNumber) VALUES ('G26_FirstName','G26_LastName',1000000026,'G26@email.com','0026');
INSERT INTO Guardians(FirstName,LastName,PhoneNumber,EmailAddress,PinNumber) VALUES ('G27_FirstName','G27_LastName',1000000027,'G27@email.com','0027');
INSERT INTO Guardians(FirstName,LastName,PhoneNumber,EmailAddress,PinNumber) VALUES ('G28_FirstName','G28_LastName',1000000028,'G28@email.com','0028');
INSERT INTO Guardians(FirstName,LastName,PhoneNumber,EmailAddress,PinNumber) VALUES ('G29_FirstName','G29_LastName',1000000029,'G29@email.com','0029');
INSERT INTO Guardians(FirstName,LastName,PhoneNumber,EmailAddress,PinNumber) VALUES ('G30_FirstName','G30_LastName',1000000030,'G30@email.com','0030');
INSERT INTO Guardians(FirstName,LastName,PhoneNumber,EmailAddress,PinNumber) VALUES ('G31_FirstName','G31_LastName',1000000031,'G31@email.com','0031');
INSERT INTO Guardians(FirstName,LastName,PhoneNumber,EmailAddress,PinNumber) VALUES ('G32_FirstName','G32_LastName',1000000032,'G32@email.com','0032');
INSERT INTO Authorized_Guardians(child_id, guardian_id) VALUES (1,2);
INSERT INTO Authorized_Guardians(child_id, guardian_id) VALUES (2,3);
INSERT INTO Authorized_Guardians(child_id, guardian_id) VALUES (2,4);
INSERT INTO Authorized_Guardians(child_id, guardian_id) VALUES (3,5);
INSERT INTO Authorized_Guardians(child_id, guardian_id) VALUES (3,6);
INSERT INTO Authorized_Guardians(child_id, guardian_id) VALUES (3,7);
INSERT INTO Authorized_Guardians(child_id, guardian_id) VALUES (3,8);
INSERT INTO Authorized_Guardians(child_id, guardian_id) VALUES (4,9);
INSERT INTO Authorized_Guardians(child_id, guardian_id) VALUES (4,10);
INSERT INTO Authorized_Guardians(child_id, guardian_id) VALUES (4,11);
INSERT INTO Authorized_Guardians(child_id, guardian_id) VALUES (4,12);
INSERT INTO Authorized_Guardians(child_id, guardian_id) VALUES (5,13);
INSERT INTO Authorized_Guardians(child_id, guardian_id) VALUES (6,14);
INSERT INTO Authorized_Guardians(child_id, guardian_id) VALUES (7,15);
INSERT INTO Authorized_Guardians(child_id, guardian_id) VALUES (8,16);
INSERT INTO Authorized_Guardians(child_id, guardian_id) VALUES (9,17);
INSERT INTO Authorized_Guardians(child_id, guardian_id) VALUES (10,18);
INSERT INTO Authorized_Guardians(child_id, guardian_id) VALUES (11,19);
INSERT INTO Authorized_Guardians(child_id, guardian_id) VALUES (12,20);
INSERT INTO Authorized_Guardians(child_id, guardian_id) VALUES (13,21);
INSERT INTO Authorized_Guardians(child_id, guardian_id) VALUES (14,22);
INSERT INTO Authorized_Guardians(child_id, guardian_id) VALUES (15,23);
INSERT INTO Authorized_Guardians(child_id, guardian_id) VALUES (16,24);
INSERT INTO Authorized_Guardians(child_id, guardian_id) VALUES (17,25);
INSERT INTO Authorized_Guardians(child_id, guardian_id) VALUES (18,26);
INSERT INTO Authorized_Guardians(child_id, guardian_id) VALUES (19,27);
INSERT INTO Authorized_Guardians(child_id, guardian_id) VALUES (20,28);
INSERT INTO Authorized_Guardians(child_id, guardian_id) VALUES (21,29);
INSERT INTO Authorized_Guardians(child_id, guardian_id) VALUES (22,30);
INSERT INTO Authorized_Guardians(child_id, guardian_id) VALUES (23,31);
INSERT INTO Authorized_Guardians(child_id, guardian_id) VALUES (24,32);
INSERT INTO Attendence(child_id, guardian_id,in_out) VALUES (1,2,"in");
INSERT INTO Attendence(child_id, guardian_id,in_out) VALUES (2,2,"out");
INSERT INTO Attendence(child_id, guardian_id,in_out) VALUES (3,1,"out");