AAAAindex.html 0000666 00000000037 15137246535 0006560 0 ustar 00
.htaccess 0000666 00000000177 15137246535 0006366 0 ustar 00
Order allow,deny
Deny from all
mysql/2.5.6.sql 0000666 00000000071 15137246535 0007117 0 ustar 00 # Placeholder file for database changes for version 2.5.6 mysql/2.5.8.sql 0000666 00000000071 15137246535 0007121 0 ustar 00 # Placeholder file for database changes for version 2.5.8 mysql/2.5.0-2011-12-22.sql 0000666 00000004707 15137246535 0010145 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);
mysql/1.7.3-2011-10-19.sql 0000666 00000000132 15137246535 0010141 0 ustar 00 ALTER TABLE `#__languages` ADD COLUMN `sitename` varchar(1024) NOT NULL AFTER `metadesc`;
mysql/2.5.0-2011-12-19.sql 0000666 00000001724 15137246535 0010147 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;
mysql/2.5.4-2012-03-19.sql 0000666 00000000534 15137246535 0010152 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';
mysql/2.5.0-2011-12-21-1.sql 0000666 00000004343 15137246535 0010276 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);
mysql/2.5.21.sql 0000666 00000000073 15137246535 0007176 0 ustar 00 # Placeholder file for database changes for version 2.5.21
mysql/2.5.26.sql 0000666 00000000073 15137246535 0007203 0 ustar 00 # Placeholder file for database changes for version 2.5.26
mysql/2.5.28.sql 0000666 00000000724 15137246535 0007210 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);
mysql/2.5.0-2011-12-06.sql 0000666 00000001527 15137246535 0010144 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);
mysql/2.5.13.sql 0000666 00000000073 15137246535 0007177 0 ustar 00 # Placeholder file for database changes for version 2.5.13
mysql/2.5.2-2012-03-05.sql 0000666 00000000046 15137246535 0010141 0 ustar 00 # Dummy SQL file to set schema version mysql/2.5.14.sql 0000666 00000000073 15137246535 0007200 0 ustar 00 # Placeholder file for database changes for version 2.5.14
mysql/2.5.4-2012-03-18.sql 0000666 00000002320 15137246535 0010144 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);
mysql/2.5.0-2011-12-16.sql 0000666 00000000365 15137246535 0010144 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; mysql/1.7.0-2011-06-06-2.sql 0000666 00000000242 15137246535 0010300 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`);
mysql/2.5.0-2011-12-24.sql 0000666 00000000302 15137246535 0010132 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` ); mysql/2.5.9.sql 0000666 00000000071 15137246535 0007122 0 ustar 00 # Placeholder file for database changes for version 2.5.9 mysql/2.5.0-2011-12-23.sql 0000666 00000004030 15137246535 0010133 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;
mysql/2.5.7.sql 0000666 00000001010 15137246535 0007112 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' );
mysql/2.5.15.sql 0000666 00000000073 15137246535 0007201 0 ustar 00 # Placeholder file for database changes for version 2.5.15
mysql/2.5.12.sql 0000666 00000000072 15137246535 0007175 0 ustar 00 # Placeholder file for database changes for version 2.5.12 mysql/index.html 0000666 00000000037 15137246535 0007725 0 ustar 00
mysql/1.7.1-2011-09-17.sql 0000666 00000000130 15137246535 0010143 0 ustar 00 ALTER TABLE `#__modules` CHANGE `position` `position` VARCHAR( 50 ) NOT NULL DEFAULT ''; mysql/2.5.0-2012-01-14.sql 0000666 00000000136 15137246535 0010135 0 ustar 00 ALTER TABLE `#__languages` CHANGE `sitename` `sitename` VARCHAR( 1024 ) NOT NULL DEFAULT '';
mysql/2.5.27.sql 0000666 00000000073 15137246535 0007204 0 ustar 00 # Placeholder file for database changes for version 2.5.27
mysql/2.5.20.sql 0000666 00000000073 15137246535 0007175 0 ustar 00 # Placeholder file for database changes for version 2.5.20
mysql/1.7.0-2011-06-06.sql 0000666 00000000630 15137246535 0010142 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;
mysql/2.5.11.sql 0000666 00000000072 15137246535 0007174 0 ustar 00 # Placeholder file for database changes for version 2.5.11 mysql/2.5.16.sql 0000666 00000000073 15137246535 0007202 0 ustar 00 # Placeholder file for database changes for version 2.5.16
mysql/2.5.18.sql 0000666 00000000073 15137246535 0007204 0 ustar 00 # Placeholder file for database changes for version 2.5.18
mysql/2.5.1-2012-01-26.sql 0000666 00000002403 15137246535 0010140 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); mysql/1.7.4-2011-12-12.sql 0000666 00000001360 15137246535 0010141 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');
mysql/1.7.4-2011-11-23.sql 0000666 00000000646 15137246535 0010150 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';
mysql/2.5.0-2012-01-10.sql 0000666 00000000121 15137246535 0010123 0 ustar 00 ALTER TABLE `#__updates` ADD COLUMN `infourl` text NOT NULL AFTER `detailsurl`;
mysql/2.5.23.sql 0000666 00000000073 15137246535 0007200 0 ustar 00 # Placeholder file for database changes for version 2.5.23
mysql/2.5.24.sql 0000666 00000000073 15137246535 0007201 0 ustar 00 # Placeholder file for database changes for version 2.5.24
mysql/.htaccess 0000666 00000000177 15137246535 0007533 0 ustar 00
Order allow,deny
Deny from all
mysql/2.5.0-2011-12-20.sql 0000666 00000000500 15137246535 0010126 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"; mysql/1.7.0.sql 0000666 00000000000 15137246535 0007102 0 ustar 00 mysql/1.7.1-2011-09-15-3.sql 0000666 00000000163 15137246535 0010307 0 ustar 00 UPDATE `#__modules` SET `ordering` = 2 WHERE `position` = 'status' AND `module` = 'mod_status' AND `client_id`=1;
mysql/1.7.3-2011-10-15.sql 0000666 00000001767 15137246535 0010154 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 '';
mysql/1.7.1-2011-09-15-4.sql 0000666 00000001035 15137246535 0010307 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;
mysql/2.5.25.sql 0000666 00000000073 15137246535 0007202 0 ustar 00 # Placeholder file for database changes for version 2.5.25
mysql/1.7.4-2011-11-19.sql 0000666 00000000200 15137246535 0010137 0 ustar 00 ALTER TABLE `#__languages` ADD UNIQUE `idx_image` (`image`);
ALTER TABLE `#__languages` ADD UNIQUE `idx_langcode` (`lang_code`); mysql/2.5.0-2011-12-21-2.sql 0000666 00000020167 15137246535 0010301 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;
mysql/2.5.22.sql 0000666 00000000073 15137246535 0007177 0 ustar 00 # Placeholder file for database changes for version 2.5.22
mysql/1.7.1-2011-09-15.sql 0000666 00000000254 15137246535 0010150 0 ustar 00 ALTER TABLE `#__categories` MODIFY `description` MEDIUMTEXT;
ALTER TABLE `#__session` MODIFY `data` MEDIUMTEXT;
ALTER TABLE `#__session` MODIFY `session_id` varchar(200);
mysql/1.7.1-2011-09-20.sql 0000666 00000000714 15137246535 0010145 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; mysql/2.5.19.sql 0000666 00000000073 15137246535 0007205 0 ustar 00 # Placeholder file for database changes for version 2.5.19
mysql/2.5.17.sql 0000666 00000000073 15137246535 0007203 0 ustar 00 # Placeholder file for database changes for version 2.5.17
mysql/2.5.10.sql 0000666 00000000111 15137246535 0007165 0 ustar 00 UPDATE `#__extensions` SET `protected` = 0 WHERE `name` = 'mod_banners';
mysql/1.7.3-2011-11-10.sql 0000666 00000000235 15137246535 0010135 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';
mysql/2.5.3-2012-03-13.sql 0000666 00000000046 15137246535 0010141 0 ustar 00 # Dummy SQL file to set schema version mysql/2.5.5.sql 0000666 00000000565 15137246535 0007126 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'; mysql/1.7.1-2011-09-15-2.sql 0000666 00000001341 15137246535 0010305 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);
sqlazure/2.5.12.sql 0000666 00000000072 15137246535 0007676 0 ustar 00 # Placeholder file for database changes for version 2.5.12 sqlazure/2.5.4-2012-03-19.sql 0000666 00000000522 15137246535 0010650 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';
sqlazure/2.5.15.sql 0000666 00000000073 15137246535 0007702 0 ustar 00 # Placeholder file for database changes for version 2.5.15
sqlazure/index.html 0000666 00000000040 15137246535 0010420 0 ustar 00
sqlazure/.htaccess 0000666 00000000177 15137246535 0010234 0 ustar 00
Order allow,deny
Deny from all
sqlazure/2.5.20.sql 0000666 00000000073 15137246535 0007676 0 ustar 00 # Placeholder file for database changes for version 2.5.20
sqlazure/2.5.27.sql 0000666 00000000073 15137246535 0007705 0 ustar 00 # Placeholder file for database changes for version 2.5.27
sqlazure/2.5.2-2012-03-05.sql 0000666 00000000046 15137246535 0010642 0 ustar 00 # Dummy SQL file to set schema version sqlazure/2.5.26.sql 0000666 00000000073 15137246535 0007704 0 ustar 00 # Placeholder file for database changes for version 2.5.26
sqlazure/2.5.21.sql 0000666 00000000073 15137246535 0007677 0 ustar 00 # Placeholder file for database changes for version 2.5.21
sqlazure/2.5.28.sql 0000666 00000001002 15137246535 0007677 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;
sqlazure/2.5.5.sql 0000666 00000000341 15137246535 0007617 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; sqlazure/2.5.4-2012-03-18.sql 0000666 00000002414 15137246535 0010651 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;
sqlazure/2.5.14.sql 0000666 00000000073 15137246535 0007701 0 ustar 00 # Placeholder file for database changes for version 2.5.14
sqlazure/2.5.13.sql 0000666 00000000073 15137246535 0007700 0 ustar 00 # Placeholder file for database changes for version 2.5.13
sqlazure/2.5.22.sql 0000666 00000000073 15137246535 0007700 0 ustar 00 # Placeholder file for database changes for version 2.5.22
sqlazure/2.5.25.sql 0000666 00000000073 15137246535 0007703 0 ustar 00 # Placeholder file for database changes for version 2.5.25
sqlazure/2.5.6.sql 0000666 00000000071 15137246535 0007620 0 ustar 00 # Placeholder file for database changes for version 2.5.6 sqlazure/2.5.19.sql 0000666 00000000073 15137246535 0007706 0 ustar 00 # Placeholder file for database changes for version 2.5.19
sqlazure/2.5.10.sql 0000666 00000000111 15137246535 0007666 0 ustar 00 UPDATE [#__extensions] SET [protected] = 0 WHERE [name] = 'mod_banners';
sqlazure/2.5.8.sql 0000666 00000000071 15137246535 0007622 0 ustar 00 # Placeholder file for database changes for version 2.5.8 sqlazure/2.5.17.sql 0000666 00000000073 15137246535 0007704 0 ustar 00 # Placeholder file for database changes for version 2.5.17
sqlazure/2.5.9.sql 0000666 00000000071 15137246535 0007623 0 ustar 00 # Placeholder file for database changes for version 2.5.9 sqlazure/2.5.16.sql 0000666 00000000073 15137246535 0007703 0 ustar 00 # Placeholder file for database changes for version 2.5.16
sqlazure/2.5.11.sql 0000666 00000000072 15137246535 0007675 0 ustar 00 # Placeholder file for database changes for version 2.5.11 sqlazure/2.5.7.sql 0000666 00000000757 15137246535 0007634 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' );
sqlazure/2.5.18.sql 0000666 00000000105 15137246535 0007701 0 ustar 00 ALTER TABLE [#__languages] ADD [access] [bigint] NOT NULL DEFAULT 0;
sqlazure/2.5.24.sql 0000666 00000000073 15137246535 0007702 0 ustar 00 # Placeholder file for database changes for version 2.5.24
sqlazure/2.5.3-2012-03-13.sql 0000666 00000000046 15137246535 0010642 0 ustar 00 # Dummy SQL file to set schema version sqlazure/2.5.23.sql 0000666 00000000073 15137246535 0007701 0 ustar 00 # Placeholder file for database changes for version 2.5.23
mysql/1.20.0.sql 0000666 00000001102 15137561201 0007147 0 ustar 00 /* enable module, set position to 'status', hide title and put module as last in status container */
UPDATE #__modules
SET position = 'menu'
, published = 1
, showtitle = 0
, ordering = 99
WHERE module = 'mod_jumenu'
AND client_id = 1;
/* show module for all menus in adminstrator */
INSERT INTO #__modules_menu (moduleid, menuid)
SELECT #__modules.id, 0
FROM #__modules
WHERE #__modules.module = 'mod_jumenu'
AND #__modules.position = 'menu'
AND NOT EXISTS (SELECT 1 FROM #__modules_menu WHERE moduleid = #__modules.id)
ORDER BY id DESC
LIMIT 1;
mysql/4.1.sql 0000666 00000000146 15140001165 0006732 0 ustar 00 ALTER TABLE `#__csvi_replacements` ADD COLUMN `multivalue` ENUM('0','1') NOT NULL AFTER `replacetext`; mysql/5.11.sql 0000666 00000010033 15140001165 0007010 0 ustar 00 CREATE TABLE IF NOT EXISTS `#__csvi_mapheaders` (
`id` INT(10) NOT NULL AUTO_INCREMENT,
`map_id` INT(10) NOT NULL,
`csvheader` VARCHAR(100) NOT NULL,
`templateheader` VARCHAR(100) NOT NULL,
PRIMARY KEY (`id`)
) COMMENT='Contains the mapped fields';
CREATE TABLE IF NOT EXISTS `#__csvi_maps` (
`id` INT(10) NOT NULL AUTO_INCREMENT,
`name` VARCHAR(100) NULL DEFAULT NULL,
`mapfile` VARCHAR(100) NULL DEFAULT NULL,
`action` VARCHAR(100) NULL DEFAULT NULL,
`component` VARCHAR(100) NULL DEFAULT NULL,
`operation` VARCHAR(100) NULL DEFAULT NULL,
`checked_out` INT(10) NULL DEFAULT NULL,
`checked_out_time` DATETIME NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) COMMENT='Holds map configurations';
CREATE TABLE IF NOT EXISTS `#__csvi_template_fields` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique ID for the template field',
`template_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'The template ID',
`ordering` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'The order of the field',
`field_name` varchar(255) NOT NULL COMMENT 'Name for the field',
`column_header` varchar(255) NOT NULL DEFAULT '' COMMENT 'Header for the column',
`default_value` varchar(255) NOT NULL DEFAULT '' COMMENT 'Default value for the field',
`process` enum('0','1') NOT NULL DEFAULT '1' COMMENT 'Process the field',
`combine` ENUM('0','1') NOT NULL DEFAULT '0' COMMENT 'Combine the field',
`sort` enum('0','1') NOT NULL DEFAULT '0' COMMENT 'Sort the field',
PRIMARY KEY (`id`)
) CHARSET=utf8 COMMENT='Holds the fields for a CSVI template';
CREATE TABLE IF NOT EXISTS `#__csvi_related_categories` (
`product_sku` VARCHAR(64) NOT NULL,
`related_cat` TEXT NOT NULL
) COMMENT='Related categories import for CSVI';
ALTER TABLE `#__csvi_replacements`
ADD COLUMN `ordering` INT(11) NOT NULL DEFAULT '0' AFTER `method`;
ALTER TABLE `#__csvi_template_fields`
ADD COLUMN `file_field_name` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'Name for the field from the file' AFTER `field_name`;
ALTER TABLE `#__csvi_template_fields`
ADD COLUMN `template_field_name` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'Name for the field from the template' AFTER `file_field_name`;
ALTER TABLE `#__csvi_template_fields`
ADD COLUMN `cdata` ENUM('0','1') NOT NULL DEFAULT '1' COMMENT 'Use the CDATA tag' AFTER `sort`;
ALTER TABLE `#__csvi_template_fields`
ADD COLUMN `combine_char` VARCHAR(5) NOT NULL DEFAULT '' COMMENT 'The character(s) to combine the fields' AFTER `combine`;
CREATE TABLE IF NOT EXISTS `#__csvi_template_fields_combine` (
`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Unique ID for the cross reference',
`field_id` VARCHAR(255) NOT NULL COMMENT 'ID of the field',
`combine_id` VARCHAR(255) NOT NULL COMMENT 'ID of the field to combine',
PRIMARY KEY (`id`)
) COMMENT='Holds the replacement cross reference for a CSVI template field';
CREATE TABLE IF NOT EXISTS `#__csvi_template_fields_replacement` (
`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Unique ID for the cross reference',
`field_id` VARCHAR(255) NOT NULL COMMENT 'ID of the field',
`replace_id` VARCHAR(255) NOT NULL COMMENT 'ID of the replacement rule',
PRIMARY KEY (`id`)
) COMMENT='Holds the replacement cross reference for a CSVI template field';
CREATE TABLE IF NOT EXISTS `#__csvi_template_settings` (
`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Unique ID for the saved setting',
`name` VARCHAR(255) NOT NULL COMMENT 'Name for the saved setting',
`settings` TEXT NOT NULL COMMENT 'The actual settings',
`process` ENUM('import','export') NOT NULL DEFAULT 'import' COMMENT 'The type of template',
PRIMARY KEY (`id`)
) COMMENT='Stores the template settings for CSVI';
ALTER TABLE `#__csvi_template_types`
ADD COLUMN `published` TINYINT(1) NOT NULL DEFAULT '1' AFTER `options`,
ADD COLUMN `ordering` INT(11) NULL DEFAULT NULL AFTER `published`;
ALTER TABLE `#__csvi_template_settings`
ADD COLUMN `process` ENUM('import','export') NOT NULL DEFAULT 'import' COMMENT 'The type of template' AFTER `settings`; mysql/4.5.1.sql 0000666 00000000000 15140001165 0007062 0 ustar 00 mysql/4.4.sql 0000666 00000000000 15140001165 0006722 0 ustar 00