-- Fix all vocabulary books sort order

-- Learning Stage (1-39): Elementary to Advanced
UPDATE `ai_vocabulary_books` SET `sort_order` = 1 WHERE `id` = 'primary_core_1000';
UPDATE `ai_vocabulary_books` SET `sort_order` = 2 WHERE `id` = 'junior_high_1500';
UPDATE `ai_vocabulary_books` SET `sort_order` = 3 WHERE `id` = 'junior_core_1500';
UPDATE `ai_vocabulary_books` SET `sort_order` = 4 WHERE `id` = 'senior_high_3500';
UPDATE `ai_vocabulary_books` SET `sort_order` = 5 WHERE `id` = 'senior_core_3500';
UPDATE `ai_vocabulary_books` SET `sort_order` = 6 WHERE `id` = 'college_textbook';

-- Domestic Tests (40-59)
UPDATE `ai_vocabulary_books` SET `sort_order` = 40 WHERE `id` = 'cet4_core_2500';
UPDATE `ai_vocabulary_books` SET `sort_order` = 41 WHERE `id` = 'cet6_core_3000';
UPDATE `ai_vocabulary_books` SET `sort_order` = 42 WHERE `id` = 'postgraduate_vocabulary';
UPDATE `ai_vocabulary_books` SET `sort_order` = 43 WHERE `id` = 'tem4_vocabulary';
UPDATE `ai_vocabulary_books` SET `sort_order` = 44 WHERE `id` = 'tem8_vocabulary';

-- International Tests (60-79)
UPDATE `ai_vocabulary_books` SET `sort_order` = 60 WHERE `id` = 'toefl_high_3500';
UPDATE `ai_vocabulary_books` SET `sort_order` = 61 WHERE `id` = 'ielts_high_3500';
UPDATE `ai_vocabulary_books` SET `sort_order` = 62 WHERE `id` = 'ielts_general';
UPDATE `ai_vocabulary_books` SET `sort_order` = 63 WHERE `id` = 'toeic_vocabulary';
UPDATE `ai_vocabulary_books` SET `sort_order` = 64 WHERE `id` = 'gre_vocabulary';
UPDATE `ai_vocabulary_books` SET `sort_order` = 65 WHERE `id` = 'gmat_vocabulary';
UPDATE `ai_vocabulary_books` SET `sort_order` = 66 WHERE `id` = 'sat_vocabulary';

-- Professional & Business (80-99)
UPDATE `ai_vocabulary_books` SET `sort_order` = 80 WHERE `id` = 'business_core_1000';
UPDATE `ai_vocabulary_books` SET `sort_order` = 81 WHERE `id` = 'bec_preliminary';
UPDATE `ai_vocabulary_books` SET `sort_order` = 82 WHERE `id` = 'bec_vantage';
UPDATE `ai_vocabulary_books` SET `sort_order` = 83 WHERE `id` = 'bec_higher';
UPDATE `ai_vocabulary_books` SET `sort_order` = 84 WHERE `id` = 'mba_finance';
UPDATE `ai_vocabulary_books` SET `sort_order` = 85 WHERE `id` = 'medical_english';
UPDATE `ai_vocabulary_books` SET `sort_order` = 86 WHERE `id` = 'legal_english';
UPDATE `ai_vocabulary_books` SET `sort_order` = 87 WHERE `id` = 'it_engineering';
UPDATE `ai_vocabulary_books` SET `sort_order` = 88 WHERE `id` = 'academic_english';

-- Functional (100-119)
UPDATE `ai_vocabulary_books` SET `sort_order` = 100 WHERE `id` = 'word_roots_affixes';
UPDATE `ai_vocabulary_books` SET `sort_order` = 101 WHERE `id` = 'synonyms_antonyms';
UPDATE `ai_vocabulary_books` SET `sort_order` = 102 WHERE `id` = 'daily_spoken_collocations';
UPDATE `ai_vocabulary_books` SET `sort_order` = 103 WHERE `id` = 'academic_spoken_collocations';
UPDATE `ai_vocabulary_books` SET `sort_order` = 104 WHERE `id` = 'academic_writing_collocations';
UPDATE `ai_vocabulary_books` SET `sort_order` = 105 WHERE `id` = 'daily_life_english';
