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

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

CREATE TABLE IF NOT EXISTS `#__fields` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `asset_id` int(10) unsigned NOT NULL DEFAULT 0,
  `context` varchar(255) NOT NULL DEFAULT '',
  `group_id` int(10) unsigned NOT NULL DEFAULT 0,
  `title` varchar(255) NOT NULL DEFAULT '',
  `name` varchar(255) NOT NULL DEFAULT '',
  `label` varchar(255) NOT NULL DEFAULT '',
  `default_value` text NOT NULL DEFAULT '',
  `type` varchar(255) NOT NULL DEFAULT 'text',
  `note` varchar(255) NOT NULL DEFAULT '',
  `description` text NOT NULL,
  `state` tinyint(1) NOT NULL DEFAULT '0',
  `required` 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',
  `params` text NOT NULL,
  `fieldparams` text NOT NULL,
  `language` char(7) NOT NULL DEFAULT '',
  `created_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_user_id` int(10) unsigned NOT NULL DEFAULT '0',
  `modified_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified_by` int(10) unsigned NOT NULL DEFAULT '0',
  `access` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `idx_checkout` (`checked_out`),
  KEY `idx_state` (`state`),
  KEY `idx_created_user_id` (`created_user_id`),
  KEY `idx_access` (`access`),
  KEY `idx_context` (`context`(191)),
  KEY `idx_language` (`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `#__fields_categories` (
  `field_id` int(11) NOT NULL DEFAULT 0,
  `category_id` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`field_id`,`category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `#__fields_groups` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `asset_id` int(10) unsigned NOT NULL DEFAULT 0,
  `context` varchar(255) NOT NULL DEFAULT '',
  `title` varchar(255) NOT NULL DEFAULT '',
  `note` varchar(255) NOT NULL DEFAULT '',
  `description` text NOT NULL,
  `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',
  `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',
  `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified_by` int(10) unsigned NOT NULL DEFAULT '0',
  `access` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `idx_checkout` (`checked_out`),
  KEY `idx_state` (`state`),
  KEY `idx_created_by` (`created_by`),
  KEY `idx_access` (`access`),
  KEY `idx_context` (`context`(191)),
  KEY `idx_language` (`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `#__fields_values` (
  `field_id` int(10) unsigned NOT NULL,
  `item_id` varchar(255) NOT NULL COMMENT 'Allow references to items which have strings as ids, eg. none db systems.',
  `value` text NOT NULL DEFAULT '',
  KEY `idx_field_id` (`field_id`),
  KEY `idx_item_id` (`item_id`(191))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;

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
(33, 'com_fields', 'component', 'com_fields', '', 1, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0);
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
(461, 'plg_system_fields', 'plugin', 'fields', 'system', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
(462, 'plg_fields_calendar', 'plugin', 'calendar', 'fields', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
(463, 'plg_fields_checkboxes', 'plugin', 'checkboxes', 'fields', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
(464, 'plg_fields_color', 'plugin', 'color', 'fields', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
(465, 'plg_fields_editor', 'plugin', 'editor', 'fields', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
(466, 'plg_fields_imagelist', 'plugin', 'imagelist', 'fields', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
(467, 'plg_fields_integer', 'plugin', 'integer', 'fields', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
(468, 'plg_fields_list', 'plugin', 'list', 'fields', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
(469, 'plg_fields_media', 'plugin', 'media', 'fields', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
(470, 'plg_fields_radio', 'plugin', 'radio', 'fields', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
(471, 'plg_fields_sql', 'plugin', 'sql', 'fields', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
(472, 'plg_fields_text', 'plugin', 'text', 'fields', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
(473, 'plg_fields_textarea', 'plugin', 'textarea', 'fields', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
(474, 'plg_fields_url', 'plugin', 'url', 'fields', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
(475, 'plg_fields_user', 'plugin', 'user', 'fields', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
(476, 'plg_fields_usergrouplist', 'plugin', 'usergrouplist', 'fields', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0);

[+] ..
[-] 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]