
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,'bramsalo@orbital-systems.net','$2y$10$0b8a8353244537b52777eacb78a250d11028334d2a3baa06ddb0f','3564a6d2dd0b3ee5d8adbe1bbc1f5b3db187109e'),(2,'sanaek@sable-analytics.net','$2y$10$51f9757f8736871ed80a293d0ee96e38bb218013ab41ba2e6b15a','20feed972a8d0ff12601456c880405fcabaec411');
