From b9055ec9d4057822f2955066bdec59c71418feef Mon Sep 17 00:00:00 2001
From: Karen Arutyunov <karen@codesynthesis.com>
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

