Field event_timezones.offset & event_timezones.offset_dst: no Schema type for mysql type time

I also get the following messages on my Open Atrium:

* Field event_timezones.offset: no Schema type for mysql type time.
* Field event_timezones.offset_dst: no Schema type for mysql type time.

I have the same two warning messages at the top of the admin page. I also noted that Schema reports event_timezones as an Extra table.

Tables in the database that are not present in the schema. This indicates previously installed modules that are disabled but not un-installed or modules that do not use the Schema API.

    * event_timezones

I accidentally deleted the table while cleaning up a bunch of unused cruft. I think the event module included the event table in the schema API but neglected to include the event_timezones table.


Edit: Additional information. The Schema Inspect shows that the event module defines the schema for the 'event' table, but the 'event_timezones' table is unknown. The following should be added to the event modules schema definition.

$schema['event_timezones'] = array(
  'description' => t('TODO: please describe this table!'),
  'fields' => array(
    'timezone' => array(
      'description' => t('TODO: please describe this field!'),
      'type' => 'int',
      'not null' => TRUE,
      'default' => 0,
    ),
    'name' => array(
      'description' => t('TODO: please describe this field!'),
      'type' => 'varchar',
      'length' => '255',
      'not null' => TRUE,
      'default' => '',
    ),
    'offset' => array(
      'description' => t('TODO: please describe this field!'),
      'type' => 'time',
      'not null' => TRUE,
      'default' => '00:00:00',
    ),
    'offset_dst' => array(
      'description' => t('TODO: please describe this field!'),
      'type' => 'time',
      'not null' => TRUE,
      'default' => '00:00:00',
    ),
    'dst_region' => array(
      'description' => t('TODO: please describe this field!'),
      'type' => 'int',
      'not null' => TRUE,
      'default' => 0,
    ),
    'is_dst' => array(
      'description' => t('TODO: please describe this field!'),
      'type' => 'int',
      'not null' => TRUE,
      'default' => 0,
    ),
  ),
  'primary key' => array('timezone'),
);

Specifically, in what file or files do I need to enter the above code?

dude4linux's schema for event_timezones on postgresql produces the warning:

* Field event_timezones.offset: no Schema type for pgsql type interval.
* Field event_timezones.offset_dst: no Schema type for pgsql type interval.
* event_timezones.offset: no type for Schema type time:normal.
* Field event_timezones.offset: no Schema type for type time.
* event_timezones.offset_dst: no type for Schema type time:normal.
* Field event_timezones.offset_dst: no Schema type for type time.

and event_timezones shows up as a mismatch.

The problem is, of course, that there is no Schema API type for mysql time or pgsql interval. You're not going to totally eliminate Schema warnings until there is a Schema API type for this. The best I can come up so far at least eliminates the mismatch:

$schema['event_timezones'] = array(
  'description' => t('TODO: please describe this table!'),
  'fields' => array(
    'timezone' => array(
      'description' => t('TODO: please describe this field!'),
      'type' => 'int',
      'not null' => TRUE,
      'default' => 0,
    ),
    'name' => array(
      'description' => t('TODO: please describe this field!'),
      'type' => 'varchar',
      'length' => '255',
      'not null' => TRUE,
      'default' => '',
    ),
    'offset' => array(
      'description' => t('TODO: please describe this field!'),
      'type' => 'varchar',
      'mysql_type' => 'time',
      'pgsql_type' => 'interval',
      'not null' => TRUE,
      'default' => '00:00:00',
    ),
    'offset_dst' => array(
      'description' => t('TODO: please describe this field!'),
      'type' => 'varchar',
      'mysql_type' => 'time',
      'pgsql_type' => 'interval',
      'not null' => TRUE,
      'default' => '00:00:00',
    ),
    'dst_region' => array(
      'description' => t('TODO: please describe this field!'),
      'type' => 'int',
      'not null' => TRUE,
      'default' => 0,
    ),
    'is_dst' => array(
      'description' => t('TODO: please describe this field!'),
      'type' => 'int',
      'not null' => TRUE,
      'default' => 0,
    ),
  ),
  'primary key' => array('timezone'),
);

lvadillo, this goes in event.install, inside the event_schema function.

Event for Drupal 8 is unrelated to older versions. If an issue similar to this one exists, please open a new issue with the 8.x branch.