ꦫꦣꦺꦤ꧀ꦄꦤ꧀ꦠꦱꦺꦤ

PATH: home / centosnipponia / public_html / nipponiacom2 / administrator / components / com_admin / sql / updates / mysql

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;

[+] ..
[-] 2.5.0-2011-12-06.sql [edit]
[-] 2.5.0-2011-12-16.sql [edit]
[-] 2.5.0-2011-12-19.sql [edit]
[-] 2.5.0-2011-12-20.sql [edit]
[-] 2.5.0-2011-12-21-1.sql [edit]
[-] 2.5.0-2011-12-21-2.sql [edit]
[-] 2.5.0-2011-12-22.sql [edit]
[-] 2.5.0-2011-12-23.sql [edit]
[-] 2.5.0-2011-12-24.sql [edit]
[-] 2.5.0-2012-01-10.sql [edit]
[-] 2.5.0-2012-01-14.sql [edit]
[-] 2.5.1-2012-01-26.sql [edit]
[-] 2.5.2-2012-03-05.sql [edit]
[-] 2.5.3-2012-03-13.sql [edit]
[-] 2.5.4-2012-03-18.sql [edit]
[-] 2.5.4-2012-03-19.sql [edit]
[-] 2.5.5.sql [edit]
[-] 2.5.6.sql [edit]
[-] 2.5.7.sql [edit]
[-] 3.0.0.sql [edit]
[-] 3.0.1.sql [edit]
[-] 3.0.2.sql [edit]
[-] 3.0.3.sql [edit]
[-] 3.1.0.sql [edit]
[-] 3.1.1.sql [edit]
[-] 3.1.2.sql [edit]
[-] 3.1.3.sql [edit]
[-] 3.1.4.sql [edit]
[-] 3.1.5.sql [edit]
[-] 3.2.0.sql [edit]
[-] 3.2.1.sql [edit]
[-] 3.2.2-2013-12-22.sql [edit]
[-] 3.2.2-2013-12-28.sql [edit]
[-] 3.2.2-2014-01-08.sql [edit]
[-] 3.2.2-2014-01-15.sql [edit]
[-] 3.2.2-2014-01-18.sql [edit]
[-] 3.2.2-2014-01-23.sql [edit]
[-] 3.2.3-2014-02-20.sql [edit]
[-] 3.3.0-2014-02-16.sql [edit]
[-] 3.3.0-2014-04-02.sql [edit]
[-] 3.3.4-2014-08-03.sql [edit]
[-] 3.3.6-2014-09-30.sql [edit]
[-] 3.4.0-2014-08-24.sql [edit]
[-] 3.4.0-2014-09-01.sql [edit]
[-] 3.4.0-2014-09-16.sql [edit]
[-] 3.4.0-2014-10-20.sql [edit]
[-] 3.4.0-2014-12-03.sql [edit]
[-] 3.4.0-2015-01-21.sql [edit]
[-] 3.4.0-2015-02-26.sql [edit]
[-] 3.5.0-2015-07-01.sql [edit]
[-] 3.5.0-2015-10-13.sql [edit]
[-] 3.5.0-2015-10-26.sql [edit]
[-] 3.5.0-2015-10-30.sql [edit]
[-] 3.5.0-2015-11-04.sql [edit]
[-] 3.5.0-2015-11-05.sql [edit]
[-] 3.5.0-2016-02-26.sql [edit]
[-] 3.5.0-2016-03-01.sql [edit]
[-] 3.5.1-2016-03-25.sql [edit]
[-] 3.5.1-2016-03-29.sql [edit]
[-] 3.6.0-2016-04-01.sql [edit]
[-] 3.6.0-2016-04-06.sql [edit]
[-] 3.6.0-2016-04-08.sql [edit]
[-] 3.6.0-2016-04-09.sql [edit]
[-] 3.6.0-2016-05-06.sql [edit]
[-] 3.6.0-2016-06-01.sql [edit]
[-] 3.6.0-2016-06-05.sql [edit]
[-] 3.6.3-2016-08-15.sql [edit]
[-] 3.6.3-2016-08-16.sql [edit]
[-] 3.7.0-2016-08-06.sql [edit]
[-] 3.7.0-2016-08-22.sql [edit]
[-] 3.7.0-2016-08-29.sql [edit]
[-] 3.7.0-2016-09-29.sql [edit]
[-] 3.7.0-2016-10-01.sql [edit]
[-] 3.7.0-2016-10-02.sql [edit]
[-] 3.7.0-2016-11-04.sql [edit]
[-] 3.7.0-2016-11-19.sql [edit]
[-] 3.7.0-2016-11-21.sql [edit]
[-] 3.7.0-2016-11-24.sql [edit]
[-] 3.7.0-2016-11-27.sql [edit]
[-] 3.7.0-2017-01-08.sql [edit]
[-] 3.7.0-2017-01-09.sql [edit]
[-] 3.7.0-2017-01-15.sql [edit]
[-] 3.7.0-2017-01-17.sql [edit]
[-] 3.7.0-2017-01-31.sql [edit]
[-] 3.7.0-2017-02-02.sql [edit]
[-] 3.7.0-2017-02-15.sql [edit]
[-] 3.7.0-2017-02-17.sql [edit]
[-] 3.7.0-2017-03-03.sql [edit]
[-] 3.7.0-2017-03-09.sql [edit]
[-] 3.7.0-2017-03-19.sql [edit]
[-] 3.7.0-2017-04-10.sql [edit]
[-] 3.7.0-2017-04-19.sql [edit]
[-] 3.7.3-2017-06-03.sql [edit]
[-] 3.7.4-2017-07-05.sql [edit]
[-] 3.8.0-2017-07-28.sql [edit]
[-] 3.8.0-2017-07-31.sql [edit]
[-] 3.8.2-2017-10-14.sql [edit]
[-] 3.8.4-2018-01-16.sql [edit]
[-] 3.8.6-2018-02-14.sql [edit]
[-] 3.8.8-2018-05-18.sql [edit]
[-] 3.8.9-2018-06-19.sql [edit]
[-] 3.9.0-2018-05-02.sql [edit]
[-] 3.9.0-2018-05-03.sql [edit]
[-] 3.9.0-2018-05-05.sql [edit]
[-] 3.9.0-2018-05-19.sql [edit]
[-] 3.9.0-2018-05-20.sql [edit]
[-] 3.9.0-2018-05-24.sql [edit]
[-] 3.9.0-2018-05-27.sql [edit]
[-] 3.9.0-2018-06-02.sql [edit]
[-] 3.9.0-2018-06-12.sql [edit]
[-] 3.9.0-2018-06-13.sql [edit]
[-] 3.9.0-2018-06-14.sql [edit]
[-] 3.9.0-2018-06-17.sql [edit]
[-] 3.9.0-2018-07-09.sql [edit]
[-] 3.9.0-2018-07-10.sql [edit]
[-] 3.9.0-2018-07-11.sql [edit]
[-] 3.9.0-2018-08-12.sql [edit]
[-] 3.9.0-2018-08-28.sql [edit]
[-] 3.9.0-2018-08-29.sql [edit]
[-] 3.9.0-2018-09-04.sql [edit]
[-] 3.9.0-2018-10-15.sql [edit]
[-] 3.9.0-2018-10-20.sql [edit]
[-] 3.9.0-2018-10-21.sql [edit]
[-] 3.9.3-2019-01-12.sql [edit]
[-] 3.9.3-2019-02-07.sql [edit]
[-] index.html [edit]
[-] .htaccess.disabled [edit]