Index: branches/5.2.x/core/install/upgrades.sql
===================================================================
diff -u -N -r14840 -r14853
--- branches/5.2.x/core/install/upgrades.sql	(.../upgrades.sql)	(revision 14840)
+++ branches/5.2.x/core/install/upgrades.sql	(.../upgrades.sql)	(revision 14853)
@@ -2301,4 +2301,43 @@
 	'LA_SECTION_SETTINGSCACHING', 'LA_CONFIG_CACHEHANDLER', 'LA_CONFIG_MEMCACHESERVERS', 'LA_HINT_MEMCACHESERVERS'
 );
 
-DELETE FROM ConfigurationValues WHERE VariableName IN ('CacheHandler', 'MemcacheServers');
\ No newline at end of file
+DELETE FROM ConfigurationValues WHERE VariableName IN ('CacheHandler', 'MemcacheServers');
+
+CREATE TABLE PromoBlocks (
+  BlockId int(11) NOT NULL AUTO_INCREMENT,
+  Title varchar(50) NOT NULL DEFAULT '',
+  Priority int(11) NOT NULL DEFAULT '0',
+  Status tinyint(1) NOT NULL DEFAULT '0',
+  l1_Image varchar(255) NOT NULL DEFAULT '',
+  l2_Image varchar(255) NOT NULL DEFAULT '',
+  l3_Image varchar(255) NOT NULL DEFAULT '',
+  l4_Image varchar(255) NOT NULL DEFAULT '',
+  l5_Image varchar(255) NOT NULL DEFAULT '',
+  CSSClassName varchar(255) NOT NULL DEFAULT '',
+  LinkType tinyint(1) NOT NULL DEFAULT '1',
+  CategoryId int(11) NOT NULL DEFAULT '0',
+  ExternalLink varchar(255) NOT NULL DEFAULT '',
+  OpenInNewWindow tinyint(3) unsigned NOT NULL DEFAULT '0',
+  ScheduleFromDate int(11) DEFAULT NULL,
+  ScheduleToDate int(11) DEFAULT NULL,
+  NumberOfClicks int(11) NOT NULL DEFAULT '0',
+  NumberOfViews int(11) NOT NULL DEFAULT '0',
+  Sticky tinyint(1) NOT NULL DEFAULT '0',
+  Html text,
+  l1_Html text,
+  l2_Html text,
+  l3_Html text,
+  l4_Html text,
+  l5_Html text,
+  PRIMARY KEY (BlockId),
+  KEY OpenInNewWindow (OpenInNewWindow)
+);
+
+INSERT INTO ConfigurationValues VALUES (DEFAULT, 'PromoRotationDelay', '7', 'In-Portal', 'in-portal:configure_promo_blocks', 'la_Text_PromoSettings', 'la_config_PromoRotationDelay', 'text', '', '', 10.01, 0, 0, NULL);
+INSERT INTO ConfigurationValues VALUES (DEFAULT, 'PromoTransitionTime', '0.6', 'In-Portal', 'in-portal:configure_promo_blocks', 'la_Text_PromoSettings', 'la_config_PromoTransitionTime', 'text', '', '', 10.02, 0, 0, NULL);
+INSERT INTO ConfigurationValues VALUES (DEFAULT, 'PromoTransitionControls', '1', 'In-Portal', 'in-portal:configure_promo_blocks', 'la_Text_PromoSettings', 'la_config_PromoTransitionControls', 'select', '', '1=la_Enabled||0=la_Disabled', 10.03, 0, 0, NULL);
+INSERT INTO ConfigurationValues VALUES (DEFAULT, 'PromoTransitionEffect', 'fade', 'In-Portal', 'in-portal:configure_promo_blocks', 'la_Text_PromoSettings', 'la_config_PromoTransitionEffect', 'select', '', 'fade=la_opt_AnimationFade||slide=la_opt_AnimationSlide', 10.04, 0, 0, NULL);
+
+UPDATE Phrase
+SET l<%PRIMARY_LANGUAGE%>_ColumnTranslation = l<%PRIMARY_LANGUAGE%>_Translation
+WHERE PhraseKey IN ('LA_FLD_CATEGORY', 'LA_FLD_ORDER');
\ No newline at end of file