/*
Navicat MySQL Data Transfer
Source Server : yupinhui
Source Server Version : 50621
Source Host : 106.14.219.221:3306
Source Database : yupinhui
Target Server Type : MYSQL
Target Server Version : 50621
File Encoding : 65001
Date: 2018-08-10 17:14:08
*/
SET FOREIGN_KEY_CHECKS=0;
– Table structure for yph_express
DROP TABLE IF EXISTS yph_express
;
CREATE TABLE yph_express
(
express_id
tinyint(1) unsigned NOT NULL AUTO_INCREMENT COMMENT ‘快递公司自增ID’,
express_name
varchar(50) NOT NULL COMMENT ‘快递公司名称’,
express_state
enum(‘0’,’1’) NOT NULL DEFAULT ‘1’ COMMENT ‘快递公司状态’,
express_code
varchar(50) NOT NULL COMMENT ‘快递公司编号’,
express_letter
char(1) NOT NULL COMMENT ‘快递公司首字母’,
express_order
enum(‘1’,’2’) NOT NULL DEFAULT ‘2’ COMMENT ‘1:常用2:不常用’,
express_url
varchar(100) NOT NULL COMMENT ‘快递公司网址’,
express_zt_state
tinyint(4) DEFAULT ‘0’ COMMENT ‘是否支持服务站配送0否1是’,
is_del
int(11) NOT NULL DEFAULT ‘1’ COMMENT ‘0 删除 1 正常’,
PRIMARY KEY (express_id
)
) ENGINE=InnoDB AUTO_INCREMENT=119 DEFAULT CHARSET=utf8 COMMENT=’快递公司’;
– Records of yph_express
INSERT INTO yph_express
VALUES (‘1’, ‘顺丰’, ‘1’, ‘SF’, ‘S’, ‘1’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘2’, ‘中通’, ‘1’, ‘ZTO’, ‘Z’, ‘1’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘3’, ‘申通’, ‘1’, ‘STO’, ‘S’, ‘1’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘4’, ‘圆通’, ‘1’, ‘YTO’, ‘Y’, ‘1’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘5’, ‘韵达’, ‘1’, ‘YD’, ‘Y’, ‘1’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘6’, ‘邮政平邮’, ‘1’, ‘YZPY’, ‘Y’, ‘1’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘7’, ‘全峰’, ‘1’, ‘QFKD’, ‘Q’, ‘1’, ‘###’, ‘0’, ‘0’);
INSERT INTO yph_express
VALUES (‘8’, ‘国通’, ‘1’, ‘GTO’, ‘G’, ‘1’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘9’, ‘优速’, ‘1’, ‘UC’, ‘Y’, ‘1’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘10’, ‘快捷’, ‘1’, ‘FAST’, ‘K’, ‘1’, ‘###’, ‘0’, ‘0’);
INSERT INTO yph_express
VALUES (‘11’, ‘亚马逊’, ‘1’, ‘AMAZON’, ‘Y’, ‘1’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘12’, ‘安捷快递’, ‘1’, ‘AJ’, ‘A’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘13’, ‘亚马逊物流’, ‘1’, ‘AMAZON’, ‘Y’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘14’, ‘安能物流’, ‘1’, ‘ANE’, ‘A’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘15’, ‘安信达快递’, ‘1’, ‘AXD’, ‘A’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘16’, ‘澳邮专线’, ‘1’, ‘AYCA’, ‘A’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘17’, ‘北青小红帽’, ‘1’, ‘BQXHM’, ‘B’, ‘2’, ‘###’, ‘0’, ‘0’);
INSERT INTO yph_express
VALUES (‘18’, ‘百福东方’, ‘1’, ‘BFDF’, ‘B’, ‘2’, ‘###’, ‘0’, ‘0’);
INSERT INTO yph_express
VALUES (‘19’, ‘百世快运’, ‘1’, ‘BTWL’, ‘B’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘20’, ‘CCES快递’, ‘1’, ‘CCES’, ‘C’, ‘2’, ‘###’, ‘0’, ‘0’);
INSERT INTO yph_express
VALUES (‘21’, ‘城市100’, ‘1’, ‘CITY100’, ‘C’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘22’, ‘城际快递’, ‘1’, ‘CJKD’, ‘C’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘23’, ‘CNPEX中邮快递’, ‘1’, ‘CNPEX’, ‘C’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘24’, ‘COE东方快递’, ‘1’, ‘COE’, ‘C’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘25’, ‘长沙创一’, ‘1’, ‘CSCY’, ‘C’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘26’, ‘成都善途速运’, ‘1’, ‘CDSTKY’, ‘C’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘27’, ‘联合运通’, ‘1’, ‘CTG’, ‘L’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘28’, ‘德邦’, ‘1’, ‘DBL’, ‘D’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘29’, ‘D速物流’, ‘1’, ‘DSWL’, ‘D’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘30’, ‘大田物流’, ‘1’, ‘DTWL’, ‘D’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘31’, ‘EMS’, ‘1’, ‘EMS’, ‘E’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘32’, ‘快捷速递’, ‘1’, ‘FAST’, ‘K’, ‘2’, ‘###’, ‘0’, ‘0’);
INSERT INTO yph_express
VALUES (‘33’, ‘FEDEX联邦(国内件)’, ‘1’, ‘FEDEX’, ‘F’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘34’, ‘FEDEX联邦(国际件)’, ‘1’, ‘FEDEX_GJ’, ‘F’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘35’, ‘飞康达’, ‘1’, ‘FKD’, ‘F’, ‘2’, ‘###’, ‘0’, ‘0’);
INSERT INTO yph_express
VALUES (‘36’, ‘广东邮政’, ‘1’, ‘GDEMS’, ‘G’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘37’, ‘共速达’, ‘1’, ‘GSD’, ‘G’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘38’, ‘国通快递’, ‘1’, ‘GTO’, ‘G’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘39’, ‘高铁速递’, ‘1’, ‘GTSD’, ‘G’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘40’, ‘汇丰物流’, ‘1’, ‘HFWL’, ‘H’, ‘2’, ‘###’, ‘0’, ‘0’);
INSERT INTO yph_express
VALUES (‘41’, ‘天天快递’, ‘1’, ‘HHTT’, ‘T’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘42’, ‘恒路物流’, ‘1’, ‘HLWL’, ‘H’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘43’, ‘天地华宇’, ‘1’, ‘HOAU’, ‘T’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘44’, ‘鸿桥供应链’, ‘1’, ‘HOTSCM’, ‘H’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘45’, ‘海派通物流公司’, ‘1’, ‘HPTEX’, ‘H’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘46’, ‘华强物流’, ‘1’, ‘hq568’, ‘H’, ‘2’, ‘###’, ‘0’, ‘0’);
INSERT INTO yph_express
VALUES (‘47’, ‘百世快递’, ‘1’, ‘HTKY’, ‘B’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘48’, ‘华夏龙物流’, ‘1’, ‘HXLWL’, ‘H’, ‘2’, ‘###’, ‘0’, ‘0’);
INSERT INTO yph_express
VALUES (‘49’, ‘好来运快递’, ‘1’, ‘HYLSD’, ‘H’, ‘2’, ‘###’, ‘0’, ‘0’);
INSERT INTO yph_express
VALUES (‘50’, ‘京东’, ‘1’, ‘JD’, ‘J’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘51’, ‘京广速递’, ‘1’, ‘JGSD’, ‘J’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘52’, ‘九曳供应链’, ‘1’, ‘JIUYE’, ‘J’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘53’, ‘佳吉快运’, ‘1’, ‘JJKY’, ‘J’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘54’, ‘嘉里物流’, ‘1’, ‘JLDT’, ‘J’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘55’, ‘捷特快递’, ‘1’, ‘JTKD’, ‘J’, ‘2’, ‘###’, ‘0’, ‘0’);
INSERT INTO yph_express
VALUES (‘56’, ‘急先达’, ‘1’, ‘JXD’, ‘J’, ‘2’, ‘###’, ‘0’, ‘0’);
INSERT INTO yph_express
VALUES (‘57’, ‘晋越快递’, ‘1’, ‘JYKD’, ‘J’, ‘2’, ‘###’, ‘0’, ‘0’);
INSERT INTO yph_express
VALUES (‘58’, ‘加运美’, ‘1’, ‘JYM’, ‘J’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘59’, ‘佳怡物流’, ‘1’, ‘JYWL’, ‘J’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘60’, ‘跨越速运’, ‘1’, ‘KYSY’, ‘K’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘61’, ‘龙邦快递’, ‘1’, ‘LB’, ‘L’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘62’, ‘联昊通速递’, ‘1’, ‘LHT’, ‘L’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘63’, ‘民邦快递’, ‘1’, ‘MB’, ‘M’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘64’, ‘民航快递’, ‘1’, ‘MHKD’, ‘M’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘65’, ‘明亮物流’, ‘1’, ‘MLWL’, ‘M’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘66’, ‘南方’, ‘1’, ‘NF’, ‘N’, ‘2’, ‘###’, ‘0’, ‘0’);
INSERT INTO yph_express
VALUES (‘67’, ‘能达速递’, ‘1’, ‘NEDA’, ‘N’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘68’, ‘平安达腾飞快递’, ‘1’, ‘PADTF’, ‘P’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘69’, ‘泛捷快递’, ‘1’, ‘PANEX’, ‘F’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘70’, ‘品骏’, ‘1’, ‘PJ’, ‘P’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘71’, ‘PCA Express’, ‘1’, ‘PCA’, ‘P’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘72’, ‘全晨快递’, ‘1’, ‘QCKD’, ‘Q’, ‘2’, ‘###’, ‘0’, ‘0’);
INSERT INTO yph_express
VALUES (‘73’, ‘全峰快递’, ‘1’, ‘QFKD’, ‘Q’, ‘2’, ‘###’, ‘0’, ‘0’);
INSERT INTO yph_express
VALUES (‘74’, ‘全日通快递’, ‘1’, ‘QRT’, ‘Q’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘75’, ‘全信通’, ‘1’, ‘QXT’, ‘Q’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘76’, ‘如风达’, ‘1’, ‘RFD’, ‘R’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘77’, ‘瑞丰速递’, ‘1’, ‘RFEX’, ‘R’, ‘2’, ‘###’, ‘0’, ‘0’);
INSERT INTO yph_express
VALUES (‘78’, ‘赛澳递’, ‘1’, ‘SAD’, ‘S’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘79’, ‘圣安物流’, ‘1’, ‘SAWL’, ‘S’, ‘2’, ‘###’, ‘0’, ‘0’);
INSERT INTO yph_express
VALUES (‘80’, ‘盛邦物流’, ‘1’, ‘SBWL’, ‘S’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘81’, ‘上大物流’, ‘1’, ‘SDWL’, ‘S’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘82’, ‘顺丰快递’, ‘1’, ‘SF’, ‘S’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘83’, ‘盛丰物流’, ‘1’, ‘SFWL’, ‘S’, ‘2’, ‘###’, ‘0’, ‘0’);
INSERT INTO yph_express
VALUES (‘84’, ‘盛辉物流’, ‘1’, ‘SHWL’, ‘S’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘85’, ‘速通物流’, ‘1’, ‘ST’, ‘S’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘86’, ‘速腾快递’, ‘1’, ‘STWL’, ‘S’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘87’, ‘速必达物流’, ‘1’, ‘SUBIDA’, ‘S’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘88’, ‘速尔快递’, ‘1’, ‘SURE’, ‘S’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘89’, ‘天天’, ‘1’, ‘HHTT’, ‘T’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘90’, ‘全一快递’, ‘1’, ‘UAPEX’, ‘Q’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘91’, ‘UEQ Express’, ‘1’, ‘UEQ’, ‘U’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘92’, ‘优速快递’, ‘1’, ‘UC’, ‘Y’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘93’, ‘万家物流’, ‘1’, ‘WJWL’, ‘W’, ‘2’, ‘###’, ‘0’, ‘0’);
INSERT INTO yph_express
VALUES (‘94’, ‘万象物流’, ‘1’, ‘WXWL’, ‘W’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘95’, ‘新邦物流’, ‘1’, ‘XBWL’, ‘X’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘96’, ‘信丰快递’, ‘1’, ‘XFEX’, ‘X’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘97’, ‘希优特’, ‘1’, ‘XYT’, ‘X’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘98’, ‘新杰物流’, ‘1’, ‘XJ’, ‘X’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘99’, ‘源安达快递’, ‘1’, ‘YADEX’, ‘Y’, ‘2’, ‘###’, ‘0’, ‘0’);
INSERT INTO yph_express
VALUES (‘100’, ‘远成物流’, ‘1’, ‘YCWL’, ‘Y’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘101’, ‘韵达快递’, ‘1’, ‘YD’, ‘Y’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘102’, ‘义达国际物流’, ‘1’, ‘YDH’, ‘Y’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘103’, ‘越丰物流’, ‘1’, ‘YFEX’, ‘Y’, ‘2’, ‘###’, ‘0’, ‘0’);
INSERT INTO yph_express
VALUES (‘104’, ‘原飞航物流’, ‘1’, ‘YFHEX’, ‘Y’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘105’, ‘亚风快递’, ‘1’, ‘YFSD’, ‘Y’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘106’, ‘运通快递’, ‘1’, ‘YTKD’, ‘Y’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘107’, ‘圆通速递’, ‘1’, ‘YTO’, ‘Y’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘108’, ‘亿翔快递’, ‘1’, ‘YXKD’, ‘Y’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘109’, ‘运东西’, ‘1’, ‘YUNDX’, ‘Y’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘110’, ‘邮政平邮/小包’, ‘1’, ‘YZPY’, ‘Y’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘111’, ‘增益快递’, ‘1’, ‘ZENY’, ‘Z’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘112’, ‘汇强快递’, ‘1’, ‘ZHQKD’, ‘H’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘113’, ‘宅急送’, ‘1’, ‘ZJS’, ‘Z’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘114’, ‘众通快递’, ‘1’, ‘ZTE’, ‘Z’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘115’, ‘中铁快运’, ‘1’, ‘ZTKY’, ‘Z’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘116’, ‘中通速递’, ‘1’, ‘ZTO’, ‘Z’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘117’, ‘中铁物流’, ‘1’, ‘ZTWL’, ‘Z’, ‘2’, ‘###’, ‘0’, ‘1’);
INSERT INTO yph_express
VALUES (‘118’, ‘中邮物流’, ‘1’, ‘ZYWL’, ‘Z’, ‘2’, ‘###’, ‘0’, ‘0’);