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

Upload File

[Home] [System Details] [Kill Me]

/* Core 3.2 schema updates */

ALTER TABLE `#__content_types` ADD COLUMN `content_history_options`
VARCHAR(5120) NOT NULL COMMENT 'JSON string for com_contenthistory
options';

UPDATE `#__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 `#__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 `#__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');
UPDATE `#__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 `#__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';

INSERT INTO `#__content_types` (`type_title`, `type_alias`, `table`,
`rules`, `field_mappings`, `router`, `content_history_options`) VALUES
('Banner', 'com_banners.banner',
'{"special":{"dbtable":"#__banners","key":"id","type":"Banner","prefix":"BannersTable","config":"array()"},"common":{"dbtable":"#__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":"#__categories","targetColumn":"id","displayColumn":"title"},
{"sourceColumn":"cid","targetTable":"#__banner_clients","targetColumn":"id","displayColumn":"name"},
{"sourceColumn":"created_by","targetTable":"#__users","targetColumn":"id","displayColumn":"name"},{"sourceColumn":"modified_by","targetTable":"#__users","targetColumn":"id","displayColumn":"name"}]}'),
('Banners Category', 'com_banners.category',
'{"special":{"dbtable":"#__categories","key":"id","type":"Category","prefix":"JTable","config":"array()"},"common":{"dbtable":"#__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":"#__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"}]}'),
('Banner Client', 'com_banners.client',
'{"special":{"dbtable":"#__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":"#__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":"#__categories","targetColumn":"id","displayColumn":"title"},
{"sourceColumn":"created_user_id","targetTable":"#__users","targetColumn":"id","displayColumn":"name"},
{"sourceColumn":"user_id","targetTable":"#__users","targetColumn":"id","displayColumn":"name"},
{"sourceColumn":"modified_user_id","targetTable":"#__users","targetColumn":"id","displayColumn":"name"}]}'),
('User Notes Category', 'com_users.category',
'{"special":{"dbtable":"#__categories","key":"id","type":"Category","prefix":"JTable","config":"array()"},"common":{"dbtable":"#__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":"#__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"}]}');

UPDATE `#__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 `#__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 `#__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) 2013 Open Source Matters,
Inc.\\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) 2013 Open Source Matters,
Inc.","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) 2013 Open Source Matters,
Inc.","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":"(C) 2013 Open Source Matters,
Inc.","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) 2013 Open Source Matters,
Inc.","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 `#__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 `#__modules` ADD COLUMN `asset_id` INT UNSIGNED NOT NULL
DEFAULT '0' COMMENT 'FK to the #__assets table.' AFTER
`id`;

CREATE TABLE `#__postinstall_messages` (
  `postinstall_message_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `extension_id` bigint NOT NULL DEFAULT '700' COMMENT 'FK
to #__extensions',
  `title_key` varchar(255) NOT NULL DEFAULT '' COMMENT 'Lang
key for the title',
  `description_key` varchar(255) NOT NULL DEFAULT '' COMMENT
'Lang key for description',
  `action_key` varchar(255) NOT NULL DEFAULT '',
  `language_extension` varchar(255) NOT NULL DEFAULT
'com_postinstall' COMMENT 'Extension holding lang
keys',
  `language_client_id` tinyint NOT NULL DEFAULT '1',
  `type` varchar(10) NOT NULL DEFAULT 'link' COMMENT
'Message type - message, link, action',
  `action_file` varchar(255) DEFAULT '' COMMENT 'RAD URI to
the PHP file containing action method',
  `action` varchar(255) DEFAULT '' COMMENT 'Action method
name or URL',
  `condition_file` varchar(255) DEFAULT NULL COMMENT 'RAD URI to file
holding display condition method',
  `condition_method` varchar(255) DEFAULT NULL COMMENT 'Display
condition method, must return boolean',
  `version_introduced` varchar(50) NOT NULL DEFAULT '3.2.0'
COMMENT 'Version when this message was introduced',
  `enabled` tinyint NOT NULL DEFAULT '1',
  PRIMARY KEY (`postinstall_message_id`)
) DEFAULT CHARSET=utf8;

INSERT INTO `#__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, 'PLG_TWOFACTORAUTH_TOTP_POSTINSTALL_TITLE',
'PLG_TWOFACTORAUTH_TOTP_POSTINSTALL_BODY',
'PLG_TWOFACTORAUTH_TOTP_POSTINSTALL_ACTION',
'plg_twofactorauth_totp', 1, 'action',
'site://plugins/twofactorauth/totp/postinstall/actions.php',
'twofactorauth_postinstall_action',
'site://plugins/twofactorauth/totp/postinstall/actions.php',
'twofactorauth_postinstall_condition', '3.2.0', 1),
(700, 'COM_CPANEL_MSG_EACCELERATOR_TITLE',
'COM_CPANEL_MSG_EACCELERATOR_BODY',
'COM_CPANEL_MSG_EACCELERATOR_BUTTON', 'com_cpanel', 1,
'action',
'admin://components/com_admin/postinstall/eaccelerator.php',
'admin_postinstall_eaccelerator_action',
'admin://components/com_admin/postinstall/eaccelerator.php',
'admin_postinstall_eaccelerator_condition', '3.2.0',
1);

CREATE TABLE IF NOT EXISTS `#__ucm_history` (
  `version_id` int unsigned NOT NULL AUTO_INCREMENT,
  `ucm_item_id` int unsigned NOT NULL,
  `ucm_type_id` int 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 unsigned NOT NULL DEFAULT '0',
  `character_count` int 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 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 `#__users` ADD COLUMN `otpKey` varchar(1000) NOT NULL DEFAULT
'' COMMENT 'Two factor authentication encrypted keys';
ALTER TABLE `#__users` ADD COLUMN `otep` varchar(1000) NOT NULL DEFAULT
'' COMMENT 'One time emergency passwords';

CREATE TABLE IF NOT EXISTS `#__user_keys` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `series` varchar(255) NOT NULL,
  `invalid` tinyint 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 `#__modules` SET `params` = REPLACE(`params`,
'"bootstrap_size":"1"',
'"bootstrap_size":"0"') WHERE `id` IN (3,4);