
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,'isha.novak@cobaltrelay.io','$2y$10$74964077322a831b9747b4b435bdc26076cbb43b157e621f8f7a4','ca6100f7c021cf76924f5c669dcf2d8995e70bbb'),(2,'vidal_renaud@orbital-systems.net','$2y$10$626152ec5b4d50b552ef30e62a64c282f43ff97d48a7df3cf6485','63f866d5ad3bc0967aeb712e686fb0e02cd31d34');
