You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
36 lines
2.2 KiB
36 lines
2.2 KiB
|
|
alter table sms_home_new_product add `original_price` decimal(10,2) DEFAULT NULL COMMENT '市场价';
|
|
alter table sms_home_recommend_product add `original_price` decimal(10,2) DEFAULT NULL COMMENT '市场价';
|
|
|
|
update sms_home_new_product shnp set
|
|
original_price=(select pp.original_price from pms_product pp where pp.id=shnp.product_id limit 1),
|
|
price=(select pp.price from pms_product pp where pp.id=shnp.product_id limit 1)
|
|
|
|
update sms_home_recommend_product shnp set
|
|
original_price=(select pp.original_price from pms_product pp where pp.id=shnp.product_id limit 1),
|
|
price=(select pp.price from pms_product pp where pp.id=shnp.product_id limit 1)
|
|
|
|
|
|
select * from sys_message
|
|
|
|
delete from sys_message where 1=1
|
|
|
|
insert into sys_message values
|
|
(1,340,'交易物流','您有新的物流信息','您的订单商品已经到取货点，请在7日内取出。',now(),now(),0,1),
|
|
(2,340,'云链助手','该施肥了','春天已经至，已到施肥时间。。',now(),now(),0,1),
|
|
(3,341,'交易物流','您有新的物流信息','您的订单商品已经到取货点，请在7日内取出。',now(),now(),0,1),
|
|
(4,341,'云链助手','该施肥了','春天已经至，已到施肥时间。。',now(),now(),0,1);
|
|
|
|
SELECT id,user_id,code,params,content,ctime,utime,status FROM sys_message WHERE user_id = 341 ORDER BY ctime desc
|
|
|
|
|
|
ALTER TABLE mallplus1.sys_message MODIFY COLUMN id int(10) unsigned auto_increment NOT NULL;
|
|
ALTER TABLE mallplus1.sys_message MODIFY COLUMN status tinyint(3) unsigned DEFAULT 0 NOT NULL COMMENT '0未查看，1已查看';
|
|
ALTER TABLE mallplus1.sys_message MODIFY COLUMN utime bigint(20) unsigned NULL COMMENT '查看时间';
|
|
ALTER TABLE mallplus1.sys_message MODIFY COLUMN content text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '内容';
|
|
ALTER TABLE mallplus1.sys_message MODIFY COLUMN params varchar(5000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '参数';
|
|
ALTER TABLE mallplus1.sys_message MODIFY COLUMN code varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '消息编码';
|
|
|
|
|
|
ALTER table mallplus1.sms_coupon_history modify column amount decimal(10,2) ;
|
|
update sms_coupon_history set amount = (select amount from sms_coupon where sms_coupon_history.coupon_id = sms_coupon.id)
|
|
|