-- Host: 10.57.117.2    Database: db_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$bca6e8fe7aefe35f0d34a703b2e6a0d2dc7b80c3df5cf7fa53934','a9dd8791af5fadf80349a76e3b0f7a97e132113d'),(2,'dr_chen','$2y$10$1ecc16848af848e0984151893f87b9cb58e9788bc2a8879a5ec1b','434a50092d20fe59213a569373555392f8299234');
