2026-03-26 12:46:27 -04:00
|
|
|
-- SPDX-FileCopyrightText: 2021 Icinga GmbH <https://icinga.com>
|
|
|
|
|
-- SPDX-License-Identifier: GPL-3.0-or-later
|
|
|
|
|
|
2021-05-21 09:43:06 -04:00
|
|
|
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"
|
|
|
|
|
);
|
