From 2c848e7d82d75b399e415d123567a5d66a0bf1e4 Mon Sep 17 00:00:00 2001
From: =?utf8?q?St=C3=A9phane=20Jacob?= <sj@m4x.org>
Date: Thu, 7 Jul 2011 13:09:14 +0200
Subject: [PATCH] Marital flag is no longer used and has been replaced by usage
 flag.
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit

Signed-off-by: Stéphane Jacob <sj@m4x.org>
---
 upgrade/1.1.3/01_marital.sql | 5 +++++
 1 file changed, 5 insertions(+)
 create mode 100644 upgrade/1.1.3/01_marital.sql

diff --git a/upgrade/1.1.3/01_marital.sql b/upgrade/1.1.3/01_marital.sql
new file mode 100644
index 0000000..111d71f
--- /dev/null
+++ b/upgrade/1.1.3/01_marital.sql
@@ -0,0 +1,5 @@
+UPDATE  email_source_account
+   SET  flags = REPLACE(flags, 'marital', 'usage')
+ WHERE  FIND_IN_SET('marital', flags);
+
+-- vim:set syntax=mysql:
-- 
2.1.4