INSERT INTO tenants (id, name, slug, plan, status) VALUES (1,'Travelingo Admin','admin','business','active'),(2,'Joe Demo','joe-demo','pro','active');

INSERT INTO languages (id, code, name, native_name) VALUES
(1,'el','Greek','Ελληνικά'),(2,'es','Spanish','Español'),(3,'fr','French','Français'),(4,'it','Italian','Italiano'),(5,'de','German','Deutsch');

INSERT INTO phrase_categories (id, slug, name, sort_order) VALUES
(1,'survival','Survival Basics',1),(2,'airport','Airport',2),(3,'hotel','Hotel',3),(4,'food','Food & Drink',4),(5,'transport','Transport',5),(6,'emergency','Emergency',6),(7,'social','Social',7),(8,'nightlife','Nightlife',8),(9,'shopping','Shopping',9);

INSERT INTO phrases (language_id,category_id,english_uk,translated,phonetic,difficulty) VALUES
(1,1,'Hello','Γεια σας','YAH sas','survival'),(1,1,'Please','Παρακαλώ','pa-ra-ka-LO','survival'),(1,1,'Thank you','Ευχαριστώ','ef-ha-ri-STO','survival'),(1,1,'Sorry, I do not speak much Greek','Συγγνώμη, δεν μιλάω πολύ ελληνικά','see-GNO-mee, then mee-LA-o po-LEE el-li-ni-KA','easy'),
(1,4,'Can I have a coffee, please?','Μπορώ να έχω έναν καφέ, παρακαλώ;','bo-RO na E-ho EN-an ka-FE pa-ra-ka-LO','easy'),(1,4,'The bill, please','Τον λογαριασμό, παρακαλώ','ton lo-gha-ria-ZMO pa-ra-ka-LO','easy'),(1,5,'Where is the bus stop?','Πού είναι η στάση λεωφορείου;','poo EE-ne ee STA-see le-o-fo-REE-ou','easy'),(1,6,'I need a pharmacy','Χρειάζομαι φαρμακείο','hree-A-zo-me far-ma-KEE-o','easy'),
(2,1,'Hello','Hola','OH-la','survival'),(2,4,'The bill, please','La cuenta, por favor','la KWEN-ta por fa-VOR','easy'),(3,1,'Hello','Bonjour','bon-ZHOOR','survival'),(3,4,'The bill, please','L’addition, s’il vous plaît','la-dee-SYON seel voo PLEH','easy'),(4,1,'Hello','Ciao','CHOW','survival'),(4,4,'The bill, please','Il conto, per favore','eel KON-to per fa-VO-re','easy'),(5,1,'Hello','Hallo','HA-lo','survival'),(5,4,'The bill, please','Die Rechnung, bitte','dee REKH-noong BIT-te','easy');

INSERT INTO badges (slug,name,description,xp_reward) VALUES
('first-trip','First Trip','Created your first travel plan',25),('coffee-ready','Coffee Ready','Completed key food and drink phrases',25),('survival-ready','Survival Ready','Completed survival basics',50),('landed-mode','Landed Mode','Opened the companion mode while travelling',10);

INSERT INTO trips (tenant_id,user_id,destination_country,destination_city,language_id,departure_date,trip_length,purpose) VALUES
(2,2,'Greece','Thessaloniki',1,'2026-06-20','1 Week','Holiday');
