From 7ac2b3722ba3bfeb5de6efcd94dd97c411607fd8 Mon Sep 17 00:00:00 2001 From: simond Date: Tue, 19 Feb 2002 08:29:46 +0000 Subject: [PATCH] Add PostgreSQL details git-svn-id: https://svn.code.sf.net/p/squirrelmail/code/trunk/squirrelmail@2468 7612ce4b-ef26-0410-bec9-ea0150e637f0 --- doc/db-backend.txt | 21 +++++++++++++++++++++ 1 file changed, 21 insertions(+) diff --git a/doc/db-backend.txt b/doc/db-backend.txt index 3712c376..1e12922e 100644 --- a/doc/db-backend.txt +++ b/doc/db-backend.txt @@ -55,6 +55,19 @@ The table structure should be similar to this (for MySQL): KEY firstname (firstname,lastname) ); +and similar to this for PostgreSQL: +CREATE TABLE "address" ( + "owner" varchar(128) NOT NULL, + "nickname" varchar(16) NOT NULL, + "firstname" varchar(128) NOT NULL, + "lastname" varchar(128) NOT NULL, + "email" varchar(128) NOT NULL, + "label" varchar(255) NOT NULL, + CONSTRAINT "address_pkey" PRIMARY KEY ("nickname", "owner") +); +CREATE UNIQUE INDEX "address_firstname_key" ON "address" + ("firstname", "lastname"); + Next, edit your configuration so that the address book DSN (Data Source Name) is specified, this can be done using either conf.pl or via the @@ -82,6 +95,14 @@ The table structure should be similar to this (for MySQL): PRIMARY KEY (user,prefkey) ); +and for PostgreSQL: +CREATE TABLE "userprefs" ( + "user" varchar(128) NOT NULL, + "prefkey" varchar(64) NOT NULL, + "prefval" text, + CONSTRAINT "userprefs_pkey" PRIMARY KEY ("prefkey", "user") +); + Next, edit your configuration so that the preferences DSN (Data Source Name) is specified, this can be done using either conf.pl or via the administration plugin. The DSN should look something like: -- 2.25.1