function bat_event_generate_hour_schema_fields in Booking and Availability Management Tools for Drupal 7

Same name and namespace in other branches

1. 8 modules/bat_event/bat_event.module \bat_event_generate_hour_schema_fields()

Creates the necessary hour schema fields.

Return value

array

1 call to bat_event_generate_hour_schema_fields()

bat_event_create_event_type_schema in modules/bat_event/bat_event.module

Create 6 tables for store events of type $machine_name.

File

modules/bat_event/bat_event.module, line 2218

Manage Events - Events store the EventValue of a Unit over a period of time.

Code

function bat_event_generate_hour_schema_fields() {
  $fields = array(
    'unit_id' => array(
      'description' => 'Identifier for a unit.',
      'type' => 'int',
      'unsigned' => TRUE,
      'not null' => TRUE,
    ),
    'year' => array(
      'description' => 'The calendar year for which this availability row is relevant',
      'type' => 'int',
      'not null' => TRUE,
      'default' => '0',
    ),
    'month' => array(
      'description' => 'The month for which this availability row is relevant',
      'type' => 'int',
      'not null' => TRUE,
      'default' => '0',
    ),
    'day' => array(
      'description' => 'The day for which this availability row is relevant',
      'type' => 'int',
      'not null' => TRUE,
      'default' => '0',
    ),
  );
  for ($i = 0; $i <= 23; $i++) {
    $fields['h' . $i] = array(
      'description' => 'H' . $i,
      'type' => 'int',
      'not null' => TRUE,
      'default' => '0',
    );
  }
  return $fields;
}