7-12.开启使用渠道ID没有淘口令解决方法 · 老虎淘宝客2020最新最全教程中心

1、复制下方SQL语句 2、打开登录微擎后台－站点－数据库－运行SQL－把复制的语句粘贴到SQL栏框内－然后点击下边的“运行SQL” ALTER TABLE`ims_tiger_app_tuanzhangset`MODIFY COLUMN`ordermsum`varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' AFTER`fsm`; ALTER TABLE`ims_tiger_newhu_appdh`MODIFY COLUMN`title`varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '名称' AFTER`type`; ALTER TABLE`ims_tiger_newhu_appdh`MODIFY COLUMN`ftitle`varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '副名称' AFTER`title`; ALTER TABLE`ims_tiger_newhu_appdh`MODIFY COLUMN`hd`varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '1聚划算 2淘抢购 3秒杀 4 叮咚抢 5 视频单 6品牌团 7官方推荐 8好券直播 9小编力荐' AFTER`ftitle`; ALTER TABLE`ims_tiger_newhu_appdh`MODIFY COLUMN`fqcat`int(11) NULL DEFAULT 0 COMMENT '商品分类ID' AFTER`hd`; ALTER TABLE`ims_tiger_newhu_appdh`MODIFY COLUMN`flname`varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '分类名称' AFTER`fqcat`; ALTER TABLE`ims_tiger_newhu_appdh`MODIFY COLUMN`pic`varchar(250) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' AFTER`flname`; ALTER TABLE`ims_tiger_newhu_appdh`MODIFY COLUMN`apppage1`varchar(1000) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT NULL AFTER`pic`; ALTER TABLE`ims_tiger_newhu_appdh`MODIFY COLUMN`apppage2`varchar(1000) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' AFTER`apppage1`; ALTER TABLE`ims_tiger_newhu_appdh`MODIFY COLUMN`url`varchar(1000) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' AFTER`apppage2`; ALTER TABLE`ims_tiger_newhu_appdh`MODIFY COLUMN`h5title`varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '网页标题' AFTER`url`; ALTER TABLE`ims_tiger_newhu_appdh`MODIFY COLUMN`createtime`int(10) NOT NULL AFTER`h5title`; ALTER TABLE`ims_tiger_newhu_appdh`MODIFY COLUMN`itemid`varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '商品ID' AFTER`createtime`; ALTER TABLE`ims_tiger_newhu_appset`MODIFY COLUMN`appid`varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT NULL COMMENT 'APP的APPID' AFTER`weid`; ALTER TABLE`ims_tiger_newhu_appset`MODIFY COLUMN`mchid`varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT NULL COMMENT '商户号' AFTER`appid`; ALTER TABLE`ims_tiger_newhu_appset`MODIFY COLUMN`jiamistr`varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT NULL COMMENT '加密字符' AFTER`mchid`; ALTER TABLE`ims_tiger_newhu_appset`MODIFY COLUMN`appzfip`varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT NULL COMMENT 'IP' AFTER`jiamistr`; ALTER TABLE`ims_tiger_newhu_appset`MODIFY COLUMN`appfximg`varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '' AFTER`appzfip`; ALTER TABLE`ims_tiger_newhu_appset`MODIFY COLUMN`appfxtitle`varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '' AFTER`appfximg`; ALTER TABLE`ims_tiger_newhu_appset`MODIFY COLUMN`appfxcontent`varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '' AFTER`appfxtitle`; ALTER TABLE`ims_tiger_newhu_appset`MODIFY COLUMN`smskeyid`varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' AFTER`appfxcontent`; ALTER TABLE`ims_tiger_newhu_appset`MODIFY COLUMN`smssecret`varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' AFTER`smskeyid`; ALTER TABLE`ims_tiger_newhu_appset`MODIFY COLUMN`smsname`varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' AFTER`smssecret`; ALTER TABLE`ims_tiger_newhu_appset`MODIFY COLUMN`smscode`varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' AFTER`smsname`; ALTER TABLE`ims_tiger_newhu_appset`MODIFY COLUMN`appkey`varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '秘钥' AFTER`smscode`; ALTER TABLE`ims_tiger_newhu_appset`MODIFY COLUMN`tuanzhangtype`int(11) NULL DEFAULT 0 COMMENT '1开启团长功能' AFTER`appkey`; ALTER TABLE`ims_tiger_newhu_fztype`MODIFY COLUMN`picurl`varchar(255) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL COMMENT '封面' AFTER`hlcid`; ALTER TABLE`ims_tiger_newhu_fztype`MODIFY COLUMN`cid`varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '上级ID' AFTER`picurl`; ALTER TABLE`ims_tiger_newhu_fztype`MODIFY COLUMN`sokey`varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT NULL COMMENT '搜索词' AFTER`cid`; ALTER TABLE`ims_tiger_newhu_fztype`MODIFY COLUMN`picurl2`varchar(255) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL COMMENT '搜索界面图标' AFTER`sokey`; ALTER TABLE`ims_tiger_newhu_fztype`MODIFY COLUMN`wlurl`varchar(255) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL COMMENT '外链' AFTER`picurl2`; ALTER TABLE`ims_tiger_newhu_fztype`MODIFY COLUMN`tag`varchar(250) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL COMMENT '男装衬衫|男装裤' AFTER`wlurl`; ALTER TABLE`ims_tiger_newhu_fztype`MODIFY COLUMN`createtime`int(10) NOT NULL AFTER`tag`; ALTER TABLE`ims_tiger_newhu_fztype`MODIFY COLUMN`shztype`varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '' COMMENT '实惠猪分类' AFTER`createtime`; ALTER TABLE`ims_tiger_newhu_fztype`MODIFY COLUMN`ysdtype`varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '' COMMENT '一手单分类' AFTER`shztype`; ALTER TABLE`ims_tiger_newhu_fztype`MODIFY COLUMN`tkzstype`varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '' COMMENT '淘客助手分类' AFTER`ysdtype`; ALTER TABLE`ims_tiger_newhu_fztype`MODIFY COLUMN`qtktype`varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '' COMMENT '轻淘客分类' AFTER`tkzstype`; ALTER TABLE`ims_tiger_newhu_fztype`MODIFY COLUMN`hpttype`varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '' COMMENT '好品推分类' AFTER`qtktype`; ALTER TABLE`ims_tiger_newhu_fztype`MODIFY COLUMN`tkjdtype`varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '' COMMENT '淘客基地分类' AFTER`hpttype`; ALTER TABLE`ims_tiger_newhu_goods`MODIFY COLUMN`shtype`int(2) NOT NULL DEFAULT 0 AFTER`px`; ALTER TABLE`ims_tiger_newhu_goods`MODIFY COLUMN`title`varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL AFTER`shtype`; ALTER TABLE`ims_tiger_newhu_goods`MODIFY COLUMN`hot`varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL AFTER`title`; ALTER TABLE`ims_tiger_newhu_goods`MODIFY COLUMN`hotcolor`varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL AFTER`hot`; ALTER TABLE`ims_tiger_newhu_goods`MODIFY COLUMN`leibei`varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL AFTER`hotcolor`; ALTER TABLE`ims_tiger_newhu_goods`MODIFY COLUMN`logo`varchar(255) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL AFTER`leibei`; ALTER TABLE`ims_tiger_newhu_goods`MODIFY COLUMN`appurl`varchar(300) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' AFTER`logo`; ALTER TABLE`ims_tiger_newhu_goods`MODIFY COLUMN`amount`int(11) NOT NULL DEFAULT 0 AFTER`appurl`; ALTER TABLE`ims_tiger_newhu_goods`MODIFY COLUMN`day_sum`int(11) NOT NULL DEFAULT 0 AFTER`amount`; ALTER TABLE`ims_tiger_newhu_goods`MODIFY COLUMN`cardid`varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL AFTER`day_sum`; ALTER TABLE`ims_tiger_newhu_goods`MODIFY COLUMN`taokouling`varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL AFTER`cardid`; ALTER TABLE`ims_tiger_newhu_goods`MODIFY COLUMN`deadline`datetime NOT NULL AFTER`taokouling`; ALTER TABLE`ims_tiger_newhu_goods`MODIFY COLUMN`per_user_limit`int(11) NOT NULL DEFAULT 0 AFTER`deadline`; ALTER TABLE`ims_tiger_newhu_goods`MODIFY COLUMN`starttime`varchar(12) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT NULL AFTER`per_user_limit`; ALTER TABLE`ims_tiger_newhu_goods`MODIFY COLUMN`endtime`varchar(12) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT NULL AFTER`starttime`; ALTER TABLE`ims_tiger_newhu_goods`MODIFY COLUMN`cost`int(11) NOT NULL DEFAULT 0 AFTER`endtime`; ALTER TABLE`ims_tiger_newhu_goods`MODIFY COLUMN`cost_type`int(11) NOT NULL DEFAULT 1 COMMENT '1系统积分 2会员积分 4,8等留作扩展' AFTER`cost`; ALTER TABLE`ims_tiger_newhu_goods`MODIFY COLUMN`price`decimal(10,2) NOT NULL DEFAULT 0.10 COMMENT '商品价格' AFTER`cost_type`; ALTER TABLE`ims_tiger_newhu_goods`MODIFY COLUMN`fxprice`decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '返现' AFTER`price`; ALTER TABLE`ims_tiger_newhu_goods`MODIFY COLUMN`vip_require`int(10) NOT NULL DEFAULT 0 COMMENT '兑换最低VIP级别' AFTER`fxprice`; ALTER TABLE`ims_tiger_newhu_goods`MODIFY COLUMN`content`text CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL AFTER`vip_require`; ALTER TABLE`ims_tiger_newhu_goods`MODIFY COLUMN`type`int(11) NOT NULL DEFAULT 0 COMMENT '是否需要填写收货地址,1,实物需要填写地址,0虚拟物品不需要填写地址' AFTER`content`; ALTER TABLE`ims_tiger_newhu_goods`MODIFY COLUMN`dj_link`varchar(255) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL AFTER`type`; ALTER TABLE`ims_tiger_newhu_goods`MODIFY COLUMN`wl_link`varchar(255) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL AFTER`dj_link`; ALTER TABLE`ims_tiger_newhu_goods`MODIFY COLUMN`createtime`int(10) NOT NULL AFTER`wl_link`; ALTER TABLE`ims_tiger_newhu_goods`MODIFY COLUMN`ordrsum`int(11) NULL DEFAULT 0 AFTER`createtime`; ALTER TABLE`ims_tiger_newhu_goods`MODIFY COLUMN`ordermsg`varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '' AFTER`ordrsum`; ALTER TABLE`ims_tiger_newhu_jdtjorder`MODIFY COLUMN`jlnickname`varchar(255) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '订单所有人' AFTER`avatar`; ALTER TABLE`ims_tiger_newhu_jdtjorder`MODIFY COLUMN`jlavatar`varchar(255) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '订单所有人' AFTER`jlnickname`; ALTER TABLE`ims_tiger_newhu_jdtjorder`MODIFY COLUMN`memberid`varchar(255) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '微擎会员编号' AFTER`jlavatar`; ALTER TABLE`ims_tiger_newhu_jdtjorder`MODIFY COLUMN`uid`varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT NULL COMMENT '用户UID share表' AFTER`memberid`; ALTER TABLE`ims_tiger_newhu_jdtjorder`MODIFY COLUMN`orderid`varchar(255) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '订单编号' AFTER`uid`; ALTER TABLE`ims_tiger_newhu_jdtjorder`MODIFY COLUMN`price`varchar(255) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '奖励金额' AFTER`orderid`; ALTER TABLE`ims_tiger_newhu_jdtjorder`MODIFY COLUMN`yongjin`varchar(255) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '佣金' AFTER`price`; ALTER TABLE`ims_tiger_newhu_jdtjorder`MODIFY COLUMN`type`varchar(255) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '类型 0 自有 1级奖励 2级奖励' AFTER`yongjin`; ALTER TABLE`ims_tiger_newhu_jdtjorder`MODIFY COLUMN`sh`varchar(255) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '是否审核 0 1待返 2已返 3审核 4失效' AFTER`type`; ALTER TABLE`ims_tiger_newhu_jdtjorder`MODIFY COLUMN`msg`varchar(255) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '留言' AFTER`sh`; ALTER TABLE`ims_tiger_newhu_jdtjorder`MODIFY COLUMN`itemid`varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '商品ID' AFTER`msg`; ALTER TABLE`ims_tiger_newhu_jdtjorder`MODIFY COLUMN`jl`varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '奖励金额或是积分' AFTER`itemid`; ALTER TABLE`ims_tiger_newhu_jdtjorder`MODIFY COLUMN`jltype`int(10) NULL DEFAULT 0 COMMENT '0积分 1余额' AFTER`jl`; ALTER TABLE`ims_tiger_newhu_jdtjorder`MODIFY COLUMN`createtime`varchar(255) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL AFTER`jltype`; ALTER TABLE`ims_tiger_newhu_jdtjorder`MODIFY COLUMN`cjdd`int(10) NULL DEFAULT 0 AFTER`createtime`; ALTER TABLE`ims_tiger_newhu_jdtjorder`MODIFY COLUMN`jluid`varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '' AFTER`cjdd`; ALTER TABLE`ims_tiger_newhu_lxorder`MODIFY COLUMN`newtel`varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT NULL AFTER`sgtime`; ALTER TABLE`ims_tiger_newhu_lxorder`MODIFY COLUMN`xrzt`varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT NULL AFTER`newtel`; ALTER TABLE`ims_tiger_newhu_lxorder`MODIFY COLUMN`ddlx`varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT NULL AFTER`xrzt`; ALTER TABLE`ims_tiger_newhu_lxorder`MODIFY COLUMN`fxyh`varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT NULL AFTER`ddlx`; ALTER TABLE`ims_tiger_newhu_lxorder`MODIFY COLUMN`mtid`varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT NULL AFTER`fxyh`; ALTER TABLE`ims_tiger_newhu_lxorder`MODIFY COLUMN`mtname`varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT NULL AFTER`mtid`; ALTER TABLE`ims_tiger_newhu_lxorder`MODIFY COLUMN`tgwid`varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT NULL AFTER`mtname`; ALTER TABLE`ims_tiger_newhu_lxorder`MODIFY COLUMN`tgwname`varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT NULL AFTER`tgwid`; ALTER TABLE`ims_tiger_newhu_lxorder`MODIFY COLUMN`orderid`varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT NULL AFTER`tgwname`; ALTER TABLE`ims_tiger_newhu_lxorder`MODIFY COLUMN`createtime`int(10) NOT NULL AFTER`orderid`; ALTER TABLE`ims_tiger_newhu_order`MODIFY COLUMN`jlnickname`varchar(255) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '订单所有人' AFTER`avatar`; ALTER TABLE`ims_tiger_newhu_order`MODIFY COLUMN`jlavatar`varchar(255) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '订单所有人' AFTER`jlnickname`; ALTER TABLE`ims_tiger_newhu_order`MODIFY COLUMN`memberid`varchar(255) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '微擎会员编号' AFTER`jlavatar`; ALTER TABLE`ims_tiger_newhu_order`MODIFY COLUMN`uid`varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT NULL COMMENT '用户UID share表' AFTER`memberid`; ALTER TABLE`ims_tiger_newhu_order`MODIFY COLUMN`orderid`varchar(255) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '订单编号' AFTER`uid`; ALTER TABLE`ims_tiger_newhu_order`MODIFY COLUMN`price`varchar(255) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '奖励金额' AFTER`orderid`; ALTER TABLE`ims_tiger_newhu_order`MODIFY COLUMN`yongjin`varchar(255) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '佣金' AFTER`price`; ALTER TABLE`ims_tiger_newhu_order`MODIFY COLUMN`type`varchar(255) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '类型 0 自有 1级奖励 2级奖励' AFTER`yongjin`; ALTER TABLE`ims_tiger_newhu_order`MODIFY COLUMN`sh`varchar(255) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '是否审核 0 1待返 2已返 3审核 4失效' AFTER`type`; ALTER TABLE`ims_tiger_newhu_order`MODIFY COLUMN`msg`varchar(255) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '留言' AFTER`sh`; ALTER TABLE`ims_tiger_newhu_order`MODIFY COLUMN`itemid`varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '商品ID' AFTER`msg`; ALTER TABLE`ims_tiger_newhu_order`MODIFY COLUMN`jl`varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '奖励金额或是积分' AFTER`itemid`; ALTER TABLE`ims_tiger_newhu_order`MODIFY COLUMN`jltype`int(10) NULL DEFAULT 0 COMMENT '0积分 1余额' AFTER`jl`; ALTER TABLE`ims_tiger_newhu_order`MODIFY COLUMN`createtime`varchar(255) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL AFTER`jltype`; ALTER TABLE`ims_tiger_newhu_order`MODIFY COLUMN`cjdd`int(10) NULL DEFAULT 0 AFTER`createtime`; ALTER TABLE`ims_tiger_newhu_order`MODIFY COLUMN`jluid`varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '' AFTER`cjdd`; ALTER TABLE`ims_tiger_newhu_pddtjorder`MODIFY COLUMN`jlnickname`varchar(255) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '订单所有人' AFTER`avatar`; ALTER TABLE`ims_tiger_newhu_pddtjorder`MODIFY COLUMN`jlavatar`varchar(255) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '订单所有人' AFTER`jlnickname`; ALTER TABLE`ims_tiger_newhu_pddtjorder`MODIFY COLUMN`memberid`varchar(255) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '微擎会员编号' AFTER`jlavatar`; ALTER TABLE`ims_tiger_newhu_pddtjorder`MODIFY COLUMN`uid`varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT NULL COMMENT '用户UID share表' AFTER`memberid`; ALTER TABLE`ims_tiger_newhu_pddtjorder`MODIFY COLUMN`orderid`varchar(255) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '订单编号' AFTER`uid`; ALTER TABLE`ims_tiger_newhu_pddtjorder`MODIFY COLUMN`price`varchar(255) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '奖励金额' AFTER`orderid`; ALTER TABLE`ims_tiger_newhu_pddtjorder`MODIFY COLUMN`yongjin`varchar(255) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '佣金' AFTER`price`; ALTER TABLE`ims_tiger_newhu_pddtjorder`MODIFY COLUMN`type`varchar(255) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '类型 0 自有 1级奖励 2级奖励' AFTER`yongjin`; ALTER TABLE`ims_tiger_newhu_pddtjorder`MODIFY COLUMN`sh`varchar(255) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '是否审核 0 1待返 2已返 3审核 4失效' AFTER`type`; ALTER TABLE`ims_tiger_newhu_pddtjorder`MODIFY COLUMN`msg`varchar(255) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '留言' AFTER`sh`; ALTER TABLE`ims_tiger_newhu_pddtjorder`MODIFY COLUMN`itemid`varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '商品ID' AFTER`msg`; ALTER TABLE`ims_tiger_newhu_pddtjorder`MODIFY COLUMN`jl`varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '奖励金额或是积分' AFTER`itemid`; ALTER TABLE`ims_tiger_newhu_pddtjorder`MODIFY COLUMN`jltype`int(10) NULL DEFAULT 0 COMMENT '0积分 1余额' AFTER`jl`; ALTER TABLE`ims_tiger_newhu_pddtjorder`MODIFY COLUMN`createtime`varchar(255) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL AFTER`jltype`; ALTER TABLE`ims_tiger_newhu_pddtjorder`MODIFY COLUMN`cjdd`int(10) NULL DEFAULT 0 AFTER`createtime`; ALTER TABLE`ims_tiger_newhu_pddtjorder`MODIFY COLUMN`jluid`varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '' AFTER`cjdd`; ALTER TABLE`ims_tiger_newhu_qtzlist`MODIFY COLUMN`cate`varchar(400) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL COMMENT '124|154| 子栏目' AFTER`type`; ALTER TABLE`ims_tiger_newhu_request`MODIFY COLUMN`from_user_realname`varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL AFTER`weid`; ALTER TABLE`ims_tiger_newhu_request`MODIFY COLUMN`from_user`varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL AFTER`from_user_realname`; ALTER TABLE`ims_tiger_newhu_request`MODIFY COLUMN`openid`varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL AFTER`from_user`; ALTER TABLE`ims_tiger_newhu_request`MODIFY COLUMN`image`varchar(300) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' AFTER`openid`; ALTER TABLE`ims_tiger_newhu_request`MODIFY COLUMN`realname`varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL AFTER`image`; ALTER TABLE`ims_tiger_newhu_request`MODIFY COLUMN`mobile`varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL AFTER`realname`; ALTER TABLE`ims_tiger_newhu_request`MODIFY COLUMN`residedist`varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL AFTER`mobile`; ALTER TABLE`ims_tiger_newhu_request`MODIFY COLUMN`alipay`varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL AFTER`residedist`; ALTER TABLE`ims_tiger_newhu_request`MODIFY COLUMN`note`varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL AFTER`alipay`; ALTER TABLE`ims_tiger_newhu_request`MODIFY COLUMN`tborder`varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL AFTER`note`; ALTER TABLE`ims_tiger_newhu_request`MODIFY COLUMN`goods_id`int(10) UNSIGNED NOT NULL AFTER`tborder`; ALTER TABLE`ims_tiger_newhu_request`MODIFY COLUMN`createtime`int(10) UNSIGNED NOT NULL DEFAULT 0 AFTER`goods_id`; ALTER TABLE`ims_tiger_newhu_request`MODIFY COLUMN`cost`decimal(10,2) NOT NULL DEFAULT 0.00 AFTER`createtime`; ALTER TABLE`ims_tiger_newhu_request`MODIFY COLUMN`price`decimal(10,2) NOT NULL DEFAULT 0.00 AFTER`cost`; ALTER TABLE`ims_tiger_newhu_request`MODIFY COLUMN`fxprice`decimal(10,2) NOT NULL DEFAULT 0.00 AFTER`price`; ALTER TABLE`ims_tiger_newhu_request`MODIFY COLUMN`status`varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL AFTER`fxprice`; ALTER TABLE`ims_tiger_newhu_request`MODIFY COLUMN`type`int(5) NULL DEFAULT 0 AFTER`status`; ALTER TABLE`ims_tiger_newhu_request`MODIFY COLUMN`kuaidi`varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL AFTER`type`; ALTER TABLE`ims_tiger_newhu_request`MODIFY COLUMN`uid`varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL COMMENT '用户UID' AFTER`kuaidi`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`openid`varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' AFTER`weid`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`tel`varchar(15) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT NULL AFTER`openid`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`type`varchar(15) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' AFTER`tel`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`credit1`decimal(10,2) UNSIGNED NOT NULL COMMENT '积分' AFTER`type`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`credit2`decimal(10,2) UNSIGNED NOT NULL COMMENT '余额' AFTER`credit1`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`cqtype`varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL COMMENT '0 不能查询 1 能查询' AFTER`credit2`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`dltype`varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL COMMENT '0 不是代理 1 是代理' AFTER`cqtype`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`dlsh`varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL COMMENT '0 审核中 1通过' AFTER`dltype`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`dlbl`varchar(110) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL COMMENT '代理佣金比例-一级自购' AFTER`dlsh`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`dlbl2`varchar(110) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL COMMENT '代理佣金比例-二级自购' AFTER`dlbl`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`dlbl3`varchar(110) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL COMMENT '代理佣金比例-三级自购' AFTER`dlbl2`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`tgwid`varchar(250) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL COMMENT '渠道推广位ID' AFTER`dlbl3`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`dlqqpid`varchar(110) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL COMMENT '代理鹊桥PID' AFTER`tgwid`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`dlptpid`varchar(110) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL COMMENT '代理普通' AFTER`dlqqpid`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`apppid`varchar(110) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL COMMENT 'APP PID' AFTER`dlptpid`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`apptgw`varchar(110) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL COMMENT 'APP 推广位' AFTER`apppid`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`dlmsg`varchar(250) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL COMMENT '代理申请理由' AFTER`apptgw`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`zfbuid`varchar(250) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL COMMENT '支付宝帐号' AFTER`dlmsg`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`tname`varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL COMMENT '姓名' AFTER`zfbuid`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`qunname`varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL COMMENT '群名称' AFTER`tname`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`pclogo`varchar(250) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL COMMENT 'PCLOGO' AFTER`qunname`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`pctitle`varchar(250) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL COMMENT 'PC网站标题' AFTER`pclogo`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`pckeywords`varchar(250) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL COMMENT 'PC网站关键词' AFTER`pctitle`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`pcdescription`varchar(250) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL COMMENT 'PC网站描述' AFTER`pckeywords`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`pcsearchkey`varchar(250) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL COMMENT 'PC网站搜索框下面关键词' AFTER`pcdescription`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`pcewm1`varchar(250) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL COMMENT 'PC二维码1' AFTER`pcsearchkey`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`pcewm2`varchar(250) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL COMMENT 'PC二维码2' AFTER`pcewm1`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`pcbottom1`varchar(250) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL COMMENT 'PC网站底部1' AFTER`pcewm2`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`pcbottom2`varchar(250) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL COMMENT 'PC网站底部2' AFTER`pcbottom1`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`pcuser`varchar(250) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL COMMENT '登录帐号' AFTER`pcbottom2`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`pcpasswords`varchar(250) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL COMMENT '登录密码' AFTER`pcuser`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`pcurl`varchar(250) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL COMMENT '代理独立域名' AFTER`pcpasswords`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`lytype`int(3) NULL DEFAULT 0 COMMENT '0 公众号 1APP' AFTER`pcurl`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`dytype`int(3) NULL DEFAULT 0 COMMENT '0已经订阅 1取消订阅' AFTER`lytype`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`weixin`varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT NULL AFTER`dytype`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`from_user`varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL AFTER`weixin`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`xcxopenid`varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL AFTER`from_user`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`pcopenid`varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL AFTER`xcxopenid`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`appopenid`varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL AFTER`pcopenid`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`unionid`varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL AFTER`appopenid`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`jqfrom_user`varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL AFTER`unionid`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`nickname`varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' AFTER`jqfrom_user`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`avatar`varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT NULL AFTER`nickname`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`tbnickname`varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' AFTER`avatar`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`tbavatar`varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT NULL AFTER`tbnickname`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`tbopenid`varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL AFTER`tbavatar`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`tbunionid`varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL AFTER`tbopenid`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`score`int(11) NULL DEFAULT 0 AFTER`tbunionid`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`cscore`int(11) NULL DEFAULT 0 AFTER`score`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`pscore`int(11) NULL DEFAULT 0 AFTER`cscore`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`pid`int(11) NULL DEFAULT 0 AFTER`pscore`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`sceneid`int(11) NULL DEFAULT 0 AFTER`pid`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`ticketid`varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT NULL AFTER`sceneid`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`url`varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT NULL AFTER`ticketid`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`parentid`int(11) NULL DEFAULT 0 AFTER`url`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`helpid`int(11) NULL DEFAULT 0 AFTER`parentid`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`follow`tinyint(1) NOT NULL DEFAULT 0 AFTER`helpid`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`status`int(1) NULL DEFAULT 0 AFTER`follow`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`hasdel`int(1) NULL DEFAULT 0 AFTER`status`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`createtime`varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT NULL AFTER`hasdel`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`updatetime`varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' AFTER`createtime`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`province`varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT NULL AFTER`updatetime`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`city`varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT NULL AFTER`province`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`tbsbuid6`varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT NULL AFTER`city`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`yaoqingma`varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT NULL AFTER`tbsbuid6`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`pddpid`varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL COMMENT '多多PID' AFTER`yaoqingma`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`jdpid`varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL COMMENT '京东PID' AFTER`pddpid`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`tbkpidtype`int(11) NULL DEFAULT 0 COMMENT '1已经绑定tbuid 0未绑定' AFTER`jdpid`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`tbuid`varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' AFTER`tbkpidtype`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`tzpaytime`varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '团长支付时间' AFTER`tztype`; ALTER TABLE`ims_tiger_newhu_share`MODIFY COLUMN`qdid`varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' AFTER`tzendtime`; ALTER TABLE`ims_tiger_newhu_tkorder`MODIFY COLUMN`orderid`varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '订单编号' AFTER`addtime`; ALTER TABLE`ims_tiger_newhu_tkorder`MODIFY COLUMN`numid`varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '商品ID' AFTER`orderid`; ALTER TABLE`ims_tiger_newhu_tkorder`MODIFY COLUMN`shopname`varchar(255) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '店铺名称' AFTER`numid`; ALTER TABLE`ims_tiger_newhu_tkorder`MODIFY COLUMN`title`varchar(255) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '商品标题' AFTER`shopname`; ALTER TABLE`ims_tiger_newhu_tkorder`MODIFY COLUMN`orderzt`varchar(255) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '订单状态' AFTER`title`; ALTER TABLE`ims_tiger_newhu_tkorder`MODIFY COLUMN`srbl`varchar(255) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '收入比例' AFTER`orderzt`; ALTER TABLE`ims_tiger_newhu_tkorder`MODIFY COLUMN`fcbl`varchar(255) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '分成比例' AFTER`srbl`; ALTER TABLE`ims_tiger_newhu_tkorder`MODIFY COLUMN`fkprice`varchar(255) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '付款金额' AFTER`fcbl`; ALTER TABLE`ims_tiger_newhu_tkorder`MODIFY COLUMN`xgyg`varchar(255) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '效果预估' AFTER`fkprice`; ALTER TABLE`ims_tiger_newhu_tkorder`MODIFY COLUMN`jstime`varchar(255) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '结算时间' AFTER`xgyg`; ALTER TABLE`ims_tiger_newhu_tkorder`MODIFY COLUMN`pt`varchar(255) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '平台' AFTER`jstime`; ALTER TABLE`ims_tiger_newhu_tkorder`MODIFY COLUMN`type`varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '状态 0未奖励 1已奖励' AFTER`pt`; ALTER TABLE`ims_tiger_newhu_tkorder`MODIFY COLUMN`mtid`varchar(150) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '媒体ID' AFTER`type`; ALTER TABLE`ims_tiger_newhu_tkorder`MODIFY COLUMN`mttitle`varchar(150) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '媒体名称' AFTER`mtid`; ALTER TABLE`ims_tiger_newhu_tkorder`MODIFY COLUMN`tgwid`varchar(150) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '推广ID' AFTER`mttitle`; ALTER TABLE`ims_tiger_newhu_tkorder`MODIFY COLUMN`tgwtitle`varchar(150) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '推广位名称' AFTER`tgwid`; ALTER TABLE`ims_tiger_newhu_tkorder`MODIFY COLUMN`wq`varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '维权订单 1 维权订单' AFTER`tgwtitle`; ALTER TABLE`ims_tiger_newhu_tkorder`MODIFY COLUMN`createtime`varchar(255) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL AFTER`wq`; ALTER TABLE`ims_tiger_newhu_tkorder`MODIFY COLUMN`tbsbuid6`varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT NULL AFTER`createtime`; ALTER TABLE`ims_tiger_newhu_tkorder`MODIFY COLUMN`zdgd`int(10) NULL DEFAULT 0 AFTER`tbsbuid6`; ALTER TABLE`ims_tiger_newhu_tkorder`MODIFY COLUMN`forderid`varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '父订单编号' AFTER`zdgd`; ALTER TABLE`ims_tiger_newhu_tkorder`MODIFY COLUMN`ly`varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '来源0联盟表格 1 联盟API' AFTER`forderid`; ALTER TABLE`ims_tiger_newhu_tkorder`MODIFY COLUMN`zorderid`varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '子订单编号' AFTER`ly`; ALTER TABLE`ims_tiger_newhu_tkorder`MODIFY COLUMN`relation_id`varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' AFTER`zorderid`; DROP INDEX`orderid`ON`ims_tiger_newhu_tkorder`; CREATE UNIQUE INDEX`orderid`ON`ims_tiger_newhu_tkorder`(`weid`,`orderid`,`numid`) USING BTREE ; ALTER TABLE`ims_tiger_newhu_tksign`MODIFY COLUMN`sign`varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT NULL AFTER`tbuid`; ALTER TABLE`ims_tiger_newhu_tksign`MODIFY COLUMN`endtime`varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT NULL COMMENT '结束时间' AFTER`sign`; ALTER TABLE`ims_tiger_newhu_tksign`MODIFY COLUMN`createtime`int(10) NOT NULL AFTER`endtime`; ALTER TABLE`ims_tiger_wxdaili_set`MODIFY COLUMN`dltype`int(11) NULL DEFAULT 3 COMMENT '1 级 2级 3级' AFTER`weid`; ALTER TABLE`ims_tiger_wxdaili_set`MODIFY COLUMN`dlname1`varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT NULL COMMENT '一级名称' AFTER`dltype`; ALTER TABLE`ims_tiger_wxdaili_set`MODIFY COLUMN`dlname2`varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT NULL COMMENT '二级名称' AFTER`dlname1`; ALTER TABLE`ims_tiger_wxdaili_set`MODIFY COLUMN`dlname3`varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT NULL COMMENT '三级名称' AFTER`dlname2`; ALTER TABLE`ims_tiger_wxdaili_set`MODIFY COLUMN`dlbl1`int(11) NULL DEFAULT NULL COMMENT '一级-自己产生佣金比率' AFTER`dlname3`; ALTER TABLE`ims_tiger_wxdaili_set`MODIFY COLUMN`dlbl1t2`int(11) NULL DEFAULT NULL COMMENT '一级-提取二级佣金比率' AFTER`dlbl1`; ALTER TABLE`ims_tiger_wxdaili_set`MODIFY COLUMN`dlbl1t3`int(11) NULL DEFAULT NULL COMMENT '一级-提取三级佣金比率' AFTER`dlbl1t2`; ALTER TABLE`ims_tiger_wxdaili_set`MODIFY COLUMN`dlbl2`int(11) NULL DEFAULT NULL COMMENT '二级-自己产生佣金比率' AFTER`dlbl1t3`; ALTER TABLE`ims_tiger_wxdaili_set`MODIFY COLUMN`dlbl2t3`int(11) NULL DEFAULT NULL COMMENT '二级-提取三级佣金比率' AFTER`dlbl2`; ALTER TABLE`ims_tiger_wxdaili_set`MODIFY COLUMN`dlbl3`int(11) NULL DEFAULT NULL COMMENT '三级-自己产生佣金比率' AFTER`dlbl2t3`; ALTER TABLE`ims_tiger_wxdaili_set`MODIFY COLUMN`dlfftype`int(11) NULL DEFAULT 0 COMMENT '0不开启 1开启' AFTER`dlbl3`; ALTER TABLE`ims_tiger_wxdaili_set`MODIFY COLUMN`dlffprice`varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT NULL COMMENT '付费金额' AFTER`dlfftype`; ALTER TABLE`ims_tiger_wxdaili_set`MODIFY COLUMN`fxtype`int(11) NULL DEFAULT 0 COMMENT '0抽成模式 1普通分销' AFTER`dlffprice`; ALTER TABLE`ims_tiger_wxdaili_set`MODIFY COLUMN`ddtype`int(11) NULL DEFAULT 0 COMMENT '0全显示 1显示一部分' AFTER`fxtype`; ALTER TABLE`ims_tiger_wxdaili_set`MODIFY COLUMN`seartype`int(11) NULL DEFAULT 0 COMMENT '超级搜0显示 1不显示' AFTER`ddtype`; ALTER TABLE`ims_tiger_wxdaili_set`MODIFY COLUMN`dlzbtype`int(11) NULL DEFAULT 0 COMMENT '直播 1显示' AFTER`seartype`; ALTER TABLE`ims_tiger_wxdaili_set`MODIFY COLUMN`fzname`varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT NULL COMMENT '分站名称' AFTER`dlzbtype`; ALTER TABLE`ims_tiger_wxdaili_set`MODIFY COLUMN`zfmsg0`varchar(1000) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT NULL COMMENT '支付提醒' AFTER`fzname`; ALTER TABLE`ims_tiger_wxdaili_set`MODIFY COLUMN`zfmsg1`varchar(1000) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT NULL COMMENT '一级支付提醒' AFTER`zfmsg0`; ALTER TABLE`ims_tiger_wxdaili_set`MODIFY COLUMN`zfmsg2`varchar(1000) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT NULL COMMENT '二级支付提醒' AFTER`zfmsg1`; ALTER TABLE`ims_tiger_wxdaili_set`MODIFY COLUMN`zfmsg3`varchar(1000) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT NULL COMMENT '三级支付提醒' AFTER`zfmsg2`; ALTER TABLE`ims_tiger_wxdaili_set`MODIFY COLUMN`level1`varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT NULL COMMENT '代理付费一级奖励' AFTER`zfmsg3`; ALTER TABLE`ims_tiger_wxdaili_set`MODIFY COLUMN`level2`varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT NULL COMMENT '代理付费二级奖励' AFTER`level1`; ALTER TABLE`ims_tiger_wxdaili_set`MODIFY COLUMN`level3`varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT NULL COMMENT '代理付费三级奖励' AFTER`level2`; ALTER TABLE`ims_tiger_wxdaili_set`MODIFY COLUMN`glevel1`varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT NULL COMMENT '代理付费固定一级奖励' AFTER`level3`; ALTER TABLE`ims_tiger_wxdaili_set`MODIFY COLUMN`glevel2`varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT NULL COMMENT '代理付费固定二级奖励' AFTER`glevel1`; ALTER TABLE`ims_tiger_wxdaili_set`MODIFY COLUMN`glevel3`varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT NULL COMMENT '代理付费固定三级奖励' AFTER`glevel2`; ALTER TABLE`ims_tiger_wxdaili_set`MODIFY COLUMN`dlkcbl`varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT NULL COMMENT '扣除佣金' AFTER`glevel3`; ALTER TABLE`ims_tiger_wxdaili_set`MODIFY COLUMN`dlyjfltype`int(3) NULL DEFAULT 0 COMMENT '提交订单是示开启返二级 0 不开启 1开启' AFTER`dlkcbl`; ALTER TABLE`ims_tiger_wxdaili_set`MODIFY COLUMN`dlfxtype`int(11) NULL DEFAULT 0 COMMENT '代理商是否支持提交订单反现 0 支持 1 不支持' AFTER`dlyjfltype`; ALTER TABLE`ims_tiger_wxdaili_tkpid`MODIFY COLUMN`pid`varchar(250) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT NULL COMMENT '淘客PID' AFTER`uid`; ALTER TABLE`ims_tiger_wxdaili_tkpid`MODIFY COLUMN`tgwname`varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT NULL COMMENT '推广位名称' AFTER`pid`; ALTER TABLE`ims_tiger_wxdaili_tkpid`MODIFY COLUMN`fptime`varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT NULL COMMENT '分配时间' AFTER`tgwname`; ALTER TABLE`ims_tiger_wxdaili_tkpid`MODIFY COLUMN`createtime`varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT NULL COMMENT '生成时间' AFTER`fptime`; ALTER TABLE`ims_tiger_wxdaili_tkpid`MODIFY COLUMN`tbuid`varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT '0' COMMENT '淘宝ID' AFTER`createtime`;