mailman.git/src/mailman/database/tests/data/migration_postgres_1.sql, branch plugin The GNU Mailing List manager. https://git.neuromancer.sk/mailman.git/atom/src/mailman/database/tests/data/migration_postgres_1.sql?h=plugin 2014-09-22T23:32:58Z Migrations will be replaced with Alchemy. 2014-09-22T23:32:58Z Barry Warsaw 2014-09-22T23:32:58Z urn:sha1:31aebefadf7853a4e7767ea1552720f52e06bb7a We don't need the raw SQL schema stuff any more. We don't need the Version table any more. * The policy for archiving has now been collapsed into a single enum, called 2012-07-26T04:22:19Z Barry Warsaw 2012-07-26T04:22:19Z urn:sha1:6724d3688f5cf612f722a2d7504eeb50caf8dbe9 ArchivePolicy. This describes the three states of never archive, archive privately, and archive_publicly. (LP: #967238) Database -------- * Schema migrations (LP: #971013) - include_list_post_header -> allow_list_posts - news_prefix_subject_too -> nntp_prefix_subject_too - news_moderation -> newsgroup_moderation - archive and archive_private have been collapsed into archive_policy. - nntp_host has been removed. * The PostgreSQL port of the schema accidentally added a moderation_callback column to the mailinglist table. Since this is unused in Mailman, it was simply commented out of the base schema for PostgreSQL. Very nearly there with PostgreSQL support for testing the beta2 migration. 2012-07-25T16:23:29Z Barry Warsaw 2012-07-25T16:23:29Z urn:sha1:9ef8a1268f1b2902ad46852937dd7bc977c5b2b1 - Improve migration logging - Disable pre_reset() and post_reset() on migrations, which might need to be re-enabled for SQLite support. - Be sure to record the migration version in PostgreSQL. - Parameterize the Error that will occur. - Better sample data for PostgreSQL and SQLite, which have different formats.