AAAAPK ńC\T9 9 2.5.6.sqlnu W+A # Placeholder file for database changes for version 2.5.6PK ńC\Sͫ9 9 2.5.8.sqlnu W+A # Placeholder file for database changes for version 2.5.8PK ńC\a 2.5.0-2011-12-22.sqlnu W+A REPLACE INTO `#__finder_taxonomy` (`id`, `parent_id`, `title`, `state`, `access`, `ordering`) VALUES
(1, 0, 'ROOT', 0, 0, 0);
REPLACE INTO `#__finder_terms_common` (`term`, `language`) VALUES
('a', 'en'),
('about', 'en'),
('after', 'en'),
('ago', 'en'),
('all', 'en'),
('am', 'en'),
('an', 'en'),
('and', 'en'),
('ani', 'en'),
('any', 'en'),
('are', 'en'),
('aren''t', 'en'),
('as', 'en'),
('at', 'en'),
('be', 'en'),
('but', 'en'),
('by', 'en'),
('for', 'en'),
('from', 'en'),
('get', 'en'),
('go', 'en'),
('how', 'en'),
('if', 'en'),
('in', 'en'),
('into', 'en'),
('is', 'en'),
('isn''t', 'en'),
('it', 'en'),
('its', 'en'),
('me', 'en'),
('more', 'en'),
('most', 'en'),
('must', 'en'),
('my', 'en'),
('new', 'en'),
('no', 'en'),
('none', 'en'),
('not', 'en'),
('noth', 'en'),
('nothing', 'en'),
('of', 'en'),
('off', 'en'),
('often', 'en'),
('old', 'en'),
('on', 'en'),
('onc', 'en'),
('once', 'en'),
('onli', 'en'),
('only', 'en'),
('or', 'en'),
('other', 'en'),
('our', 'en'),
('ours', 'en'),
('out', 'en'),
('over', 'en'),
('page', 'en'),
('she', 'en'),
('should', 'en'),
('small', 'en'),
('so', 'en'),
('some', 'en'),
('than', 'en'),
('thank', 'en'),
('that', 'en'),
('the', 'en'),
('their', 'en'),
('theirs', 'en'),
('them', 'en'),
('then', 'en'),
('there', 'en'),
('these', 'en'),
('they', 'en'),
('this', 'en'),
('those', 'en'),
('thus', 'en'),
('time', 'en'),
('times', 'en'),
('to', 'en'),
('too', 'en'),
('true', 'en'),
('under', 'en'),
('until', 'en'),
('up', 'en'),
('upon', 'en'),
('use', 'en'),
('user', 'en'),
('users', 'en'),
('veri', 'en'),
('version', 'en'),
('very', 'en'),
('via', 'en'),
('want', 'en'),
('was', 'en'),
('way', 'en'),
('were', 'en'),
('what', 'en'),
('when', 'en'),
('where', 'en'),
('whi', 'en'),
('which', 'en'),
('who', 'en'),
('whom', 'en'),
('whose', 'en'),
('why', 'en'),
('wide', 'en'),
('will', 'en'),
('with', 'en'),
('within', 'en'),
('without', 'en'),
('would', 'en'),
('yes', 'en'),
('yet', 'en'),
('you', 'en'),
('your', 'en'),
('yours', 'en');
INSERT INTO `#__menu` (`id`, `menutype`, `title`, `alias`, `note`, `path`, `link`, `type`, `published`, `parent_id`, `level`, `component_id`, `ordering`, `checked_out`, `checked_out_time`, `browserNav`, `access`, `img`, `template_style_id`, `params`, `lft`, `rgt`, `home`, `language`, `client_id`) VALUES
(21, 'menu', 'com_finder', 'Smart Search', '', 'Smart Search', 'index.php?option=com_finder', 'component', 0, 1, 1, 27, 0, 0, '0000-00-00 00:00:00', 0, 0, 'class:finder', 0, '', 41, 42, 0, '*', 1);
PK ńC\A,Z Z 1.7.3-2011-10-19.sqlnu W+A ALTER TABLE `#__languages` ADD COLUMN `sitename` varchar(1024) NOT NULL AFTER `metadesc`;
PK ńC\a 2.5.0-2011-12-19.sqlnu W+A CREATE TABLE IF NOT EXISTS `#__user_notes` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(10) unsigned NOT NULL DEFAULT '0',
`catid` int(10) unsigned NOT NULL DEFAULT '0',
`subject` varchar(100) NOT NULL DEFAULT '',
`body` text NOT NULL,
`state` tinyint(3) NOT NULL DEFAULT '0',
`checked_out` int(10) unsigned NOT NULL DEFAULT '0',
`checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`created_user_id` int(10) unsigned NOT NULL DEFAULT '0',
`created_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`modified_user_id` int(10) unsigned NOT NULL,
`modified_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`review_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`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 `idx_user_id` (`user_id`),
KEY `idx_category_id` (`catid`)
) DEFAULT CHARSET=utf8;
PK ńC\_\ \ 2.5.4-2012-03-19.sqlnu W+A ALTER TABLE `#__languages` ADD COLUMN `access` integer unsigned NOT NULL default 0 AFTER `published`;
ALTER TABLE `#__languages` ADD KEY `idx_access` (`access`);
UPDATE `#__categories` SET `extension` = 'com_users.notes' WHERE `extension` = 'com_users';
UPDATE `#__extensions` SET `enabled` = '1' WHERE `protected` = '1' AND `type` <> 'plugin';
PK ńC\ 2.5.0-2011-12-21-1.sqlnu W+A 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
(27, 'com_finder', 'component', 'com_finder', '', 1, 1, 0, 0, '', '{"show_description":"1","description_length":255,"allow_empty_query":"0","show_url":"1","show_advanced":"1","expand_advanced":"0","show_date_filters":"0","highlight_terms":"1","opensearch_name":"","opensearch_description":"","batch_size":"50","memory_table_limit":30000,"title_multiplier":"1.7","text_multiplier":"0.7","meta_multiplier":"1.2","path_multiplier":"2.0","misc_multiplier":"0.3","stemmer":"porter_en"}', '', '', 0, '0000-00-00 00:00:00', 0, 0),
(439, 'plg_captcha_recaptcha', 'plugin', 'recaptcha', 'captcha', 0, 1, 1, 0, '{}', '{"public_key":"","private_key":"","theme":"clean"}', '', '', 0, '0000-00-00 00:00:00', 0, 0),
(440, 'plg_system_highlight', 'plugin', 'highlight', 'system', 0, 1, 1, 0, '', '{}', '', '', 0, '0000-00-00 00:00:00', 7, 0),
(441, 'plg_content_finder', 'plugin', 'finder', 'content', 0, 0, 1, 0, '{"legacy":false,"name":"plg_content_finder","type":"plugin","creationDate":"December 2011","author":"Joomla! Project","copyright":"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.","authorEmail":"admin@joomla.org","authorUrl":"www.joomla.org","version":"1.7.0","description":"PLG_CONTENT_FINDER_XML_DESCRIPTION","group":""}', '{}', '', '', 0, '0000-00-00 00:00:00', 0, 0),
(442, 'plg_finder_categories', 'plugin', 'categories', 'finder', 0, 1, 1, 0, '', '{}', '', '', 0, '0000-00-00 00:00:00', 1, 0),
(443, 'plg_finder_contacts', 'plugin', 'contacts', 'finder', 0, 1, 1, 0, '', '{}', '', '', 0, '0000-00-00 00:00:00', 2, 0),
(444, 'plg_finder_content', 'plugin', 'content', 'finder', 0, 1, 1, 0, '', '{}', '', '', 0, '0000-00-00 00:00:00', 3, 0),
(445, 'plg_finder_newsfeeds', 'plugin', 'newsfeeds', 'finder', 0, 1, 1, 0, '', '{}', '', '', 0, '0000-00-00 00:00:00', 4, 0),
(446, 'plg_finder_weblinks', 'plugin', 'weblinks', 'finder', 0, 1, 1, 0, '', '{}', '', '', 0, '0000-00-00 00:00:00', 5, 0),
(223, 'mod_finder', 'module', 'mod_finder', '', 0, 1, 0, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0);
PK ńC\= ; ;
2.5.21.sqlnu W+A # Placeholder file for database changes for version 2.5.21
PK ńC\sQ; ;
2.5.26.sqlnu W+A # Placeholder file for database changes for version 2.5.26
PK ńC\W:
2.5.28.sqlnu W+A ALTER TABLE `#__user_profiles` CHANGE `profile_value` `profile_value` TEXT NOT NULL;
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
(900, 'plg_quickicon_eosnotify', 'plugin', 'eosnotify', 'quickicon', 0, 1, 1, 1, '', '{}', '', '', 0, '0000-00-00 00:00:00', 0, 0);
PK ńC\ mW W 2.5.0-2011-12-06.sqlnu W+A 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
(437, 'plg_quickicon_joomlaupdate', 'plugin', 'joomlaupdate', 'quickicon', 0, 1, 1, 1, '', '{}', '', '', 0, '0000-00-00 00:00:00', 0, 0),
(438, 'plg_quickicon_extensionupdate', 'plugin', 'extensionupdate', 'quickicon', 0, 1, 1, 1, '', '{}', '', '', 0, '0000-00-00 00:00:00', 0, 0);
ALTER TABLE `#__update_sites` ADD COLUMN `last_check_timestamp` bigint(20) DEFAULT '0' AFTER `enabled`;
REPLACE INTO `#__update_sites` VALUES
(1, 'Joomla Core', 'collection', 'http://update.joomla.org/core/list.xml', 1, 0),
(2, 'Joomla Extension Directory', 'collection', 'http://update.joomla.org/jed/list.xml', 1, 0);
PK ńC\o.; ;
2.5.13.sqlnu W+A # Placeholder file for database changes for version 2.5.13
PK ƄC\ & & 2.5.2-2012-03-05.sqlnu W+A # Dummy SQL file to set schema versionPK ƄC\wa; ;
2.5.14.sqlnu W+A # Placeholder file for database changes for version 2.5.14
PK ƄC\! 2.5.4-2012-03-18.sqlnu W+A 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
(28, 'com_joomlaupdate', 'component', 'com_joomlaupdate', '', 1, 1, 0, 1, '{"legacy":false,"name":"com_joomlaupdate","type":"component","creationDate":"February 2012","author":"Joomla! Project","copyright":"(C) 2005 - 2014 Open Source Matters. All rights reserved.","authorEmail":"admin@joomla.org","authorUrl":"www.joomla.org","version":"2.5.2","description":"COM_JOOMLAUPDATE_XML_DESCRIPTION","group":""}', '{}', '', '', 0, '0000-00-00 00:00:00', 0, 0);
INSERT INTO `#__menu` (`id`, `menutype`, `title`, `alias`, `note`, `path`, `link`, `type`, `published`, `parent_id`, `level`, `component_id`, `ordering`, `checked_out`, `checked_out_time`, `browserNav`, `access`, `img`, `template_style_id`, `params`, `lft`, `rgt`, `home`, `language`, `client_id`) VALUES
(22, 'menu', 'com_joomlaupdate', 'Joomla! Update', '', 'Joomla! Update', 'index.php?option=com_joomlaupdate', 'component', 0, 1, 1, 28, 0, 0, '0000-00-00 00:00:00', 0, 0, 'class:joomlaupdate', 0, '', 41, 42, 0, '*', 1);
PK ƄC\lG 2.5.0-2011-12-16.sqlnu W+A CREATE TABLE IF NOT EXISTS `#__overrider` (
`id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
`constant` varchar(255) NOT NULL,
`string` text NOT NULL,
`file` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;PK ƄC\5 1.7.0-2011-06-06-2.sqlnu W+A ALTER TABLE `#__languages` ADD COLUMN `ordering` int(11) NOT NULL default 0 AFTER `published`;
ALTER TABLE `#__languages` ADD INDEX `idx_ordering` (`ordering`);
PK ƄC\e 2.5.0-2011-12-24.sqlnu W+A ALTER TABLE `#__menu` DROP INDEX `idx_client_id_parent_id_alias`;
ALTER TABLE `#__menu` ADD UNIQUE `idx_client_id_parent_id_alias_language` ( `client_id` , `parent_id` , `alias` , `language` );PK ƄC\9 9 2.5.9.sqlnu W+A # Placeholder file for database changes for version 2.5.9PK ƄC\=/ 2.5.0-2011-12-23.sqlnu W+A CREATE TABLE IF NOT EXISTS `#__finder_filters` (
`filter_id` int(10) unsigned NOT NULL auto_increment,
`title` varchar(255) NOT NULL,
`alias` varchar(255) NOT NULL,
`state` tinyint(1) NOT NULL default '1',
`created` datetime NOT NULL default '0000-00-00 00:00:00',
`created_by` int(10) unsigned NOT NULL,
`created_by_alias` varchar(255) NOT NULL,
`modified` datetime NOT NULL default '0000-00-00 00:00:00',
`modified_by` int(10) unsigned NOT NULL default '0',
`checked_out` int(10) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`map_count` int(10) unsigned NOT NULL default '0',
`data` text NOT NULL,
`params` mediumtext,
PRIMARY KEY (`filter_id`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__finder_links` (
`link_id` int(10) unsigned NOT NULL auto_increment,
`url` varchar(255) NOT NULL,
`route` varchar(255) NOT NULL,
`title` varchar(255) default NULL,
`description` varchar(255) default NULL,
`indexdate` datetime NOT NULL default '0000-00-00 00:00:00',
`md5sum` varchar(32) default NULL,
`published` tinyint(1) NOT NULL default '1',
`state` int(5) default '1',
`access` int(5) default '0',
`language` varchar(8) NOT NULL,
`publish_start_date` datetime NOT NULL default '0000-00-00 00:00:00',
`publish_end_date` datetime NOT NULL default '0000-00-00 00:00:00',
`start_date` datetime NOT NULL default '0000-00-00 00:00:00',
`end_date` datetime NOT NULL default '0000-00-00 00:00:00',
`list_price` double unsigned NOT NULL default '0',
`sale_price` double unsigned NOT NULL default '0',
`type_id` int(11) NOT NULL,
`object` mediumblob NOT NULL,
PRIMARY KEY (`link_id`),
KEY `idx_type` (`type_id`),
KEY `idx_title` (`title`),
KEY `idx_md5` (`md5sum`),
KEY `idx_url` (`url`(75)),
KEY `idx_published_list` (`published`,`state`,`access`,`publish_start_date`,`publish_end_date`,`list_price`),
KEY `idx_published_sale` (`published`,`state`,`access`,`publish_start_date`,`publish_end_date`,`sale_price`)
) DEFAULT CHARSET=utf8;
PK ƄC\Y7b 2.5.7.sqlnu W+A INSERT INTO `#__update_sites` (`name`, `type`, `location`, `enabled`, `last_check_timestamp`) VALUES('Accredited Joomla! Translations','collection','http://update.joomla.org/language/translationlist.xml',1,0);
INSERT INTO `#__update_sites_extensions` (`update_site_id`, `extension_id`) VALUES(LAST_INSERT_ID(),600);
UPDATE `#__assets` SET name=REPLACE( name, 'com_user.notes.category','com_users.category' );
UPDATE `#__categories` SET extension=REPLACE( extension, 'com_user.notes.category','com_users.category' );
PK ƄC\Fx; ;
2.5.15.sqlnu W+A # Placeholder file for database changes for version 2.5.15
PK ƄC\Ǯ9: :
2.5.12.sqlnu W+A # Placeholder file for database changes for version 2.5.12PK ƄC\V
index.htmlnu W+A
PK ƄC\iX X 1.7.1-2011-09-17.sqlnu W+A ALTER TABLE `#__modules` CHANGE `position` `position` VARCHAR( 50 ) NOT NULL DEFAULT '';PK ƄC\$.5^ ^ 2.5.0-2012-01-14.sqlnu W+A ALTER TABLE `#__languages` CHANGE `sitename` `sitename` VARCHAR( 1024 ) NOT NULL DEFAULT '';
PK ƄC\2H; ;
2.5.27.sqlnu W+A # Placeholder file for database changes for version 2.5.27
PK ƄC\ ; ;
2.5.20.sqlnu W+A # Placeholder file for database changes for version 2.5.20
PK ƄC\KMۘ 1.7.0-2011-06-06.sqlnu W+A CREATE TABLE IF NOT EXISTS `#__associations` (
`id` VARCHAR(50) NOT NULL COMMENT 'A reference to the associated item.',
`context` VARCHAR(50) NOT NULL COMMENT 'The context of the associated item.',
`key` CHAR(32) NOT NULL COMMENT 'The key for the association computed from an md5 on associated ids.',
PRIMARY KEY `idx_context_id` (`context`, `id`),
INDEX `idx_key` (`key`)
) DEFAULT CHARSET=utf8;
PK ƄC\}: :
2.5.11.sqlnu W+A # Placeholder file for database changes for version 2.5.11PK ƄC\*S; ;
2.5.16.sqlnu W+A # Placeholder file for database changes for version 2.5.16
PK ƄC\8; ;
2.5.18.sqlnu W+A # Placeholder file for database changes for version 2.5.18
PK ƄC\S) 2.5.1-2012-01-26.sqlnu W+A 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
(314, 'mod_version', 'module', 'mod_version', '', 1, 1, 1, 0, '{"legacy":false,"name":"mod_version","type":"module","creationDate":"January 2012","author":"Joomla! Project","copyright":"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.","authorEmail":"admin@joomla.org","authorUrl":"www.joomla.org","version":"2.5.0","description":"MOD_VERSION_XML_DESCRIPTION","group":""}', '{"format":"short","product":"1","cache":"0"}', '', '', 0, '0000-00-00 00:00:00', 0, 0);
INSERT INTO `#__modules` (`title`, `note`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `publish_up`, `publish_down`, `published`, `module`, `access`, `showtitle`, `params`, `client_id`, `language`) VALUES
('Joomla Version', '', '', 1, 'footer', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'mod_version', 3, 1, '{"format":"short","product":"1","layout":"_:default","moduleclass_sfx":"","cache":"0"}', 1, '*');
INSERT INTO `#__modules_menu` (`moduleid`, `menuid`) VALUES
(LAST_INSERT_ID(), 0);PK ƄC\H? 1.7.4-2011-12-12.sqlnu W+A 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 ('436', 'plg_system_languagecode', 'plugin', 'languagecode', 'system', '0', '0', '1', '0', '{"legacy":false,"name":"plg_system_languagecode","type":"plugin","creationDate":"November 2011","author":"Joomla! Project","copyright":"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.","authorEmail":"admin@joomla.org","authorUrl":"www.joomla.org","version":"1.7.0","description":"PLG_SYSTEM_LANGUAGECODE_XML_DESCRIPTION","group":""}', '{}', '', '', '0', '0000-00-00 00:00:00', '10', '0');
PK ƄC\T 1.7.4-2011-11-23.sqlnu W+A ALTER TABLE `#__newsfeeds` CHANGE `alias` `alias` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '';
ALTER TABLE `#__content` CHANGE `alias` `alias` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '';
ALTER TABLE `#__content` CHANGE `title_alias` `title_alias` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT 'Deprecated in Joomla! 3.0';
PK ƄC\o`Q Q 2.5.0-2012-01-10.sqlnu W+A ALTER TABLE `#__updates` ADD COLUMN `infourl` text NOT NULL AFTER `detailsurl`;
PK ƄC\6_,; ;
2.5.23.sqlnu W+A # Placeholder file for database changes for version 2.5.23
PK ƄC\c; ;
2.5.24.sqlnu W+A # Placeholder file for database changes for version 2.5.24
PK ƄC\) .htaccessnu W+A
Order allow,deny
Deny from all
PK ƄC\K@ @ 2.5.0-2011-12-20.sqlnu W+A SELECT @old_params:= CONCAT(SUBSTRING_INDEX(SUBSTRING(params, LOCATE('"filters":', params)), '}}', 1), '}}') as filters
FROM `#__extensions`
WHERE name="com_content";
UPDATE `#__extensions`
SET params=CONCAT('{',SUBSTRING(params, 2, CHAR_LENGTH(params)-2),IF(params='','',','),@old_params,'}')
WHERE name="com_config";PK ƄC\ 1.7.0.sqlnu W+A PK ƄC\vPs s 1.7.1-2011-09-15-3.sqlnu W+A UPDATE `#__modules` SET `ordering` = 2 WHERE `position` = 'status' AND `module` = 'mod_status' AND `client_id`=1;
PK ƄC\ry 1.7.3-2011-10-15.sqlnu W+A ALTER TABLE `#__banners` CHANGE `alias` `alias` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '';
ALTER TABLE `#__categories` CHANGE `alias` `alias` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '';
ALTER TABLE `#__contact_details` CHANGE `alias` `alias` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '';
ALTER TABLE `#__content` CHANGE `alias` `alias` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '';
ALTER TABLE `#__content` CHANGE `title_alias` `title_alias` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '';
ALTER TABLE `#__menu` CHANGE `alias` `alias` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'The SEF alias of the menu item.';
ALTER TABLE `#__newsfeeds` CHANGE `alias` `alias` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '';
ALTER TABLE `#__weblinks` CHANGE `alias` `alias` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '';
PK ƄC\H P 1.7.1-2011-09-15-4.sqlnu W+A INSERT INTO `#__modules` (`id`, `title`, `note`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `publish_up`, `publish_down`, `published`, `module`, `access`, `showtitle`, `params`, `client_id`, `language`) VALUES
(NULL, 'Multilanguage status', '', '', 1, 'status', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 'mod_multilangstatus', 3, 1, '{"layout":"_:default","moduleclass_sfx":"","cache":"0"}', 1, '*');
INSERT INTO `#__modules_menu` SET `moduleid` = LAST_INSERT_ID(), `menuid` = 0;
PK ƄC\z; ;
2.5.25.sqlnu W+A # Placeholder file for database changes for version 2.5.25
PK ƄC\}_ 1.7.4-2011-11-19.sqlnu W+A ALTER TABLE `#__languages` ADD UNIQUE `idx_image` (`image`);
ALTER TABLE `#__languages` ADD UNIQUE `idx_langcode` (`lang_code`);PK ƄC\?ݿw w 2.5.0-2011-12-21-2.sqlnu W+A CREATE TABLE IF NOT EXISTS `#__finder_links_terms0` (
`link_id` int(10) unsigned NOT NULL,
`term_id` int(10) unsigned NOT NULL,
`weight` float unsigned NOT NULL,
PRIMARY KEY (`link_id`,`term_id`),
KEY `idx_term_weight` (`term_id`,`weight`),
KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__finder_links_terms1` (
`link_id` int(10) unsigned NOT NULL,
`term_id` int(10) unsigned NOT NULL,
`weight` float unsigned NOT NULL,
PRIMARY KEY (`link_id`,`term_id`),
KEY `idx_term_weight` (`term_id`,`weight`),
KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__finder_links_terms2` (
`link_id` int(10) unsigned NOT NULL,
`term_id` int(10) unsigned NOT NULL,
`weight` float unsigned NOT NULL,
PRIMARY KEY (`link_id`,`term_id`),
KEY `idx_term_weight` (`term_id`,`weight`),
KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__finder_links_terms3` (
`link_id` int(10) unsigned NOT NULL,
`term_id` int(10) unsigned NOT NULL,
`weight` float unsigned NOT NULL,
PRIMARY KEY (`link_id`,`term_id`),
KEY `idx_term_weight` (`term_id`,`weight`),
KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__finder_links_terms4` (
`link_id` int(10) unsigned NOT NULL,
`term_id` int(10) unsigned NOT NULL,
`weight` float unsigned NOT NULL,
PRIMARY KEY (`link_id`,`term_id`),
KEY `idx_term_weight` (`term_id`,`weight`),
KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__finder_links_terms5` (
`link_id` int(10) unsigned NOT NULL,
`term_id` int(10) unsigned NOT NULL,
`weight` float unsigned NOT NULL,
PRIMARY KEY (`link_id`,`term_id`),
KEY `idx_term_weight` (`term_id`,`weight`),
KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__finder_links_terms6` (
`link_id` int(10) unsigned NOT NULL,
`term_id` int(10) unsigned NOT NULL,
`weight` float unsigned NOT NULL,
PRIMARY KEY (`link_id`,`term_id`),
KEY `idx_term_weight` (`term_id`,`weight`),
KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__finder_links_terms7` (
`link_id` int(10) unsigned NOT NULL,
`term_id` int(10) unsigned NOT NULL,
`weight` float unsigned NOT NULL,
PRIMARY KEY (`link_id`,`term_id`),
KEY `idx_term_weight` (`term_id`,`weight`),
KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__finder_links_terms8` (
`link_id` int(10) unsigned NOT NULL,
`term_id` int(10) unsigned NOT NULL,
`weight` float unsigned NOT NULL,
PRIMARY KEY (`link_id`,`term_id`),
KEY `idx_term_weight` (`term_id`,`weight`),
KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__finder_links_terms9` (
`link_id` int(10) unsigned NOT NULL,
`term_id` int(10) unsigned NOT NULL,
`weight` float unsigned NOT NULL,
PRIMARY KEY (`link_id`,`term_id`),
KEY `idx_term_weight` (`term_id`,`weight`),
KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__finder_links_termsa` (
`link_id` int(10) unsigned NOT NULL,
`term_id` int(10) unsigned NOT NULL,
`weight` float unsigned NOT NULL,
PRIMARY KEY (`link_id`,`term_id`),
KEY `idx_term_weight` (`term_id`,`weight`),
KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__finder_links_termsb` (
`link_id` int(10) unsigned NOT NULL,
`term_id` int(10) unsigned NOT NULL,
`weight` float unsigned NOT NULL,
PRIMARY KEY (`link_id`,`term_id`),
KEY `idx_term_weight` (`term_id`,`weight`),
KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__finder_links_termsc` (
`link_id` int(10) unsigned NOT NULL,
`term_id` int(10) unsigned NOT NULL,
`weight` float unsigned NOT NULL,
PRIMARY KEY (`link_id`,`term_id`),
KEY `idx_term_weight` (`term_id`,`weight`),
KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__finder_links_termsd` (
`link_id` int(10) unsigned NOT NULL,
`term_id` int(10) unsigned NOT NULL,
`weight` float unsigned NOT NULL,
PRIMARY KEY (`link_id`,`term_id`),
KEY `idx_term_weight` (`term_id`,`weight`),
KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__finder_links_termse` (
`link_id` int(10) unsigned NOT NULL,
`term_id` int(10) unsigned NOT NULL,
`weight` float unsigned NOT NULL,
PRIMARY KEY (`link_id`,`term_id`),
KEY `idx_term_weight` (`term_id`,`weight`),
KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__finder_links_termsf` (
`link_id` int(10) unsigned NOT NULL,
`term_id` int(10) unsigned NOT NULL,
`weight` float unsigned NOT NULL,
PRIMARY KEY (`link_id`,`term_id`),
KEY `idx_term_weight` (`term_id`,`weight`),
KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__finder_taxonomy` (
`id` int(10) unsigned NOT NULL auto_increment,
`parent_id` int(10) unsigned NOT NULL default '0',
`title` varchar(255) NOT NULL,
`state` tinyint(1) unsigned NOT NULL default '1',
`access` tinyint(1) unsigned NOT NULL default '0',
`ordering` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `parent_id` (`parent_id`),
KEY `state` (`state`),
KEY `ordering` (`ordering`),
KEY `access` (`access`),
KEY `idx_parent_published` (`parent_id`,`state`,`access`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__finder_taxonomy_map` (
`link_id` int(10) unsigned NOT NULL,
`node_id` int(10) unsigned NOT NULL,
PRIMARY KEY (`link_id`,`node_id`),
KEY `link_id` (`link_id`),
KEY `node_id` (`node_id`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__finder_terms` (
`term_id` int(10) unsigned NOT NULL auto_increment,
`term` varchar(75) NOT NULL,
`stem` varchar(75) NOT NULL,
`common` tinyint(1) unsigned NOT NULL default '0',
`phrase` tinyint(1) unsigned NOT NULL default '0',
`weight` float unsigned NOT NULL default '0',
`soundex` varchar(75) NOT NULL,
`links` int(10) NOT NULL default '0',
PRIMARY KEY (`term_id`),
UNIQUE KEY `idx_term` (`term`),
KEY `idx_term_phrase` (`term`,`phrase`),
KEY `idx_stem_phrase` (`stem`,`phrase`),
KEY `idx_soundex_phrase` (`soundex`,`phrase`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__finder_terms_common` (
`term` varchar(75) NOT NULL,
`language` varchar(3) NOT NULL,
KEY `idx_word_lang` (`term`,`language`),
KEY `idx_lang` (`language`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__finder_tokens` (
`term` varchar(75) NOT NULL,
`stem` varchar(75) NOT NULL,
`common` tinyint(1) unsigned NOT NULL default '0',
`phrase` tinyint(1) unsigned NOT NULL default '0',
`weight` float unsigned NOT NULL default '1',
`context` tinyint(1) unsigned NOT NULL default '2',
KEY `idx_word` (`term`),
KEY `idx_context` (`context`)
) ENGINE=MEMORY DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__finder_tokens_aggregate` (
`term_id` int(10) unsigned NOT NULL,
`map_suffix` char(1) NOT NULL,
`term` varchar(75) NOT NULL,
`stem` varchar(75) NOT NULL,
`common` tinyint(1) unsigned NOT NULL default '0',
`phrase` tinyint(1) unsigned NOT NULL default '0',
`term_weight` float unsigned NOT NULL,
`context` tinyint(1) unsigned NOT NULL default '2',
`context_weight` float unsigned NOT NULL,
`total_weight` float unsigned NOT NULL,
KEY `token` (`term`),
KEY `keyword_id` (`term_id`)
) ENGINE=MEMORY DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__finder_types` (
`id` int(10) unsigned NOT NULL auto_increment,
`title` varchar(100) NOT NULL,
`mime` varchar(100) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `title` (`title`)
) DEFAULT CHARSET=utf8;
PK ƄC\wn5; ;
2.5.22.sqlnu W+A # Placeholder file for database changes for version 2.5.22
PK ƄC\Yɬ 1.7.1-2011-09-15.sqlnu W+A ALTER TABLE `#__categories` MODIFY `description` MEDIUMTEXT;
ALTER TABLE `#__session` MODIFY `data` MEDIUMTEXT;
ALTER TABLE `#__session` MODIFY `session_id` varchar(200);
PK ƄC\( 1.7.1-2011-09-20.sqlnu W+A ALTER TABLE #__redirect_links MODIFY old_url varchar(255);
ALTER TABLE #__redirect_links MODIFY new_url varchar(255);
ALTER TABLE #__categories MODIFY access integer unsigned;
ALTER TABLE #__contact_details MODIFY access integer unsigned;
ALTER TABLE #__extensions MODIFY access integer unsigned;
ALTER TABLE #__menu MODIFY access integer unsigned;
ALTER TABLE #__modules MODIFY access integer unsigned;
ALTER TABLE #__newsfeeds MODIFY access integer unsigned;PK ƄC\ ; ;
2.5.19.sqlnu W+A # Placeholder file for database changes for version 2.5.19
PK ƄC\k$J; ;
2.5.17.sqlnu W+A # Placeholder file for database changes for version 2.5.17
PK ƄC\/OTI I
2.5.10.sqlnu W+A UPDATE `#__extensions` SET `protected` = 0 WHERE `name` = 'mod_banners';
PK ƄC\ϖQi 1.7.3-2011-11-10.sqlnu W+A ALTER TABLE `#__content` CHANGE `alias` `alias` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT 'Deprecated in Joomla! 3.0';
PK ƄC\ & & 2.5.3-2012-03-13.sqlnu W+A # Dummy SQL file to set schema versionPK ƄC\f]u u 2.5.5.sqlnu W+A ALTER TABLE `#__redirect_links` ADD COLUMN `hits` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `comment`;
ALTER TABLE `#__users` ADD COLUMN `lastResetTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Date of last password reset';
ALTER TABLE `#__users` ADD COLUMN `resetCount` int(11) NOT NULL DEFAULT '0' COMMENT 'Count of password resets since lastResetTime';PK ƄC\
1.7.1-2011-09-15-2.sqlnu W+A REPLACE 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
(313, 'mod_multilangstatus', 'module', 'mod_multilangstatus', '', 1, 1, 1, 0, '{"legacy":false,"name":"mod_multilangstatus","type":"module","creationDate":"September 2011","author":"Joomla! Project","copyright":"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.","authorEmail":"admin@joomla.org","authorUrl":"www.joomla.org","version":"1.7.1","description":"MOD_MULTILANGSTATUS_XML_DESCRIPTION","group":""}', '{"cache":"0"}', '', '', 0, '0000-00-00 00:00:00', 0, 0);
PK ńC\T9 9 2.5.6.sqlnu W+A PK ńC\Sͫ9 9 r 2.5.8.sqlnu W+A PK ńC\a 2.5.0-2011-12-22.sqlnu W+A PK ńC\A,Z Z
1.7.3-2011-10-19.sqlnu W+A PK ńC\a 2.5.0-2011-12-19.sqlnu W+A PK ńC\_\ \ 2.5.4-2012-03-19.sqlnu W+A PK ńC\ E 2.5.0-2011-12-21-1.sqlnu W+A PK ńC\= ; ;
n 2.5.21.sqlnu W+A PK ńC\sQ; ;
2.5.26.sqlnu W+A PK ńC\W:
X 2.5.28.sqlnu W+A PK ńC\ mW W f 2.5.0-2011-12-06.sqlnu W+A PK ńC\o.; ;
! 2.5.13.sqlnu W+A PK ƄC\ & & v! 2.5.2-2012-03-05.sqlnu W+A PK ƄC\wa; ;
! 2.5.14.sqlnu W+A PK ƄC\! U" 2.5.4-2012-03-18.sqlnu W+A PK ƄC\lG i' 2.5.0-2011-12-16.sqlnu W+A PK ƄC\5 ( 1.7.0-2011-06-06-2.sqlnu W+A PK ƄC\e ) 2.5.0-2011-12-24.sqlnu W+A PK ƄC\9 9 * 2.5.9.sqlnu W+A PK ƄC\=/ + 2.5.0-2011-12-23.sqlnu W+A PK ƄC\Y7b ^3 2.5.7.sqlnu W+A PK ƄC\Fx; ;
5 2.5.15.sqlnu W+A PK ƄC\Ǯ9: :
6 2.5.12.sqlnu W+A PK ƄC\V
6 index.htmlnu W+A PK ƄC\iX X 6 1.7.1-2011-09-17.sqlnu W+A PK ƄC\$.5^ ^ }7 2.5.0-2012-01-14.sqlnu W+A PK ƄC\2H; ;
8 2.5.27.sqlnu W+A PK ƄC\ ; ;
8 2.5.20.sqlnu W+A PK ƄC\KMۘ 9 1.7.0-2011-06-06.sqlnu W+A PK ƄC\}: :
: 2.5.11.sqlnu W+A PK ƄC\*S; ;
Y; 2.5.16.sqlnu W+A PK ƄC\8; ;
; 2.5.18.sqlnu W+A PK ƄC\S) C< 2.5.1-2012-01-26.sqlnu W+A PK ƄC\H? A 1.7.4-2011-12-12.sqlnu W+A PK ƄC\T D 1.7.4-2011-11-23.sqlnu W+A PK ƄC\o`Q Q F 2.5.0-2012-01-10.sqlnu W+A PK ƄC\6_,; ;
=G 2.5.23.sqlnu W+A PK ƄC\c; ;
G 2.5.24.sqlnu W+A PK ƄC\) 'H .htaccessnu W+A PK ƄC\K@ @ H 2.5.0-2011-12-20.sqlnu W+A PK ƄC\ cJ 1.7.0.sqlnu W+A PK ƄC\vPs s J 1.7.1-2011-09-15-3.sqlnu W+A PK ƄC\ry UK 1.7.3-2011-10-15.sqlnu W+A PK ƄC\H P O 1.7.1-2011-09-15-4.sqlnu W+A PK ƄC\z; ;
Q 2.5.25.sqlnu W+A PK ƄC\}_ hR 1.7.4-2011-11-19.sqlnu W+A PK ƄC\?ݿw w ,S 2.5.0-2011-12-21-2.sqlnu W+A PK ƄC\wn5; ;
s 2.5.22.sqlnu W+A PK ƄC\Yɬ ^t 1.7.1-2011-09-15.sqlnu W+A PK ƄC\( Nu 1.7.1-2011-09-20.sqlnu W+A PK ƄC\ ; ;
^w 2.5.19.sqlnu W+A PK ƄC\k$J; ;
w 2.5.17.sqlnu W+A PK ƄC\/OTI I
Hx 2.5.10.sqlnu W+A PK ƄC\ϖQi x 1.7.3-2011-11-10.sqlnu W+A PK ƄC\ & & y 2.5.3-2012-03-13.sqlnu W+A PK ƄC\f]u u z 2.5.5.sqlnu W+A PK ƄC\
{ 1.7.1-2011-09-15-2.sqlnu W+A PK 9 9 ~