paymentreference.install in Payment 7

Installation and uninstallation functions.

File

modules/paymentreference/paymentreference.install

<?php

/**
 * @file
 * Installation and uninstallation functions.
 */

/**
 * Implements hook_schema().
 */
function paymentreference_schema() {
  $schema['paymentreference'] = array(
    'fields' => array(
      'bundle' => array(
        'type' => 'varchar',
        'length' => 128,
        'not null' => TRUE,
      ),
      'entity_type' => array(
        'type' => 'varchar',
        'length' => 32,
        'not null' => TRUE,
      ),
      'field_name' => array(
        'type' => 'varchar',
        'length' => 32,
        'not null' => TRUE,
      ),
      'pid' => array(
        'type' => 'int',
        'not null' => TRUE,
        'default' => 0,
      ),
    ),
    'primary key' => array(
      'pid',
    ),
    'foreign keys' => array(
      'pid' => array(
        'table' => 'payment',
        'columns' => array(
          'pid' => 'pid',
        ),
      ),
    ),
    'indexes' => array(
      'instance' => array(
        'bundle',
        'entity_type',
        'field_name',
      ),
    ),
  );
  return $schema;
}

/**
 * Implements hook_field_schema().
 */
function paymentreference_field_schema($field) {
  if ($field['type'] == 'paymentreference') {
    $schema = array(
      'columns' => array(
        'pid' => array(
          'type' => 'int',
          'size' => 'big',
          'not null' => TRUE,
        ),
      ),
      'foreign_keys' => array(
        'pid' => array(
          'table' => 'payment',
          'columns' => array(
            'pid' => 'pid',
          ),
        ),
      ),
      'indexes' => array(
        'pid' => array(
          'pid',
        ),
      ),
    );
  }
  return $schema;
}

/**
 * Deletes orphaned items from {paymentreference}.
 */
function paymentreference_update_7100(&$sandbox) {
  $pids = db_query("SELECT pr.pid FROM {paymentreference} pr LEFT JOIN {payment} p ON pr.pid = p.pid WHERE p.pid IS NULL")
    ->fetchCol();
  if ($pids) {
    db_delete('paymentreference')
      ->condition('pid', $pids)
      ->execute();
  }
}

/**
 * Modify field lengths to follow Drupal core.
 */
function paymentreference_update_7101() {
  db_drop_index('paymentreference', 'instance');
  db_change_field('paymentreference', 'bundle', 'bundle', array(
    'type' => 'varchar',
    'length' => 128,
    'not null' => TRUE,
  ));
  db_change_field('paymentreference', 'entity_type', 'entity_type', array(
    'type' => 'varchar',
    'length' => 32,
    'not null' => TRUE,
  ));
  db_change_field('paymentreference', 'field_name', 'field_name', array(
    'type' => 'varchar',
    'length' => 32,
    'not null' => TRUE,
  ));
  db_add_index('paymentreference', 'instance', array(
    'bundle',
    'entity_type',
    'field_name',
  ));
}

Functions

Name	Description
paymentreference_field_schema	Implements hook_field_schema().
paymentreference_schema	Implements hook_schema().
paymentreference_update_7100	Deletes orphaned items from {paymentreference}.
paymentreference_update_7101	Modify field lengths to follow Drupal core.