Index: branches/5.3.x/install/upgrades.sql =================================================================== diff -u -r12920 -r16550 --- branches/5.3.x/install/upgrades.sql (.../5.0.x/install/upgrades.sql) (revision 12920) +++ branches/5.3.x/install/upgrades.sql (.../5.3.x/install/upgrades.sql) (revision 16550) @@ -57,4 +57,111 @@ CHANGE StartDate StartDate INT(11) NULL DEFAULT NULL, CHANGE Modified Modified INT(11) NULL DEFAULT NULL; -# ===== v 5.0.2-B2 ===== \ No newline at end of file +# ===== v 5.0.2-B2 ===== + +# ===== v 5.0.2-RC1 ===== + +# ===== v 5.0.2 ===== + +# ===== v 5.0.3-B1 ===== + +# ===== v 5.0.3-B2 ===== + +# ===== v 5.0.3-RC1 ===== + +# ===== v 5.0.3 ===== + +# ===== v 5.0.4-B1 ===== + +# ===== v 5.0.4-B2 ===== + +# ===== v 5.0.4 ===== + +# ===== v 5.1.0-B1 ===== +UPDATE Modules SET Path = 'modules/in-news/' WHERE `Name` = 'In-News'; +DELETE FROM ConfigurationValues WHERE VariableName IN ( + 'Article_Root', 'News_PopCount', 'News_ArticleSort', 'News_CatSort', 'News_ShowMulti', + 'News_Admin_Notice_New', 'News_Admin_Notice_Modify', 'News_Admin_Notice_Suggest', + 'News_User_Notice_New', 'News_User_Notice_Approve', 'News_User_Notice_Deny', + 'News_User_Notice_Modify', 'News_User_Notice_Modify_Approve', 'News_User_Notice_Modify_Deny' +); + +DELETE FROM Permissions WHERE Permission LIKE 'in-news:configuration_email%'; + +# ===== v 5.1.0-RC1 ===== + +# ===== v 5.1.0 ===== + +# ===== v 5.1.1-B1 ===== +ALTER TABLE News + CHANGE CreatedById CreatedById INT(11) NULL DEFAULT NULL , + CHANGE ModifiedById ModifiedById INT(11) NULL DEFAULT NULL; + +# ===== v 5.1.1-RC1 ===== + +# ===== v 5.1.1 ===== + +# ===== v 5.1.2-B1 ===== + +# ===== v 5.1.2-RC1 ===== + +# ===== v 5.1.2 ===== + +# ===== v 5.1.3-B1 ===== + +# ===== v 5.1.3-RC1 ===== +UPDATE ConfigurationValues +SET VariableValue = 'in-news/articles/article_detail' +WHERE VariableName = 'n_ItemTemplate' AND VariableValue = 'in-news/designs/detail'; + +# ===== v 5.1.3-RC2 ===== + +# ===== v 5.1.3 ===== +UPDATE Phrase +SET `Module` = 'Core' +WHERE PhraseKey = 'LA_FLD_STARTDATE'; + +# ===== v 5.2.0-B1 ===== +DELETE FROM SystemSettings +WHERE VariableName IN ('News_Highlight_OpenTag', 'News_Highlight_CloseTag'); + +# ===== v 5.2.0-B2 ===== +UPDATE News main_table +SET main_table.CachedReviewsQty = (SELECT COUNT(*) FROM <%TABLE_PREFIX%>CatalogReviews review_table WHERE review_table.ItemId = main_table.ResourceId); + +# ===== v 5.2.0-B3 ===== + +# ===== v 5.2.0-RC1 ===== + +# ===== v 5.2.0 ===== +INSERT INTO Permissions VALUES(DEFAULT, 'in-news:configuration_output.add', 11, 1, 1, 0); + +# ===== v 5.2.1-B1 ===== +UPDATE SystemSettings +SET DisplayOrder = 20.04 +WHERE VariableName = 'Perpage_NewsReviews'; + +# ===== v 5.2.1-B2 ===== +UPDATE Modules +SET ClassNamespace = 'Intechnic\\InPortal\\Modules\\InNews' +WHERE `Name` = 'In-News'; + +# ===== v 5.2.1-RC1 ===== + +# ===== v 5.2.1 ===== + +# ===== v 5.2.2-B1 ===== + +# ===== v 5.2.2-B2 ===== +UPDATE Modules +SET ClassNamespace = 'InPortal\\Modules\\InNews' +WHERE `Name` = 'In-News'; + +# ===== v 5.3.0-B1 ===== +# Backported in http://jira.in-portal.org/browse/INP-1690. +# UPDATE Modules +# SET ClassNamespace = 'InPortal\\Modules\\InNews' +# WHERE `Name` = 'In-News'; + +INSERT INTO SearchConfig VALUES ('News', 'MetaKeywords', 0, 1, '', 'lc_field_MetaKeywords', 'In-News', 'la_text_article', 27, DEFAULT, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL); +INSERT INTO SearchConfig VALUES ('News', 'MetaDescription', 0, 1, '', 'lc_field_MetaDescription', 'In-News', 'la_text_article', 28, DEFAULT, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL);