20200412.sql 836 B

123456789101112
  1. rename table `email_log` to `notification_log`;
  2. alter table `notification_log` COMMENT = '通知投递记录';
  3. alter table `notification_log` CHANGE `type` `type` TINYINT(4) NOT NULL DEFAULT '1' COMMENT '类型:1-邮件、2-ServerChan、3-Bark';
  4. -- 加入Bark通知
  5. insert into `config` VALUES ('104', 'bark_key', '');
  6. update `config` SET `name` = 'is_node_offline' where `config`.`id` = 37;
  7. update `config` SET `name` = 'is_notification', `value` = '0' where `config`.`id` = 39;
  8. update `config` SET `name` = 'is_email_filtering',`value` = '0' where `config`.`id` = 58;
  9. update `config` SET `name` = 'detection_check_times' where `config`.`id` = 68;
  10. update `config` SET `name` = 'is_activate_account', `value` = '0' where `config`.`id` = 73;
  11. update `config` SET `name` = 'offline_check_times', `value` = '10' where `config`.`id` = 98;