X-Git-Url: https://vcs.fsf.org/?p=squirrelmail.git;a=blobdiff_plain;f=doc%2Fdb-backend.txt;h=41feffc00f57c14ca1c11a3f3e2a5010bf93695d;hp=4b3a6d94eff973803c34b1a6b86eea6a2164c849;hb=1e63b43003a372f5b420d5696ccb54ff45bd7972;hpb=97445d7d882729c7b222b4f35395b61e31d5049e;ds=sidebyside diff --git a/doc/db-backend.txt b/doc/db-backend.txt index 4b3a6d94..41feffc0 100644 --- a/doc/db-backend.txt +++ b/doc/db-backend.txt @@ -6,11 +6,11 @@ Storing private addressbooks and preferences in a database On sites with many users you might want to store your user data in a -database instead of in files. This document describe how to configure +database instead of in files. This document describes how to configure SquirrelMail to do this. Methods for storing both personal addressbooks and user preferences in -a database is as a part of the distribution. +a database is included as a part of the distribution. @@ -41,7 +41,7 @@ For MySQL you would normally do something like: The table structure should be similar to this (for MySQL): CREATE TABLE address ( - owner varchar(16) DEFAULT '' NOT NULL, + owner varchar(128) DEFAULT '' NOT NULL, nickname varchar(16) DEFAULT '' NOT NULL, firstname varchar(128) DEFAULT '' NOT NULL, lastname varchar(128) DEFAULT '' NOT NULL, @@ -72,9 +72,9 @@ point to a database you create (can be the same you use for addressbooks). Create a table similar to this (for MySQL): CREATE TABLE userprefs ( - user varchar(32) DEFAULT '' NOT NULL, + user varchar(128) DEFAULT '' NOT NULL, prefkey varchar(64) DEFAULT '' NOT NULL, - prefval blob DEFAULT '' NOT NULL, + prefval BLOB DEFAULT '' NOT NULL, PRIMARY KEY (user,prefkey) );