-- Countries and sample international universities (safe to re-run: uses INSERT IGNORE / NOT EXISTS).
-- Sample records are NOT verified - verify or delete them in Admin > Universities.
INSERT IGNORE INTO countries (slug,name,name_bn,iso2,currency,short_description,short_description_bn,overview,why_study,tuition_info,scholarship_info,admission_requirements,intake_info,visa_guidance,application_process,sort_order,is_published,data_verified) VALUES ('south-korea','South Korea','দক্ষিণ কোরিয়া','KR','KRW','Globally ranked universities, English-taught programs, a safe modern society and strong scholarship routes such as GKS.','বিশ্বমানের বিশ্ববিদ্যালয়, ইংরেজি মাধ্যমের প্রোগ্রাম, নিরাপদ আধুনিক সমাজ এবং GKS-এর মতো স্কলারশিপের সুযোগ।','South Korea combines high-quality, research-driven universities with a safe, technologically advanced society. Many universities offer English-taught undergraduate and graduate programs, and the country is a popular, cost-conscious choice for Bangladeshi students.','Internationally respected universities and strong research output
English-taught programs in engineering, business, IT and more
Scholarships such as GKS and university-specific awards
Safe cities, modern transport and a vibrant student culture
Part-time work rights for eligible international students (rules apply)','Tuition is usually charged per semester and differs widely between public and private universities and between majors. Dormitory and living costs are generally lower than in many Western destinations. See each university page for details.','Government (GKS) and university scholarships can cover tuition fully or partly. Many universities offer merit-based fee reductions for strong applicants.','Typically: completed secondary/higher secondary results, academic transcripts, a valid passport, proof of English (IELTS/TOEFL) or Korean (TOPIK) as required, a study plan and financial proof.','Main intakes are March (Spring) and September (Fall). Korean-language programs may start in other months.','Students normally apply for a D-2 (study) visa or D-4 (language) visa after receiving admission. Documents usually include the admission letter, financial proof, academic records and a certificate of no criminal record, as required by the embassy.','Free counseling and profile evaluation
University and program shortlisting
Prepare and verify documents
Submit application and track admission
Visa documentation guidance
Pre-departure support',1,1,0);
INSERT IGNORE INTO countries (slug,name,name_bn,iso2,currency,short_description,short_description_bn,overview,why_study,tuition_info,scholarship_info,admission_requirements,intake_info,visa_guidance,application_process,sort_order,is_published,data_verified) VALUES ('canada','Canada','কানাডা','CA','CAD','World-class education, welcoming multicultural cities and post-study work pathways for international students.','বিশ্বমানের শিক্ষা, বহুসাংস্কৃতিক শহর এবং পড়াশোনা শেষে কাজের সুযোগ।','Canada is known for high academic standards, safe and multicultural cities and a wide choice of universities and colleges. International students can explore co-op programs and post-graduation work options subject to current immigration rules.','High-quality universities and colleges
Co-op and work-integrated learning options
Multicultural, welcoming cities
Post-graduation work permit pathways (subject to rules)
Strong research and innovation environment','Tuition and living costs vary by province, institution and program. Check each university page and the official institution website for current fees.','Entrance awards, merit scholarships and graduate funding are offered by many institutions. Availability depends on the program and applicant profile.','Typically: academic transcripts, proof of English proficiency (IELTS/TOEFL/PTE), a statement of purpose, references (for graduate study), a valid passport and proof of funds.','Common intakes are September (Fall), January (Winter) and May (Summer); availability varies by institution and program.','Students usually need a study permit, supported by a letter of acceptance, proof of funds and other documents set by the Canadian immigration authority. Requirements change; always confirm on the official government website.','Free counseling and profile evaluation
University and program shortlisting
Prepare and verify documents
Submit application and track admission
Study permit documentation guidance
Pre-departure support',2,1,0);
INSERT IGNORE INTO countries (slug,name,name_bn,iso2,currency,short_description,short_description_bn,overview,why_study,tuition_info,scholarship_info,admission_requirements,intake_info,visa_guidance,application_process,sort_order,is_published,data_verified) VALUES ('uk','United Kingdom','যুক্তরাজ্য','GB','GBP','Historic, globally respected universities with shorter degrees and a wide range of scholarships.','ঐতিহ্যবাহী ও বিশ্বখ্যাত বিশ্ববিদ্যালয়, তুলনামূলক কম মেয়াদি ডিগ্রি এবং বিভিন্ন স্কলারশিপ।','The UK offers internationally recognised qualifications, many with shorter durations than in other destinations. Universities provide strong academic support and diverse student communities.','Globally recognised degrees
Shorter course durations (many Master programs run one year)
Wide choice of subjects and specialisations
Scholarships such as Chevening and university awards
Diverse, international student community','Tuition differs by university and subject, and international fees are higher than home fees. Living costs are higher in London than elsewhere. See each university page for details.','Scholarships include Chevening, Commonwealth and many university-funded awards. Competition is strong and deadlines are early.','Typically: academic transcripts, English proficiency (IELTS/UKVI or equivalent), personal statement, references, a valid passport and proof of funds.','Main intakes are September/October, with January/February at some universities. UCAS deadlines apply to many undergraduate programs.','International students usually apply for a Student visa after receiving a Confirmation of Acceptance for Studies (CAS). Financial and English requirements apply. Always check the official UK government website.','Free counseling and profile evaluation
University and program shortlisting
Prepare and verify documents
Submit application and track admission
Student visa documentation guidance
Pre-departure support',3,1,0);
INSERT IGNORE INTO countries (slug,name,name_bn,iso2,currency,short_description,short_description_bn,overview,why_study,tuition_info,scholarship_info,admission_requirements,intake_info,visa_guidance,application_process,sort_order,is_published,data_verified) VALUES ('australia','Australia','অস্ট্রেলিয়া','AU','AUD','Top-ranked universities, a high quality of life and strong support for international students.','র‍্যাংকিংয়ে এগিয়ে থাকা বিশ্ববিদ্যালয়, উন্নত জীবনমান এবং আন্তর্জাতিক শিক্ষার্থীদের জন্য শক্তিশালী সহায়তা।','Australia has a strong reputation for quality education, research and student support, with vibrant coastal and city lifestyles and a large international student community.','Highly ranked universities
Strong student support services
Post-study work options (subject to rules)
High quality of life and diverse cities
Wide range of courses and pathway programs','Tuition and living costs vary by city, university and course. Check each university page and the official institution website for current fees.','Many universities offer international merit scholarships and fee reductions; government and external awards also exist.','Typically: academic transcripts, English proficiency (IELTS/TOEFL/PTE), a statement of purpose, a valid passport, proof of funds and health cover details.','Common intakes are February/March and July, with additional intakes at some universities.','International students typically apply for a Student visa (subclass 500) using a Confirmation of Enrolment (CoE), with a Genuine Student requirement and health cover. Confirm current rules on the official Home Affairs website.','Free counseling and profile evaluation
University and program shortlisting
Prepare and verify documents
Submit application and track admission
Student visa documentation guidance
Pre-departure support',4,1,0);
INSERT IGNORE INTO countries (slug,name,name_bn,iso2,currency,short_description,short_description_bn,overview,why_study,tuition_info,scholarship_info,admission_requirements,intake_info,visa_guidance,application_process,sort_order,is_published,data_verified) VALUES ('japan','Japan','জাপান','JP','JPY','Cutting-edge technology, safe cities and scholarships such as MEXT for international students.','আধুনিক প্রযুক্তি, নিরাপদ শহর এবং MEXT-এর মতো স্কলারশিপ।','Japan offers a blend of advanced technology, rich culture and research excellence. A growing number of universities offer English-taught programs, and Japanese-language pathways are widely available.','Research and technology excellence
Safe and efficient cities
MEXT and university scholarships
English-taught programs at selected universities
Rich culture and language-learning opportunities','National and public universities usually charge standardised tuition, while private universities vary. Living costs depend heavily on the city.','The MEXT (Japanese Government) scholarship and JASSO/university awards are available to eligible international students.','Typically: academic transcripts, proof of language ability (EJU/JLPT or English tests as applicable), a study plan, recommendation letters, a valid passport and financial documents.','Main intakes are April and October, depending on the program.','Students usually obtain a Certificate of Eligibility (COE) through the university, then apply for a student visa at the Japanese embassy. Check the official sources for current requirements.','Free counseling and profile evaluation
University and program shortlisting
Prepare and verify documents
Submit application and track admission
COE and visa documentation guidance
Pre-departure support',5,1,0);
INSERT IGNORE INTO countries (slug,name,name_bn,iso2,currency,short_description,short_description_bn,overview,why_study,tuition_info,scholarship_info,admission_requirements,intake_info,visa_guidance,application_process,sort_order,is_published,data_verified) VALUES ('malaysia','Malaysia','মালয়েশিয়া','MY','MYR','Affordable international education, English-medium programs and a multicultural environment.','সাশ্রয়ী আন্তর্জাতিক শিক্ষা, ইংরেজি মাধ্যমের প্রোগ্রাম এবং বহুসাংস্কৃতিক পরিবেশ।','Malaysia is a popular, cost-effective study destination with many English-medium programs, international branch campuses and a multicultural environment.','Lower tuition and living costs than many destinations
English-medium programs
International branch campuses and twinning programs
Multicultural, student-friendly cities
Close to Bangladesh with easy travel','Tuition and living costs are generally moderate and differ by university and program. See each university page for details.','Several universities offer merit scholarships and fee waivers for international students.','Typically: academic transcripts, English proficiency as required, a valid passport, passport photos, medical screening and proof of funds.','Common intakes are February/March, June/July and September/October; this varies by university.','International students normally require a Student Pass arranged through the university, supported by an offer letter, medical screening and financial proof. Confirm with official sources.','Free counseling and profile evaluation
University and program shortlisting
Prepare and verify documents
Submit application and track admission
Student pass documentation guidance
Pre-departure support',6,1,0);
INSERT IGNORE INTO countries (slug,name,name_bn,iso2,currency,short_description,short_description_bn,overview,why_study,tuition_info,scholarship_info,admission_requirements,intake_info,visa_guidance,application_process,sort_order,is_published,data_verified) VALUES ('germany','Germany','জার্মানি','DE','EUR','Renowned engineering universities, low or no tuition at many public universities and a strong job market.','প্রকৌশলে বিখ্যাত বিশ্ববিদ্যালয়, অনেক পাবলিক বিশ্ববিদ্যালয়ে কম বা টিউশন ফি নেই এবং শক্তিশালী কর্মবাজার।','Germany is known for engineering and research excellence. Many public universities charge low or no tuition fees, though living costs and blocked-account requirements apply.','Strong engineering, science and technology programs
Low or no tuition at many public universities
Large number of English-taught Master programs
Strong industry links and job market
Post-study residence options (subject to rules)','Many public universities charge little or no tuition, but semester contributions and living costs apply. Private universities charge tuition. See each university page for details.','DAAD and other scholarships are available for eligible students; deadlines are early.','Typically: academic transcripts, proof of German or English proficiency as required, a motivation letter, a valid passport and proof of financial resources (e.g. blocked account).','Main intakes are October (Winter semester) and April (Summer semester).','Students usually apply for a national visa for study after admission, with proof of funds and health insurance. Check the German mission and official sources for current requirements.','Free counseling and profile evaluation
University and program shortlisting
Prepare and verify documents
Submit application and track admission
Visa documentation guidance
Pre-departure support',7,1,0);
INSERT IGNORE INTO universities (slug,name,category,city,province,short_description,website_url,country_id,data_verified,is_featured,is_published,sort_order) SELECT 'university-of-toronto','University of Toronto','Public','Toronto','Ontario','Sample listing - details to be verified by Seoul Educamp International.','https://www.utoronto.ca',id,0,1,1,1 FROM countries WHERE slug='canada';
INSERT IGNORE INTO programs (university_id,slug,name,degree_level,field,duration,tuition_period,language,intake_months,is_popular,is_published,data_verified) SELECT id,'university-of-toronto-computer-science-bachelor','Computer Science','Bachelor','Computer Science','4 years','per year','English','September',1,1,0 FROM universities WHERE slug='university-of-toronto';
INSERT IGNORE INTO programs (university_id,slug,name,degree_level,field,duration,tuition_period,language,intake_months,is_popular,is_published,data_verified) SELECT id,'university-of-toronto-business-administration-master','Business Administration','Master','Business','2 years','per year','English','September',1,1,0 FROM universities WHERE slug='university-of-toronto';
INSERT INTO university_intakes (university_id,intake_name,intake_year,start_month,is_open) SELECT u.id,'Fall',2027,'September',1 FROM universities u WHERE u.slug='university-of-toronto' AND NOT EXISTS (SELECT 1 FROM university_intakes i WHERE i.university_id=u.id AND i.intake_name='Fall' AND i.intake_year=2027);
INSERT IGNORE INTO universities (slug,name,category,city,province,short_description,website_url,country_id,data_verified,is_featured,is_published,sort_order) SELECT 'university-of-british-columbia','University of British Columbia','Public','Vancouver','British Columbia','Sample listing - details to be verified by Seoul Educamp International.','https://www.ubc.ca',id,0,0,1,2 FROM countries WHERE slug='canada';
INSERT IGNORE INTO programs (university_id,slug,name,degree_level,field,duration,tuition_period,language,intake_months,is_popular,is_published,data_verified) SELECT id,'university-of-british-columbia-computer-science-bachelor','Computer Science','Bachelor','Computer Science','4 years','per year','English','September',1,1,0 FROM universities WHERE slug='university-of-british-columbia';
INSERT IGNORE INTO programs (university_id,slug,name,degree_level,field,duration,tuition_period,language,intake_months,is_popular,is_published,data_verified) SELECT id,'university-of-british-columbia-business-administration-master','Business Administration','Master','Business','2 years','per year','English','September',1,1,0 FROM universities WHERE slug='university-of-british-columbia';
INSERT INTO university_intakes (university_id,intake_name,intake_year,start_month,is_open) SELECT u.id,'Fall',2027,'September',1 FROM universities u WHERE u.slug='university-of-british-columbia' AND NOT EXISTS (SELECT 1 FROM university_intakes i WHERE i.university_id=u.id AND i.intake_name='Fall' AND i.intake_year=2027);
INSERT IGNORE INTO universities (slug,name,category,city,province,short_description,website_url,country_id,data_verified,is_featured,is_published,sort_order) SELECT 'mcgill-university','McGill University','Public','Montreal','Quebec','Sample listing - details to be verified by Seoul Educamp International.','https://www.mcgill.ca',id,0,0,1,3 FROM countries WHERE slug='canada';
INSERT IGNORE INTO programs (university_id,slug,name,degree_level,field,duration,tuition_period,language,intake_months,is_popular,is_published,data_verified) SELECT id,'mcgill-university-computer-science-bachelor','Computer Science','Bachelor','Computer Science','4 years','per year','English','September',1,1,0 FROM universities WHERE slug='mcgill-university';
INSERT IGNORE INTO programs (university_id,slug,name,degree_level,field,duration,tuition_period,language,intake_months,is_popular,is_published,data_verified) SELECT id,'mcgill-university-business-administration-master','Business Administration','Master','Business','2 years','per year','English','September',1,1,0 FROM universities WHERE slug='mcgill-university';
INSERT INTO university_intakes (university_id,intake_name,intake_year,start_month,is_open) SELECT u.id,'Fall',2027,'September',1 FROM universities u WHERE u.slug='mcgill-university' AND NOT EXISTS (SELECT 1 FROM university_intakes i WHERE i.university_id=u.id AND i.intake_name='Fall' AND i.intake_year=2027);
INSERT IGNORE INTO universities (slug,name,category,city,province,short_description,website_url,country_id,data_verified,is_featured,is_published,sort_order) SELECT 'university-of-manchester','University of Manchester','Public','Manchester','England','Sample listing - details to be verified by Seoul Educamp International.','https://www.manchester.ac.uk',id,0,1,1,1 FROM countries WHERE slug='uk';
INSERT IGNORE INTO programs (university_id,slug,name,degree_level,field,duration,tuition_period,language,intake_months,is_popular,is_published,data_verified) SELECT id,'university-of-manchester-computer-science-bachelor','Computer Science','Bachelor','Computer Science','4 years','per year','English','September',1,1,0 FROM universities WHERE slug='university-of-manchester';
INSERT IGNORE INTO programs (university_id,slug,name,degree_level,field,duration,tuition_period,language,intake_months,is_popular,is_published,data_verified) SELECT id,'university-of-manchester-business-administration-master','Business Administration','Master','Business','2 years','per year','English','September',1,1,0 FROM universities WHERE slug='university-of-manchester';
INSERT INTO university_intakes (university_id,intake_name,intake_year,start_month,is_open) SELECT u.id,'Fall',2027,'September',1 FROM universities u WHERE u.slug='university-of-manchester' AND NOT EXISTS (SELECT 1 FROM university_intakes i WHERE i.university_id=u.id AND i.intake_name='Fall' AND i.intake_year=2027);
INSERT IGNORE INTO universities (slug,name,category,city,province,short_description,website_url,country_id,data_verified,is_featured,is_published,sort_order) SELECT 'university-of-edinburgh','University of Edinburgh','Public','Edinburgh','Scotland','Sample listing - details to be verified by Seoul Educamp International.','https://www.ed.ac.uk',id,0,0,1,2 FROM countries WHERE slug='uk';
INSERT IGNORE INTO programs (university_id,slug,name,degree_level,field,duration,tuition_period,language,intake_months,is_popular,is_published,data_verified) SELECT id,'university-of-edinburgh-computer-science-bachelor','Computer Science','Bachelor','Computer Science','4 years','per year','English','September',1,1,0 FROM universities WHERE slug='university-of-edinburgh';
INSERT IGNORE INTO programs (university_id,slug,name,degree_level,field,duration,tuition_period,language,intake_months,is_popular,is_published,data_verified) SELECT id,'university-of-edinburgh-business-administration-master','Business Administration','Master','Business','2 years','per year','English','September',1,1,0 FROM universities WHERE slug='university-of-edinburgh';
INSERT INTO university_intakes (university_id,intake_name,intake_year,start_month,is_open) SELECT u.id,'Fall',2027,'September',1 FROM universities u WHERE u.slug='university-of-edinburgh' AND NOT EXISTS (SELECT 1 FROM university_intakes i WHERE i.university_id=u.id AND i.intake_name='Fall' AND i.intake_year=2027);
INSERT IGNORE INTO universities (slug,name,category,city,province,short_description,website_url,country_id,data_verified,is_featured,is_published,sort_order) SELECT 'university-of-leeds','University of Leeds','Public','Leeds','England','Sample listing - details to be verified by Seoul Educamp International.','https://www.leeds.ac.uk',id,0,0,1,3 FROM countries WHERE slug='uk';
INSERT IGNORE INTO programs (university_id,slug,name,degree_level,field,duration,tuition_period,language,intake_months,is_popular,is_published,data_verified) SELECT id,'university-of-leeds-computer-science-bachelor','Computer Science','Bachelor','Computer Science','4 years','per year','English','September',1,1,0 FROM universities WHERE slug='university-of-leeds';
INSERT IGNORE INTO programs (university_id,slug,name,degree_level,field,duration,tuition_period,language,intake_months,is_popular,is_published,data_verified) SELECT id,'university-of-leeds-business-administration-master','Business Administration','Master','Business','2 years','per year','English','September',1,1,0 FROM universities WHERE slug='university-of-leeds';
INSERT INTO university_intakes (university_id,intake_name,intake_year,start_month,is_open) SELECT u.id,'Fall',2027,'September',1 FROM universities u WHERE u.slug='university-of-leeds' AND NOT EXISTS (SELECT 1 FROM university_intakes i WHERE i.university_id=u.id AND i.intake_name='Fall' AND i.intake_year=2027);
INSERT IGNORE INTO universities (slug,name,category,city,province,short_description,website_url,country_id,data_verified,is_featured,is_published,sort_order) SELECT 'university-of-melbourne','University of Melbourne','Public','Melbourne','Victoria','Sample listing - details to be verified by Seoul Educamp International.','https://www.unimelb.edu.au',id,0,1,1,1 FROM countries WHERE slug='australia';
INSERT IGNORE INTO programs (university_id,slug,name,degree_level,field,duration,tuition_period,language,intake_months,is_popular,is_published,data_verified) SELECT id,'university-of-melbourne-computer-science-bachelor','Computer Science','Bachelor','Computer Science','4 years','per year','English','September',1,1,0 FROM universities WHERE slug='university-of-melbourne';
INSERT IGNORE INTO programs (university_id,slug,name,degree_level,field,duration,tuition_period,language,intake_months,is_popular,is_published,data_verified) SELECT id,'university-of-melbourne-business-administration-master','Business Administration','Master','Business','2 years','per year','English','September',1,1,0 FROM universities WHERE slug='university-of-melbourne';
INSERT INTO university_intakes (university_id,intake_name,intake_year,start_month,is_open) SELECT u.id,'Fall',2027,'September',1 FROM universities u WHERE u.slug='university-of-melbourne' AND NOT EXISTS (SELECT 1 FROM university_intakes i WHERE i.university_id=u.id AND i.intake_name='Fall' AND i.intake_year=2027);
INSERT IGNORE INTO universities (slug,name,category,city,province,short_description,website_url,country_id,data_verified,is_featured,is_published,sort_order) SELECT 'unsw-sydney','UNSW Sydney','Public','Sydney','New South Wales','Sample listing - details to be verified by Seoul Educamp International.','https://www.unsw.edu.au',id,0,0,1,2 FROM countries WHERE slug='australia';
INSERT IGNORE INTO programs (university_id,slug,name,degree_level,field,duration,tuition_period,language,intake_months,is_popular,is_published,data_verified) SELECT id,'unsw-sydney-computer-science-bachelor','Computer Science','Bachelor','Computer Science','4 years','per year','English','September',1,1,0 FROM universities WHERE slug='unsw-sydney';
INSERT IGNORE INTO programs (university_id,slug,name,degree_level,field,duration,tuition_period,language,intake_months,is_popular,is_published,data_verified) SELECT id,'unsw-sydney-business-administration-master','Business Administration','Master','Business','2 years','per year','English','September',1,1,0 FROM universities WHERE slug='unsw-sydney';
INSERT INTO university_intakes (university_id,intake_name,intake_year,start_month,is_open) SELECT u.id,'Fall',2027,'September',1 FROM universities u WHERE u.slug='unsw-sydney' AND NOT EXISTS (SELECT 1 FROM university_intakes i WHERE i.university_id=u.id AND i.intake_name='Fall' AND i.intake_year=2027);
INSERT IGNORE INTO universities (slug,name,category,city,province,short_description,website_url,country_id,data_verified,is_featured,is_published,sort_order) SELECT 'monash-university','Monash University','Public','Melbourne','Victoria','Sample listing - details to be verified by Seoul Educamp International.','https://www.monash.edu',id,0,0,1,3 FROM countries WHERE slug='australia';
INSERT IGNORE INTO programs (university_id,slug,name,degree_level,field,duration,tuition_period,language,intake_months,is_popular,is_published,data_verified) SELECT id,'monash-university-computer-science-bachelor','Computer Science','Bachelor','Computer Science','4 years','per year','English','September',1,1,0 FROM universities WHERE slug='monash-university';
INSERT IGNORE INTO programs (university_id,slug,name,degree_level,field,duration,tuition_period,language,intake_months,is_popular,is_published,data_verified) SELECT id,'monash-university-business-administration-master','Business Administration','Master','Business','2 years','per year','English','September',1,1,0 FROM universities WHERE slug='monash-university';
INSERT INTO university_intakes (university_id,intake_name,intake_year,start_month,is_open) SELECT u.id,'Fall',2027,'September',1 FROM universities u WHERE u.slug='monash-university' AND NOT EXISTS (SELECT 1 FROM university_intakes i WHERE i.university_id=u.id AND i.intake_name='Fall' AND i.intake_year=2027);
INSERT IGNORE INTO universities (slug,name,category,city,province,short_description,website_url,country_id,data_verified,is_featured,is_published,sort_order) SELECT 'university-of-tokyo','University of Tokyo','National','Tokyo','Tokyo','Sample listing - details to be verified by Seoul Educamp International.','https://www.u-tokyo.ac.jp',id,0,1,1,1 FROM countries WHERE slug='japan';
INSERT IGNORE INTO programs (university_id,slug,name,degree_level,field,duration,tuition_period,language,intake_months,is_popular,is_published,data_verified) SELECT id,'university-of-tokyo-computer-science-bachelor','Computer Science','Bachelor','Computer Science','4 years','per year','English','September',1,1,0 FROM universities WHERE slug='university-of-tokyo';
INSERT IGNORE INTO programs (university_id,slug,name,degree_level,field,duration,tuition_period,language,intake_months,is_popular,is_published,data_verified) SELECT id,'university-of-tokyo-business-administration-master','Business Administration','Master','Business','2 years','per year','English','September',1,1,0 FROM universities WHERE slug='university-of-tokyo';
INSERT INTO university_intakes (university_id,intake_name,intake_year,start_month,is_open) SELECT u.id,'Fall',2027,'September',1 FROM universities u WHERE u.slug='university-of-tokyo' AND NOT EXISTS (SELECT 1 FROM university_intakes i WHERE i.university_id=u.id AND i.intake_name='Fall' AND i.intake_year=2027);
INSERT IGNORE INTO universities (slug,name,category,city,province,short_description,website_url,country_id,data_verified,is_featured,is_published,sort_order) SELECT 'kyoto-university','Kyoto University','National','Kyoto','Kyoto','Sample listing - details to be verified by Seoul Educamp International.','https://www.kyoto-u.ac.jp',id,0,0,1,2 FROM countries WHERE slug='japan';
INSERT IGNORE INTO programs (university_id,slug,name,degree_level,field,duration,tuition_period,language,intake_months,is_popular,is_published,data_verified) SELECT id,'kyoto-university-computer-science-bachelor','Computer Science','Bachelor','Computer Science','4 years','per year','English','September',1,1,0 FROM universities WHERE slug='kyoto-university';
INSERT IGNORE INTO programs (university_id,slug,name,degree_level,field,duration,tuition_period,language,intake_months,is_popular,is_published,data_verified) SELECT id,'kyoto-university-business-administration-master','Business Administration','Master','Business','2 years','per year','English','September',1,1,0 FROM universities WHERE slug='kyoto-university';
INSERT INTO university_intakes (university_id,intake_name,intake_year,start_month,is_open) SELECT u.id,'Fall',2027,'September',1 FROM universities u WHERE u.slug='kyoto-university' AND NOT EXISTS (SELECT 1 FROM university_intakes i WHERE i.university_id=u.id AND i.intake_name='Fall' AND i.intake_year=2027);
INSERT IGNORE INTO universities (slug,name,category,city,province,short_description,website_url,country_id,data_verified,is_featured,is_published,sort_order) SELECT 'osaka-university','Osaka University','National','Osaka','Osaka','Sample listing - details to be verified by Seoul Educamp International.','https://www.osaka-u.ac.jp',id,0,0,1,3 FROM countries WHERE slug='japan';
INSERT IGNORE INTO programs (university_id,slug,name,degree_level,field,duration,tuition_period,language,intake_months,is_popular,is_published,data_verified) SELECT id,'osaka-university-computer-science-bachelor','Computer Science','Bachelor','Computer Science','4 years','per year','English','September',1,1,0 FROM universities WHERE slug='osaka-university';
INSERT IGNORE INTO programs (university_id,slug,name,degree_level,field,duration,tuition_period,language,intake_months,is_popular,is_published,data_verified) SELECT id,'osaka-university-business-administration-master','Business Administration','Master','Business','2 years','per year','English','September',1,1,0 FROM universities WHERE slug='osaka-university';
INSERT INTO university_intakes (university_id,intake_name,intake_year,start_month,is_open) SELECT u.id,'Fall',2027,'September',1 FROM universities u WHERE u.slug='osaka-university' AND NOT EXISTS (SELECT 1 FROM university_intakes i WHERE i.university_id=u.id AND i.intake_name='Fall' AND i.intake_year=2027);
INSERT IGNORE INTO universities (slug,name,category,city,province,short_description,website_url,country_id,data_verified,is_featured,is_published,sort_order) SELECT 'universiti-malaya','Universiti Malaya','Public','Kuala Lumpur','Kuala Lumpur','Sample listing - details to be verified by Seoul Educamp International.','https://www.um.edu.my',id,0,1,1,1 FROM countries WHERE slug='malaysia';
INSERT IGNORE INTO programs (university_id,slug,name,degree_level,field,duration,tuition_period,language,intake_months,is_popular,is_published,data_verified) SELECT id,'universiti-malaya-computer-science-bachelor','Computer Science','Bachelor','Computer Science','4 years','per year','English','September',1,1,0 FROM universities WHERE slug='universiti-malaya';
INSERT IGNORE INTO programs (university_id,slug,name,degree_level,field,duration,tuition_period,language,intake_months,is_popular,is_published,data_verified) SELECT id,'universiti-malaya-business-administration-master','Business Administration','Master','Business','2 years','per year','English','September',1,1,0 FROM universities WHERE slug='universiti-malaya';
INSERT INTO university_intakes (university_id,intake_name,intake_year,start_month,is_open) SELECT u.id,'Fall',2027,'September',1 FROM universities u WHERE u.slug='universiti-malaya' AND NOT EXISTS (SELECT 1 FROM university_intakes i WHERE i.university_id=u.id AND i.intake_name='Fall' AND i.intake_year=2027);
INSERT IGNORE INTO universities (slug,name,category,city,province,short_description,website_url,country_id,data_verified,is_featured,is_published,sort_order) SELECT 'universiti-teknologi-malaysia','Universiti Teknologi Malaysia','Public','Johor Bahru','Johor','Sample listing - details to be verified by Seoul Educamp International.','https://www.utm.my',id,0,0,1,2 FROM countries WHERE slug='malaysia';
INSERT IGNORE INTO programs (university_id,slug,name,degree_level,field,duration,tuition_period,language,intake_months,is_popular,is_published,data_verified) SELECT id,'universiti-teknologi-malaysia-computer-science-bachelor','Computer Science','Bachelor','Computer Science','4 years','per year','English','September',1,1,0 FROM universities WHERE slug='universiti-teknologi-malaysia';
INSERT IGNORE INTO programs (university_id,slug,name,degree_level,field,duration,tuition_period,language,intake_months,is_popular,is_published,data_verified) SELECT id,'universiti-teknologi-malaysia-business-administration-master','Business Administration','Master','Business','2 years','per year','English','September',1,1,0 FROM universities WHERE slug='universiti-teknologi-malaysia';
INSERT INTO university_intakes (university_id,intake_name,intake_year,start_month,is_open) SELECT u.id,'Fall',2027,'September',1 FROM universities u WHERE u.slug='universiti-teknologi-malaysia' AND NOT EXISTS (SELECT 1 FROM university_intakes i WHERE i.university_id=u.id AND i.intake_name='Fall' AND i.intake_year=2027);
INSERT IGNORE INTO universities (slug,name,category,city,province,short_description,website_url,country_id,data_verified,is_featured,is_published,sort_order) SELECT 'taylor-s-university','Taylor''s University','Private','Subang Jaya','Selangor','Sample listing - details to be verified by Seoul Educamp International.','https://university.taylors.edu.my',id,0,0,1,3 FROM countries WHERE slug='malaysia';
INSERT IGNORE INTO programs (university_id,slug,name,degree_level,field,duration,tuition_period,language,intake_months,is_popular,is_published,data_verified) SELECT id,'taylor-s-university-computer-science-bachelor','Computer Science','Bachelor','Computer Science','4 years','per year','English','September',1,1,0 FROM universities WHERE slug='taylor-s-university';
INSERT IGNORE INTO programs (university_id,slug,name,degree_level,field,duration,tuition_period,language,intake_months,is_popular,is_published,data_verified) SELECT id,'taylor-s-university-business-administration-master','Business Administration','Master','Business','2 years','per year','English','September',1,1,0 FROM universities WHERE slug='taylor-s-university';
INSERT INTO university_intakes (university_id,intake_name,intake_year,start_month,is_open) SELECT u.id,'Fall',2027,'September',1 FROM universities u WHERE u.slug='taylor-s-university' AND NOT EXISTS (SELECT 1 FROM university_intakes i WHERE i.university_id=u.id AND i.intake_name='Fall' AND i.intake_year=2027);
INSERT IGNORE INTO universities (slug,name,category,city,province,short_description,website_url,country_id,data_verified,is_featured,is_published,sort_order) SELECT 'technical-university-of-munich','Technical University of Munich','Public','Munich','Bavaria','Sample listing - details to be verified by Seoul Educamp International.','https://www.tum.de',id,0,1,1,1 FROM countries WHERE slug='germany';
INSERT IGNORE INTO programs (university_id,slug,name,degree_level,field,duration,tuition_period,language,intake_months,is_popular,is_published,data_verified) SELECT id,'technical-university-of-munich-computer-science-bachelor','Computer Science','Bachelor','Computer Science','4 years','per year','English','September',1,1,0 FROM universities WHERE slug='technical-university-of-munich';
INSERT IGNORE INTO programs (university_id,slug,name,degree_level,field,duration,tuition_period,language,intake_months,is_popular,is_published,data_verified) SELECT id,'technical-university-of-munich-business-administration-master','Business Administration','Master','Business','2 years','per year','English','September',1,1,0 FROM universities WHERE slug='technical-university-of-munich';
INSERT INTO university_intakes (university_id,intake_name,intake_year,start_month,is_open) SELECT u.id,'Fall',2027,'September',1 FROM universities u WHERE u.slug='technical-university-of-munich' AND NOT EXISTS (SELECT 1 FROM university_intakes i WHERE i.university_id=u.id AND i.intake_name='Fall' AND i.intake_year=2027);
INSERT IGNORE INTO universities (slug,name,category,city,province,short_description,website_url,country_id,data_verified,is_featured,is_published,sort_order) SELECT 'heidelberg-university','Heidelberg University','Public','Heidelberg','Baden-Württemberg','Sample listing - details to be verified by Seoul Educamp International.','https://www.uni-heidelberg.de',id,0,0,1,2 FROM countries WHERE slug='germany';
INSERT IGNORE INTO programs (university_id,slug,name,degree_level,field,duration,tuition_period,language,intake_months,is_popular,is_published,data_verified) SELECT id,'heidelberg-university-computer-science-bachelor','Computer Science','Bachelor','Computer Science','4 years','per year','English','September',1,1,0 FROM universities WHERE slug='heidelberg-university';
INSERT IGNORE INTO programs (university_id,slug,name,degree_level,field,duration,tuition_period,language,intake_months,is_popular,is_published,data_verified) SELECT id,'heidelberg-university-business-administration-master','Business Administration','Master','Business','2 years','per year','English','September',1,1,0 FROM universities WHERE slug='heidelberg-university';
INSERT INTO university_intakes (university_id,intake_name,intake_year,start_month,is_open) SELECT u.id,'Fall',2027,'September',1 FROM universities u WHERE u.slug='heidelberg-university' AND NOT EXISTS (SELECT 1 FROM university_intakes i WHERE i.university_id=u.id AND i.intake_name='Fall' AND i.intake_year=2027);
INSERT IGNORE INTO universities (slug,name,category,city,province,short_description,website_url,country_id,data_verified,is_featured,is_published,sort_order) SELECT 'humboldt-university-of-berlin','Humboldt University of Berlin','Public','Berlin','Berlin','Sample listing - details to be verified by Seoul Educamp International.','https://www.hu-berlin.de',id,0,0,1,3 FROM countries WHERE slug='germany';
INSERT IGNORE INTO programs (university_id,slug,name,degree_level,field,duration,tuition_period,language,intake_months,is_popular,is_published,data_verified) SELECT id,'humboldt-university-of-berlin-computer-science-bachelor','Computer Science','Bachelor','Computer Science','4 years','per year','English','September',1,1,0 FROM universities WHERE slug='humboldt-university-of-berlin';
INSERT IGNORE INTO programs (university_id,slug,name,degree_level,field,duration,tuition_period,language,intake_months,is_popular,is_published,data_verified) SELECT id,'humboldt-university-of-berlin-business-administration-master','Business Administration','Master','Business','2 years','per year','English','September',1,1,0 FROM universities WHERE slug='humboldt-university-of-berlin';
INSERT INTO university_intakes (university_id,intake_name,intake_year,start_month,is_open) SELECT u.id,'Fall',2027,'September',1 FROM universities u WHERE u.slug='humboldt-university-of-berlin' AND NOT EXISTS (SELECT 1 FROM university_intakes i WHERE i.university_id=u.id AND i.intake_name='Fall' AND i.intake_year=2027);
