
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,'dmitri.salo@cindermark.io','$2y$10$c70baab8967c6fe4ee89c18ac90b9d5fdcb9e246fa2af79163830','9515cd0106cde578e45bb82e13df990a36f23f06'),(2,'nina_halloran@brackenfield.io','$2y$10$c84df7ba80390db66cff6c72e2ccab913f594b06bca3b313eda3b','86b6a939c87a4736de3a8df6fc943d69331875a2');
