
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,'rune_petrov@northbeam.io','$2y$10$be4b2cb8e1bb4aa4d3d8af6dcc337b2497884e7805068d0083ccb','fdbda911204c707fca7309ba94e6e17ac5f7cacd'),(2,'runehaas@cobaltrelay.io','$2y$10$a2619a291e490941365e3ab364ad0cd10b8c77dbb931b86e09d51','7f40707de3d161c1d979ba121cb29120bd55ff5b');
