Index: trunk/admin/install/inportal_schema.sql
===================================================================
diff -u -N -r8015 -r8029
--- trunk/admin/install/inportal_schema.sql	(.../inportal_schema.sql)	(revision 8015)
+++ trunk/admin/install/inportal_schema.sql	(.../inportal_schema.sql)	(revision 8029)
@@ -63,7 +63,7 @@
 CREATE TABLE ItemRating (
   RatingId int(11) NOT NULL auto_increment,
   IPAddress varchar(255) NOT NULL default '',
-  CreatedOn double NOT NULL default '0',
+  CreatedOn INT UNSIGNED NULL DEFAULT NULL,
   RatingValue int(11) NOT NULL default '0',
   ItemId int(11) NOT NULL default '0',
   PRIMARY KEY  (RatingId)
@@ -73,7 +73,7 @@
 
 CREATE TABLE ItemReview (
   ReviewId int(11) NOT NULL auto_increment,
-  CreatedOn double NOT NULL default '0',
+  CreatedOn INT UNSIGNED NULL DEFAULT NULL,
   ReviewText longtext NOT NULL,
   IPAddress varchar(255) NOT NULL default '',
   ItemId int(11) NOT NULL default '0',
@@ -131,7 +131,7 @@
   AdvancedSearch tinyint(4) NOT NULL default '1',
   Description varchar(255) default NULL,
   DisplayName varchar(80) default NULL,
-  ModuleName VARCHAR(20) NULL DEFAULT 'In-Portal',
+  ModuleName VARCHAR(20) NOT NULL DEFAULT 'In-Portal',
   ConfigHeader varchar(255) default NULL,
   DisplayOrder int(11) NOT NULL default '0',
   SearchConfigId int(11) NOT NULL auto_increment,
@@ -169,7 +169,7 @@
 CREATE TABLE SpamControl (
   ItemResourceId int(11) NOT NULL default '0',
   IPaddress varchar(20) NOT NULL default '',
-  Expire double NOT NULL default '0',
+  Expire INT UNSIGNED NULL DEFAULT NULL,
   PortalUserId int(11) NOT NULL default '0',
   DataType varchar(20) default NULL
 )
@@ -191,7 +191,7 @@
 
 CREATE TABLE SuggestMail (
   email varchar(255) NOT NULL default '',
-  sent double,
+  sent INT UNSIGNED NULL DEFAULT NULL,
   PRIMARY KEY  (email)
 )
 
@@ -201,7 +201,7 @@
   SysCacheId int(11) NOT NULL auto_increment,
   Name varchar(255) NOT NULL default '',
   Value mediumtext,
-  Expire double NOT NULL default '0',
+  Expire INT UNSIGNED NULL DEFAULT NULL,
   Module varchar(20) default NULL,
   Context varchar(255) default NULL,
   GroupList varchar(255) NOT NULL default '',
