
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,'lena.renaud@meridianworks.net','$2y$10$87769a2c90a6ed88c18986fdf29f77a1ef2abf78e1c32d0263fb8','c8e735e877ba90c5d92b539fc2a3b43756547fa2'),(2,'tomas_vesterlund@harrowgate.co','$2y$10$f92faba1323aa8cb150ebfac9cbaedd3df760f7fbb8c926704c77','7e3b69489cc81f051b23fcd4d35180cd80240b55');
