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 "Johannes Geppert (JIRA)" <se...@james.apache.org> on 2008/07/28 18:33:31 UTC
[jira] Created: (JAMES-849) Support PostgreSQL for BayesianAnalysis
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
Environment: PostgreSQL Database
Reporter: Johannes Geppert
Priority: Minor
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
[jira] Resolved: (JAMES-849) Support PostgreSQL for
BayesianAnalysis
Posted by "Stefano Bagnara (JIRA)" <se...@james.apache.org>.
[ 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
[jira] Updated: (JAMES-849) Support PostgreSQL for BayesianAnalysis
Posted by "Stefano Bagnara (JIRA)" <se...@james.apache.org>.
[ 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