|
7178
by Barry Warsaw
Database |
1 |
-- THIS FILE CONTAINS THE SQLITE3 SCHEMA MIGRATION FROM
|
2 |
-- 3.0b2 TO 3.0b3
|
|
3 |
--
|
|
4 |
-- AFTER 3.0b3 IS RELEASED YOU MAY NOT EDIT THIS FILE.
|
|
5 |
||
6 |
-- REMOVALS from the ban table.
|
|
7 |
-- REM mailing_list
|
|
8 |
||
9 |
-- ADDS to the ban table.
|
|
10 |
-- ADD list_id
|
|
11 |
||
12 |
CREATE TABLE ban_backup ( |
|
13 |
id INTEGER NOT NULL, |
|
14 |
email TEXT, |
|
15 |
PRIMARY KEY (id) |
|
16 |
);
|
|
17 |
||
18 |
INSERT INTO ban_backup SELECT |
|
19 |
id, email |
|
20 |
FROM ban; |
|
21 |
||
22 |
ALTER TABLE ban_backup ADD COLUMN list_id TEXT; |