diff options
Diffstat (limited to 'SQL/postgres.initial.sql')
-rw-r--r-- | SQL/postgres.initial.sql | 17 |
1 files changed, 16 insertions, 1 deletions
diff --git a/SQL/postgres.initial.sql b/SQL/postgres.initial.sql index 209f0066c..5a3bafd1d 100644 --- a/SQL/postgres.initial.sql +++ b/SQL/postgres.initial.sql @@ -366,6 +366,21 @@ CREATE TABLE "filestore" ( ); -- +-- Table "uploads" +-- Name: uploads; Type: TABLE; Schema: public; Owner: postgres +-- + +CREATE TABLE "uploads" ( + upload_id varchar(64) PRIMARY KEY, + session_id varchar(128) NOT NULL, + "group" varchar(128) NOT NULL, + metadata text NOT NULL, + created timestamp with time zone DEFAULT now() NOT NULL +); + +CREATE INDEX uploads_session_id_idx ON uploads (session_id, "group", created); + +-- -- Table "system" -- Name: system; Type: TABLE; Schema: public; Owner: postgres -- @@ -375,4 +390,4 @@ CREATE TABLE "system" ( value text ); -INSERT INTO "system" (name, value) VALUES ('roundcube-version', '2022081200'); +INSERT INTO "system" (name, value) VALUES ('roundcube-version', '2022100100'); |