AAAAPK
B\V updates/index.htmlnu W+A
PK
B\) updates/.htaccessnu W+A
Order allow,deny
Deny from all
PK
B\T9 9 updates/mysql/2.5.6.sqlnu W+A # Placeholder file for database changes for version 2.5.6PK
B\Sͫ9 9 updates/mysql/2.5.8.sqlnu W+A # Placeholder file for database changes for version 2.5.8PK
B\a " updates/mysql/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
B\A,Z Z " updates/mysql/1.7.3-2011-10-19.sqlnu W+A ALTER TABLE `#__languages` ADD COLUMN `sitename` varchar(1024) NOT NULL AFTER `metadesc`;
PK
B\a " updates/mysql/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
B\_\ \ " updates/mysql/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
B\ $ updates/mysql/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
B\= ; ; updates/mysql/2.5.21.sqlnu W+A # Placeholder file for database changes for version 2.5.21
PK
B\sQ; ; updates/mysql/2.5.26.sqlnu W+A # Placeholder file for database changes for version 2.5.26
PK
B\W: updates/mysql/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
B\ mW W " updates/mysql/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
B\o.; ; updates/mysql/2.5.13.sqlnu W+A # Placeholder file for database changes for version 2.5.13
PK
B\ & & " updates/mysql/2.5.2-2012-03-05.sqlnu W+A # Dummy SQL file to set schema versionPK
B\wa; ; updates/mysql/2.5.14.sqlnu W+A # Placeholder file for database changes for version 2.5.14
PK
B\! " updates/mysql/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
B\lG " updates/mysql/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
B\5 $ updates/mysql/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
B\e " updates/mysql/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
B\9 9 updates/mysql/2.5.9.sqlnu W+A # Placeholder file for database changes for version 2.5.9PK
B\=/ " updates/mysql/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
B\Y7b updates/mysql/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
B\Fx; ; updates/mysql/2.5.15.sqlnu W+A # Placeholder file for database changes for version 2.5.15
PK
B\Ǯ9: : updates/mysql/2.5.12.sqlnu W+A # Placeholder file for database changes for version 2.5.12PK
B\V updates/mysql/index.htmlnu W+A
PK
B\iX X " updates/mysql/1.7.1-2011-09-17.sqlnu W+A ALTER TABLE `#__modules` CHANGE `position` `position` VARCHAR( 50 ) NOT NULL DEFAULT '';PK
B\$.5^ ^ " updates/mysql/2.5.0-2012-01-14.sqlnu W+A ALTER TABLE `#__languages` CHANGE `sitename` `sitename` VARCHAR( 1024 ) NOT NULL DEFAULT '';
PK
B\2H; ; updates/mysql/2.5.27.sqlnu W+A # Placeholder file for database changes for version 2.5.27
PK
B\ ; ; updates/mysql/2.5.20.sqlnu W+A # Placeholder file for database changes for version 2.5.20
PK
B\KMۘ " updates/mysql/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
B\}: : updates/mysql/2.5.11.sqlnu W+A # Placeholder file for database changes for version 2.5.11PK
B\*S; ; updates/mysql/2.5.16.sqlnu W+A # Placeholder file for database changes for version 2.5.16
PK
B\8; ; updates/mysql/2.5.18.sqlnu W+A # Placeholder file for database changes for version 2.5.18
PK
B\S) " updates/mysql/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
B\H? " updates/mysql/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
B\T " updates/mysql/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
B\o`Q Q " updates/mysql/2.5.0-2012-01-10.sqlnu W+A ALTER TABLE `#__updates` ADD COLUMN `infourl` text NOT NULL AFTER `detailsurl`;
PK
B\6_,; ; updates/mysql/2.5.23.sqlnu W+A # Placeholder file for database changes for version 2.5.23
PK
B\c; ; updates/mysql/2.5.24.sqlnu W+A # Placeholder file for database changes for version 2.5.24
PK
B\) updates/mysql/.htaccessnu W+A
Order allow,deny
Deny from all
PK
B\K@ @ " updates/mysql/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
B\ updates/mysql/1.7.0.sqlnu W+A PK
B\vPs s $ updates/mysql/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
B\ry " updates/mysql/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
B\H P $ updates/mysql/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
B\z; ; updates/mysql/2.5.25.sqlnu W+A # Placeholder file for database changes for version 2.5.25
PK
B\}_ " updates/mysql/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
B\?ݿw w $ updates/mysql/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
B\wn5; ; updates/mysql/2.5.22.sqlnu W+A # Placeholder file for database changes for version 2.5.22
PK
B\Yɬ " updates/mysql/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
B\( " updates/mysql/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
B\ ; ; updates/mysql/2.5.19.sqlnu W+A # Placeholder file for database changes for version 2.5.19
PK
B\k$J; ; updates/mysql/2.5.17.sqlnu W+A # Placeholder file for database changes for version 2.5.17
PK
B\/OTI I updates/mysql/2.5.10.sqlnu W+A UPDATE `#__extensions` SET `protected` = 0 WHERE `name` = 'mod_banners';
PK
B\ϖQi " updates/mysql/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
B\ & & " updates/mysql/2.5.3-2012-03-13.sqlnu W+A # Dummy SQL file to set schema versionPK
B\f]u u updates/mysql/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
B\
$ updates/mysql/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
B\Ǯ9: : updates/sqlazure/2.5.12.sqlnu W+A # Placeholder file for database changes for version 2.5.12PK
B\'qR R % updates/sqlazure/2.5.4-2012-03-19.sqlnu W+A 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';
PK
B\Fx; ; updates/sqlazure/2.5.15.sqlnu W+A # Placeholder file for database changes for version 2.5.15
PK
B\߄B updates/sqlazure/index.htmlnu W+A
PK
B\) updates/sqlazure/.htaccessnu W+A
Order allow,deny
Deny from all
PK
B\ ; ; updates/sqlazure/2.5.20.sqlnu W+A # Placeholder file for database changes for version 2.5.20
PK
B\2H; ; updates/sqlazure/2.5.27.sqlnu W+A # Placeholder file for database changes for version 2.5.27
PK
B\ & & % updates/sqlazure/2.5.2-2012-03-05.sqlnu W+A # Dummy SQL file to set schema versionPK
B\sQ; ; updates/sqlazure/2.5.26.sqlnu W+A # Placeholder file for database changes for version 2.5.26
PK
B\= ; ; updates/sqlazure/2.5.21.sqlnu W+A # Placeholder file for database changes for version 2.5.21
PK
B\ updates/sqlazure/2.5.28.sqlnu W+A 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;
PK
B\Ԍ@ updates/sqlazure/2.5.5.sqlnu W+A 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;PK
B\:d % updates/sqlazure/2.5.4-2012-03-18.sqlnu W+A 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;
PK
B\wa; ; updates/sqlazure/2.5.14.sqlnu W+A # Placeholder file for database changes for version 2.5.14
PK
B\o.; ; updates/sqlazure/2.5.13.sqlnu W+A # Placeholder file for database changes for version 2.5.13
PK
B\wn5; ; updates/sqlazure/2.5.22.sqlnu W+A # Placeholder file for database changes for version 2.5.22
PK
B\z; ; updates/sqlazure/2.5.25.sqlnu W+A # Placeholder file for database changes for version 2.5.25
PK
B\T9 9 updates/sqlazure/2.5.6.sqlnu W+A # Placeholder file for database changes for version 2.5.6PK
B\ ; ; updates/sqlazure/2.5.19.sqlnu W+A # Placeholder file for database changes for version 2.5.19
PK
B\I$}I I updates/sqlazure/2.5.10.sqlnu W+A UPDATE [#__extensions] SET [protected] = 0 WHERE [name] = 'mod_banners';
PK
B\Sͫ9 9 updates/sqlazure/2.5.8.sqlnu W+A # Placeholder file for database changes for version 2.5.8PK
B\k$J; ; updates/sqlazure/2.5.17.sqlnu W+A # Placeholder file for database changes for version 2.5.17
PK
B\9 9 updates/sqlazure/2.5.9.sqlnu W+A # Placeholder file for database changes for version 2.5.9PK
B\*S; ; updates/sqlazure/2.5.16.sqlnu W+A # Placeholder file for database changes for version 2.5.16
PK
B\}: : updates/sqlazure/2.5.11.sqlnu W+A # Placeholder file for database changes for version 2.5.11PK
B\T updates/sqlazure/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 (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' );
PK
B\`-E E updates/sqlazure/2.5.18.sqlnu W+A ALTER TABLE [#__languages] ADD [access] [bigint] NOT NULL DEFAULT 0;
PK
B\c; ; updates/sqlazure/2.5.24.sqlnu W+A # Placeholder file for database changes for version 2.5.24
PK
B\ & & % updates/sqlazure/2.5.3-2012-03-13.sqlnu W+A # Dummy SQL file to set schema versionPK
B\6_,; ; updates/sqlazure/2.5.23.sqlnu W+A # Placeholder file for database changes for version 2.5.23
PK
B\V
index.htmlnu W+A
PK
B\) .htaccessnu W+A
Order allow,deny
Deny from all
PK sCB\yg install.mysql.utf8.sqlnu W+A CREATE TABLE IF NOT EXISTS `#__weblinks` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`catid` int(11) NOT NULL DEFAULT '0',
`sid` int(11) NOT NULL DEFAULT '0',
`title` varchar(250) NOT NULL DEFAULT '',
`alias` varchar(255) NOT NULL DEFAULT '',
`url` varchar(250) NOT NULL DEFAULT '',
`description` text NOT NULL,
`date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`hits` int(11) NOT NULL DEFAULT '0',
`state` tinyint(1) NOT NULL DEFAULT '0',
`checked_out` int(11) NOT NULL DEFAULT '0',
`checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`ordering` int(11) NOT NULL DEFAULT '0',
`archived` tinyint(1) NOT NULL DEFAULT '0',
`approved` tinyint(1) NOT NULL DEFAULT '1',
`access` int(11) NOT NULL DEFAULT '1',
`params` text NOT NULL,
`language` char(7) NOT NULL DEFAULT '',
`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,
`featured` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Set if link is featured.',
`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` (`state`),
KEY `idx_catid` (`catid`),
KEY `idx_createdby` (`created_by`),
KEY `idx_featured_catid` (`featured`,`catid`),
KEY `idx_language` (`language`),
KEY `idx_xreference` (`xreference`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
PK sCB\ Œ# # uninstall.mysql.utf8.sqlnu W+A DROP TABLE IF EXISTS `#__weblinks`;PK 6jB\_~ install.chronoforms.sqlnu W+A 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`;PK 6jB\`T T uninstall.chronoforms.sqlnu W+A DROP TABLE IF EXISTS `#__chronoforms`;
DROP TABLE IF EXISTS `#__chronoform_actions`;PK
B\V updates/index.htmlnu W+A PK
B\) a updates/.htaccessnu W+A PK
B\T9 9 ! updates/mysql/2.5.6.sqlnu W+A PK
B\Sͫ9 9 updates/mysql/2.5.8.sqlnu W+A PK
B\a " ! updates/mysql/2.5.0-2011-12-22.sqlnu W+A PK
B\A,Z Z " : updates/mysql/1.7.3-2011-10-19.sqlnu W+A PK
B\a " updates/mysql/2.5.0-2011-12-19.sqlnu W+A PK
B\_\ \ " updates/mysql/2.5.4-2012-03-19.sqlnu W+A PK
B\ $ updates/mysql/2.5.0-2011-12-21-1.sqlnu W+A PK
B\= ; ; updates/mysql/2.5.21.sqlnu W+A PK
B\sQ; ; t updates/mysql/2.5.26.sqlnu W+A PK
B\W: updates/mysql/2.5.28.sqlnu W+A PK
B\ mW W " updates/mysql/2.5.0-2011-12-06.sqlnu W+A PK
B\o.; ; " updates/mysql/2.5.13.sqlnu W+A PK
B\ & & " ?# updates/mysql/2.5.2-2012-03-05.sqlnu W+A PK
B\wa; ; # updates/mysql/2.5.14.sqlnu W+A PK
B\! " :$ updates/mysql/2.5.4-2012-03-18.sqlnu W+A PK
B\lG " \) updates/mysql/2.5.0-2011-12-16.sqlnu W+A PK
B\5 $ * updates/mysql/1.7.0-2011-06-06-2.sqlnu W+A PK
B\e " + updates/mysql/2.5.0-2011-12-24.sqlnu W+A PK
B\9 9 , updates/mysql/2.5.9.sqlnu W+A PK
B\=/ " -- updates/mysql/2.5.0-2011-12-23.sqlnu W+A PK
B\Y7b 5 updates/mysql/2.5.7.sqlnu W+A PK
B\Fx; ; 7 updates/mysql/2.5.15.sqlnu W+A PK
B\Ǯ9: : i8 updates/mysql/2.5.12.sqlnu W+A PK
B\V 8 updates/mysql/index.htmlnu W+A PK
B\iX X " R9 updates/mysql/1.7.1-2011-09-17.sqlnu W+A PK
B\$.5^ ^ " 9 updates/mysql/2.5.0-2012-01-14.sqlnu W+A PK
B\2H; ; : updates/mysql/2.5.27.sqlnu W+A PK
B\ ; ; /; updates/mysql/2.5.20.sqlnu W+A PK
B\KMۘ " ; updates/mysql/1.7.0-2011-06-06.sqlnu W+A PK
B\}: : = updates/mysql/2.5.11.sqlnu W+A PK
B\*S; ; > updates/mysql/2.5.16.sqlnu W+A PK
B\8; ; > updates/mysql/2.5.18.sqlnu W+A PK
B\S) " $? updates/mysql/2.5.1-2012-01-26.sqlnu W+A PK
B\H? " yD updates/mysql/1.7.4-2011-12-12.sqlnu W+A PK
B\T " G updates/mysql/1.7.4-2011-11-23.sqlnu W+A PK
B\o`Q Q " I updates/mysql/2.5.0-2012-01-10.sqlnu W+A PK
B\6_,; ; VJ updates/mysql/2.5.23.sqlnu W+A PK
B\c; ; J updates/mysql/2.5.24.sqlnu W+A PK
B\) \K updates/mysql/.htaccessnu W+A PK
B\K@ @ " "L updates/mysql/2.5.0-2011-12-20.sqlnu W+A PK
B\ M updates/mysql/1.7.0.sqlnu W+A PK
B\vPs s $ M updates/mysql/1.7.1-2011-09-15-3.sqlnu W+A PK
B\ry " N updates/mysql/1.7.3-2011-10-15.sqlnu W+A PK
B\H P $ S updates/mysql/1.7.1-2011-09-15-4.sqlnu W+A PK
B\z; ; |U updates/mysql/2.5.25.sqlnu W+A PK
B\}_ " U updates/mysql/1.7.4-2011-11-19.sqlnu W+A PK
B\?ݿw w $ V updates/mysql/2.5.0-2011-12-21-2.sqlnu W+A PK
B\wn5; ; w updates/mysql/2.5.22.sqlnu W+A PK
B\Yɬ " x updates/mysql/1.7.1-2011-09-15.sqlnu W+A PK
B\( " y updates/mysql/1.7.1-2011-09-20.sqlnu W+A PK
B\ ; ; ;{ updates/mysql/2.5.19.sqlnu W+A PK
B\k$J; ; { updates/mysql/2.5.17.sqlnu W+A PK
B\/OTI I A| updates/mysql/2.5.10.sqlnu W+A PK
B\ϖQi " | updates/mysql/1.7.3-2011-11-10.sqlnu W+A PK
B\ & & " } updates/mysql/2.5.3-2012-03-13.sqlnu W+A PK
B\f]u u 9~ updates/mysql/2.5.5.sqlnu W+A PK
B\
$ updates/mysql/1.7.1-2011-09-15-2.sqlnu W+A PK
B\Ǯ9: : * updates/sqlazure/2.5.12.sqlnu W+A PK
B\'qR R % updates/sqlazure/2.5.4-2012-03-19.sqlnu W+A PK
B\Fx; ; V updates/sqlazure/2.5.15.sqlnu W+A PK
B\߄B ܅ updates/sqlazure/index.htmlnu W+A PK
B\) G updates/sqlazure/.htaccessnu W+A PK
B\ ; ; updates/sqlazure/2.5.20.sqlnu W+A PK
B\2H; ; updates/sqlazure/2.5.27.sqlnu W+A PK
B\ & & % updates/sqlazure/2.5.2-2012-03-05.sqlnu W+A PK
B\sQ; ; updates/sqlazure/2.5.26.sqlnu W+A PK
B\= ; ; updates/sqlazure/2.5.21.sqlnu W+A PK
B\ updates/sqlazure/2.5.28.sqlnu W+A PK
B\Ԍ@ updates/sqlazure/2.5.5.sqlnu W+A PK
B\:d % updates/sqlazure/2.5.4-2012-03-18.sqlnu W+A PK
B\wa; ; | updates/sqlazure/2.5.14.sqlnu W+A PK
B\o.; ; updates/sqlazure/2.5.13.sqlnu W+A PK
B\wn5; ; updates/sqlazure/2.5.22.sqlnu W+A PK
B\z; ; updates/sqlazure/2.5.25.sqlnu W+A PK
B\T9 9 updates/sqlazure/2.5.6.sqlnu W+A PK
B\ ; ; updates/sqlazure/2.5.19.sqlnu W+A PK
B\I$}I I updates/sqlazure/2.5.10.sqlnu W+A PK
B\Sͫ9 9 1 updates/sqlazure/2.5.8.sqlnu W+A PK
B\k$J; ; updates/sqlazure/2.5.17.sqlnu W+A PK
B\9 9 : updates/sqlazure/2.5.9.sqlnu W+A PK
B\*S; ; updates/sqlazure/2.5.16.sqlnu W+A PK
B\}: : C updates/sqlazure/2.5.11.sqlnu W+A PK
B\T Ș updates/sqlazure/2.5.7.sqlnu W+A PK
B\`-E E updates/sqlazure/2.5.18.sqlnu W+A PK
B\c; ; updates/sqlazure/2.5.24.sqlnu W+A PK
B\ & & % updates/sqlazure/2.5.3-2012-03-13.sqlnu W+A PK
B\6_,; ; updates/sqlazure/2.5.23.sqlnu W+A PK
B\V
index.htmlnu W+A PK
B\) q .htaccessnu W+A PK sCB\yg ) install.mysql.utf8.sqlnu W+A PK sCB\ Œ# # uninstall.mysql.utf8.sqlnu W+A PK 6jB\_~ d install.chronoforms.sqlnu W+A PK 6jB\`T T uninstall.chronoforms.sqlnu W+A PK _ _ )" )