[JAMES-849] Support PostgreSQL for BayesianAnalysis

• Type: New Feature
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 2.3.1
• Fix Version/s: 2.3.2, 3.0.0
• Component/s: Mailet Contributions
• Environment: PostgreSQL Database
• Assignee: Stefano Bagnara
• Reporter: Johannes Geppert
• Created: 28/Jul/08 16:32
• Updated: 02/Aug/08 13:57
• Resolved: 02/Aug/08 13:57

Description

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>