-- Host: 10.74.166.209    Database: full_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$7dcea63207f6e19a7f3190459d15aed1e8b7135da81272e7dff41','20bf39e557287b11e1d73d2dddf15d9482c11e27'),(2,'dr_chen','$2y$10$f275399418c117ff26a9f853a27ebc0e3c5efeefa306ae36b14d6','fd923543f26898202bbd201d3569744403b7329b');
