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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
