summaryrefslogtreecommitdiff
path: root/db/rev.sql
diff options
context:
space:
mode:
authorFreya Murphy <freya@freyacat.org>2024-04-01 11:09:25 -0400
committerFreya Murphy <freya@freyacat.org>2024-04-01 11:09:25 -0400
commit3a82baec9d793edf81ac2b151b0f4d4159641375 (patch)
treef9d50c296b078ac48c2a2391c172c3ccf37edb3f /db/rev.sql
parentrefactor asset dir, refactor oberver in lib (diff)
downloadxssbook2-3a82baec9d793edf81ac2b151b0f4d4159641375.tar.gz
xssbook2-3a82baec9d793edf81ac2b151b0f4d4159641375.tar.bz2
xssbook2-3a82baec9d793edf81ac2b151b0f4d4159641375.zip
login and register, liking on homepage
Diffstat (limited to 'db/rev.sql')
-rw-r--r--db/rev.sql21
1 files changed, 0 insertions, 21 deletions
diff --git a/db/rev.sql b/db/rev.sql
deleted file mode 100644
index dff1cfe..0000000
--- a/db/rev.sql
+++ /dev/null
@@ -1,21 +0,0 @@
-CREATE OR REPLACE FUNCTION curr_revision()
-RETURNS INTEGER
-LANGUAGE plpgsql VOLATILE
-AS $BODY$
-DECLARE
- _revision INTEGER;
-BEGIN
- BEGIN
- SELECT curr_revision INTO _revision
- FROM sys.database_info
- WHERE name = current_database();
- RETURN _revision;
- EXCEPTION WHEN OTHERS THEN
- RETURN 0;
- END;
-END
-$BODY$;
-
-GRANT EXECUTE ON FUNCTION curr_revision() TO xssbook;
-
-SELECT curr_revision();