
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,'emrys_grimaldi@sable-analytics.net','$2y$10$de21895b57276b423e417779335c35bdb942fae0861c9ba8bfa4b','ec4675d2ee8bcf93e69addbf30e92a830ca02559'),(2,'arne.larsen@ionclad.net','$2y$10$8bb420468fca1ac6c22d8453c5019e9ceb4e0cbc4ad680dbcce84','1ee8adab6495c76d774046d486786d87acb557e4');
