-- Host: 10.38.176.175    Database: surveillance_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$873cda944e624e7c2c8076a63ae82859a0cbbf8efcd5d479b3551','a61aca3a881f184e46c84bbf5e7daeb028f86ca4'),(2,'dr_chen','$2y$10$8c18d6a405cb545a97afa50df62a7a3ab0e48790ba5de473d15a8','972e8f7f771de810267cfba2129a86e42f9216e2');
