From b9055ec9d4057822f2955066bdec59c71418feef Mon Sep 17 00:00:00 2001 From: Karen Arutyunov Date: Fri, 12 Oct 2018 14:31:10 +0300 Subject: Recreate database schema extras on migration --- libbrep/package-extra.sql | 7 +++++++ 1 file changed, 7 insertions(+) (limited to 'libbrep/package-extra.sql') diff --git a/libbrep/package-extra.sql b/libbrep/package-extra.sql index 93c61d8..86f055b 100644 --- a/libbrep/package-extra.sql +++ b/libbrep/package-extra.sql @@ -8,6 +8,13 @@ -- * strings other then function bodies must be quoted with ' or " -- * statements must end with ";\n" -- +-- Increment the database 'package' schema version when update this file. Note +-- that the brep-migrate utility executes the drop SQL statements prior to the +-- schema migration and the create statements afterwards. That, in particular, +-- means that the extras may depend on the tables but not the other way +-- around. Make sure that the drop statements properly handle entities created +-- for all schema versions starting from LIBBREP_PACKAGE_SCHEMA_VERSION_BASE. +-- -- There is no need to drop to_tsvector() explicitly, as we can rely on "DROP -- TYPE IF EXISTS weighted_text CASCADE" statement below, which will drop all -- cgit v1.1