diff options
author | Pav Lucistnik <pav@FreeBSD.org> | 2004-07-06 14:43:28 +0000 |
---|---|---|
committer | Pav Lucistnik <pav@FreeBSD.org> | 2004-07-06 14:43:28 +0000 |
commit | 07015f11141748093a850e082e7a9e48d197d3da (patch) | |
tree | 886e90ff27e5680c27debf5a099a66ee24f00618 /mail/dspam/files | |
parent | Add 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.sql | 12 | ||||
-rw-r--r-- | mail/dspam/files/sync_db.sql | 3 |
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; |