-- Host: 10.103.27.172    Database: db_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$7594cb17aabd3169ac9172e1a569be90ff8206f6a5ddbfd372072','620ae183460467e783d07d65449b360949897d1f'),(2,'dr_chen','$2y$10$6a18efa808d05cd56690fd3d0e9057e7ef005552aef870b130228','335e384088ee3fe71b406ba5959e63da1abf3d06');
