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