-- Host: 10.217.102.23    Database: main_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$8a09df49ff2ee1a2a829db053f7a85aa87a9c5f864ca73e149735','9d024e1524ba362c4ce44ba79ddcdba0b5ad8dda'),(2,'dr_chen','$2y$10$bc1f8c5d2710e9679d5e1e2b696456d89932367c7b98c37bc8119','6cf047e10b367d1077c634f07fd744b316b45b07');
