Created
August 26, 2014 14:20
-
-
Save pkdavies/70261dd1ff9bc79205ec to your computer and use it in GitHub Desktop.
joomla upgrade tag fix SQL
This file contains hidden or 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
| -- Table structure for table `r53wg_content_types` | |
| -- | |
| CREATE TABLE IF NOT EXISTS `r53wg_content_types` ( | |
| `type_id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| `type_title` varchar(255) NOT NULL DEFAULT '', | |
| `type_alias` varchar(255) NOT NULL DEFAULT '', | |
| `table` varchar(255) NOT NULL DEFAULT '', | |
| `rules` text NOT NULL, | |
| `field_mappings` text NOT NULL, | |
| `router` varchar(255) NOT NULL DEFAULT '', | |
| PRIMARY KEY (`type_id`), | |
| KEY `idx_alias` (`type_alias`) | |
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=10000; | |
| -- | |
| -- Dumping data for table `r53wg_content_types` | |
| -- | |
| INSERT INTO `r53wg_content_types` (`type_id`, `type_title`, `type_alias`, `table`, `rules`, `field_mappings`,`router`) VALUES | |
| (1, 'Article', 'com_content.article', '{"special":{"dbtable":"r53wg_content","key":"id","type":"Content","prefix":"JTable","config":"array()"},"common":{"dbtable":"r53wg_core_content","key":"ucm_id","type":"Corecontent","prefix":"JTable","config":"array()"}}', '', '{"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"}]}','ContentHelperRoute::getArticleRoute'), | |
| (2, 'Weblink', 'com_weblinks.weblink', '{"special":{"dbtable":"r53wg_weblinks","key":"id","type":"Weblink","prefix":"WeblinksTable","config":"array()"},"common":{"dbtable":"r53wg_core_content","key":"ucm_id","type":"Corecontent","prefix":"JTable","config":"array()"}}', '', '{"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":"urls", "core_version":"version", "core_ordering":"ordering", "core_metakey":"metakey", "core_metadesc":"metadesc", "core_catid":"catid", "core_xreference":"xreference", "asset_id":"null"}], "special": []}','WeblinksHelperRoute::getWeblinkRoute'), | |
| (3, 'Contact', 'com_contact.contact', '{"special":{"dbtable":"r53wg_contact_details","key":"id","type":"Contact","prefix":"ContactTable","config":"array()"},"common":{"dbtable":"r53wg_core_content","key":"ucm_id","type":"Corecontent","prefix":"JTable","config":"array()"}}', '', '{"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"}]}','ContactHelperRoute::getContactRoute'), | |
| (4, 'Newsfeed', 'com_newsfeeds.newsfeed', '{"special":{"dbtable":"r53wg_newsfeeds","key":"id","type":"Newsfeed","prefix":"NewsfeedsTable","config":"array()"},"common":{"dbtable":"r53wg_core_content","key":"ucm_id","type":"Corecontent","prefix":"JTable","config":"array()"}}', '', '{"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"}]}','NewsfeedsHelperRoute::getNewsfeedRoute'), | |
| (5, 'User', 'com_users.user', '{"special":{"dbtable":"r53wg_users","key":"id","type":"User","prefix":"JTable","config":"array()"},"common":{"dbtable":"r53wg_core_content","key":"ucm_id","type":"Corecontent","prefix":"JTable","config":"array()"}}', '', '{"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": [{}]}','UsersHelperRoute::getUserRoute'), | |
| (6, 'Article Category', 'com_content.category', '{"special":{"dbtable":"r53wg_categories","key":"id","type":"Category","prefix":"JTable","config":"array()"},"common":{"dbtable":"r53wg_core_content","key":"ucm_id","type":"Corecontent","prefix":"JTable","config":"array()"}}', '', '{"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"}]}','ContentHelperRoute::getCategoryRoute'), | |
| (7, 'Contact Category', 'com_contact.category', '{"special":{"dbtable":"r53wg_categories","key":"id","type":"Category","prefix":"JTable","config":"array()"},"common":{"dbtable":"r53wg_core_content","key":"ucm_id","type":"Corecontent","prefix":"JTable","config":"array()"}}', '', '{"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"}]}','ContactHelperRoute::getCategoryRoute'), | |
| (8, 'Newsfeeds Category', 'com_newsfeeds.category', '{"special":{"dbtable":"r53wg_categories","key":"id","type":"Category","prefix":"JTable","config":"array()"},"common":{"dbtable":"r53wg_core_content","key":"ucm_id","type":"Corecontent","prefix":"JTable","config":"array()"}}', '', '{"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"}]}','NewsfeedsHelperRoute::getCategoryRoute'), | |
| (9, 'Weblinks Category', 'com_weblinks.category', '{"special":{"dbtable":"r53wg_categories","key":"id","type":"Category","prefix":"JTable","config":"array()"},"common":{"dbtable":"r53wg_core_content","key":"ucm_id","type":"Corecontent","prefix":"JTable","config":"array()"}}', '', '{"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"}]}','WeblinksHelperRoute::getCategoryRoute'), | |
| (10, 'Tag', 'com_tags.tag', '{"special":{"dbtable":"r53wg_tags","key":"tag_id","type":"Tag","prefix":"TagsTable","config":"array()"},"common":{"dbtable":"r53wg_core_content","key":"ucm_id","type":"Corecontent","prefix":"JTable","config":"array()"}}', '', '{"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"}]}','TagsHelperRoute::getTagRoute'); | |
| CREATE TABLE IF NOT EXISTS `r53wg_contentitem_tag_map` ( | |
| `type_alias` varchar(255) NOT NULL DEFAULT '', | |
| `core_content_id` int(10) unsigned NOT NULL COMMENT 'PK from the core content table', | |
| `content_item_id` int(11) NOT NULL COMMENT 'PK from the content type table', | |
| `tag_id` int(10) unsigned NOT NULL COMMENT 'PK from the tag table', | |
| `tag_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Date of most recent save for this tag-item', | |
| `type_id` mediumint(8) NOT NULL COMMENT 'PK from the content_type table', | |
| UNIQUE KEY `uc_ItemnameTagid` (`type_id`,`content_item_id`,`tag_id`), | |
| KEY `idx_tag_type` (`tag_id`,`type_id`), | |
| KEY `idx_date_id` (`tag_date`,`tag_id`), | |
| KEY `idx_tag` (`tag_id`), | |
| KEY `idx_type` (`type_id`), | |
| KEY `idx_core_content_id` (`core_content_id`) | |
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Maps items from content tables to tags'; | |
| CREATE TABLE IF NOT EXISTS `r53wg_tags` ( | |
| `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| `parent_id` int(10) unsigned NOT NULL DEFAULT '0', | |
| `lft` int(11) NOT NULL DEFAULT '0', | |
| `rgt` int(11) NOT NULL DEFAULT '0', | |
| `level` int(10) unsigned NOT NULL DEFAULT '0', | |
| `path` varchar(255) NOT NULL DEFAULT '', | |
| `title` varchar(255) NOT NULL, | |
| `alias` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '', | |
| `note` varchar(255) NOT NULL DEFAULT '', | |
| `description` mediumtext NOT NULL, | |
| `published` tinyint(1) NOT NULL DEFAULT '0', | |
| `checked_out` int(11) unsigned NOT NULL DEFAULT '0', | |
| `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', | |
| `access` int(10) unsigned NOT NULL DEFAULT '0', | |
| `params` text NOT NULL, | |
| `metadesc` varchar(1024) NOT NULL COMMENT 'The meta description for the page.', | |
| `metakey` varchar(1024) NOT NULL COMMENT 'The meta keywords for the page.', | |
| `metadata` varchar(2048) NOT NULL COMMENT 'JSON encoded metadata properties.', | |
| `created_user_id` int(10) unsigned NOT NULL DEFAULT '0', | |
| `created_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', | |
| `created_by_alias` varchar(255) NOT NULL DEFAULT '', | |
| `modified_user_id` int(10) unsigned NOT NULL DEFAULT '0', | |
| `modified_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', | |
| `images` text NOT NULL, | |
| `urls` text NOT NULL, | |
| `hits` int(10) unsigned NOT NULL DEFAULT '0', | |
| `language` char(7) NOT NULL, | |
| `version` int(10) unsigned NOT NULL DEFAULT '1', | |
| `publish_up` datetime NOT NULL default '0000-00-00 00:00:00', | |
| `publish_down` datetime NOT NULL default '0000-00-00 00:00:00', | |
| PRIMARY KEY (`id`), | |
| KEY `tag_idx` (`published`,`access`), | |
| KEY `idx_access` (`access`), | |
| KEY `idx_checkout` (`checked_out`), | |
| KEY `idx_path` (`path`), | |
| KEY `idx_left_right` (`lft`,`rgt`), | |
| KEY `idx_alias` (`alias`), | |
| KEY `idx_language` (`language`) | |
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | |
| -- | |
| -- Dumping data for table `r53wg_tags` | |
| -- | |
| INSERT INTO `r53wg_tags` (`id`, `parent_id`, `lft`, `rgt`, `level`, `path`, `title`, `alias`, `note`, `description`, `published`, `checked_out`, `checked_out_time`, `access`, `params`, `metadesc`, `metakey`, `metadata`, `created_user_id`, `created_time`,`created_by_alias`, `modified_user_id`, `modified_time`, `images`, `urls`, `hits`, `language`, `version`) | |
| VALUES (1, 0, 0, 1, 0, '', 'ROOT', 'root', '', '', 1, 0, '0000-00-00 00:00:00', 1, '{}', '', '', '', '', '2011-01-01 00:00:01','', 0, '0000-00-00 00:00:00', '', '', 0, '*', 1); | |
| -- | |
| -- Table structure for table `r53wg_ucm_base` | |
| -- | |
| CREATE TABLE IF NOT EXISTS `r53wg_ucm_base` ( | |
| `ucm_id` int(10) unsigned NOT NULL, | |
| `ucm_item_id` int(10) NOT NULL, | |
| `ucm_type_id` int(11) NOT NULL, | |
| `ucm_language_id` int(11) NOT NULL, | |
| PRIMARY KEY (`ucm_id`), | |
| KEY `idx_ucm_item_id` (`ucm_item_id`), | |
| KEY `idx_ucm_type_id` (`ucm_type_id`), | |
| KEY `idx_ucm_language_id` (`ucm_language_id`) | |
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | |
| CREATE TABLE IF NOT EXISTS `r53wg_ucm_content` ( | |
| `core_content_id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| `core_type_alias` varchar(255) NOT NULL DEFAULT '' COMMENT 'FK to the content types table', | |
| `core_title` varchar(255) NOT NULL, | |
| `core_alias` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '', | |
| `core_body` mediumtext NOT NULL, | |
| `core_state` tinyint(1) NOT NULL DEFAULT '0', | |
| `core_checked_out_time` varchar(255) NOT NULL DEFAULT '', | |
| `core_checked_out_user_id` int(10) unsigned NOT NULL DEFAULT '0', | |
| `core_access` int(10) unsigned NOT NULL DEFAULT '0', | |
| `core_params` text NOT NULL, | |
| `core_featured` tinyint(4) unsigned NOT NULL DEFAULT '0', | |
| `core_metadata` varchar(2048) NOT NULL COMMENT 'JSON encoded metadata properties.', | |
| `core_created_user_id` int(10) unsigned NOT NULL DEFAULT '0', | |
| `core_created_by_alias` varchar(255) NOT NULL DEFAULT '', | |
| `core_created_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', | |
| `core_modified_user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Most recent user that modified', | |
| `core_modified_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', | |
| `core_language` char(7) NOT NULL, | |
| `core_publish_up` datetime NOT NULL, | |
| `core_publish_down` datetime NOT NULL, | |
| `core_content_item_id` int(10) unsigned COMMENT 'ID from the individual type table', | |
| `asset_id` int(10) unsigned COMMENT 'FK to the r53wg_assets table.', | |
| `core_images` text NOT NULL, | |
| `core_urls` text NOT NULL, | |
| `core_hits` int(10) unsigned NOT NULL DEFAULT '0', | |
| `core_version` int(10) unsigned NOT NULL DEFAULT '1', | |
| `core_ordering` int(11) NOT NULL DEFAULT '0', | |
| `core_metakey` text NOT NULL, | |
| `core_metadesc` text NOT NULL, | |
| `core_catid` int(10) unsigned NOT NULL DEFAULT '0', | |
| `core_xreference` varchar(50) NOT NULL COMMENT 'A reference to enable linkages to external data sets.', | |
| `core_type_id` int(10) unsigned, | |
| PRIMARY KEY (`core_content_id`), | |
| KEY `tag_idx` (`core_state`,`core_access`), | |
| KEY `idx_access` (`core_access`), | |
| KEY `idx_alias` (`core_alias`), | |
| KEY `idx_language` (`core_language`), | |
| KEY `idx_title` (`core_title`), | |
| KEY `idx_modified_time` (`core_modified_time`), | |
| KEY `idx_created_time` (`core_created_time`), | |
| KEY `idx_content_type` (`core_type_alias`), | |
| KEY `idx_core_modified_user_id` (`core_modified_user_id`), | |
| KEY `idx_core_checked_out_user_id` (`core_checked_out_user_id`), | |
| KEY `idx_core_created_user_id` (`core_created_user_id`), | |
| KEY `idx_core_type_id` (`core_type_id`) | |
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Contains core content data in name spaced fields'; | |
| INSERT INTO `r53wg_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 - 2013 Open Source Matters. All rights reserved.","authorEmail":"[email protected]","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 - 2013 Open Source Matters. All rights reserved.","authorEmail":"[email protected]","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 - 2013 Open Source Matters. All rights reserved.","authorEmail":"[email protected]","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 - 2013 Open Source Matters. All rights reserved.","authorEmail":"[email protected]","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 `r53wg_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); | |
| UPDATE `r53wg_content_types` SET `table` = '{"special":{"dbtable":"r53wg_content","key":"id","type":"Content","prefix":"JTable","config":"array()"},"common":{"dbtable":"r53wg_ucm_content","key":"ucm_id","type":"Corecontent","prefix":"JTable","config":"array()"}}' WHERE `type_title` = 'Article';UPDATE `r53wg_content_types` SET `table` = '{"special":{"dbtable":"r53wg_weblinks","key":"id","type":"Weblink","prefix":"WeblinksTable","config":"array()"},"common":{"dbtable":"r53wg_ucm_content","key":"ucm_id","type":"Corecontent","prefix":"JTable","config":"array()"}}' WHERE `type_title` = 'Weblink';UPDATE `r53wg_content_types` SET `table` = '{"special":{"dbtable":"r53wg_contact_details","key":"id","type":"Contact","prefix":"ContactTable","config":"array()"},"common":{"dbtable":"r53wg_ucm_content","key":"ucm_id","type":"Corecontent","prefix":"JTable","config":"array()"}}' WHERE `type_title` = 'Contact';UPDATE `r53wg_content_types` SET `table` = '{"special":{"dbtable":"r53wg_newsfeeds","key":"id","type":"Newsfeed","prefix":"NewsfeedsTable","config":"array()"},"common":{"dbtable":"r53wg_ucm_content","key":"ucm_id","type":"Corecontent","prefix":"JTable","config":"array()"}}' WHERE `type_title` = 'Newsfeed';UPDATE `r53wg_content_types` SET `table` = '{"special":{"dbtable":"r53wg_users","key":"id","type":"User","prefix":"JTable","config":"array()"},"common":{"dbtable":"r53wg_ucm_content","key":"ucm_id","type":"Corecontent","prefix":"JTable","config":"array()"}}' WHERE `type_title` = 'User';UPDATE `r53wg_content_types` SET `table` = '{"special":{"dbtable":"r53wg_categories","key":"id","type":"Category","prefix":"JTable","config":"array()"},"common":{"dbtable":"r53wg_ucm_content","key":"ucm_id","type":"Corecontent","prefix":"JTable","config":"array()"}}' WHERE `type_title` = 'Article Category';UPDATE `r53wg_content_types` SET `table` = '{"special":{"dbtable":"r53wg_categories","key":"id","type":"Category","prefix":"JTable","config":"array()"},"common":{"dbtable":"r53wg_ucm_content","key":"ucm_id","type":"Corecontent","prefix":"JTable","config":"array()"}}' WHERE `type_title` = 'Contact Category';UPDATE `r53wg_content_types` SET `table` = '{"special":{"dbtable":"r53wg_categories","key":"id","type":"Category","prefix":"JTable","config":"array()"},"common":{"dbtable":"r53wg_ucm_content","key":"ucm_id","type":"Corecontent","prefix":"JTable","config":"array()"}}' WHERE `type_title` = 'Newsfeeds Category';UPDATE `r53wg_content_types` SET `table` = '{"special":{"dbtable":"r53wg_categories","key":"id","type":"Category","prefix":"JTable","config":"array()"},"common":{"dbtable":"r53wg_ucm_content","key":"ucm_id","type":"Corecontent","prefix":"JTable","config":"array()"}}' WHERE `type_title` = 'Weblinks Category';UPDATE `r53wg_content_types` SET `table` = '{"special":{"dbtable":"r53wg_tags","key":"tag_id","type":"Tag","prefix":"TagsTable","config":"array()"},"common":{"dbtable":"r53wg_ucm_content","key":"ucm_id","type":"Corecontent","prefix":"JTable","config":"array()"}}' WHERE `type_title` = 'Tag'; | |
| UPDATE `r53wg_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 `r53wg_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 `r53wg_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 `r53wg_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 `r53wg_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 `r53wg_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 `r53wg_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 `r53wg_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 `r53wg_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 `r53wg_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'; | |
| ALTER TABLE `r53wg_content_types` ADD COLUMN `content_history_options` VARCHAR(5120) NOT NULL COMMENT 'JSON string for com_contenthistory options'; | |
| UPDATE `r53wg_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":"r53wg_categories","targetColumn":"id","displayColumn":"title"},{"sourceColumn":"created_by","targetTable":"r53wg_users","targetColumn":"id","displayColumn":"name"},{"sourceColumn":"access","targetTable":"r53wg_viewlevels","targetColumn":"id","displayColumn":"title"},{"sourceColumn":"modified_by","targetTable":"r53wg_users","targetColumn":"id","displayColumn":"name"} ]}' WHERE `type_alias` = 'com_content.article'; | |
| UPDATE `r53wg_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":"r53wg_users","targetColumn":"id","displayColumn":"name"},{"sourceColumn":"catid","targetTable":"r53wg_categories","targetColumn":"id","displayColumn":"title"},{"sourceColumn":"modified_by","targetTable":"r53wg_users","targetColumn":"id","displayColumn":"name"},{"sourceColumn":"access","targetTable":"r53wg_viewlevels","targetColumn":"id","displayColumn":"title"},{"sourceColumn":"user_id","targetTable":"r53wg_users","targetColumn":"id","displayColumn":"name"} ] }' WHERE `type_alias` = 'com_contact.contact'; | |
| UPDATE `r53wg_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":"r53wg_users","targetColumn":"id","displayColumn":"name"},{"sourceColumn":"access","targetTable":"r53wg_viewlevels","targetColumn":"id","displayColumn":"title"},{"sourceColumn":"modified_user_id","targetTable":"r53wg_users","targetColumn":"id","displayColumn":"name"},{"sourceColumn":"parent_id","targetTable":"r53wg_categories","targetColumn":"id","displayColumn":"title"}]}' WHERE `type_alias` IN ('com_content.category', 'com_contact.category', 'com_newsfeeds.category', 'com_weblinks.category'); | |
| UPDATE `r53wg_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":"r53wg_categories","targetColumn":"id","displayColumn":"title"},{"sourceColumn":"created_by","targetTable":"r53wg_users","targetColumn":"id","displayColumn":"name"},{"sourceColumn":"access","targetTable":"r53wg_viewlevels","targetColumn":"id","displayColumn":"title"},{"sourceColumn":"modified_by","targetTable":"r53wg_users","targetColumn":"id","displayColumn":"name"} ]}' WHERE `type_alias` = 'com_weblinks.weblink'; | |
| UPDATE `r53wg_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":"r53wg_categories","targetColumn":"id","displayColumn":"title"},{"sourceColumn":"created_by","targetTable":"r53wg_users","targetColumn":"id","displayColumn":"name"},{"sourceColumn":"access","targetTable":"r53wg_viewlevels","targetColumn":"id","displayColumn":"title"},{"sourceColumn":"modified_by","targetTable":"r53wg_users","targetColumn":"id","displayColumn":"name"}]}' WHERE `type_alias` = 'com_newsfeeds.newsfeed'; | |
| UPDATE `r53wg_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":"r53wg_users","targetColumn":"id","displayColumn":"name"}, {"sourceColumn":"access","targetTable":"r53wg_viewlevels","targetColumn":"id","displayColumn":"title"}, {"sourceColumn":"modified_user_id","targetTable":"r53wg_users","targetColumn":"id","displayColumn":"name"}]}' WHERE `type_alias` = 'com_tags.tag'; | |
| INSERT INTO `r53wg_content_types` (`type_title`, `type_alias`, `table`, `rules`, `field_mappings`, `router`, `content_history_options`) VALUES | |
| ('Banner', 'com_banners.banner', '{"special":{"dbtable":"r53wg_banners","key":"id","type":"Banner","prefix":"BannersTable","config":"array()"},"common":{"dbtable":"r53wg_ucm_content","key":"ucm_id","type":"Corecontent","prefix":"JTable","config":"array()"}}', '', '{"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":"null","core_publish_up":"publish_up","core_publish_down":"publish_down","core_access":"access", "core_params":"params", "core_featured":"null", "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":"null", "asset_id":"null"}, "special":{"imptotal":"imptotal", "impmade":"impmade", "clicks":"clicks", "clickurl":"clickurl", "custombannercode":"custombannercode", "cid":"cid", "purchase_type":"purchase_type", "track_impressions":"track_impressions", "track_clicks":"track_clicks"}}', '', '{"formFile":"administrator\\/components\\/com_banners\\/models\\/forms\\/banner.xml", "hideFields":["checked_out","checked_out_time","version", "reset"],"ignoreChanges":["modified_by", "modified", "checked_out", "checked_out_time", "version", "imptotal", "impmade", "reset"], "convertToInt":["publish_up", "publish_down", "ordering"], "displayLookup":[{"sourceColumn":"catid","targetTable":"r53wg_categories","targetColumn":"id","displayColumn":"title"}, {"sourceColumn":"cid","targetTable":"r53wg_banner_clients","targetColumn":"id","displayColumn":"name"}, {"sourceColumn":"created_by","targetTable":"r53wg_users","targetColumn":"id","displayColumn":"name"},{"sourceColumn":"modified_by","targetTable":"r53wg_users","targetColumn":"id","displayColumn":"name"}]}'), | |
| ('Banners Category', 'com_banners.category', '{"special":{"dbtable":"r53wg_categories","key":"id","type":"Category","prefix":"JTable","config":"array()"},"common":{"dbtable":"r53wg_ucm_content","key":"ucm_id","type":"Corecontent","prefix":"JTable","config":"array()"}}', '', '{"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"}}', '', '{"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":"r53wg_users","targetColumn":"id","displayColumn":"name"},{"sourceColumn":"access","targetTable":"r53wg_viewlevels","targetColumn":"id","displayColumn":"title"},{"sourceColumn":"modified_user_id","targetTable":"r53wg_users","targetColumn":"id","displayColumn":"name"},{"sourceColumn":"parent_id","targetTable":"r53wg_categories","targetColumn":"id","displayColumn":"title"}]}'), | |
| ('Banner Client', 'com_banners.client', '{"special":{"dbtable":"r53wg_banner_clients","key":"id","type":"Client","prefix":"BannersTable"}}', '', '', '', '{"formFile":"administrator\\/components\\/com_banners\\/models\\/forms\\/client.xml", "hideFields":["checked_out","checked_out_time"], "ignoreChanges":["checked_out", "checked_out_time"], "convertToInt":[], "displayLookup":[]}'), | |
| ('User Notes', 'com_users.note', '{"special":{"dbtable":"r53wg_user_notes","key":"id","type":"Note","prefix":"UsersTable"}}', '', '', '', '{"formFile":"administrator\\/components\\/com_users\\/models\\/forms\\/note.xml", "hideFields":["checked_out","checked_out_time", "publish_up", "publish_down"],"ignoreChanges":["modified_user_id", "modified_time", "checked_out", "checked_out_time"], "convertToInt":["publish_up", "publish_down"],"displayLookup":[{"sourceColumn":"catid","targetTable":"r53wg_categories","targetColumn":"id","displayColumn":"title"}, {"sourceColumn":"created_user_id","targetTable":"r53wg_users","targetColumn":"id","displayColumn":"name"}, {"sourceColumn":"user_id","targetTable":"r53wg_users","targetColumn":"id","displayColumn":"name"}, {"sourceColumn":"modified_user_id","targetTable":"r53wg_users","targetColumn":"id","displayColumn":"name"}]}'), | |
| ('User Notes Category', 'com_users.category', '{"special":{"dbtable":"r53wg_categories","key":"id","type":"Category","prefix":"JTable","config":"array()"},"common":{"dbtable":"r53wg_ucm_content","key":"ucm_id","type":"Corecontent","prefix":"JTable","config":"array()"}}', '', '{"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"}}', '', '{"formFile":"administrator\\/components\\/com_categories\\/models\\/forms\\/category.xml", "hideFields":["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":"r53wg_users","targetColumn":"id","displayColumn":"name"}, {"sourceColumn":"access","targetTable":"r53wg_viewlevels","targetColumn":"id","displayColumn":"title"},{"sourceColumn":"modified_user_id","targetTable":"r53wg_users","targetColumn":"id","displayColumn":"name"},{"sourceColumn":"parent_id","targetTable":"r53wg_categories","targetColumn":"id","displayColumn":"title"}]}'); | |
| UPDATE `r53wg_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 `r53wg_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 `r53wg_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 - 2013 Open Source Matters. All rights reserved.\\n\\t","authorEmail":"[email protected]","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 - 2013 Open Source Matters. All rights reserved.","authorEmail":"[email protected]","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":"[email protected]","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 - 2013 Open Source Matters. All rights reserved.","authorEmail":"[email protected]","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 - 2013 Open Source Matters. All rights reserved.","authorEmail":"[email protected]","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 - 2013 Open Source Matters. All rights reserved.","authorEmail":"[email protected]","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 `r53wg_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 `r53wg_modules` ADD COLUMN `asset_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'FK to the r53wg_assets table.' AFTER `id`; | |
| CREATE TABLE IF NOT EXISTS `r53wg_ucm_history` ( | |
| `version_id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| `ucm_item_id` int(10) unsigned NOT NULL, | |
| `ucm_type_id` int(10) unsigned NOT NULL, | |
| `version_note` varchar(255) NOT NULL DEFAULT '' COMMENT 'Optional version name', | |
| `save_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', | |
| `editor_user_id` int(10) unsigned NOT NULL DEFAULT '0', | |
| `character_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Number of characters in this version.', | |
| `sha1_hash` varchar(50) NOT NULL DEFAULT '' COMMENT 'SHA1 hash of the version_data column.', | |
| `version_data` mediumtext NOT NULL COMMENT 'json-encoded string of version data', | |
| `keep_forever` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0=auto delete; 1=keep', | |
| PRIMARY KEY (`version_id`), | |
| KEY `idx_ucm_item_id` (`ucm_type_id`,`ucm_item_id`), | |
| KEY `idx_save_date` (`save_date`) | |
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | |
| ALTER TABLE `r53wg_users` ADD COLUMN `otpKey` varchar(1000) NOT NULL DEFAULT '' COMMENT 'Two factor authentication encrypted keys'; | |
| ALTER TABLE `r53wg_users` ADD COLUMN `otep` varchar(1000) NOT NULL DEFAULT '' COMMENT 'One time emergency passwords'; | |
| CREATE TABLE IF NOT EXISTS `r53wg_user_keys` ( | |
| `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| `user_id` varchar(255) NOT NULL, | |
| `token` varchar(255) NOT NULL, | |
| `series` varchar(255) NOT NULL, | |
| `invalid` tinyint(4) NOT NULL, | |
| `time` varchar(200) NOT NULL, | |
| `uastring` varchar(255) NOT NULL, | |
| PRIMARY KEY (`id`), | |
| UNIQUE KEY `series` (`series`), | |
| UNIQUE KEY `series_2` (`series`), | |
| UNIQUE KEY `series_3` (`series`), | |
| KEY `user_id` (`user_id`) | |
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | |
| /* Update bad params for two cpanel modules */ | |
| UPDATE `r53wg_modules` SET `params` = REPLACE(`params`, '"bootstrap_size":"1"', '"bootstrap_size":"0"') WHERE `id` IN (3,4); | |
| DELETE FROM `r53wg_postinstall_messages` WHERE `title_key` = 'PLG_USER_JOOMLA_POSTINSTALL_STRONGPW_TITLE'; | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment