source: npl/mailserver/dspam/upgrade-3.9.sql @ 0105685

gcc484ntopperl-5.22
Last change on this file since 0105685 was c5c522c, checked in by Edwin Eefting <edwin@datux.nl>, 8 years ago

initial commit, transferred from cleaned syn3 svn tree
  • Property mode set to 100644
File size: 1.4 KB
Line 
1     ALTER TABLE `dspam_signature_data`
2       CHANGE `uid` `uid` INT UNSIGNED NOT NULL,
3       CHANGE `data` `data` LONGBLOB NOT NULL,
4       CHANGE `length` `length` INT UNSIGNED NOT NULL;
5     ALTER TABLE `dspam_stats`
6       CHANGE `uid` `uid` INT UNSIGNED NOT NULL,
7       CHANGE `spam_learned` `spam_learned` BIGINT UNSIGNED NOT NULL,
8       CHANGE `innocent_learned` `innocent_learned` BIGINT UNSIGNED NOT NULL,
9       CHANGE `spam_misclassified` `spam_misclassified` BIGINT UNSIGNED NOT NULL,
10       CHANGE `innocent_misclassified` `innocent_misclassified` BIGINT UNSIGNED NOT NULL,
11       CHANGE `spam_corpusfed` `spam_corpusfed` BIGINT UNSIGNED NOT NULL,
12       CHANGE `innocent_corpusfed` `innocent_corpusfed` BIGINT UNSIGNED NOT NULL,
13       CHANGE `spam_classified` `spam_classified` BIGINT UNSIGNED NOT NULL,
14       CHANGE `innocent_classified` `innocent_classified` BIGINT UNSIGNED NOT NULL;
15     ALTER TABLE `dspam_token_data`
16       CHANGE `uid` `uid` INT UNSIGNED NOT NULL,
17       CHANGE `spam_hits` `spam_hits` BIGINT UNSIGNED NOT NULL,
18       CHANGE `innocent_hits` `innocent_hits` BIGINT UNSIGNED NOT NULL;
19
20     ALTER TABLE `dspam_preferences`
21       CHANGE `uid` `uid` INT UNSIGNED NOT NULL;
22
23     ALTER TABLE `dspam_virtual_uids`
24       CHANGE `uid` `uid` INT UNSIGNED NOT NULL AUTO_INCREMENT;
25
26     ALTER TABLE `dspam_token_data`
27       ADD INDEX(`spam_hits`),
28       ADD INDEX(`innocent_hits`),
29       ADD INDEX(`last_hit`);
Note: See TracBrowser for help on using the repository browser.