summaryrefslogtreecommitdiff
path: root/src/mailman/database/schema/sqlite_20120407000000_01.sql (follow)
Commit message (Collapse)AuthorAgeFilesLines
* Migrations will be replaced with Alchemy.Barry Warsaw2014-09-221-280/+0
| | | | | | We don't need the raw SQL schema stuff any more. We don't need the Version table any more.
* Migrate bounceevent.list_name -> bounceevent.list_idBarry Warsaw2013-09-011-15/+15
| | | | | | | * Rename StormBaseDatabase._create() -> .initialize() * Refactor database initialization. * make_listid() helper. * Add a pivot() helper for schema migrations.
* * The column `mailinglist.new_member_options` was unused, and has beenBarry Warsaw2012-12-301-1/+1
| | | | removed.
* DatabaseBarry Warsaw2012-10-161-1/+1
| | | | | | | | | | | | -------- * The `ban` table now uses list-ids to cross-reference the mailing list, since these cannot change even if the mailing list is moved or renamed. Interfaces ---------- * The `IBanManager` is no longer a global utility. Instead, you adapt an `IMailingList` to an `IBanManager` to manage the bans for a specific mailing list. To manage the global bans, adapt ``None``.
* * Schema migrations (LP: #1024509)Barry Warsaw2012-09-041-3/+35
| | | | - member.mailing_list -> list_id
* * The link between members and the mailing lists they are subscribed to, isBarry Warsaw2012-09-041-0/+2
| | | | | | | | | | | | | | | now via the RFC 2369 `list_id` instead of the fqdn listname (i.e. posting address). This is because while the posting address can change if the mailing list is moved to a new server, the list id is fixed. (LP: #1024509) + IListManager.get_by_list_id() added. + IListManager.list_ids added. + IMailingList.list_id added. + Several internal APIs that accepted fqdn list names now require list ids, e.g. ISubscriptionService.join() and .find_members(). + IMember.list_id attribute added; .mailing_list is now an alias that retrieves and returns the IMailingList. - list_id added (LP: #1024509)
* * Removed obsolete `IMailingList` attribute `generic_nonmember_action.Barry Warsaw2012-08-191-2/+0
| | | | (LP: #975696)
* Working for SQLite:Barry Warsaw2012-07-251-1/+5
| | | | | | include_list_post_header -> allow_list_posts Also add a bunch more migration tests.
* - Rename the model attributes.Barry Warsaw2012-04-081-2/+3
| | | | - news_moderation -> newsgroup_moderation
* - Refactor the way databases are schema-migrated so that load_migrations()Barry Warsaw2012-04-081-0/+243
can be tested separately. - Add an `until` argument to load_migrations() so that we can load only up to a given timestamp. - In load_migrations(), ignore files in which the `version` part of the file name is empty. - In migrations.rst, use the new, better way of ensuring post-test cleanup. - Add tests for partial upgrades. - LP: #971013 - schema migrations for beta 2. - LP: #967238 - IMailingList.archive + IMailingList.archive_private -> IMailingList.archive_policy, and add ArchivePolicy enum. - Move the `chdir` context manager to helpers.py and add `temporary_db` context manager.
generated by cgit v1.2.3-70-g09d2 (git 2.52.0) at 2026-02-07 00:53:53 +0000