james-server-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Johannes Geppert (JIRA)" <server-...@james.apache.org>
Subject [jira] Created: (JAMES-849) Support PostgreSQL for BayesianAnalysis
Date Mon, 28 Jul 2008 16:33:31 GMT
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


Mime
View raw message