~~~[sql] CREATE TABLE `xi_cart` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `member_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '會員ID', `stores_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '門店ID', `goods_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '商品ID', `sku_key` varchar(32) DEFAULT NULL COMMENT '存放SKU庫存量項目ID進行拼接', `number` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '購買數量', `selected` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否選中，0=>未選中，1=>已選中', `sort` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '排序', `is_trash` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '刪除，0=>否，1=>是', `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '狀態，0=>禁用，1=>啟用', `created_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '創建時間', `updated_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '更新時間', PRIMARY KEY (`id`), UNIQUE KEY `goods` (`member_id`,`goods_id`,`sku_key`,`is_trash`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='購物車'; ~~~