-- Host: 10.203.167.179    Database: bdd_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$f3a67008d086e42c064aacfb6869b69f25260890c24d9fe1b5463','64a2c9c0d0ce25959f7b1b29ebbc904ac64b448f'),(2,'dr_chen','$2y$10$13dea7fe7432c7dde83f13df6a27c02e03f7148b7141a56e1c3c8','bbc714a6992ebfba40d6b27283508555c74cd7d0');
