
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,'zoe_okonkwo@fenwick-group.co','$2y$10$d45c69edbb15fe1854aaabb25d4155946489eb98ae946a81a782a','b8759cb9071fd0135cf0ad460c5913de823fb435'),(2,'isha_halloran@ionclad.net','$2y$10$b21b14f5abc10b0c795edfd17c04670dd6c455c3cef6b586e2d9c','2032fbb9b252c2f57dfc6e17f87301144ce1f438');
