Details
-
New Feature
-
Status: Resolved
-
Minor
-
Resolution: Fixed
-
2.3.1
-
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>