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 */; -- -- Database: `drupal7102` -- -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]actions` -- CREATE TABLE `[[dbprefix]]actions` ( `aid` varchar(255) NOT NULL DEFAULT '0' COMMENT 'Primary Key: Unique actions ID.', `type` varchar(32) NOT NULL DEFAULT '' COMMENT 'The object that that action acts on (node, user, comment, system or custom types.)', `callback` varchar(255) NOT NULL DEFAULT '' COMMENT 'The callback function that executes when the action runs.', `parameters` longblob NOT NULL COMMENT 'Parameters to be passed to the callback function.', `label` varchar(255) NOT NULL DEFAULT '0' COMMENT 'Label of the action.', PRIMARY KEY (`aid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Stores action information.'; -- -- Dumping data for table `[[dbprefix]]actions` -- INSERT INTO `[[dbprefix]]actions` VALUES ('comment_publish_action', 'comment', 'comment_publish_action', '', 'Publish comment'), ('comment_save_action', 'comment', 'comment_save_action', '', 'Save comment'), ('comment_unpublish_action', 'comment', 'comment_unpublish_action', '', 'Unpublish comment'), ('node_make_sticky_action', 'node', 'node_make_sticky_action', '', 'Make content sticky'), ('node_make_unsticky_action', 'node', 'node_make_unsticky_action', '', 'Make content unsticky'), ('node_promote_action', 'node', 'node_promote_action', '', 'Promote content to front page'), ('node_publish_action', 'node', 'node_publish_action', '', 'Publish content'), ('node_save_action', 'node', 'node_save_action', '', 'Save content'), ('node_unpromote_action', 'node', 'node_unpromote_action', '', 'Remove content from front page'), ('node_unpublish_action', 'node', 'node_unpublish_action', '', 'Unpublish content'), ('system_block_ip_action', 'user', 'system_block_ip_action', '', 'Ban IP address of current user'), ('user_block_user_action', 'user', 'user_block_user_action', '', 'Block current user'), ('user_unblock_user_action', 'user', 'user_unblock_user_action', '', 'Unblock current user'); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]authmap` -- CREATE TABLE `[[dbprefix]]authmap` ( `aid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key: Unique authmap ID.', `uid` int(11) NOT NULL DEFAULT '0' COMMENT 'User’s `[[dbprefix]]users`.uid.', `authname` varchar(128) NOT NULL DEFAULT '' COMMENT 'Unique authentication name.', `module` varchar(128) NOT NULL DEFAULT '' COMMENT 'Module which is controlling the authentication.', PRIMARY KEY (`aid`), UNIQUE KEY `authname` (`authname`), KEY `uid_module` (`uid`,`module`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Stores distributed authentication mapping.' AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]batch` -- CREATE TABLE `[[dbprefix]]batch` ( `bid` int(10) unsigned NOT NULL COMMENT 'Primary Key: Unique batch ID.', `token` varchar(64) 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.', PRIMARY KEY (`bid`), KEY `token` (`token`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Stores details about batches (processes that run in...'; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]block` -- CREATE TABLE `[[dbprefix]]block` ( `bid` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Primary Key: Unique block ID.', `module` varchar(64) NOT NULL DEFAULT '' COMMENT 'The module from which the block originates; for example, ’user’ for the Who’s Online block, and ’block’ for any custom blocks.', `delta` varchar(32) NOT NULL DEFAULT '0' COMMENT 'Unique ID for block within a module.', `theme` varchar(64) NOT NULL DEFAULT '' COMMENT 'The theme under which the block settings apply.', `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Block enabled status. (1 = enabled, 0 = disabled)', `weight` int(11) NOT NULL DEFAULT '0' COMMENT 'Block weight within region.', `region` varchar(64) NOT NULL DEFAULT '' COMMENT 'Theme region within which the block is set.', `custom` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Flag to indicate how users may control visibility of the block. (0 = Users cannot control, 1 = On by default, but can be hidden, 2 = Hidden by default, but can be shown)', `visibility` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Flag to indicate how to show blocks on pages. (0 = Show on all pages except listed pages, 1 = Show only on listed pages, 2 = Use custom PHP code to determine visibility)', `pages` text NOT NULL COMMENT 'Contents of the "Pages" block; contains either a list of paths on which to include/exclude the block or PHP code, depending on "visibility" setting.', `title` varchar(255) NOT NULL DEFAULT '' COMMENT 'Custom title for the block. (Empty string will use block default title, will remove the title, text will cause block to use specified title.)', `cache` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'Binary flag to indicate block cache mode. (-2: Custom cache, -1: Do not cache, 1: Cache per role, 2: Cache per user, 4: Cache per page, 8: Block cache global) See DRUPAL_CACHE_* constants in ../includes/common.inc for more detailed information.', PRIMARY KEY (`bid`), UNIQUE KEY `tmd` (`theme`,`module`,`delta`), KEY `list` (`theme`,`status`,`region`,`weight`,`module`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Stores block settings, such as region and visibility...' AUTO_INCREMENT=31 ; -- -- Dumping data for table `[[dbprefix]]block` -- INSERT INTO `[[dbprefix]]block` VALUES (1, 'system', 'main', 'bartik', 1, 0, 'content', 0, 0, '', '', -1), (2, 'search', 'form', 'bartik', 1, -1, 'sidebar_first', 0, 0, '', '', -1), (3, 'node', 'recent', 'seven', 1, 10, 'dashboard_main', 0, 0, '', '', -1), (4, 'user', 'login', 'bartik', 1, 0, 'sidebar_first', 0, 0, '', '', -1), (5, 'system', 'navigation', 'bartik', 1, 0, 'sidebar_first', 0, 0, '', '', -1), (6, 'system', 'powered-by', 'bartik', 1, 10, 'footer', 0, 0, '', '', -1), (7, 'system', 'help', 'bartik', 1, 0, 'help', 0, 0, '', '', -1), (8, 'system', 'main', 'seven', 1, 0, 'content', 0, 0, '', '', -1), (9, 'system', 'help', 'seven', 1, 0, 'help', 0, 0, '', '', -1), (10, 'user', 'login', 'seven', 1, 10, 'content', 0, 0, '', '', -1), (11, 'user', 'new', 'seven', 1, 0, 'dashboard_sidebar', 0, 0, '', '', -1), (12, 'search', 'form', 'seven', 1, -10, 'dashboard_sidebar', 0, 0, '', '', -1), (13, 'comment', 'recent', 'bartik', 0, 0, '-1', 0, 0, '', '', 1), (14, 'node', 'syndicate', 'bartik', 0, 0, '-1', 0, 0, '', '', -1), (15, 'node', 'recent', 'bartik', 0, 0, '-1', 0, 0, '', '', 1), (16, 'shortcut', 'shortcuts', 'bartik', 0, 0, '-1', 0, 0, '', '', -1), (17, 'system', 'management', 'bartik', 0, 0, '-1', 0, 0, '', '', -1), (18, 'system', 'user-menu', 'bartik', 0, 0, '-1', 0, 0, '', '', -1), (19, 'system', 'main-menu', 'bartik', 0, 0, '-1', 0, 0, '', '', -1), (20, 'user', 'new', 'bartik', 0, 0, '-1', 0, 0, '', '', 1), (21, 'user', 'online', 'bartik', 0, 0, '-1', 0, 0, '', '', -1), (22, 'comment', 'recent', 'seven', 1, 0, 'dashboard_inactive', 0, 0, '', '', 1), (23, 'node', 'syndicate', 'seven', 0, 0, '-1', 0, 0, '', '', -1), (24, 'shortcut', 'shortcuts', 'seven', 0, 0, '-1', 0, 0, '', '', -1), (25, 'system', 'powered-by', 'seven', 0, 10, '-1', 0, 0, '', '', -1), (26, 'system', 'navigation', 'seven', 0, 0, '-1', 0, 0, '', '', -1), (27, 'system', 'management', 'seven', 0, 0, '-1', 0, 0, '', '', -1), (28, 'system', 'user-menu', 'seven', 0, 0, '-1', 0, 0, '', '', -1), (29, 'system', 'main-menu', 'seven', 0, 0, '-1', 0, 0, '', '', -1), (30, 'user', 'online', 'seven', 1, 0, 'dashboard_inactive', 0, 0, '', '', -1); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]blocked_ips` -- CREATE TABLE `[[dbprefix]]blocked_ips` ( `iid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key: unique ID for IP addresses.', `ip` varchar(40) NOT NULL DEFAULT '' COMMENT 'IP address', PRIMARY KEY (`iid`), KEY `blocked_ip` (`ip`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Stores blocked IP addresses.' AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]block_custom` -- CREATE TABLE `[[dbprefix]]block_custom` ( `bid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'The block’s `[[dbprefix]]block`.bid.', `body` longtext COMMENT 'Block contents.', `info` varchar(128) NOT NULL DEFAULT '' COMMENT 'Block description.', `format` varchar(255) DEFAULT NULL COMMENT 'The `[[dbprefix]]filter_format`.format of the block body.', PRIMARY KEY (`bid`), UNIQUE KEY `info` (`info`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Stores contents of custom-made blocks.' AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]block_node_type` -- CREATE TABLE `[[dbprefix]]block_node_type` ( `module` varchar(64) NOT NULL COMMENT 'The block’s origin module, from `[[dbprefix]]block`.module.', `delta` varchar(32) NOT NULL COMMENT 'The block’s unique delta within module, from `[[dbprefix]]block`.delta.', `type` varchar(32) NOT NULL COMMENT 'The machine-readable name of this type from `[[dbprefix]]node_type`.type.', PRIMARY KEY (`module`,`delta`,`type`), KEY `type` (`type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sets up display criteria for blocks based on content types'; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]block_role` -- CREATE TABLE `[[dbprefix]]block_role` ( `module` varchar(64) NOT NULL COMMENT 'The block’s origin module, from `[[dbprefix]]block`.module.', `delta` varchar(32) NOT NULL COMMENT 'The block’s unique delta within module, from `[[dbprefix]]block`.delta.', `rid` int(10) unsigned NOT NULL COMMENT 'The user’s role ID from `[[dbprefix]]users_roles`.rid.', PRIMARY KEY (`module`,`delta`,`rid`), KEY `rid` (`rid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sets up access permissions for blocks based on user roles'; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]cache` -- CREATE TABLE `[[dbprefix]]cache` ( `cid` varchar(255) 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 0 for never.', `created` int(11) NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp 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).', PRIMARY KEY (`cid`), KEY `expire` (`expire`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Generic cache table for caching things not separated out...'; -- -- Dumping data for table `[[dbprefix]]cache` -- -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]cache_block` -- CREATE TABLE `[[dbprefix]]cache_block` ( `cid` varchar(255) 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 0 for never.', `created` int(11) NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp 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).', PRIMARY KEY (`cid`), KEY `expire` (`expire`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Cache table for the Block module to store already built...'; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]cache_bootstrap` -- CREATE TABLE `[[dbprefix]]cache_bootstrap` ( `cid` varchar(255) 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 0 for never.', `created` int(11) NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp 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).', PRIMARY KEY (`cid`), KEY `expire` (`expire`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Cache table for data required to bootstrap Drupal, may be...'; -- -- Dumping data for table `[[dbprefix]]cache_bootstrap` -- -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]cache_field` -- CREATE TABLE `[[dbprefix]]cache_field` ( `cid` varchar(255) 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 0 for never.', `created` int(11) NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp 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).', PRIMARY KEY (`cid`), KEY `expire` (`expire`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Cache table for the Field module to store already built...'; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]cache_filter` -- CREATE TABLE `[[dbprefix]]cache_filter` ( `cid` varchar(255) 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 0 for never.', `created` int(11) NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp 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).', PRIMARY KEY (`cid`), KEY `expire` (`expire`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Cache table for the Filter module to store already...'; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]cache_form` -- CREATE TABLE `[[dbprefix]]cache_form` ( `cid` varchar(255) 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 0 for never.', `created` int(11) NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp 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).', PRIMARY KEY (`cid`), KEY `expire` (`expire`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Cache table for the form system to store recently built...'; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]cache_image` -- CREATE TABLE `[[dbprefix]]cache_image` ( `cid` varchar(255) 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 0 for never.', `created` int(11) NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp 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).', PRIMARY KEY (`cid`), KEY `expire` (`expire`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Cache table used to store information about image...'; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]cache_menu` -- CREATE TABLE `[[dbprefix]]cache_menu` ( `cid` varchar(255) 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 0 for never.', `created` int(11) NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp 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).', PRIMARY KEY (`cid`), KEY `expire` (`expire`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Cache table for the menu system to store router...'; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]cache_page` -- CREATE TABLE `[[dbprefix]]cache_page` ( `cid` varchar(255) 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 0 for never.', `created` int(11) NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp 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).', PRIMARY KEY (`cid`), KEY `expire` (`expire`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Cache table used to store compressed pages for anonymous...'; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]cache_path` -- CREATE TABLE `[[dbprefix]]cache_path` ( `cid` varchar(255) 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 0 for never.', `created` int(11) NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp 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).', PRIMARY KEY (`cid`), KEY `expire` (`expire`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Cache table for path alias lookup.'; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]cache_update` -- CREATE TABLE `[[dbprefix]]cache_update` ( `cid` varchar(255) 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 0 for never.', `created` int(11) NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp 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).', PRIMARY KEY (`cid`), KEY `expire` (`expire`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Cache table for the Update module to store information...'; -- -- Dumping data for table `[[dbprefix]]cache_update` -- -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]comment` -- CREATE TABLE `[[dbprefix]]comment` ( `cid` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Primary Key: Unique comment ID.', `pid` int(11) NOT NULL DEFAULT '0' COMMENT 'The `[[dbprefix]]comment`.cid to which this comment is a reply. If set to 0, this comment is not a reply to an existing comment.', `nid` int(11) NOT NULL DEFAULT '0' COMMENT 'The `[[dbprefix]]node`.nid to which this comment is a reply.', `uid` int(11) NOT NULL DEFAULT '0' COMMENT 'The `[[dbprefix]]users`.uid who authored the comment. If set to 0, this comment was created by an anonymous user.', `subject` varchar(64) NOT NULL DEFAULT '' COMMENT 'The comment title.', `hostname` varchar(128) NOT NULL DEFAULT '' COMMENT 'The author’s host name.', `created` int(11) NOT NULL DEFAULT '0' COMMENT 'The time that the comment was created, as a Unix timestamp.', `changed` int(11) NOT NULL DEFAULT '0' COMMENT 'The time that the comment was last edited, as a Unix timestamp.', `status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT 'The published status of a comment. (0 = Not Published, 1 = Published)', `thread` varchar(255) NOT NULL COMMENT 'The vancode representation of the comment’s place in a thread.', `name` varchar(60) DEFAULT NULL COMMENT 'The comment author’s name. Uses `[[dbprefix]]users`.name if the user is logged in, otherwise uses the value typed into the comment form.', `mail` varchar(64) DEFAULT NULL COMMENT 'The comment author’s e-mail address from the comment form, if user is anonymous, and the ’Anonymous users may/must leave their contact information’ setting is turned on.', `homepage` varchar(255) DEFAULT NULL COMMENT 'The comment author’s home page address from the comment form, if user is anonymous, and the ’Anonymous users may/must leave their contact information’ setting is turned on.', `language` varchar(12) NOT NULL DEFAULT '' COMMENT 'The `[[dbprefix]]languages`.language of this comment.', PRIMARY KEY (`cid`), KEY `comment_status_pid` (`pid`,`status`), KEY `comment_num_new` (`nid`,`status`,`created`,`cid`,`thread`), KEY `comment_uid` (`uid`), KEY `comment_nid_language` (`nid`,`language`), KEY `comment_created` (`created`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Stores comments and associated data.' AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]date_formats` -- CREATE TABLE `[[dbprefix]]date_formats` ( `dfid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'The date format identifier.', `format` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'The date format string.', `type` varchar(64) NOT NULL COMMENT 'The date format type, e.g. medium.', `locked` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Whether or not this format can be modified.', PRIMARY KEY (`dfid`), UNIQUE KEY `formats` (`format`,`type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Stores configured date formats.' AUTO_INCREMENT=36 ; -- -- Dumping data for table `[[dbprefix]]date_formats` -- INSERT INTO `[[dbprefix]]date_formats` VALUES (1, 'm/d/Y - H:i', 'short', 1), (2, 'd/m/Y - H:i', 'short', 1), (3, 'Y/m/d - H:i', 'short', 1), (4, 'd.m.Y - H:i', 'short', 1), (5, 'Y-m-d H:i', 'short', 1), (6, 'm/d/Y - g:ia', 'short', 1), (7, 'd/m/Y - g:ia', 'short', 1), (8, 'Y/m/d - g:ia', 'short', 1), (9, 'M j Y - H:i', 'short', 1), (10, 'j M Y - H:i', 'short', 1), (11, 'Y M j - H:i', 'short', 1), (12, 'M j Y - g:ia', 'short', 1), (13, 'j M Y - g:ia', 'short', 1), (14, 'Y M j - g:ia', 'short', 1), (15, 'D, m/d/Y - H:i', 'medium', 1), (16, 'D, d/m/Y - H:i', 'medium', 1), (17, 'D, Y/m/d - H:i', 'medium', 1), (18, 'D, Y-m-d H:i', 'medium', 1), (19, 'F j, Y - H:i', 'medium', 1), (20, 'j F, Y - H:i', 'medium', 1), (21, 'Y, F j - H:i', 'medium', 1), (22, 'D, m/d/Y - g:ia', 'medium', 1), (23, 'D, d/m/Y - g:ia', 'medium', 1), (24, 'D, Y/m/d - g:ia', 'medium', 1), (25, 'F j, Y - g:ia', 'medium', 1), (26, 'j F Y - g:ia', 'medium', 1), (27, 'Y, F j - g:ia', 'medium', 1), (28, 'j. F Y - G:i', 'medium', 1), (29, 'l, F j, Y - H:i', 'long', 1), (30, 'l, j F, Y - H:i', 'long', 1), (31, 'l, Y, F j - H:i', 'long', 1), (32, 'l, F j, Y - g:ia', 'long', 1), (33, 'l, j F Y - g:ia', 'long', 1), (34, 'l, Y, F j - g:ia', 'long', 1), (35, 'l, j. F Y - G:i', 'long', 1); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]date_format_locale` -- CREATE TABLE `[[dbprefix]]date_format_locale` ( `format` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'The date format string.', `type` varchar(64) NOT NULL COMMENT 'The date format type, e.g. medium.', `language` varchar(12) NOT NULL COMMENT 'A `[[dbprefix]]languages`.language for this format to be used with.', PRIMARY KEY (`type`,`language`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Stores configured date formats for each locale.'; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]date_format_type` -- CREATE TABLE `[[dbprefix]]date_format_type` ( `type` varchar(64) NOT NULL COMMENT 'The date format type, e.g. medium.', `title` varchar(255) NOT NULL COMMENT 'The human readable name of the format type.', `locked` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Whether or not this is a system provided format.', PRIMARY KEY (`type`), KEY `title` (`title`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Stores configured date format types.'; -- -- Dumping data for table `[[dbprefix]]date_format_type` -- INSERT INTO `[[dbprefix]]date_format_type` VALUES ('long', 'Long', 1), ('medium', 'Medium', 1), ('short', 'Short', 1); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]field_config` -- CREATE TABLE `[[dbprefix]]field_config` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'The primary identifier for a field', `field_name` varchar(32) NOT NULL COMMENT 'The name of this field. Non-deleted field names are unique, but multiple deleted fields can have the same name.', `type` varchar(128) NOT NULL COMMENT 'The type of this field.', `module` varchar(128) NOT NULL DEFAULT '' COMMENT 'The module that implements the field type.', `active` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Boolean indicating whether the module that implements the field type is enabled.', `storage_type` varchar(128) NOT NULL COMMENT 'The storage backend for the field.', `storage_module` varchar(128) NOT NULL DEFAULT '' COMMENT 'The module that implements the storage backend.', `storage_active` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Boolean indicating whether the module that implements the storage backend is enabled.', `locked` tinyint(4) NOT NULL DEFAULT '0' COMMENT '@TODO', `data` longblob NOT NULL COMMENT 'Serialized data containing the field properties that do not warrant a dedicated column.', `cardinality` tinyint(4) NOT NULL DEFAULT '0', `translatable` tinyint(4) NOT NULL DEFAULT '0', `deleted` tinyint(4) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `field_name` (`field_name`), KEY `active` (`active`), KEY `storage_active` (`storage_active`), KEY `deleted` (`deleted`), KEY `module` (`module`), KEY `storage_module` (`storage_module`), KEY `type` (`type`), KEY `storage_type` (`storage_type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ; -- -- Dumping data for table `[[dbprefix]]field_config` -- INSERT INTO `[[dbprefix]]field_config` VALUES (1, 'comment_body', 'text_long', 'text', 1, 'field_sql_storage', 'field_sql_storage', 1, 0, 'a:6:{s:12:"entity_types";a:1:{i:0;s:7:"comment";}s:12:"translatable";b:0;s:8:"settings";a:0:{}s:7:"storage";a:4:{s:4:"type";s:17:"field_sql_storage";s:8:"settings";a:0:{}s:6:"module";s:17:"field_sql_storage";s:6:"active";i:1;}s:12:"foreign keys";a:1:{s:6:"format";a:2:{s:5:"table";s:13:"filter_format";s:7:"columns";a:1:{s:6:"format";s:6:"format";}}}s:7:"indexes";a:1:{s:6:"format";a:1:{i:0;s:6:"format";}}}', 1, 0, 0), (2, 'body', 'text_with_summary', 'text', 1, 'field_sql_storage', 'field_sql_storage', 1, 0, 'a:6:{s:12:"entity_types";a:1:{i:0;s:4:"node";}s:12:"translatable";b:0;s:8:"settings";a:0:{}s:7:"storage";a:4:{s:4:"type";s:17:"field_sql_storage";s:8:"settings";a:0:{}s:6:"module";s:17:"field_sql_storage";s:6:"active";i:1;}s:12:"foreign keys";a:1:{s:6:"format";a:2:{s:5:"table";s:13:"filter_format";s:7:"columns";a:1:{s:6:"format";s:6:"format";}}}s:7:"indexes";a:1:{s:6:"format";a:1:{i:0;s:6:"format";}}}', 1, 0, 0), (3, 'field_tags', 'taxonomy_term_reference', 'taxonomy', 1, 'field_sql_storage', 'field_sql_storage', 1, 0, 'a:6:{s:8:"settings";a:1:{s:14:"allowed_values";a:1:{i:0;a:2:{s:10:"vocabulary";s:4:"tags";s:6:"parent";i:0;}}}s:12:"entity_types";a:0:{}s:12:"translatable";b:0;s:7:"storage";a:4:{s:4:"type";s:17:"field_sql_storage";s:8:"settings";a:0:{}s:6:"module";s:17:"field_sql_storage";s:6:"active";i:1;}s:12:"foreign keys";a:1:{s:3:"tid";a:2:{s:5:"table";s:18:"taxonomy_term_data";s:7:"columns";a:1:{s:3:"tid";s:3:"tid";}}}s:7:"indexes";a:1:{s:3:"tid";a:1:{i:0;s:3:"tid";}}}', -1, 0, 0), (4, 'field_image', 'image', 'image', 1, 'field_sql_storage', 'field_sql_storage', 1, 0, 'a:6:{s:7:"indexes";a:1:{s:3:"fid";a:1:{i:0;s:3:"fid";}}s:8:"settings";a:2:{s:10:"uri_scheme";s:6:"public";s:13:"default_image";b:0;}s:7:"storage";a:4:{s:4:"type";s:17:"field_sql_storage";s:8:"settings";a:0:{}s:6:"module";s:17:"field_sql_storage";s:6:"active";i:1;}s:12:"entity_types";a:0:{}s:12:"translatable";b:0;s:12:"foreign keys";a:1:{s:3:"fid";a:2:{s:5:"table";s:12:"file_managed";s:7:"columns";a:1:{s:3:"fid";s:3:"fid";}}}}', 1, 0, 0); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]field_config_instance` -- CREATE TABLE `[[dbprefix]]field_config_instance` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'The primary identifier for a field instance', `field_id` int(11) NOT NULL COMMENT 'The identifier of the field attached by this instance', `field_name` varchar(32) NOT NULL DEFAULT '', `entity_type` varchar(32) NOT NULL DEFAULT '', `bundle` varchar(128) NOT NULL DEFAULT '', `data` longblob NOT NULL, `deleted` tinyint(4) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `field_name_bundle` (`field_name`,`entity_type`,`bundle`), KEY `deleted` (`deleted`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ; -- -- Dumping data for table `[[dbprefix]]field_config_instance` -- INSERT INTO `[[dbprefix]]field_config_instance` VALUES (1, 1, 'comment_body', 'comment', 'comment_node_page', 'a:6:{s:5:"label";s:7:"Comment";s:8:"settings";a:2:{s:15:"text_processing";i:1;s:18:"user_register_form";b:0;}s:8:"required";b:1;s:7:"display";a:1:{s:7:"default";a:5:{s:5:"label";s:6:"hidden";s:4:"type";s:12:"text_default";s:6:"weight";i:0;s:8:"settings";a:0:{}s:6:"module";s:4:"text";}}s:6:"widget";a:4:{s:4:"type";s:13:"text_textarea";s:8:"settings";a:1:{s:4:"rows";i:5;}s:6:"weight";i:0;s:6:"module";s:4:"text";}s:11:"description";s:0:"";}', 0), (2, 2, 'body', 'node', 'page', 'a:6:{s:5:"label";s:4:"Body";s:6:"widget";a:4:{s:4:"type";s:26:"text_textarea_with_summary";s:8:"settings";a:2:{s:4:"rows";i:20;s:12:"summary_rows";i:5;}s:6:"weight";i:-4;s:6:"module";s:4:"text";}s:8:"settings";a:3:{s:15:"display_summary";b:1;s:15:"text_processing";i:1;s:18:"user_register_form";b:0;}s:7:"display";a:2:{s:7:"default";a:5:{s:5:"label";s:6:"hidden";s:4:"type";s:12:"text_default";s:8:"settings";a:0:{}s:6:"module";s:4:"text";s:6:"weight";i:0;}s:6:"teaser";a:5:{s:5:"label";s:6:"hidden";s:4:"type";s:23:"text_summary_or_trimmed";s:8:"settings";a:1:{s:11:"trim_length";i:600;}s:6:"module";s:4:"text";s:6:"weight";i:0;}}s:8:"required";b:0;s:11:"description";s:0:"";}', 0), (3, 1, 'comment_body', 'comment', 'comment_node_article', 'a:6:{s:5:"label";s:7:"Comment";s:8:"settings";a:2:{s:15:"text_processing";i:1;s:18:"user_register_form";b:0;}s:8:"required";b:1;s:7:"display";a:1:{s:7:"default";a:5:{s:5:"label";s:6:"hidden";s:4:"type";s:12:"text_default";s:6:"weight";i:0;s:8:"settings";a:0:{}s:6:"module";s:4:"text";}}s:6:"widget";a:4:{s:4:"type";s:13:"text_textarea";s:8:"settings";a:1:{s:4:"rows";i:5;}s:6:"weight";i:0;s:6:"module";s:4:"text";}s:11:"description";s:0:"";}', 0), (4, 2, 'body', 'node', 'article', 'a:6:{s:5:"label";s:4:"Body";s:6:"widget";a:4:{s:4:"type";s:26:"text_textarea_with_summary";s:8:"settings";a:2:{s:4:"rows";i:20;s:12:"summary_rows";i:5;}s:6:"weight";i:-4;s:6:"module";s:4:"text";}s:8:"settings";a:3:{s:15:"display_summary";b:1;s:15:"text_processing";i:1;s:18:"user_register_form";b:0;}s:7:"display";a:2:{s:7:"default";a:5:{s:5:"label";s:6:"hidden";s:4:"type";s:12:"text_default";s:8:"settings";a:0:{}s:6:"module";s:4:"text";s:6:"weight";i:0;}s:6:"teaser";a:5:{s:5:"label";s:6:"hidden";s:4:"type";s:23:"text_summary_or_trimmed";s:8:"settings";a:1:{s:11:"trim_length";i:600;}s:6:"module";s:4:"text";s:6:"weight";i:0;}}s:8:"required";b:0;s:11:"description";s:0:"";}', 0), (5, 3, 'field_tags', 'node', 'article', 'a:6:{s:5:"label";s:4:"Tags";s:11:"description";s:63:"Enter a comma-separated list of words to describe your content.";s:6:"widget";a:4:{s:4:"type";s:21:"taxonomy_autocomplete";s:6:"weight";i:-4;s:8:"settings";a:2:{s:4:"size";i:60;s:17:"autocomplete_path";s:21:"taxonomy/autocomplete";}s:6:"module";s:8:"taxonomy";}s:7:"display";a:2:{s:7:"default";a:5:{s:4:"type";s:28:"taxonomy_term_reference_link";s:6:"weight";i:10;s:5:"label";s:5:"above";s:8:"settings";a:0:{}s:6:"module";s:8:"taxonomy";}s:6:"teaser";a:5:{s:4:"type";s:28:"taxonomy_term_reference_link";s:6:"weight";i:10;s:5:"label";s:5:"above";s:8:"settings";a:0:{}s:6:"module";s:8:"taxonomy";}}s:8:"settings";a:1:{s:18:"user_register_form";b:0;}s:8:"required";b:0;}', 0), (6, 4, 'field_image', 'node', 'article', 'a:6:{s:5:"label";s:5:"Image";s:11:"description";s:40:"Upload an image to go with this article.";s:8:"required";b:0;s:8:"settings";a:9:{s:14:"file_directory";s:31:"[date:custom:Y]-[date:custom:m]";s:15:"file_extensions";s:16:"png gif jpg jpeg";s:12:"max_filesize";s:0:"";s:14:"max_resolution";s:0:"";s:14:"min_resolution";s:0:"";s:9:"alt_field";b:1;s:11:"title_field";s:0:"";s:13:"default_image";i:0;s:18:"user_register_form";b:0;}s:6:"widget";a:4:{s:4:"type";s:11:"image_image";s:8:"settings";a:2:{s:18:"progress_indicator";s:8:"throbber";s:19:"preview_image_style";s:9:"thumbnail";}s:6:"weight";i:-1;s:6:"module";s:5:"image";}s:7:"display";a:2:{s:7:"default";a:5:{s:5:"label";s:6:"hidden";s:4:"type";s:5:"image";s:8:"settings";a:2:{s:11:"image_style";s:5:"large";s:10:"image_link";s:0:"";}s:6:"weight";i:-1;s:6:"module";s:5:"image";}s:6:"teaser";a:5:{s:5:"label";s:6:"hidden";s:4:"type";s:5:"image";s:8:"settings";a:2:{s:11:"image_style";s:6:"medium";s:10:"image_link";s:7:"content";}s:6:"weight";i:-1;s:6:"module";s:5:"image";}}}', 0); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]field_data_body` -- CREATE TABLE `[[dbprefix]]field_data_body` ( `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to', `bundle` varchar(128) 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 DEFAULT NULL COMMENT 'The entity revision id this data is attached to, or NULL if the entity type is not versioned', `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language 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, `body_summary` longtext, `body_format` varchar(255) DEFAULT NULL, PRIMARY KEY (`entity_type`,`entity_id`,`deleted`,`delta`,`language`), KEY `entity_type` (`entity_type`), KEY `bundle` (`bundle`), KEY `deleted` (`deleted`), KEY `entity_id` (`entity_id`), KEY `revision_id` (`revision_id`), KEY `language` (`language`), KEY `body_format` (`body_format`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Data storage for field 2 (body)'; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]field_data_comment_body` -- CREATE TABLE `[[dbprefix]]field_data_comment_body` ( `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to', `bundle` varchar(128) 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 DEFAULT NULL COMMENT 'The entity revision id this data is attached to, or NULL if the entity type is not versioned', `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language 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, `comment_body_format` varchar(255) DEFAULT NULL, PRIMARY KEY (`entity_type`,`entity_id`,`deleted`,`delta`,`language`), KEY `entity_type` (`entity_type`), KEY `bundle` (`bundle`), KEY `deleted` (`deleted`), KEY `entity_id` (`entity_id`), KEY `revision_id` (`revision_id`), KEY `language` (`language`), KEY `comment_body_format` (`comment_body_format`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Data storage for field 1 (comment_body)'; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]field_data_field_image` -- CREATE TABLE `[[dbprefix]]field_data_field_image` ( `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to', `bundle` varchar(128) 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 DEFAULT NULL COMMENT 'The entity revision id this data is attached to, or NULL if the entity type is not versioned', `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.', `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields', `field_image_fid` int(10) unsigned DEFAULT NULL COMMENT 'The `[[dbprefix]]file_managed`.fid being referenced in this field.', `field_image_alt` varchar(512) DEFAULT NULL COMMENT 'Alternative image text, for the image’s ’alt’ attribute.', `field_image_title` varchar(1024) DEFAULT NULL COMMENT 'Image title text, for the image’s ’title’ attribute.', `field_image_width` int(10) unsigned DEFAULT NULL COMMENT 'The width of the image in pixels.', `field_image_height` int(10) unsigned DEFAULT NULL COMMENT 'The height of the image in pixels.', PRIMARY KEY (`entity_type`,`entity_id`,`deleted`,`delta`,`language`), KEY `entity_type` (`entity_type`), KEY `bundle` (`bundle`), KEY `deleted` (`deleted`), KEY `entity_id` (`entity_id`), KEY `revision_id` (`revision_id`), KEY `language` (`language`), KEY `field_image_fid` (`field_image_fid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Data storage for field 4 (field_image)'; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]field_data_field_tags` -- CREATE TABLE `[[dbprefix]]field_data_field_tags` ( `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to', `bundle` varchar(128) 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 DEFAULT NULL COMMENT 'The entity revision id this data is attached to, or NULL if the entity type is not versioned', `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.', `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields', `field_tags_tid` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`entity_type`,`entity_id`,`deleted`,`delta`,`language`), KEY `entity_type` (`entity_type`), KEY `bundle` (`bundle`), KEY `deleted` (`deleted`), KEY `entity_id` (`entity_id`), KEY `revision_id` (`revision_id`), KEY `language` (`language`), KEY `field_tags_tid` (`field_tags_tid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Data storage for field 3 (field_tags)'; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]field_revision_body` -- CREATE TABLE `[[dbprefix]]field_revision_body` ( `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to', `bundle` varchar(128) 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', `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language 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, `body_summary` longtext, `body_format` varchar(255) DEFAULT NULL, PRIMARY KEY (`entity_type`,`entity_id`,`revision_id`,`deleted`,`delta`,`language`), KEY `entity_type` (`entity_type`), KEY `bundle` (`bundle`), KEY `deleted` (`deleted`), KEY `entity_id` (`entity_id`), KEY `revision_id` (`revision_id`), KEY `language` (`language`), KEY `body_format` (`body_format`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Revision archive storage for field 2 (body)'; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]field_revision_comment_body` -- CREATE TABLE `[[dbprefix]]field_revision_comment_body` ( `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to', `bundle` varchar(128) 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', `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language 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, `comment_body_format` varchar(255) DEFAULT NULL, PRIMARY KEY (`entity_type`,`entity_id`,`revision_id`,`deleted`,`delta`,`language`), KEY `entity_type` (`entity_type`), KEY `bundle` (`bundle`), KEY `deleted` (`deleted`), KEY `entity_id` (`entity_id`), KEY `revision_id` (`revision_id`), KEY `language` (`language`), KEY `comment_body_format` (`comment_body_format`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Revision archive storage for field 1 (comment_body)'; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]field_revision_field_image` -- CREATE TABLE `[[dbprefix]]field_revision_field_image` ( `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to', `bundle` varchar(128) 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', `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.', `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields', `field_image_fid` int(10) unsigned DEFAULT NULL COMMENT 'The `[[dbprefix]]file_managed`.fid being referenced in this field.', `field_image_alt` varchar(512) DEFAULT NULL COMMENT 'Alternative image text, for the image’s ’alt’ attribute.', `field_image_title` varchar(1024) DEFAULT NULL COMMENT 'Image title text, for the image’s ’title’ attribute.', `field_image_width` int(10) unsigned DEFAULT NULL COMMENT 'The width of the image in pixels.', `field_image_height` int(10) unsigned DEFAULT NULL COMMENT 'The height of the image in pixels.', PRIMARY KEY (`entity_type`,`entity_id`,`revision_id`,`deleted`,`delta`,`language`), KEY `entity_type` (`entity_type`), KEY `bundle` (`bundle`), KEY `deleted` (`deleted`), KEY `entity_id` (`entity_id`), KEY `revision_id` (`revision_id`), KEY `language` (`language`), KEY `field_image_fid` (`field_image_fid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Revision archive storage for field 4 (field_image)'; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]field_revision_field_tags` -- CREATE TABLE `[[dbprefix]]field_revision_field_tags` ( `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to', `bundle` varchar(128) 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', `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.', `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields', `field_tags_tid` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`entity_type`,`entity_id`,`revision_id`,`deleted`,`delta`,`language`), KEY `entity_type` (`entity_type`), KEY `bundle` (`bundle`), KEY `deleted` (`deleted`), KEY `entity_id` (`entity_id`), KEY `revision_id` (`revision_id`), KEY `language` (`language`), KEY `field_tags_tid` (`field_tags_tid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Revision archive storage for field 3 (field_tags)'; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]file_managed` -- CREATE TABLE `[[dbprefix]]file_managed` ( `fid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'File ID.', `uid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'The `[[dbprefix]]users`.uid of the user who is associated with the file.', `filename` varchar(255) NOT NULL DEFAULT '' COMMENT 'Name of the file with no path components. This may differ from the basename of the URI if the file is renamed to avoid overwriting an existing file.', `uri` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT 'The URI to access the file (either local or remote).', `filemime` varchar(255) NOT NULL DEFAULT '' COMMENT 'The file’s MIME type.', `filesize` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'The size of the file in bytes.', `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A field indicating the status of the file. Two status are defined in core: temporary (0) and permanent (1). Temporary files older than DRUPAL_MAXIMUM_TEMP_FILE_AGE will be removed during a cron run.', `timestamp` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'UNIX timestamp for when the file was added.', PRIMARY KEY (`fid`), UNIQUE KEY `uri` (`uri`), KEY `uid` (`uid`), KEY `status` (`status`), KEY `timestamp` (`timestamp`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Stores information for uploaded files.' AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]file_usage` -- CREATE TABLE `[[dbprefix]]file_usage` ( `fid` int(10) unsigned NOT NULL COMMENT 'File ID.', `module` varchar(255) NOT NULL DEFAULT '' COMMENT 'The name of the module that is using the file.', `type` varchar(64) NOT NULL DEFAULT '' COMMENT 'The name of the object type in which the file is used.', `id` int(10) unsigned 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.', PRIMARY KEY (`fid`,`type`,`id`,`module`), KEY `type_id` (`type`,`id`), KEY `fid_count` (`fid`,`count`), KEY `fid_module` (`fid`,`module`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Track where a file is used.'; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]filter` -- CREATE TABLE `[[dbprefix]]filter` ( `format` varchar(255) NOT NULL COMMENT 'Foreign key: The `[[dbprefix]]filter_format`.format to which this filter is assigned.', `module` varchar(64) NOT NULL DEFAULT '' COMMENT 'The origin module of the filter.', `name` varchar(32) NOT NULL DEFAULT '' COMMENT 'Name of the filter being referenced.', `weight` int(11) NOT NULL DEFAULT '0' COMMENT 'Weight of filter within format.', `status` int(11) NOT NULL DEFAULT '0' COMMENT 'Filter enabled status. (1 = enabled, 0 = disabled)', `settings` longblob COMMENT 'A serialized array of name value pairs that store the filter settings for the specific format.', PRIMARY KEY (`format`,`name`), KEY `list` (`weight`,`module`,`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Table that maps filters (HTML corrector) to text formats ...'; -- -- Dumping data for table `[[dbprefix]]filter` -- INSERT INTO `[[dbprefix]]filter` VALUES ('filtered_html', 'filter', 'filter_autop', 2, 1, 'a:0:{}'), ('filtered_html', 'filter', 'filter_html', 1, 1, 'a:3:{s:12:"allowed_html";s:74:"