From 16653a77d8f8ed0585890fcc464f743815c3ef75 Mon Sep 17 00:00:00 2001 From: Daniel Hokka Zakrisson Date: Sat, 16 Oct 2010 17:46:50 -0400 Subject: [PATCH] Add migration files for the extensions. --- migrations/103-down-extensions.sql | 1 + migrations/103-up-extensions.sql | 6 ++++++ 2 files changed, 7 insertions(+) create mode 100644 migrations/103-down-extensions.sql create mode 100644 migrations/103-up-extensions.sql diff --git a/migrations/103-down-extensions.sql b/migrations/103-down-extensions.sql new file mode 100644 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 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; -- 2.43.0