From fdfc98239de2cfdfff6c62a5bb9d49abc8d3722e Mon Sep 17 00:00:00 2001
From: Barry Warsaw
Date: Sun, 8 Apr 2012 19:40:38 -0400
Subject:  - Rename the model attributes.  - news_moderation ->
 newsgroup_moderation

---
 src/mailman/database/schema/sqlite_20120407000000_01.sql | 5 +++--
 1 file changed, 3 insertions(+), 2 deletions(-)

(limited to 'src/mailman/database/schema/sqlite_20120407000000_01.sql')

diff --git a/src/mailman/database/schema/sqlite_20120407000000_01.sql b/src/mailman/database/schema/sqlite_20120407000000_01.sql
index 4fae9ed9d..58201fb9b 100644
--- a/src/mailman/database/schema/sqlite_20120407000000_01.sql
+++ b/src/mailman/database/schema/sqlite_20120407000000_01.sql
@@ -10,11 +10,13 @@
 -- REM archive
 -- REM archive_private
 -- REM archive_volume_frequency
+-- REM news_moderation
 -- REM news_prefix_subject_too
 -- REM nntp_host
 --
 -- THESE COLUMNS ARE ADDED BY THE PYTHON MIGRATION LAYER:
 -- ADD archive_policy
+-- ADD newsgroup_moderation
 -- ADD nntp_prefix_subject_too
 -- LP: #971013
 
@@ -95,7 +97,6 @@ CREATE TABLE ml_backup(
     mime_is_default_digest BOOLEAN,
     moderator_password TEXT,
     new_member_options INTEGER,
-    news_moderation INTEGER,
     nondigestable BOOLEAN,
     nonmember_rejection_notice TEXT,
     obscure_addresses BOOLEAN,
@@ -206,7 +207,6 @@ INSERT INTO ml_backup SELECT
     mime_is_default_digest,
     moderator_password,
     new_member_options,
-    news_moderation,
     nondigestable,
     nonmember_rejection_notice,
     obscure_addresses,
@@ -241,3 +241,4 @@ INSERT INTO ml_backup SELECT
 -- Add the new columns.  They'll get inserted at the Python layer.
 ALTER TABLE ml_backup ADD COLUMN archive_policy INTEGER;
 ALTER TABLE ml_backup ADD COLUMN nntp_prefix_subject_too INTEGER;
+ALTER TABLE ml_backup ADD COLUMN newsgroup_moderation INTEGER;
-- 
cgit v1.3

