Index: branches/5.2.x/_install/install_data.sql
===================================================================
diff -u -N -r13829 -r14084
--- branches/5.2.x/_install/install_data.sql	(.../install_data.sql)	(revision 13829)
+++ branches/5.2.x/_install/install_data.sql	(.../install_data.sql)	(revision 14084)
@@ -1,9 +1,9 @@
 UPDATE Category SET IsMenu = 1 WHERE Template = 'index';
 
-INSERT INTO Category (CategoryId, Type, SymLinkCategoryId, ParentId, Name, l1_Name, l2_Name, l3_Name, l4_Name, l5_Name, Filename, AutomaticFilename, Description, l1_Description, l2_Description, l3_Description, l4_Description, l5_Description, CreatedOn, EditorsPick, Status, Priority, MetaKeywords, CachedDescendantCatsQty, CachedNavbar, l1_CachedNavbar, l2_CachedNavbar, l3_CachedNavbar, l4_CachedNavbar, l5_CachedNavbar, CreatedById, ResourceId, ParentPath, TreeLeft, TreeRight, NamedParentPath, MetaDescription, HotItem, NewItem, PopItem, Modified, ModifiedById, CachedTemplate, Template, UseExternalUrl, ExternalUrl, UseMenuIconUrl, MenuIconUrl, l1_Title, l2_Title, l3_Title, l4_Title, l5_Title, l1_MenuTitle, l2_MenuTitle, l3_MenuTitle, l4_MenuTitle, l5_MenuTitle, MetaTitle, IndexTools, IsMenu, IsSystem, FormId, FormSubmittedTemplate, FriendlyURL, ThemeId) VALUES(200, 0, NULL, 1, '', 'About', '', '', '', '', 'About', 1, NULL, NULL, NULL, NULL, NULL, NULL, 1257194857, 0, 1, -3, NULL, 0, NULL, 'Content&|&About', 'Content&|&About', 'Content&|&About', 'Content&|&About', 'Content&|&About', -1, 200, '|1|200|', 12, 13, 'Content/About', NULL, 2, 2, 2, 1257194911, 0, '#default_design#', '#default_design#', 0, '', 0, '', 'About', '', '', '', '', 'About', '', '', '', '', NULL, NULL, 1, 0, NULL, NULL, '', 0);
-INSERT INTO Category (CategoryId, Type, SymLinkCategoryId, ParentId, Name, l1_Name, l2_Name, l3_Name, l4_Name, l5_Name, Filename, AutomaticFilename, Description, l1_Description, l2_Description, l3_Description, l4_Description, l5_Description, CreatedOn, EditorsPick, Status, Priority, MetaKeywords, CachedDescendantCatsQty, CachedNavbar, l1_CachedNavbar, l2_CachedNavbar, l3_CachedNavbar, l4_CachedNavbar, l5_CachedNavbar, CreatedById, ResourceId, ParentPath, TreeLeft, TreeRight, NamedParentPath, MetaDescription, HotItem, NewItem, PopItem, Modified, ModifiedById, CachedTemplate, Template, UseExternalUrl, ExternalUrl, UseMenuIconUrl, MenuIconUrl, l1_Title, l2_Title, l3_Title, l4_Title, l5_Title, l1_MenuTitle, l2_MenuTitle, l3_MenuTitle, l4_MenuTitle, l5_MenuTitle, MetaTitle, IndexTools, IsMenu, IsSystem, FormId, FormSubmittedTemplate, FriendlyURL, ThemeId) VALUES(201, 0, NULL, 1, '', 'Products', '', '', '', '', 'Products', 1, NULL, NULL, NULL, NULL, NULL, NULL, 1257194857, 0, 1, -4, NULL, 0, NULL, 'Content&|&Products', 'Content&|&Products', 'Content&|&Products', 'Content&|&Products', 'Content&|&Products', -1, 201, '|1|201|', 14, 15, 'Content/Products', NULL, 2, 2, 2, 1257197984, -1, '#default_design#', '#default_design#', 0, '', 0, '', 'Products', '', '', '', '', 'Products', '', '', '', '', NULL, NULL, 1, 0, NULL, NULL, '', 0);
-INSERT INTO Category (CategoryId, Type, SymLinkCategoryId, ParentId, Name, l1_Name, l2_Name, l3_Name, l4_Name, l5_Name, Filename, AutomaticFilename, Description, l1_Description, l2_Description, l3_Description, l4_Description, l5_Description, CreatedOn, EditorsPick, Status, Priority, MetaKeywords, CachedDescendantCatsQty, CachedNavbar, l1_CachedNavbar, l2_CachedNavbar, l3_CachedNavbar, l4_CachedNavbar, l5_CachedNavbar, CreatedById, ResourceId, ParentPath, TreeLeft, TreeRight, NamedParentPath, MetaDescription, HotItem, NewItem, PopItem, Modified, ModifiedById, CachedTemplate, Template, UseExternalUrl, ExternalUrl, UseMenuIconUrl, MenuIconUrl, l1_Title, l2_Title, l3_Title, l4_Title, l5_Title, l1_MenuTitle, l2_MenuTitle, l3_MenuTitle, l4_MenuTitle, l5_MenuTitle, MetaTitle, IndexTools, IsMenu, IsSystem, FormId, FormSubmittedTemplate, FriendlyURL, ThemeId) VALUES(202, 0, NULL, 1, '', 'Services', '', '', '', '', 'Services', 1, NULL, NULL, NULL, NULL, NULL, NULL, 1257194857, 0, 1, -5, NULL, 0, NULL, 'Content&|&Services', 'Content&|&Services', 'Content&|&Services', 'Content&|&Services', 'Content&|&Services', -1, 202, '|1|202|', 16, 17, 'Content/Services', NULL, 2, 2, 2, 1257200289, -1, '#default_design#', '#default_design#', 0, '', 0, '', 'Services', '', '', '', '', 'Services', '', '', '', '', NULL, NULL, 1, 0, NULL, NULL, '', 0);
-INSERT INTO Category (CategoryId, Type, SymLinkCategoryId, ParentId, Name, l1_Name, l2_Name, l3_Name, l4_Name, l5_Name, Filename, AutomaticFilename, Description, l1_Description, l2_Description, l3_Description, l4_Description, l5_Description, CreatedOn, EditorsPick, Status, Priority, MetaKeywords, CachedDescendantCatsQty, CachedNavbar, l1_CachedNavbar, l2_CachedNavbar, l3_CachedNavbar, l4_CachedNavbar, l5_CachedNavbar, CreatedById, ResourceId, ParentPath, TreeLeft, TreeRight, NamedParentPath, MetaDescription, HotItem, NewItem, PopItem, Modified, ModifiedById, CachedTemplate, Template, UseExternalUrl, ExternalUrl, UseMenuIconUrl, MenuIconUrl, l1_Title, l2_Title, l3_Title, l4_Title, l5_Title, l1_MenuTitle, l2_MenuTitle, l3_MenuTitle, l4_MenuTitle, l5_MenuTitle, MetaTitle, IndexTools, IsMenu, IsSystem, FormId, FormSubmittedTemplate, FriendlyURL, ThemeId) VALUES(203, 0, NULL, 1, '', 'Contact Us', '', '', '', '', 'Contact-Us', 1, NULL, NULL, NULL, NULL, NULL, NULL, 1257208139, 0, 1, -6, NULL, 0, NULL, 'Content&|&Contact Us', 'Content&|&Contact Us', 'Content&|&Contact Us', 'Content&|&Contact Us', 'Content&|&Contact Us', -1, 203, '|1|203|', 18, 19, 'Content/Contact-Us', NULL, 2, 2, 2, 1257208178, 0, '#form_design#', '#form_design#', 0, '', 0, '', 'Contact Us', '', '', '', '', 'Contact Us', '', '', '', '', NULL, NULL, 1, 0, 1, 'thankyou', '', 0);
+INSERT INTO Category (CategoryId, Type, SymLinkCategoryId, ParentId, Name, l1_Name, l2_Name, l3_Name, l4_Name, l5_Name, Filename, AutomaticFilename, Description, l1_Description, l2_Description, l3_Description, l4_Description, l5_Description, CreatedOn, EditorsPick, Status, Priority, MetaKeywords, CachedDescendantCatsQty, CachedNavbar, l1_CachedNavbar, l2_CachedNavbar, l3_CachedNavbar, l4_CachedNavbar, l5_CachedNavbar, CreatedById, ResourceId, ParentPath, TreeLeft, TreeRight, NamedParentPath, MetaDescription, HotItem, NewItem, PopItem, Modified, ModifiedById, CachedTemplate, Template, UseExternalUrl, ExternalUrl, UseMenuIconUrl, MenuIconUrl, l1_Title, l2_Title, l3_Title, l4_Title, l5_Title, l1_MenuTitle, l2_MenuTitle, l3_MenuTitle, l4_MenuTitle, l5_MenuTitle, MetaTitle, IndexTools, IsMenu, Protected, FormId, FormSubmittedTemplate, FriendlyURL, ThemeId) VALUES(200, 1, NULL, 1, '', 'About', '', '', '', '', 'About', 1, NULL, NULL, NULL, NULL, NULL, NULL, 1257194857, 0, 1, -3, NULL, 0, NULL, 'Content&|&About', 'Content&|&About', 'Content&|&About', 'Content&|&About', 'Content&|&About', -1, 200, '|1|200|', 12, 13, 'Content/About', NULL, 2, 2, 2, 1257194911, 0, '#default_design#', '#default_design#', 0, '', 0, '', 'About', '', '', '', '', 'About', '', '', '', '', NULL, NULL, 1, 0, NULL, NULL, '', 0);
+INSERT INTO Category (CategoryId, Type, SymLinkCategoryId, ParentId, Name, l1_Name, l2_Name, l3_Name, l4_Name, l5_Name, Filename, AutomaticFilename, Description, l1_Description, l2_Description, l3_Description, l4_Description, l5_Description, CreatedOn, EditorsPick, Status, Priority, MetaKeywords, CachedDescendantCatsQty, CachedNavbar, l1_CachedNavbar, l2_CachedNavbar, l3_CachedNavbar, l4_CachedNavbar, l5_CachedNavbar, CreatedById, ResourceId, ParentPath, TreeLeft, TreeRight, NamedParentPath, MetaDescription, HotItem, NewItem, PopItem, Modified, ModifiedById, CachedTemplate, Template, UseExternalUrl, ExternalUrl, UseMenuIconUrl, MenuIconUrl, l1_Title, l2_Title, l3_Title, l4_Title, l5_Title, l1_MenuTitle, l2_MenuTitle, l3_MenuTitle, l4_MenuTitle, l5_MenuTitle, MetaTitle, IndexTools, IsMenu, Protected, FormId, FormSubmittedTemplate, FriendlyURL, ThemeId) VALUES(201, 1, NULL, 1, '', 'Products', '', '', '', '', 'Products', 1, NULL, NULL, NULL, NULL, NULL, NULL, 1257194857, 0, 1, -4, NULL, 0, NULL, 'Content&|&Products', 'Content&|&Products', 'Content&|&Products', 'Content&|&Products', 'Content&|&Products', -1, 201, '|1|201|', 14, 15, 'Content/Products', NULL, 2, 2, 2, 1257197984, -1, '#default_design#', '#default_design#', 0, '', 0, '', 'Products', '', '', '', '', 'Products', '', '', '', '', NULL, NULL, 1, 0, NULL, NULL, '', 0);
+INSERT INTO Category (CategoryId, Type, SymLinkCategoryId, ParentId, Name, l1_Name, l2_Name, l3_Name, l4_Name, l5_Name, Filename, AutomaticFilename, Description, l1_Description, l2_Description, l3_Description, l4_Description, l5_Description, CreatedOn, EditorsPick, Status, Priority, MetaKeywords, CachedDescendantCatsQty, CachedNavbar, l1_CachedNavbar, l2_CachedNavbar, l3_CachedNavbar, l4_CachedNavbar, l5_CachedNavbar, CreatedById, ResourceId, ParentPath, TreeLeft, TreeRight, NamedParentPath, MetaDescription, HotItem, NewItem, PopItem, Modified, ModifiedById, CachedTemplate, Template, UseExternalUrl, ExternalUrl, UseMenuIconUrl, MenuIconUrl, l1_Title, l2_Title, l3_Title, l4_Title, l5_Title, l1_MenuTitle, l2_MenuTitle, l3_MenuTitle, l4_MenuTitle, l5_MenuTitle, MetaTitle, IndexTools, IsMenu, Protected, FormId, FormSubmittedTemplate, FriendlyURL, ThemeId) VALUES(202, 1, NULL, 1, '', 'Services', '', '', '', '', 'Services', 1, NULL, NULL, NULL, NULL, NULL, NULL, 1257194857, 0, 1, -5, NULL, 0, NULL, 'Content&|&Services', 'Content&|&Services', 'Content&|&Services', 'Content&|&Services', 'Content&|&Services', -1, 202, '|1|202|', 16, 17, 'Content/Services', NULL, 2, 2, 2, 1257200289, -1, '#default_design#', '#default_design#', 0, '', 0, '', 'Services', '', '', '', '', 'Services', '', '', '', '', NULL, NULL, 1, 0, NULL, NULL, '', 0);
+INSERT INTO Category (CategoryId, Type, SymLinkCategoryId, ParentId, Name, l1_Name, l2_Name, l3_Name, l4_Name, l5_Name, Filename, AutomaticFilename, Description, l1_Description, l2_Description, l3_Description, l4_Description, l5_Description, CreatedOn, EditorsPick, Status, Priority, MetaKeywords, CachedDescendantCatsQty, CachedNavbar, l1_CachedNavbar, l2_CachedNavbar, l3_CachedNavbar, l4_CachedNavbar, l5_CachedNavbar, CreatedById, ResourceId, ParentPath, TreeLeft, TreeRight, NamedParentPath, MetaDescription, HotItem, NewItem, PopItem, Modified, ModifiedById, CachedTemplate, Template, UseExternalUrl, ExternalUrl, UseMenuIconUrl, MenuIconUrl, l1_Title, l2_Title, l3_Title, l4_Title, l5_Title, l1_MenuTitle, l2_MenuTitle, l3_MenuTitle, l4_MenuTitle, l5_MenuTitle, MetaTitle, IndexTools, IsMenu, Protected, FormId, FormSubmittedTemplate, FriendlyURL, ThemeId) VALUES(203, 1, NULL, 1, '', 'Contact Us', '', '', '', '', 'Contact-Us', 1, NULL, NULL, NULL, NULL, NULL, NULL, 1257208139, 0, 1, -6, NULL, 0, NULL, 'Content&|&Contact Us', 'Content&|&Contact Us', 'Content&|&Contact Us', 'Content&|&Contact Us', 'Content&|&Contact Us', -1, 203, '|1|203|', 18, 19, 'Content/Contact-Us', NULL, 2, 2, 2, 1257208178, 0, '#form_design#', '#form_design#', 0, '', 0, '', 'Contact Us', '', '', '', '', 'Contact Us', '', '', '', '', NULL, NULL, 1, 0, 1, 'thankyou', '', 0);
 
 UPDATE IdGenerator SET lastid = lastid + 100;
 
