# HG changeset patch
# User Richard Jones <richard@users.sourceforge.net>
# Date 1097792879 0
# Node ID e3cd28cec23d5d6fc814ed1dd7be1efe2c83c7c0
# Parent  1f89984c0ea594f7bcc154aee6ec31d8385cda83
Clean out sessions / otks tables when migrating

diff -r 1f89984c0ea5 -r e3cd28cec23d CHANGES.txt
--- a/CHANGES.txt	Thu Oct 14 10:47:07 2004 +0000
+++ b/CHANGES.txt	Thu Oct 14 22:27:59 2004 +0000
@@ -35,7 +35,12 @@
 - removed safeget() from the API (sf bug 994750)
 
 
-2004-??-?? 0.7.7
+2004-10-15 0.7.8
+Fixed:
+- Clean out sessions / otks tables when migrating
+
+
+2004-10-11 0.7.7
 Fixed:
 - ZRoundup's search interface works now (sf bug 994957)
 - fixed history display when "ascending"
diff -r 1f89984c0ea5 -r e3cd28cec23d roundup/backends/rdbms_common.py
--- a/roundup/backends/rdbms_common.py	Thu Oct 14 10:47:07 2004 +0000
+++ b/roundup/backends/rdbms_common.py	Thu Oct 14 22:27:59 2004 +0000
@@ -1,4 +1,4 @@
-# $Id: rdbms_common.py,v 1.136 2004-10-08 01:28:32 richard Exp $
+# $Id: rdbms_common.py,v 1.137 2004-10-14 22:27:59 richard Exp $
 ''' Relational database (SQL) backend common code.
 
 Basics:
@@ -250,6 +250,7 @@
     def fix_version_3_tables(self):
         # drop the shorter VARCHAR OTK column and add a new TEXT one
         for name in ('otk', 'session'):
+            self.sql('DELETE FROM %ss'%name)
             self.sql('ALTER TABLE %ss DROP %s_value'%(name, name))
             self.sql('ALTER TABLE %ss ADD %s_value TEXT'%(name, name))