You are viewing a plain text version of this content. The canonical link for it is here.
Posted to server-dev@james.apache.org by no...@apache.org on 2006/12/11 16:25:19 UTC
svn commit: r485708 - /james/server/trunk/src/conf/sqlResources.xml
Author: norman
Date: Mon Dec 11 07:25:18 2006
New Revision: 485708
URL: http://svn.apache.org/viewvc?view=rev&rev=485708
Log:
Add postgresql support for creating bayesian tables. Thx to Kev Jackson. See JAMES-730
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?view=diff&rev=485708&r1=485707&r2=485708
==============================================================================
--- james/server/trunk/src/conf/sqlResources.xml (original)
+++ james/server/trunk/src/conf/sqlResources.xml Mon Dec 11 07:25:18 2006
@@ -706,6 +706,13 @@
PRIMARY KEY (token)
)
</sql>
+ <sql name="createHamTable" db="postgresql">
+ CREATE TABLE bayesiananalysis_ham (
+ token varchar(128) NOT NULL,
+ occurrences int 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">
@@ -729,6 +736,13 @@
PRIMARY KEY (token)
)
</sql>
+ <sql name="createSpamTable" db="postgresql">
+ CREATE TABLE bayesiananalysis_spam (
+ token varchar (128) NOT NULL,
+ occurrences int NOT NULL default 0,
+ PRIMARY KEY (token)
+ )
+ </sql>
<!-- Statements used to create the "message counts" table. -->
<sql name="createMessageCountsTable" db="mysql">
@@ -747,6 +761,12 @@
CREATE TABLE bayesiananalysis_messagecounts (
hamcount INTEGER NOT NULL default 0,
spamcount INTEGER NOT NULL default 0
+ )
+ </sql>
+ <sql name="createMessageCountsTable" db="postgresql">
+ CREATE TABLE bayesiananalysis_messagecounts (
+ hamcount int NOT NULL default 0,
+ spamcount int NOT NULL default 0
)
</sql>
</sqlDefs>
---------------------------------------------------------------------
To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org