mirror of
https://github.com/wavetermdev/waveterm.git
synced 2024-12-31 18:18:02 +01:00
7 lines
176 B
SQL
7 lines
176 B
SQL
ALTER TABLE history ADD COLUMN linenum int NOT NULL DEFAULT 0;
|
|
|
|
UPDATE history
|
|
SET linenum = COALESCE((SELECT line.linenum FROM line WHERE line.lineid = history.lineid), 0)
|
|
;
|
|
|