[ 
https://issues.apache.org/jira/browse/JAMES-849?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Stefano Bagnara updated JAMES-849:
----------------------------------

    Affects Version/s: 2.3.1
        Fix Version/s: 3.0
                       2.3.2
             Assignee: Stefano Bagnara

We already had this queries in trunk (I didn't know / remember this).
So I will simply backport what we have in trunk to v2.3 (so it will be included 
in 2.3.2).

Thank you anyway Johannes!

> 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]

Reply via email to