tomsun28 commented on PR #1875:
URL: https://github.com/apache/hertzbeat/pull/1875#issuecomment-2081366682

   -- for to hertzbeat v1.6.0 upgrade in mysql, user need run this by themself, 
ignore for non-upgrading -> 1.6.0 users
   ```
   # UPDATE hzb_param SET param_value = `value` WHERE `value` IS NOT NULL AND 
param_value IS NULL;
   # ALTER TABLE hzb_param DROP COLUMN `value`;
   # commit;
   # 
   # UPDATE hzb_tag SET tag_value = `value` WHERE `value` IS NOT NULL AND 
tag_value IS NULL;
   # ALTER TABLE hzb_tag DROP COLUMN `value`;
   # commit;
   # 
   # UPDATE hzb_status_page_history SET unknowing = `unknown` WHERE `unknown` 
IS NOT NULL AND unknowing IS NULL;
   # ALTER TABLE hzb_status_page_history DROP COLUMN `unknown`;
   # commit;
   ```


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to