-- phpMyAdmin SQL Dump -- version 4.2.12deb2+deb8u1 -- http://www.phpmyadmin.net -- -- Host: localhost -- Czas generowania: 29 Lis 2015, 09:07 -- Wersja serwera: 5.5.46-0+deb8u1 -- Wersja PHP: 5.6.14-0+deb8u1 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Baza danych: `mage_kpse8` -- -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `batch` -- CREATE TABLE IF NOT EXISTS `batch` ( `bid` int(10) unsigned NOT NULL COMMENT 'Primary Key: Unique batch ID.', `token` varchar(64) CHARACTER SET ascii NOT NULL COMMENT 'A string token generated against the current user''s session id and the batch id, used to ensure that only the user who submitted the batch can effectively access it.', `timestamp` int(11) NOT NULL COMMENT 'A Unix timestamp indicating when this batch was submitted for processing. Stale batches are purged at cron time.', `batch` longblob COMMENT 'A serialized array containing the processing data for the batch.' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Stores details about batches (processes that run in…'; -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `cachetags` -- CREATE TABLE IF NOT EXISTS `cachetags` ( `tag` varchar(255) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'Namespace-prefixed tag string.', `invalidations` int(11) NOT NULL DEFAULT '0' COMMENT 'Number incremented when the tag is invalidated.' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Cache table for tracking cache tag invalidations.'; -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `cache_bootstrap` -- CREATE TABLE IF NOT EXISTS `cache_bootstrap` ( `cid` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL DEFAULT '' COMMENT 'Primary Key: Unique cache ID.', `data` longblob COMMENT 'A collection of data to cache.', `expire` int(11) NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp indicating when the cache entry should expire, or -1 for never.', `created` decimal(14,3) NOT NULL DEFAULT '0.000' COMMENT 'A timestamp with millisecond precision indicating when the cache entry was created.', `serialized` smallint(6) NOT NULL DEFAULT '0' COMMENT 'A flag to indicate whether content is serialized (1) or not (0).', `tags` longtext COMMENT 'Space-separated list of cache tags for this entry.', `checksum` varchar(255) CHARACTER SET ascii NOT NULL COMMENT 'The tag invalidation checksum when this entry was saved.' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Storage for the cache API.'; -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `cache_config` -- CREATE TABLE IF NOT EXISTS `cache_config` ( `cid` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL DEFAULT '' COMMENT 'Primary Key: Unique cache ID.', `data` longblob COMMENT 'A collection of data to cache.', `expire` int(11) NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp indicating when the cache entry should expire, or -1 for never.', `created` decimal(14,3) NOT NULL DEFAULT '0.000' COMMENT 'A timestamp with millisecond precision indicating when the cache entry was created.', `serialized` smallint(6) NOT NULL DEFAULT '0' COMMENT 'A flag to indicate whether content is serialized (1) or not (0).', `tags` longtext COMMENT 'Space-separated list of cache tags for this entry.', `checksum` varchar(255) CHARACTER SET ascii NOT NULL COMMENT 'The tag invalidation checksum when this entry was saved.' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Storage for the cache API.'; -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `cache_container` -- CREATE TABLE IF NOT EXISTS `cache_container` ( `cid` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL DEFAULT '' COMMENT 'Primary Key: Unique cache ID.', `data` longblob COMMENT 'A collection of data to cache.', `expire` int(11) NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp indicating when the cache entry should expire, or -1 for never.', `created` decimal(14,3) NOT NULL DEFAULT '0.000' COMMENT 'A timestamp with millisecond precision indicating when the cache entry was created.', `serialized` smallint(6) NOT NULL DEFAULT '0' COMMENT 'A flag to indicate whether content is serialized (1) or not (0).', `tags` longtext COMMENT 'Space-separated list of cache tags for this entry.', `checksum` varchar(255) CHARACTER SET ascii NOT NULL COMMENT 'The tag invalidation checksum when this entry was saved.' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Storage for the cache API.'; -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `cache_data` -- CREATE TABLE IF NOT EXISTS `cache_data` ( `cid` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL DEFAULT '' COMMENT 'Primary Key: Unique cache ID.', `data` longblob COMMENT 'A collection of data to cache.', `expire` int(11) NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp indicating when the cache entry should expire, or -1 for never.', `created` decimal(14,3) NOT NULL DEFAULT '0.000' COMMENT 'A timestamp with millisecond precision indicating when the cache entry was created.', `serialized` smallint(6) NOT NULL DEFAULT '0' COMMENT 'A flag to indicate whether content is serialized (1) or not (0).', `tags` longtext COMMENT 'Space-separated list of cache tags for this entry.', `checksum` varchar(255) CHARACTER SET ascii NOT NULL COMMENT 'The tag invalidation checksum when this entry was saved.' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Storage for the cache API.'; -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `cache_default` -- CREATE TABLE IF NOT EXISTS `cache_default` ( `cid` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL DEFAULT '' COMMENT 'Primary Key: Unique cache ID.', `data` longblob COMMENT 'A collection of data to cache.', `expire` int(11) NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp indicating when the cache entry should expire, or -1 for never.', `created` decimal(14,3) NOT NULL DEFAULT '0.000' COMMENT 'A timestamp with millisecond precision indicating when the cache entry was created.', `serialized` smallint(6) NOT NULL DEFAULT '0' COMMENT 'A flag to indicate whether content is serialized (1) or not (0).', `tags` longtext COMMENT 'Space-separated list of cache tags for this entry.', `checksum` varchar(255) CHARACTER SET ascii NOT NULL COMMENT 'The tag invalidation checksum when this entry was saved.' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Storage for the cache API.'; -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `cache_discovery` -- CREATE TABLE IF NOT EXISTS `cache_discovery` ( `cid` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL DEFAULT '' COMMENT 'Primary Key: Unique cache ID.', `data` longblob COMMENT 'A collection of data to cache.', `expire` int(11) NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp indicating when the cache entry should expire, or -1 for never.', `created` decimal(14,3) NOT NULL DEFAULT '0.000' COMMENT 'A timestamp with millisecond precision indicating when the cache entry was created.', `serialized` smallint(6) NOT NULL DEFAULT '0' COMMENT 'A flag to indicate whether content is serialized (1) or not (0).', `tags` longtext COMMENT 'Space-separated list of cache tags for this entry.', `checksum` varchar(255) CHARACTER SET ascii NOT NULL COMMENT 'The tag invalidation checksum when this entry was saved.' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Storage for the cache API.'; -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `cache_dynamic_page_cache` -- CREATE TABLE IF NOT EXISTS `cache_dynamic_page_cache` ( `cid` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL DEFAULT '' COMMENT 'Primary Key: Unique cache ID.', `data` longblob COMMENT 'A collection of data to cache.', `expire` int(11) NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp indicating when the cache entry should expire, or -1 for never.', `created` decimal(14,3) NOT NULL DEFAULT '0.000' COMMENT 'A timestamp with millisecond precision indicating when the cache entry was created.', `serialized` smallint(6) NOT NULL DEFAULT '0' COMMENT 'A flag to indicate whether content is serialized (1) or not (0).', `tags` longtext COMMENT 'Space-separated list of cache tags for this entry.', `checksum` varchar(255) CHARACTER SET ascii NOT NULL COMMENT 'The tag invalidation checksum when this entry was saved.' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Storage for the cache API.'; -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `cache_entity` -- CREATE TABLE IF NOT EXISTS `cache_entity` ( `cid` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL DEFAULT '' COMMENT 'Primary Key: Unique cache ID.', `data` longblob COMMENT 'A collection of data to cache.', `expire` int(11) NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp indicating when the cache entry should expire, or -1 for never.', `created` decimal(14,3) NOT NULL DEFAULT '0.000' COMMENT 'A timestamp with millisecond precision indicating when the cache entry was created.', `serialized` smallint(6) NOT NULL DEFAULT '0' COMMENT 'A flag to indicate whether content is serialized (1) or not (0).', `tags` longtext COMMENT 'Space-separated list of cache tags for this entry.', `checksum` varchar(255) CHARACTER SET ascii NOT NULL COMMENT 'The tag invalidation checksum when this entry was saved.' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Storage for the cache API.'; -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `cache_menu` -- CREATE TABLE IF NOT EXISTS `cache_menu` ( `cid` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL DEFAULT '' COMMENT 'Primary Key: Unique cache ID.', `data` longblob COMMENT 'A collection of data to cache.', `expire` int(11) NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp indicating when the cache entry should expire, or -1 for never.', `created` decimal(14,3) NOT NULL DEFAULT '0.000' COMMENT 'A timestamp with millisecond precision indicating when the cache entry was created.', `serialized` smallint(6) NOT NULL DEFAULT '0' COMMENT 'A flag to indicate whether content is serialized (1) or not (0).', `tags` longtext COMMENT 'Space-separated list of cache tags for this entry.', `checksum` varchar(255) CHARACTER SET ascii NOT NULL COMMENT 'The tag invalidation checksum when this entry was saved.' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Storage for the cache API.'; -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `cache_render` -- CREATE TABLE IF NOT EXISTS `cache_render` ( `cid` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL DEFAULT '' COMMENT 'Primary Key: Unique cache ID.', `data` longblob COMMENT 'A collection of data to cache.', `expire` int(11) NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp indicating when the cache entry should expire, or -1 for never.', `created` decimal(14,3) NOT NULL DEFAULT '0.000' COMMENT 'A timestamp with millisecond precision indicating when the cache entry was created.', `serialized` smallint(6) NOT NULL DEFAULT '0' COMMENT 'A flag to indicate whether content is serialized (1) or not (0).', `tags` longtext COMMENT 'Space-separated list of cache tags for this entry.', `checksum` varchar(255) CHARACTER SET ascii NOT NULL COMMENT 'The tag invalidation checksum when this entry was saved.' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Storage for the cache API.'; -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `comment` -- CREATE TABLE IF NOT EXISTS `comment` ( `cid` int(10) unsigned NOT NULL, `comment_type` varchar(32) CHARACTER SET ascii NOT NULL COMMENT 'The ID of the target entity.', `uuid` varchar(128) CHARACTER SET ascii NOT NULL, `langcode` varchar(12) CHARACTER SET ascii NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='The base table for comment entities.'; -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `comment_entity_statistics` -- CREATE TABLE IF NOT EXISTS `comment_entity_statistics` ( `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'The entity_id of the entity for which the statistics are compiled.', `entity_type` varchar(32) CHARACTER SET ascii NOT NULL DEFAULT 'node' COMMENT 'The entity_type of the entity to which this comment is a reply.', `field_name` varchar(32) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The field_name of the field that was used to add this comment.', `cid` int(11) NOT NULL DEFAULT '0' COMMENT 'The comment.cid of the last comment.', `last_comment_timestamp` int(11) NOT NULL DEFAULT '0' COMMENT 'The Unix timestamp of the last comment that was posted within this node, from comment.changed.', `last_comment_name` varchar(60) DEFAULT NULL COMMENT 'The name of the latest author to post a comment on this node, from comment.name.', `last_comment_uid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'The user ID of the latest author to post a comment on this node, from comment.uid.', `comment_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'The total number of comments on this entity.' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Maintains statistics of entity and comments posts to show …'; -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `comment_field_data` -- CREATE TABLE IF NOT EXISTS `comment_field_data` ( `cid` int(10) unsigned NOT NULL, `comment_type` varchar(32) CHARACTER SET ascii NOT NULL COMMENT 'The ID of the target entity.', `langcode` varchar(12) CHARACTER SET ascii NOT NULL, `pid` int(10) unsigned DEFAULT NULL COMMENT 'The ID of the target entity.', `entity_id` int(10) unsigned DEFAULT NULL COMMENT 'The ID of the target entity.', `subject` varchar(64) DEFAULT NULL, `uid` int(10) unsigned DEFAULT NULL COMMENT 'The ID of the target entity.', `name` varchar(60) DEFAULT NULL, `mail` varchar(254) DEFAULT NULL, `homepage` varchar(255) DEFAULT NULL, `hostname` varchar(128) DEFAULT NULL, `created` int(11) NOT NULL, `changed` int(11) DEFAULT NULL, `status` tinyint(4) DEFAULT NULL, `thread` varchar(255) NOT NULL, `entity_type` varchar(32) CHARACTER SET ascii DEFAULT NULL, `field_name` varchar(32) CHARACTER SET ascii DEFAULT NULL, `default_langcode` tinyint(4) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='The data table for comment entities.'; -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `comment__comment_body` -- CREATE TABLE IF NOT EXISTS `comment__comment_body` ( `bundle` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance', `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted', `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to', `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to, which for an unversioned entity type is the same as the entity id', `langcode` varchar(32) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The language code for this data item.', `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields', `comment_body_value` longtext NOT NULL, `comment_body_format` varchar(255) CHARACTER SET ascii DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Data storage for comment field comment_body.'; -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `config` -- CREATE TABLE IF NOT EXISTS `config` ( `collection` varchar(255) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'Primary Key: Config object collection.', `name` varchar(255) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'Primary Key: Config object name.', `data` longblob COMMENT 'A serialized configuration object data.' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='The base table for configuration data.'; -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `file_managed` -- CREATE TABLE IF NOT EXISTS `file_managed` ( `fid` int(10) unsigned NOT NULL, `uuid` varchar(128) CHARACTER SET ascii NOT NULL, `langcode` varchar(12) CHARACTER SET ascii NOT NULL, `uid` int(10) unsigned DEFAULT NULL COMMENT 'The ID of the target entity.', `filename` varchar(255) DEFAULT NULL, `uri` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL, `filemime` varchar(255) CHARACTER SET ascii DEFAULT NULL, `filesize` bigint(20) unsigned DEFAULT NULL, `status` tinyint(4) NOT NULL, `created` int(11) DEFAULT NULL, `changed` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='The base table for file entities.'; -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `file_usage` -- CREATE TABLE IF NOT EXISTS `file_usage` ( `fid` int(10) unsigned NOT NULL COMMENT 'File ID.', `module` varchar(50) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The name of the module that is using the file.', `type` varchar(64) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The name of the object type in which the file is used.', `id` varchar(64) CHARACTER SET ascii NOT NULL DEFAULT '0' COMMENT 'The primary key of the object using the file.', `count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'The number of times this file is used by this object.' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Track where a file is used.'; -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `flood` -- CREATE TABLE IF NOT EXISTS `flood` ( `fid` int(11) NOT NULL COMMENT 'Unique flood event ID.', `event` varchar(64) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'Name of event (e.g. contact).', `identifier` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'Identifier of the visitor, such as an IP address or hostname.', `timestamp` int(11) NOT NULL DEFAULT '0' COMMENT 'Timestamp of the event.', `expiration` int(11) NOT NULL DEFAULT '0' COMMENT 'Expiration timestamp. Expired events are purged on cron run.' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Flood controls the threshold of events, such as the number…'; -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `key_value` -- CREATE TABLE IF NOT EXISTS `key_value` ( `collection` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'A named collection of key and value pairs.' `value` longblob NOT NULL COMMENT 'The value.', PRIMARY KEY (`collection`,`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Generic key-value storage table. See the state system for…'; -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `key_value_expire` -- CREATE TABLE IF NOT EXISTS `key_value_expire` ( `collection` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'A named collection of key and value pairs.', `name` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The key of the key/value pair.', `value` longblob NOT NULL COMMENT 'The value of the key/value pair.', `expire` int(11) NOT NULL DEFAULT '2147483647' COMMENT 'The time since Unix epoch in seconds when this item expires. Defaults to the maximum possible time.' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Generic key/value storage table with an expiration.'; -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `locales_location` -- CREATE TABLE IF NOT EXISTS `locales_location` ( `lid` int(11) NOT NULL COMMENT 'Unique identifier of this location.', `sid` int(11) NOT NULL COMMENT 'Unique identifier of this string.', `type` varchar(50) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The location type (file, config, path, etc).', `name` varchar(255) NOT NULL DEFAULT '' COMMENT 'Type dependent location information (file name, path, etc).', `version` varchar(20) CHARACTER SET ascii NOT NULL DEFAULT 'none' COMMENT 'Version of Drupal where the location was found.' ) ENGINE=InnoDB AUTO_INCREMENT=1039 DEFAULT CHARSET=utf8mb4 COMMENT='Location information for source strings.'; -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `locales_source` -- CREATE TABLE IF NOT EXISTS `locales_source` ( `lid` int(11) NOT NULL COMMENT 'Unique identifier of this string.', `source` blob NOT NULL COMMENT 'The original string in English.', `context` varchar(255) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The context this string applies to.', `version` varchar(20) CHARACTER SET ascii NOT NULL DEFAULT 'none' COMMENT 'Version of Drupal where the string was last used (for locales optimization).' ) ENGINE=InnoDB AUTO_INCREMENT=5139 DEFAULT CHARSET=utf8mb4 COMMENT='List of English source strings.'; -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `locales_target` -- CREATE TABLE IF NOT EXISTS `locales_target` ( `lid` int(11) NOT NULL DEFAULT '0' COMMENT 'Source string ID. References locales_source.lid.', `translation` blob NOT NULL COMMENT 'Translation string value in this language.', `language` varchar(12) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'Language code. References language.langcode.', `customized` int(11) NOT NULL DEFAULT '0' COMMENT 'Boolean indicating whether the translation is custom to this site.' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Stores translated versions of strings.'; -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `locale_file` -- CREATE TABLE IF NOT EXISTS `locale_file` ( `project` varchar(255) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'A unique short name to identify the project the file belongs to.', `langcode` varchar(12) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'Language code of this translation. References language.langcode.', `filename` varchar(255) NOT NULL DEFAULT '' COMMENT 'Filename of the imported file.', `version` varchar(128) NOT NULL DEFAULT '' COMMENT 'Version tag of the imported file.', `uri` varchar(255) NOT NULL DEFAULT '' COMMENT 'URI of the remote file, the resulting local file or the locally imported file.', `timestamp` int(11) DEFAULT '0' COMMENT 'Unix timestamp of the imported file.', `last_checked` int(11) DEFAULT '0' COMMENT 'Unix timestamp of the last time this translation was confirmed to be the most recent release available.' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='File import status information for interface translation…'; -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `menu_tree` -- CREATE TABLE IF NOT EXISTS `menu_tree` ( `menu_name` varchar(32) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The menu name. All links with the same menu name (such as ''tools'') are part of the same menu.', `mlid` int(10) unsigned NOT NULL COMMENT 'The menu link ID (mlid) is the integer primary key.', `id` varchar(255) CHARACTER SET ascii NOT NULL COMMENT 'Unique machine name: the plugin ID.', `parent` varchar(255) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The plugin ID for the parent of this link.', `route_name` varchar(255) CHARACTER SET ascii DEFAULT NULL COMMENT 'The machine name of a defined Symfony Route this menu item represents.', `route_param_key` varchar(255) DEFAULT NULL COMMENT 'An encoded string of route parameters for loading by route.', `route_parameters` longblob COMMENT 'Serialized array of route parameters of this menu link.', `url` varchar(255) NOT NULL DEFAULT '' COMMENT 'The external path this link points to (when not using a route).', `title` longblob COMMENT 'The serialized title for the link. May be a TranslatableMarkup.', `description` longblob COMMENT 'The serialized description of this link - used for admin pages and title attribute. May be a TranslatableMarkup.', `class` text COMMENT 'The class for this link plugin.', `options` longblob COMMENT 'A serialized array of URL options, such as a query string or HTML attributes.', `provider` varchar(50) CHARACTER SET ascii NOT NULL DEFAULT 'system' COMMENT 'The name of the module that generated this link.', `enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT 'A flag for whether the link should be rendered in menus. (0 = a disabled menu item that may be shown on admin screens, 1 = a normal, visible link)', `discovered` smallint(6) NOT NULL DEFAULT '0' COMMENT 'A flag for whether the link was discovered, so can be purged on rebuild', `expanded` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Flag for whether this link should be rendered as expanded in menus - expanded links always have their child links displayed, instead of only when the link is in the active trail (1 = expanded, 0 = not expanded)', `weight` int(11) NOT NULL DEFAULT '0' COMMENT 'Link weight among links in the same menu at the same depth.', `metadata` longblob COMMENT 'A serialized array of data that may be used by the plugin instance.', `has_children` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Flag indicating whether any enabled links have this link as a parent (1 = enabled children exist, 0 = no enabled children).', `depth` smallint(6) NOT NULL DEFAULT '0' COMMENT 'The depth relative to the top level. A link with empty parent will have depth == 1.', `p1` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'The first mlid in the materialized path. If N = depth, then pN must equal the mlid. If depth > 1 then p(N-1) must equal the parent link mlid. All pX where X > depth must equal zero. The columns p1 .. p9 are also called the parents.', `p2` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'The second mlid in the materialized path. See p1.', `p3` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'The third mlid in the materialized path. See p1.', `p4` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'The fourth mlid in the materialized path. See p1.', `p5` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'The fifth mlid in the materialized path. See p1.', `p6` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'The sixth mlid in the materialized path. See p1.', `p7` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'The seventh mlid in the materialized path. See p1.', `p8` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'The eighth mlid in the materialized path. See p1.', `p9` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'The ninth mlid in the materialized path. See p1.', `form_class` varchar(255) DEFAULT NULL COMMENT 'meh' ) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8mb4 COMMENT='Contains the menu tree hierarchy.'; -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `node` -- CREATE TABLE IF NOT EXISTS `node` ( `nid` int(10) unsigned NOT NULL, `vid` int(10) unsigned DEFAULT NULL, `type` varchar(32) CHARACTER SET ascii NOT NULL COMMENT 'The ID of the target entity.', `uuid` varchar(128) CHARACTER SET ascii NOT NULL, `langcode` varchar(12) CHARACTER SET ascii NOT NULL ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='The base table for node entities.'; -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `node_access` -- CREATE TABLE IF NOT EXISTS `node_access` ( `nid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'The node.nid this record affects.', `langcode` varchar(12) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The language.langcode of this node.', `fallback` int(10) unsigned NOT NULL DEFAULT '1' COMMENT 'Boolean indicating whether this record should be used as a fallback if a language condition is not provided.', `gid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'The grant ID a user must possess in the specified realm to gain this row''s privileges on the node.', `realm` varchar(255) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The realm in which the user must possess the grant ID. Each node access node can define one or more realms.', `grant_view` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Boolean indicating whether a user with the realm/grant pair can view this node.', `grant_update` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Boolean indicating whether a user with the realm/grant pair can edit this node.', `grant_delete` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Boolean indicating whether a user with the realm/grant pair can delete this node.' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Identifies which realm/grant pairs a user must possess in…'; -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `node_field_data` -- CREATE TABLE IF NOT EXISTS `node_field_data` ( `nid` int(10) unsigned NOT NULL, `vid` int(10) unsigned NOT NULL, `type` varchar(32) CHARACTER SET ascii NOT NULL COMMENT 'The ID of the target entity.', `langcode` varchar(12) CHARACTER SET ascii NOT NULL, `title` varchar(255) NOT NULL, `uid` int(10) unsigned NOT NULL COMMENT 'The ID of the target entity.', `status` tinyint(4) NOT NULL, `created` int(11) NOT NULL, `changed` int(11) NOT NULL, `promote` tinyint(4) NOT NULL, `sticky` tinyint(4) NOT NULL, `revision_translation_affected` tinyint(4) DEFAULT NULL, `default_langcode` tinyint(4) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='The data table for node entities.'; -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `node_field_revision` -- CREATE TABLE IF NOT EXISTS `node_field_revision` ( `nid` int(10) unsigned NOT NULL, `vid` int(10) unsigned NOT NULL, `langcode` varchar(12) CHARACTER SET ascii NOT NULL, `title` varchar(255) DEFAULT NULL, `uid` int(10) unsigned NOT NULL COMMENT 'The ID of the target entity.', `status` tinyint(4) NOT NULL, `created` int(11) DEFAULT NULL, `changed` int(11) DEFAULT NULL, `promote` tinyint(4) DEFAULT NULL, `sticky` tinyint(4) DEFAULT NULL, `revision_translation_affected` tinyint(4) DEFAULT NULL, `default_langcode` tinyint(4) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='The revision data table for node entities.'; -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `node_revision` -- CREATE TABLE IF NOT EXISTS `node_revision` ( `nid` int(10) unsigned NOT NULL, `vid` int(10) unsigned NOT NULL, `langcode` varchar(12) CHARACTER SET ascii NOT NULL, `revision_timestamp` int(11) DEFAULT NULL, `revision_uid` int(10) unsigned DEFAULT NULL COMMENT 'The ID of the target entity.', `revision_log` longtext ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='The revision table for node entities.'; -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `node_revision__body` -- CREATE TABLE IF NOT EXISTS `node_revision__body` ( `bundle` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance', `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted', `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to', `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to', `langcode` varchar(32) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The language code for this data item.', `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields', `body_value` longtext NOT NULL, `body_summary` longtext, `body_format` varchar(255) CHARACTER SET ascii DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Revision archive storage for node field body.'; -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `node_revision__field_artykul_autor` -- CREATE TABLE IF NOT EXISTS `node_revision__field_artykul_autor` ( `bundle` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance', `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted', `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to', `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to', `langcode` varchar(32) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The language code for this data item.', `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields', `field_artykul_autor_value` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Revision archive storage for node field field_artykul_autor.'; -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `node_revision__field_artykul_notki_biograficzne` -- CREATE TABLE IF NOT EXISTS `node_revision__field_artykul_notki_biograficzne` ( `bundle` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance', `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted', `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to', `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to', `langcode` varchar(32) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The language code for this data item.', `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields', `field_artykul_notki_biograficzne_value` longtext NOT NULL, `field_artykul_notki_biograficzne_format` varchar(255) CHARACTER SET ascii DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Revision archive storage for node field field_artykul_notki…'; -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `node__body` -- CREATE TABLE IF NOT EXISTS `node__body` ( `bundle` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance', `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted', `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to', `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to', `langcode` varchar(32) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The language code for this data item.', `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields', `body_value` longtext NOT NULL, `body_summary` longtext, `body_format` varchar(255) CHARACTER SET ascii DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Data storage for node field body.'; -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `node__field_artykul_autor` -- CREATE TABLE IF NOT EXISTS `node__field_artykul_autor` ( `bundle` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance', `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted', `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to', `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to', `langcode` varchar(32) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The language code for this data item.', `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields', `field_artykul_autor_value` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Data storage for node field field_artykul_autor.'; -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `node__field_artykul_notki_biograficzne` -- CREATE TABLE IF NOT EXISTS `node__field_artykul_notki_biograficzne` ( `bundle` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance', `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted', `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to', `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to', `langcode` varchar(32) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The language code for this data item.', `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields', `field_artykul_notki_biograficzne_value` longtext NOT NULL, `field_artykul_notki_biograficzne_format` varchar(255) CHARACTER SET ascii DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Data storage for node field field_artykul_notki…'; -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `queue` -- CREATE TABLE IF NOT EXISTS `queue` ( `item_id` int(10) unsigned NOT NULL COMMENT 'Primary Key: Unique item ID.', `name` varchar(255) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The queue name.', `data` longblob COMMENT 'The arbitrary data for the item.', `expire` int(11) NOT NULL DEFAULT '0' COMMENT 'Timestamp when the claim lease expires on the item.', `created` int(11) NOT NULL DEFAULT '0' COMMENT 'Timestamp when the item was created.' ) ENGINE=InnoDB AUTO_INCREMENT=63 DEFAULT CHARSET=utf8mb4 COMMENT='Stores items in queues.'; -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `router` -- CREATE TABLE IF NOT EXISTS `router` ( `name` varchar(255) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'Primary Key: Machine name of this route', `path` varchar(255) NOT NULL DEFAULT '' COMMENT 'The path for this URI', `pattern_outline` varchar(255) NOT NULL DEFAULT '' COMMENT 'The pattern', `fit` int(11) NOT NULL DEFAULT '0' COMMENT 'A numeric representation of how specific the path is.', `route` longblob COMMENT 'A serialized Route object', `number_parts` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Number of parts in this router path.' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Maps paths to various callbacks (access, page and title)'; -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `search_dataset` -- CREATE TABLE IF NOT EXISTS `search_dataset` ( `sid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Search item ID, e.g. node ID for nodes.', `langcode` varchar(12) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The languages.langcode of the item variant.', `type` varchar(64) CHARACTER SET ascii NOT NULL COMMENT 'Type of item, e.g. node.', `data` longtext NOT NULL COMMENT 'List of space-separated words from the item.', `reindex` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Set to force node reindexing.' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Stores items that will be searched.'; -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `search_index` -- CREATE TABLE IF NOT EXISTS `search_index` ( `word` varchar(50) NOT NULL DEFAULT '' COMMENT 'The search_total.word that is associated with the search item.', `sid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'The search_dataset.sid of the searchable item to which the word belongs.', `langcode` varchar(12) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The languages.langcode of the item variant.', `type` varchar(64) CHARACTER SET ascii NOT NULL COMMENT 'The search_dataset.type of the searchable item to which the word belongs.', `score` float DEFAULT NULL COMMENT 'The numeric score of the word, higher being more important.' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Stores the search index, associating words, items and…'; -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `search_total` -- CREATE TABLE IF NOT EXISTS `search_total` ( `word` varchar(50) NOT NULL DEFAULT '' COMMENT 'Primary Key: Unique word in the search index.', `count` float DEFAULT NULL COMMENT 'The count of the word in the index using Zipf''s law to equalize the probability distribution.' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Stores search totals for words.'; -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `semaphore` -- CREATE TABLE IF NOT EXISTS `semaphore` ( `name` varchar(255) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'Primary Key: Unique name.', `value` varchar(255) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'A value for the semaphore.', `expire` double NOT NULL COMMENT 'A Unix timestamp with microseconds indicating when the semaphore should expire.' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Table for holding semaphores, locks, flags, etc. that…'; -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `sequences` -- CREATE TABLE IF NOT EXISTS `sequences` ( `value` int(10) unsigned NOT NULL COMMENT 'The value of the sequence.' ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COMMENT='Stores IDs.'; -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `sessions` -- CREATE TABLE IF NOT EXISTS `sessions` ( `uid` int(10) unsigned NOT NULL COMMENT 'The users.uid corresponding to a session, or 0 for anonymous user.', `sid` varchar(128) CHARACTER SET ascii NOT NULL COMMENT 'A session ID (hashed). The value is generated by Drupal''s session handlers.', `hostname` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The IP address that last used this session ID (sid).', `timestamp` int(11) NOT NULL DEFAULT '0' COMMENT 'The Unix timestamp when this session last requested a page. Old records are purged by PHP automatically.', `session` longblob COMMENT 'The serialized contents of $_SESSION, an array of name/value pairs that persists across page requests by this session ID. Drupal loads $_SESSION from here at the start of each request and saves it at the end.' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Drupal''s session handlers read and write into the sessions…'; -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `tracker_node` -- CREATE TABLE IF NOT EXISTS `tracker_node` ( `nid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'The node.nid this record tracks.', `published` tinyint(4) DEFAULT '0' COMMENT 'Boolean indicating whether the node is published.', `changed` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'The Unix timestamp when the node was most recently saved or commented on.' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Tracks when nodes were last changed or commented on.'; -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `tracker_user` -- CREATE TABLE IF NOT EXISTS `tracker_user` ( `nid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'The node.nid this record tracks.', `uid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'The users.uid of the node author or commenter.', `published` tinyint(4) DEFAULT '0' COMMENT 'Boolean indicating whether the node is published.', `changed` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'The Unix timestamp when the node was most recently saved or commented on.' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Tracks when nodes were last changed or commented on, for…'; -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `url_alias` -- CREATE TABLE IF NOT EXISTS `url_alias` ( `pid` int(10) unsigned NOT NULL COMMENT 'A unique path alias identifier.', `source` varchar(255) NOT NULL DEFAULT '' COMMENT 'The Drupal path this alias is for. e.g. node/12.', `alias` varchar(255) NOT NULL DEFAULT '' COMMENT 'The alias for this path. e.g. title-of-the-story.', `langcode` varchar(12) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The language code this alias is for. if ''und'', the alias will be used for unknown languages. Each Drupal path can have an alias for each supported language.' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='A list of URL aliases for Drupal paths. a user may visit…'; -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `users` -- CREATE TABLE IF NOT EXISTS `users` ( `uid` int(10) unsigned NOT NULL, `uuid` varchar(128) CHARACTER SET ascii NOT NULL, `langcode` varchar(12) CHARACTER SET ascii NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='The base table for user entities.'; -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `users_data` -- CREATE TABLE IF NOT EXISTS `users_data` ( `uid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Primary key: users.uid for user.', `module` varchar(50) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The name of the module declaring the variable.', `name` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The identifier of the data.', `value` longblob COMMENT 'The value.', `serialized` tinyint(3) unsigned DEFAULT '0' COMMENT 'Whether value is serialized.' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Stores module data as key/value pairs per user.'; -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `users_field_data` -- CREATE TABLE IF NOT EXISTS `users_field_data` ( `uid` int(10) unsigned NOT NULL, `langcode` varchar(12) CHARACTER SET ascii NOT NULL, `preferred_langcode` varchar(12) CHARACTER SET ascii DEFAULT NULL, `preferred_admin_langcode` varchar(12) CHARACTER SET ascii DEFAULT NULL, `name` varchar(60) NOT NULL, `pass` varchar(255) DEFAULT NULL, `mail` varchar(254) DEFAULT NULL, `timezone` varchar(32) DEFAULT NULL, `status` tinyint(4) DEFAULT NULL, `created` int(11) NOT NULL, `changed` int(11) DEFAULT NULL, `access` int(11) NOT NULL, `login` int(11) DEFAULT NULL, `init` varchar(254) DEFAULT NULL, `default_langcode` tinyint(4) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='The data table for user entities.'; -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `user__field_user_imie` -- CREATE TABLE IF NOT EXISTS `user__field_user_imie` ( `bundle` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance', `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted', `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to', `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to, which for an unversioned entity type is the same as the entity id', `langcode` varchar(32) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The language code for this data item.', `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields', `field_user_imie_value` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Data storage for user field field_user_imie.'; -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `user__field_user_nazwisko` -- CREATE TABLE IF NOT EXISTS `user__field_user_nazwisko` ( `bundle` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance', `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted', `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to', `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to, which for an unversioned entity type is the same as the entity id', `langcode` varchar(32) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The language code for this data item.', `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields', `field_user_nazwisko_value` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Data storage for user field field_user_nazwisko.'; -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `user__roles` -- CREATE TABLE IF NOT EXISTS `user__roles` ( `bundle` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance', `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted', `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to', `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to, which for an unversioned entity type is the same as the entity id', `langcode` varchar(32) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The language code for this data item.', `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields', `roles_target_id` varchar(255) CHARACTER SET ascii NOT NULL COMMENT 'The ID of the target entity.' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Data storage for user field roles.'; -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `watchdog` -- CREATE TABLE IF NOT EXISTS `watchdog` ( `wid` int(11) NOT NULL COMMENT 'Primary Key: Unique watchdog event ID.', `uid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'The users.uid of the user who triggered the event.', `type` varchar(64) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'Type of log message, for example "user" or "page not found."', `message` longtext NOT NULL COMMENT 'Text of log message to be passed into the t() function.', `variables` longblob NOT NULL COMMENT 'Serialized array of variables that match the message string and that is passed into the t() function.', `severity` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'The severity level of the event. ranges from 0 (Emergency) to 7 (Debug)', `link` text COMMENT 'Link to view the result of the event.', `location` text NOT NULL COMMENT 'URL of the origin of the event.', `referer` text COMMENT 'URL of referring page.', `hostname` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'Hostname of the user who triggered the event.', `timestamp` int(11) NOT NULL DEFAULT '0' COMMENT 'Unix timestamp of when event occurred.' ) ENGINE=InnoDB AUTO_INCREMENT=60 DEFAULT CHARSET=utf8mb4 COMMENT='Table that contains logs of all system events.'; -- -- Indeksy dla zrzutów tabel -- -- -- Indexes for table `batch` -- ALTER TABLE `batch` ADD PRIMARY KEY (`bid`), ADD KEY `token` (`token`); -- -- Indexes for table `cachetags` -- ALTER TABLE `cachetags` ADD PRIMARY KEY (`tag`); -- -- Indexes for table `cache_bootstrap` -- ALTER TABLE `cache_bootstrap` ADD PRIMARY KEY (`cid`), ADD KEY `expire` (`expire`); -- -- Indexes for table `cache_config` -- ALTER TABLE `cache_config` ADD PRIMARY KEY (`cid`), ADD KEY `expire` (`expire`); -- -- Indexes for table `cache_container` -- ALTER TABLE `cache_container` ADD PRIMARY KEY (`cid`), ADD KEY `expire` (`expire`); -- -- Indexes for table `cache_data` -- ALTER TABLE `cache_data` ADD PRIMARY KEY (`cid`), ADD KEY `expire` (`expire`); -- -- Indexes for table `cache_default` -- ALTER TABLE `cache_default` ADD PRIMARY KEY (`cid`), ADD KEY `expire` (`expire`); -- -- Indexes for table `cache_discovery` -- ALTER TABLE `cache_discovery` ADD PRIMARY KEY (`cid`), ADD KEY `expire` (`expire`); -- -- Indexes for table `cache_dynamic_page_cache` -- ALTER TABLE `cache_dynamic_page_cache` ADD PRIMARY KEY (`cid`), ADD KEY `expire` (`expire`); -- -- Indexes for table `cache_entity` -- ALTER TABLE `cache_entity` ADD PRIMARY KEY (`cid`), ADD KEY `expire` (`expire`); -- -- Indexes for table `cache_menu` -- ALTER TABLE `cache_menu` ADD PRIMARY KEY (`cid`), ADD KEY `expire` (`expire`); -- -- Indexes for table `cache_render` -- ALTER TABLE `cache_render` ADD PRIMARY KEY (`cid`), ADD KEY `expire` (`expire`); -- -- Indexes for table `comment` -- ALTER TABLE `comment` ADD PRIMARY KEY (`cid`), ADD UNIQUE KEY `comment_field__uuid__value` (`uuid`), ADD KEY `comment_field__comment_type__target_id` (`comment_type`); -- -- Indexes for table `comment_entity_statistics` -- ALTER TABLE `comment_entity_statistics` ADD PRIMARY KEY (`entity_id`,`entity_type`,`field_name`), ADD KEY `last_comment_timestamp` (`last_comment_timestamp`), ADD KEY `comment_count` (`comment_count`), ADD KEY `last_comment_uid` (`last_comment_uid`); -- -- Indexes for table `comment_field_data` -- ALTER TABLE `comment_field_data` ADD PRIMARY KEY (`cid`,`langcode`), ADD KEY `comment__id__default_langcode__langcode` (`cid`,`default_langcode`,`langcode`), ADD KEY `comment_field__comment_type__target_id` (`comment_type`), ADD KEY `comment_field__uid__target_id` (`uid`), ADD KEY `comment_field__created` (`created`), ADD KEY `comment__status_pid` (`pid`,`status`), ADD KEY `comment__num_new` (`entity_id`,`entity_type`,`comment_type`,`status`,`created`,`cid`,`thread`(191)), ADD KEY `comment__entity_langcode` (`entity_id`,`entity_type`,`comment_type`,`default_langcode`); -- -- Indexes for table `comment__comment_body` -- ALTER TABLE `comment__comment_body` ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`), ADD KEY `bundle` (`bundle`), ADD KEY `revision_id` (`revision_id`), ADD KEY `comment_body_format` (`comment_body_format`); -- -- Indexes for table `config` -- ALTER TABLE `config` ADD PRIMARY KEY (`collection`,`name`); -- -- Indexes for table `file_managed` -- ALTER TABLE `file_managed` ADD PRIMARY KEY (`fid`), ADD UNIQUE KEY `file_field__uuid__value` (`uuid`), ADD KEY `file_field__uid__target_id` (`uid`), ADD KEY `file_field__uri` (`uri`(191)), ADD KEY `file_field__status` (`status`), ADD KEY `file_field__changed` (`changed`); -- -- Indexes for table `file_usage` -- ALTER TABLE `file_usage` ADD PRIMARY KEY (`fid`,`type`,`id`,`module`), ADD KEY `type_id` (`type`,`id`), ADD KEY `fid_count` (`fid`,`count`), ADD KEY `fid_module` (`fid`,`module`); -- -- Indexes for table `flood` -- ALTER TABLE `flood` ADD PRIMARY KEY (`fid`), ADD KEY `allow` (`event`,`identifier`,`timestamp`), ADD KEY `purge` (`expiration`); -- -- Indexes for table `key_value` -- ALTER TABLE `key_value` ADD `name` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The key of the key-value pair. As KEY is a SQL reserved keyword, name was chosen instead.'; -- -- Indexes for table `key_value_expire` -- ALTER TABLE `key_value_expire` ADD PRIMARY KEY (`collection`,`name`), ADD KEY `all` (`name`,`collection`,`expire`), ADD KEY `expire` (`expire`); -- -- Indexes for table `locales_location` -- ALTER TABLE `locales_location` ADD PRIMARY KEY (`lid`), ADD KEY `string_id` (`sid`), ADD KEY `string_type` (`sid`,`type`); -- -- Indexes for table `locales_source` -- ALTER TABLE `locales_source` ADD PRIMARY KEY (`lid`), ADD KEY `source_context` (`source`(30),`context`); -- -- Indexes for table `locales_target` -- ALTER TABLE `locales_target` ADD PRIMARY KEY (`language`,`lid`), ADD KEY `lid` (`lid`); -- -- Indexes for table `locale_file` -- ALTER TABLE `locale_file` ADD PRIMARY KEY (`project`,`langcode`); -- -- Indexes for table `menu_tree` -- ALTER TABLE `menu_tree` ADD PRIMARY KEY (`mlid`), ADD UNIQUE KEY `id` (`id`), ADD KEY `menu_parents` (`menu_name`,`p1`,`p2`,`p3`,`p4`,`p5`,`p6`,`p7`,`p8`,`p9`), ADD KEY `menu_parent_expand_child` (`menu_name`,`expanded`,`has_children`,`parent`(16)), ADD KEY `route_values` (`route_name`(32),`route_param_key`(16)); -- -- Indexes for table `node` -- ALTER TABLE `node` ADD PRIMARY KEY (`nid`), ADD UNIQUE KEY `node_field__uuid__value` (`uuid`), ADD UNIQUE KEY `node__vid` (`vid`), ADD KEY `node_field__type__target_id` (`type`); -- -- Indexes for table `node_access` -- ALTER TABLE `node_access` ADD PRIMARY KEY (`nid`,`gid`,`realm`,`langcode`); -- -- Indexes for table `node_field_data` -- ALTER TABLE `node_field_data` ADD PRIMARY KEY (`nid`,`langcode`), ADD KEY `node__id__default_langcode__langcode` (`nid`,`default_langcode`,`langcode`), ADD KEY `node__vid` (`vid`), ADD KEY `node_field__type__target_id` (`type`), ADD KEY `node_field__uid__target_id` (`uid`), ADD KEY `node_field__created` (`created`), ADD KEY `node_field__changed` (`changed`), ADD KEY `node__frontpage` (`promote`,`status`,`sticky`,`created`), ADD KEY `node__status_type` (`status`,`type`,`nid`), ADD KEY `node__title_type` (`title`(191),`type`(4)); -- -- Indexes for table `node_field_revision` -- ALTER TABLE `node_field_revision` ADD PRIMARY KEY (`vid`,`langcode`), ADD KEY `node__id__default_langcode__langcode` (`nid`,`default_langcode`,`langcode`), ADD KEY `node_field__uid__target_id` (`uid`); -- -- Indexes for table `node_revision` -- ALTER TABLE `node_revision` ADD PRIMARY KEY (`vid`), ADD KEY `node__nid` (`nid`), ADD KEY `node_field__langcode` (`langcode`), ADD KEY `node_field__revision_uid__target_id` (`revision_uid`); -- -- Indexes for table `node_revision__body` -- ALTER TABLE `node_revision__body` ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`), ADD KEY `bundle` (`bundle`), ADD KEY `revision_id` (`revision_id`), ADD KEY `body_format` (`body_format`); -- -- Indexes for table `node_revision__field_artykul_autor` -- ALTER TABLE `node_revision__field_artykul_autor` ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`), ADD KEY `bundle` (`bundle`), ADD KEY `revision_id` (`revision_id`); -- -- Indexes for table `node_revision__field_artykul_notki_biograficzne` -- ALTER TABLE `node_revision__field_artykul_notki_biograficzne` ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`), ADD KEY `bundle` (`bundle`), ADD KEY `revision_id` (`revision_id`), ADD KEY `field_artykul_notki_biograficzne_format` (`field_artykul_notki_biograficzne_format`); -- -- Indexes for table `node__body` -- ALTER TABLE `node__body` ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`), ADD KEY `bundle` (`bundle`), ADD KEY `revision_id` (`revision_id`), ADD KEY `body_format` (`body_format`); -- -- Indexes for table `node__field_artykul_autor` -- ALTER TABLE `node__field_artykul_autor` ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`), ADD KEY `bundle` (`bundle`), ADD KEY `revision_id` (`revision_id`); -- -- Indexes for table `node__field_artykul_notki_biograficzne` -- ALTER TABLE `node__field_artykul_notki_biograficzne` ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`), ADD KEY `bundle` (`bundle`), ADD KEY `revision_id` (`revision_id`), ADD KEY `field_artykul_notki_biograficzne_format` (`field_artykul_notki_biograficzne_format`); -- -- Indexes for table `queue` -- ALTER TABLE `queue` ADD PRIMARY KEY (`item_id`), ADD KEY `name_created` (`name`,`created`), ADD KEY `expire` (`expire`); -- -- Indexes for table `router` -- ALTER TABLE `router` ADD PRIMARY KEY (`name`), ADD KEY `pattern_outline_parts` (`pattern_outline`(191),`number_parts`); -- -- Indexes for table `search_dataset` -- ALTER TABLE `search_dataset` ADD PRIMARY KEY (`sid`,`langcode`,`type`); -- -- Indexes for table `search_index` -- ALTER TABLE `search_index` ADD PRIMARY KEY (`word`,`sid`,`langcode`,`type`), ADD KEY `sid_type` (`sid`,`langcode`,`type`); -- -- Indexes for table `search_total` -- ALTER TABLE `search_total` ADD PRIMARY KEY (`word`); -- -- Indexes for table `semaphore` -- ALTER TABLE `semaphore` ADD PRIMARY KEY (`name`), ADD KEY `value` (`value`), ADD KEY `expire` (`expire`); -- -- Indexes for table `sequences` -- ALTER TABLE `sequences` ADD PRIMARY KEY (`value`); -- -- Indexes for table `sessions` -- ALTER TABLE `sessions` ADD PRIMARY KEY (`sid`), ADD KEY `timestamp` (`timestamp`), ADD KEY `uid` (`uid`); -- -- Indexes for table `tracker_node` -- ALTER TABLE `tracker_node` ADD PRIMARY KEY (`nid`), ADD KEY `tracker` (`published`,`changed`); -- -- Indexes for table `tracker_user` -- ALTER TABLE `tracker_user` ADD PRIMARY KEY (`nid`,`uid`), ADD KEY `tracker` (`uid`,`published`,`changed`); -- -- Indexes for table `url_alias` -- ALTER TABLE `url_alias` ADD PRIMARY KEY (`pid`), ADD KEY `alias_langcode_pid` (`alias`(191),`langcode`,`pid`), ADD KEY `source_langcode_pid` (`source`(191),`langcode`,`pid`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`uid`), ADD UNIQUE KEY `user_field__uuid__value` (`uuid`); -- -- Indexes for table `users_data` -- ALTER TABLE `users_data` ADD PRIMARY KEY (`uid`,`module`,`name`), ADD KEY `module` (`module`), ADD KEY `name` (`name`); -- -- Indexes for table `users_field_data` -- ALTER TABLE `users_field_data` ADD PRIMARY KEY (`uid`,`langcode`), ADD UNIQUE KEY `user__name` (`name`,`langcode`), ADD KEY `user__id__default_langcode__langcode` (`uid`,`default_langcode`,`langcode`), ADD KEY `user_field__mail` (`mail`(191)), ADD KEY `user_field__created` (`created`), ADD KEY `user_field__access` (`access`); -- -- Indexes for table `user__field_user_imie` -- ALTER TABLE `user__field_user_imie` ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`), ADD KEY `bundle` (`bundle`), ADD KEY `revision_id` (`revision_id`); -- -- Indexes for table `user__field_user_nazwisko` -- ALTER TABLE `user__field_user_nazwisko` ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`), ADD KEY `bundle` (`bundle`), ADD KEY `revision_id` (`revision_id`); -- -- Indexes for table `user__roles` -- ALTER TABLE `user__roles` ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`), ADD KEY `bundle` (`bundle`), ADD KEY `revision_id` (`revision_id`), ADD KEY `roles_target_id` (`roles_target_id`); -- -- Indexes for table `watchdog` -- ALTER TABLE `watchdog` ADD PRIMARY KEY (`wid`), ADD KEY `type` (`type`), ADD KEY `uid` (`uid`), ADD KEY `severity` (`severity`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT dla tabeli `comment` -- ALTER TABLE `comment` MODIFY `cid` int(10) unsigned NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT dla tabeli `file_managed` -- ALTER TABLE `file_managed` MODIFY `fid` int(10) unsigned NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT dla tabeli `flood` -- ALTER TABLE `flood` MODIFY `fid` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Unique flood event ID.'; -- -- AUTO_INCREMENT dla tabeli `locales_location` -- ALTER TABLE `locales_location` MODIFY `lid` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Unique identifier of this location.',AUTO_INCREMENT=1039; -- -- AUTO_INCREMENT dla tabeli `locales_source` -- ALTER TABLE `locales_source` MODIFY `lid` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Unique identifier of this string.',AUTO_INCREMENT=5139; -- -- AUTO_INCREMENT dla tabeli `menu_tree` -- ALTER TABLE `menu_tree` MODIFY `mlid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'The menu link ID (mlid) is the integer primary key.',AUTO_INCREMENT=46; -- -- AUTO_INCREMENT dla tabeli `node` -- ALTER TABLE `node` MODIFY `nid` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2; -- -- AUTO_INCREMENT dla tabeli `node_revision` -- ALTER TABLE `node_revision` MODIFY `vid` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2; -- -- AUTO_INCREMENT dla tabeli `queue` -- ALTER TABLE `queue` MODIFY `item_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key: Unique item ID.',AUTO_INCREMENT=63; -- -- AUTO_INCREMENT dla tabeli `sequences` -- ALTER TABLE `sequences` MODIFY `value` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'The value of the sequence.',AUTO_INCREMENT=8; -- -- AUTO_INCREMENT dla tabeli `url_alias` -- ALTER TABLE `url_alias` MODIFY `pid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'A unique path alias identifier.'; -- -- AUTO_INCREMENT dla tabeli `watchdog` -- ALTER TABLE `watchdog` MODIFY `wid` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Primary Key: Unique watchdog event ID.',AUTO_INCREMENT=60; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;