uptime-kuma/db/old_migrations/patch-add-other-auth.sql

19 lines
316 B
MySQL
Raw Permalink Normal View History

2022-05-13 14:06:41 +00:00
BEGIN TRANSACTION;
ALTER TABLE monitor
ADD auth_method VARCHAR(250);
2022-05-13 17:58:23 +00:00
ALTER TABLE monitor
ADD auth_domain TEXT;
ALTER TABLE monitor
2022-05-13 14:06:41 +00:00
2022-05-13 17:58:23 +00:00
ADD auth_workstation TEXT;
2022-05-13 14:06:41 +00:00
2022-05-13 17:58:23 +00:00
COMMIT;
2022-05-13 14:06:41 +00:00
2022-05-13 17:58:23 +00:00
BEGIN TRANSACTION;
UPDATE monitor
SET auth_method = 'basic'
WHERE basic_auth_user is not null;
2022-05-13 14:06:41 +00:00
COMMIT;