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

Support PostgreSQL for BayesianAnalysis

Agile BoardAttach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Resolved
    • Minor
    • Resolution: Fixed
    • 2.3.1
    • 2.3.2, 3.0.0
    • Mailet Contributions
    • None
    • 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

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            bago Stefano Bagnara
            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

              Slack

                Issue deployment