protected function SupportTicketStorageSchema::getSharedTableFieldSchema in Support Ticketing System 8

Gets the schema for a single field definition.

Entity types may override this method in order to optimize the generated schema for given field. While all optimizations that apply to a single field have to be added here, all cross-field optimizations should be via SqlContentEntityStorageSchema::getEntitySchema() instead; e.g., an index spanning multiple fields.

Parameters

\Drupal\Core\Field\FieldStorageDefinitionInterface $storage_definition: The storage definition of the field whose schema has to be returned.

string $table_name: The name of the table columns will be added to.

string[] $column_mapping: A mapping of field column names to database column names.

Return value

array The schema definition for the table with the following keys:

• fields: The schema definition for the each field columns.
• indexes: The schema definition for the indexes.
• unique keys: The schema definition for the unique keys.
• foreign keys: The schema definition for the foreign keys.

Throws

\Drupal\Core\Field\FieldException Exception thrown if the schema contains reserved column names or if the initial values definition is invalid.

Overrides SqlContentEntityStorageSchema::getSharedTableFieldSchema

File

modules/support_ticket/src/SupportTicketStorageSchema.php, line 36

Contains \Drupal\support_ticket\SupportTicketStorageSchema.

Class

SupportTicketStorageSchema

Defines the support schema handler.

Namespace

Drupal\support_ticket

Code

protected function getSharedTableFieldSchema(FieldStorageDefinitionInterface $storage_definition, $table_name, array $column_mapping) {
  $schema = parent::getSharedTableFieldSchema($storage_definition, $table_name, $column_mapping);
  $field_name = $storage_definition
    ->getName();
  if ($table_name == 'support_ticket_revision') {
    switch ($field_name) {
      case 'langcode':
        $this
          ->addSharedTableFieldIndex($storage_definition, $schema, TRUE);
        break;
      case 'revision_uid':
        $this
          ->addSharedTableFieldForeignKey($storage_definition, $schema, 'users', 'uid');
        break;
    }
  }
  if ($table_name == 'support_ticket_field_data') {
    switch ($field_name) {
      case 'status':
      case 'locked':
      case 'title':

        // Improves the performance of the indexes defined
        // in getEntitySchema().
        $schema['fields'][$field_name]['not null'] = TRUE;
        break;
      case 'changed':
      case 'created':

        // @todo Revisit index definitions:
        //   https://www.drupal.org/node/2015277.
        $this
          ->addSharedTableFieldIndex($storage_definition, $schema, TRUE);
        break;
    }
  }
  return $schema;
}