版本更新SQL记录

[wxshow]

[zd-plane title=”3.5.0 版本SQL”]

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;

[/zd-plane]

[zd-plane title=”3.4.9 版本SQL”]

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;

[/zd-plane]

[zd-plane title=”3.4.7 版本SQL”]

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;

[/zd-plane]

[zd-plane title=”3.4.6 版本SQL”]

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

[/zd-plane]

[zd-plane title=”3.4.4 版本SQL”]

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;

[/zd-plane]

此处内容已经被作者隐藏，请输入验证码查看内容

验证码：

请关注本站微信公众号，回复“百宝箱”，获取验证码。在微信里搜索“工具人博客”或者“ishoud_com”或者微信扫描右侧二维码都可以关注本站微信公众号。

[/wxshow]