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;
-