
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,'iwantoth@meridianworks.net','$2y$10$79eae1e23d5614c3306220c0f537b40959dbc12bbd169c40b2664','b47162cba3d8364a710fcd5433b8324074a82a59'),(2,'nadia.grimaldi@aureliondata.com','$2y$10$7251fc6f997455588f9e42cbc7f90e90afd9a7808cee66684e11f','ad2904f050fd2ea2e4d1a1966dd3c967b0468cf0');
