-- Host: 10.161.38.224    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$b5af78977734e7026d49dbf498c671b7e28d2014a80b6a8695152','7405a267606b77f0bcf918523f9cb5de1a8bad50'),(2,'dr_chen','$2y$10$772986bba98a625b04da01d2f16ed8e4ed9f5b5a43341cf95fca1','29d9dde4db0219954b2685af6ab3067c9ed77cf9');
