carts

 avatar
iamvu
mysql
3 months ago
561 B
8
Indexable
CREATE TABLE `carts` (
    `id` BIGINT(20) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    `user_id` BIGINT(20) UNSIGNED DEFAULT NULL,
    `cart_session` VARCHAR(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `sku` VARCHAR(50) COLLATE utf8mb4_general_ci NOT NULL,
    `quantity` INT(10) UNSIGNED NOT NULL DEFAULT 1,
    `price` DECIMAL(10,2) NOT NULL,
    `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
Editor is loading...
Leave a Comment