-- Host: 10.6.158.222    Database: bd_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$7194c12319c566d66d235b154e4635fd93839cec5c591cd51c0ec','a27804d536636c38adecbecde42b3582841f49ef'),(2,'dr_chen','$2y$10$79693e072d2c3ed12758e148593c67aa399b2e569496805fcdfa0','8c910fedea50a169e727151be97637d19c704b93');
