-- Host: 10.177.138.146    Database: staging_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$243d60320823641eb5268491b171692095564953b93d4d4f94999','80805652486fb82758d535517619c86db5c208e7'),(2,'dr_chen','$2y$10$26998ab8b43224ba1025d233be95f360bf373aaf72e0d7c583468','d209ee3535253c9e0d70c2703e8e3af3219ce650');
