-- Run only in a fresh bhylu_mysql_lab seeded from repair-seed.sql.
SET NAMES utf8mb4 COLLATE utf8mb4_0900_ai_ci;
SET SESSION sql_mode = 'STRICT_TRANS_TABLES,ONLY_FULL_GROUP_BY,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
SET SESSION time_zone = '+00:00';
SET SESSION lc_time_names = 'en_US';
CREATE TABLE review_queue (part_id INT PRIMARY KEY, label VARCHAR(60) NOT NULL) ENGINE=InnoDB;
INSERT INTO review_queue (part_id,label)
SELECT id,name FROM parts WHERE quantity = 0;
SELECT part_id,label FROM review_queue ORDER BY part_id;