You are here

public static function SubscriptionItem::schema in Simplenews 8.2

Same name and namespace in other branches
  1. 8 src/Plugin/Field/FieldType/SubscriptionItem.php \Drupal\simplenews\Plugin\Field\FieldType\SubscriptionItem::schema()
  2. 3.x src/Plugin/Field/FieldType/SubscriptionItem.php \Drupal\simplenews\Plugin\Field\FieldType\SubscriptionItem::schema()

Returns the schema for the field.

This method is static because the field schema information is needed on creation of the field. FieldItemInterface objects instantiated at that time are not reliable as field settings might be missing.

Computed fields having no schema should return an empty array.

Parameters

\Drupal\Core\Field\FieldStorageDefinitionInterface $field_definition: The field definition.

Return value

array An empty array if there is no schema, or an associative array with the following key/value pairs:

  • columns: An array of Schema API column specifications, keyed by column name. The columns need to be a subset of the properties defined in propertyDefinitions(). The 'not null' property is ignored if present, as it is determined automatically by the storage controller depending on the table layout and the property definitions. It is recommended to avoid having the column definitions depend on field settings when possible. No assumptions should be made on how storage engines internally use the original column name to structure their storage.
  • unique keys: (optional) An array of Schema API unique key definitions. Only columns that appear in the 'columns' array are allowed.
  • indexes: (optional) An array of Schema API index definitions. Only columns that appear in the 'columns' array are allowed. Those indexes will be used as default indexes. Field definitions can specify additional indexes or, at their own risk, modify the default indexes specified by the field-type module. Some storage engines might not support indexes.
  • foreign keys: (optional) An array of Schema API foreign key definitions. Note, however, that the field data is not necessarily stored in SQL. Also, the possible usage is limited, as you cannot specify another field as related, only existing SQL tables, such as {taxonomy_term_data}.

Overrides EntityReferenceItem::schema

File

src/Plugin/Field/FieldType/SubscriptionItem.php, line 56

Class

SubscriptionItem
Defines the 'subscription' entity field type (extended entity_reference).

Namespace

Drupal\simplenews\Plugin\Field\FieldType

Code

public static function schema(FieldStorageDefinitionInterface $field_definition) {
  $schema = parent::schema($field_definition);
  $schema['columns']['status'] = [
    'description' => 'A flag indicating whether the user is unsubscribed (0), subscribed (1) or unconfirmed (2).',
    'type' => 'int',
    'size' => 'tiny',
    'not null' => FALSE,
  ];
  $schema['columns']['timestamp'] = [
    'description' => 'UNIX timestamp of when the user is (un)subscribed.',
    'type' => 'int',
    'unsigned' => TRUE,
    'not null' => FALSE,
  ];
  $schema['columns']['source'] = [
    'description' => 'The source via which the user is (un)subscription.',
    'type' => 'varchar',
    'length' => 24,
    'not null' => FALSE,
  ];
  return $schema;
}