summaryrefslogtreecommitdiffstats
path: root/schema/postgresql/t/00-create-db.sql
diff options
context:
space:
mode:
Diffstat (limited to 'schema/postgresql/t/00-create-db.sql')
-rw-r--r--schema/postgresql/t/00-create-db.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/schema/postgresql/t/00-create-db.sql b/schema/postgresql/t/00-create-db.sql
new file mode 100644
index 0000000..5e0e78a
--- /dev/null
+++ b/schema/postgresql/t/00-create-db.sql
@@ -0,0 +1,4 @@
+--create database icinga2;
+CREATE EXTENSION IF NOT EXISTS pgtap;
+SELECT plan(1);
+SELECT is(count(*) , 1::bigint,'Extension pg_tap installed') FROM pg_extension WHERE extname = 'pgtap';