------------------------------------------------------------------------------------ MySQL Workbench Migration Wizard Report Date: Wed Aug 01 09:48:22 2012 Source: MySQL 5.5.16 Target: MySQL 5.5.16 ------------------------------------------------------------------------------------ I. Migration 1. Summary Number of migrated schemata: 1 1. test Source Schema: test - Tables: 64 - Triggers: 0 - Views: 0 - Stored Procedures: 0 - Functions: 0 2. Migration Issues 3. Object Creation Issues 4. Migration Details 4.1. Table test.actions (actions) Stores action information. Columns: - aid VARCHAR(255) '0' #Primary Key: Unique actions ID. - type VARCHAR(32) '' #The object that that action acts on (node, user, comment, system or custom types.) - callback VARCHAR(255) '' #The callback function that executes when the action runs. - parameters LONGBLOB #Parameters to be passed to the callback function. - label VARCHAR(255) '0' #Label of the action. Foreign Keys: Indices: - PRIMARY (aid) 4.2. Table test.authmap (authmap) Stores distributed authentication mapping. Columns: - aid INT(10) UNSIGNED #Primary Key: Unique authmap ID. - uid INT(11) '0' #User’s users.uid. - authname VARCHAR(128) '' #Unique authentication name. - module VARCHAR(128) '' #Module which is controlling the authentication. Foreign Keys: Indices: - PRIMARY (aid) - authname (authname) 4.3. Table test.batch (batch) Stores details about batches (processes that run in... Columns: - bid INT(10) UNSIGNED #Primary Key: Unique batch ID. - token VARCHAR(64) #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) #A Unix timestamp indicating when this batch was submitted for processing. Stale batches are purged at cron time. - batch LONGBLOB NULL #A serialized array containing the processing data for the batch. Foreign Keys: Indices: - PRIMARY (bid) - token (token) 4.4. Table test.block (block) Stores block settings, such as region and visibility... Columns: - bid INT(11) #Primary Key: Unique block ID. - module VARCHAR(64) '' #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) '0' #Unique ID for block within a module. - theme VARCHAR(64) '' #The theme under which the block settings apply. - status TINYINT(4) '0' #Block enabled status. (1 = enabled, 0 = disabled) - weight INT(11) '0' #Block weight within region. - region VARCHAR(64) '' #Theme region within which the block is set. - custom TINYINT(4) '0' #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) '0' #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 #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(64) '' #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) '1' #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. Foreign Keys: Indices: - PRIMARY (bid) - tmd (theme, module, delta) - list (theme, status, region, weight, module) 4.5. Table test.block_custom (block_custom) Stores contents of custom-made blocks. Columns: - bid INT(10) UNSIGNED #The block’s block.bid. - body LONGTEXT NULL #Block contents. - info VARCHAR(128) '' #Block description. - format VARCHAR(255) NULL #The filter_format.format of the block body. Foreign Keys: Indices: - PRIMARY (bid) - info (info) 4.6. Table test.block_node_type (block_node_type) Sets up display criteria for blocks based on content types Columns: - module VARCHAR(64) #The block’s origin module, from block.module. - delta VARCHAR(32) #The block’s unique delta within module, from block.delta. - type VARCHAR(32) #The machine-readable name of this type from node_type.type. Foreign Keys: Indices: - PRIMARY (module, delta, type) - type (type) 4.7. Table test.block_role (block_role) Sets up access permissions for blocks based on user roles Columns: - module VARCHAR(64) #The block’s origin module, from block.module. - delta VARCHAR(32) #The block’s unique delta within module, from block.delta. - rid INT(10) UNSIGNED #The user’s role ID from users_roles.rid. Foreign Keys: Indices: - PRIMARY (module, delta, rid) - rid (rid) 4.8. Table test.blocked_ips (blocked_ips) Stores blocked IP addresses. Columns: - iid INT(10) UNSIGNED #Primary Key: unique ID for IP addresses. - ip VARCHAR(40) '' #IP address Foreign Keys: Indices: - PRIMARY (iid) - blocked_ip (ip) 4.9. Table test.brilliant_gallery_checklist (brilliant_gallery_checklist) Table tracing which Brilliant Gallery images are hidden... Columns: - nid INT(10) UNSIGNED '0' #Unused now. - user INT(10) UNSIGNED '0' #User ID. - qid TEXT #Image. - state INT(10) UNSIGNED '0' #Visible or invisible. Foreign Keys: Indices: - PRIMARY (nid, user, qid(255)) 4.10. Table test.brilliant_gallery_image_arrays (brilliant_gallery_image_arrays) Binds image property array with its hash that is present... Columns: - hash VARCHAR(32) #Hash of the serialized array. - array TEXT #Array of image parametres. - datetime INT(10) UNSIGNED #Date and time of last value refresh. Foreign Keys: Indices: - PRIMARY (hash) - datetime (datetime) 4.11. Table test.cache (cache) Generic cache table for caching things not separated out... Columns: - cid VARCHAR(255) '' #Primary Key: Unique cache ID. - data LONGBLOB NULL #A collection of data to cache. - expire INT(11) '0' #A Unix timestamp indicating when the cache entry should expire, or 0 for never. - created INT(11) '0' #A Unix timestamp indicating when the cache entry was created. - serialized SMALLINT(6) '0' #A flag to indicate whether content is serialized (1) or not (0). Foreign Keys: Indices: - PRIMARY (cid) - expire (expire) 4.12. Table test.cache_block (cache_block) Cache table for the Block module to store already built... Columns: - cid VARCHAR(255) '' #Primary Key: Unique cache ID. - data LONGBLOB NULL #A collection of data to cache. - expire INT(11) '0' #A Unix timestamp indicating when the cache entry should expire, or 0 for never. - created INT(11) '0' #A Unix timestamp indicating when the cache entry was created. - serialized SMALLINT(6) '0' #A flag to indicate whether content is serialized (1) or not (0). Foreign Keys: Indices: - PRIMARY (cid) - expire (expire) 4.13. Table test.cache_bootstrap (cache_bootstrap) Cache table for data required to bootstrap Drupal, may be... Columns: - cid VARCHAR(255) '' #Primary Key: Unique cache ID. - data LONGBLOB NULL #A collection of data to cache. - expire INT(11) '0' #A Unix timestamp indicating when the cache entry should expire, or 0 for never. - created INT(11) '0' #A Unix timestamp indicating when the cache entry was created. - serialized SMALLINT(6) '0' #A flag to indicate whether content is serialized (1) or not (0). Foreign Keys: Indices: - PRIMARY (cid) - expire (expire) 4.14. Table test.cache_field (cache_field) Generic cache table for caching things not separated out... Columns: - cid VARCHAR(255) '' #Primary Key: Unique cache ID. - data LONGBLOB NULL #A collection of data to cache. - expire INT(11) '0' #A Unix timestamp indicating when the cache entry should expire, or 0 for never. - created INT(11) '0' #A Unix timestamp indicating when the cache entry was created. - serialized SMALLINT(6) '0' #A flag to indicate whether content is serialized (1) or not (0). Foreign Keys: Indices: - PRIMARY (cid) - expire (expire) 4.15. Table test.cache_filter (cache_filter) Cache table for the Filter module to store already... Columns: - cid VARCHAR(255) '' #Primary Key: Unique cache ID. - data LONGBLOB NULL #A collection of data to cache. - expire INT(11) '0' #A Unix timestamp indicating when the cache entry should expire, or 0 for never. - created INT(11) '0' #A Unix timestamp indicating when the cache entry was created. - serialized SMALLINT(6) '0' #A flag to indicate whether content is serialized (1) or not (0). Foreign Keys: Indices: - PRIMARY (cid) - expire (expire) 4.16. Table test.cache_form (cache_form) Cache table for the form system to store recently built... Columns: - cid VARCHAR(255) '' #Primary Key: Unique cache ID. - data LONGBLOB NULL #A collection of data to cache. - expire INT(11) '0' #A Unix timestamp indicating when the cache entry should expire, or 0 for never. - created INT(11) '0' #A Unix timestamp indicating when the cache entry was created. - serialized SMALLINT(6) '0' #A flag to indicate whether content is serialized (1) or not (0). Foreign Keys: Indices: - PRIMARY (cid) - expire (expire) 4.17. Table test.cache_image (cache_image) Cache table used to store information about image... Columns: - cid VARCHAR(255) '' #Primary Key: Unique cache ID. - data LONGBLOB NULL #A collection of data to cache. - expire INT(11) '0' #A Unix timestamp indicating when the cache entry should expire, or 0 for never. - created INT(11) '0' #A Unix timestamp indicating when the cache entry was created. - serialized SMALLINT(6) '0' #A flag to indicate whether content is serialized (1) or not (0). Foreign Keys: Indices: - PRIMARY (cid) - expire (expire) 4.18. Table test.cache_media_xml (cache_media_xml) Cache table for the the results of retreived XML... Columns: - cid VARCHAR(255) '' #Primary Key: Unique cache ID. - data LONGBLOB NULL #A collection of data to cache. - expire INT(11) '0' #A Unix timestamp indicating when the cache entry should expire, or 0 for never. - created INT(11) '0' #A Unix timestamp indicating when the cache entry was created. - serialized SMALLINT(6) '0' #A flag to indicate whether content is serialized (1) or not (0). Foreign Keys: Indices: - PRIMARY (cid) - expire (expire) 4.19. Table test.cache_menu (cache_menu) Cache table for the menu system to store router... Columns: - cid VARCHAR(255) '' #Primary Key: Unique cache ID. - data LONGBLOB NULL #A collection of data to cache. - expire INT(11) '0' #A Unix timestamp indicating when the cache entry should expire, or 0 for never. - created INT(11) '0' #A Unix timestamp indicating when the cache entry was created. - serialized SMALLINT(6) '0' #A flag to indicate whether content is serialized (1) or not (0). Foreign Keys: Indices: - PRIMARY (cid) - expire (expire) 4.20. Table test.cache_page (cache_page) Cache table used to store compressed pages for anonymous... Columns: - cid VARCHAR(255) '' #Primary Key: Unique cache ID. - data LONGBLOB NULL #A collection of data to cache. - expire INT(11) '0' #A Unix timestamp indicating when the cache entry should expire, or 0 for never. - created INT(11) '0' #A Unix timestamp indicating when the cache entry was created. - serialized SMALLINT(6) '0' #A flag to indicate whether content is serialized (1) or not (0). Foreign Keys: Indices: - PRIMARY (cid) - expire (expire) 4.21. Table test.cache_path (cache_path) Cache table for path alias lookup. Columns: - cid VARCHAR(255) '' #Primary Key: Unique cache ID. - data LONGBLOB NULL #A collection of data to cache. - expire INT(11) '0' #A Unix timestamp indicating when the cache entry should expire, or 0 for never. - created INT(11) '0' #A Unix timestamp indicating when the cache entry was created. - serialized SMALLINT(6) '0' #A flag to indicate whether content is serialized (1) or not (0). Foreign Keys: Indices: - PRIMARY (cid) - expire (expire) 4.22. Table test.cache_update (cache_update) Cache table for the Update module to store information... Columns: - cid VARCHAR(255) '' #Primary Key: Unique cache ID. - data LONGBLOB NULL #A collection of data to cache. - expire INT(11) '0' #A Unix timestamp indicating when the cache entry should expire, or 0 for never. - created INT(11) '0' #A Unix timestamp indicating when the cache entry was created. - serialized SMALLINT(6) '0' #A flag to indicate whether content is serialized (1) or not (0). Foreign Keys: Indices: - PRIMARY (cid) - expire (expire) 4.23. Table test.cache_views (cache_views) Generic cache table for caching things not separated out... Columns: - cid VARCHAR(255) '' #Primary Key: Unique cache ID. - data LONGBLOB NULL #A collection of data to cache. - expire INT(11) '0' #A Unix timestamp indicating when the cache entry should expire, or 0 for never. - created INT(11) '0' #A Unix timestamp indicating when the cache entry was created. - serialized SMALLINT(6) '0' #A flag to indicate whether content is serialized (1) or not (0). Foreign Keys: Indices: - PRIMARY (cid) - expire (expire) 4.24. Table test.cache_views_data (cache_views_data) Cache table for views to store pre-rendered queries,... Columns: - cid VARCHAR(255) '' #Primary Key: Unique cache ID. - data LONGBLOB NULL #A collection of data to cache. - expire INT(11) '0' #A Unix timestamp indicating when the cache entry should expire, or 0 for never. - created INT(11) '0' #A Unix timestamp indicating when the cache entry was created. - serialized SMALLINT(6) '1' #A flag to indicate whether content is serialized (1) or not (0). Foreign Keys: Indices: - PRIMARY (cid) - expire (expire) 4.25. Table test.captcha_points (captcha_points) This table describes which challenges should be added to... Columns: - form_id VARCHAR(128) '' #The form_id of the form to add a CAPTCHA to. - module VARCHAR(64) NULL #The module that provides the challenge. - captcha_type VARCHAR(64) NULL #The challenge type to use. Foreign Keys: Indices: - PRIMARY (form_id) 4.26. Table test.captcha_sessions (captcha_sessions) Stores the data about CAPTCHA sessions (solution, IP... Columns: - csid INT(11) #CAPTCHA session ID. - token VARCHAR(64) NULL #One time CAPTCHA token. - uid INT(11) '0' #User’s users.uid. - sid VARCHAR(64) '' #Session ID of the user. - ip_address VARCHAR(128) NULL #IP address of the visitor. - timestamp INT(11) '0' #A Unix timestamp indicating when the challenge was generated. - form_id VARCHAR(128) #The form_id of the form where the CAPTCHA is added to. - solution VARCHAR(128) '' #Solution of the challenge. - status INT(11) '0' #Status of the CAPTCHA session (unsolved, solved, ...) - attempts INT(11) '0' #The number of attempts. Foreign Keys: Indices: - PRIMARY (csid) - csid_ip (csid, ip_address) 4.27. Table test.ckeditor_input_format (ckeditor_input_format) Stores CKEditor input format assignments Columns: - name VARCHAR(128) '' #Name of the CKEditor role - format VARCHAR(128) '' #Drupal filter format ID Foreign Keys: Indices: - PRIMARY (name, format) 4.28. Table test.ckeditor_settings (ckeditor_settings) Stores CKEditor profile settings Columns: - name VARCHAR(128) '' #Name of the CKEditor profile - settings TEXT NULL #Profile settings Foreign Keys: Indices: - PRIMARY (name) 4.29. Table test.comment (comment) Stores comments and associated data. Columns: - cid INT(11) #Primary Key: Unique comment ID. - pid INT(11) '0' #The 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) '0' #The node.nid to which this comment is a reply. - uid INT(11) '0' #The users.uid who authored the comment. If set to 0, this comment was created by an anonymous user. - subject VARCHAR(64) '' #The comment title. - hostname VARCHAR(128) '' #The author’s host name. - created INT(11) '0' #The time that the comment was created, as a Unix timestamp. - changed INT(11) '0' #The time that the comment was last edited, as a Unix timestamp. - status TINYINT(3) UNSIGNED '1' #The published status of a comment. (0 = Not Published, 1 = Published) - thread VARCHAR(255) #The vancode representation of the comment’s place in a thread. - name VARCHAR(60) NULL #The comment author’s name. Uses users.name if the user is logged in, otherwise uses the value typed into the comment form. - mail VARCHAR(64) NULL #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) NULL #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) '' #The languages.language of this comment. Foreign Keys: Indices: - PRIMARY (cid) - comment_status_pid (pid, status) - comment_num_new (nid, status, created, cid, thread) - comment_uid (uid) - comment_nid_language (nid, language) - comment_created (created) 4.30. Table test.contact (contact) Contact form category settings. Columns: - cid INT(10) UNSIGNED #Primary Key: Unique category ID. - category VARCHAR(255) '' #Category name. - recipients LONGTEXT #Comma-separated list of recipient e-mail addresses. - reply LONGTEXT #Text of the auto-reply message. - weight INT(11) '0' #The category’s weight. - selected TINYINT(4) '0' #Flag to indicate whether or not category is selected by default. (1 = Yes, 0 = No) Foreign Keys: Indices: - PRIMARY (cid) - category (category) - list (weight, category) 4.31. Table test.context (context) Storage for normal (user-defined) contexts. Columns: - name VARCHAR(255) '' #The primary identifier for a context. - description VARCHAR(255) '' #Description for this context. - tag VARCHAR(255) '' #Tag for this context. - conditions TEXT NULL #Serialized storage of all context condition settings. - reactions TEXT NULL #Serialized storage of all context reaction settings. - condition_mode INT(11) '0' #Condition mode for this context. Foreign Keys: Indices: - PRIMARY (name) 4.32. Table test.ctools_css_cache (ctools_css_cache) A special cache used to store CSS that must be non-volatile. Columns: - cid VARCHAR(128) #The CSS ID this cache object belongs to. - filename VARCHAR(255) NULL #The filename this CSS is stored in. - css LONGTEXT NULL #CSS being stored. - filter TINYINT(4) NULL #Whether or not this CSS needs to be filtered. Foreign Keys: Indices: - PRIMARY (cid) 4.33. Table test.ctools_object_cache (ctools_object_cache) A special cache used to store objects that are being... Columns: - sid VARCHAR(64) #The session ID this cache object belongs to. - name VARCHAR(128) #The name of the object this cache is attached to. - obj VARCHAR(32) #The type of the object this cache is attached to; this essentially represents the owner so that several sub-systems can use this cache. - updated INT(10) UNSIGNED '0' #The time this cache was created or updated. - data LONGTEXT NULL #Serialized data being stored. Foreign Keys: Indices: - PRIMARY (sid, obj, name) - updated (updated) 4.34. Table test.date_format_locale (date_format_locale) Stores configured date formats for each locale. Columns: - format VARCHAR(100) #The date format string. - type VARCHAR(64) #The date format type, e.g. medium. - language VARCHAR(12) #A languages.language for this format to be used with. Foreign Keys: Indices: - PRIMARY (type, language) 4.35. Table test.date_format_type (date_format_type) Stores configured date format types. Columns: - type VARCHAR(64) #The date format type, e.g. medium. - title VARCHAR(255) #The human readable name of the format type. - locked TINYINT(4) '0' #Whether or not this is a system provided format. Foreign Keys: Indices: - PRIMARY (type) - title (title) 4.36. Table test.date_formats (date_formats) Stores configured date formats. Columns: - dfid INT(10) UNSIGNED #The date format identifier. - format VARCHAR(100) #The date format string. - type VARCHAR(64) #The date format type, e.g. medium. - locked TINYINT(4) '0' #Whether or not this format can be modified. Foreign Keys: Indices: - PRIMARY (dfid) - formats (format, type) 4.37. Table test.delta (delta) Stores theme-settings templates that allow overriding the... Columns: - machine_name VARCHAR(32) #The system name of this theme settings template. - name VARCHAR(128) #The friendly name of this theme settings template. - description MEDIUMTEXT #A brief description of this theme settings template. - theme VARCHAR(128) #The theme for which this theme settings template is relevant. - mode VARCHAR(32) #The mode that this template operrates in. - parent VARCHAR(32) #The system name of the parent of this theme settings template. - settings LONGBLOB NULL #Serialized data which is a copy of the theme settings array stored in the system table based on these overrides Foreign Keys: Indices: - PRIMARY (machine_name) 4.38. Table test.field_config (field_config) Columns: - id INT(11) #The primary identifier for a field - field_name VARCHAR(32) #The name of this field. Non-deleted field names are unique, but multiple deleted fields can have the same name. - type VARCHAR(128) #The type of this field. - module VARCHAR(128) '' #The module that implements the field type. - active TINYINT(4) '0' #Boolean indicating whether the module that implements the field type is enabled. - storage_type VARCHAR(128) #The storage backend for the field. - storage_module VARCHAR(128) '' #The module that implements the storage backend. - storage_active TINYINT(4) '0' #Boolean indicating whether the module that implements the storage backend is enabled. - locked TINYINT(4) '0' #@TODO - data LONGBLOB #Serialized data containing the field properties that do not warrant a dedicated column. - cardinality TINYINT(4) '0' - translatable TINYINT(4) '0' - deleted TINYINT(4) '0' Foreign Keys: Indices: - PRIMARY (id) - field_name (field_name) - active (active) - storage_active (storage_active) - deleted (deleted) - module (module) - storage_module (storage_module) - type (type) - storage_type (storage_type) 4.39. Table test.field_config_instance (field_config_instance) Columns: - id INT(11) #The primary identifier for a field instance - field_id INT(11) #The identifier of the field attached by this instance - field_name VARCHAR(32) '' - entity_type VARCHAR(32) '' - bundle VARCHAR(128) '' - data LONGBLOB - deleted TINYINT(4) '0' Foreign Keys: Indices: - PRIMARY (id) - field_name_bundle (field_name, entity_type, bundle) - deleted (deleted) 4.40. Table test.field_data_body (field_data_body) Data storage for field 2 (body) Columns: - entity_type VARCHAR(128) '' #The entity type this data is attached to - bundle VARCHAR(128) '' #The field instance bundle to which this row belongs, used when deleting a field instance - deleted TINYINT(4) '0' #A boolean indicating whether this data item has been deleted - entity_id INT(10) UNSIGNED #The entity id this data is attached to - revision_id INT(10) UNSIGNED NULL #The entity revision id this data is attached to, or NULL if the entity type is not versioned - language VARCHAR(32) '' #The language for this data item. - delta INT(10) UNSIGNED #The sequence number for this data item, used for multi-value fields - body_value LONGTEXT NULL - body_summary LONGTEXT NULL - body_format VARCHAR(255) NULL Foreign Keys: Indices: - PRIMARY (entity_type, entity_id, deleted, delta, language) - entity_type (entity_type) - bundle (bundle) - deleted (deleted) - entity_id (entity_id) - revision_id (revision_id) - language (language) - body_format (body_format) 4.41. Table test.field_data_comment_body (field_data_comment_body) Data storage for field 1 (comment_body) Columns: - entity_type VARCHAR(128) '' #The entity type this data is attached to - bundle VARCHAR(128) '' #The field instance bundle to which this row belongs, used when deleting a field instance - deleted TINYINT(4) '0' #A boolean indicating whether this data item has been deleted - entity_id INT(10) UNSIGNED #The entity id this data is attached to - revision_id INT(10) UNSIGNED NULL #The entity revision id this data is attached to, or NULL if the entity type is not versioned - language VARCHAR(32) '' #The language for this data item. - delta INT(10) UNSIGNED #The sequence number for this data item, used for multi-value fields - comment_body_value LONGTEXT NULL - comment_body_format VARCHAR(255) NULL Foreign Keys: Indices: - PRIMARY (entity_type, entity_id, deleted, delta, language) - entity_type (entity_type) - bundle (bundle) - deleted (deleted) - entity_id (entity_id) - revision_id (revision_id) - language (language) - comment_body_format (comment_body_format) 4.42. Table test.field_data_field_image (field_data_field_image) Data storage for field 4 (field_image) Columns: - entity_type VARCHAR(128) '' #The entity type this data is attached to - bundle VARCHAR(128) '' #The field instance bundle to which this row belongs, used when deleting a field instance - deleted TINYINT(4) '0' #A boolean indicating whether this data item has been deleted - entity_id INT(10) UNSIGNED #The entity id this data is attached to - revision_id INT(10) UNSIGNED NULL #The entity revision id this data is attached to, or NULL if the entity type is not versioned - language VARCHAR(32) '' #The language for this data item. - delta INT(10) UNSIGNED #The sequence number for this data item, used for multi-value fields - field_image_fid INT(10) UNSIGNED NULL #The file_managed.fid being referenced in this field. - field_image_alt VARCHAR(512) NULL #Alternative image text, for the image’s ’alt’ attribute. - field_image_title VARCHAR(1024) NULL #Image title text, for the image’s ’title’ attribute. - field_image_width INT(10) UNSIGNED NULL #The width of the image in pixels. - field_image_height INT(10) UNSIGNED NULL #The height of the image in pixels. Foreign Keys: Indices: - PRIMARY (entity_type, entity_id, deleted, delta, language) - entity_type (entity_type) - bundle (bundle) - deleted (deleted) - entity_id (entity_id) - revision_id (revision_id) - language (language) - field_image_fid (field_image_fid) 4.43. Table test.field_data_field_tags (field_data_field_tags) Data storage for field 3 (field_tags) Columns: - entity_type VARCHAR(128) '' #The entity type this data is attached to - bundle VARCHAR(128) '' #The field instance bundle to which this row belongs, used when deleting a field instance - deleted TINYINT(4) '0' #A boolean indicating whether this data item has been deleted - entity_id INT(10) UNSIGNED #The entity id this data is attached to - revision_id INT(10) UNSIGNED NULL #The entity revision id this data is attached to, or NULL if the entity type is not versioned - language VARCHAR(32) '' #The language for this data item. - delta INT(10) UNSIGNED #The sequence number for this data item, used for multi-value fields - field_tags_tid INT(10) UNSIGNED NULL Foreign Keys: Indices: - PRIMARY (entity_type, entity_id, deleted, delta, language) - entity_type (entity_type) - bundle (bundle) - deleted (deleted) - entity_id (entity_id) - revision_id (revision_id) - language (language) - field_tags_tid (field_tags_tid) 4.44. Table test.field_revision_body (field_revision_body) Revision archive storage for field 2 (body) Columns: - entity_type VARCHAR(128) '' #The entity type this data is attached to - bundle VARCHAR(128) '' #The field instance bundle to which this row belongs, used when deleting a field instance - deleted TINYINT(4) '0' #A boolean indicating whether this data item has been deleted - entity_id INT(10) UNSIGNED #The entity id this data is attached to - revision_id INT(10) UNSIGNED #The entity revision id this data is attached to - language VARCHAR(32) '' #The language for this data item. - delta INT(10) UNSIGNED #The sequence number for this data item, used for multi-value fields - body_value LONGTEXT NULL - body_summary LONGTEXT NULL - body_format VARCHAR(255) NULL Foreign Keys: Indices: - PRIMARY (entity_type, entity_id, revision_id, deleted, delta, language) - entity_type (entity_type) - bundle (bundle) - deleted (deleted) - entity_id (entity_id) - revision_id (revision_id) - language (language) - body_format (body_format) 4.45. Table test.field_revision_comment_body (field_revision_comment_body) Revision archive storage for field 1 (comment_body) Columns: - entity_type VARCHAR(128) '' #The entity type this data is attached to - bundle VARCHAR(128) '' #The field instance bundle to which this row belongs, used when deleting a field instance - deleted TINYINT(4) '0' #A boolean indicating whether this data item has been deleted - entity_id INT(10) UNSIGNED #The entity id this data is attached to - revision_id INT(10) UNSIGNED #The entity revision id this data is attached to - language VARCHAR(32) '' #The language for this data item. - delta INT(10) UNSIGNED #The sequence number for this data item, used for multi-value fields - comment_body_value LONGTEXT NULL - comment_body_format VARCHAR(255) NULL Foreign Keys: Indices: - PRIMARY (entity_type, entity_id, revision_id, deleted, delta, language) - entity_type (entity_type) - bundle (bundle) - deleted (deleted) - entity_id (entity_id) - revision_id (revision_id) - language (language) - comment_body_format (comment_body_format) 4.46. Table test.field_revision_field_image (field_revision_field_image) Revision archive storage for field 4 (field_image) Columns: - entity_type VARCHAR(128) '' #The entity type this data is attached to - bundle VARCHAR(128) '' #The field instance bundle to which this row belongs, used when deleting a field instance - deleted TINYINT(4) '0' #A boolean indicating whether this data item has been deleted - entity_id INT(10) UNSIGNED #The entity id this data is attached to - revision_id INT(10) UNSIGNED #The entity revision id this data is attached to - language VARCHAR(32) '' #The language for this data item. - delta INT(10) UNSIGNED #The sequence number for this data item, used for multi-value fields - field_image_fid INT(10) UNSIGNED NULL #The file_managed.fid being referenced in this field. - field_image_alt VARCHAR(512) NULL #Alternative image text, for the image’s ’alt’ attribute. - field_image_title VARCHAR(1024) NULL #Image title text, for the image’s ’title’ attribute. - field_image_width INT(10) UNSIGNED NULL #The width of the image in pixels. - field_image_height INT(10) UNSIGNED NULL #The height of the image in pixels. Foreign Keys: Indices: - PRIMARY (entity_type, entity_id, revision_id, deleted, delta, language) - entity_type (entity_type) - bundle (bundle) - deleted (deleted) - entity_id (entity_id) - revision_id (revision_id) - language (language) - field_image_fid (field_image_fid) 4.47. Table test.field_revision_field_tags (field_revision_field_tags) Revision archive storage for field 3 (field_tags) Columns: - entity_type VARCHAR(128) '' #The entity type this data is attached to - bundle VARCHAR(128) '' #The field instance bundle to which this row belongs, used when deleting a field instance - deleted TINYINT(4) '0' #A boolean indicating whether this data item has been deleted - entity_id INT(10) UNSIGNED #The entity id this data is attached to - revision_id INT(10) UNSIGNED #The entity revision id this data is attached to - language VARCHAR(32) '' #The language for this data item. - delta INT(10) UNSIGNED #The sequence number for this data item, used for multi-value fields - field_tags_tid INT(10) UNSIGNED NULL Foreign Keys: Indices: - PRIMARY (entity_type, entity_id, revision_id, deleted, delta, language) - entity_type (entity_type) - bundle (bundle) - deleted (deleted) - entity_id (entity_id) - revision_id (revision_id) - language (language) - field_tags_tid (field_tags_tid) 4.48. Table test.file_display (file_display) Stores configuration options for file displays. Columns: - name VARCHAR(255) #A combined string (FILE_TYPE__VIEW_MODE__FILE_FORMATTER) identifying a file display configuration. For integration with CTools Exportables, stored as a single string rather than as a compound primary key. - weight INT(11) '0' #Weight of formatter within the display chain for the associated file type and view mode. A file is rendered using the lowest weighted enabled display configuration that matches the file type and view mode and that is capable of displaying the file. - status TINYINT(3) UNSIGNED '0' #The status of the display. (1 = enabled, 0 = disabled) - settings LONGBLOB NULL #A serialized array of name value pairs that store the formatter settings for the display. Foreign Keys: Indices: - PRIMARY (name) 4.49. Table test.file_managed (file_managed) Stores information for uploaded files. Columns: - fid INT(10) UNSIGNED #File ID. - uid INT(10) UNSIGNED '0' #The users.uid of the user who is associated with the file. - filename VARCHAR(255) '' #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) '' #The URI to access the file (either local or remote). - filemime VARCHAR(255) '' #The file’s MIME type. - filesize INT(10) UNSIGNED '0' #The size of the file in bytes. - status TINYINT(4) '0' #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 '0' #UNIX timestamp for when the file was added. - type VARCHAR(50) 'undefined' #The type of this file. Foreign Keys: Indices: - PRIMARY (fid) - uri (uri) - uid (uid) - status (status) - timestamp (timestamp) - file_type (type) 4.50. Table test.file_usage (file_usage) Track where a file is used. Columns: - fid INT(10) UNSIGNED #File ID. - module VARCHAR(255) '' #The name of the module that is using the file. - type VARCHAR(64) '' #The name of the object type in which the file is used. - id INT(10) UNSIGNED '0' #The primary key of the object using the file. - count INT(10) UNSIGNED '0' #The number of times this file is used by this object. Foreign Keys: Indices: - PRIMARY (fid, type, id, module) - type_id (type, id) - fid_count (fid, count) - fid_module (fid, module) 4.51. Table test.filter (filter) Table that maps filters (HTML corrector) to text formats ... Columns: - format VARCHAR(255) #Foreign key: The filter_format.format to which this filter is assigned. - module VARCHAR(64) '' #The origin module of the filter. - name VARCHAR(32) '' #Name of the filter being referenced. - weight INT(11) '0' #Weight of filter within format. - status INT(11) '0' #Filter enabled status. (1 = enabled, 0 = disabled) - settings LONGBLOB NULL #A serialized array of name value pairs that store the filter settings for the specific format. Foreign Keys: Indices: - PRIMARY (format, name) - list (weight, module, name) 4.52. Table test.filter_format (filter_format) Stores text formats: custom groupings of filters, such as... Columns: - format VARCHAR(255) #Primary Key: Unique machine name of the format. - name VARCHAR(255) '' #Name of the text format (Filtered HTML). - cache TINYINT(4) '0' #Flag to indicate whether format is cacheable. (1 = cacheable, 0 = not cacheable) - status TINYINT(3) UNSIGNED '1' #The status of the text format. (1 = enabled, 0 = disabled) - weight INT(11) '0' #Weight of text format to use when listing. Foreign Keys: Indices: - PRIMARY (format) - name (name) - status_weight (status, weight) 4.53. Table test.flood (flood) Flood controls the threshold of events, such as the... Columns: - fid INT(11) #Unique flood event ID. - event VARCHAR(64) '' #Name of event (e.g. contact). - identifier VARCHAR(128) '' #Identifier of the visitor, such as an IP address or hostname. - timestamp INT(11) '0' #Timestamp of the event. - expiration INT(11) '0' #Expiration timestamp. Expired events are purged on cron run. Foreign Keys: Indices: - PRIMARY (fid) - allow (event, identifier, timestamp) - purge (expiration) 4.54. Table test.history (history) A record of which users have read which nodes. Columns: - uid INT(11) '0' #The users.uid that read the node nid. - nid INT(11) '0' #The node.nid that was read. - timestamp INT(11) '0' #The Unix timestamp at which the read occurred. Foreign Keys: Indices: - PRIMARY (uid, nid) - nid (nid) 4.55. Table test.image_effects (image_effects) Stores configuration options for image effects. Columns: - ieid INT(10) UNSIGNED #The primary identifier for an image effect. - isid INT(10) UNSIGNED '0' #The image_styles.isid for an image style. - weight INT(11) '0' #The weight of the effect in the style. - name VARCHAR(255) #The unique name of the effect to be executed. - data LONGBLOB #The configuration data for the effect. Foreign Keys: Indices: - PRIMARY (ieid) - isid (isid) - weight (weight) 4.56. Table test.image_styles (image_styles) Stores configuration options for image styles. Columns: - isid INT(10) UNSIGNED #The primary identifier for an image style. - name VARCHAR(255) #The style name. Foreign Keys: Indices: - PRIMARY (isid) - name (name) 4.57. Table test.media_filter_usage (media_filter_usage) Stores fids that have been included in the media tag in... Columns: - fid INT(10) UNSIGNED '0' #The media file_managed.fid. - timestamp INT(11) '0' #The timestamp the fid was last recorded by media_filter() Foreign Keys: Indices: - PRIMARY (fid) - timestamp (timestamp) 4.58. Table test.media_list_type (media_list_type) Stores the user preference for whether to list as table... Columns: - uid INT(10) UNSIGNED '0' #The user.uid of the user. - type VARCHAR(32) '' #The type of display (table or images). Foreign Keys: Indices: - PRIMARY (uid) 4.59. Table test.media_type (media_type) Stores the settings for media types. Columns: - name VARCHAR(255) '' #The machine name of the media type. - label VARCHAR(255) '' #The label of the media type. - base TINYINT(4) '0' #If this is a base type (i.e. cannot be deleted) - weight INT(11) '0' #Weight of media type. Determines which one wins when claiming a piece of media (first wins) - type_callback VARCHAR(255) '' #Callback to determine if provided media is of this type. - type_callback_args LONGTEXT NULL #A serialized array of name value pairs that will be passed to the callback function Foreign Keys: Indices: - PRIMARY (name) 4.60. Table test.menu_custom (menu_custom) Holds definitions for top-level custom menus (for example... Columns: - menu_name VARCHAR(32) '' #Primary Key: Unique key for menu. This is used as a block delta so length is 32. - title VARCHAR(255) '' #Menu title; displayed at top of block. - description TEXT NULL #Menu description. Foreign Keys: Indices: - PRIMARY (menu_name) 4.61. Table test.menu_links (menu_links) Contains the individual links within a menu. Columns: - menu_name VARCHAR(32) '' #The menu name. All links with the same menu name (such as ’navigation’) are part of the same menu. - mlid INT(10) UNSIGNED #The menu link ID (mlid) is the integer primary key. - plid INT(10) UNSIGNED '0' #The parent link ID (plid) is the mlid of the link above in the hierarchy, or zero if the link is at the top level in its menu. - link_path VARCHAR(255) '' #The Drupal path or external path this link points to. - router_path VARCHAR(255) '' #For links corresponding to a Drupal path (external = 0), this connects the link to a menu_router.path for joins. - link_title VARCHAR(255) '' #The text displayed for the link, which may be modified by a title callback stored in menu_router. - options BLOB NULL #A serialized array of options to be passed to the url() or l() function, such as a query string or HTML attributes. - module VARCHAR(255) 'system' #The name of the module that generated this link. - hidden SMALLINT(6) '0' #A flag for whether the link should be rendered in menus. (1 = a disabled menu item that may be shown on admin screens, -1 = a menu callback, 0 = a normal, visible link) - external SMALLINT(6) '0' #A flag to indicate if the link points to a full URL starting with a protocol, like http:// (1 = external, 0 = internal). - has_children SMALLINT(6) '0' #Flag indicating whether any links have this link as a parent (1 = children exist, 0 = no children). - expanded SMALLINT(6) '0' #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) '0' #Link weight among links in the same menu at the same depth. - depth SMALLINT(6) '0' #The depth relative to the top level. A link with plid == 0 will have depth == 1. - customized SMALLINT(6) '0' #A flag to indicate that the user has manually created or edited the link (1 = customized, 0 = not customized). - p1 INT(10) UNSIGNED '0' #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 plid. All pX where X > depth must equal zero. The columns p1 .. p9 are also called the parents. - p2 INT(10) UNSIGNED '0' #The second mlid in the materialized path. See p1. - p3 INT(10) UNSIGNED '0' #The third mlid in the materialized path. See p1. - p4 INT(10) UNSIGNED '0' #The fourth mlid in the materialized path. See p1. - p5 INT(10) UNSIGNED '0' #The fifth mlid in the materialized path. See p1. - p6 INT(10) UNSIGNED '0' #The sixth mlid in the materialized path. See p1. - p7 INT(10) UNSIGNED '0' #The seventh mlid in the materialized path. See p1. - p8 INT(10) UNSIGNED '0' #The eighth mlid in the materialized path. See p1. - p9 INT(10) UNSIGNED '0' #The ninth mlid in the materialized path. See p1. - updated SMALLINT(6) '0' #Flag that indicates that this link was generated during the update from Drupal 5. Foreign Keys: Indices: - PRIMARY (mlid) - path_menu (link_path(128), menu_name) - menu_plid_expand_child (menu_name, plid, expanded, has_children) - menu_parents (menu_name, p1, p2, p3, p4, p5, p6, p7, p8, p9) - router_path (router_path(128)) 4.62. Table test.menu_router (menu_router) Maps paths to various callbacks (access, page and title) Columns: - path VARCHAR(255) '' #Primary Key: the Drupal path this entry describes - load_functions BLOB #A serialized array of function names (like node_load) to be called to load an object corresponding to a part of the current path. - to_arg_functions BLOB #A serialized array of function names (like user_uid_optional_to_arg) to be called to replace a part of the router path with another string. - access_callback VARCHAR(255) '' #The callback which determines the access to this router path. Defaults to user_access. - access_arguments BLOB NULL #A serialized array of arguments for the access callback. - page_callback VARCHAR(255) '' #The name of the function that renders the page. - page_arguments BLOB NULL #A serialized array of arguments for the page callback. - delivery_callback VARCHAR(255) '' #The name of the function that sends the result of the page_callback function to the browser. - fit INT(11) '0' #A numeric representation of how specific the path is. - number_parts SMALLINT(6) '0' #Number of parts in this router path. - context INT(11) '0' #Only for local tasks (tabs) - the context of a local task to control its placement. - tab_parent VARCHAR(255) '' #Only for local tasks (tabs) - the router path of the parent page (which may also be a local task). - tab_root VARCHAR(255) '' #Router path of the closest non-tab parent page. For pages that are not local tasks, this will be the same as the path. - title VARCHAR(255) '' #The title for the current page, or the title for the tab if this is a local task. - title_callback VARCHAR(255) '' #A function which will alter the title. Defaults to t() - title_arguments VARCHAR(255) '' #A serialized array of arguments for the title callback. If empty, the title will be used as the sole argument for the title callback. - theme_callback VARCHAR(255) '' #A function which returns the name of the theme that will be used to render this page. If left empty, the default theme will be used. - theme_arguments VARCHAR(255) '' #A serialized array of arguments for the theme callback. - type INT(11) '0' #Numeric representation of the type of the menu item, like MENU_LOCAL_TASK. - description TEXT #A description of this item. - position VARCHAR(255) '' #The position of the block (left or right) on the system administration page for this item. - weight INT(11) '0' #Weight of the element. Lighter weights are higher up, heavier weights go down. - include_file MEDIUMTEXT NULL #The file to include for this element, usually the page callback function lives in this file. Foreign Keys: Indices: - PRIMARY (path) - fit (fit) - tab_parent (tab_parent(64), weight, title) - tab_root_weight_title (tab_root(64), weight, title) 4.63. Table test.node (node) The base table for nodes. Columns: - nid INT(10) UNSIGNED #The primary identifier for a node. - vid INT(10) UNSIGNED NULL #The current node_revision.vid version identifier. - type VARCHAR(32) '' #The node_type.type of this node. - language VARCHAR(12) '' #The languages.language of this node. - title VARCHAR(255) '' #The title of this node, always treated as non-markup plain text. - uid INT(11) '0' #The users.uid that owns this node; initially, this is the user that created it. - status INT(11) '1' #Boolean indicating whether the node is published (visible to non-administrators). - created INT(11) '0' #The Unix timestamp when the node was created. - changed INT(11) '0' #The Unix timestamp when the node was most recently saved. - comment INT(11) '0' #Whether comments are allowed on this node: 0 = no, 1 = closed (read only), 2 = open (read/write). - promote INT(11) '0' #Boolean indicating whether the node should be displayed on the front page. - sticky INT(11) '0' #Boolean indicating whether the node should be displayed at the top of lists in which it appears. - tnid INT(10) UNSIGNED '0' #The translation set id for this node, which equals the node id of the source post in each set. - translate INT(11) '0' #A boolean indicating whether this translation page needs to be updated. Foreign Keys: Indices: - PRIMARY (nid) - vid (vid) - node_changed (changed) - node_created (created) - node_frontpage (promote, status, sticky, created) - node_status_type (status, type, nid) - node_title_type (title, type(4)) - node_type (type(4)) - uid (uid) - tnid (tnid) - translate (translate) 4.64. Table test.node_access (node_access) Identifies which realm/grant pairs a user must possess in... Columns: - nid INT(10) UNSIGNED '0' #The node.nid this record affects. - gid INT(10) UNSIGNED '0' #The grant ID a user must possess in the specified realm to gain this row’s privileges on the node. - realm VARCHAR(255) '' #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 '0' #Boolean indicating whether a user with the realm/grant pair can view this node. - grant_update TINYINT(3) UNSIGNED '0' #Boolean indicating whether a user with the realm/grant pair can edit this node. - grant_delete TINYINT(3) UNSIGNED '0' #Boolean indicating whether a user with the realm/grant pair can delete this node. Foreign Keys: Indices: - PRIMARY (nid, gid, realm) II. Data Copy