Author: norman
Date: Thu Aug 31 08:49:49 2006
New Revision: 438957
URL: http://svn.apache.org/viewvc?rev=438957&view=rev
Log:
Add support for derby to use with BayesianAnalzer. Thx to Guillermo Grandes.
See JAMES-555
Modified:
james/server/trunk/src/conf/sqlResources.xml
Modified: james/server/trunk/src/conf/sqlResources.xml
URL:
http://svn.apache.org/viewvc/james/server/trunk/src/conf/sqlResources.xml?rev=438957&r1=438956&r2=438957&view=diff
==============================================================================
--- james/server/trunk/src/conf/sqlResources.xml (original)
+++ james/server/trunk/src/conf/sqlResources.xml Thu Aug 31 08:49:49 2006
@@ -689,6 +689,13 @@
PRIMARY KEY (token)
)
</sql>
+ <sql name="createHamTable" db="derby">
+ CREATE TABLE bayesiananalysis_ham (
+ token varchar(128) NOT NULL,
+ occurrences INTEGER NOT NULL default 0,
+ PRIMARY KEY (token)
+ )
+ </sql>
<!-- Statements used to create the "spam" table (the 'token' field must be
case sensitive). -->
<sql name="createSpamTable" db="mysql">
@@ -705,6 +712,13 @@
PRIMARY KEY (token)
)
</sql>
+ <sql name="createSpamTable" db="derby">
+ CREATE TABLE bayesiananalysis_spam (
+ token varchar (128) NOT NULL,
+ occurrences INTEGER NOT NULL default 0,
+ PRIMARY KEY (token)
+ )
+ </sql>
<!-- Statements used to create the "message counts" table. -->
<sql name="createMessageCountsTable" db="mysql">
@@ -719,7 +733,12 @@
[spamcount] [int] NOT NULL default (0)
)
</sql>
-
+ <sql name="createMessageCountsTable" db="derby">
+ CREATE TABLE bayesiananalysis_messagecounts (
+ hamcount INTEGER NOT NULL default 0,
+ spamcount INTEGER NOT NULL default 0
+ )
+ </sql>
</sqlDefs>
<!-- SQL statements to support the WhiteListManager mailet and the
IsInWhiteList matcher -->
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
