Directory:~$ /home/lmsyaran/public_html/joomla3/administrator/components/com_admin/sql/updates/mysql/

Upload File

[Home] [System Details] [Kill Me]

UPDATE `#__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 `#__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 `#__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 `#__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 `#__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 `#__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 `#__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 `#__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 `#__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_title` =
'Article';
UPDATE `#__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_title` = 'Contact';
UPDATE `#__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_title` = 'Newsfeed';
UPDATE `#__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_title` = 'User';
UPDATE `#__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_title` = 'Article Category';
UPDATE `#__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_title` = 'Contact Category';
UPDATE `#__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_title` = 'Newsfeeds Category';
UPDATE `#__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_title` = 'Tag';