【老虎其他】开启使用渠道ID没有淘口令解决方法

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(weidorderidnumid) 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;

1、本站所提供的文章资讯、软件资源、源码等内容均为正版打包、网友推荐、互联网整理而来(部分报媒/平媒内容转载自网络合作媒体),仅供学习研究参考,如有侵犯您的版权,请联系我们i#33f3.cn(#换成@),本站将在三个工作日内改正。 2、如您需商业运营,建议购买正版程序。 3、拾光大叔不保证资源的准确性、安全性和完整性,请您在阅读、下载及使用过程中自行确认,本站亦不承担上述资源对您或您的网站造成的任何形式的损失或伤害。 4、互联网的本质是自由与分享,我们真诚的希望,每一份有价值的正能量能够在互联网中自由传播,能够为每一个网站提供动力。
拾光大叔 » 【老虎其他】开启使用渠道ID没有淘口令解决方法