diff options
Diffstat (limited to 'util/dump.sql')
| -rw-r--r-- | util/dump.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/util/dump.sql b/util/dump.sql index f7f9bb9e..2bb4fda5 100644 --- a/util/dump.sql +++ b/util/dump.sql @@ -412,7 +412,7 @@ ALTER TABLE wlists ADD FOREIGN KEY (vid) REFERENCES vn -- F U N C T I O N S -- ------------------------- - + -- update_rev(table, ids) - updates the rev column in the changes table CREATE FUNCTION update_rev(tbl text, ids text) RETURNS void AS $$ DECLARE @@ -446,7 +446,7 @@ BEGIN IF id > 0 THEN w := ' WHERE id = '||id; END IF; - EXECUTE 'UPDATE vn SET + EXECUTE 'UPDATE vn SET c_released = COALESCE((SELECT MIN(rr1.released) FROM releases_rev rr1 |