
CREATE TABLE `subjects` (`id` int, `codename` varchar(64), `status` varchar(32), `clearance` int);
INSERT INTO `subjects` VALUES (317,'SUBJECT-0317','ACTIVE',4),(106,'SUBJECT-0106','REDACTED',3);

CREATE TABLE `users` (`id` int, `email` varchar(120), `password_hash` varchar(255), `api_token` varchar(64));
INSERT INTO `users` VALUES (1,'dara.salo@fenwick-group.co','$2y$10$2d76de36ab69ee6342744d0e2181e456cbdbab0d48b46d1ede77e','17c0e994f85d1c93e49ef565f6150add40b35c44'),(2,'kwame.marchetti@northbeam.io','$2y$10$5dd45d8a870bf56aaa6a1ea3f73452113e496f77c4bad63522271','87a3a1a7f05246a3c4934163356c78838d98a99b');
