drupal_sync.install

<?php

/**
 * @file
 * Install, update and uninstall functions for the drupal_sync module.
 */

/**
 * Implements hook_schema().
 */
function drupal_sync_schema() {
  $schema['drupal_sync'] = array(
    'description' => 'The base table for synchronization entities between multiple sites.',
    'fields' => array(
      'eid' => array(
        'description' => 'The primary identifier for a entity.',
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
      ),
      'reid' => array(
        'description' => 'The remote identifier for a entity.',
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => FALSE,
        'default' => 0
      ),
      'entity_type' => array(
        'description' => 'The type of entity.',
        'type' => 'varchar',
        'length' => 128,
        'not null' => TRUE,
        'default' => '',
      ),
      'site_id' => array(
        'description' => 'The ID of remote site (site name in drupal_sync configuration settings).',
        'type' => 'varchar',
        'length' => 128,
        'not null' => TRUE,
        'default' => '',
      ),
      'source_eid' => array(
        'description' => 'The entity identifier for first source.',
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
      ),
      'source_site_id' => array(
        'description' => 'The ID of first source remote site.',
        'type' => 'varchar',
        'length' => 128,
        'not null' => TRUE,
        'default' => '',
      ),
      'source_changed' => array(
        'description' => 'The Unix timestamp when the source entity was changed.',
        'type' => 'int',
        'default' => 0,
      ),
    ),
    'primary key' => array('eid', 'reid', 'site_id', 'entity_type'),
  );

  $schema['drupal_sync_in_progress'] = array(
    'description' => 'The base table for synchronization entities between multiple sites.',
    'fields' => array(
      'source_eid' => array(
        'description' => 'The entity identifier for first source.',
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
      ),
     'entity_type' => array(
        'description' => 'The type of entity.',
        'type' => 'varchar',
        'length' => 128,
        'not null' => TRUE,
        'default' => '',
      ),
      'source_site_id' => array(
        'description' => 'The ID of first source remote site.',
        'type' => 'varchar',
        'length' => 128,
        'not null' => TRUE,
        'default' => '',
      ),
      'source_changed' => array(
        'description' => 'The Unix timestamp when the source entity was changed.',
        'type' => 'int',
        'default' => 0,
      ),
      'operation' => array(
        'description' => 'Synchronization operation.',
        'type' => 'varchar',
        'length' => 128,
        'not null' => TRUE,
        'default' => '',
      ),
    ),
    'primary key' => array('source_eid', 'source_site_id', 'operation'),
  );

  $schema['drupal_sync_queue'] = array(
    'description' => 'The table for queue synchronization.',
    'fields' => array(
      'id' => array(
        'description' => 'The primary identifier.',
        'type' => 'serial',
        'unsigned' => TRUE,
        'not null' => TRUE,
      ),
      'remote_site_id' => array(
        'description' => 'The ID of remove site (URL).',
        'type' => 'varchar',
        'length' => 128,
        'not null' => TRUE,
        'default' => '',
      ),
      'entity_id' => array(
        'description' => 'The local entity ID.',
        'type' => 'int',
        'not null' => TRUE,
      ),
      'entity_type' => array(
        'description' => 'The type of entity.',
        'type' => 'varchar',
        'length' => 128,
        'not null' => TRUE,
        'default' => '',
      ),
      'entity' => array(
        'description' => 'The entity array',
        'type' => 'blob',
        'not null' => FALSE,
        'size' => 'big',
        'serialize' => TRUE,
      ),
      'operation' => array(
        'description' => 'The sync operation',
        'type' => 'varchar',
        'length' => 128,
        'not null' => TRUE,
        'default' => 'insert',
      ),
      'created' => array(
        'type' => 'int',
        'not null' => TRUE,
        'default' => 0,
        'description' => 'Timestamp for when row was created.',
      ),
      'status' => array(
        'type' => 'varchar',
        'length' => 30,
        'not null' => TRUE,
        'default' => 'awaiting',
      ),
    ),
    'primary key' => array('id'),
  );

  return $schema;
}

/**
 * Implements hook_install().
 */
function drupal_sync_install() {

}

/**
 * Implements hook_uninstall().
 */
function drupal_sync_uninstall() {
  variable_del('drupal_sync_remote_relation_settings');
  variable_del('drupal_sync_settings');
  variable_del('drupal_sync_update_last_time');
  variable_del('drupal_sync_xmlrpc_auth_options');
}



/**
 * Add fields to table.
 */
function drupal_sync_update_7000() {
  db_add_field('drupal_sync_queue', 'status', array(
    'type' => 'varchar',
    'length' => 30,
    'not null' => TRUE,
    'default' => 'awaiting',
  ));
}

/**
 * Add fields to table drupal_sync_in_progress.
 */
function drupal_sync_update_7001() {
  db_add_field('drupal_sync_in_progress', 'entity_type', array(
    'description' => 'The type of entity.',
    'type' => 'varchar',
    'length' => 128,
    'not null' => TRUE,
    'default' => '',
  ));
}

/**
 * Change primary key in 'drupal_sync' table.
 */
function drupal_sync_update_7002() {
  db_drop_primary_key('drupal_sync');
  db_add_primary_key('drupal_sync', array('eid', 'reid', 'site_id', 'entity_type'));
}

/**
 * Change field reid in drupal_sync_table, now reid can be NULL.
 */
function drupal_sync_update_7003() {
  db_change_field('drupal_sync', 'reid', 'reid',
      array(
        'description' => 'The remote identifier for a entity.',
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => FALSE,
      ));
}

/**
 * Change field reid in drupal_sync_table, now reid cant be NULL.
 */
function drupal_sync_update_7004() {
  db_change_field('drupal_sync', 'reid', 'reid',
      array(
        'description' => 'The remote identifier for a entity.',
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
      ));
}

/**
 * Change field reid in drupal_sync_table, now reid can be NULL.
 */
function drupal_sync_update_7005() {
  db_change_field('drupal_sync', 'reid', 'reid',
      array(
        'description' => 'The remote identifier for a entity.',
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => FALSE,
        'default' => 0
      ));
}