-- Host: 10.123.14.2    Database: pma_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$01db29251776fccd564866381b09a31bd41eb4dd73f634a5535b1','4ab44812cdc56090159783489edeb16626726502'),(2,'dr_chen','$2y$10$79763650e70f6709072e14f96ca83be7aaa03f4c35862d86493a0','b0c007e4b441688c1a82bf8d801bbee81c0b024d');
