Index: trunk/core/install/install_schema.sql
===================================================================
diff -u -N -r7403 -r7855
--- trunk/core/install/install_schema.sql	(.../install_schema.sql)	(revision 7403)
+++ trunk/core/install/install_schema.sql	(.../install_schema.sql)	(revision 7855)
@@ -41,7 +41,7 @@
   prompt varchar(255) default NULL,
   element_type varchar(20) NOT NULL default '',
   validation varchar(255) default NULL,
-  ValueList text default NULL,
+  ValueList text,
   DisplayOrder double NOT NULL default '0',
   GroupDisplayOrder double NOT NULL default '0',
   Install int(11) NOT NULL default '1',
@@ -61,17 +61,18 @@
 CREATE TABLE EmailMessage (
   EmailMessageId int(10) NOT NULL auto_increment,
   Template longtext,
+  ReplacementTags text,
   MessageType enum('html','text') NOT NULL default 'text',
   LanguageId int(11) NOT NULL default '0',
   EventId int(11) NOT NULL default '0',
-  Subject text,
+  `Subject` text,
   PRIMARY KEY  (EmailMessageId)
 );
 
 CREATE TABLE EmailQueue (
-  Subject text NOT NULL,
-  toaddr text NOT NULL,
-  fromaddr text NOT NULL,
+  Subject text,
+  toaddr text,
+  fromaddr text,
   message blob,
   headers blob,
   queued timestamp NOT NULL
@@ -86,7 +87,7 @@
   EventId int(11) NOT NULL auto_increment,
   Event varchar(40) NOT NULL default '',
   Enabled int(11) NOT NULL default '1',
-  FromUserId int(11) NOT NULL default '0',
+  FromUserId int(11) NOT NULL default '-1',
   Module varchar(40) NOT NULL default '',
   Description varchar(255) NOT NULL default '',
   Type int(11) NOT NULL default '0',
@@ -101,45 +102,44 @@
   LanguageId int(11) NOT NULL auto_increment,
   PackName varchar(40) NOT NULL default '',
   LocalName varchar(40) NOT NULL default '',
-  Enabled int(11) NOT NULL default '0',
+  Enabled int(11) NOT NULL default '1',
   PrimaryLang int(11) NOT NULL default '0',
   IconURL varchar(255) default NULL,
   DateFormat varchar(50) NOT NULL default '',
   TimeFormat varchar(50) NOT NULL default '',
-  InputDateFormat varchar(50) NOT NULL default '',
-  InputTimeFormat varchar(50) NOT NULL default '',
-  DecimalPoint char(2) NOT NULL default '.',
-  ThousandSep tinytext NULL,
-  Charset varchar(20) 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,
+  `Charset` varchar(20) NOT NULL default '',
   UnitSystem tinyint(4) NOT NULL default '1',
   PRIMARY KEY  (LanguageId)
 );
 
 CREATE TABLE Modules (
-  Name varchar(255) NOT NULL default '',
+  `Name` varchar(255) NOT NULL default '',
   Path varchar(255) NOT NULL default '',
   Var varchar(10) NOT NULL default '',
-  Version varchar(10) NOT NULL default '',
+  Version varchar(10) NOT NULL default '0.0.0',
   Loaded tinyint(4) NOT NULL default '1',
   LoadOrder tinyint(4) NOT NULL default '0',
   TemplatePath varchar(255) NOT NULL default '',
   RootCat int(11) NOT NULL default '0',
-  BuildDate double NOT NULL default '0',
-  PRIMARY KEY  (Name)
+  BuildDate int(10) unsigned default NULL,
+  PRIMARY KEY  (`Name`)
 );
 
 CREATE TABLE PersistantSessionData (
   PortalUserId int(11) NOT NULL default '0',
   VariableName varchar(255) NOT NULL default '',
   VariableValue text NOT NULL,
-  PRIMARY KEY  (PortalUserId,VariableName),
   KEY UserId (PortalUserId),
   KEY VariableName (VariableName)
 );
 
 CREATE TABLE Phrase (
   Phrase varchar(255) NOT NULL default '',
-  Translation text NOT NULL default '',
+  Translation text NOT NULL,
   PhraseType int(11) NOT NULL default '0',
   PhraseId int(11) NOT NULL auto_increment,
   LanguageId int(11) NOT NULL default '0',
@@ -185,7 +185,7 @@
   LastName varchar(255) default NULL,
   Company varchar(255) NOT NULL default '',
   Email varchar(255) NOT NULL default '',
-  CreatedOn double NOT NULL default '0',
+  CreatedOn INT DEFAULT NULL,
   Phone varchar(20) default NULL,
   Fax varchar(255) NOT NULL default '',
   Street varchar(255) default NULL,
@@ -197,13 +197,13 @@
   ResourceId int(11) NOT NULL default '0',
   `Status` tinyint(4) NOT NULL default '2',
   Modified int(11) NOT NULL default '0',
-  dob double NOT NULL default '0',
+  dob INT(11) NULL DEFAULT NULL,
   tz int(11) default NULL,
   ip varchar(20) default NULL,
   IsBanned tinyint(1) NOT NULL default '0',
-  PassResetTime bigint(20) default NULL,
+  PassResetTime INT(11) UNSIGNED NULL DEFAULT NULL,
   PwResetConfirm varchar(255) default NULL,
-  PwRequestTime bigint(25) default NULL,
+  PwRequestTime INT(11) UNSIGNED NULL DEFAULT NULL,
   MinPwResetDelay int(11) NOT NULL default '1800',
   PRIMARY KEY  (PortalUserId),
   UNIQUE KEY ResourceId (ResourceId),
@@ -286,9 +286,10 @@
   EmailLogId int(11) NOT NULL auto_increment,
   fromuser varchar(200) default NULL,
   addressto varchar(255) default NULL,
-  subject varchar(255) default NULL,
-  timestamp bigint(20) default '0',
+  `subject` varchar(255) default NULL,
+  `timestamp` bigint(20) default '0',
   event varchar(100) default NULL,
+  EventParams text NOT NULL,
   PRIMARY KEY  (EmailLogId)
 );
 
