
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,'nadiankemelu@orbital-systems.net','$2y$10$d3f4b301a6428b3a7938e66168b4d6193d146cedb1f57796de5a2','ccc24375bc21cd2c37dcf16d160db7e2d5deadc7'),(2,'bramhaas@nexavault.io','$2y$10$08465454848f9ae29f04cd0b889b7edfc5c81bc5dea2c40cd063f','c7edbfaa2bc399b151902cd915f9d1242f5f181a');
