You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@spamassassin.apache.org by pa...@apache.org on 2004/03/01 06:09:39 UTC
svn commit: rev 6942 - incubator/spamassassin/trunk/sql
Author: parker
Date: Sun Feb 29 21:09:39 2004
New Revision: 6942
Modified:
incubator/spamassassin/trunk/sql/README
incubator/spamassassin/trunk/sql/userpref_mysql.sql
Log:
PR2457: Updated userpref create def, also re added the PHP admin stuff with a corrected URL
Modified: incubator/spamassassin/trunk/sql/README
==============================================================================
--- incubator/spamassassin/trunk/sql/README (original)
+++ incubator/spamassassin/trunk/sql/README Sun Feb 29 21:09:39 2004
@@ -202,3 +202,13 @@
NB: This should be considered BETA, and the interface, schema, or overall
operation of SQL support may change at any time with future releases of SA.
******
+
+PHP Interface
+-------------
+
+This can be downloaded from http://www.peregrinehw.com/downloads/SpamAssassin/old/,
+called "php-sa-mysql-n.n" where n.n is the version number.
+
+Please send any comments to jengland /at/ enetis.net .
+
+Justin England
Modified: incubator/spamassassin/trunk/sql/userpref_mysql.sql
==============================================================================
--- incubator/spamassassin/trunk/sql/userpref_mysql.sql (original)
+++ incubator/spamassassin/trunk/sql/userpref_mysql.sql Sun Feb 29 21:09:39 2004
@@ -1,9 +1,8 @@
CREATE TABLE userpref (
- username varchar(100) NOT NULL,
- preference varchar(30) NOT NULL,
- value varchar(100) NOT NULL,
+ username varchar(100) NOT NULL default '',
+ preference varchar(30) NOT NULL default '',
+ value varchar(100) NOT NULL default '',
prefid int(11) NOT NULL auto_increment,
- PRIMARY KEY (prefid),
- INDEX (username)
+ PRIMARY KEY (prefid),
+ KEY username (username)
) TYPE=MyISAM;
-