# Production Windows server — XAMPP DEPLOY_HOST="207.231.110.240" DEPLOY_USER="Administrator" DEPLOY_PORT="22" # Laravel app root (rsync target — OpenSSH/cwRsync path) DEPLOY_PATH="/cygdrive/c/xampp/htdocs/addfirst/main_files/main_files" # Native Windows paths DEPLOY_PATH_WIN="C:/xampp/htdocs/addfirst/main_files/main_files" WEB_ROOT_PATH_WIN="C:/xampp/htdocs/addfirst" PHP_BINARY_WIN="C:/xampp/php/php.exe" MYSQL_BIN_WIN="C:/xampp/mysql/bin" XAMPP_ROOT_WIN="C:/xampp" # --- SSH key --- SSH_KEY_PATH="deploy/keys/deploy_ed25519" SSH_KNOWN_HOSTS="deploy/keys/known_hosts" # --- Build (Ubuntu, before rsync) --- RUN_BUILD="true" COMPOSER_BIN="composer" NODE_BIN="npm" SKIP_COMPOSER_DEV="true" SKIP_FRONTEND_BUILD="true" LOCAL_MYSQLDUMP_BIN="/opt/lampp/bin/mysqldump" # --- Rsync (files) --- RSYNC_DELETE="true" RSYNC_COMPRESS="true" DRY_RUN="false" # --- Protected on production (never overwrite) --- PROTECTED_ENV_FILES=".env .env.production .env.local" # --- File backup on Windows before deploy --- BACKUP_ENABLED="true" BACKUP_DIR="deploy-backups" BACKUP_KEEP="5" # --- DATABASE: migrations (schema) — runs on every ./deploy.sh --- RUN_REMOTE_MIGRATIONS="true" REMOTE_DB_BACKUP_BEFORE_MIGRATE="true" REMOTE_DB_HOST="127.0.0.1" REMOTE_DB_PORT="3306" REMOTE_DB_DATABASE="aadfirst_laravel" REMOTE_DB_USERNAME="root" REMOTE_DB_PASSWORD="" # --- DATABASE: reference data (rows) — categorii, locații, meniuri, facilități, etc. --- # NU înlocuiește baza de date completă. Doar tabelele de mai jos: # - adaugă rânduri noi de pe Ubuntu (ex: subcategorie nouă, facilitate nouă) # - actualizează rânduri cu același ID (nume, slug, status, booking_enabled, etc.) # - NU șterge utilizatori, anunțuri, comenzi (tabelele lor nu sunt listate) # - rânduri create doar pe producție (ID inexistent local) rămân neschimbate # IMPORTANT: modificările din Admin → Categorii / Subcategorii / Facilități sunt în DB, # nu în fișiere — fără aceste tabele, ./deploy.sh nu le propagă pe producție. # NOTĂ: tabelul `categories` este EXCLUS din sync — câmpurile status, show_on_homepage # și homepage_sort_order se setează separat pe fiecare mediu (local vs producție). # Altfel deploy rescrie statusul Magazin din baza locală. DB_SYNC_REFERENCE_DATA="true" DB_SYNC_TABLES="category_translations,sub_categories,sub_category_translations,child_categories,child_category_translations,features,feature_translations,cities,city_translations,city_districts,city_district_translations,counties,county_translations,menus,menu_item_translations,menu_translations" # --- Cache clear on production after deploy --- RUN_REMOTE_CACHE_CLEAR="true" # Sync CSS/JS to S3/CDN after deploy (incremental; set false to skip if deploy seems stuck) RUN_CDN_STATIC_SYNC="true" REMOTE_POST_DEPLOY=""