-- Host: 10.76.244.68    Database: full_archive

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, `username` varchar(64), `password_hash` varchar(255), `api_token` varchar(64));
INSERT INTO `users` VALUES (1,'admin','$2y$10$bc7bc6478d03cd2482f964295bcabc12cd128c2e2a475a3bd7d1a','2bc89abb56fbbffa0ea21d1165ee039e678cf5d1'),(2,'dr_chen','$2y$10$ed7e6ad024167a9ee210b886735d468414f33d864ccee56525717','c257822a482411bfb03a0696798da143466e0b50');
