mirror of
https://github.com/wavetermdev/backup.git
synced 2026-04-22 15:26:58 -07:00
sawka
6 lines
160 B
SQL
6 lines
160 B
SQL
ALTER TABLE cmd ADD COLUMN screenid varchar(36) NOT NULL DEFAULT '';
|
|
|
|
UPDATE cmd
|
|
SET screenid = (SELECT line.screenid FROM line WHERE line.cmdid = cmd.cmdid)
|
|
;
|