Index: branches/unlabeled/unlabeled-1.4.2/core/install/install_schema.sql
===================================================================
diff -u -r7811 -r7816
--- branches/unlabeled/unlabeled-1.4.2/core/install/install_schema.sql	(.../install_schema.sql)	(revision 7811)
+++ branches/unlabeled/unlabeled-1.4.2/core/install/install_schema.sql	(.../install_schema.sql)	(revision 7816)
@@ -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,7 +61,7 @@
 CREATE TABLE EmailMessage (
   EmailMessageId int(10) NOT NULL auto_increment,
   Template longtext,
-  ReplacementTags text NOT NULL,
+  ReplacementTags text,
   MessageType enum('html','text') NOT NULL default 'text',
   LanguageId int(11) NOT NULL default '0',
   EventId int(11) NOT NULL default '0',
@@ -70,9 +70,9 @@
 );
 
 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
@@ -139,7 +139,7 @@
 
 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',
@@ -324,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,
