· 6 years ago · Sep 16, 2019, 11:16 PM
1# ************************************************************
2# Sequel Pro SQL dump
3# Version 5438
4#
5# https://www.sequelpro.com/
6# https://github.com/sequelpro/sequelpro
7#
8# Host: sjc04s1wwwdb03.teslamotors.com (MySQL 8.0.15-commercial)
9# Database: wwwstage
10# Generation Time: 2019-09-16 23:11:16 +0000
11# ************************************************************
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18SET NAMES utf8mb4;
19/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
20/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
21/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
22
23
24# Dump of table comparer
25# ------------------------------------------------------------
26
27DROP TABLE IF EXISTS `comparer`;
28
29CREATE TABLE `comparer` (
30 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
31 `uuid` varchar(128) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL,
32 `langcode` varchar(12) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL,
33 PRIMARY KEY (`id`),
34 UNIQUE KEY `comparer_field__uuid__value` (`uuid`)
35) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='The base table for comparer entities.';
36
37
38
39# Dump of table comparer__items
40# ------------------------------------------------------------
41
42DROP TABLE IF EXISTS `comparer__items`;
43
44CREATE TABLE `comparer__items` (
45 `bundle` varchar(128) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
46 `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
47 `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
48 `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',
49 `langcode` varchar(32) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'The language code for this data item.',
50 `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
51 `items_target_id` int(10) unsigned NOT NULL COMMENT 'The ID of the target entity.',
52 PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
53 KEY `bundle` (`bundle`),
54 KEY `revision_id` (`revision_id`),
55 KEY `items_target_id` (`items_target_id`)
56) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Data storage for comparer field items.';
57
58
59
60# Dump of table comparer_field_data
61# ------------------------------------------------------------
62
63DROP TABLE IF EXISTS `comparer_field_data`;
64
65CREATE TABLE `comparer_field_data` (
66 `id` int(10) unsigned NOT NULL,
67 `langcode` varchar(12) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL,
68 `status` tinyint(4) NOT NULL,
69 `user_id` int(10) unsigned NOT NULL COMMENT 'The ID of the target entity.',
70 `name` varchar(50) DEFAULT NULL,
71 `created` int(11) DEFAULT NULL,
72 `changed` int(11) DEFAULT NULL,
73 `default_langcode` tinyint(4) NOT NULL,
74 PRIMARY KEY (`id`,`langcode`),
75 KEY `comparer__id__default_langcode__langcode` (`id`,`default_langcode`,`langcode`),
76 KEY `comparer_field__user_id__target_id` (`user_id`),
77 KEY `comparer__status` (`status`,`id`)
78) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='The data table for comparer entities.';
79
80
81
82# Dump of table comparer_item
83# ------------------------------------------------------------
84
85DROP TABLE IF EXISTS `comparer_item`;
86
87CREATE TABLE `comparer_item` (
88 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
89 `type` varchar(32) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL COMMENT 'The ID of the target entity.',
90 `uuid` varchar(128) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL,
91 `langcode` varchar(12) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL,
92 PRIMARY KEY (`id`),
93 UNIQUE KEY `comparer_item_field__uuid__value` (`uuid`),
94 KEY `comparer_item_field__type__target_id` (`type`)
95) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='The base table for comparer_item entities.';
96
97
98
99# Dump of table comparer_item_field_data
100# ------------------------------------------------------------
101
102DROP TABLE IF EXISTS `comparer_item_field_data`;
103
104CREATE TABLE `comparer_item_field_data` (
105 `id` int(10) unsigned NOT NULL,
106 `type` varchar(32) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL COMMENT 'The ID of the target entity.',
107 `langcode` varchar(12) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL,
108 `status` tinyint(4) NOT NULL,
109 `user_id` int(10) unsigned NOT NULL COMMENT 'The ID of the target entity.',
110 `name` varchar(50) DEFAULT NULL,
111 `created` int(11) DEFAULT NULL,
112 `changed` int(11) DEFAULT NULL,
113 `default_langcode` tinyint(4) NOT NULL,
114 PRIMARY KEY (`id`,`langcode`),
115 KEY `comparer_item__id__default_langcode__langcode` (`id`,`default_langcode`,`langcode`),
116 KEY `comparer_item_field__type__target_id` (`type`),
117 KEY `comparer_item_field__user_id__target_id` (`user_id`),
118 KEY `comparer_item__status_type` (`status`,`type`,`id`)
119) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='The data table for comparer_item entities.';
120
121
122
123
124/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
125/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
126/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
127/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
128/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
129/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;