Index: trunk/core/install/install_schema.sql
===================================================================
diff -u -N -r8015 -r8029
--- trunk/core/install/install_schema.sql	(.../install_schema.sql)	(revision 8015)
+++ trunk/core/install/install_schema.sql	(.../install_schema.sql)	(revision 8029)
@@ -109,8 +109,8 @@
   TimeFormat varchar(50) NOT NULL default '',
   InputDateFormat varchar(50) NOT NULL default 'm/d/Y',
   InputTimeFormat varchar(50) NOT NULL default 'g:i:s A',
-  DecimalPoint char(2) NOT NULL default '',
-  ThousandSep TINYTEXT NOT NULL default '',
+  DecimalPoint VARCHAR(10) NOT NULL DEFAULT '',
+  ThousandSep VARCHAR(10) NOT NULL DEFAULT '',
   `Charset` varchar(20) NOT NULL default '',
   UnitSystem tinyint(4) NOT NULL default '1',
   PRIMARY KEY  (LanguageId)
@@ -145,7 +145,7 @@
   LanguageId int(11) NOT NULL default '0',
   LastChanged int(10) unsigned NOT NULL default '0',
   LastChangeIP varchar(15) NOT NULL default '',
-  Module varchar(30) NOT NULL default '',
+  Module VARCHAR(30) NOT NULL DEFAULT 'In-Portal',
   PRIMARY KEY  (PhraseId),
   KEY LanguageId (LanguageId),
   INDEX Phrase_Index (Phrase)
@@ -165,7 +165,7 @@
   GroupId int(11) NOT NULL auto_increment,
   Name varchar(255) NOT NULL default '',
   Description varchar(255) default NULL,
-  CreatedOn double NOT NULL default '0',
+  CreatedOn INT UNSIGNED NULL DEFAULT NULL,
   System tinyint(4) NOT NULL default '0',
   Personal tinyint(4) NOT NULL default '0',
   Enabled tinyint(4) NOT NULL default '1',
@@ -265,16 +265,16 @@
 );
 
 CREATE TABLE UserSession (
-  SessionKey varchar(50) NOT NULL default '',
-  CurrentTempKey varchar(50) default NULL,
-  PrevTempKey varchar(50) default NULL,
-  LastAccessed double NOT NULL default '0',
-  PortalUserId varchar(255) NOT NULL default '',
-  Language varchar(255) NOT NULL default '',
-  Theme varchar(255) NOT NULL default '',
+  SessionKey int(10) unsigned NOT NULL default '0',
+  CurrentTempKey int(10) unsigned default NULL,
+  PrevTempKey int(10) unsigned default NULL,
+  LastAccessed int(10) unsigned NOT NULL default '0',
+  PortalUserId int(11) NOT NULL default '-2',
+  `Language` int(11) NOT NULL default '1',
+  Theme int(11) NOT NULL default '1',
   GroupId int(11) NOT NULL default '0',
   IpAddress varchar(20) NOT NULL default '0.0.0.0',
-  Status int(11) NOT NULL default '1',
+  `Status` int(11) NOT NULL default '1',
   GroupList varchar(255) default NULL,
   tz int(11) default NULL,
   PRIMARY KEY  (SessionKey),