Chris@0
|
1 <?php
|
Chris@0
|
2
|
Chris@0
|
3 namespace Drupal\node;
|
Chris@0
|
4
|
Chris@0
|
5 use Drupal\Core\Entity\ContentEntityTypeInterface;
|
Chris@0
|
6 use Drupal\Core\Entity\Sql\SqlContentEntityStorageSchema;
|
Chris@0
|
7 use Drupal\Core\Field\FieldStorageDefinitionInterface;
|
Chris@0
|
8
|
Chris@0
|
9 /**
|
Chris@0
|
10 * Defines the node schema handler.
|
Chris@0
|
11 */
|
Chris@0
|
12 class NodeStorageSchema extends SqlContentEntityStorageSchema {
|
Chris@0
|
13
|
Chris@0
|
14 /**
|
Chris@0
|
15 * {@inheritdoc}
|
Chris@0
|
16 */
|
Chris@0
|
17 protected function getEntitySchema(ContentEntityTypeInterface $entity_type, $reset = FALSE) {
|
Chris@0
|
18 $schema = parent::getEntitySchema($entity_type, $reset);
|
Chris@0
|
19
|
Chris@0
|
20 $schema['node_field_data']['indexes'] += [
|
Chris@0
|
21 'node__frontpage' => ['promote', 'status', 'sticky', 'created'],
|
Chris@0
|
22 'node__title_type' => ['title', ['type', 4]],
|
Chris@0
|
23 ];
|
Chris@0
|
24
|
Chris@0
|
25 return $schema;
|
Chris@0
|
26 }
|
Chris@0
|
27
|
Chris@0
|
28 /**
|
Chris@0
|
29 * {@inheritdoc}
|
Chris@0
|
30 */
|
Chris@0
|
31 protected function getSharedTableFieldSchema(FieldStorageDefinitionInterface $storage_definition, $table_name, array $column_mapping) {
|
Chris@0
|
32 $schema = parent::getSharedTableFieldSchema($storage_definition, $table_name, $column_mapping);
|
Chris@0
|
33 $field_name = $storage_definition->getName();
|
Chris@0
|
34
|
Chris@0
|
35 if ($table_name == 'node_revision') {
|
Chris@0
|
36 switch ($field_name) {
|
Chris@0
|
37 case 'langcode':
|
Chris@0
|
38 $this->addSharedTableFieldIndex($storage_definition, $schema, TRUE);
|
Chris@0
|
39 break;
|
Chris@0
|
40
|
Chris@0
|
41 case 'revision_uid':
|
Chris@0
|
42 $this->addSharedTableFieldForeignKey($storage_definition, $schema, 'users', 'uid');
|
Chris@0
|
43 break;
|
Chris@0
|
44 }
|
Chris@0
|
45 }
|
Chris@0
|
46
|
Chris@0
|
47 if ($table_name == 'node_field_data') {
|
Chris@0
|
48 switch ($field_name) {
|
Chris@0
|
49 case 'promote':
|
Chris@0
|
50 case 'status':
|
Chris@0
|
51 case 'sticky':
|
Chris@0
|
52 case 'title':
|
Chris@0
|
53 // Improves the performance of the indexes defined
|
Chris@0
|
54 // in getEntitySchema().
|
Chris@0
|
55 $schema['fields'][$field_name]['not null'] = TRUE;
|
Chris@0
|
56 break;
|
Chris@0
|
57
|
Chris@0
|
58 case 'changed':
|
Chris@0
|
59 case 'created':
|
Chris@0
|
60 // @todo Revisit index definitions:
|
Chris@0
|
61 // https://www.drupal.org/node/2015277.
|
Chris@0
|
62 $this->addSharedTableFieldIndex($storage_definition, $schema, TRUE);
|
Chris@0
|
63 break;
|
Chris@0
|
64 }
|
Chris@0
|
65 }
|
Chris@0
|
66
|
Chris@0
|
67 return $schema;
|
Chris@0
|
68 }
|
Chris@0
|
69
|
Chris@0
|
70 }
|