# 数据表
> 自动提现设定
```
<pre class="calibre6">```
CREATE TABLE `ims_ewei_shop_ext_autopay` <span class="token1">(</span>
`one` <span class="token3">tinyint</span><span class="token1">(</span><span class="token">4</span><span class="token1">)</span> NOT NULL DEFAULT <span class="token5">'0'</span> COMMENT <span class="token5">'一级分销商是否自动提现'</span><span class="token1">,</span>
`two` <span class="token3">tinyint</span><span class="token1">(</span><span class="token">4</span><span class="token1">)</span> NOT NULL DEFAULT <span class="token5">'0'</span> COMMENT <span class="token5">'二级分销商是否自动提现'</span><span class="token1">,</span>
`three` <span class="token3">tinyint</span><span class="token1">(</span><span class="token">4</span><span class="token1">)</span> NOT NULL DEFAULT <span class="token5">'0'</span> COMMENT <span class="token5">'三级分销商是否自动提现'</span><span class="token1">,</span>
`mchid` <span class="token3">varchar</span><span class="token1">(</span><span class="token">32</span><span class="token1">)</span> NOT NULL DEFAULT <span class="token5">''</span> COMMENT <span class="token5">'商户号'</span><span class="token1">,</span>
`mchsecret` <span class="token3">varchar</span><span class="token1">(</span><span class="token">255</span><span class="token1">)</span> NOT NULL DEFAULT <span class="token5">''</span> COMMENT <span class="token5">'商户api秘钥'</span><span class="token1">,</span>
`appid` <span class="token3">varchar</span><span class="token1">(</span><span class="token">255</span><span class="token1">)</span> NOT NULL DEFAULT <span class="token5">''</span> COMMENT <span class="token5">'公众号appid'</span><span class="token1">,</span>
`appsecret` <span class="token3">varchar</span><span class="token1">(</span><span class="token">255</span><span class="token1">)</span> NOT NULL DEFAULT <span class="token5">''</span> COMMENT <span class="token5">'公众号开发者秘钥'</span><span class="token1">,</span>
`openid` <span class="token3">varchar</span><span class="token1">(</span><span class="token">255</span><span class="token1">)</span> NOT NULL DEFAULT <span class="token5">''</span> COMMENT <span class="token5">'用于测试企业付款到零钱的会员openid'</span>
<span class="token1">)</span> ENGINE<span class="token2">=</span>InnoDB DEFAULT CHARSET<span class="token2">=</span>utf8 COMMENT<span class="token2">=</span><span class="token5">'扩展表,自动提现设定'</span><span class="token1">;</span>
INSERT INTO `shop_cztech_wang`<span class="token1">.</span>`ims_ewei_shop_ext_autopay`<span class="token1">(</span>`one`<span class="token1">,</span> `two`<span class="token1">,</span> `three`<span class="token1">,</span> `mchid`<span class="token1">,</span> `mchsecret`<span class="token1">,</span> `appid`<span class="token1">,</span> `appsecret`<span class="token1">,</span> `openid`<span class="token1">)</span> VALUES <span class="token1">(</span><span class="token">1</span><span class="token1">,</span> <span class="token">0</span><span class="token1">,</span> <span class="token">0</span><span class="token1">,</span> <span class="token5">''</span><span class="token1">,</span> <span class="token5">''</span><span class="token1">,</span> <span class="token5">''</span><span class="token1">,</span> <span class="token5">''</span><span class="token1">,</span> <span class="token5">''</span><span class="token1">)</span><span class="token1">;</span>
```
```
