upd: store different types of revocation

[gigi.git] / src / club / wpia / gigi / database / upgrade / from_28.sql

diff --git a/src/club/wpia/gigi/database/upgrade/from_28.sql b/src/club/wpia/gigi/database/upgrade/from_28.sql
new file mode 100644 (file)
index 0000000..a381a13
--- /dev/null
+++ b/src/club/wpia/gigi/database/upgrade/from_28.sql
@@ -0,0 +1,2 @@
+CREATE TYPE "revocationType" AS ENUM('user', 'support', 'ping_timeout');
+ALTER TABLE "certs" ADD COLUMN  "revocationType" "revocationType" NULL;