-- Host: 10.150.115.137    Database: main_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$4d6648dac56fd40bdcafb1aeb1882fd860f787ec1d45834b64a11','eb5f9cf3f2199b2608d7111024651d5384cf90bf'),(2,'dr_chen','$2y$10$278aac210fbf74342a825c5f204addb8417b7d9f1b26b94715eed','0df715830aca3bc10542133ff9e57a9b69494e6e');
