aboutsummaryrefslogtreecommitdiff
path: root/verify
diff options
context:
space:
mode:
Diffstat (limited to 'verify')
-rw-r--r--verify/articles_update_updated_at.sql14
-rw-r--r--verify/tags_update_updated_at.sql14
-rw-r--r--verify/update_updated_at.sql9
3 files changed, 0 insertions, 37 deletions
diff --git a/verify/articles_update_updated_at.sql b/verify/articles_update_updated_at.sql
deleted file mode 100644
index 744b1fd..0000000
--- a/verify/articles_update_updated_at.sql
+++ /dev/null
@@ -1,14 +0,0 @@
--- Verify diary:articles_update_updated_at on pg
-
-BEGIN;
-
-DO $$
- BEGIN
- ASSERT (SELECT 1 from information_schema.triggers
- WHERE trigger_schema = 'diary'
- AND event_object_table = 'articles'
- AND trigger_name = 'update_updated_at');
- END
-$$;
-
-ROLLBACK;
diff --git a/verify/tags_update_updated_at.sql b/verify/tags_update_updated_at.sql
deleted file mode 100644
index e6940ce..0000000
--- a/verify/tags_update_updated_at.sql
+++ /dev/null
@@ -1,14 +0,0 @@
--- Verify diary:tags_update_updated_at on pg
-
-BEGIN;
-
-DO $$
- BEGIN
- ASSERT (SELECT 1 from information_schema.triggers
- WHERE trigger_schema = 'diary'
- AND event_object_table = 'tags'
- AND trigger_name = 'update_updated_at');
- END
-$$;
-
-ROLLBACK;
diff --git a/verify/update_updated_at.sql b/verify/update_updated_at.sql
deleted file mode 100644
index 59c71be..0000000
--- a/verify/update_updated_at.sql
+++ /dev/null
@@ -1,9 +0,0 @@
--- Verify diary:update_updated_at on pg
-
-BEGIN;
-
-SET search_path to diary;
-
-SELECT has_function_privilege('update_updated_at()', 'EXECUTE');
-
-ROLLBACK;