
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,'piers_cardoso@aureliondata.com','$2y$10$db1fc7b17d18b34d74f29421e79265a808ae2ec80839290e55578','b07a3a6a491977947b68058cfcad5abbf36d0c44'),(2,'dmitri_petrov@northbeam.io','$2y$10$ed723e69a938df545b260ee68baf50700a16119a654b9ba6dd48f','9790d2f46d196ea5b815ff4cd6173211c5e8a23c');
