[cvs] [Wiki] changed: SQLAuthHowTo

[Eric Rostetter]

ericr  Mon, 15 Sep 2008 23:44:21 -0400

Modified page: http://wiki.horde.org/SQLAuthHowTo
New Revision:  1.5
Change log:  indent sql statements

@@ -29,17 +29,17 @@
  * Set the username and password paramters to the SQL database  
username and password you set when creating the database
  * Set the encryption to use to store the password in the table to  
crypt-md5 (is this correct?)
  * Set the database field to the one defined when you configured  
dovecot's SQL database (in this case, we will use "users" like on the  
dovecot website)
  * For query_auth, enter:
-SELECT * FROM users WHERE userid = \L AND password = MD5(\P);
+> SELECT * FROM users WHERE userid = \L AND password = MD5(\P);
  * For query_add, enter:
-INSERT INTO users (domain,userid,password) VALUES ('example.org', \L,  
MD5(\P));
-NB: Change the domain to your domain in the above query.
+> INSERT INTO users (domain,userid,password) VALUES ('example.org',  
\L, MD5(\P));
+>> NB: Change the domain to your domain in the above query.
  * For query_update, enter:
-UPDATE users SET password = MD5(\P) WHERE userid =  
TRIM('@example.org' FROM \L) LIMIT 1;
-NB: Change the domain to your domain in the above query.
+> UPDATE users SET password = MD5(\P) WHERE userid =  
TRIM('@example.org' FROM \L) LIMIT 1;
+>> NB: Change the domain to your domain in the above query.
  * For query_remove, enter:
-DELETE FROM users WHERE userid = TRIM('@example.org' FROM \L) LIMIT 1;
+> DELETE FROM users WHERE userid = TRIM('@example.org' FROM \L) LIMIT 1;
  * For query_list, enter:
-SELECT * FROM users;
+> SELECT * FROM users;
  * and so on for the other queries...