AAAAupdates/index.html 0000666 00000000037 15137206521 0010214 0 ustar 00
updates/.htaccess 0000666 00000000177 15137206521 0010022 0 ustar 00
Order allow,deny
Deny from all
updates/mysql/2.5.6.sql 0000666 00000000071 15137206521 0010553 0 ustar 00 # Placeholder file for database changes for version 2.5.6 updates/mysql/2.5.8.sql 0000666 00000000071 15137206521 0010555 0 ustar 00 # Placeholder file for database changes for version 2.5.8 updates/mysql/2.5.0-2011-12-22.sql 0000666 00000004707 15137206521 0011601 0 ustar 00 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);
updates/mysql/1.7.3-2011-10-19.sql 0000666 00000000132 15137206521 0011575 0 ustar 00 ALTER TABLE `#__languages` ADD COLUMN `sitename` varchar(1024) NOT NULL AFTER `metadesc`;
updates/mysql/2.5.0-2011-12-19.sql 0000666 00000001724 15137206521 0011603 0 ustar 00 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;
updates/mysql/2.5.4-2012-03-19.sql 0000666 00000000534 15137206521 0011606 0 ustar 00 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';
updates/mysql/2.5.0-2011-12-21-1.sql 0000666 00000004343 15137206521 0011732 0 ustar 00 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);
updates/mysql/2.5.21.sql 0000666 00000000073 15137206521 0010632 0 ustar 00 # Placeholder file for database changes for version 2.5.21
updates/mysql/2.5.26.sql 0000666 00000000073 15137206521 0010637 0 ustar 00 # Placeholder file for database changes for version 2.5.26
updates/mysql/2.5.28.sql 0000666 00000000724 15137206521 0010644 0 ustar 00 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);
updates/mysql/2.5.0-2011-12-06.sql 0000666 00000001527 15137206521 0011600 0 ustar 00 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);
updates/mysql/2.5.13.sql 0000666 00000000073 15137206521 0010633 0 ustar 00 # Placeholder file for database changes for version 2.5.13
updates/mysql/2.5.2-2012-03-05.sql 0000666 00000000046 15137206521 0011575 0 ustar 00 # Dummy SQL file to set schema version updates/mysql/2.5.14.sql 0000666 00000000073 15137206521 0010634 0 ustar 00 # Placeholder file for database changes for version 2.5.14
updates/mysql/2.5.4-2012-03-18.sql 0000666 00000002320 15137206521 0011600 0 ustar 00 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);
updates/mysql/2.5.0-2011-12-16.sql 0000666 00000000365 15137206521 0011600 0 ustar 00 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; updates/mysql/1.7.0-2011-06-06-2.sql 0000666 00000000242 15137206521 0011734 0 ustar 00 ALTER TABLE `#__languages` ADD COLUMN `ordering` int(11) NOT NULL default 0 AFTER `published`;
ALTER TABLE `#__languages` ADD INDEX `idx_ordering` (`ordering`);
updates/mysql/2.5.0-2011-12-24.sql 0000666 00000000302 15137206521 0011566 0 ustar 00 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` ); updates/mysql/2.5.9.sql 0000666 00000000071 15137206521 0010556 0 ustar 00 # Placeholder file for database changes for version 2.5.9 updates/mysql/2.5.0-2011-12-23.sql 0000666 00000004030 15137206521 0011567 0 ustar 00 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;
updates/mysql/2.5.7.sql 0000666 00000001010 15137206521 0010546 0 ustar 00 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' );
updates/mysql/2.5.15.sql 0000666 00000000073 15137206521 0010635 0 ustar 00 # Placeholder file for database changes for version 2.5.15
updates/mysql/2.5.12.sql 0000666 00000000072 15137206521 0010631 0 ustar 00 # Placeholder file for database changes for version 2.5.12 updates/mysql/index.html 0000666 00000000037 15137206521 0011361 0 ustar 00
updates/mysql/1.7.1-2011-09-17.sql 0000666 00000000130 15137206521 0011577 0 ustar 00 ALTER TABLE `#__modules` CHANGE `position` `position` VARCHAR( 50 ) NOT NULL DEFAULT ''; updates/mysql/2.5.0-2012-01-14.sql 0000666 00000000136 15137206521 0011571 0 ustar 00 ALTER TABLE `#__languages` CHANGE `sitename` `sitename` VARCHAR( 1024 ) NOT NULL DEFAULT '';
updates/mysql/2.5.27.sql 0000666 00000000073 15137206521 0010640 0 ustar 00 # Placeholder file for database changes for version 2.5.27
updates/mysql/2.5.20.sql 0000666 00000000073 15137206521 0010631 0 ustar 00 # Placeholder file for database changes for version 2.5.20
updates/mysql/1.7.0-2011-06-06.sql 0000666 00000000630 15137206521 0011576 0 ustar 00 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;
updates/mysql/2.5.11.sql 0000666 00000000072 15137206521 0010630 0 ustar 00 # Placeholder file for database changes for version 2.5.11 updates/mysql/2.5.16.sql 0000666 00000000073 15137206521 0010636 0 ustar 00 # Placeholder file for database changes for version 2.5.16
updates/mysql/2.5.18.sql 0000666 00000000073 15137206521 0010640 0 ustar 00 # Placeholder file for database changes for version 2.5.18
updates/mysql/2.5.1-2012-01-26.sql 0000666 00000002403 15137206521 0011574 0 ustar 00 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); updates/mysql/1.7.4-2011-12-12.sql 0000666 00000001360 15137206521 0011575 0 ustar 00 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');
updates/mysql/1.7.4-2011-11-23.sql 0000666 00000000646 15137206521 0011604 0 ustar 00 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';
updates/mysql/2.5.0-2012-01-10.sql 0000666 00000000121 15137206521 0011557 0 ustar 00 ALTER TABLE `#__updates` ADD COLUMN `infourl` text NOT NULL AFTER `detailsurl`;
updates/mysql/2.5.23.sql 0000666 00000000073 15137206521 0010634 0 ustar 00 # Placeholder file for database changes for version 2.5.23
updates/mysql/2.5.24.sql 0000666 00000000073 15137206521 0010635 0 ustar 00 # Placeholder file for database changes for version 2.5.24
updates/mysql/.htaccess 0000666 00000000177 15137206521 0011167 0 ustar 00
Order allow,deny
Deny from all
updates/mysql/2.5.0-2011-12-20.sql 0000666 00000000500 15137206521 0011562 0 ustar 00 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"; updates/mysql/1.7.0.sql 0000666 00000000000 15137206521 0010536 0 ustar 00 updates/mysql/1.7.1-2011-09-15-3.sql 0000666 00000000163 15137206521 0011743 0 ustar 00 UPDATE `#__modules` SET `ordering` = 2 WHERE `position` = 'status' AND `module` = 'mod_status' AND `client_id`=1;
updates/mysql/1.7.3-2011-10-15.sql 0000666 00000001767 15137206521 0011610 0 ustar 00 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 '';
updates/mysql/1.7.1-2011-09-15-4.sql 0000666 00000001035 15137206521 0011743 0 ustar 00 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;
updates/mysql/2.5.25.sql 0000666 00000000073 15137206521 0010636 0 ustar 00 # Placeholder file for database changes for version 2.5.25
updates/mysql/1.7.4-2011-11-19.sql 0000666 00000000200 15137206521 0011573 0 ustar 00 ALTER TABLE `#__languages` ADD UNIQUE `idx_image` (`image`);
ALTER TABLE `#__languages` ADD UNIQUE `idx_langcode` (`lang_code`); updates/mysql/2.5.0-2011-12-21-2.sql 0000666 00000020167 15137206521 0011735 0 ustar 00 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;
updates/mysql/2.5.22.sql 0000666 00000000073 15137206521 0010633 0 ustar 00 # Placeholder file for database changes for version 2.5.22
updates/mysql/1.7.1-2011-09-15.sql 0000666 00000000254 15137206521 0011604 0 ustar 00 ALTER TABLE `#__categories` MODIFY `description` MEDIUMTEXT;
ALTER TABLE `#__session` MODIFY `data` MEDIUMTEXT;
ALTER TABLE `#__session` MODIFY `session_id` varchar(200);
updates/mysql/1.7.1-2011-09-20.sql 0000666 00000000714 15137206521 0011601 0 ustar 00 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; updates/mysql/2.5.19.sql 0000666 00000000073 15137206521 0010641 0 ustar 00 # Placeholder file for database changes for version 2.5.19
updates/mysql/2.5.17.sql 0000666 00000000073 15137206521 0010637 0 ustar 00 # Placeholder file for database changes for version 2.5.17
updates/mysql/2.5.10.sql 0000666 00000000111 15137206521 0010621 0 ustar 00 UPDATE `#__extensions` SET `protected` = 0 WHERE `name` = 'mod_banners';
updates/mysql/1.7.3-2011-11-10.sql 0000666 00000000235 15137206521 0011571 0 ustar 00 ALTER TABLE `#__content` CHANGE `alias` `alias` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT 'Deprecated in Joomla! 3.0';
updates/mysql/2.5.3-2012-03-13.sql 0000666 00000000046 15137206521 0011575 0 ustar 00 # Dummy SQL file to set schema version updates/mysql/2.5.5.sql 0000666 00000000565 15137206521 0010562 0 ustar 00 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'; updates/mysql/1.7.1-2011-09-15-2.sql 0000666 00000001341 15137206521 0011741 0 ustar 00 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);
updates/sqlazure/2.5.12.sql 0000666 00000000072 15137206521 0011332 0 ustar 00 # Placeholder file for database changes for version 2.5.12 updates/sqlazure/2.5.4-2012-03-19.sql 0000666 00000000522 15137206521 0012304 0 ustar 00 ALTER TABLE [#__languages] ADD [access] INTEGER CONSTRAINT DF_languages_access DEFAULT '' NOT NULL
CREATE UNIQUE INDEX idx_access ON [jos_languages] (access);
UPDATE [#__categories] SET extension = 'com_users.notes' WHERE extension = 'com_users';
UPDATE [#__extensions] SET enabled = '1' WHERE protected = '1' AND [type] <> 'plugin';
updates/sqlazure/2.5.15.sql 0000666 00000000073 15137206521 0011336 0 ustar 00 # Placeholder file for database changes for version 2.5.15
updates/sqlazure/index.html 0000666 00000000040 15137206521 0012054 0 ustar 00
updates/sqlazure/.htaccess 0000666 00000000177 15137206521 0011670 0 ustar 00
Order allow,deny
Deny from all
updates/sqlazure/2.5.20.sql 0000666 00000000073 15137206521 0011332 0 ustar 00 # Placeholder file for database changes for version 2.5.20
updates/sqlazure/2.5.27.sql 0000666 00000000073 15137206521 0011341 0 ustar 00 # Placeholder file for database changes for version 2.5.27
updates/sqlazure/2.5.2-2012-03-05.sql 0000666 00000000046 15137206521 0012276 0 ustar 00 # Dummy SQL file to set schema version updates/sqlazure/2.5.26.sql 0000666 00000000073 15137206521 0011340 0 ustar 00 # Placeholder file for database changes for version 2.5.26
updates/sqlazure/2.5.21.sql 0000666 00000000073 15137206521 0011333 0 ustar 00 # Placeholder file for database changes for version 2.5.21
updates/sqlazure/2.5.28.sql 0000666 00000001002 15137206521 0011333 0 ustar 00 ALTER TABLE [#__user_profiles] ALTER COLUMN [profile_value] [nvarchar](max) NOT NULL;
SET IDENTITY_INSERT [#__extensions] ON;
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)
SELECT 900, 'plg_quickicon_eosnotify', 'plugin', 'eosnotify', 'quickicon', 0, 1, 1, 1, '', '{}', '', '', 0, '1900-01-01 00:00:00', 0, 0;
SET IDENTITY_INSERT #__extensions OFF;
updates/sqlazure/2.5.5.sql 0000666 00000000341 15137206521 0011253 0 ustar 00 ALTER TABLE [#__redirect_links] ADD [hits] INTEGER CONSTRAINT DF_redirect_links_hits DEFAULT '' NOT NULL;
ALTER TABLE [#__users] ADD [lastResetTime] [datetime] NOT NULL;
ALTER TABLE [#__users] ADD [resetCount] [int] NOT NULL; updates/sqlazure/2.5.4-2012-03-18.sql 0000666 00000002414 15137206521 0012305 0 ustar 00 SET IDENTITY_INSERT #__extensions ON;
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)
SELECT 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, '1900-01-01 00:00:00', 0, 0;
SET IDENTITY_INSERT #__extensions OFF;
SET IDENTITY_INSERT #__menu ON;
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)
SELECT 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;
SET IDENTITY_INSERT #__menu OFF;
updates/sqlazure/2.5.14.sql 0000666 00000000073 15137206521 0011335 0 ustar 00 # Placeholder file for database changes for version 2.5.14
updates/sqlazure/2.5.13.sql 0000666 00000000073 15137206521 0011334 0 ustar 00 # Placeholder file for database changes for version 2.5.13
updates/sqlazure/2.5.22.sql 0000666 00000000073 15137206521 0011334 0 ustar 00 # Placeholder file for database changes for version 2.5.22
updates/sqlazure/2.5.25.sql 0000666 00000000073 15137206521 0011337 0 ustar 00 # Placeholder file for database changes for version 2.5.25
updates/sqlazure/2.5.6.sql 0000666 00000000071 15137206521 0011254 0 ustar 00 # Placeholder file for database changes for version 2.5.6 updates/sqlazure/2.5.19.sql 0000666 00000000073 15137206521 0011342 0 ustar 00 # Placeholder file for database changes for version 2.5.19
updates/sqlazure/2.5.10.sql 0000666 00000000111 15137206521 0011322 0 ustar 00 UPDATE [#__extensions] SET [protected] = 0 WHERE [name] = 'mod_banners';
updates/sqlazure/2.5.8.sql 0000666 00000000071 15137206521 0011256 0 ustar 00 # Placeholder file for database changes for version 2.5.8 updates/sqlazure/2.5.17.sql 0000666 00000000073 15137206521 0011340 0 ustar 00 # Placeholder file for database changes for version 2.5.17
updates/sqlazure/2.5.9.sql 0000666 00000000071 15137206521 0011257 0 ustar 00 # Placeholder file for database changes for version 2.5.9 updates/sqlazure/2.5.16.sql 0000666 00000000073 15137206521 0011337 0 ustar 00 # Placeholder file for database changes for version 2.5.16
updates/sqlazure/2.5.11.sql 0000666 00000000072 15137206521 0011331 0 ustar 00 # Placeholder file for database changes for version 2.5.11 updates/sqlazure/2.5.7.sql 0000666 00000000757 15137206521 0011270 0 ustar 00 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 (SCOPE_IDENTITY(), 600);
UPDATE [#__assets] SET name=REPLACE( name, 'com_user.notes.category','com_users.category' );
UPDATE [#__assets] SET name=REPLACE( name, 'com_user.notes.category','com_users.category' );
updates/sqlazure/2.5.18.sql 0000666 00000000105 15137206521 0011335 0 ustar 00 ALTER TABLE [#__languages] ADD [access] [bigint] NOT NULL DEFAULT 0;
updates/sqlazure/2.5.24.sql 0000666 00000000073 15137206521 0011336 0 ustar 00 # Placeholder file for database changes for version 2.5.24
updates/sqlazure/2.5.3-2012-03-13.sql 0000666 00000000046 15137206521 0012276 0 ustar 00 # Dummy SQL file to set schema version updates/sqlazure/2.5.23.sql 0000666 00000000073 15137206521 0011335 0 ustar 00 # Placeholder file for database changes for version 2.5.23
index.html 0000666 00000000000 15137206521 0006535 0 ustar 00 .htaccess 0000666 00000000177 15137206521 0006355 0 ustar 00
Order allow,deny
Deny from all
uninstall.mysql.utf8.sql 0000666 00000000046 15137207443 0011341 0 ustar 00 DROP TABLE IF EXISTS `#__newsfeeds`;
install.mysql.utf8.sql 0000666 00000003216 15137207443 0011000 0 ustar 00 CREATE TABLE `#__newsfeeds` (
`catid` integer NOT NULL default '0',
`id` integer(10) UNSIGNED NOT NULL auto_increment,
`name` varchar(100) NOT NULL DEFAULT '',
`alias` varchar(100) NOT NULL default '',
`link` varchar(200) NOT NULL DEFAULT '',
`filename` varchar(200) default NULL,
`published` tinyint(1) NOT NULL default '0',
`numarticles` integer unsigned NOT NULL default '1',
`cache_time` integer unsigned NOT NULL default '3600',
`checked_out` integer(10) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`ordering` integer NOT NULL default '0',
`rtl` tinyint(4) NOT NULL default '0',
`access` tinyint UNSIGNED NOT NULL DEFAULT '0',
`language` char(7) NOT NULL DEFAULT '',
`params` text NOT NULL,
`created` datetime NOT NULL default '0000-00-00 00:00:00',
`created_by` int(10) unsigned NOT NULL default '0',
`created_by_alias` varchar(255) NOT NULL default '',
`modified` datetime NOT NULL default '0000-00-00 00:00:00',
`modified_by` int(10) unsigned NOT NULL default '0',
`metakey` text NOT NULL,
`metadesc` text NOT NULL,
`metadata` text NOT NULL,
`xreference` varchar(50) NOT NULL COMMENT 'A reference to enable linkages to external data sets.',
`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_access` (`access`),
KEY `idx_checkout` (`checked_out`),
KEY `idx_state` (`published`),
KEY `idx_catid` (`catid`),
KEY `idx_createdby` (`created_by`),
KEY `idx_language` (`language`),
KEY `idx_xreference` (`xreference`)
) DEFAULT CHARSET=utf8;
install.chronoforms.sql 0000666 00000001341 15137226122 0011275 0 ustar 00 CREATE TABLE IF NOT EXISTS `#__chronoforms` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`form_type` tinyint(1) NOT NULL,
`content` longtext NOT NULL,
`wizardcode` longtext,
`events_actions_map` longtext,
`params` longtext NOT NULL,
`published` tinyint(1) NOT NULL DEFAULT '1',
`app` varchar(100) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) CHARACTER SET `utf8`;
CREATE TABLE IF NOT EXISTS `#__chronoform_actions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`chronoform_id` int(11) NOT NULL,
`type` varchar(255) NOT NULL,
`enabled` tinyint(1) NOT NULL,
`params` longtext NOT NULL,
`order` int(11) NOT NULL,
`content1` longtext NOT NULL,
PRIMARY KEY (`id`)
) CHARACTER SET `utf8`; uninstall.chronoforms.sql 0000666 00000000124 15137226122 0011636 0 ustar 00 DROP TABLE IF EXISTS `#__chronoforms`;
DROP TABLE IF EXISTS `#__chronoform_actions`; uninstall.sql 0000666 00000000117 15137226151 0007304 0 ustar 00 DROP TABLE `#__unitehcarousel_sliders`;
DROP TABLE `#__unitehcarousel_slides`; install.sql 0000666 00000002121 15137226151 0006736 0 ustar 00 CREATE TABLE IF NOT EXISTS `#__unitehcarousel_sliders` (
`id` int(10) unsigned NOT NULL auto_increment,
`title` varchar(255) NOT NULL,
`alias` varchar(255) NOT NULL default '',
`published` tinyint(1) NOT NULL default '0',
`ordering` int(11) NOT NULL default '0',
`params` text NOT NULL,
`visual` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__unitehcarousel_slides` (
`id` int(10) unsigned NOT NULL auto_increment,
`catid` int(10) unsigned NOT NULL default '0',
`sliderid` int(10) unsigned NOT NULL default '0',
`title` varchar(255) NOT NULL,
`alias` varchar(255) NOT NULL default '',
`image` varchar(255) NOT NULL,
`description` text NOT NULL,
`published` tinyint(1) 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',
`ordering` int(11) NOT NULL default '0',
`params` text NOT NULL,
PRIMARY KEY (`id`),
KEY `catid` (`catid`,`published`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;