~~~[sql] CREATE TABLE `xi_express` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `dealer_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '商家ID', `stores_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '門店ID', `name` varchar(16) NOT NULL DEFAULT '' COMMENT '名稱', `express_shipper_code` varchar(16) NOT NULL DEFAULT '' COMMENT '快遞公司編碼', `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`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='快遞'; ~~~ ~~~[sql] CREATE TABLE `xi_express_price` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `express_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '快遞ID', `province` varchar(16) NOT NULL DEFAULT '0' COMMENT '省份', `pricing_manner` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '計價方式，0=>按件，1=>按重量', `first` int(11) unsigned NOT NULL DEFAULT '1' COMMENT '首件件數（首重重量）', `first_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '首件價格（首重價格）', `next` int(11) unsigned NOT NULL DEFAULT '1' COMMENT '續件件數（續重重量）', `next_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '續件價格（續重價格）', `is_default` tinyint(1) 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`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='快遞價格'; ~~~