mirror of
https://github.com/wavetermdev/waveterm.git
synced 2025-01-04 18:59:08 +01:00
15 lines
301 B
MySQL
15 lines
301 B
MySQL
|
ALTER TABLE remote ADD COLUMN remotesudo;
|
||
|
|
|
||
|
|
UPDATE remote
|
||
|
|
SET remotesudo = 1
|
||
|
|
WHERE json_extract(sshopts, '$.issudo')
|
||
|
|
;
|
||
|
|
|
||
|
|
UPDATE remote
|
||
|
|
SET sshopts = json_remove(sshopts, '$.issudo')
|
||
|
|
;
|
||
|
|
|
||
|
|
ALTER TABLE remote ADD COLUMN physicalid varchar(36) NOT NULL DEFAULT '';
|
||
|
|
|
||
|
|
ALTER TABLE remote DROP COLUMN openaiopts;
|