summaryrefslogtreecommitdiff
path: root/mail/dspam/files
diff options
context:
space:
mode:
authorPav Lucistnik <pav@FreeBSD.org>2004-07-06 14:43:28 +0000
committerPav Lucistnik <pav@FreeBSD.org>2004-07-06 14:43:28 +0000
commit07015f11141748093a850e082e7a9e48d197d3da (patch)
tree886e90ff27e5680c27debf5a099a66ee24f00618 /mail/dspam/files
parentAdd kdissert, a KDE mindmapping tool. (diff)
- Fix up MySQL 2.x -> 3.x migration instructions
Submitted by: Ion-Mihai Tetcu <itetcu@apropo.ro> Approved by: maintainer
Notes
Notes: svn path=/head/; revision=113069
Diffstat (limited to 'mail/dspam/files')
-rw-r--r--mail/dspam/files/2x_to_3x_db.sql (renamed from mail/dspam/files/convert2db.sql)0
-rw-r--r--mail/dspam/files/modify2db.sql12
-rw-r--r--mail/dspam/files/sync_db.sql3
3 files changed, 0 insertions, 15 deletions
diff --git a/mail/dspam/files/convert2db.sql b/mail/dspam/files/2x_to_3x_db.sql
index 489965907a7c..489965907a7c 100644
--- a/mail/dspam/files/convert2db.sql
+++ b/mail/dspam/files/2x_to_3x_db.sql
diff --git a/mail/dspam/files/modify2db.sql b/mail/dspam/files/modify2db.sql
deleted file mode 100644
index d387b5c7ddf6..000000000000
--- a/mail/dspam/files/modify2db.sql
+++ /dev/null
@@ -1,12 +0,0 @@
-alter table dspam_stats add spam_learned int;
-alter table dspam_stats add innocent_learned int;
-alter table dspam_stats add spam_classified int;
-alter table dspam_stats add innocent_classified int;
-update dspam_stats set spam_learned = total_spam;
-update dspam_stats set innocent_learned = total_innocent;
-update dspam_stats set spam_classified = 0, innocent_classified = 0;
-alter table dspam_stats add spam_misclassified int;
-alter table dspam_stats add innocent_misclassified int;
-update dspam_stats set spam_misclassified = spam_misses;
-update dspam_stats set innocent_misclassified = false_positives;
-
diff --git a/mail/dspam/files/sync_db.sql b/mail/dspam/files/sync_db.sql
deleted file mode 100644
index 5c82303510e4..000000000000
--- a/mail/dspam/files/sync_db.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-
-update dspam_stats set spam_misclassified = spam_misses;
-update dspam_stats set innocent_misclassified = false_positives;