Uploaded image for project: 'James Server'
  1. James Server
  2. JAMES-849

Support PostgreSQL for BayesianAnalysis

    Details

    • 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
    • Labels:
      None
    • Environment:
      PostgreSQL Database

      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>

        Attachments

          Activity

            People

            • Assignee:
              bago Stefano Bagnara
              Reporter:
              jogep Johannes Geppert
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 2h
                2h
                Remaining:
                Remaining Estimate - 2h
                2h
                Logged:
                Time Spent - Not Specified
                Not Specified