Move hcoop changes to quilt patch
[hcoop/debian/courier-authlib.git] / README.authpostgres.html
CommitLineData
d9898ee8 1<?xml version="1.0" encoding="iso-8859-1"?>
2<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
b0322a85
CE
3 "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
4
d9898ee8 5<html xmlns="http://www.w3.org/1999/xhtml">
6<head>
7 <title>Courier PostgreSQL authentication module</title>
8 <meta name="MSSmartTagsPreventParsing" content="TRUE" />
9</head>
10
b0322a85
CE
11<body text="#000000" bgcolor="#FFFFFF" link="#0000EE" vlink=
12"#551A8B" alink="#FF0000">
13 <h1>Courier PostgreSQL authentication module</h1>
d9898ee8 14
b0322a85
CE
15 <p>Please read <a href=
16 "README.authmysql.html">README.authmysql.html</a> since almost
17 all information there applies to postgres as well, but with
18 Postgres change the schema to:</p>
19 <pre>
20CREATE TABLE passwd (
d9898ee8 21 id varchar(128) DEFAULT '' NOT NULL,
22 crypt varchar(128) DEFAULT '' NOT NULL,
23 clear varchar(128) DEFAULT '' NOT NULL,
24 name varchar(128) DEFAULT '' NOT NULL,
25 uid int DEFAULT 65534 NOT NULL,
26 gid int DEFAULT 65534 NOT NULL,
27 home varchar(255) DEFAULT '' NOT NULL,
28 maildir varchar(255) DEFAULT '' NOT NULL,
29 defaultdelivery varchar(255) DEFAULT '' NOT NULL,
30 quota varchar(255) DEFAULT '' NOT NULL,
31 CONSTRAINT id PRIMARY KEY (id)
b0322a85
CE
32);
33</pre>
d9898ee8 34</body>
35</html>