
--- populate the database
---
---   $ sqlite3 academics.db < populate.sql
---

 INSERT INTO People(id, name, age) VALUES(1, 'John Smith', 21);
 INSERT INTO People(id, name, age) VALUES(2, 'Jane Doe',18);
 INSERT INTO People(id, name, age) VALUES(3, 'Inigo Montoya',33);
 INSERT INTO People(id, name, age) VALUES(4, 'Zaphod Beeblebrox', 401);
 INSERT INTO People(id, name, age) VALUES(5, 'Frodo Baggins', 129);

 INSERT INTO Roles(id, name) VALUES(1, 'faculty'); 
 INSERT INTO Roles(id, name) VALUES(2, 'student');
 INSERT INTO Roles(id, name) VALUES(3, 'guest'); 

 INSERT INTO Courses(id, name)  VALUES(1, 'Counting on your Fingers');
 INSERT INTO Courses(id, name)  VALUES(2, 'Physics for Poets');
 INSERT INTO Courses(id, name)  VALUES(3, 'Advanced Whirled Peas');

---                                                                   who  what  why  
 INSERT INTO Registrations(id, person, course, role, date)  VALUES(1, 1,   2,    2, '2020-01-02');
 INSERT INTO Registrations(id, person, course, role, date)  VALUES(2, 2,   2,    2, '2020-01-02');
 INSERT INTO Registrations(id, person, course, role, date)  VALUES(3, 4,   2,    1, '2020-01-02');
 INSERT INTO Registrations(id, person, course, role, date)  VALUES(4, 5,   3,    1, '2020-01-02');
 INSERT INTO Registrations(id, person, course, role, date)  VALUES(5, 3,   1,    1, '2020-01-02');
 INSERT INTO Registrations(id, person, course, role, date)  VALUES(6, 1,   1,    2, '2020-01-02');
 INSERT INTO Registrations(id, person, course, role, date)  VALUES(7, 2,   1,    2, '2020-01-02');
 INSERT INTO Registrations(id, person, course, role, date)  VALUES(8, 5,   1,    2, '2020-01-02'); 

