src/mailman/database/schema/sqlite_20121015000000_01.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22

-- THIS FILE CONTAINS THE SQLITE3 SCHEMA MIGRATION FROM
-- 3.0b2 TO 3.0b3
--
-- AFTER 3.0b3 IS RELEASED YOU MAY NOT EDIT THIS FILE.

-- REMOVALS from the ban table.
-- REM mailing_list

-- ADDS to the ban table.
-- ADD list_id

CREATE TABLE ban_backup (
    id INTEGER NOT NULL,
    email TEXT,
    PRIMARY KEY (id)
    );

INSERT INTO ban_backup SELECT
    id, email
    FROM ban;

ALTER TABLE ban_backup ADD COLUMN list_id TEXT;