Opened 15 years ago

Closed 14 years ago

#108 closed defect (fixed)

updatescript for changeset [488] ?

Reported by: dnauck Owned by: dmorton
Priority: high Milestone: 1.0.0 RC6
Component: PHP scripts Version: 1.0.0 RC6
Severity: critical Keywords: configtest.php schema.php
Cc:

Description

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

Change History (4)

comment:1 Changed 15 years ago by rjl

  • Component changed from SQL scripts to PHP scripts
  • Keywords configtest.php schema.php added

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.

comment:2 Changed 15 years ago by dmorton

  • Owner changed from rjl to dmorton
  • Status changed from new to assigned

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.

comment:3 Changed 15 years ago by dmorton

  • Severity changed from major to critical

comment:4 Changed 14 years ago by dmorton

  • Resolution set to fixed
  • Status changed from assigned to closed

fixed with new upgrade scripts.

Note: See TracTickets for help on using tickets.