updatescript for changeset [488] ?

[dnauck]

what about an upgradescript/readme for changeset [488] ?

[rjl]

This will ultimately be added to schema.php and configtest.php, yes. For now, the changes are unimportant to people who already have a working configuration. The specific changes:

(1) The "DEFAULT '0'" clause was removed from all auto_increment columns in maia-mysql.sql, since this clause was causing errors for users of MySQL 4.1. It can be safely removed for older versions of MySQL as well, though, since the default for auto_increment columns is to start from 0 anyway. A harmless, backward-compatible change, basically.

(2) The AWL and Bayes-related tables used by SpamAssassin 3.0 have been added to the Maia database schema as a convenience. The definitions are straight from the SpamAssassin documentation, and have not been modified.

(3) The PostgreSQL schema was falling a bit behind the MySQL schema, and needed to have some elements added to it (e.g. the maia_themes table).

In other words, if you've already got Maia working properly on your system, you don't need to worry about any of these changes. They should just make it easier for new users to get things setup.

[dmorton]

configtest is not doing the auto-increment stuff right now, at least in table creation.

need to special case this, I guess, as postgresql doesn't have an autoincrement keyword at all. I guess it uses the SERIAL type.

[dmorton]

fixed with new upgrade scripts.