@@ -22,14 +22,14 @@
 INSERT INTO PermCache VALUES(DEFAULT, 202, 1, '11');
 INSERT INTO PermCache VALUES(DEFAULT, 203, 1, '11');
 
-INSERT INTO Forms VALUES(1, 'Contact Us', 'Form for contacts', 0, 0, 0, '', '', '', '', '', '', '110', '', '', '', '', '110', '', '');
+INSERT INTO Forms VALUES(1, 'Contact Us', 'Form for contacts', 0, 1, 0, 0, '', '', '', '', '', '', '110', '', '', '', '', '110', '', '');
 
-INSERT INTO FormFields VALUES(1, 1, 0, 'Name', 'lu_fld_Name', NULL, 'la_fld_Name', 'text', NULL, 5, 0, 1, 1, NULL, 0, 1, 0);
+INSERT INTO FormFields VALUES(1, 1, 0, 'Name', 'lu_fld_Name', NULL, 'la_fld_Name', 'text', NULL, 5, 0, 1, 1, NULL, 0, 1, 1);
 INSERT INTO FormFields VALUES(2, 1, 0, 'Company', 'lu_fld_Company', NULL, 'la_fld_Company', 'text', NULL, 4, 0, 1, 1, NULL, 0, 1, 0);
-INSERT INTO FormFields VALUES(3, 1, 0, 'Email', 'lu_fld_Email', NULL, 'la_fld_Email', 'text', NULL, 3, 0, 1, 1, NULL, 1, 1, 0);
+INSERT INTO FormFields VALUES(3, 1, 0, 'Email', 'lu_fld_Email', NULL, 'la_fld_Email', 'text', NULL, 3, 0, 1, 1, NULL, 1, 1, 2);
 INSERT INTO FormFields VALUES(4, 1, 0, 'Phone', 'lu_fld_Phone', NULL, 'la_fld_Phone', 'text', NULL, 2, 0, 0, 1, NULL, 0, 1, 0);
-INSERT INTO FormFields VALUES(5, 1, 0, 'Message', 'lu_fld_Message', NULL, 'la_fld_Message', 'textarea', NULL, 0, 0, 1, 0, NULL, 0, 1, 0);
-INSERT INTO FormFields VALUES(6, 1, 0, 'Subject', 'lu_fld_Subject', NULL, 'la_fld_Subject', 'select', '=+-- Please select --||0=+Sales questions||1=+General questions||2=+Billing questions||3=+Support questions', 1, 0, 1, 0, NULL, 0, 1, 0);
+INSERT INTO FormFields VALUES(5, 1, 0, 'Message', 'lu_fld_Message', NULL, 'la_fld_Message', 'textarea', NULL, 0, 0, 1, 0, NULL, 0, 1, 4);
+INSERT INTO FormFields VALUES(6, 1, 0, 'Subject', 'lu_fld_Subject', NULL, 'la_fld_Subject', 'select', '=+-- Please select --||0=+Sales questions||1=+General questions||2=+Billing questions||3=+Support questions', 1, 0, 1, 0, NULL, 0, 1, 3);
 
 ALTER TABLE FormSubmissions
 	ADD COLUMN fld_1 text,