Add migration files for the extensions.

diff --git a/migrations/103-down-extensions.sql b/migrations/103-down-extensions.sql
new file mode 100644 (file)
index 0000000..a0797df
--- /dev/null
+++ b/migrations/103-down-extensions.sql
@@ -0,0 +1 @@
+DROP TABLE plc_db_extensions;

diff --git a/migrations/103-up-extensions.sql b/migrations/103-up-extensions.sql
new file mode 100644 (file)
index 0000000..c411049
--- /dev/null
+++ b/migrations/103-up-extensions.sql
@@ -0,0 +1,6 @@
+CREATE TABLE plc_db_extensions (
+    name text NOT NULL PRIMARY KEY,
+    version integer NOT NULL
+) WITH OIDS;
+
+UPDATE plc_db_version SET subversion = 103;