- 博客(1)
- 资源 (4)
- 收藏
- 关注
原创 stripe 跳转支付&支付跳转&外贸独立站
开发背景:外贸网站的第三方收款通道,可支持海外用户信用卡付款,不过影响力仍然没有Paypal大,Paypal对卖家还是客户来讲,其安全性和周转时间都比其它通道强。我们推出更加灵活安全的多号分流(q1806098280)的风控机制。开发原理:A站商品站 A2B中转站 B站合规站(普通的合规站,绑定paypal、stripe账号)客户在A站下单并提交给中转做分类权重计算分配出B...
2019-11-08 22:06:24 2191 1
area_insert_quanguo.sql
DROP TABLE IF EXISTS `area`;
CREATE TABLE `area` (
`id` bigint(20) NOT NULL COMMENT 'ID',
`name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '区域名称',
`pid` bigint(20) NOT NULL COMMENT '父ID',
`level` int(11) NOT NULL COMMENT '级别:1-省,2-市,3-区,4-乡镇',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '行政区域表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of area
-- ----------------------------
INSERT INTO `area` VALUES (110000000000, '北京市', 0, 1);
INSERT INTO `area` VALUES (110100000000, '市辖区', 110000000000, 2);
INSERT INTO `area` VALUES (110101000000, '东城区', 110100000000, 3);
INSERT INTO `area` VALUES (110101001000, '东华门街道办事处', 110101000000, 4);
INSERT INTO `area` VALUES (110101002000, '景山街道办事处', 110101000000, 4);
INSERT INTO `area` VALUES (110101003000, '交道口街道办事处', 110101000000, 4);
INSERT INTO `area` VALUES (110101004000, '安定门街道办事处', 110101000000, 4);
INSERT INTO `area` VALUES (110101005000, '北新桥街道办事处', 110101000000, 4);
INSERT INTO `area` VALUES (110101006000, '东四街道办事处', 110101000000, 4);
2021-04-27
area_insert_taiwan.sql
INSERT INTO `area` (`id`, `pid`, `name`, `level`) VALUES
(830000000000, 0, '台灣省', 1);
INSERT INTO `area` (`id`, `pid`, `name`, `level`) VALUES
(830100000000, 830000000000, '臺北市', 2),
(830200000000, 830000000000, '基隆市', 2),
(830300000000, 830000000000, '新北市', 2),
(830400000000, 830000000000, '桃園市', 2),
(830500000000, 830000000000, '新竹市', 2),
(830600000000, 830000000000, '新竹縣', 2),
(830700000000, 830000000000, '苗栗縣', 2),
(830800000000, 830000000000, '臺中市', 2),
(830900000000, 830000000000, '彰化縣', 2),
(831000000000, 830000000000, '南投縣', 2),
(831100000000, 830000000000, '雲林縣', 2),
(831200000000, 830000000000, '嘉義市', 2),
(831300000000, 830000000000, '嘉義縣', 2),
(831400000000, 830000000000, '臺南市', 2),
(831500000000, 830000000000, '高雄市', 2),
(831600000000, 830000000000, '屏東縣', 2),
(831700000000, 830000000000, '宜蘭縣', 2),
(831800000000, 830000000000, '花蓮縣', 2),
(831900000000, 830000000000, '臺東縣', 2),
(832000000000, 830000000000, '澎湖縣', 2),
(832100000000, 830000000000, '金門縣', 2),
(832200000000, 830000000000, '連江縣', 2),
(830101000000, 830100000000, '中正區', 3),
(830102000000, 830100000000, '大同區', 3),
(830103000000, 830100000000, '中山區', 3),
(830104000000, 830100000000, '松山區', 3),
(830105000000, 830100000000, '大安區', 3),
(830106000000, 830100000000, '萬華區', 3),
(830107000000, 830100000000, '信義區', 3),
(830108000000, 830100000000, '士林區', 3),
(830109000000, 830100000000, '北投區', 3),
(830110000000, 830100000000, '內湖區', 3),
(830111000000, 830100000000, '南港區', 3),
(830112000000, 830100000000, '文山區', 3),
(830201000000, 830200000000, '仁愛區', 3),
(830202000000, 830200000000, '信義區', 3),
(830203000000, 830200000000, '中正區', 3),
2021-04-27
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人