
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,'emrysnovak@orbital-systems.net','$2y$10$64df3d1767858a214cd235d38d65d65bb203bc011f156b4a2401b','8bbedb1df2e3a1db5e1c42904f54f3da5cf9c357'),(2,'cato.toth@greyharbor.co','$2y$10$accb8292b4353989a048e1b8d26ce2e4a2037c5968732b170743b','f3b24eb993b2825abeba7206b93115c421433901');
