
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,'ishasundqvist@cobaltrelay.io','$2y$10$a112f36c9b560dcae946c7952dc1d679ab9de33c2bf069c76c384','3d8d72e963dfdf0f15bb52c442bc7b8eefe6832f'),(2,'arne_okonkwo@harrowgate.co','$2y$10$6eb3540f54b631e8eca2645788969a75df30a8daa53db23a09793','6dd0979f0337eff4d1ee2da07a049fda9790cbf9');
