ALTER TABLE `novel_chapters` ADD COLUMN `volume_no` INT NULL AFTER `novel_source_id`, ADD COLUMN `volume_title` VARCHAR(255) NULL AFTER `volume_no`; CREATE INDEX `novel_chapters_novel_source_id_volume_no_idx` ON `novel_chapters`(`novel_source_id`, `volume_no`);