diff options
Diffstat (limited to 'util/updates/update_2.16.sql')
-rw-r--r-- | util/updates/update_2.16.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/util/updates/update_2.16.sql b/util/updates/update_2.16.sql index 580be925..07050734 100644 --- a/util/updates/update_2.16.sql +++ b/util/updates/update_2.16.sql @@ -42,3 +42,7 @@ INSERT INTO vnlists SELECT CREATE CONSTRAINT TRIGGER update_vnlist_rlist AFTER DELETE ON vnlists DEFERRABLE FOR EACH ROW EXECUTE PROCEDURE update_vnlist_rlist(); CREATE CONSTRAINT TRIGGER update_vnlist_rlist AFTER INSERT ON rlists DEFERRABLE FOR EACH ROW EXECUTE PROCEDURE update_vnlist_rlist(); +-- remove rlists.vstat and rename rlists.rstat +ALTER TABLE rlists DROP COLUMN vstat; +ALTER TABLE rlists RENAME COLUMN rstat TO status; + |