
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, `email` varchar(120), `password_hash` varchar(255), `api_token` varchar(64));
INSERT INTO `users` VALUES (1,'piers.ek@ionclad.net','$2y$10$5658ee39131e6bbe7148debd50ac191801a6e15500001764d2736','98aac96bdddea4c95ae84ad1f165ef25f7185ae9'),(2,'petralarsen@westford-holdings.com','$2y$10$24d72120613914f3308bda96dac5085d6b4aac56f65608393c5ee','daabf36623e8283fecd2401df5f0798bf48fb953');
