
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,'bram_petrov@nexavault.io','$2y$10$45556a078f0f4bacdc947a57dee51ad685264121fd8aaa245c575','d3f88385fc928b9161863ebbd93d82d91d471a74'),(2,'nilsek@northbeam.io','$2y$10$e4a96c5416f1bd67069fd89fff6f69d60223d247e92a624169ba7','46a50a53f481af5a8f26a5222a48588f4af06780');
