Index: branches/5.0.x/core/units/helpers/language_import_helper.php
===================================================================
diff -u -N -r12591 -r12641
--- branches/5.0.x/core/units/helpers/language_import_helper.php	(.../language_import_helper.php)	(revision 12591)
+++ branches/5.0.x/core/units/helpers/language_import_helper.php	(.../language_import_helper.php)	(revision 12641)
@@ -1,6 +1,6 @@
 <?php
 /**
-* @version	$Id: language_import_helper.php 12591 2009-09-22 20:58:35Z alex $
+* @version	$Id: language_import_helper.php 12641 2009-09-29 17:04:12Z alex $
 * @package	In-Portal
 * @copyright	Copyright (C) 1997 - 2009 Intechnic. All rights reserved.
 * @license      GNU/GPL
@@ -384,7 +384,7 @@
 				$sql = 'CREATE TABLE %s SELECT * FROM %s WHERE 0';
 				$this->Conn->Query( sprintf($sql, $temp_table, $table) );
 
-				$sql = 'ALTER TABLE %1$s CHANGE %2$s %2$s INT(11) NOT NULL';
+				$sql = 'ALTER TABLE %1$s CHANGE %2$s %2$s INT(11) NOT NULL DEFAULT "0"';
 				$this->Conn->Query( sprintf($sql, $temp_table, $idfield) );
 			}
 
Index: branches/5.0.x/core/install/install_schema.sql
===================================================================
diff -u -N -r12639 -r12641
--- branches/5.0.x/core/install/install_schema.sql	(.../install_schema.sql)	(revision 12639)
+++ branches/5.0.x/core/install/install_schema.sql	(.../install_schema.sql)	(revision 12641)
@@ -330,7 +330,7 @@
   `Status` int(11) NOT NULL DEFAULT '1',
   GroupList varchar(255) DEFAULT NULL,
   tz int(11) DEFAULT NULL,
-  BrowserSignature varchar(32) NOT NULL,
+  BrowserSignature varchar(32) NOT NULL DEFAULT '',
   PRIMARY KEY (SessionKey),
   KEY UserId (PortalUserId),
   KEY LastAccessed (LastAccessed),
@@ -413,7 +413,7 @@
   PopItem int(11) NOT NULL DEFAULT '2',
   Modified int(11) NOT NULL DEFAULT '0',
   ModifiedById int(11) NOT NULL DEFAULT '0',
-  CachedTemplate varchar(255) NOT NULL,
+  CachedTemplate varchar(255) NOT NULL DEFAULT '',
   Template varchar(255) NOT NULL DEFAULT '#inherit#',
   UseExternalUrl tinyint(3) unsigned NOT NULL DEFAULT '0',
   ExternalUrl varchar(255) NOT NULL DEFAULT '',
@@ -437,7 +437,7 @@
   FormId int(11) DEFAULT NULL,
   FormSubmittedTemplate varchar(255) DEFAULT NULL,
   FriendlyURL varchar(255) NOT NULL DEFAULT '',
-  ThemeId int(10) unsigned NOT NULL,
+  ThemeId int(10) unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (CategoryId),
   UNIQUE KEY ResourceId (ResourceId),
   KEY ParentId (ParentId),
Index: branches/5.0.x/core/install/upgrades.sql
===================================================================
diff -u -N -r12639 -r12641
--- branches/5.0.x/core/install/upgrades.sql	(.../upgrades.sql)	(revision 12639)
+++ branches/5.0.x/core/install/upgrades.sql	(.../upgrades.sql)	(revision 12641)
@@ -1523,3 +1523,9 @@
 	DROP l3_Translated,
 	DROP l4_Translated,
 	DROP l5_Translated;
+
+ALTER TABLE Category
+	CHANGE CachedTemplate CachedTemplate varchar(255) NOT NULL DEFAULT '',
+	CHANGE ThemeId ThemeId int(10) unsigned NOT NULL DEFAULT '0';
+
+ALTER TABLE UserSession CHANGE BrowserSignature BrowserSignature varchar(32) NOT NULL DEFAULT '';
\ No newline at end of file