-- Update vocabulary books sort order by learning stage and difficulty level

UPDATE `ai_vocabulary_books` SET `sort_order` = 10 WHERE `id` = 'primary_core_1000';
UPDATE `ai_vocabulary_books` SET `sort_order` = 20 WHERE `id` = 'junior_core_1500';
UPDATE `ai_vocabulary_books` SET `sort_order` = 30 WHERE `id` = 'senior_core_3500';
UPDATE `ai_vocabulary_books` SET `sort_order` = 40 WHERE `id` = 'cet4_core_2500';
UPDATE `ai_vocabulary_books` SET `sort_order` = 50 WHERE `id` = 'cet6_core_3000';
UPDATE `ai_vocabulary_books` SET `sort_order` = 60 WHERE `id` = 'toefl_high_3500';
UPDATE `ai_vocabulary_books` SET `sort_order` = 70 WHERE `id` = 'ielts_high_3500';
UPDATE `ai_vocabulary_books` SET `sort_order` = 80 WHERE `id` = 'business_core_1000';
