mirror of
https://github.com/wavetermdev/backup.git
synced 2026-08-05 13:57:07 -07:00
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)
|
||
|
|
;
|