carts
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