-- Host: 10.250.127.253    Database: archive_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$d2da54b86f5b96809ce08397871f87065448a3644588ea3366036','1d6cc73b0cb4a0514b6144ac06a4315629a6a348'),(2,'dr_chen','$2y$10$cf860f325dbffc9993a942d2fae9ed59ebd55efb9d4db7be37ca7','d33c052d37b56b4bf98a0ef23afa2ce4ae09dbd0');
