1 files changed, 16 insertions, 0 deletions
diff --git a/schema/pgsql-upgrades/2.9.0.sql b/schema/pgsql-upgrades/2.9.0.sql
new file mode 100644
index 0000000..c017b91
--- /dev/null
+++ b/schema/pgsql-upgrades/2.9.0.sql
@@ -0,0 +1,16 @@
+CREATE TABLE "icingaweb_rememberme" (
+  "id"                  serial,
+  "username"            character varying(254) NOT NULL,
+  "passphrase"          character varying(256) NOT NULL,
+  "random_iv"           character varying(24) NOT NULL,
+  "http_user_agent"     text NOT NULL,
+  "expires_at"          timestamp NULL DEFAULT NULL,
+  "ctime"               timestamp NULL DEFAULT NULL,
+  "mtime"               timestamp NULL DEFAULT NULL
+);
+
+ALTER TABLE ONLY "icingaweb_rememberme"
+  ADD CONSTRAINT pk_icingaweb_rememberme
+  PRIMARY KEY (
+    "id"
+);