~~~[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='快递价格'; ~~~