diff options
| author | Barry Warsaw | 2013-09-01 11:15:08 -0400 |
|---|---|---|
| committer | Barry Warsaw | 2013-09-01 11:15:08 -0400 |
| commit | d146f14b3eef9f608c0e03347c135062bade8ced (patch) | |
| tree | 5a1f2f576dd7d5dcce4d6903df5cc4b6cb754815 /src/mailman/database/schema/sqlite_20121015000000_01.sql | |
| parent | 41059ed20ec668baf41cceaf539f8017171e9651 (diff) | |
| download | mailman-d146f14b3eef9f608c0e03347c135062bade8ced.tar.gz mailman-d146f14b3eef9f608c0e03347c135062bade8ced.tar.zst mailman-d146f14b3eef9f608c0e03347c135062bade8ced.zip | |
Migrate bounceevent.list_name -> bounceevent.list_id
* Rename StormBaseDatabase._create() -> .initialize()
* Refactor database initialization.
* make_listid() helper.
* Add a pivot() helper for schema migrations.
Diffstat (limited to 'src/mailman/database/schema/sqlite_20121015000000_01.sql')
| -rw-r--r-- | src/mailman/database/schema/sqlite_20121015000000_01.sql | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/src/mailman/database/schema/sqlite_20121015000000_01.sql b/src/mailman/database/schema/sqlite_20121015000000_01.sql index 3e2410c3b..a80dc03df 100644 --- a/src/mailman/database/schema/sqlite_20121015000000_01.sql +++ b/src/mailman/database/schema/sqlite_20121015000000_01.sql @@ -1,12 +1,12 @@ --- THIS FILE CONTAINS THE SQLITE3 SCHEMA MIGRATION FROM +-- This file contains the sqlite3 schema migration from -- 3.0b2 TO 3.0b3 -- --- AFTER 3.0b3 IS RELEASED YOU MAY NOT EDIT THIS FILE. +-- 3.0b3 has been released thus you MAY NOT edit this file. --- REMOVALS from the ban table. +-- REMOVALS from the ban table: -- REM mailing_list --- ADDS to the ban table. +-- ADDS to the ban table: -- ADD list_id CREATE TABLE ban_backup ( @@ -30,7 +30,7 @@ ALTER TABLE ban_backup ADD COLUMN list_id TEXT; -- REM private_roster -- REM admin_member_chunksize -CREATE TABLE ml_backup ( +CREATE TABLE mailinglist_backup ( id INTEGER NOT NULL, list_name TEXT, mail_host TEXT, @@ -130,7 +130,7 @@ CREATE TABLE ml_backup ( PRIMARY KEY (id) ); -INSERT INTO ml_backup SELECT +INSERT INTO mailinglist_backup SELECT id, list_name, mail_host, |