Connector/NET commit: r812 - in trunk: . MySql.Web/Providers/Source MySql.Web/Tests

[rburnett]

Modified:
   trunk/CHANGES
   trunk/MySql.Web/Providers/Source/MembershipSchema.cs
   trunk/MySql.Web/Tests/UserManagement.cs
Log:
Fixed problem with membership schema where the password key column was not large enough  


Modified: trunk/CHANGES
===================================================================
--- trunk/CHANGES	2007-07-24 22:34:25 UTC (rev 811)
+++ trunk/CHANGES	2007-07-25 20:47:06 UTC (rev 812)
@@ -16,7 +16,8 @@
   - Help is now integrated into Visual Studio 2005 and includes content other than the API 
   - Fixed problem reported by user where MySqlMembershipProvider.GetUser was attempting to 
     reuse the connection to update a table while a reader was open on it.    
-    
+  - Fixed problem with membership schema where the password key column was not large enough  
+
 Version 5.1.2 - 6/12/2007
   - Fixed integration with the Website Administration Tool.  Before this fix, the test link
     was visible but did not work and  user management did not work.

Modified: trunk/MySql.Web/Providers/Source/MembershipSchema.cs
===================================================================
--- trunk/MySql.Web/Providers/Source/MembershipSchema.cs	2007-07-24 22:34:25 UTC (rev 811)
+++ trunk/MySql.Web/Providers/Source/MembershipSchema.cs	2007-07-25 20:47:06 UTC (rev 812)
@@ -105,7 +105,7 @@
 
         private const string schema2 =
             @"ALTER TABLE mysql_Membership 
-            ADD PasswordKey char(16) AFTER Password, 
+            ADD PasswordKey char(32) AFTER Password, 
             ADD PasswordFormat tinyint AFTER PasswordKey, 
             CHANGE email email VARCHAR(128), COMMENT='2'";
 

Modified: trunk/MySql.Web/Tests/UserManagement.cs
===================================================================
--- trunk/MySql.Web/Tests/UserManagement.cs	2007-07-24 22:34:25 UTC (rev 811)
+++ trunk/MySql.Web/Tests/UserManagement.cs	2007-07-25 20:47:06 UTC (rev 812)
@@ -39,7 +39,7 @@
         [SetUp]
         public void SetUp()
         {
-            execSQL("TRUNCATE TABLE mysql_Membership");
+            execSQL("DROP TABLE IF EXISTS mysql_membership");
         }
 
         private void CreateUserWithFormat(MembershipPasswordFormat format)
@@ -63,7 +63,7 @@
             Assert.AreEqual(format, rowFormat);
 
             //  then attempt to verify the user
-            provider.ValidateUser("foo", "bar");
+            Assert.IsTrue(provider.ValidateUser("foo", "bar"));
         }
 
         [Test]