[Nmailserver-commits] SF.net SVN: nmailserver: [85] NMail/trunk/NMail.LocalStoreData.MySql/ MySqlLocalStore.sql

[<tmy...@us...>]

Revision: 85
          http://svn.sourceforge.net/nmailserver/?rev=85&view=rev
Author:   tmyroadctfig
Date:     2006-11-11 03:25:29 -0800 (Sat, 11 Nov 2006)

Log Message:
-----------
Fixed defect in createuser.

Modified Paths:
--------------
    NMail/trunk/NMail.LocalStoreData.MySql/MySqlLocalStore.sql

Modified: NMail/trunk/NMail.LocalStoreData.MySql/MySqlLocalStore.sql
===================================================================
--- NMail/trunk/NMail.LocalStoreData.MySql/MySqlLocalStore.sql	2006-11-11 10:58:49 UTC (rev 84)
+++ NMail/trunk/NMail.LocalStoreData.MySql/MySqlLocalStore.sql	2006-11-11 11:25:29 UTC (rev 85)
@@ -485,7 +485,11 @@
 		IF NOT EXISTS (SELECT * FROM Folder f WHERE f.Name LIKE Name and f.NamespaceId = NamespaceId) AND
 			NOT EXISTS (SELECT * FROM Folder f WHERE f.Name LIKE InboxName and f.NamespaceId = NamespaceId) THEN
 						
-			INSERT INTO User (Username, QuotaHardLimit, QuotaWarnLimit) VALUES (Name, QuotaHardLimit, QuotaWarnLimit);
+			INSERT INTO User
+				(Username, QuotaHardLimit, QuotaWarnLimit, Disabled, PasswordExpiry)
+			VALUES
+				(Name, QuotaHardLimit, QuotaWarnLimit, FALSE, NOW() + INTERVAL 90 DAY);
+				
 			SELECT LAST_INSERT_ID() INTO UserId;
 			
 			/* Create the user's base folder. */


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.