SupportTicketStorageSchema.php in Support Ticketing System 8
File
modules/support_ticket/src/SupportTicketStorageSchema.php
View source
<?php
namespace Drupal\support_ticket;
use Drupal\Core\Entity\ContentEntityTypeInterface;
use Drupal\Core\Entity\Sql\SqlContentEntityStorageSchema;
use Drupal\Core\Field\FieldStorageDefinitionInterface;
class SupportTicketStorageSchema extends SqlContentEntityStorageSchema {
protected function getEntitySchema(ContentEntityTypeInterface $entity_type, $reset = FALSE) {
$schema = parent::getEntitySchema($entity_type, $reset);
$schema['support_ticket_field_data']['indexes'] += array(
'support_ticket__status_type' => array(
'status',
'support_ticket_type',
'stid',
),
'support_ticket__title_type' => array(
'title',
array(
'support_ticket_type',
4,
),
),
);
return $schema;
}
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':
$schema['fields'][$field_name]['not null'] = TRUE;
break;
case 'changed':
case 'created':
$this
->addSharedTableFieldIndex($storage_definition, $schema, TRUE);
break;
}
}
return $schema;
}
}