-- Shopro 阿里云快递查询插件

CREATE TABLE IF NOT EXISTS `__PREFIX__shopro_aliyun_express_config` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `value` text,
  `description` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='阿里云快递查询配置';

CREATE TABLE IF NOT EXISTS `__PREFIX__shopro_aliyun_express_query_log` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `provider` varchar(32) NOT NULL DEFAULT '',
  `waybill_number` varchar(64) NOT NULL DEFAULT '',
  `phone` varchar(20) NOT NULL DEFAULT '',
  `express_code` varchar(32) NOT NULL DEFAULT '',
  `status_code` int(11) NOT NULL DEFAULT 0,
  `success` tinyint(1) NOT NULL DEFAULT 0,
  `message` varchar(255) NOT NULL DEFAULT '',
  `duration_ms` int(11) NOT NULL DEFAULT 0,
  `createtime` int(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `waybill_number` (`waybill_number`),
  KEY `createtime` (`createtime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='快递查询日志';

INSERT IGNORE INTO `__PREFIX__shopro_aliyun_express_config` (`name`, `value`, `description`) VALUES
('express_enable', '1', '快递查询总开关'),
('express_provider', 'aliyun', '查询Provider: aliyun/kdniao/expressbird'),
('aliyun_appcode', '', '阿里云APPCODE'),
('aliyun_api_url', '', '阿里云查询完整URL，从云市场API调试复制'),
('aliyun_api_mode', 'auto', '接口模板 auto/expr_post/expr_get/wuliu_kdi'),
('aliyun_http_method', 'auto', 'HTTP方法 auto/get/post'),
('expressbird_appcode', '', 'ExpressBird APPCODE'),
('cache_ttl', '300', '轨迹缓存秒数');