james-server-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From nor...@apache.org
Subject svn commit: r485708 - /james/server/trunk/src/conf/sqlResources.xml
Date Mon, 11 Dec 2006 15:25:19 GMT
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


Mime
View raw message