[prev in list] [next in list] [prev in thread] [next in thread] 

List:       james-dev
Subject:    svn commit: r438957 - /james/server/trunk/src/conf/sqlResources.xml
From:       norman () apache ! org
Date:       2006-08-31 15:49:49
Message-ID: 20060831154950.0C6971A981A () eris ! apache ! org
[Download RAW message or body]

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: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org


[prev in list] [next in list] [prev in thread] [next in thread]