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 "Stefano Bagnara (JIRA)" <se...@james.apache.org> on 2008/08/02 15:57:44 UTC
[jira] Resolved: (JAMES-849) Support PostgreSQL for
BayesianAnalysis
[ https://issues.apache.org/jira/browse/JAMES-849?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Stefano Bagnara resolved JAMES-849.
-----------------------------------
Resolution: Fixed
Backported from trunk (support both derby and postgresql previously unsupported)
> Support PostgreSQL for BayesianAnalysis
> ---------------------------------------
>
> Key: JAMES-849
> URL: https://issues.apache.org/jira/browse/JAMES-849
> Project: James
> Issue Type: New Feature
> Components: Mailet Contributions
> Affects Versions: 2.3.1
> Environment: PostgreSQL Database
> Reporter: Johannes Geppert
> Assignee: Stefano Bagnara
> Priority: Minor
> Fix For: 2.3.2, 3.0
>
> Original Estimate: 2h
> Remaining Estimate: 2h
>
> Add following XML to the conf/sqlResources.xml for PostgreSQL support.
> <sql name="createHamTable" db="postgresql">
> CREATE TABLE bayesiananalysis_ham (
> token character varying(128) NOT NULL default '',
> occurrences bigint NOT NULL default '0',
> PRIMARY KEY (token)
> )
> </sql>
> <sql name="createSpamTable" db="postgresql">
> CREATE TABLE bayesiananalysis_spam (
> token character varying(128) NOT NULL default '',
> occurrences bigint NOT NULL default '0',
> PRIMARY KEY (token)
> )
> </sql>
> <sql name="createMessageCountsTable" db="postgresql">
> CREATE TABLE bayesiananalysis_messagecounts (
> hamcount bigint NOT NULL default '0',
> spamcount bigint NOT NULL default '0'
> )
> </sql>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
---------------------------------------------------------------------
To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org