File manager - Edit - /home/webapp69.cm.in.th/u69319090039/Shop39/database/migrations/20260808_create_shipments_table.sql
Back
-- Migration: create shipments table CREATE TABLE IF NOT EXISTS shipments ( id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY, order_id INT UNSIGNED NOT NULL, carrier_id INT UNSIGNED NULL, tracking_number VARCHAR(100) NULL, status ENUM('awaiting_payment','paid','preparing','packed','ready_for_pickup','picked_up','in_transit','delivering','delivered','failed','returned','cancelled') NOT NULL DEFAULT 'awaiting_payment', picked_up_at TIMESTAMP NULL, delivered_at TIMESTAMP NULL, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, FOREIGN KEY (order_id) REFERENCES orders(id) ON DELETE CASCADE, FOREIGN KEY (carrier_id) REFERENCES carriers(id) ON DELETE SET NULL, INDEX idx_shipments_status (status), INDEX idx_shipments_tracking (tracking_number) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
| ver. 1.4 |
Github
|
.
| PHP 7.4.33 | Generation time: 0.24 |
proxy
|
phpinfo
|
Settings