main/postgresql: add script for creating pltcl_* tables

1 files changed, 13 insertions, 0 deletions

diff --git a/main/postgresql/pltcl_create_tables.sql b/main/postgresql/pltcl_create_tables.sql
new file mode 100644
index 0000000000..76c7a954af
--- /dev/null
+++ b/main/postgresql/pltcl_create_tables.sql
@@ -0,0 +1,13 @@
+-- Create tables needed for PL/Tcl autoloading. This script should be run by
+-- the database administrator only.
+--
+-- Statements in this script are extracted from pltcl_loadmod script.
+--
+-- Author: G.J.R. Timmer
+-- Date: 2017-01-28
+
+create table pltcl_modules (modname name, modseq int2, modsrc text);
+create index pltcl_modules_i on pltcl_modules using btree (modname name_ops);
+
+create table pltcl_modfuncs (funcname name, modname name);
+create index pltcl_modfuncs_i on pltcl_modfuncs using hash (funcname name_ops);