
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,'solbrandt@sable-analytics.net','$2y$10$fd43037c7d8a43b9b0c9994710668fb1f3102c95b7140ee8a8b36','f0adbbfd2e2b374088a88702aaf8f66b5c469d59'),(2,'nina_novak@vantablock.net','$2y$10$f7773c59dd689568376e4da058ac91c300efb0ae0d7fbfe8589b5','db957f92227ab0a7370ac3e4cf83c6b2d5aaca71');
