乐商网(LWSCMS) 系统版本更新SQL记录

3.5.7 版本SQL

ALTER TABLE `lw_api_goods` ADD `is_lunxun` TINYINT(5) NOT NULL DEFAULT '0' COMMENT '是否开启轮询' ;
ALTER TABLE `lw_api_goods` ADD `lunxun_quan` INT(5) NOT NULL DEFAULT '0' COMMENT '轮询权重';
ALTER TABLE `lw_goods` ADD `is_lunxun_pay` INT(5) NOT NULL DEFAULT '0' ;
ALTER TABLE `lw_order` ADD `is_lunxun_num` INT(5) NULL DEFAULT '0' ;
ALTER TABLE `lw_order_old` ADD `is_lunxun_num` INT(5) NULL DEFAULT '0' ;
ALTER TABLE `lw_order` ADD `order_history` TEXT NULL DEFAULT '';
ALTER TABLE `lw_order_old` ADD `order_history` TEXT NULL DEFAULT '';
3.5.6 版本SQL

ALTER TABLE lw_api_list ADD COLUMN post_content VARCHAR(255) DEFAULT '' COMMENT ''
ALTER TABLE lw_goods ADD xianzhi_money DECIMAL(10,2) NULL DEFAULT '0';
ALTER TABLE lw_user ADD is_user_pay INT(2) DEFAULT '0';

CREATE TABLE lw_order_old ( order_id int(11) NOT NULL, uid int(11) DEFAULT ‘0’ COMMENT ‘0游客’, order_no varchar(255) DEFAULT NULL COMMENT ‘订单号’, apiorder_no varchar(255) DEFAULT NULL, out_trade_no varchar(255) DEFAULT NULL COMMENT ‘下游订单号’, taobao_goods int(11) DEFAULT ‘0’ COMMENT ‘淘宝商品id’, is_send_taobao int(5) DEFAULT ‘0’ COMMENT ‘0 未发送 1发货成功 2发送旺旺消息成功 3都成功’, yibu varchar(255) DEFAULT ” COMMENT ‘异步回调地址’, qr varchar(255) DEFAULT ” COMMENT ‘二维码’, api_info varchar(255) DEFAULT NULL, pay_no varchar(255) DEFAULT NULL, goods_id int(11) DEFAULT NULL, goods_name varchar(300) DEFAULT NULL COMMENT ‘商品名称’, order_num int(11) NOT NULL, order_buydouble int(11) DEFAULT ‘1’, goods_price decimal(10,2) DEFAULT NULL, goods_costprice decimal(10,2) DEFAULT NULL COMMENT ‘成本价’, order_profit decimal(10,2) DEFAULT NULL COMMENT ‘利润’, order_price decimal(10,2) DEFAULT NULL, order_contact varchar(255) DEFAULT NULL, actual_price decimal(10,2) DEFAULT NULL COMMENT ‘实付金额’, templates text, is_deliver int(11) DEFAULT ‘1’ COMMENT ‘1 未发货 2 已发货’, pay_name varchar(255) DEFAULT NULL COMMENT ‘支付通道’, pay_type varchar(255) DEFAULT NULL, is_automatic int(11) DEFAULT ‘1’ COMMENT ‘1自动 2手动’, order_status int(2) DEFAULT ‘1’ COMMENT ‘1待付款 2 已付款 3 已超时 4 处理中 5已发货 6卡密不足 7退款中 8已退款’, order_ip varchar(255) DEFAULT ‘0’, check_ip text, ua varchar(50) DEFAULT ” COMMENT ‘用户请求方式’, notebook varchar(255) DEFAULT ” COMMENT ‘记事本’, goods_api_id int(11) DEFAULT ‘0’ COMMENT ‘api对接id’, goods_api_type int(5) DEFAULT ‘0’ COMMENT ‘对接类型’, api_address varchar(255) DEFAULT ” COMMENT ‘对接站地址’, pay_info text COMMENT ‘支付的appi appkey等’, order_card longtext, is_buy int(2) DEFAULT ‘1’ COMMENT ‘1购买 2.充值’, is_send int(2) DEFAULT ‘0’ COMMENT ‘是否发送已消息’, site_id int(11) DEFAULT ‘-1’ COMMENT ‘分站ID’, site_profit decimal(10,2) DEFAULT NULL COMMENT ‘分站收益’, order_addtime int(11) DEFAULT NULL, order_paytime int(11) DEFAULT ‘0’, day_time int(11) DEFAULT ‘0’ COMMENT ‘每天日期’, status_time int(11) DEFAULT ‘0’ COMMENT ‘状态时间’, order_msg text COMMENT ‘消息’, ordermsg_type int(1) DEFAULT ‘0’ COMMENT ‘消息状态’, t_s int(3) DEFAULT ‘0’ COMMENT ‘推送提醒 0 未推送 1 已推送 ‘, t_status int(3) DEFAULT ‘2’ COMMENT ‘退款状态 2 人工处理 1网站余额’, t_site_money decimal(12,2) DEFAULT ‘0.00’ COMMENT ‘分站t记录’, t_money decimal(12,2) DEFAULT ‘0.00’ COMMENT ‘退款记录’, t_profit_status tinyint(3) DEFAULT ‘0’ COMMENT ‘退款状态’, cha_time int(11) DEFAULT ‘0’ COMMENT ‘查单时间’, is_read tinyint(3) DEFAULT ‘0’ COMMENT ‘是否已读’, pay_channel varchar(255) DEFAULT ” COMMENT ‘支付类型’, tongdao tinyint(5) NOT NULL DEFAULT ‘0’, can_money decimal(10,2) DEFAULT ‘0.00’, fenxiao_profit decimal(12,2) NOT NULL DEFAULT ‘0.00’) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
ALTER TABLE lw_goods ADD COLUMN is_jd tinyint(5) DEFAULT 0 COMMENT ”;
ALTER TABLE lw_goods ADD COLUMN is_tb tinyint(5) DEFAULT 0 COMMENT ”;
ALTER TABLE lw_goods ADD COLUMN is_pdd tinyint(5) DEFAULT 0 COMMENT ”;
ALTER TABLE lw_goods ADD COLUMN is_xy tinyint(5) DEFAULT 0 COMMENT ”;
ALTER TABLE lw_goods ADD COLUMN is_other tinyint(5) DEFAULT 0 COMMENT ”;
ALTER TABLE lw_order_old ADD PRIMARY KEY (order_id) USING BTREE, ADD UNIQUE KEY order_no (order_no) USING BTREE, ADD UNIQUE KEY order_no_2 (order_no) USING BTREE, ADD KEY uid (uid) USING BTREE, ADD KEY site_id (site_id) USING BTREE, ADD KEY apiorder_no (apiorder_no) USING BTREE, ADD KEY out_trade_no (out_trade_no) USING BTREE, ADD KEY is_automatic (is_automatic) USING BTREE, ADD KEY order_status (order_status) USING BTREE, ADD KEY is_send (is_send) USING BTREE;
ALTER TABLE lw_api_goods ADD COLUMN additional VARCHAR(255) DEFAULT ” COMMENT ”;

