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`;