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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
