svn commit: r1933478 - in spamassassin/trunk: . sql

Author: gbechis
Date: Wed Apr 29 09:38:16 2026
New Revision: 1933478

Log:
sync MANIFEST

Added:
   spamassassin/trunk/sql/extracttext_pg.sql
Deleted:
   spamassassin/trunk/sql/extracttext_pgsql.sql
Modified:
   spamassassin/trunk/MANIFEST

Modified: spamassassin/trunk/MANIFEST
==============================================================================
--- spamassassin/trunk/MANIFEST	Wed Apr 29 09:34:28 2026	(r1933477)
+++ spamassassin/trunk/MANIFEST	Wed Apr 29 09:38:16 2026	(r1933478)
@@ -250,6 +250,9 @@ sql/bayes_pg.sql
 sql/decodeshorturl_mysql.sql
 sql/decodeshorturl_pg.sql
 sql/decodeshorturl_sqlite.sql
+sql/extracttext_mysql.sql
+sql/extracttext_pg.sql
+sql/extracttext_sqlite.sql
 sql/neural_mysql.sql
 sql/neural_pg.sql
 sql/neural_sqlite.sql

Added: spamassassin/trunk/sql/extracttext_pg.sql
==============================================================================
--- /dev/null	00:00:00 1970	(empty, because file is newly added)
+++ spamassassin/trunk/sql/extracttext_pg.sql	Wed Apr 29 09:38:16 2026	(r1933478)
@@ -0,0 +1,15 @@
+-- SpamAssassin ExtractText plugin - PostgreSQL cache schema
+-- Usage: psql -U <username> -d <database> -f extracttext_pgsql.sql
+
+CREATE TABLE IF NOT EXISTS extracttext_cache (
+  file_hash   TEXT        PRIMARY KEY NOT NULL,
+  file_name   TEXT        NOT NULL,
+  file_text   TEXT        NOT NULL,
+  hits        INTEGER     NOT NULL DEFAULT 1,
+  created     INTEGER     NOT NULL,
+  modified    INTEGER     NOT NULL
+);
+
+-- Optional index to speed up TTL-based cleanup queries
+-- CREATE INDEX IF NOT EXISTS extracttext_modified
+--   ON extracttext_cache(created);