Last active
August 29, 2015 14:16
-
-
Save renekreijveld/68aed38358087595f29b to your computer and use it in GitHub Desktop.
Joomla database update 2.5.x to 3.3.6
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- Upgrade Joomla 2.5.7 database to Joomla 3.3.6 database | |
| -- Written by: Rene Kreijveld | |
| -- | |
| -- This script is provided "as is", without any accompanying services or warranties from Rene Kreijveld. | |
| -- | |
| -- Please read these instructions carefully! | |
| -- Before you de ANY update, migration or modification, make sure you have a working backup of your website(s)! | |
| -- | |
| -- To use this script do the following: | |
| -- | |
| -- Uninstall all additional extensions in your Joomla 2.5.x website (backup first!). | |
| -- From your 2.5.x database dump the following tables to a file with phpMyAdmin: | |
| -- | |
| -- #__assets | |
| -- #__associations | |
| -- #__banner_clients | |
| -- #__banner_tracks | |
| -- #__banners | |
| -- #__categories | |
| -- #__contact_details | |
| -- #__content | |
| -- #__content_frontpage | |
| -- #__content_rating | |
| -- #__core_log_searches | |
| -- #__extensions | |
| -- #__finder_filters | |
| -- #__finder_links | |
| -- #__finder_links_terms0 | |
| -- #__finder_links_terms1 | |
| -- #__finder_links_terms2 | |
| -- #__finder_links_terms3 | |
| -- #__finder_links_terms4 | |
| -- #__finder_links_terms5 | |
| -- #__finder_links_terms6 | |
| -- #__finder_links_terms7 | |
| -- #__finder_links_terms8 | |
| -- #__finder_links_terms9 | |
| -- #__finder_links_termsa | |
| -- #__finder_links_termsb | |
| -- #__finder_links_termsc | |
| -- #__finder_links_termsd | |
| -- #__finder_links_termse | |
| -- #__finder_links_termsf | |
| -- #__finder_taxonomy | |
| -- #__finder_taxonomy_map | |
| -- #__finder_terms | |
| -- #__finder_terms_common | |
| -- #__finder_tokens_aggregate | |
| -- #__finder_types | |
| -- #__languages | |
| -- #__menu | |
| -- #__menu_types | |
| -- #__messages | |
| -- #__messages_cfg | |
| -- #__modules | |
| -- #__modules_menu | |
| -- #__newsfeeds | |
| -- #__overrider | |
| -- #__redirect_links | |
| -- #__schemas | |
| -- #__session | |
| -- #__template_styles | |
| -- #__update_sites | |
| -- #__update_sites_extensions | |
| -- #__updates | |
| -- #__user_notes | |
| -- #__user_profiles | |
| -- #__user_usergroup_map | |
| -- #__usergroups | |
| -- #__users | |
| -- #__viewlevels | |
| -- #__weblinks | |
| -- | |
| -- Make sure you select the following options in phpMyAdmin next to the default options: | |
| -- | |
| -- Export Method: custom | |
| -- Tables: see above | |
| -- Output: Save output to a file | |
| -- Object creation options: select Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT / TRIGGER statement | |
| -- Data creation options: neither of the above [Example: INSERT INTO tbl_name VALUES (1,2,3)] | |
| -- | |
| -- Next install a clean Joomla 3.3.6 with NO example content installed. | |
| -- Make a backup of your fresh and clean Joomla 3.3.6 website. | |
| -- | |
| -- In the database dump of your 2.5.x database, replace all occurances of the old table prefix | |
| -- with the new table prefix of the 3.3.6 database. Then import the 2.5.x dump into your 3.3.6 database. | |
| -- | |
| -- In this file replace "yourtableprefix_" with the new table prefix of the 3.3.6 database. | |
| -- Import this script into your 3.3.6 database. | |
| -- 3.0.0 | |
| ALTER TABLE `yourtableprefix_users` DROP KEY `usertype`; | |
| ALTER TABLE `yourtableprefix_session` DROP KEY `whosonline`; | |
| DROP TABLE IF EXISTS `yourtableprefix_update_categories`; | |
| ALTER TABLE `yourtableprefix_contact_details` DROP `imagepos`; | |
| ALTER TABLE `yourtableprefix_content` DROP COLUMN `title_alias`; | |
| ALTER TABLE `yourtableprefix_content` DROP COLUMN `sectionid`; | |
| ALTER TABLE `yourtableprefix_content` DROP COLUMN `mask`; | |
| ALTER TABLE `yourtableprefix_content` DROP COLUMN `parentid`; | |
| ALTER TABLE `yourtableprefix_newsfeeds` DROP COLUMN `filename`; | |
| ALTER TABLE `yourtableprefix_weblinks` DROP COLUMN `sid`; | |
| ALTER TABLE `yourtableprefix_weblinks` DROP COLUMN `date`; | |
| ALTER TABLE `yourtableprefix_weblinks` DROP COLUMN `archived`; | |
| ALTER TABLE `yourtableprefix_weblinks` DROP COLUMN `approved`; | |
| ALTER TABLE `yourtableprefix_session` DROP COLUMN `usertype`; | |
| ALTER TABLE `yourtableprefix_users` DROP COLUMN `usertype`; | |
| ALTER TABLE `yourtableprefix_updates` DROP COLUMN `categoryid`; | |
| UPDATE `yourtableprefix_extensions` SET protected = 0 WHERE | |
| `name` = 'com_search' OR | |
| `name` = 'mod_articles_archive' OR | |
| `name` = 'mod_articles_latest' OR | |
| `name` = 'mod_banners' OR | |
| `name` = 'mod_feed' OR | |
| `name` = 'mod_footer' OR | |
| `name` = 'mod_users_latest' OR | |
| `name` = 'mod_articles_category' OR | |
| `name` = 'mod_articles_categories' OR | |
| `name` = 'plg_content_pagebreak' OR | |
| `name` = 'plg_content_pagenavigation' OR | |
| `name` = 'plg_content_vote' OR | |
| `name` = 'plg_editors_tinymce' OR | |
| `name` = 'plg_system_p3p' OR | |
| `name` = 'plg_user_contactcreator' OR | |
| `name` = 'plg_user_profile'; | |
| DELETE FROM `yourtableprefix_extensions` WHERE `extension_id` = 800; | |
| ALTER TABLE `yourtableprefix_assets` ENGINE=InnoDB; | |
| ALTER TABLE `yourtableprefix_associations` ENGINE=InnoDB; | |
| ALTER TABLE `yourtableprefix_banners` ENGINE=InnoDB; | |
| ALTER TABLE `yourtableprefix_banner_clients` ENGINE=InnoDB; | |
| ALTER TABLE `yourtableprefix_banner_tracks` ENGINE=InnoDB; | |
| ALTER TABLE `yourtableprefix_categories` ENGINE=InnoDB; | |
| ALTER TABLE `yourtableprefix_contact_details` ENGINE=InnoDB; | |
| ALTER TABLE `yourtableprefix_content` ENGINE=InnoDB; | |
| ALTER TABLE `yourtableprefix_content_frontpage` ENGINE=InnoDB; | |
| ALTER TABLE `yourtableprefix_content_rating` ENGINE=InnoDB; | |
| ALTER TABLE `yourtableprefix_core_log_searches` ENGINE=InnoDB; | |
| ALTER TABLE `yourtableprefix_extensions` ENGINE=InnoDB; | |
| ALTER TABLE `yourtableprefix_finder_filters` ENGINE=InnoDB; | |
| ALTER TABLE `yourtableprefix_finder_links` ENGINE=InnoDB; | |
| ALTER TABLE `yourtableprefix_finder_links_terms0` ENGINE=InnoDB; | |
| ALTER TABLE `yourtableprefix_finder_links_terms1` ENGINE=InnoDB; | |
| ALTER TABLE `yourtableprefix_finder_links_terms2` ENGINE=InnoDB; | |
| ALTER TABLE `yourtableprefix_finder_links_terms3` ENGINE=InnoDB; | |
| ALTER TABLE `yourtableprefix_finder_links_terms4` ENGINE=InnoDB; | |
| ALTER TABLE `yourtableprefix_finder_links_terms5` ENGINE=InnoDB; | |
| ALTER TABLE `yourtableprefix_finder_links_terms6` ENGINE=InnoDB; | |
| ALTER TABLE `yourtableprefix_finder_links_terms7` ENGINE=InnoDB; | |
| ALTER TABLE `yourtableprefix_finder_links_terms8` ENGINE=InnoDB; | |
| ALTER TABLE `yourtableprefix_finder_links_terms9` ENGINE=InnoDB; | |
| ALTER TABLE `yourtableprefix_finder_links_termsa` ENGINE=InnoDB; | |
| ALTER TABLE `yourtableprefix_finder_links_termsb` ENGINE=InnoDB; | |
| ALTER TABLE `yourtableprefix_finder_links_termsc` ENGINE=InnoDB; | |
| ALTER TABLE `yourtableprefix_finder_links_termsd` ENGINE=InnoDB; | |
| ALTER TABLE `yourtableprefix_finder_links_termse` ENGINE=InnoDB; | |
| ALTER TABLE `yourtableprefix_finder_links_termsf` ENGINE=InnoDB; | |
| ALTER TABLE `yourtableprefix_finder_taxonomy` ENGINE=InnoDB; | |
| ALTER TABLE `yourtableprefix_finder_taxonomy_map` ENGINE=InnoDB; | |
| ALTER TABLE `yourtableprefix_finder_terms` ENGINE=InnoDB; | |
| ALTER TABLE `yourtableprefix_finder_terms_common` ENGINE=InnoDB; | |
| ALTER TABLE `yourtableprefix_finder_types` ENGINE=InnoDB; | |
| ALTER TABLE `yourtableprefix_languages` ENGINE=InnoDB; | |
| ALTER TABLE `yourtableprefix_menu` ENGINE=InnoDB; | |
| ALTER TABLE `yourtableprefix_menu_types` ENGINE=InnoDB; | |
| ALTER TABLE `yourtableprefix_messages` ENGINE=InnoDB; | |
| ALTER TABLE `yourtableprefix_messages_cfg` ENGINE=InnoDB; | |
| ALTER TABLE `yourtableprefix_modules` ENGINE=InnoDB; | |
| ALTER TABLE `yourtableprefix_modules_menu` ENGINE=InnoDB; | |
| ALTER TABLE `yourtableprefix_newsfeeds` ENGINE=InnoDB; | |
| ALTER TABLE `yourtableprefix_overrider` ENGINE=InnoDB; | |
| ALTER TABLE `yourtableprefix_redirect_links` ENGINE=InnoDB; | |
| ALTER TABLE `yourtableprefix_schemas` ENGINE=InnoDB; | |
| ALTER TABLE `yourtableprefix_session` ENGINE=InnoDB; | |
| ALTER TABLE `yourtableprefix_template_styles` ENGINE=InnoDB; | |
| ALTER TABLE `yourtableprefix_updates` ENGINE=InnoDB; | |
| ALTER TABLE `yourtableprefix_update_sites` ENGINE=InnoDB; | |
| ALTER TABLE `yourtableprefix_update_sites_extensions` ENGINE=InnoDB; | |
| ALTER TABLE `yourtableprefix_users` ENGINE=InnoDB; | |
| ALTER TABLE `yourtableprefix_usergroups` ENGINE=InnoDB; | |
| ALTER TABLE `yourtableprefix_user_notes` ENGINE=InnoDB; | |
| ALTER TABLE `yourtableprefix_user_profiles` ENGINE=InnoDB; | |
| ALTER TABLE `yourtableprefix_user_usergroup_map` ENGINE=InnoDB; | |
| ALTER TABLE `yourtableprefix_viewlevels` ENGINE=InnoDB; | |
| ALTER TABLE `yourtableprefix_weblinks` ENGINE=InnoDB; | |
| ALTER TABLE `yourtableprefix_weblinks` ADD COLUMN `version` int(10) unsigned NOT NULL DEFAULT '1'; | |
| ALTER TABLE `yourtableprefix_weblinks` ADD COLUMN `images` text NOT NULL; | |
| ALTER TABLE `yourtableprefix_newsfeeds` ADD COLUMN `description` text NOT NULL; | |
| ALTER TABLE `yourtableprefix_newsfeeds` ADD COLUMN `version` int(10) unsigned NOT NULL DEFAULT '1'; | |
| ALTER TABLE `yourtableprefix_newsfeeds` ADD COLUMN `hits` int(10) unsigned NOT NULL DEFAULT '0'; | |
| ALTER TABLE `yourtableprefix_newsfeeds` ADD COLUMN `images` text NOT NULL; | |
| ALTER TABLE `yourtableprefix_contact_details` ADD COLUMN `version` int(10) unsigned NOT NULL DEFAULT '1'; | |
| ALTER TABLE `yourtableprefix_contact_details` ADD COLUMN `hits` int(10) unsigned NOT NULL DEFAULT '0'; | |
| ALTER TABLE `yourtableprefix_banners` ADD COLUMN `created_by` int(10) unsigned NOT NULL DEFAULT '0'; | |
| ALTER TABLE `yourtableprefix_banners` ADD COLUMN `created_by_alias` varchar(255) NOT NULL DEFAULT ''; | |
| ALTER TABLE `yourtableprefix_banners` ADD COLUMN `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00'; | |
| ALTER TABLE `yourtableprefix_banners` ADD COLUMN `modified_by` int(10) unsigned NOT NULL DEFAULT '0'; | |
| ALTER TABLE `yourtableprefix_banners` ADD COLUMN `version` int(10) unsigned NOT NULL DEFAULT '1'; | |
| ALTER TABLE `yourtableprefix_categories` ADD COLUMN `version` int(10) unsigned NOT NULL DEFAULT '1'; | |
| UPDATE `yourtableprefix_assets` SET name=REPLACE( name, 'com_user.notes.category','com_users.category' ); | |
| UPDATE `yourtableprefix_categories` SET extension=REPLACE( extension, 'com_user.notes.category','com_users.category' ); | |
| ALTER TABLE `yourtableprefix_finder_terms` ADD COLUMN `language` char(3) NOT NULL DEFAULT ''; | |
| ALTER TABLE `yourtableprefix_finder_tokens` ADD COLUMN `language` char(3) NOT NULL DEFAULT ''; | |
| ALTER TABLE `yourtableprefix_finder_tokens_aggregate` ADD COLUMN `language` char(3) NOT NULL DEFAULT ''; | |
| INSERT INTO `yourtableprefix_extensions` | |
| (`name`, `type`, `element`, `folder`, `client_id`, `enabled`, `access`, `protected`, `manifest_cache`, `params`, `custom_data`, `system_data`, `checked_out`, `checked_out_time`, `ordering`, `state`) | |
| VALUES | |
| ('isis', 'template', 'isis', '', 1, 1, 1, 0, '{"name":"isis","type":"template","creationDate":"3\\/30\\/2012","author":"Kyle Ledbetter","copyright":"Copyright (C) 2005 - 2012 Open Source Matters, Inc. All rights reserved.","authorEmail":"admin@joomla.org","authorUrl":"","version":"1.0","description":"TPL_ISIS_XML_DESCRIPTION","group":""}', '{"templateColor":"","logoFile":""}', '', '', 0, '0000-00-00 00:00:00', 0, 0), | |
| ('protostar', 'template', 'protostar', '', 0, 1, 1, 0, '{"name":"protostar","type":"template","creationDate":"4\\/30\\/2012","author":"Kyle Ledbetter","copyright":"Copyright (C) 2005 - 2012 Open Source Matters, Inc. All rights reserved.","authorEmail":"admin@joomla.org","authorUrl":"","version":"1.0","description":"TPL_PROTOSTAR_XML_DESCRIPTION","group":""}', '{"templateColor":"","logoFile":"","googleFont":"1","googleFontName":"Open+Sans","fluidContainer":"0"}', '', '', 0, '0000-00-00 00:00:00', 0, 0), | |
| ('beez3', 'template', 'beez3', '', 0, 1, 1, 0, '{"legacy":false,"name":"beez3","type":"template","creationDate":"25 November 2009","author":"Angie Radtke","copyright":"Copyright (C) 2005 - 2012 Open Source Matters, Inc. All rights reserved.","authorEmail":"a.radtke@derauftritt.de","authorUrl":"http:\\/\\/www.der-auftritt.de","version":"1.6.0","description":"TPL_BEEZ3_XML_DESCRIPTION","group":""}', '{"wrapperSmall":"53","wrapperLarge":"72","sitetitle":"","sitedescription":"","navposition":"center","templatecolor":"nature"}', '', '', 0, '0000-00-00 00:00:00', 0, 0); | |
| INSERT INTO `yourtableprefix_template_styles` (`template`, `client_id`, `home`, `title`, `params`) VALUES | |
| ('protostar', 0, '0', 'protostar - Default', '{"templateColor":"","logoFile":"","googleFont":"1","googleFontName":"Open+Sans","fluidContainer":"0"}'), | |
| ('isis', 1, '1', 'isis - Default', '{"templateColor":"","logoFile":""}'), | |
| ('beez3', 0, '0', 'beez3 - Default', '{"wrapperSmall":53,"wrapperLarge":72,"logo":"","sitetitle":"","sitedescription":"","navposition":"center","bootstrap":"","templatecolor":"nature","headerImage":"","backgroundcolor":"#eee"}'); | |
| UPDATE `yourtableprefix_template_styles` | |
| SET home = (CASE WHEN (SELECT count FROM (SELECT count(`id`) AS count | |
| FROM `yourtableprefix_template_styles` | |
| WHERE home = '1' | |
| AND client_id = 1) as c) = 0 | |
| THEN '1' | |
| ELSE '0' | |
| END) | |
| WHERE template = 'isis' | |
| AND home != '1'; | |
| UPDATE `yourtableprefix_template_styles` | |
| SET home = 0 | |
| WHERE template = 'bluestork'; | |
| INSERT INTO `yourtableprefix_extensions` (`extension_id`, `name`, `type`, `element`, `folder`, `client_id`, `enabled`, `access`, `protected`, `manifest_cache`, `params`, `custom_data`, `system_data`, `checked_out`, `checked_out_time`, `ordering`, `state`) VALUES | |
| (315, 'mod_stats_admin', 'module', 'mod_stats_admin', '', 1, 1, 1, 0, '{"name":"mod_stats_admin","type":"module","creationDate":"September 2012","author":"Joomla! Project","copyright":"Copyright (C) 2005 - 2012 Open Source Matters. All rights reserved.","authorEmail":"admin@joomla.org","authorUrl":"www.joomla.org","version":"3.0.0","description":"MOD_STATS_XML_DESCRIPTION","group":""}', '{"serverinfo":"0","siteinfo":"0","counter":"0","increase":"0","cache":"1","cache_time":"900","cachemode":"static"}', '', '', 0, '0000-00-00 00:00:00', 0, 0); | |
| UPDATE `yourtableprefix_update_sites` | |
| SET location = 'http://update.joomla.org/language/translationlist_3.xml' | |
| WHERE location = 'http://update.joomla.org/language/translationlist.xml' | |
| AND name = 'Accredited Joomla! Translations'; | |
| ALTER TABLE `yourtableprefix_associations` CHANGE `id` `id` INT(11) NOT NULL COMMENT 'A reference to the associated item.'; | |
| -- 3.1.0 | |
| -- | |
| -- Table structure for table `yourtableprefix_content_types` | |
| -- | |
| INSERT INTO `yourtableprefix_extensions` (`extension_id`, `name`, `type`, `element`, `folder`, `client_id`, `enabled`, `access`, `protected`, `manifest_cache`, `params`, `custom_data`, `system_data`, `checked_out`, `checked_out_time`, `ordering`, `state`) VALUES | |
| (29, 'com_tags', 'component', 'com_tags', '', 1, 1, 1, 1, '{"legacy":false,"name":"com_tags","type":"component","creationDate":"March 2013","author":"Joomla! Project","copyright":"(C) 2005 - 2014 Open Source Matters. All rights reserved.","authorEmail":"admin@joomla.org","authorUrl":"www.joomla.org","version":"3.0.0","description":"COM_TAGS_XML_DESCRIPTION","group":""}', '{}', '', '', 0, '0000-00-00 00:00:00', 0, 0), | |
| (316, 'mod_tags_popular', 'module', 'mod_tags_popular', '', 0, 1, 1, 0, '{"name":"mod_tags_popular","type":"module","creationDate":"January 2013","author":"Joomla! Project","copyright":"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.","authorEmail":"admin@joomla.org","authorUrl":"www.joomla.org","version":"3.1.0","description":"MOD_TAGS_POPULAR_XML_DESCRIPTION","group":""}', '{"maximum":"5","timeframe":"alltime","owncache":"1"}', '', '', 0, '0000-00-00 00:00:00', 0, 0), | |
| (317, 'mod_tags_similar', 'module', 'mod_tags_similar', '', 0, 1, 1, 0, '{"name":"mod_tags_similar","type":"module","creationDate":"January 2013","author":"Joomla! Project","copyright":"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.","authorEmail":"admin@joomla.org","authorUrl":"www.joomla.org","version":"3.1.0","description":"MOD_TAGS_SIMILAR_XML_DESCRIPTION","group":""}', '{"maximum":"5","matchtype":"any","owncache":"1"}', '', '', 0, '0000-00-00 00:00:00', 0, 0), | |
| (447, 'plg_finder_tags', 'plugin', 'tags', 'finder', 0, 1, 1, 0, '{"name":"plg_finder_tags","type":"plugin","creationDate":"February 2013","author":"Joomla! Project","copyright":"(C) 2005 - 2014 Open Source Matters. All rights reserved.","authorEmail":"admin@joomla.org","authorUrl":"www.joomla.org","version":"3.0.0","description":"PLG_FINDER_TAGS_XML_DESCRIPTION","group":""}', '{}', '', '', 0, '0000-00-00 00:00:00', 0, 0); | |
| INSERT INTO `yourtableprefix_menu` (`menutype`, `title`, `alias`, `note`, `path`, `link`, `type`, `published`, `parent_id`, `level`, `component_id`, `checked_out`, `checked_out_time`, `browserNav`, `access`, `img`, `template_style_id`, `params`, `lft`, `rgt`, `home`, `language`, `client_id`) VALUES | |
| ('main', 'com_tags', 'Tags', '', 'Tags', 'index.php?option=com_tags', 'component', 0, 1, 1, 29, 0, '0000-00-00 00:00:00', 0, 1, 'class:tags', 0, '', 45, 46, 0, '', 1); | |
| -- 3.1.2 | |
| UPDATE `yourtableprefix_content_types` SET `table` = '{"special":{"dbtable":"#__content","key":"id","type":"Content","prefix":"JTable","config":"array()"},"common":{"dbtable":"#__ucm_content","key":"ucm_id","type":"Corecontent","prefix":"JTable","config":"array()"}}' WHERE `type_title` = 'Article'; | |
| UPDATE `yourtableprefix_content_types` SET `table` = '{"special":{"dbtable":"#__weblinks","key":"id","type":"Weblink","prefix":"WeblinksTable","config":"array()"},"common":{"dbtable":"#__ucm_content","key":"ucm_id","type":"Corecontent","prefix":"JTable","config":"array()"}}' WHERE `type_title` = 'Weblink'; | |
| UPDATE `yourtableprefix_content_types` SET `table` = '{"special":{"dbtable":"#__contact_details","key":"id","type":"Contact","prefix":"ContactTable","config":"array()"},"common":{"dbtable":"#__ucm_content","key":"ucm_id","type":"Corecontent","prefix":"JTable","config":"array()"}}' WHERE `type_title` = 'Contact'; | |
| UPDATE `yourtableprefix_content_types` SET `table` = '{"special":{"dbtable":"#__newsfeeds","key":"id","type":"Newsfeed","prefix":"NewsfeedsTable","config":"array()"},"common":{"dbtable":"#__ucm_content","key":"ucm_id","type":"Corecontent","prefix":"JTable","config":"array()"}}' WHERE `type_title` = 'Newsfeed'; | |
| UPDATE `yourtableprefix_content_types` SET `table` = '{"special":{"dbtable":"#__users","key":"id","type":"User","prefix":"JTable","config":"array()"},"common":{"dbtable":"#__ucm_content","key":"ucm_id","type":"Corecontent","prefix":"JTable","config":"array()"}}' WHERE `type_title` = 'User'; | |
| UPDATE `yourtableprefix_content_types` SET `table` = '{"special":{"dbtable":"#__categories","key":"id","type":"Category","prefix":"JTable","config":"array()"},"common":{"dbtable":"#__ucm_content","key":"ucm_id","type":"Corecontent","prefix":"JTable","config":"array()"}}' WHERE `type_title` = 'Article Category'; | |
| UPDATE `yourtableprefix_content_types` SET `table` = '{"special":{"dbtable":"#__categories","key":"id","type":"Category","prefix":"JTable","config":"array()"},"common":{"dbtable":"#__ucm_content","key":"ucm_id","type":"Corecontent","prefix":"JTable","config":"array()"}}' WHERE `type_title` = 'Contact Category'; | |
| UPDATE `yourtableprefix_content_types` SET `table` = '{"special":{"dbtable":"#__categories","key":"id","type":"Category","prefix":"JTable","config":"array()"},"common":{"dbtable":"#__ucm_content","key":"ucm_id","type":"Corecontent","prefix":"JTable","config":"array()"}}' WHERE `type_title` = 'Newsfeeds Category'; | |
| UPDATE `yourtableprefix_content_types` SET `table` = '{"special":{"dbtable":"#__categories","key":"id","type":"Category","prefix":"JTable","config":"array()"},"common":{"dbtable":"#__ucm_content","key":"ucm_id","type":"Corecontent","prefix":"JTable","config":"array()"}}' WHERE `type_title` = 'Weblinks Category'; | |
| UPDATE `yourtableprefix_content_types` SET `table` = '{"special":{"dbtable":"#__tags","key":"tag_id","type":"Tag","prefix":"TagsTable","config":"array()"},"common":{"dbtable":"#__ucm_content","key":"ucm_id","type":"Corecontent","prefix":"JTable","config":"array()"}}' WHERE `type_title` = 'Tag'; | |
| UPDATE `yourtableprefix_content_types` SET `field_mappings` = '{"common":{"core_content_item_id":"id","core_title":"title","core_state":"state","core_alias":"alias","core_created_time":"created","core_modified_time":"modified","core_body":"introtext", "core_hits":"hits","core_publish_up":"publish_up","core_publish_down":"publish_down","core_access":"access", "core_params":"attribs", "core_featured":"featured", "core_metadata":"metadata", "core_language":"language", "core_images":"images", "core_urls":"urls", "core_version":"version", "core_ordering":"ordering", "core_metakey":"metakey", "core_metadesc":"metadesc", "core_catid":"catid", "core_xreference":"xreference", "asset_id":"asset_id"}, "special": {"fulltext":"fulltext"}}' WHERE `type_id` = '1'; | |
| UPDATE `yourtableprefix_content_types` SET `field_mappings` = '{"common":{"core_content_item_id":"id","core_title":"title","core_state":"state","core_alias":"alias","core_created_time":"created","core_modified_time":"modified","core_body":"description", "core_hits":"hits","core_publish_up":"publish_up","core_publish_down":"publish_down","core_access":"access", "core_params":"params", "core_featured":"featured", "core_metadata":"metadata", "core_language":"language", "core_images":"images", "core_urls":"url", "core_version":"version", "core_ordering":"ordering", "core_metakey":"metakey", "core_metadesc":"metadesc", "core_catid":"catid", "core_xreference":"xreference", "asset_id":"null"}, "special": {}}' WHERE `type_id` = '2'; | |
| UPDATE `yourtableprefix_content_types` SET `field_mappings` = '{"common":{"core_content_item_id":"id","core_title":"name","core_state":"published","core_alias":"alias","core_created_time":"created","core_modified_time":"modified","core_body":"address", "core_hits":"hits","core_publish_up":"publish_up","core_publish_down":"publish_down","core_access":"access", "core_params":"params", "core_featured":"featured", "core_metadata":"metadata", "core_language":"language", "core_images":"image", "core_urls":"webpage", "core_version":"version", "core_ordering":"ordering", "core_metakey":"metakey", "core_metadesc":"metadesc", "core_catid":"catid", "core_xreference":"xreference", "asset_id":"null"}, "special": {"con_position":"con_position","suburb":"suburb","state":"state","country":"country","postcode":"postcode","telephone":"telephone","fax":"fax","misc":"misc","email_to":"email_to","default_con":"default_con","user_id":"user_id","mobile":"mobile","sortname1":"sortname1","sortname2":"sortname2","sortname3":"sortname3"}}' WHERE `type_id` = '3'; | |
| UPDATE `yourtableprefix_content_types` SET `field_mappings` = '{"common":{"core_content_item_id":"id","core_title":"name","core_state":"published","core_alias":"alias","core_created_time":"created","core_modified_time":"modified","core_body":"description", "core_hits":"hits","core_publish_up":"publish_up","core_publish_down":"publish_down","core_access":"access", "core_params":"params", "core_featured":"featured", "core_metadata":"metadata", "core_language":"language", "core_images":"images", "core_urls":"link", "core_version":"version", "core_ordering":"ordering", "core_metakey":"metakey", "core_metadesc":"metadesc", "core_catid":"catid", "core_xreference":"xreference", "asset_id":"null"}, "special": {"numarticles":"numarticles","cache_time":"cache_time","rtl":"rtl"}}' WHERE `type_id` = '4'; | |
| UPDATE `yourtableprefix_content_types` SET `field_mappings` = '{"common":{"core_content_item_id":"id","core_title":"name","core_state":"null","core_alias":"username","core_created_time":"registerdate","core_modified_time":"lastvisitDate","core_body":"null", "core_hits":"null","core_publish_up":"null","core_publish_down":"null","access":"null", "core_params":"params", "core_featured":"null", "core_metadata":"null", "core_language":"null", "core_images":"null", "core_urls":"null", "core_version":"null", "core_ordering":"null", "core_metakey":"null", "core_metadesc":"null", "core_catid":"null", "core_xreference":"null", "asset_id":"null"}, "special": {}}' WHERE `type_id` = '5'; | |
| UPDATE `yourtableprefix_content_types` SET `field_mappings` = '{"common":{"core_content_item_id":"id","core_title":"title","core_state":"published","core_alias":"alias","core_created_time":"created_time","core_modified_time":"modified_time","core_body":"description", "core_hits":"hits","core_publish_up":"null","core_publish_down":"null","core_access":"access", "core_params":"params", "core_featured":"null", "core_metadata":"metadata", "core_language":"language", "core_images":"null", "core_urls":"null", "core_version":"version", "core_ordering":"null", "core_metakey":"metakey", "core_metadesc":"metadesc", "core_catid":"parent_id", "core_xreference":"null", "asset_id":"asset_id"}, "special": {"parent_id":"parent_id","lft":"lft","rgt":"rgt","level":"level","path":"path","extension":"extension","note":"note"}}' WHERE `type_id` = '6'; | |
| UPDATE `yourtableprefix_content_types` SET `field_mappings` = '{"common":{"core_content_item_id":"id","core_title":"title","core_state":"published","core_alias":"alias","core_created_time":"created_time","core_modified_time":"modified_time","core_body":"description", "core_hits":"hits","core_publish_up":"null","core_publish_down":"null","core_access":"access", "core_params":"params", "core_featured":"null", "core_metadata":"metadata", "core_language":"language", "core_images":"null", "core_urls":"null", "core_version":"version", "core_ordering":"null", "core_metakey":"metakey", "core_metadesc":"metadesc", "core_catid":"parent_id", "core_xreference":"null", "asset_id":"asset_id"}, "special": {"parent_id":"parent_id","lft":"lft","rgt":"rgt","level":"level","path":"path","extension":"extension","note":"note"}}' WHERE `type_id` = '7'; | |
| UPDATE `yourtableprefix_content_types` SET `field_mappings` = '{"common":{"core_content_item_id":"id","core_title":"title","core_state":"published","core_alias":"alias","core_created_time":"created_time","core_modified_time":"modified_time","core_body":"description", "core_hits":"hits","core_publish_up":"null","core_publish_down":"null","core_access":"access", "core_params":"params", "core_featured":"null", "core_metadata":"metadata", "core_language":"language", "core_images":"null", "core_urls":"null", "core_version":"version", "core_ordering":"null", "core_metakey":"metakey", "core_metadesc":"metadesc", "core_catid":"parent_id", "core_xreference":"null", "asset_id":"asset_id"}, "special": {"parent_id":"parent_id","lft":"lft","rgt":"rgt","level":"level","path":"path","extension":"extension","note":"note"}}' WHERE `type_id` = '8'; | |
| UPDATE `yourtableprefix_content_types` SET `field_mappings` = '{"common":{"core_content_item_id":"id","core_title":"title","core_state":"published","core_alias":"alias","core_created_time":"created_time","core_modified_time":"modified_time","core_body":"description", "core_hits":"hits","core_publish_up":"null","core_publish_down":"null","core_access":"access", "core_params":"params", "core_featured":"null", "core_metadata":"metadata", "core_language":"language", "core_images":"null", "core_urls":"null", "core_version":"version", "core_ordering":"null", "core_metakey":"metakey", "core_metadesc":"metadesc", "core_catid":"parent_id", "core_xreference":"null", "asset_id":"asset_id"}, "special": {"parent_id":"parent_id","lft":"lft","rgt":"rgt","level":"level","path":"path","extension":"extension","note":"note"}}' WHERE `type_id` = '9'; | |
| UPDATE `yourtableprefix_content_types` SET `field_mappings` = '{"common":{"core_content_item_id":"id","core_title":"title","core_state":"published","core_alias":"alias","core_created_time":"created_time","core_modified_time":"modified_time","core_body":"description", "core_hits":"hits","core_publish_up":"null","core_publish_down":"null","core_access":"access", "core_params":"params", "core_featured":"featured", "core_metadata":"metadata", "core_language":"language", "core_images":"images", "core_urls":"urls", "core_version":"version", "core_ordering":"null", "core_metakey":"metakey", "core_metadesc":"metadesc", "core_catid":"null", "core_xreference":"null", "asset_id":"null"}, "special": {"parent_id":"parent_id","lft":"lft","rgt":"rgt","level":"level","path":"path"}}' WHERE `type_id` = '10'; | |
| -- 3.1.4 | |
| INSERT INTO `yourtableprefix_extensions` (`extension_id`, `name`, `type`, `element`, `folder`, `client_id`, `enabled`, `access`, `protected`, `manifest_cache`, `params`, `custom_data`, `system_data`, `checked_out`, `checked_out_time`, `ordering`, `state`) VALUES | |
| (104, 'IDNA Convert', 'library', 'idna_convert', '', 0, 1, 1, 1, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0); | |
| -- lovah_2.sql | |
| -- 3.2.0 | |
| /* Core 3.2 schema updates */ | |
| UPDATE `yourtableprefix_content_types` SET `content_history_options` = '{"formFile":"administrator\\/components\\/com_content\\/models\\/forms\\/article.xml", "hideFields":["asset_id","checked_out","checked_out_time","version"],"ignoreChanges":["modified_by", "modified", "checked_out", "checked_out_time", "version", "hits"],"convertToInt":["publish_up", "publish_down", "featured", "ordering"],"displayLookup":[{"sourceColumn":"catid","targetTable":"#__categories","targetColumn":"id","displayColumn":"title"},{"sourceColumn":"created_by","targetTable":"#__users","targetColumn":"id","displayColumn":"name"},{"sourceColumn":"access","targetTable":"#__viewlevels","targetColumn":"id","displayColumn":"title"},{"sourceColumn":"modified_by","targetTable":"#__users","targetColumn":"id","displayColumn":"name"} ]}' WHERE `type_alias` = 'com_content.article'; | |
| UPDATE `yourtableprefix_content_types` SET `content_history_options` = '{"formFile":"administrator\\/components\\/com_contact\\/models\\/forms\\/contact.xml","hideFields":["default_con","checked_out","checked_out_time","version","xreference"],"ignoreChanges":["modified_by", "modified", "checked_out", "checked_out_time", "version", "hits"],"convertToInt":["publish_up", "publish_down", "featured", "ordering"], "displayLookup":[ {"sourceColumn":"created_by","targetTable":"#__users","targetColumn":"id","displayColumn":"name"},{"sourceColumn":"catid","targetTable":"#__categories","targetColumn":"id","displayColumn":"title"},{"sourceColumn":"modified_by","targetTable":"#__users","targetColumn":"id","displayColumn":"name"},{"sourceColumn":"access","targetTable":"#__viewlevels","targetColumn":"id","displayColumn":"title"},{"sourceColumn":"user_id","targetTable":"#__users","targetColumn":"id","displayColumn":"name"} ] }' WHERE `type_alias` = 'com_contact.contact'; | |
| UPDATE `yourtableprefix_content_types` SET `content_history_options` = '{"formFile":"administrator\\/components\\/com_categories\\/models\\/forms\\/category.xml", "hideFields":["asset_id","checked_out","checked_out_time","version","lft","rgt","level","path","extension"], "ignoreChanges":["modified_user_id", "modified_time", "checked_out", "checked_out_time", "version", "hits", "path"],"convertToInt":["publish_up", "publish_down"], "displayLookup":[{"sourceColumn":"created_user_id","targetTable":"#__users","targetColumn":"id","displayColumn":"name"},{"sourceColumn":"access","targetTable":"#__viewlevels","targetColumn":"id","displayColumn":"title"},{"sourceColumn":"modified_user_id","targetTable":"#__users","targetColumn":"id","displayColumn":"name"},{"sourceColumn":"parent_id","targetTable":"#__categories","targetColumn":"id","displayColumn":"title"}]}' WHERE `type_alias` IN ('com_content.category', 'com_contact.category', 'com_newsfeeds.category', 'com_weblinks.category'); | |
| UPDATE `yourtableprefix_content_types` SET `content_history_options` = '{"formFile":"administrator\\/components\\/com_weblinks\\/models\\/forms\\/weblink.xml", "hideFields":["asset_id","checked_out","checked_out_time","version","featured","images"], "ignoreChanges":["modified_by", "modified", "checked_out", "checked_out_time", "version", "hits"], "convertToInt":["publish_up", "publish_down", "featured", "ordering"], "displayLookup":[{"sourceColumn":"catid","targetTable":"#__categories","targetColumn":"id","displayColumn":"title"},{"sourceColumn":"created_by","targetTable":"#__users","targetColumn":"id","displayColumn":"name"},{"sourceColumn":"access","targetTable":"#__viewlevels","targetColumn":"id","displayColumn":"title"},{"sourceColumn":"modified_by","targetTable":"#__users","targetColumn":"id","displayColumn":"name"} ]}' WHERE `type_alias` = 'com_weblinks.weblink'; | |
| UPDATE `yourtableprefix_content_types` SET `content_history_options` = '{"formFile":"administrator\\/components\\/com_newsfeeds\\/models\\/forms\\/newsfeed.xml","hideFields":["asset_id","checked_out","checked_out_time","version"],"ignoreChanges":["modified_by", "modified", "checked_out", "checked_out_time", "version", "hits"],"convertToInt":["publish_up", "publish_down", "featured", "ordering"],"displayLookup":[{"sourceColumn":"catid","targetTable":"#__categories","targetColumn":"id","displayColumn":"title"},{"sourceColumn":"created_by","targetTable":"#__users","targetColumn":"id","displayColumn":"name"},{"sourceColumn":"access","targetTable":"#__viewlevels","targetColumn":"id","displayColumn":"title"},{"sourceColumn":"modified_by","targetTable":"#__users","targetColumn":"id","displayColumn":"name"}]}' WHERE `type_alias` = 'com_newsfeeds.newsfeed'; | |
| UPDATE `yourtableprefix_content_types` SET `content_history_options` = '{"formFile":"administrator\\/components\\/com_tags\\/models\\/forms\\/tag.xml", "hideFields":["checked_out","checked_out_time","version", "lft", "rgt", "level", "path", "urls", "publish_up", "publish_down"],"ignoreChanges":["modified_user_id", "modified_time", "checked_out", "checked_out_time", "version", "hits", "path"],"convertToInt":["publish_up", "publish_down"], "displayLookup":[{"sourceColumn":"created_user_id","targetTable":"#__users","targetColumn":"id","displayColumn":"name"}, {"sourceColumn":"access","targetTable":"#__viewlevels","targetColumn":"id","displayColumn":"title"}, {"sourceColumn":"modified_user_id","targetTable":"#__users","targetColumn":"id","displayColumn":"name"}]}' WHERE `type_alias` = 'com_tags.tag'; | |
| UPDATE `yourtableprefix_extensions` SET `params` = '{"template_positions_display":"0","upload_limit":"2","image_formats":"gif,bmp,jpg,jpeg,png","source_formats":"txt,less,ini,xml,js,php,css","font_formats":"woff,ttf,otf","compressed_formats":"zip"}' WHERE `extension_id` = 20; | |
| UPDATE `yourtableprefix_extensions` SET `params` = '{"lineNumbers":"1","lineWrapping":"1","matchTags":"1","matchBrackets":"1","marker-gutter":"1","autoCloseTags":"1","autoCloseBrackets":"1","autoFocus":"1","theme":"default","tabmode":"indent"}' WHERE `extension_id` = 410; | |
| INSERT INTO `yourtableprefix_extensions` (`extension_id`, `name`, `type`, `element`, `folder`, `client_id`, `enabled`, `access`, `protected`, `manifest_cache`, `params`, `custom_data`, `system_data`, `checked_out`, `checked_out_time`, `ordering`, `state`) VALUES | |
| (30, 'com_contenthistory', 'component', 'com_contenthistory', '', 1, 1, 1, 0, '{"name":"com_contenthistory","type":"component","creationDate":"May 2013","author":"Joomla! Project","copyright":"(C) 2005 - 2014 Open Source Matters. All rights reserved.\\n\\t","authorEmail":"admin@joomla.org","authorUrl":"www.joomla.org","version":"3.2.0","description":"COM_CONTENTHISTORY_XML_DESCRIPTION","group":""}', '{}', '', '', 0, '0000-00-00 00:00:00', 0, 0), | |
| (31, 'com_ajax', 'component', 'com_ajax', '', 1, 1, 1, 0, '{"name":"com_ajax","type":"component","creationDate":"August 2013","author":"Joomla! Project","copyright":"(C) 2005 - 2014 Open Source Matters. All rights reserved.","authorEmail":"admin@joomla.org","authorUrl":"www.joomla.org","version":"3.2.0","description":"COM_AJAX_DESC","group":""}', '{}', '', '', 0, '0000-00-00 00:00:00', 0, 0), | |
| (32, 'com_postinstall', 'component', 'com_postinstall', '', 1, 1, 1, 1, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0), | |
| (105, 'FOF', 'library', 'fof', '', 0, 1, 1, 1, '{"legacy":false,"name":"FOF","type":"library","creationDate":"2013-10-08","author":"Nicholas K. Dionysopoulos \/ Akeeba Ltd","copyright":"(C)2011-2013 Nicholas K. Dionysopoulos","authorEmail":"nicholas@akeebabackup.com","authorUrl":"https:\/\/www.akeebabackup.com","version":"2.1.rc4","description":"Framework-on-Framework (FOF) - A rapid component development framework for Joomla!","group":""}', '{}', '', '', 0, '0000-00-00 00:00:00', 0, 0), | |
| (448, 'plg_twofactorauth_totp', 'plugin', 'totp', 'twofactorauth', 0, 0, 1, 0, '{"name":"plg_twofactorauth_totp","type":"plugin","creationDate":"August 2013","author":"Joomla! Project","copyright":"(C) 2005 - 2014 Open Source Matters. All rights reserved.","authorEmail":"admin@joomla.org","authorUrl":"www.joomla.org","version":"3.2.0","description":"PLG_TWOFACTORAUTH_TOTP_XML_DESCRIPTION","group":""}', '{}', '', '', 0, '0000-00-00 00:00:00', 0, 0), | |
| (449, 'plg_authentication_cookie', 'plugin', 'cookie', 'authentication', 0, 1, 1, 0, '{"name":"plg_authentication_cookie","type":"plugin","creationDate":"July 2013","author":"Joomla! Project","copyright":"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.","authorEmail":"admin@joomla.org","authorUrl":"www.joomla.org","version":"3.0.0","description":"PLG_AUTH_COOKIE_XML_DESCRIPTION","group":""}', '{}', '', '', 0, '0000-00-00 00:00:00', 0, 0), | |
| (450, 'plg_twofactorauth_yubikey', 'plugin', 'yubikey', 'twofactorauth', 0, 0, 1, 0, '{"name":"plg_twofactorauth_yubikey","type":"plugin","creationDate":"Se[ptember 2013","author":"Joomla! Project","copyright":"(C) 2005 - 2014 Open Source Matters. All rights reserved.","authorEmail":"admin@joomla.org","authorUrl":"www.joomla.org","version":"3.2.0","description":"PLG_TWOFACTORAUTH_YUBIKEY_XML_DESCRIPTION","group":""}', '{}', '', '', 0, '0000-00-00 00:00:00', 0, 0); | |
| INSERT INTO `yourtableprefix_menu` (`menutype`, `title`, `alias`, `note`, `path`, `link`, `type`, `published`, `parent_id`, `level`, `component_id`, `checked_out`, `checked_out_time`, `browserNav`, `access`, `img`, `template_style_id`, `params`, `lft`, `rgt`, `home`, `language`, `client_id`) VALUES | |
| ('main', 'com_postinstall', 'Post-installation messages', '', 'Post-installation messages', 'index.php?option=com_postinstall', 'component', 0, 1, 1, 32, 0, '0000-00-00 00:00:00', 0, 1, 'class:postinstall', 0, '', 45, 46, 0, '*', 1); | |
| ALTER TABLE `yourtableprefix_modules` ADD COLUMN `asset_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'FK to the hq02r_assets table.' AFTER `id`; | |
| ALTER TABLE `yourtableprefix_users` ADD COLUMN `otpKey` varchar(1000) NOT NULL DEFAULT '' COMMENT 'Two factor authentication encrypted keys'; | |
| ALTER TABLE `yourtableprefix_users` ADD COLUMN `otep` varchar(1000) NOT NULL DEFAULT '' COMMENT 'One time emergency passwords'; | |
| -- lovah_3.sql | |
| /* Update bad params for two cpanel modules */ | |
| UPDATE `yourtableprefix_modules` SET `params` = REPLACE(`params`, '"bootstrap_size":"1"', '"bootstrap_size":"0"') WHERE `id` IN (3,4); | |
| -- 3.2.1 | |
| DELETE FROM `yourtableprefix_postinstall_messages` WHERE `title_key` = 'PLG_USER_JOOMLA_POSTINSTALL_STRONGPW_TITLE'; | |
| -- 3.2.2-2013-12-22 | |
| ALTER TABLE `yourtableprefix_update_sites` ADD COLUMN `extra_query` VARCHAR(1000) DEFAULT ''; | |
| ALTER TABLE `yourtableprefix_updates` ADD COLUMN `extra_query` VARCHAR(1000) DEFAULT ''; | |
| -- 3.2.2-2013-12-28 | |
| UPDATE `yourtableprefix_menu` SET `component_id` = (SELECT `extension_id` FROM `yourtableprefix_extensions` WHERE `element` = 'com_joomlaupdate') WHERE `link` = 'index.php?option=com_joomlaupdate'; | |
| -- 3.2.2-2014-01-08 | |
| INSERT INTO `yourtableprefix_extensions` (`extension_id`, `name`, `type`, `element`, `folder`, `client_id`, `enabled`, `access`, `protected`, `manifest_cache`, `params`, `custom_data`, `system_data`, `checked_out`, `checked_out_time`, `ordering`, `state`) VALUES | |
| (403, 'plg_content_contact', 'plugin', 'contact', 'content', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 1, 0); | |
| -- 3.2.2-2014-01-15 | |
| INSERT INTO `yourtableprefix_postinstall_messages` (`extension_id`, `title_key`, `description_key`, `action_key`, `language_extension`, `language_client_id`, `type`, `action_file`, `action`, `condition_file`, `condition_method`, `version_introduced`, `enabled`) VALUES | |
| (700, 'COM_CPANEL_MSG_PHPVERSION_TITLE', 'COM_CPANEL_MSG_PHPVERSION_BODY', '', 'com_cpanel', 1, 'message', '', '', 'admin://components/com_admin/postinstall/phpversion.php', 'admin_postinstall_phpversion_condition', '3.2.2', 1); | |
| -- 3.2.2-2014-01-18 | |
| /* Update updates version length */ | |
| ALTER TABLE `yourtableprefix_updates` MODIFY `version` varchar(32) DEFAULT ''; | |
| -- 3.2.2-2014-01-23 | |
| INSERT INTO `yourtableprefix_extensions` (`extension_id`, `name`, `type`, `element`, `folder`, `client_id`, `enabled`, `access`, `protected`, `manifest_cache`, `params`, `custom_data`, `system_data`, `checked_out`, `checked_out_time`, `ordering`, `state`) VALUES | |
| (106, 'PHPass', 'library', 'phpass', '', 0, 1, 1, 1, '{"legacy":false,"name":"PHPass","type":"library","creationDate":"2004-2006","author":"Solar Designer","authorEmail":"solar@openwall.com","authorUrl":"http:\/\/www.openwall.com/phpass","version":"0.3","description":"LIB_PHPASS_XML_DESCRIPTION","group":""}', '{}', '', '', 0, '0000-00-00 00:00:00', 0, 0); | |
| -- 3.2.2-2014-02-20 | |
| UPDATE `yourtableprefix_extensions` ext1, `yourtableprefix_extensions` ext2 SET ext1.`params` = ext2.`params` WHERE ext1.`name` = 'plg_authentication_cookie' AND ext2.`name` = 'plg_system_remember'; | |
| -- 3.3.0-2014-02-16 | |
| ALTER TABLE `yourtableprefix_users` ADD COLUMN `requireReset` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'Require user to reset password on next login' AFTER `otep`; | |
| -- 3.3.0-2014-04-02 | |
| INSERT INTO `yourtableprefix_extensions` (`extension_id`, `name`, `type`, `element`, `folder`, `client_id`, `enabled`, `access`, `protected`, `manifest_cache`, `params`, `custom_data`, `system_data`, `checked_out`, `checked_out_time`, `ordering`, `state`) VALUES | |
| (451, 'plg_search_tags', 'plugin', 'tags', 'search', 0, 0, 1, 0, '', '{"search_limit":"50","show_tagged_items":"1"}', '', '', 0, '0000-00-00 00:00:00', 0, 0); | |
| -- 3.3.4-2014-08-03 | |
| ALTER TABLE `yourtableprefix_user_profiles` CHANGE `profile_value` `profile_value` TEXT NOT NULL; | |
| -- 3.3.6-2014-09-30 | |
| INSERT INTO `yourtableprefix_update_sites` (`name`, `type`, `location`, `enabled`) VALUES | |
| ('Joomla! Update Component Update Site', 'extension', 'http://update.joomla.org/core/extensions/com_joomlaupdate.xml', 1); | |
| INSERT INTO `yourtableprefix_update_sites_extensions` (`update_site_id`, `extension_id`) VALUES | |
| ((SELECT `update_site_id` FROM `yourtableprefix_update_sites` WHERE `name` = 'Joomla! Update Component Update Site'), (SELECT `extension_id` FROM `yourtableprefix_extensions` WHERE `name` = 'com_joomlaupdate')); | |
| -- Cleanup redirect redirect_links | |
| DELETE FROM `yourtableprefix_redirect_links` WHERE `published` = '0'; | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment