gitmodir110/ifnex
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
main
ifnex/04_Laravel/database/migrations
History
Kazem Alghasi d2871ce8dd build(db): expand shipment and transaction schemas with new enums and fields 
Update database migrations to support enhanced shipment workflows,
expanded status tracking, and improved payment gateway flexibility.
Includes SQLite compatibility checks for ENUM modifications.

- Expand `shipments.status` enum to include `pending_approval`,
  `approved`, `pending_payment`, `cancelled`, and `archived`.
- Add `reason` column to `shipment_status_history` for better audit trails.
- Add missing address and description fields to `shipments` table.
- Add `wallet` to `wallet_transactions.gateway` enum.
- Add `system` and `customer` to `shipment_tracking_events.source` enum.
- Implement SQLite driver checks in migrations to prevent errors during
  testing/local development.
2026-09-10 04:09:44 +03:30
..
0001_01_01_000000_create_users_table.php feat: Complete Phase 1 core logic and WP bridge setup 2026-08-01 04:01:22 +03:30
0001_01_01_000001_create_cache_table.php feat: Complete Phase 1 core logic and WP bridge setup 2026-08-01 04:01:22 +03:30
0001_01_01_000002_create_jobs_table.php feat: Complete Phase 1 core logic and WP bridge setup 2026-08-01 04:01:22 +03:30
2026_08_02_000001_create_countries_table.php ✅ ۱۰ مورد کامل شد (دیتابیس، مدل‌ها، API، Filament، Laravel 11، رفع باگ‌ها) 2026-08-04 01:59:08 +03:30
2026_08_02_000002_create_shipments_table.php ✅ ۱۰ مورد کامل شد (دیتابیس، مدل‌ها، API، Filament، Laravel 11، رفع باگ‌ها) 2026-08-04 01:59:08 +03:30
2026_08_02_000003_create_shipping_rates_table.php ✅ ۱۰ مورد کامل شد (دیتابیس، مدل‌ها، API، Filament، Laravel 11، رفع باگ‌ها) 2026-08-04 01:59:08 +03:30
2026_08_02_000004_create_shipment_carrier_mappings_table.php ✅ ۱۰ مورد کامل شد (دیتابیس، مدل‌ها، API، Filament، Laravel 11، رفع باگ‌ها) 2026-08-04 01:59:08 +03:30
2026_08_02_000005_create_shipment_tracking_events_table.php ✅ ۱۰ مورد کامل شد (دیتابیس، مدل‌ها، API، Filament، Laravel 11، رفع باگ‌ها) 2026-08-04 01:59:08 +03:30
2026_08_02_000006_create_system_settings_table.php ✅ ۱۰ مورد کامل شد (دیتابیس، مدل‌ها، API، Filament، Laravel 11، رفع باگ‌ها) 2026-08-04 01:59:08 +03:30
2026_08_02_000007_update_users_table.php ✅ ۱۰ مورد کامل شد (دیتابیس، مدل‌ها، API، Filament، Laravel 11، رفع باگ‌ها) 2026-08-04 01:59:08 +03:30
2026_08_05_135016_create_wallets_table.php feat(wallet): complete wallet system with admin adjust, freeze/unfreeze, activity logs 2026-08-07 22:51:42 +03:30
2026_08_05_135022_create_wallet_transactions_table.php feat(wallet): complete wallet system with admin adjust, freeze/unfreeze, activity logs 2026-08-07 22:51:42 +03:30
2026_08_05_135026_create_discount_codes_table.php feat(finance): implement Filament admin panel and expand wallet/discount features 2026-08-08 03:15:51 +03:30
2026_08_05_140000_create_payments_table.php feat(api): implement payment gateway integration 2026-08-05 23:49:33 +03:30
2026_08_07_000001_create_wallet_activity_logs_table.php feat(wallet): complete wallet system with admin adjust, freeze/unfreeze, activity logs 2026-08-07 22:51:42 +03:30
2026_08_07_033748_create_personal_access_tokens_table.php feat(wallet): complete wallet system with admin adjust, freeze/unfreeze, activity logs 2026-08-07 22:51:42 +03:30
2026_08_08_000001_create_shipment_items_table.php feat(laravel): implement user synchronization and shipment schema 2026-08-08 04:58:01 +03:30
2026_08_08_000001_fix_discount_codes_type_enum.php feat(laravel): implement user synchronization and shipment schema 2026-08-08 04:58:01 +03:30
2026_08_09_012526_create_notifications_table.php feat(admin): configure filament panel with custom branding and notifications 2026-08-09 05:14:36 +03:30
2026_08_09_220409_create_permission_tables.php feat(auth): implement role-based access control using spatie/laravel-permission 2026-08-10 02:44:23 +03:30
2026_08_09_231738_create_exchange_rate_history_table.php feat(exchange): implement exchange rate history tracking 2026-08-10 03:04:18 +03:30
2026_08_10_020410_update_shipments_status_enum.php build(db): expand shipment and transaction schemas with new enums and fields 2026-09-10 04:09:44 +03:30
2026_08_10_080853_add_wallet_to_payment_gateway_enum.php build(db): expand shipment and transaction schemas with new enums and fields 2026-09-10 04:09:44 +03:30
2026_08_10_082121_add_system_to_tracking_source_enum.php build(db): expand shipment and transaction schemas with new enums and fields 2026-09-10 04:09:44 +03:30
2026_08_24_000001_add_missing_fields_to_shipments_table.php build(db): expand shipment and transaction schemas with new enums and fields 2026-09-10 04:09:44 +03:30
2026_08_24_100001_create_currencies_table.php feat(admin): implement currency management and rate import system 2026-08-24 01:18:34 +03:30
2026_08_24_200001_create_shipment_packages_table.php feat(shipment): add multi-package support and AWB integration 2026-08-24 01:47:45 +03:30
2026_08_24_300001_create_shipment_status_histories_table.php feat(shipment): implement status history tracking and rate import improvements 2026-08-24 03:40:13 +03:30
2026_08_28_233839_add_calling_code_to_countries_table.php feat(core): complete phase 3 integration and enhance country/phone features 2026-08-29 04:38:28 +03:30
2026_08_29_021506_fix_shipment_items_table.php - Add picqer/php-barcode-generator dependency 2026-08-29 06:40:08 +03:30
2026_08_29_021631_make_name_nullable_in_shipment_items.php - Add picqer/php-barcode-generator dependency 2026-08-29 06:40:08 +03:30
2026_09_03_000001_add_approval_statuses_to_shipments_table.php build(db): expand shipment and transaction schemas with new enums and fields 2026-09-10 04:09:44 +03:30
2026_09_03_000002_create_commitment_forms_table.php feat(core): implement order approval flow, credit system, and import invoicing 2026-09-03 06:04:20 +03:30
2026_09_03_000003_add_credit_fields_to_users_table.php feat(core): implement order approval flow, credit system, and import invoicing 2026-09-03 06:04:20 +03:30
2026_09_03_000004_create_shipment_checklists_table.php feat(core): implement order approval flow, credit system, and import invoicing 2026-09-03 06:04:20 +03:30
2026_09_03_000005_create_audit_logs_table.php feat(core): implement order approval flow, credit system, and import invoicing 2026-09-03 06:04:20 +03:30
2026_09_03_000006_add_import_invoice_fields_to_shipments_table.php feat(core): implement order approval flow, credit system, and import invoicing 2026-09-03 06:04:20 +03:30
2026_09_09_000001_create_shipment_commitment_forms_table.php feat(api): implement shipment commitment forms and document downloads 2026-09-09 13:08:22 +03:30
2026_09_09_000002_create_shipment_status_history_table.php feat(core): integrate Kavenegar SMS notifications and audit logging 2026-09-10 00:52:18 +03:30
2026_09_09_000003_add_reason_to_shipment_status_history_table.php build(db): expand shipment and transaction schemas with new enums and fields 2026-09-10 04:09:44 +03:30