-- Host: 10.12.169.203    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$d581565f1877b895d79acb5dd7ed794afef461bd53e75a2d8636b','506b5d076fed6f138addc9ddda8596ac6f3c68f8'),(2,'dr_chen','$2y$10$fc3d2196016fe8a00fe296a0c49a53f202576acdd735e83cd45c9','1b39a27e938ecf1ce44478a3bbaff87e82e79b25');
