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@17
|
20 if ($data_table = $this->storage->getDataTable()) {
|
Chris@17
|
21 $schema[$data_table]['indexes'] += [
|
Chris@17
|
22 'node__frontpage' => ['promote', 'status', 'sticky', 'created'],
|
Chris@17
|
23 'node__title_type' => ['title', ['type', 4]],
|
Chris@17
|
24 ];
|
Chris@17
|
25 }
|
Chris@0
|
26
|
Chris@0
|
27 return $schema;
|
Chris@0
|
28 }
|
Chris@0
|
29
|
Chris@0
|
30 /**
|
Chris@0
|
31 * {@inheritdoc}
|
Chris@0
|
32 */
|
Chris@0
|
33 protected function getSharedTableFieldSchema(FieldStorageDefinitionInterface $storage_definition, $table_name, array $column_mapping) {
|
Chris@0
|
34 $schema = parent::getSharedTableFieldSchema($storage_definition, $table_name, $column_mapping);
|
Chris@0
|
35 $field_name = $storage_definition->getName();
|
Chris@0
|
36
|
Chris@0
|
37 if ($table_name == 'node_revision') {
|
Chris@0
|
38 switch ($field_name) {
|
Chris@0
|
39 case 'langcode':
|
Chris@0
|
40 $this->addSharedTableFieldIndex($storage_definition, $schema, TRUE);
|
Chris@0
|
41 break;
|
Chris@0
|
42
|
Chris@0
|
43 case 'revision_uid':
|
Chris@0
|
44 $this->addSharedTableFieldForeignKey($storage_definition, $schema, 'users', 'uid');
|
Chris@0
|
45 break;
|
Chris@0
|
46 }
|
Chris@0
|
47 }
|
Chris@0
|
48
|
Chris@0
|
49 if ($table_name == 'node_field_data') {
|
Chris@0
|
50 switch ($field_name) {
|
Chris@0
|
51 case 'promote':
|
Chris@0
|
52 case 'status':
|
Chris@0
|
53 case 'sticky':
|
Chris@0
|
54 case 'title':
|
Chris@0
|
55 // Improves the performance of the indexes defined
|
Chris@0
|
56 // in getEntitySchema().
|
Chris@0
|
57 $schema['fields'][$field_name]['not null'] = TRUE;
|
Chris@0
|
58 break;
|
Chris@0
|
59
|
Chris@0
|
60 case 'changed':
|
Chris@0
|
61 case 'created':
|
Chris@0
|
62 // @todo Revisit index definitions:
|
Chris@0
|
63 // https://www.drupal.org/node/2015277.
|
Chris@0
|
64 $this->addSharedTableFieldIndex($storage_definition, $schema, TRUE);
|
Chris@0
|
65 break;
|
Chris@0
|
66 }
|
Chris@0
|
67 }
|
Chris@0
|
68
|
Chris@0
|
69 return $schema;
|
Chris@0
|
70 }
|
Chris@0
|
71
|
Chris@0
|
72 }
|