Index: trunk/admin/install/inportal_schema.sql
===================================================================
diff -u -r1267 -r1349
--- trunk/admin/install/inportal_schema.sql	(.../inportal_schema.sql)	(revision 1267)
+++ trunk/admin/install/inportal_schema.sql	(.../inportal_schema.sql)	(revision 1349)
@@ -19,7 +19,7 @@
   ParentId int(11) NOT NULL default '0',
   Name varchar(255) NOT NULL default '',
   Description text NOT NULL,
-  CreatedOn double NOT NULL default '0',
+  CreatedOn int(11) NOT NULL default '0',
   EditorsPick tinyint(4) default NULL,
   Status tinyint(4) NOT NULL default '0',
   Pop tinyint(4) default NULL,
@@ -34,7 +34,7 @@
   HotItem int(11) NOT NULL default '2',
   NewItem int(11) NOT NULL default '2',
   PopItem int(11) NOT NULL default '2',
-  Modified double NOT NULL default '0',
+  Modified int(11) NOT NULL default '0',
   ModifiedById int(11) NOT NULL default '0',
   PRIMARY KEY  (CategoryId),
   KEY ParentId (ParentId),
@@ -50,7 +50,7 @@
   CategoryId int(11) NOT NULL default '0',
   ItemResourceId int(11) NOT NULL default '0',
   PrimaryCat tinyint(4) NOT NULL default '0',
-  PRIMARY KEY  (CategoryId,ItemResourceId),
+  KEY CategoryId (CategoryId),
   KEY ItemResourceId (ItemResourceId),
   KEY PrimaryCat (PrimaryCat)
 )
@@ -459,6 +459,7 @@
   SessionKey varchar(50) NOT NULL default '',
   VariableName varchar(255) NOT NULL default '',
   VariableValue text NOT NULL,
+  PRIMARY KEY  (`SessionKey`,`VariableName`),
   KEY SessionKey (SessionKey),
   KEY VariableName (VariableName)
 )
