Created
February 19, 2016 03:09
-
-
Save caseyfw/a924ec3c4b0cfed25136 to your computer and use it in GitHub Desktop.
Diff of UASM DB Structure - current PRD to develop 20160219
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| --- uasm_prd_structure.sql 2016-02-19 13:28:09.151761615 +1030 | |
| +++ uasm_dev_structure.sql 2016-02-19 13:31:05.983826225 +1030 | |
| @@ -1,8 +1,8 @@ | |
| --- MySQL dump 10.14 Distrib 5.5.44-MariaDB, for debian-linux-gnu (x86_64) | |
| +-- MySQL dump 10.13 Distrib 5.6.28, for debian-linux-gnu (x86_64) | |
| -- | |
| --- Host: 172.17.42.1 Database: uasm5 | |
| +-- Host: mysql Database: site_manager | |
| -- ------------------------------------------------------ | |
| --- Server version 5.5.37-MariaDB-wsrep-log | |
| +-- Server version 5.5.5-10.0.23-MariaDB-1~jessie-log | |
| /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; | |
| /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; | |
| @@ -403,6 +403,7 @@ | |
| /*!40101 SET character_set_client = utf8 */; | |
| CREATE TABLE `cas_login_data` ( | |
| `sid` varchar(128) NOT NULL COMMENT 'A session ID (hashed). The value is generated by Drupal''s session handlers.', | |
| + `plainsid` varchar(128) NOT NULL COMMENT 'An unhashed session ID. Only stored if single logout is configured.', | |
| `ticket` varchar(256) NOT NULL DEFAULT '' COMMENT 'A CAS service ticket.', | |
| PRIMARY KEY (`sid`), | |
| KEY `ticket` (`sid`) | |
| @@ -440,7 +441,7 @@ | |
| PRIMARY KEY (`cid`), | |
| UNIQUE KEY `comment_field__uuid__value` (`uuid`), | |
| KEY `comment_field__comment_type__target_id` (`comment_type`) | |
| -) ENGINE=InnoDB AUTO_INCREMENT=1275 DEFAULT CHARSET=utf8mb4 COMMENT='The base table for comment entities.'; | |
| +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='The base table for comment entities.'; | |
| /*!40101 SET character_set_client = @saved_cs_client */; | |
| -- | |
| @@ -542,90 +543,6 @@ | |
| /*!40101 SET character_set_client = @saved_cs_client */; | |
| -- | |
| --- Table structure for table `field_deleted_data_ecbe2a3bcc` | |
| --- | |
| - | |
| -DROP TABLE IF EXISTS `field_deleted_data_ecbe2a3bcc`; | |
| -/*!40101 SET @saved_cs_client = @@character_set_client */; | |
| -/*!40101 SET character_set_client = utf8 */; | |
| -CREATE TABLE `field_deleted_data_ecbe2a3bcc` ( | |
| - `bundle` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance', | |
| - `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted', | |
| - `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to', | |
| - `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to', | |
| - `langcode` varchar(32) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The language code for this data item.', | |
| - `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields', | |
| - `field_ua_sm_authorizer_email_value` varchar(255) NOT NULL, | |
| - PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`), | |
| - KEY `bundle` (`bundle`), | |
| - KEY `revision_id` (`revision_id`) | |
| -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Data storage for node field field_ua_sm_authorizer_email.'; | |
| -/*!40101 SET character_set_client = @saved_cs_client */; | |
| - | |
| --- | |
| --- Table structure for table `field_deleted_data_fe596f4c11` | |
| --- | |
| - | |
| -DROP TABLE IF EXISTS `field_deleted_data_fe596f4c11`; | |
| -/*!40101 SET @saved_cs_client = @@character_set_client */; | |
| -/*!40101 SET character_set_client = utf8 */; | |
| -CREATE TABLE `field_deleted_data_fe596f4c11` ( | |
| - `bundle` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance', | |
| - `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted', | |
| - `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to', | |
| - `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to', | |
| - `langcode` varchar(32) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The language code for this data item.', | |
| - `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields', | |
| - `field_ua_sm_authorizer_id_value` varchar(16) NOT NULL, | |
| - PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`), | |
| - KEY `bundle` (`bundle`), | |
| - KEY `revision_id` (`revision_id`) | |
| -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Data storage for node field field_ua_sm_authorizer_id.'; | |
| -/*!40101 SET character_set_client = @saved_cs_client */; | |
| - | |
| --- | |
| --- Table structure for table `field_deleted_revision_ecbe2a3bcc` | |
| --- | |
| - | |
| -DROP TABLE IF EXISTS `field_deleted_revision_ecbe2a3bcc`; | |
| -/*!40101 SET @saved_cs_client = @@character_set_client */; | |
| -/*!40101 SET character_set_client = utf8 */; | |
| -CREATE TABLE `field_deleted_revision_ecbe2a3bcc` ( | |
| - `bundle` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance', | |
| - `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted', | |
| - `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to', | |
| - `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to', | |
| - `langcode` varchar(32) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The language code for this data item.', | |
| - `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields', | |
| - `field_ua_sm_authorizer_email_value` varchar(255) NOT NULL, | |
| - PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`), | |
| - KEY `bundle` (`bundle`), | |
| - KEY `revision_id` (`revision_id`) | |
| -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Revision archive storage for node field field_ua_sm…'; | |
| -/*!40101 SET character_set_client = @saved_cs_client */; | |
| - | |
| --- | |
| --- Table structure for table `field_deleted_revision_fe596f4c11` | |
| --- | |
| - | |
| -DROP TABLE IF EXISTS `field_deleted_revision_fe596f4c11`; | |
| -/*!40101 SET @saved_cs_client = @@character_set_client */; | |
| -/*!40101 SET character_set_client = utf8 */; | |
| -CREATE TABLE `field_deleted_revision_fe596f4c11` ( | |
| - `bundle` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance', | |
| - `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted', | |
| - `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to', | |
| - `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to', | |
| - `langcode` varchar(32) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The language code for this data item.', | |
| - `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields', | |
| - `field_ua_sm_authorizer_id_value` varchar(16) NOT NULL, | |
| - PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`), | |
| - KEY `bundle` (`bundle`), | |
| - KEY `revision_id` (`revision_id`) | |
| -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Revision archive storage for node field field_ua_sm…'; | |
| -/*!40101 SET character_set_client = @saved_cs_client */; | |
| - | |
| --- | |
| -- Table structure for table `file_managed` | |
| -- | |
| @@ -689,7 +606,7 @@ | |
| PRIMARY KEY (`fid`), | |
| KEY `allow` (`event`,`identifier`,`timestamp`), | |
| KEY `purge` (`expiration`) | |
| -) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8mb4 COMMENT='Flood controls the threshold of events, such as the number…'; | |
| +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Flood controls the threshold of events, such as the number…'; | |
| /*!40101 SET character_set_client = @saved_cs_client */; | |
| -- | |
| @@ -755,7 +672,7 @@ | |
| `langcode` varchar(12) CHARACTER SET ascii NOT NULL, | |
| PRIMARY KEY (`id`), | |
| UNIQUE KEY `menu_link_content_field__uuid__value` (`uuid`) | |
| -) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COMMENT='The base table for menu_link_content entities.'; | |
| +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='The base table for menu_link_content entities.'; | |
| /*!40101 SET character_set_client = @saved_cs_client */; | |
| -- | |
| @@ -805,8 +722,8 @@ | |
| `route_param_key` varchar(255) DEFAULT NULL COMMENT 'An encoded string of route parameters for loading by route.', | |
| `route_parameters` longblob COMMENT 'Serialized array of route parameters of this menu link.', | |
| `url` varchar(255) NOT NULL DEFAULT '' COMMENT 'The external path this link points to (when not using a route).', | |
| - `title` longblob COMMENT 'The serialized title for the link. May be a TranslationWrapper.', | |
| - `description` longblob COMMENT 'The serialized description of this link - used for admin pages and title attribute. May be a TranslationWrapper.', | |
| + `title` longblob COMMENT 'The serialized title for the link. May be a TranslatableMarkup.', | |
| + `description` longblob COMMENT 'The serialized description of this link - used for admin pages and title attribute. May be a TranslatableMarkup.', | |
| `class` text COMMENT 'The class for this link plugin.', | |
| `options` longblob COMMENT 'A serialized array of URL options, such as a query string or HTML attributes.', | |
| `provider` varchar(50) CHARACTER SET ascii NOT NULL DEFAULT 'system' COMMENT 'The name of the module that generated this link.', | |
| @@ -832,7 +749,7 @@ | |
| KEY `menu_parents` (`menu_name`,`p1`,`p2`,`p3`,`p4`,`p5`,`p6`,`p7`,`p8`,`p9`), | |
| KEY `menu_parent_expand_child` (`menu_name`,`expanded`,`has_children`,`parent`(16)), | |
| KEY `route_values` (`route_name`(32),`route_param_key`(16)) | |
| -) ENGINE=InnoDB AUTO_INCREMENT=205 DEFAULT CHARSET=utf8mb4 COMMENT='Contains the menu tree hierarchy.'; | |
| +) ENGINE=InnoDB AUTO_INCREMENT=74 DEFAULT CHARSET=utf8mb4 COMMENT='Contains the menu tree hierarchy.'; | |
| /*!40101 SET character_set_client = @saved_cs_client */; | |
| -- | |
| @@ -852,7 +769,7 @@ | |
| UNIQUE KEY `node_field__uuid__value` (`uuid`), | |
| UNIQUE KEY `node__vid` (`vid`), | |
| KEY `node_field__type__target_id` (`type`) | |
| -) ENGINE=InnoDB AUTO_INCREMENT=1055 DEFAULT CHARSET=utf8mb4 COMMENT='The base table for node entities.'; | |
| +) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COMMENT='The base table for node entities.'; | |
| /*!40101 SET character_set_client = @saved_cs_client */; | |
| -- | |
| @@ -1817,45 +1734,45 @@ | |
| /*!40101 SET character_set_client = @saved_cs_client */; | |
| -- | |
| --- Table structure for table `node__field_ua_sm_site_token` | |
| +-- Table structure for table `node__field_ua_sm_ssh_port` | |
| -- | |
| -DROP TABLE IF EXISTS `node__field_ua_sm_site_token`; | |
| +DROP TABLE IF EXISTS `node__field_ua_sm_ssh_port`; | |
| /*!40101 SET @saved_cs_client = @@character_set_client */; | |
| /*!40101 SET character_set_client = utf8 */; | |
| -CREATE TABLE `node__field_ua_sm_site_token` ( | |
| +CREATE TABLE `node__field_ua_sm_ssh_port` ( | |
| `bundle` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance', | |
| `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted', | |
| `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to', | |
| `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to', | |
| `langcode` varchar(32) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The language code for this data item.', | |
| `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields', | |
| - `field_ua_sm_site_token_value` varchar(255) NOT NULL, | |
| + `field_ua_sm_ssh_port_value` int(11) NOT NULL, | |
| PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`), | |
| KEY `bundle` (`bundle`), | |
| KEY `revision_id` (`revision_id`) | |
| -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Data storage for node field field_ua_sm_site_token.'; | |
| +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Data storage for node field field_ua_sm_ssh_port.'; | |
| /*!40101 SET character_set_client = @saved_cs_client */; | |
| -- | |
| --- Table structure for table `node__field_ua_sm_ssh_port` | |
| +-- Table structure for table `node__field_ua_sm_ssh_user` | |
| -- | |
| -DROP TABLE IF EXISTS `node__field_ua_sm_ssh_port`; | |
| +DROP TABLE IF EXISTS `node__field_ua_sm_ssh_user`; | |
| /*!40101 SET @saved_cs_client = @@character_set_client */; | |
| /*!40101 SET character_set_client = utf8 */; | |
| -CREATE TABLE `node__field_ua_sm_ssh_port` ( | |
| +CREATE TABLE `node__field_ua_sm_ssh_user` ( | |
| `bundle` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance', | |
| `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted', | |
| `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to', | |
| `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to', | |
| `langcode` varchar(32) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The language code for this data item.', | |
| `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields', | |
| - `field_ua_sm_ssh_port_value` int(11) NOT NULL, | |
| + `field_ua_sm_ssh_user_value` varchar(255) NOT NULL, | |
| PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`), | |
| KEY `bundle` (`bundle`), | |
| KEY `revision_id` (`revision_id`) | |
| -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Data storage for node field field_ua_sm_ssh_port.'; | |
| +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Data storage for node field field_ua_sm_ssh_user.'; | |
| /*!40101 SET character_set_client = @saved_cs_client */; | |
| -- | |
| @@ -2067,7 +1984,7 @@ | |
| KEY `node__nid` (`nid`), | |
| KEY `node_field__langcode` (`langcode`), | |
| KEY `node_field__revision_uid__target_id` (`revision_uid`) | |
| -) ENGINE=InnoDB AUTO_INCREMENT=1181 DEFAULT CHARSET=utf8mb4 COMMENT='The revision table for node entities.'; | |
| +) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COMMENT='The revision table for node entities.'; | |
| /*!40101 SET character_set_client = @saved_cs_client */; | |
| -- | |
| @@ -3032,41 +2949,41 @@ | |
| /*!40101 SET character_set_client = @saved_cs_client */; | |
| -- | |
| --- Table structure for table `node_revision__field_ua_sm_site_token` | |
| +-- Table structure for table `node_revision__field_ua_sm_ssh_port` | |
| -- | |
| -DROP TABLE IF EXISTS `node_revision__field_ua_sm_site_token`; | |
| +DROP TABLE IF EXISTS `node_revision__field_ua_sm_ssh_port`; | |
| /*!40101 SET @saved_cs_client = @@character_set_client */; | |
| /*!40101 SET character_set_client = utf8 */; | |
| -CREATE TABLE `node_revision__field_ua_sm_site_token` ( | |
| +CREATE TABLE `node_revision__field_ua_sm_ssh_port` ( | |
| `bundle` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance', | |
| `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted', | |
| `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to', | |
| `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to', | |
| `langcode` varchar(32) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The language code for this data item.', | |
| `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields', | |
| - `field_ua_sm_site_token_value` varchar(255) NOT NULL, | |
| + `field_ua_sm_ssh_port_value` int(11) NOT NULL, | |
| PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`), | |
| KEY `bundle` (`bundle`), | |
| KEY `revision_id` (`revision_id`) | |
| -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Revision archive storage for node field field_ua_sm_site…'; | |
| +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Revision archive storage for node field field_ua_sm_ssh…'; | |
| /*!40101 SET character_set_client = @saved_cs_client */; | |
| -- | |
| --- Table structure for table `node_revision__field_ua_sm_ssh_port` | |
| +-- Table structure for table `node_revision__field_ua_sm_ssh_user` | |
| -- | |
| -DROP TABLE IF EXISTS `node_revision__field_ua_sm_ssh_port`; | |
| +DROP TABLE IF EXISTS `node_revision__field_ua_sm_ssh_user`; | |
| /*!40101 SET @saved_cs_client = @@character_set_client */; | |
| /*!40101 SET character_set_client = utf8 */; | |
| -CREATE TABLE `node_revision__field_ua_sm_ssh_port` ( | |
| +CREATE TABLE `node_revision__field_ua_sm_ssh_user` ( | |
| `bundle` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance', | |
| `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted', | |
| `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to', | |
| `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to', | |
| `langcode` varchar(32) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The language code for this data item.', | |
| `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields', | |
| - `field_ua_sm_ssh_port_value` int(11) NOT NULL, | |
| + `field_ua_sm_ssh_user_value` varchar(255) NOT NULL, | |
| PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`), | |
| KEY `bundle` (`bundle`), | |
| KEY `revision_id` (`revision_id`) | |
| @@ -3207,24 +3124,25 @@ | |
| /*!40101 SET character_set_client = @saved_cs_client */; | |
| -- | |
| --- Table structure for table `paragraph__field_ua_sm_user_id` | |
| +-- Table structure for table `paragraph__field_ua_sm_user` | |
| -- | |
| -DROP TABLE IF EXISTS `paragraph__field_ua_sm_user_id`; | |
| +DROP TABLE IF EXISTS `paragraph__field_ua_sm_user`; | |
| /*!40101 SET @saved_cs_client = @@character_set_client */; | |
| /*!40101 SET character_set_client = utf8 */; | |
| -CREATE TABLE `paragraph__field_ua_sm_user_id` ( | |
| +CREATE TABLE `paragraph__field_ua_sm_user` ( | |
| `bundle` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance', | |
| `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted', | |
| `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to', | |
| `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to', | |
| `langcode` varchar(32) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The language code for this data item.', | |
| `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields', | |
| - `field_ua_sm_user_id_value` varchar(255) NOT NULL, | |
| + `field_ua_sm_user_target_id` int(10) unsigned NOT NULL COMMENT 'The ID of the target entity.', | |
| PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`), | |
| KEY `bundle` (`bundle`), | |
| - KEY `revision_id` (`revision_id`) | |
| -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Data storage for paragraph field field_ua_sm_user_id.'; | |
| + KEY `revision_id` (`revision_id`), | |
| + KEY `field_ua_sm_user_target_id` (`field_ua_sm_user_target_id`) | |
| +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Data storage for paragraph field field_ua_sm_user.'; | |
| /*!40101 SET character_set_client = @saved_cs_client */; | |
| -- | |
| @@ -3250,23 +3168,24 @@ | |
| /*!40101 SET character_set_client = @saved_cs_client */; | |
| -- | |
| --- Table structure for table `paragraph_revision__field_ua_sm_user_id` | |
| +-- Table structure for table `paragraph_revision__field_ua_sm_user` | |
| -- | |
| -DROP TABLE IF EXISTS `paragraph_revision__field_ua_sm_user_id`; | |
| +DROP TABLE IF EXISTS `paragraph_revision__field_ua_sm_user`; | |
| /*!40101 SET @saved_cs_client = @@character_set_client */; | |
| /*!40101 SET character_set_client = utf8 */; | |
| -CREATE TABLE `paragraph_revision__field_ua_sm_user_id` ( | |
| +CREATE TABLE `paragraph_revision__field_ua_sm_user` ( | |
| `bundle` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance', | |
| `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted', | |
| `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to', | |
| `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to', | |
| `langcode` varchar(32) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The language code for this data item.', | |
| `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields', | |
| - `field_ua_sm_user_id_value` varchar(255) NOT NULL, | |
| + `field_ua_sm_user_target_id` int(10) unsigned NOT NULL COMMENT 'The ID of the target entity.', | |
| PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`), | |
| KEY `bundle` (`bundle`), | |
| - KEY `revision_id` (`revision_id`) | |
| + KEY `revision_id` (`revision_id`), | |
| + KEY `field_ua_sm_user_target_id` (`field_ua_sm_user_target_id`) | |
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Revision archive storage for paragraph field field_ua_sm…'; | |
| /*!40101 SET character_set_client = @saved_cs_client */; | |
| @@ -3287,7 +3206,7 @@ | |
| UNIQUE KEY `paragraph_field__uuid__value` (`uuid`), | |
| UNIQUE KEY `paragraph__revision_id` (`revision_id`), | |
| KEY `paragraph_field__type__target_id` (`type`) | |
| -) ENGINE=InnoDB AUTO_INCREMENT=105 DEFAULT CHARSET=utf8mb4 COMMENT='The base table for paragraph entities.'; | |
| +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='The base table for paragraph entities.'; | |
| /*!40101 SET character_set_client = @saved_cs_client */; | |
| -- | |
| @@ -3303,6 +3222,7 @@ | |
| `type` varchar(32) CHARACTER SET ascii NOT NULL COMMENT 'The ID of the target entity.', | |
| `langcode` varchar(12) CHARACTER SET ascii NOT NULL, | |
| `uid` int(10) unsigned DEFAULT NULL COMMENT 'The ID of the target entity.', | |
| + `status` tinyint(4) DEFAULT NULL, | |
| `created` int(11) DEFAULT NULL, | |
| `changed` int(11) DEFAULT NULL, | |
| `default_langcode` tinyint(4) NOT NULL, | |
| @@ -3330,7 +3250,7 @@ | |
| PRIMARY KEY (`revision_id`), | |
| KEY `paragraph__id` (`id`), | |
| KEY `paragraph_field__revision_uid__target_id` (`revision_uid`) | |
| -) ENGINE=InnoDB AUTO_INCREMENT=437 DEFAULT CHARSET=utf8mb4 COMMENT='The revision table for paragraph entities.'; | |
| +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='The revision table for paragraph entities.'; | |
| /*!40101 SET character_set_client = @saved_cs_client */; | |
| -- | |
| @@ -3345,6 +3265,7 @@ | |
| `revision_id` int(10) unsigned NOT NULL, | |
| `langcode` varchar(12) CHARACTER SET ascii NOT NULL, | |
| `uid` int(10) unsigned DEFAULT NULL COMMENT 'The ID of the target entity.', | |
| + `status` tinyint(4) DEFAULT NULL, | |
| `created` int(11) DEFAULT NULL, | |
| `changed` int(11) DEFAULT NULL, | |
| `default_langcode` tinyint(4) NOT NULL, | |
| @@ -3370,7 +3291,7 @@ | |
| PRIMARY KEY (`item_id`), | |
| KEY `name_created` (`name`,`created`), | |
| KEY `expire` (`expire`) | |
| -) ENGINE=InnoDB AUTO_INCREMENT=88 DEFAULT CHARSET=utf8mb4 COMMENT='Stores items in queues.'; | |
| +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Stores items in queues.'; | |
| /*!40101 SET character_set_client = @saved_cs_client */; | |
| -- | |
| @@ -3468,7 +3389,7 @@ | |
| CREATE TABLE `sequences` ( | |
| `value` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'The value of the sequence.', | |
| PRIMARY KEY (`value`) | |
| -) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8mb4 COMMENT='Stores IDs.'; | |
| +) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='Stores IDs.'; | |
| /*!40101 SET character_set_client = @saved_cs_client */; | |
| -- | |
| @@ -3505,7 +3426,7 @@ | |
| PRIMARY KEY (`id`), | |
| UNIQUE KEY `shortcut_field__uuid__value` (`uuid`), | |
| KEY `shortcut_field__shortcut_set__target_id` (`shortcut_set`) | |
| -) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COMMENT='The base table for shortcut entities.'; | |
| +) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='The base table for shortcut entities.'; | |
| /*!40101 SET character_set_client = @saved_cs_client */; | |
| -- | |
| @@ -3580,7 +3501,7 @@ | |
| PRIMARY KEY (`tid`), | |
| UNIQUE KEY `taxonomy_term_field__uuid__value` (`uuid`), | |
| KEY `taxonomy_term_field__vid__target_id` (`vid`) | |
| -) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COMMENT='The base table for taxonomy_term entities.'; | |
| +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='The base table for taxonomy_term entities.'; | |
| /*!40101 SET character_set_client = @saved_cs_client */; | |
| -- | |
| @@ -3632,13 +3553,13 @@ | |
| /*!40101 SET character_set_client = utf8 */; | |
| CREATE TABLE `url_alias` ( | |
| `pid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'A unique path alias identifier.', | |
| - `source` varchar(255) NOT NULL DEFAULT '' COMMENT 'The Drupal path this alias is for; e.g. node/12.', | |
| - `alias` varchar(255) NOT NULL DEFAULT '' COMMENT 'The alias for this path; e.g. title-of-the-story.', | |
| - `langcode` varchar(12) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The language code this alias is for; if ''und'', the alias will be used for unknown languages. Each Drupal path can have an alias for each supported language.', | |
| + `source` varchar(255) NOT NULL DEFAULT '' COMMENT 'The Drupal path this alias is for. e.g. node/12.', | |
| + `alias` varchar(255) NOT NULL DEFAULT '' COMMENT 'The alias for this path. e.g. title-of-the-story.', | |
| + `langcode` varchar(12) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The language code this alias is for. if ''und'', the alias will be used for unknown languages. Each Drupal path can have an alias for each supported language.', | |
| PRIMARY KEY (`pid`), | |
| KEY `alias_langcode_pid` (`alias`(191),`langcode`,`pid`), | |
| KEY `source_langcode_pid` (`source`(191),`langcode`,`pid`) | |
| -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='A list of URL aliases for Drupal paths; a user may visit…'; | |
| +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='A list of URL aliases for Drupal paths. a user may visit…'; | |
| /*!40101 SET character_set_client = @saved_cs_client */; | |
| -- | |
| @@ -3663,6 +3584,27 @@ | |
| /*!40101 SET character_set_client = @saved_cs_client */; | |
| -- | |
| +-- Table structure for table `user__field_ua_user_preferred_name` | |
| +-- | |
| + | |
| +DROP TABLE IF EXISTS `user__field_ua_user_preferred_name`; | |
| +/*!40101 SET @saved_cs_client = @@character_set_client */; | |
| +/*!40101 SET character_set_client = utf8 */; | |
| +CREATE TABLE `user__field_ua_user_preferred_name` ( | |
| + `bundle` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance', | |
| + `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted', | |
| + `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to', | |
| + `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to, which for an unversioned entity type is the same as the entity id', | |
| + `langcode` varchar(32) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The language code for this data item.', | |
| + `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields', | |
| + `field_ua_user_preferred_name_value` varchar(255) NOT NULL, | |
| + PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`), | |
| + KEY `bundle` (`bundle`), | |
| + KEY `revision_id` (`revision_id`) | |
| +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Data storage for user field field_ua_user_preferred_name.'; | |
| +/*!40101 SET character_set_client = @saved_cs_client */; | |
| + | |
| +-- | |
| -- Table structure for table `user__roles` | |
| -- | |
| @@ -3790,7 +3732,7 @@ | |
| `type` varchar(64) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'Type of log message, for example "user" or "page not found."', | |
| `message` longtext NOT NULL COMMENT 'Text of log message to be passed into the t() function.', | |
| `variables` longblob NOT NULL COMMENT 'Serialized array of variables that match the message string and that is passed into the t() function.', | |
| - `severity` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'The severity level of the event; ranges from 0 (Emergency) to 7 (Debug)', | |
| + `severity` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'The severity level of the event. ranges from 0 (Emergency) to 7 (Debug)', | |
| `link` text COMMENT 'Link to view the result of the event.', | |
| `location` text NOT NULL COMMENT 'URL of the origin of the event.', | |
| `referer` text COMMENT 'URL of referring page.', | |
| @@ -3800,7 +3742,7 @@ | |
| KEY `type` (`type`), | |
| KEY `uid` (`uid`), | |
| KEY `severity` (`severity`) | |
| -) ENGINE=InnoDB AUTO_INCREMENT=91153 DEFAULT CHARSET=utf8mb4 COMMENT='Table that contains logs of all system events.'; | |
| +) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb4 COMMENT='Table that contains logs of all system events.'; | |
| /*!40101 SET character_set_client = @saved_cs_client */; | |
| /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; | |
| @@ -3812,4 +3754,4 @@ | |
| /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; | |
| /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; | |
| --- Dump completed on 2016-02-19 13:26:02 | |
| +-- Dump completed on 2016-02-19 13:31:05 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment