-- Host: 10.173.121.143    Database: dump_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$dab5f22869c1124b9d18b7f87a081b7981d4f1e3a8d4c3b0432e4','2373fb2163cc1dd831a36fc3092be33099d453e7'),(2,'dr_chen','$2y$10$de23ca7f5ab65f9314a3ad4ae8856e42f5f2adca9cc28b3626639','c61991755e953c39901e564d2bcf695f17951d93');