@@ -307,7 +308,7 @@
   DestParentId int(11) default NULL,
   DestName varchar(255) NOT NULL default '',
   DestAbbr char(3) NOT NULL default '',
-  DestAbbr2 char(2) default '',
+  DestAbbr2 char(2) default NULL,
   PRIMARY KEY  (DestId)
 );
 
@@ -323,25 +324,24 @@
   l5_Name varchar(255) NOT NULL default '',
   Filename varchar(255) NOT NULL default '',
   AutomaticFilename tinyint(3) unsigned NOT NULL default '1',
-  Description text NOT NULL,
-  l1_Description text NOT NULL,
-  l2_Description text NOT NULL,
-  l3_Description text NOT NULL,
-  l4_Description text NOT NULL,
-  l5_Description text NOT NULL,
+  Description text,
+  l1_Description text,
+  l2_Description text,
+  l3_Description text,
+  l4_Description text,
+  l5_Description text,
   CreatedOn int(11) NOT NULL default '0',
   EditorsPick tinyint(4) NOT NULL default '0',
   `Status` tinyint(4) NOT NULL default '0',
-  Pop tinyint(4) default NULL,
   Priority int(11) NOT NULL default '0',
   MetaKeywords varchar(255) default NULL,
   CachedDescendantCatsQty int(11) default NULL,
-  CachedNavbar text NOT NULL,
-  l1_CachedNavbar text NOT NULL,
-  l2_CachedNavbar text NOT NULL,
-  l3_CachedNavbar text NOT NULL,
-  l4_CachedNavbar text NOT NULL,
-  l5_CachedNavbar text NOT NULL,
+  CachedNavbar text,
+  l1_CachedNavbar text,
+  l2_CachedNavbar text,
+  l3_CachedNavbar text,
+  l4_CachedNavbar text,
+  l5_CachedNavbar text,
   CreatedById int(11) NOT NULL default '0',
   ResourceId int(11) default NULL,
   ParentPath text NOT NULL,
@@ -397,7 +397,6 @@
   CategoryId int(11) NOT NULL default '0',
   PermId int(11) NOT NULL default '0',
   ACL varchar(255) NOT NULL default '',
-  DACL varchar(255) NOT NULL default '',
   PRIMARY KEY  (PermCacheId),
   KEY CategoryId (CategoryId),
   KEY PermId (PermId)