Index: branches/RC/core/install/install_schema.sql =================================================================== diff -u -N -r11411 -r11495 --- branches/RC/core/install/install_schema.sql (.../install_schema.sql) (revision 11411) +++ branches/RC/core/install/install_schema.sql (.../install_schema.sql) (revision 11495) @@ -369,7 +369,7 @@ `Type` int(11) NOT NULL default '0', SymLinkCategoryId int(10) unsigned default NULL, ParentId int(11) NOT NULL default '0', - Name varchar(255) NOT NULL default '', + `Name` varchar(255) NOT NULL default '', l1_Name varchar(255) NOT NULL default '', l2_Name varchar(255) NOT NULL default '', l3_Name varchar(255) NOT NULL default '', @@ -387,7 +387,7 @@ EditorsPick tinyint(4) NOT NULL default '0', `Status` tinyint(4) NOT NULL default '2', Priority int(11) NOT NULL default '0', - MetaKeywords varchar(255) default NULL, + MetaKeywords text, CachedDescendantCatsQty int(11) default NULL, CachedNavbar text, l1_CachedNavbar text, @@ -397,24 +397,54 @@ l5_CachedNavbar text, CreatedById int(11) NOT NULL default '0', ResourceId int(11) default NULL, - ParentPath TEXT NULL DEFAULT NULL, + ParentPath text, TreeLeft bigint(20) NOT NULL default '0', TreeRight bigint(20) NOT NULL default '0', - NamedParentPath TEXT NULL DEFAULT NULL, - MetaDescription varchar(255) default NULL, + NamedParentPath text, + MetaDescription text, HotItem int(11) NOT NULL default '2', NewItem int(11) NOT NULL default '2', PopItem int(11) NOT NULL default '2', Modified int(11) NOT NULL default '0', ModifiedById int(11) NOT NULL default '0', CategoryTemplate varchar(255) NOT NULL default '', CachedCategoryTemplate varchar(255) NOT NULL default '', + Template varchar(255) default NULL, + Path varchar(255) default NULL, + UseExternalUrl tinyint(3) unsigned NOT NULL default '0', + ExternalUrl varchar(255) NOT NULL default '', + UseMenuIconUrl tinyint(3) unsigned NOT NULL default '0', + MenuIconUrl varchar(255) NOT NULL default '', + l1_Title varchar(255) default '', + l2_Title varchar(255) default '', + l3_Title varchar(255) default '', + l4_Title varchar(255) default '', + l5_Title varchar(255) default '', + l1_MenuTitle varchar(255) NOT NULL default '', + l2_MenuTitle varchar(255) NOT NULL default '', + l3_MenuTitle varchar(255) NOT NULL default '', + l4_MenuTitle varchar(255) NOT NULL default '', + l5_MenuTitle varchar(255) NOT NULL default '', + MetaTitle text, + IndexTools text, + IsIndex tinyint(1) NOT NULL default '0', + IsMenu tinyint(4) NOT NULL default '1', + IsSystem tinyint(4) NOT NULL default '0', + FormId int(11) default NULL, + FormSubmittedTemplate varchar(255) default NULL, + l1_Translated tinyint(4) NOT NULL default '0', + l2_Translated tinyint(4) NOT NULL default '0', + l3_Translated tinyint(4) NOT NULL default '0', + l4_Translated tinyint(4) NOT NULL default '0', + l5_Translated tinyint(4) NOT NULL default '0', + FriendlyURL varchar(255) NOT NULL default '', + ThemeId int(10) unsigned NOT NULL, PRIMARY KEY (CategoryId), UNIQUE KEY ResourceId (ResourceId), KEY ParentId (ParentId), KEY Modified (Modified), KEY Priority (Priority), - KEY sorting (Name,Priority), + KEY sorting (`Name`,Priority), KEY Filename (Filename(5)), KEY l1_Name (l1_Name(5)), KEY l2_Name (l2_Name(5)), @@ -429,9 +459,16 @@ KEY TreeLeft (TreeLeft), KEY TreeRight (TreeRight), KEY SymLinkCategoryId (SymLinkCategoryId), - KEY Status (Status), + KEY `Status` (`Status`), KEY CreatedOn (CreatedOn), - KEY EditorsPick (EditorsPick) + KEY EditorsPick (EditorsPick), + KEY IsIndex (IsIndex), + KEY l1_Translated (l1_Translated), + KEY l2_Translated (l2_Translated), + KEY l3_Translated (l3_Translated), + KEY l4_Translated (l4_Translated), + KEY l5_Translated (l5_Translated), + KEY ThemeId (ThemeId) ); CREATE TABLE CategoryCustomData ( @@ -996,4 +1033,62 @@ KEY EmailsQueued (EmailsQueued), KEY `Status` (`Status`), KEY PortalUserId (PortalUserId) +); + +CREATE TABLE PageContent ( + PageContentId int(11) NOT NULL auto_increment, + ContentNum int(11) NOT NULL default '0', + PageId int(11) NOT NULL default '0', + l1_Content text, + l2_Content text, + l3_Content text, + l4_Content text, + l5_Content text, + l1_Translated tinyint(4) NOT NULL default '0', + l2_Translated tinyint(4) NOT NULL default '0', + l3_Translated tinyint(4) NOT NULL default '0', + l4_Translated tinyint(4) NOT NULL default '0', + l5_Translated tinyint(4) NOT NULL default '0', + PRIMARY KEY (PageContentId), + KEY ContentNum (ContentNum,PageId) +); + +CREATE TABLE FormFields ( + FormFieldId int(11) NOT NULL auto_increment, + FormId int(11) NOT NULL default '0', + Type int(11) NOT NULL default '0', + FieldName varchar(255) NOT NULL default '', + FieldLabel varchar(255) default NULL, + Heading varchar(255) default NULL, + Prompt varchar(255) default NULL, + ElementType varchar(50) NOT NULL default '', + ValueList varchar(255) default NULL, + Priority int(11) NOT NULL default '0', + IsSystem tinyint(3) unsigned NOT NULL default '0', + Required tinyint(1) NOT NULL default '0', + DisplayInGrid tinyint(1) NOT NULL default '1', + DefaultValue text NOT NULL, + Validation TINYINT NOT NULL DEFAULT '0', + PRIMARY KEY (FormFieldId), + KEY `Type` (`Type`), + KEY FormId (FormId), + KEY Priority (Priority), + KEY IsSystem (IsSystem), + KEY DisplayInGrid (DisplayInGrid) +); + +CREATE TABLE FormSubmissions ( + FormSubmissionId int(11) NOT NULL auto_increment, + FormId int(11) NOT NULL default '0', + SubmissionTime int(11) NOT NULL default '0', + PRIMARY KEY (FormSubmissionId), + KEY FormId (FormId), + KEY SubmissionTime (SubmissionTime) +); + +CREATE TABLE Forms ( + FormId int(11) NOT NULL auto_increment, + Title VARCHAR(255) NOT NULL DEFAULT '', + Description text, + PRIMARY KEY (FormId) ); \ No newline at end of file