james-server-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Stefano Bagnara (JIRA)" <server-...@james.apache.org>
Subject [jira] Updated: (JAMES-849) Support PostgreSQL for BayesianAnalysis
Date Sat, 02 Aug 2008 13:55:44 GMT

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


Mime
View raw message