ALTER TABLE lw_api_list ADD COLUMN is_update_baohu tinyint(5) DEFAULT 1 COMMENT '开启进价保护';
ALTER TABLE lw_user ADD COLUMN is_xianjia tinyint(5) DEFAULT 0 COMMENT '是否开启保护' ;
ALTER TABLE lw_user ADD COLUMN is_open_card int(5) DEFAULT 0 COMMENT 'card';
ALTER TABLE lw_goods ADD COLUMN is_open_quan int(5) DEFAULT 0 COMMENT 'card';
CREATE TABLE `lw_user_behavior` (`id` int(11) NOT NULL, `ip` varchar(20) DEFAULT '',`create_time` int(10) DEFAULT '0',`type` int(5) DEFAULT '1',`user_id` int(11) DEFAULT '0') ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
ALTER TABLE `lw_user_behavior` ADD PRIMARY KEY (`id`);
ALTER TABLE `lw_user_behavior` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; COMMIT;
CREATE TABLE `lw_quan` (`id` int(11) NOT NULL,`goods_id` int(11) NOT NULL DEFAULT '0',`card_num` varchar(255) NOT NULL DEFAULT '', `card_status` tinyint(5) NOT NULL DEFAULT '1', `order_no` varchar(255) DEFAULT '', `dui_time` int(10) NOT NULL DEFAULT '0', `create_time` int(10) NOT NULL DEFAULT '0', `user_id` int(11) NOT NULL DEFAULT '0', `card_group` varchar(32) NOT NULL DEFAULT '', `card_beizhu` varchar(255) DEFAULT NULL, `md5` varchar(32) NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
ALTER TABLE `lw_quan` ADD PRIMARY KEY (`id`),ADD UNIQUE KEY `md5` (`md5`),ADD KEY `user_id` (`user_id`),ADD KEY `card_group` (`card_group`),ADD KEY `goods_id` (`goods_id`),ADD KEY `order_no` (`order_no`(191)),ADD KEY `order_no_2` (`order_no`(191));
ALTER TABLE `lw_quan`  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;COMMIT;

ALTER TABLE lw_taobao_duijie ADD COLUMN user_id int(11) DEFAULT 0 COMMENT ‘用户ID’;

1.0.1淘宝插件SQL

INSERT INTO lw_manager_class (manager_id, manager_name, manager_url, manager_type, create_time, pid, is_open, delete_time, top_id) VALUES (‘804’, ‘插件管理操作’, ‘manager/hook’, ‘32768’, ‘0’, ‘800’, ‘0’, ‘0’, ‘800’);
INSERT INTO lw_manager_class (manager_id, manager_name, manager_url, manager_type, create_time, pid, is_open, delete_time, top_id) VALUES (‘950’, ‘电商对接’, ‘hook’, ‘32768’, ‘0’, ‘0’, ‘1’, ‘0’, ‘0’);
INSERT INTO lw_manager_class (manager_id, manager_name, manager_url, manager_type, create_time, pid, is_open, delete_time, top_id) VALUES (‘951’, ‘店铺配置’, ‘manager/hook/hook/taobao/type/index’, ‘32768’, ‘0’, ‘950’, ‘1’, ‘0’, ‘0’);
INSERT INTO lw_manager_class (manager_id, manager_name, manager_url, manager_type, create_time, pid, is_open, delete_time, top_id) VALUES (‘952’, ‘店铺配置编辑’, ‘manager/hook/hook/taobao/type/update’, ‘32768’, ‘0’, ‘950’, ‘0’, ‘0’, ‘0’);
INSERT INTO lw_manager_class (manager_id, manager_name, manager_url, manager_type, create_time, pid, is_open, delete_time, top_id) VALUES (‘953’, ‘店铺配置删除’, ‘manager/hook/hook/taobao/type/del’, ‘32768’, ‘0’, ‘950’, ‘0’, ‘0’, ‘0’);
INSERT INTO lw_manager_class (manager_id, manager_name, manager_url, manager_type, create_time, pid, is_open, delete_time, top_id) VALUES (‘954’, ‘店铺配置添加’, ‘manager/hook/hook/taobao/type/add’, ‘32768’, ‘0’, ‘950’, ‘0’, ‘0’, ‘0’);
INSERT INTO lw_manager_class (manager_id, manager_name, manager_url, manager_type, create_time, pid, is_open, delete_time, top_id) VALUES (‘960’, ‘对接配置’, ‘manager/hook/hook/taobao/type/duijie’, ‘32768’, ‘0’, ‘950’, ‘1’, ‘0’, ‘0’);
INSERT INTO lw_manager_class (manager_id, manager_name, manager_url, manager_type, create_time, pid, is_open, delete_time, top_id) VALUES (‘961’, ‘对接配置编辑’, ‘manager/hook/hook/taobao/type/duijieupdate’, ‘32768’, ‘0’, ‘950’, ‘0’, ‘0’, ‘0’);
INSERT INTO lw_manager_class (manager_id, manager_name, manager_url, manager_type, create_time, pid, is_open, delete_time, top_id) VALUES (‘962’, ‘对接配置删除’, ‘manager/hook/hook/taobao/type/duijiedel’, ‘32768’, ‘0’, ‘950’, ‘0’, ‘0’, ‘0’);
INSERT INTO lw_manager_class (manager_id, manager_name, manager_url, manager_type, create_time, pid, is_open, delete_time, top_id) VALUES (‘963’, ‘对接配置添加’, ‘manager/hook/hook/taobao/type/duijieadd’, ‘32768’, ‘0’, ‘950’, ‘0’, ‘0’, ‘0’);
INSERT INTO lw_manager_class (manager_id, manager_name, manager_url, manager_type, create_time, pid, is_open, delete_time, top_id) VALUES (‘970’, ‘模板配置’, ‘manager/hook/hook/taobao/type/moban’, ‘32768’, ‘0’, ‘950’, ‘1’, ‘0’, ‘0’);
INSERT INTO lw_manager_class (manager_id, manager_name, manager_url, manager_type, create_time, pid, is_open, delete_time, top_id) VALUES (‘971’, ‘模板配置编辑’, ‘manager/hook/hook/taobao/type/mobanupdate’, ‘32768’, ‘0’, ‘950’, ‘0’, ‘0’, ‘0’);
INSERT INTO lw_manager_class (manager_id, manager_name, manager_url, manager_type, create_time, pid, is_open, delete_time, top_id) VALUES (‘972’, ‘模板配置删除’, ‘manager/hook/hook/taobao/type/mobandel’, ‘32768’, ‘0’, ‘950’, ‘0’, ‘0’, ‘0’);
INSERT INTO lw_manager_class (manager_id, manager_name, manager_url, manager_type, create_time, pid, is_open, delete_time, top_id) VALUES (‘973’, ‘模板配置添加’, ‘manager/hook/hook/taobao/type/mobanadd’, ‘32768’, ‘0’, ‘950’, ‘0’, ‘0’, ‘0’);
CREATE TABLE lw_taobao_set (id int(11) NOT NULL AUTO_INCREMENT,beizhu varchar(255) DEFAULT NULL,name varchar(255) DEFAULT NULL,appid varchar(255) DEFAULT NULL,appsecret varchar(255) DEFAULT NULL,apptoken varchar(255) DEFAULT NULL,userid varchar(255) DEFAULT NULL,userkey varchar(255) DEFAULT NULL,userurl varchar(255) DEFAULT NULL,addtime int(11) DEFAULT NULL,updatetime int(11) DEFAULT NULL,PRIMARY KEY (id)) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
CREATE TABLE lw_taobao_duijie (id int(11) NOT NULL AUTO_INCREMENT,type int(11) DEFAULT ‘1’ COMMENT ‘对接类型’,goods_id int(11) DEFAULT NULL,taobao_id int(11) DEFAULT NULL,duijie_id varchar(255) DEFAULT ‘0’,duijie_skuid varchar(255) DEFAULT ‘0’,duijie_price decimal(10,2) DEFAULT ‘0.00’,duijie_beizhu varchar(255) DEFAULT NULL,success_mb int(11) DEFAULT ‘0’,fail_mb int(11) DEFAULT ‘0’,fahuo_type int(11) DEFAULT ‘1’,addtime int(11) DEFAULT NULL,updatetime int(11) DEFAULT NULL,PRIMARY KEY (id)) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
CREATE TABLE lw_taobao_moban (id int(11) NOT NULL AUTO_INCREMENT,name varchar(255) DEFAULT NULL,beizhu varchar(255) DEFAULT NULL,content text,addtime int(11) DEFAULT NULL,updatetime int(11) DEFAULT NULL,PRIMARY KEY (id)) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
ALTER TABLE lw_taobao_duijie ADD COLUMN is_open int(2) DEFAULT 1 COMMENT ” AFTER fahuo_type;

1.0.2 淘宝插件SQL

INSERT INTO lw_manager_class (manager_id, manager_name, manager_url, manager_type, create_time, pid, is_open, delete_time, top_id) VALUES (‘804’, ‘插件管理操作’, ‘manager/hook’, ‘32768’, ‘0’, ‘800’, ‘0’, ‘0’, ‘800’);
INSERT INTO lw_manager_class (manager_id, manager_name, manager_url, manager_type, create_time, pid, is_open, delete_time, top_id) VALUES (‘950’, ‘电商对接’, ‘hook’, ‘32768’, ‘0’, ‘0’, ‘1’, ‘0’, ‘0’);
INSERT INTO lw_manager_class (manager_id, manager_name, manager_url, manager_type, create_time, pid, is_open, delete_time, top_id) VALUES (‘951’, ‘店铺配置’, ‘manager/hook/hook/taobao/type/index’, ‘32768’, ‘0’, ‘950’, ‘1’, ‘0’, ‘0’);
INSERT INTO lw_manager_class (manager_id, manager_name, manager_url, manager_type, create_time, pid, is_open, delete_time, top_id) VALUES (‘952’, ‘店铺配置编辑’, ‘manager/hook/hook/taobao/type/update’, ‘32768’, ‘0’, ‘950’, ‘0’, ‘0’, ‘0’);
INSERT INTO lw_manager_class (manager_id, manager_name, manager_url, manager_type, create_time, pid, is_open, delete_time, top_id) VALUES (‘953’, ‘店铺配置删除’, ‘manager/hook/hook/taobao/type/del’, ‘32768’, ‘0’, ‘950’, ‘0’, ‘0’, ‘0’);
INSERT INTO lw_manager_class (manager_id, manager_name, manager_url, manager_type, create_time, pid, is_open, delete_time, top_id) VALUES (‘954’, ‘店铺配置添加’, ‘manager/hook/hook/taobao/type/add’, ‘32768’, ‘0’, ‘950’, ‘0’, ‘0’, ‘0’);
INSERT INTO lw_manager_class (manager_id, manager_name, manager_url, manager_type, create_time, pid, is_open, delete_time, top_id) VALUES (‘960’, ‘对接配置’, ‘manager/hook/hook/taobao/type/duijie’, ‘32768’, ‘0’, ‘950’, ‘1’, ‘0’, ‘0’);
INSERT INTO lw_manager_class (manager_id, manager_name, manager_url, manager_type, create_time, pid, is_open, delete_time, top_id) VALUES (‘961’, ‘对接配置编辑’, ‘manager/hook/hook/taobao/type/duijieupdate’, ‘32768’, ‘0’, ‘950’, ‘0’, ‘0’, ‘0’);
INSERT INTO lw_manager_class (manager_id, manager_name, manager_url, manager_type, create_time, pid, is_open, delete_time, top_id) VALUES (‘962’, ‘对接配置删除’, ‘manager/hook/hook/taobao/type/duijiedel’, ‘32768’, ‘0’, ‘950’, ‘0’, ‘0’, ‘0’);
INSERT INTO lw_manager_class (manager_id, manager_name, manager_url, manager_type, create_time, pid, is_open, delete_time, top_id) VALUES (‘963’, ‘对接配置添加’, ‘manager/hook/hook/taobao/type/duijieadd’, ‘32768’, ‘0’, ‘950’, ‘0’, ‘0’, ‘0’);
INSERT INTO lw_manager_class (manager_id, manager_name, manager_url, manager_type, create_time, pid, is_open, delete_time, top_id) VALUES (‘970’, ‘模板配置’, ‘manager/hook/hook/taobao/type/moban’, ‘32768’, ‘0’, ‘950’, ‘1’, ‘0’, ‘0’);
INSERT INTO lw_manager_class (manager_id, manager_name, manager_url, manager_type, create_time, pid, is_open, delete_time, top_id) VALUES (‘971’, ‘模板配置编辑’, ‘manager/hook/hook/taobao/type/mobanupdate’, ‘32768’, ‘0’, ‘950’, ‘0’, ‘0’, ‘0’);
INSERT INTO lw_manager_class (manager_id, manager_name, manager_url, manager_type, create_time, pid, is_open, delete_time, top_id) VALUES (‘972’, ‘模板配置删除’, ‘manager/hook/hook/taobao/type/mobandel’, ‘32768’, ‘0’, ‘950’, ‘0’, ‘0’, ‘0’);
INSERT INTO lw_manager_class (manager_id, manager_name, manager_url, manager_type, create_time, pid, is_open, delete_time, top_id) VALUES (‘973’, ‘模板配置添加’, ‘manager/hook/hook/taobao/type/mobanadd’, ‘32768’, ‘0’, ‘950’, ‘0’, ‘0’, ‘0’);
CREATE TABLE lw_taobao_set (id int(11) NOT NULL AUTO_INCREMENT,beizhu varchar(255) DEFAULT NULL,name varchar(255) DEFAULT NULL,appid varchar(255) DEFAULT NULL,appsecret varchar(255) DEFAULT NULL,apptoken varchar(255) DEFAULT NULL,userid varchar(255) DEFAULT NULL,userkey varchar(255) DEFAULT NULL,userurl varchar(255) DEFAULT NULL,addtime int(11) DEFAULT NULL,updatetime int(11) DEFAULT NULL,PRIMARY KEY (id)) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
CREATE TABLE lw_taobao_duijie (id int(11) NOT NULL AUTO_INCREMENT,type int(11) DEFAULT ‘1’ COMMENT ‘对接类型’,goods_id int(11) DEFAULT NULL,taobao_id int(11) DEFAULT NULL,duijie_id varchar(255) DEFAULT ‘0’,duijie_skuid varchar(255) DEFAULT ‘0’,duijie_price decimal(10,2) DEFAULT ‘0.00’,duijie_beizhu varchar(255) DEFAULT NULL,success_mb int(11) DEFAULT ‘0’,fail_mb int(11) DEFAULT ‘0’,fahuo_type int(11) DEFAULT ‘1’,addtime int(11) DEFAULT NULL,updatetime int(11) DEFAULT NULL,PRIMARY KEY (id)) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
CREATE TABLE lw_taobao_moban (id int(11) NOT NULL AUTO_INCREMENT,name varchar(255) DEFAULT NULL,beizhu varchar(255) DEFAULT NULL,content text,addtime int(11) DEFAULT NULL,updatetime int(11) DEFAULT NULL,PRIMARY KEY (id)) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
ALTER TABLE lw_taobao_duijie ADD COLUMN is_open int(2) DEFAULT 1 COMMENT ” AFTER fahuo_type;

1.1.0淘宝插件SQL

REPLACE INTO lw_manager_class (manager_id, manager_name, manager_url, manager_type, create_time, pid, is_open, delete_time, top_id) VALUES (‘804’, ‘插件管理操作’, ‘manager/hook’, ‘32768’, ‘0’, ‘800’, ‘0’, ‘0’, ‘800’);
REPLACE INTO lw_manager_class (manager_id, manager_name, manager_url, manager_type, create_time, pid, is_open, delete_time, top_id) VALUES (‘950’, ‘电商对接’, ‘hook’, ‘32768’, ‘0’, ‘0’, ‘1’, ‘0’, ‘0’);
REPLACE INTO lw_manager_class (manager_id, manager_name, manager_url, manager_type, create_time, pid, is_open, delete_time, top_id) VALUES (‘951’, ‘店铺配置’, ‘manager/hook/hook/taobao/type/index’, ‘32768’, ‘0’, ‘950’, ‘1’, ‘0’, ‘0’);
REPLACE INTO lw_manager_class (manager_id, manager_name, manager_url, manager_type, create_time, pid, is_open, delete_time, top_id) VALUES (‘952’, ‘店铺配置编辑’, ‘manager/hook/hook/taobao/type/update’, ‘32768’, ‘0’, ‘950’, ‘0’, ‘0’, ‘0’);
REPLACE INTO lw_manager_class (manager_id, manager_name, manager_url, manager_type, create_time, pid, is_open, delete_time, top_id) VALUES (‘953’, ‘店铺配置删除’, ‘manager/hook/hook/taobao/type/del’, ‘32768’, ‘0’, ‘950’, ‘0’, ‘0’, ‘0’);
REPLACE INTO lw_manager_class (manager_id, manager_name, manager_url, manager_type, create_time, pid, is_open, delete_time, top_id) VALUES (‘954’, ‘店铺配置添加’, ‘manager/hook/hook/taobao/type/add’, ‘32768’, ‘0’, ‘950’, ‘0’, ‘0’, ‘0’);
REPLACE INTO lw_manager_class (manager_id, manager_name, manager_url, manager_type, create_time, pid, is_open, delete_time, top_id) VALUES (‘960’, ‘对接配置’, ‘manager/hook/hook/taobao/type/duijie’, ‘32768’, ‘0’, ‘950’, ‘1’, ‘0’, ‘0’);
REPLACE INTO lw_manager_class (manager_id, manager_name, manager_url, manager_type, create_time, pid, is_open, delete_time, top_id) VALUES (‘961’, ‘对接配置编辑’, ‘manager/hook/hook/taobao/type/duijieupdate’, ‘32768’, ‘0’, ‘950’, ‘0’, ‘0’, ‘0’);
REPLACE INTO lw_manager_class (manager_id, manager_name, manager_url, manager_type, create_time, pid, is_open, delete_time, top_id) VALUES (‘962’, ‘对接配置删除’, ‘manager/hook/hook/taobao/type/duijiedel’, ‘32768’, ‘0’, ‘950’, ‘0’, ‘0’, ‘0’);
REPLACE INTO lw_manager_class (manager_id, manager_name, manager_url, manager_type, create_time, pid, is_open, delete_time, top_id) VALUES (‘963’, ‘对接配置添加’, ‘manager/hook/hook/taobao/type/duijieadd’, ‘32768’, ‘0’, ‘950’, ‘0’, ‘0’, ‘0’);
REPLACE INTO lw_manager_class (manager_id, manager_name, manager_url, manager_type, create_time, pid, is_open, delete_time, top_id) VALUES (‘970’, ‘模板配置’, ‘manager/hook/hook/taobao/type/moban’, ‘32768’, ‘0’, ‘950’, ‘1’, ‘0’, ‘0’);
REPLACE INTO lw_manager_class (manager_id, manager_name, manager_url, manager_type, create_time, pid, is_open, delete_time, top_id) VALUES (‘971’, ‘模板配置编辑’, ‘manager/hook/hook/taobao/type/mobanupdate’, ‘32768’, ‘0’, ‘950’, ‘0’, ‘0’, ‘0’);
REPLACE INTO lw_manager_class (manager_id, manager_name, manager_url, manager_type, create_time, pid, is_open, delete_time, top_id) VALUES (‘972’, ‘模板配置删除’, ‘manager/hook/hook/taobao/type/mobandel’, ‘32768’, ‘0’, ‘950’, ‘0’, ‘0’, ‘0’);
REPLACE INTO lw_manager_class (manager_id, manager_name, manager_url, manager_type, create_time, pid, is_open, delete_time, top_id) VALUES (‘973’, ‘模板配置添加’, ‘manager/hook/hook/taobao/type/mobanadd’, ‘32768’, ‘0’, ‘950’, ‘0’, ‘0’, ‘0’);
Create Table If Not Exists lw_taobao_set (id int(11) NOT NULL AUTO_INCREMENT,beizhu varchar(255) DEFAULT NULL,name varchar(255) DEFAULT NULL,appid varchar(255) DEFAULT NULL,appsecret varchar(255) DEFAULT NULL,apptoken varchar(255) DEFAULT NULL,userid varchar(255) DEFAULT NULL,userkey varchar(255) DEFAULT NULL,userurl varchar(255) DEFAULT NULL,addtime int(11) DEFAULT NULL,updatetime int(11) DEFAULT NULL,PRIMARY KEY (id)) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
Create Table If Not Exists lw_taobao_duijie (id int(11) NOT NULL AUTO_INCREMENT,type int(11) DEFAULT ‘1’ COMMENT ‘对接类型’,goods_id int(11) DEFAULT NULL,taobao_id int(11) DEFAULT NULL,duijie_id varchar(255) DEFAULT ‘0’,duijie_skuid varchar(255) DEFAULT ‘0’,duijie_price decimal(10,2) DEFAULT ‘0.00’,duijie_beizhu varchar(255) DEFAULT NULL,success_mb int(11) DEFAULT ‘0’,fail_mb int(11) DEFAULT ‘0’,fahuo_type int(11) DEFAULT ‘1’,addtime int(11) DEFAULT NULL,updatetime int(11) DEFAULT NULL,PRIMARY KEY (id)) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
Create Table If Not Exists lw_taobao_moban (id int(11) NOT NULL AUTO_INCREMENT,name varchar(255) DEFAULT NULL,beizhu varchar(255) DEFAULT NULL,content text,addtime int(11) DEFAULT NULL,updatetime int(11) DEFAULT NULL,PRIMARY KEY (id)) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
ALTER TABLE lw_taobao_duijie ADD COLUMN is_kuiben int(1) DEFAULT 0 COMMENT ” AFTER fahuo_type;
ALTER TABLE lw_taobao_duijie ADD COLUMN is_open int(2) DEFAULT 1 COMMENT ” AFTER fahuo_type;

ALTER TABLE lw_api_list ADD COLUMN is_update_auto tinyint(2) DEFAULT 0 COMMENT '是否自动退款';
ALTER TABLE lw_api_list ADD COLUMN is_update_auto_xiadan tinyint(2) DEFAULT 0 COMMENT '下单错误自动退款';
ALTER TABLE lw_manager ADD COLUMN openid  varchar(255)  DEFAULT NULL  COMMENT  '管理员微信';
ALTER TABLE lw_api_list ADD COLUMN is_update_money_tongdao tinyint(2) DEFAULT 0 COMMENT '附加查价通道';
ALTER TABLE lw_user ADD COLUMN wxopenid varchar(255) DEFAULT  '' COMMENT 'wx' ;
ALTER TABLE lw_goods ADD COLUMN restrictions_str text COMMENT '限价' AFTER order_time;
ALTER TABLE lw_goods ADD COLUMN `restrictions_money` decimal(10,2) DEFAULT 0 COMMENT '限价金额' AFTER order_time;
ALTER TABLE lw_user ADD COLUMN dongjie_money decimal(10,2) DEFAULT 0;
ALTER TABLE lw_order ADD COLUMN can_money decimal(10,2)  DEFAULT 0 
ALTER TABLE lw_goods ADD COLUMN `beizhu` varchar(255) DEFAULT '' COMMENT '备注' AFTER pay_type;
ALTER TABLE lw_order ADD COLUMN tongdao tinyint(5) DEFAULT 0 COMMENT '查单通道' AFTER cha_time;
ALTER TABLE lw_api_list ADD COLUMN is_update_title tinyint(5) DEFAULT 1 COMMENT '' AFTER is_status;
ALTER TABLE lw_api_list ADD COLUMN is_update_img tinyint(5) DEFAULT 1 COMMENT '' AFTER is_status;
ALTER TABLE lw_api_list ADD COLUMN is_update_price tinyint(5) DEFAULT 1 COMMENT '' AFTER is_status;
ALTER TABLE lw_api_list ADD COLUMN is_update_kucun tinyint(5) DEFAULT 1 COMMENT '' AFTER is_status;
ALTER TABLE lw_api_list ADD COLUMN is_update_desc tinyint(5) DEFAULT 1 COMMENT '' AFTER is_status;
ALTER TABLE lw_api_list ADD COLUMN is_update_status tinyint(5) DEFAULT 1 COMMENT '' AFTER is_status;
ALTER TABLE lw_api_list ADD COLUMN tongdao tinyint(5) DEFAULT 0 COMMENT '' AFTER is_status;
ALTER TABLE lw_liushui ADD INDEX order_no ( order_no );
ALTER TABLE lw_goods ADD COLUMN order_time int(11) DEFAULT 0 COMMENT '过期时间' AFTER pay_type;
DELETE FROM `lw_setinfo` WHERE name = "ONECLASS";
INSERT INTO `lw_setinfo`(`name`, `info`) VALUES ('ONECLASS','{"1":{"name":"热门推荐","ico":"<svg t="1670658508495" class="icon" viewBox="0 0 1024 1024" version="1.1" xm<x>lns="http:\/\/www.w3.org\/2000\/svg" p-id="18306" width="16" height="16"><path d="M914.432 818.389333l-114.858667 16.362667-72.533333 91.733333a43.242667 43.242667 0 0 1-59.093333-15.829333l-109.226667-189.162667a339.392 339.392 0 0 1-48.021333 3.776 343.872 343.872 0 0 1-49.941334-4.053333l-109.525333 189.696a42.666667 42.666667 0 0 1-58.282667 15.616l-71.466666-90.517333-113.28-16.149334a42.666667 42.666667 0 0 1-15.616-58.282666l121.109333-209.770667a341.333333 341.333333 0 1 1 595.413333-2.368l121.130667 209.792a43.264 43.264 0 0 1-15.808 59.157333zM158.72 775.168l94.805333 5.461333 52.992 79.872 89.6-155.285333a341.525333 341.525333 0 0 1-141.589333-96zM510.741333 106.666667a277.333333 277.333333 0 1 0 277.333334 277.333333 277.333333 277.333333 0 0 0-277.333334-277.333333zM768 608a341.333333 341.333333 0 0 1-143.488 97.6l88.917333 154.026667 53.76-81.066667 96.128-5.546667z" fill="#5C8EF3" p-id="18307"><\/path><path d="M512 576a192 192 0 1 1 192-192 192 192 0 0 1-192 192z m-0.661333-320.661333a128 128 0 1 0 128 128 128 128 0 0 0-128-128z" fill="#EB9E52" p-id="18308"><\/path><\/svg>","sort":"1"},"2":{"name":"视频会员","ico":"<svg t="1670657646255" class="icon" viewBox="0 0 1024 1024" version="1.1" xm<x>lns="http:\/\/www.w3.org\/2000\/svg" p-id="3452" width="16" height="16"><path d="M355.328 329.216c-25.6-19.456-46.592-9.216-46.592 23.04v318.976c0 32.256 20.992 42.496 46.592 23.04l193.024-146.944a42.496 42.496 0 0 0 0-71.168zM193.024 158.208h-5.632a122.88 122.88 0 0 0-158.72 74.24 1392.128 1392.128 0 0 0 0 558.592 122.88 122.88 0 0 0 160.768 75.264 2186.24 2186.24 0 0 1 3.584-708.096z" fill="#d81e06" p-id="3453"><\/path><path d="M983.552 414.208A1837.056 1837.056 0 0 0 367.616 47.616a129.536 129.536 0 0 0-172.544 98.816v11.776a1792 1792 0 0 1 563.2 278.528 88.576 88.576 0 0 1-3.584 146.944 2108.928 2108.928 0 0 1-562.688 281.6v10.752A129.536 129.536 0 0 0 369.664 972.8a2179.584 2179.584 0 0 0 609.792-369.152 130.048 130.048 0 0 0 4.096-189.44z" fill="#d81e06" p-id="3454"><\/path><\/svg>","sort":"3"},"3":{"name":"音频盛宴","ico":"<svg t="1670658458334" class="icon" viewBox="0 0 1024 1024" version="1.1" xm<x>lns="http:\/\/www.w3.org\/2000\/svg" p-id="17002" width="16" height="16"><path d="M0 0v1024h839.68V839.68h184.32V0H0z" fill="#F45D5D" p-id="17003"><\/path><path d="M839.68 1024V839.68h184.32L839.68 1024z" fill="#EA4747" p-id="17004"><\/path><path d="M482.3552 455.68a115.2 115.2 0 1 1-115.2 115.2 115.328 115.328 0 0 1 115.2-115.2m0-76.8a192 192 0 1 0 192 192 192 192 0 0 0-192-192z" fill="#FFEBEB" p-id="17005"><\/path><path d="M488.73728 251.24736l72.16896-26.26688 102.1312 280.6016-72.16896 26.26816z" fill="#FFEBEB" p-id="17006"><\/path><path d="M538.176 387.0848l52.6848 144.768L663.04 505.6a192.4992 192.4992 0 0 0-124.864-118.5152z" fill="#FFFFFF" p-id="17007"><\/path><path d="M733.6448 271.36l-19.8784 74.176-211.5584-57.28-13.4784-37.0176 71.8208-26.2656L733.6448 271.36z" fill="#FFEBEB" p-id="17008"><\/path><path d="M592.8704 312.8064l-31.9232-87.7184-0.192-0.0512-72.0256 26.2016 13.4784 37.0176 90.6624 24.5504z" fill="#FFFFFF" p-id="17009"><\/path><\/svg>","sort":"4"},"4":{"name":"美食餐饮","ico":"<svg t="1670658010250" class="icon" viewBox="0 0 1024 1024" version="1.1" xm<x>lns="http:\/\/www.w3.org\/2000\/svg" p-id="7612" width="16" height="16"><path d="M196.608 788.992v133.12c4.608 30.208 31.232 51.712 61.44 51.2h517.632c30.72 0 56.32-30.72 56.32-61.44v-133.12H196.608v10.24z" fill="#AEC9FF" p-id="7613"><\/path><path d="M1016.832 327.68c-9.216-28.672-24.576-55.296-46.08-76.8-20.48-27.136-49.152-47.104-81.92-56.32-46.08-15.36-87.04-10.24-128 5.12-5.12 0-10.24 5.12-15.36 5.12-51.2-97.28-128.512-153.6-236.032-153.6s-184.32 51.2-230.4 153.6c-51.2-25.6-107.52-30.72-163.84-5.12s-92.16 66.56-107.52 128c-15.36 56.32-5.12 107.52 20.48 153.6 35.84 66.56 97.28 92.16 163.84 97.28v128h640.512v-133.12h5.12c20.48 0 35.84-5.12 56.32-10.24 46.08-15.36 81.92-40.96 102.4-87.04 20.48-35.84 25.6-76.8 25.6-117.76 5.12-5.12 0-20.48-5.12-30.72z" fill="#3366FF" p-id="7614"><\/path><\/svg>","sort":"5"},"5":{"name":"知识教育","ico":"<svg t="1670658043772" class="icon" viewBox="0 0 1024 1024" version="1.1" xm<x>lns="http:\/\/www.w3.org\/2000\/svg" p-id="9581" width="16" height="16"><path d="M352.6144 816.896V300.3136h158.848V512l79.232-52.9408L669.9008 512v-211.6864h105.9072v463.616c0 53.76-25.856 52.9664-39.6032 52.9664-259.5072 0.4096-383.5904 0-383.5904 0z" fill="#27AD9A" p-id="9582"><\/path><path d="M766.5152 226.3552a9.0112 9.0112 0 0 1-6.8608 14.5408H311.7824a22.2208 22.2208 0 0 0-23.04 23.04c-0.4096 8.0896 0 12.928 0 18.176 0 11.3408 8.8832 19.0208 23.8592 19.0208h4.8384a8.96 8.96 0 0 1 8.8832 8.7552v498.4064a8.8064 8.8064 0 0 1-9.2928 8.8832c-53.76-2.304-56.9856-28.5696-56.9856-51.2V248.576c0 2.0224-1.6128-39.7312 39.6032-39.7312h436.9664c12.544-1.1008 21.8112 6.9888 29.9008 17.5104z" fill="#27AD9A" p-id="9583"><\/path><path d="M538.1376 274.048h105.9072v185.3952a1983.872 1983.872 0 0 0-52.9664-39.6032s-32.7168 23.8592-52.9408 39.6032v-185.3952z" fill="#27AD9A" p-id="9584"><\/path><\/svg>","sort":"6"},"6":{"name":"运动健身","ico":"<svg t="1670658099276" class="icon" viewBox="0 0 1024 1024" version="1.1" xm<x>lns="http:\/\/www.w3.org\/2000\/svg" p-id="13434" width="16" height="16"><path d="M512 1024a512 512 0 1 1 512-512 512 512 0 0 1-512 512zM250.368 329.856l99.968 352.256-99.968 11.776v98.048h539.008v-179.2l-146.048 25.6v-25.6l60.672-10.24a27.648 27.648 0 0 0 23.424-27.392 15.744 15.744 0 0 0 0-2.432A20.864 20.864 0 0 0 704 554.24l-66.816 7.936-96.256 36.608 9.984 24.32h60.416v20.48l-48.768 7.552 23.68 54.656-53.76 29.312-49.152-73.728-92.928 13.824-65.152-223.104h35.328l-44.544-122.24z m113.664 86.528l12.8 31.104L512 400.128l45.44 94.08-76.8 45.056a51.2 51.2 0 0 0-18.432 70.144l1.536 2.432 70.144 105.728 35.328-17.536-49.152-108.416 101.248-31.488a76.8 76.8 0 0 0 50.56-96.128 64 64 0 0 0-3.584-9.344L617.472 345.6a64 64 0 0 0-84.864-31.36 66.688 66.688 0 0 0-6.656 3.584zM492.8 307.2a44.8 44.8 0 1 0-44.8-44.8 44.8 44.8 0 0 0 44.8 44.8z" fill="#CB894D" p-id="13435"><\/path><\/svg>","sort":"7"},"7":{"name":"加速下载","ico":"<svg t="1670658112994" class="icon" viewBox="0 0 1024 1024" version="1.1" xm<x>lns="http:\/\/www.w3.org\/2000\/svg" p-id="14578" width="16" height="16"><path d="M1024 748.544q0 25.6-8.704 48.128t-24.064 40.96-36.352 30.208-45.568 15.872l0 2.048-21.504 0-1.024 0-664.576 0q-2.048 0-2.56 0.512t-2.56 0.512-3.072-0.512-3.072-0.512l-6.144 0 0-1.024q-43.008-2.048-80.384-19.456t-65.024-46.592-43.52-67.584-15.872-81.408 15.872-80.896 43.008-66.56 63.488-47.104 78.336-21.504q7.168-66.56 36.864-124.416t76.288-100.864 107.008-67.584 129.024-24.576q72.704 0 137.216 27.648t112.128 75.776 75.264 112.128 27.648 136.704q0 32.768-6.144 64t-17.408 59.904q2.048 0 4.608-0.512t4.608-0.512q28.672 0 53.248 10.752t43.008 29.184 29.184 43.52 10.752 53.76zM687.104 596.992q12.288-20.48 7.168-23.552t-25.6-3.072q-12.288 0-34.304-0.512t-33.28-0.512q-16.384 0-20.992-13.312t-4.608-36.864q0-32.768-0.512-52.736t-0.512-43.52q0-26.624-3.584-38.912t-29.184-12.288q-18.432 0-27.648 0.512t-25.6 0.512q-27.648 0-34.304 15.872t-6.656 31.232l0 32.768q0 13.312 0.512 25.6t0.512 25.6l0 29.696q0 16.384-4.096 25.088t-19.456 8.704q-6.144 1.024-16.896 1.536t-22.016 1.024-21.504 0.512l-16.384 0q-21.504 0-25.6 13.312t13.312 33.792q17.408 21.504 37.376 46.592t39.424 50.688 37.376 49.664 33.28 41.472q27.648 30.72 53.248-1.024 15.36-17.408 35.84-45.056t41.984-57.856 40.96-58.368 31.744-46.592z" p-id="14579" fill="#1296db"><\/path><\/svg>","sort":"8"},"8":{"name":"漫画阅读","ico":"<svg t="1670658529854" class="icon" viewBox="0 0 1024 1024" version="1.1" xm<x>lns="http:\/\/www.w3.org\/2000\/svg" p-id="19447" width="16" height="16"><path d="M445 347.9H199.1c-8.7 0-15.8-7.1-15.8-15.8 0-8.7 7.1-15.8 15.8-15.8H445c8.7 0 15.8 7.1 15.8 15.8 0 8.7-7 15.8-15.8 15.8zM436.3 478.1H199.1c-8.7 0-15.8-7.1-15.8-15.8 0-8.7 7.1-15.8 15.8-15.8h237.2c8.7 0 15.8 7.1 15.8 15.8 0 8.7-7.1 15.8-15.8 15.8zM357.4 608.2H199.1c-8.7 0-15.8-7.1-15.8-15.8 0-8.7 7.1-15.8 15.8-15.8h158.3c8.7 0 15.8 7.1 15.8 15.8 0 8.8-7.1 15.8-15.8 15.8z" fill="#E86262" p-id="19448"><\/path><path d="M484 853.6c-0.8 0-1.6 0-2.4-0.1l-284.1-13.3c-47.6-2.2-84.9-45-84.9-97.5v-502c0-28.3 11.1-55.2 30.6-73.7 17.1-16.4 39.1-24.6 61.9-23.8l281.4 13.1c30.3 1.4 54 28.6 54 61.9v573.2c0 18-7.1 35-19.4 46.8-10.5 10.1-23.5 15.4-37.1 15.4zM201.2 174.9c-13.2 0-26 5.3-36.3 15.1-13.2 12.6-20.8 31.1-20.8 50.8v502c0 35.5 24.1 64.5 54.8 65.9L483 822c8.1 0.7 12.8-3.3 16.1-6.4 6.1-5.8 9.6-14.6 9.6-23.9V218.4c0-16.1-10.7-29.7-23.8-30.3L203.5 175c-0.8-0.1-1.5-0.1-2.3-0.1z" fill="#E86262" p-id="19449"><\/path><path d="M463.4 858.7c-1 0-2.1 0-3.1-0.1l-328.2-13C76.6 843.5 33 800.1 33 746.9V237c0-26.3 10.7-51.1 30.1-69.7 20.4-19.6 48.8-30 77.5-29l335.1 13.2c36.3 1.4 64.7 29.9 64.7 64.8v568.6c0 19.7-8 38.2-22.5 52.1-14.4 13.9-34.1 21.7-54.5 21.7z m-1.9-31.6c13 0.6 25.5-4.2 34.5-12.8 8.2-7.9 12.8-18.3 12.8-29.3V216.3c0-17.8-15.1-32.4-34.4-33.2l-335.1-13.2c-20.5-0.7-40.2 6.6-54.4 20.2-13.1 12.6-20.4 29.3-20.4 46.9v509.9c0 36.2 30.2 65.7 68.7 67.2l328.3 13z" fill="#E86262" p-id="19450"><\/path><path d="M845.1 347.9h-246c-8.7 0-15.8-7.1-15.8-15.8 0-8.7 7.1-15.8 15.8-15.8H845c8.7 0 15.8 7.1 15.8 15.8 0.1 8.7-7 15.8-15.7 15.8zM836.3 478.1H599.1c-8.7 0-15.8-7.1-15.8-15.8 0-8.7 7.1-15.8 15.8-15.8h237.2c8.7 0 15.8 7.1 15.8 15.8 0 8.7-7 15.8-15.8 15.8zM757.4 608.2H599.1c-8.7 0-15.8-7.1-15.8-15.8 0-8.7 7.1-15.8 15.8-15.8h158.3c8.7 0 15.8 7.1 15.8 15.8 0 8.8-7.1 15.8-15.8 15.8z" fill="#E86262" p-id="19451"><\/path><path d="M560.2 853.6c-13.6 0-26.7-5.3-36.9-15.2-12.3-11.8-19.4-28.8-19.4-46.8V218.4c0-33.3 23.7-60.5 54-61.9l281.4-13.1c22.8-1 44.7 7.4 61.9 23.8 19.4 18.5 30.6 45.4 30.6 73.7v502c0 52.4-37.3 95.2-84.9 97.5l-284.1 13.3c-1-0.1-1.8-0.1-2.6-0.1z m282.7-678.7c-0.8 0-1.5 0-2.3 0.1l-281.4 13.1c-13.1 0.6-23.8 14.2-23.8 30.3v573.2c0 9.4 3.5 18.1 9.6 23.9 3.3 3.1 9 7 16.1 6.4l284.1-13.3c30.7-1.4 54.8-30.4 54.8-65.9v-502c0-19.7-7.6-38.2-20.8-50.8-10.2-9.7-23-15-36.3-15z" fill="#E86262" p-id="19452"><\/path><path d="M580.7 858.7c-20.4 0-40.1-7.8-54.5-21.7-14.5-13.9-22.5-32.4-22.5-52.1V216.3c0-34.9 28.4-63.3 64.7-64.8l335.1-13.2c28.9-0.9 57.1 9.4 77.5 29 19.4 18.6 30.1 43.4 30.1 69.7v509.9c0 53.2-43.5 96.6-99.1 98.8l-328.2 13h-3.1z m327.1-688.9c-1 0-2 0-3 0.1l-335.1 13.2c-19.3 0.8-34.4 15.3-34.4 33.2v568.6c0 11 4.5 21.4 12.8 29.3 9 8.7 21.8 13.4 34.5 12.8l328.2-13c38.5-1.5 68.7-31 68.7-67.2V237c0-17.6-7.2-34.3-20.4-46.9-13.5-13-32.1-20.3-51.3-20.3z" fill="#E86262" p-id="19453"><\/path><\/svg>","sort":"9"},"9":{"name":"活动大全","ico":"<svg t="1670658600164" class="icon" viewBox="0 0 1024 1024" version="1.1" xm<x>lns="http:\/\/www.w3.org\/2000\/svg" p-id="20661" width="16" height="16"><path d="M820.819484 273.272897 793.987373 273.272897c13.606903-23.070438 19.577894-45.074591 17.669428-65.485457-1.583055-17.083074-9.679453-41.514509-39.347147-60.98598-24.597211-16.181541-56.228629-20.149922-91.321892-11.383258-56.909128 14.288424-124.261095 63.410192-168.546717 122.774231-44.312228-59.363016-111.610984-108.485807-168.518065-122.774231-35.121915-8.823969-66.780963-4.827959-91.375104 11.383258-29.642111 19.47147-37.739533 43.902906-39.321564 60.98598-1.907443 20.410865 4.00829 42.416042 17.669428 65.485457l-26.832112 0c-40.628326 0-73.692373 33.089629-73.692373 73.747631l0 94.988398c0 32.162514 21.214161 60.588937 51.90516 70.134337-2.917446 8.070816-4.444219 16.413831-4.444219 24.868387l0 284.980543c0 40.630373 33.101909 73.733305 73.733305 73.733305l521.833973 0c40.628326 0 73.678046-33.101909 73.678046-73.733305l0-284.981566c0-8.508791-1.471514-16.878412-4.38896-24.89704 30.645974-9.598612 51.809993-38.025035 51.809993-70.106708l0-94.963839C894.498554 306.389132 861.448834 273.272897 820.819484 273.272897M773.399475 843.208401 538.674523 843.208401 538.674523 515.76986l234.725976 0c11.698436 0 21.185508 9.543354 21.185508 21.24179l0 284.980543C794.584983 833.691653 785.097912 843.208401 773.399475 843.208401M567.57883 273.272897c37.33021-43.058678 86.329181-76.896344 126.116349-86.877673 20.667715-5.179976 37.573757-3.761674 49.818639 4.310166 13.008268 8.546653 15.322987 16.168238 15.842827 21.923312 2.070148 21.104667-20.561291 49.558719-31.249725 60.645219L567.57883 273.272897zM841.97941 347.046111l0 94.963839c0 11.698436-9.461489 21.213137-21.159926 21.213137L538.674523 463.223087 538.674523 325.818647l282.144962 0C832.516898 325.818647 841.97941 335.349721 841.97941 347.046111M486.181985 515.76986l0 327.437517L251.565503 843.207377c-11.727089 0-21.216207-9.516748-21.216207-21.215184l0-284.980543c0-11.698436 9.490142-21.24179 21.216207-21.24179L486.181985 515.76986zM265.527492 212.628702c0.51677-5.756097 2.863211-13.377682 15.816221-21.923312 12.159948-8.071839 29.065989-9.559727 49.846268-4.310166 39.565111 9.925047 88.511893 43.765783 125.923968 86.877673L296.721959 273.272897C287.150976 263.579117 263.426645 234.238882 265.527492 212.628702M182.849468 347.046111c0-11.695367 9.490142-21.228487 21.213137-21.228487l282.118356 0 0 137.40444L204.062606 463.222063c-11.724019 0-21.213137-9.513678-21.213137-21.213137L182.849468 347.046111z" p-id="20662" fill="#1296db"><\/path><\/svg>","sort":"10"},"10":{"name":"建站服务","ico":"<svg t="1670658620548" class="icon" viewBox="0 0 1024 1024" version="1.1" xm<x>lns="http:\/\/www.w3.org\/2000\/svg" p-id="21714" width="16" height="16"><path d="M640 896v64h-256v-64H64v-64h320v-64h256v64h320v64H640zM64 64h896v640H64V64z m128 512h640V192H192v384z" fill="#0590DF" p-id="21715"><\/path><\/svg>","sort":"11"},"11":{"name":"增值业务","ico":"<svg t="1670658673530" class="icon" viewBox="0 0 1024 1024" version="1.1" xm<x>lns="http:\/\/www.w3.org\/2000\/svg" p-id="22652" width="16" height="16"><path d="M512 65.311495c-246.699682 0-446.688505 199.989847-446.688505 446.688505s199.989847 446.688505 446.688505 446.688505S958.688505 758.699682 958.688505 512 758.698658 65.311495 512 65.311495zM309.953308 567.255465c-30.517037 0-55.255465-24.738427-55.255465-55.255465s24.738427-55.255465 55.255465-55.255465 55.255465 24.738427 55.255465 55.255465S340.470345 567.255465 309.953308 567.255465zM512 567.255465c-30.517037 0-55.255465-24.738427-55.255465-55.255465s24.738427-55.255465 55.255465-55.255465c30.517037 0 55.255465 24.738427 55.255465 55.255465S542.517037 567.255465 512 567.255465zM714.046692 567.255465c-30.517037 0-55.255465-24.738427-55.255465-55.255465s24.738427-55.255465 55.255465-55.255465 55.255465 24.738427 55.255465 55.255465S744.56373 567.255465 714.046692 567.255465z" p-id="22653" fill="#1296db"><\/path><\/svg>","sort":"2"}}');
ALTER TABLE lw_goods ADD COLUMN pay_type varchar(255) DEFAULT '' COMMENT '支付类型' AFTER is_local;
ALTER TABLE lw_order ADD COLUMN pay_channel varchar(255) DEFAULT '' COMMENT '支付类型' AFTER cha_time;
ALTER TABLE lw_order ADD COLUMN is_read tinyint(3) DEFAULT 0 COMMENT '是否已读' AFTER cha_time;
INSERT INTO `lw_manager_class` (`manager_id`, `manager_name`, `manager_url`, `manager_type`, `create_time`, `pid`, `is_open`, `delete_time`, `top_id`) VALUES (604, '官方货源', 'goods/goodsadmin', '2097152', '0', '600', '1', '0', '600');
ALTER TABLE lw_user ADD COLUMN is_send_email tinyint(3) DEFAULT 1 COMMENT '是否接收邮件' AFTER money_t;
UPDATE `lw_plugs` SET `templateform` = '{"appid":"易支付ID","appkey":"易支付密钥","appurl":"易支付地址","alipay":1,"wxpay":2,"qqpay":3}'  WHERE `lw_plugs`.`plug_sign` = 'yi_pay';
ALTER TABLE lw_goods ADD COLUMN img_time int(11) DEFAULT 0 COMMENT '图片检测' AFTER is_local;
INSERT INTO `lw_manager_class` (`manager_id`, `manager_name`, `manager_url`, `manager_type`, `create_time`, `pid`, `is_open`, `delete_time`, `top_id`) VALUES (410, '密价组别', 'goods/mijiagroup', '131072', '0', '400', '1', '0', '400');
INSERT INTO `lw_manager_class` (`manager_id`, `manager_name`, `manager_url`, `manager_type`, `create_time`, `pid`, `is_open`, `delete_time`, `top_id`) VALUES (411, '密价组操作', 'goods/mijiagroupajax', '131072', '0', '400', '0', '0', '410');
INSERT INTO `lw_manager_class` (`manager_id`, `manager_name`, `manager_url`, `manager_type`, `create_time`, `pid`, `is_open`, `delete_time`, `top_id`) VALUES (412, '密价组商品', 'goods/mijiagroupgoods', '131072', '0', '400', '0', '0', '410');
CREATE TABLE `lw_mijia_group`  (`id` int(11) NOT NULL AUTO_INCREMENT,`title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`status` int(3) NULL DEFAULT 1,`create_time` int(11) NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
CREATE TABLE `lw_mijia_goods_group`  (  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,  `goods_id` int(11) NULL DEFAULT NULL,  `group_id` int(11) NULL DEFAULT NULL,  `create_time` int(11) NULL DEFAULT 0,  `price` decimal(10, 2) NULL DEFAULT 0.00,  PRIMARY KEY (`id`) USING BTREE,  INDEX `goods_id`(`goods_id`) USING BTREE,  INDEX `group_id`(`group_id`) USING BTREE) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
ALTER TABLE lw_user ADD COLUMN mi_group int(11) DEFAULT 0 COMMENT '密价组id' AFTER money_t;
DROP TABLE IF EXISTS `lw_invitation`;CREATE TABLE `lw_invitation`  (`id` int(11) NOT NULL AUTO_INCREMENT,`code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`create_time` int(11) NULL DEFAULT NULL,`status` int(11) NULL DEFAULT 0,`update_time` int(11) NULL DEFAULT NULL,PRIMARY KEY (`id`) USING BTREE) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;SET FOREIGN_KEY_CHECKS = 1;
UPDATE `lw_manager_class` SET `manager_name` = '对接配置' WHERE `lw_manager_class`.`manager_id` = 600;
UPDATE `lw_manager_class` SET `manager_name` = '对接商品' WHERE `lw_manager_class`.`manager_id` = 601;
UPDATE `lw_manager_class` SET `manager_name` = '对接平台' WHERE `lw_manager_class`.`manager_id` = 610;
ALTER TABLE lw_api_goods modify column goods_api_good varchar(50);
ALTER TABLE lw_card modify column card_content text;
UPDATE `lw_plugs` SET `templateform` = '{\"appid\":\"云宝APPID\",\"appkey\":\"云宝密钥\",\"appzfb\":\"支付宝账号写1关闭转账\",\"appname\":\"支付宝姓名\",\"alipay\":1,\"wxpay\":3,\"qqpay\":2}' , `plug_name`='优云宝' WHERE `lw_plugs`.`plug_sign` = 'huanxi_pay';
ALTER TABLE lw_liushui ADD COLUMN money_info text  COMMENT '充值信息' AFTER time;
ALTER TABLE lw_api_list ADD COLUMN is_status tinyint(3) DEFAULT 0 COMMENT '状态' AFTER time;
ALTER TABLE lw_api_list ADD COLUMN cha_time int(10) DEFAULT 0 COMMENT '查单时间' AFTER time;
ALTER TABLE lw_api_list ADD COLUMN s_money decimal(12,2) DEFAULT 0 COMMENT '剩余金额' AFTER time;
ALTER TABLE lw_user ADD COLUMN t_username varchar(50) DEFAULT '' COMMENT '推荐注册人' AFTER token;
ALTER TABLE lw_order ADD COLUMN t_profit_status tinyint(3) DEFAULT 0 COMMENT '退款状态' AFTER t_money;
ALTER TABLE lw_user ADD COLUMN money_t int(11) DEFAULT 0 COMMENT '金额预警' AFTER token;
ALTER TABLE lw_api_goods ADD COLUMN is_open int(11) DEFAULT 0 COMMENT '是否比价' AFTER update_desc;
ALTER TABLE lw_api_goods ADD COLUMN b_time int(11) DEFAULT 0 COMMENT '比价时间' AFTER update_desc;
ALTER TABLE lw_order ADD COLUMN goods_api_type int(5) DEFAULT 0 COMMENT '对接类型' AFTER notebook;
ALTER TABLE lw_order ADD COLUMN goods_api_id int(11) DEFAULT 0 COMMENT 'api对接id' AFTER notebook;
DROP INDEX goods_id ON lw_api_goods;
ALTER TABLE lw_api_goods ADD UNIQUE goods_id(goods_id,goods_api_id,goods_api_good);
ALTER TABLE lw_goods ADD COLUMN is_local tinyint(3) DEFAULT 2 COMMENT '优先本地' AFTER goods_recommend;
ALTER TABLE lw_order ADD COLUMN notebook varchar(255) DEFAULT '' COMMENT '记事本' AFTER ua;
alter table lw_order modify column templates text;
ALTER TABLE lw_order ADD COLUMN t_money decimal(12, 2) DEFAULT 0 COMMENT '退款记录' AFTER ordermsg_type;
ALTER TABLE lw_order ADD COLUMN t_site_money decimal(12, 2) DEFAULT 0 COMMENT '分站t记录' AFTER ordermsg_type;
ALTER TABLE lw_order ADD COLUMN t_status int(3) DEFAULT 2 COMMENT '退款状态 2 人工处理 1网站余额' AFTER ordermsg_type;
ALTER TABLE lw_goods ADD COLUMN j_api int(3) DEFAULT 1 COMMENT '是否需要监控价格 1监控 2 不监控' AFTER goods_str3;
ALTER TABLE lw_order ADD COLUMN t_s int(3) DEFAULT 0 COMMENT '推送提醒 0 未推送 1 已推送 ' AFTER ordermsg_type;
alter table lw_order alter column t_s drop default;
alter table lw_order alter column t_s set default 0;
图片[1]-乐商网(LWSCMS) 系统版本更新SQL记录-乐商网络
© 版权声明
THE END
喜欢就支持一下吧
点赞8赞赏 分享
评论 抢沙发
头像
欢迎您留下宝贵的见解!
提交
头像

昵称

取消
昵称表情代码图片

    暂无评论内容