Add migration files for the extensions.

[plcapi.git] / migrations / 103-up-extensions.sql

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;