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

     ALTER TABLE `dspam_signature_data`
       CHANGE `uid` `uid` INT UNSIGNED NOT NULL,
       CHANGE `data` `data` LONGBLOB NOT NULL,
       CHANGE `length` `length` INT UNSIGNED NOT NULL;
     ALTER TABLE `dspam_stats`
       CHANGE `uid` `uid` INT UNSIGNED NOT NULL,
       CHANGE `spam_learned` `spam_learned` BIGINT UNSIGNED NOT NULL,
       CHANGE `innocent_learned` `innocent_learned` BIGINT UNSIGNED NOT NULL,
       CHANGE `spam_misclassified` `spam_misclassified` BIGINT UNSIGNED NOT NULL,
       CHANGE `innocent_misclassified` `innocent_misclassified` BIGINT UNSIGNED NOT NULL,
       CHANGE `spam_corpusfed` `spam_corpusfed` BIGINT UNSIGNED NOT NULL,
       CHANGE `innocent_corpusfed` `innocent_corpusfed` BIGINT UNSIGNED NOT NULL,
       CHANGE `spam_classified` `spam_classified` BIGINT UNSIGNED NOT NULL,
       CHANGE `innocent_classified` `innocent_classified` BIGINT UNSIGNED NOT NULL;
     ALTER TABLE `dspam_token_data`
       CHANGE `uid` `uid` INT UNSIGNED NOT NULL,
       CHANGE `spam_hits` `spam_hits` BIGINT UNSIGNED NOT NULL,
       CHANGE `innocent_hits` `innocent_hits` BIGINT UNSIGNED NOT NULL;

     ALTER TABLE `dspam_preferences` 
       CHANGE `uid` `uid` INT UNSIGNED NOT NULL;

     ALTER TABLE `dspam_virtual_uids`
       CHANGE `uid` `uid` INT UNSIGNED NOT NULL AUTO_INCREMENT;

     ALTER TABLE `dspam_token_data`
       ADD INDEX(`spam_hits`),
       ADD INDEX(`innocent_hits`),
       ADD INDEX(`last_hit`);