CREATE TABLE `orders` (
                         `id` int NOT NULL,
                         `reference_cmd` BIGINT NOT NULL,
                         `created_at` datetime DEFAULT NULL,
                         `updated_at` datetime DEFAULT NULL,
                         `email` varchar(100) DEFAULT NULL,
                         `first_name` varchar(100) DEFAULT NULL,
                         `last_name` varchar(100) DEFAULT NULL,
                         `quantity` int DEFAULT NULL,
                         `delivery_type` varchar(15) DEFAULT NULL,
                         `address_line_1` varchar(255) DEFAULT NULL,
                         `address_line_2` varchar(255) DEFAULT NULL,
                         `city` varchar(255) DEFAULT NULL,
                         `region` varchar(255) DEFAULT NULL,
                         `postal_code` varchar(255) DEFAULT NULL,
                         `country` varchar(255) DEFAULT NULL,
                         `instructions` text DEFAULT NULL,
                         `phone` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

ALTER TABLE `orders` ADD INDEX(`id`);
ALTER TABLE `orders` CHANGE `id` `id` INT NOT NULL AUTO_INCREMENT;
ALTER TABLE `orders` ADD UNIQUE(`id`);