-- Host: 10.150.105.93    Database: temp_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$67a7ee160d506c783de1aa38b5c6064c70a2374a28a6223a504b6','e6c221253459166d0041fea3612b41cb6a235766'),(2,'dr_chen','$2y$10$dba5d4876dd783036e608f0cabcbb24c6e7d661f75057183e2940','b094ba1dda94301a750e62ca0603d2852f66c231');
