function merci_hours_schema in MERCI (Manage Equipment Reservations, Checkout and Inventory) 7.3

Implements hook_schema().

File

merci_hours/merci_hours.install, line 6

Code

function merci_hours_schema() {
  $schema = array();
  $schema['merci_hours'] = array(
    'description' => 'Stores merci hours.',
    'fields' => array(
      'id' => array(
        'type' => 'serial',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'description' => 'Primary Key: Unique work calendar ID.',
      ),
      'name' => array(
        'type' => 'varchar',
        'length' => 32,
        'not null' => TRUE,
        'default' => '',
        'description' => 'The machine name of this work calendar.',
      ),
      'label' => array(
        'type' => 'varchar',
        'length' => 255,
        'not null' => TRUE,
        'default' => '',
        'description' => 'The label of this work calendar.',
      ),
      'description' => array(
        'type' => 'text',
        'not null' => FALSE,
        'size' => 'medium',
        'description' => 'A brief description of this work calendar.',
      ),
    ) + entity_exportable_schema_fields(),
    'primary key' => array(
      'id',
    ),
    'unique keys' => array(
      'name' => array(
        'name',
      ),
    ),
  );
  return $schema;
}