From 40347db84550a85f43e6befa4641693200d30509 Mon Sep 17 00:00:00 2001
From: Barry Warsaw
Date: Sun, 4 Mar 2012 18:39:08 -0500
Subject: Template indirection now also in effect for regular and digest
 headers and footers, using the same semantics and algorithm as for welcome
 and goodbye messages.

Additional schema changes:

   - msg_header       -> header_uri
   - msg_footer       -> footer_uri
   - digest_header    -> digest_header_uri
   - digest_footer    -> digest_footer_uri
---
 src/mailman/database/schema/sqlite.sql | 8 ++++----
 1 file changed, 4 insertions(+), 4 deletions(-)

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

diff --git a/src/mailman/database/schema/sqlite.sql b/src/mailman/database/schema/sqlite.sql
index d5ef06f0f..ae5145d7a 100644
--- a/src/mailman/database/schema/sqlite.sql
+++ b/src/mailman/database/schema/sqlite.sql
@@ -144,8 +144,8 @@ CREATE TABLE mailinglist (
     default_member_action INTEGER,
     default_nonmember_action INTEGER,
     description TEXT,
-    digest_footer TEXT,
-    digest_header TEXT,
+    digest_footer_uri TEXT,
+    digest_header_uri TEXT,
     digest_is_default BOOLEAN,
     digest_send_periodic BOOLEAN,
     digest_size_threshold FLOAT,
@@ -155,12 +155,14 @@ CREATE TABLE mailinglist (
     emergency BOOLEAN,
     encode_ascii_prefixes BOOLEAN,
     first_strip_reply_to BOOLEAN,
+    footer_uri TEXT,
     forward_auto_discards BOOLEAN,
     gateway_to_mail BOOLEAN,
     gateway_to_news BOOLEAN,
     generic_nonmember_action INTEGER,
     goodbye_message_uri TEXT,
     header_matches BLOB,
+    header_uri TEXT,
     hold_these_nonmembers BLOB,
     info TEXT,
     linked_newsgroup TEXT,
@@ -170,8 +172,6 @@ CREATE TABLE mailinglist (
     member_moderation_notice TEXT,
     mime_is_default_digest BOOLEAN,
     moderator_password TEXT,
-    msg_footer TEXT,
-    msg_header TEXT,
     new_member_options INTEGER,
     news_moderation INTEGER,
     news_prefix_subject_too BOOLEAN,
-- 
cgit v1.2.3-70-g09d2

