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