File manager - Edit - /home/webapp69.cm.in.th/u69319090039/Shop39/database/migrations/20260808_create_shipment_events.sql
Back
-- Migration for shipment_events CREATE TABLE IF NOT EXISTS shipment_events ( id INT AUTO_INCREMENT PRIMARY KEY, shipment_id INT NOT NULL, status ENUM( 'preparing','packing','packed','await_pickup','picked_up','in_transit','out_for_delivery','delivered','failed','returned','canceled' ) NOT NULL, description VARCHAR(255) NULL, event_time DATETIME DEFAULT CURRENT_TIMESTAMP, created_by INT NOT NULL, CONSTRAINT fk_event_shipment FOREIGN KEY (shipment_id) REFERENCES shipments(id) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
| ver. 1.4 |
Github
|
.
| PHP 7.4.33 | Generation time: 0.23 |
proxy
|
phpinfo
|
Settings