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] Resolved: (JAMES-849) Support PostgreSQL for BayesianAnalysis
Date Sat, 02 Aug 2008 13:57:44 GMT

     [ 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


Mime
View raw message