乐商网(LWSCMS) 系统版本更新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;
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赞赏 分享
评论 抢沙发
头像
欢迎您留下宝贵的见解!
提交
头像

昵称

取消
昵称表情代码图片

    暂无评论内容