globallink.install in GlobalLink Connect for Drupal 7.6

Installation file for GlobalLink module.

File

globallink.install

<?php

/**
 * @file
 * Installation file for GlobalLink module.
 */

/**
 * Implements hook_schema().
 */
function globallink_schema() {
  $schema = array();
  $schema['globallink_core'] = array(
    'description' => 'GlobalLink Core Table',
    'fields' => array(
      'rid' => array(
        'description' => 'The row ID',
        'type' => 'serial',
        'unsigned' => FALSE,
        'not null' => TRUE,
      ),
      'nid' => array(
        'description' => 'The node id',
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'default' => 0,
      ),
      'vid' => array(
        'description' => 'The current {node_revisions}.vid version identifier.',
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'default' => 0,
      ),
      'type' => array(
        'description' => 'The {node_type}.type of this node.',
        'type' => 'varchar',
        'length' => 32,
        'not null' => TRUE,
        'default' => '',
      ),
      'title' => array(
        'description' => 'The title of this node, always treated as non-markup plain text.',
        'type' => 'varchar',
        'length' => 255,
        'not null' => TRUE,
        'default' => '',
      ),
      'timestamp' => array(
        'description' => 'The timestamp',
        'type' => 'int',
        'length' => 14,
        'unsigned' => TRUE,
        'not null' => FALSE,
      ),
      'source' => array(
        'description' => 'The origin language of the requested translation',
        'type' => 'varchar',
        'length' => 12,
        'not null' => TRUE,
      ),
      'target' => array(
        'description' => 'The target language of the requested translation',
        'type' => 'varchar',
        'length' => 12,
        'not null' => TRUE,
      ),
      'status' => array(
        'description' => 'The status of the request',
        'type' => 'varchar',
        'not null' => TRUE,
        'default' => 'Pending Translations',
        'length' => 50,
      ),
      'document_ticket' => array(
        'description' => 'PD Document Ticket Id',
        'type' => 'varchar',
        'not null' => TRUE,
        'default' => '',
        'length' => 50,
      ),
      'submission' => array(
        'description' => 'PD Submission Name',
        'type' => 'varchar',
        'not null' => TRUE,
        'default' => '',
        'length' => 255,
      ),
      'submission_ticket' => array(
        'description' => 'PD Submission Ticket Id',
        'type' => 'varchar',
        'not null' => TRUE,
        'default' => '',
        'length' => 50,
      ),
      'project_code' => array(
        'description' => 'PD Project Code',
        'type' => 'varchar',
        'not null' => TRUE,
        'default' => '',
        'length' => 255,
      ),
      'last_modified' => array(
        'description' => 'Last Modified Date for Source Node',
        'type' => 'int',
        'length' => 14,
        'unsigned' => TRUE,
        'not null' => FALSE,
      ),
      'changed' => array(
        'description' => 'Boolean Flag indicating whether source node has changed',
        'type' => 'int',
        'length' => 1,
        'unsigned' => TRUE,
        'not null' => TRUE,
        'default' => 0,
      ),
    ),
    'primary key' => array(
      'rid',
    ),
    'indexes' => array(
      'status' => array(
        'status',
      ),
    ),
  );
  $schema['globallink_locale'] = array(
    'description' => 'GlobalLink Locale Table',
    'fields' => array(
      'locale_code' => array(
        'description' => 'ISO locale code',
        'type' => 'varchar',
        'length' => 10,
        'not null' => TRUE,
      ),
      'locale_desc' => array(
        'description' => 'ISO locale description',
        'type' => 'varchar',
        'length' => 50,
        'not null' => TRUE,
      ),
      'drupal_locale_code' => array(
        'description' => 'Drupal locale code',
        'type' => 'varchar',
        'length' => 10,
        'not null' => FALSE,
      ),
      'drupal_locale_desc' => array(
        'description' => 'Drupal locale description',
        'type' => 'varchar',
        'length' => 50,
        'not null' => FALSE,
      ),
    ),
    'primary key' => array(
      'locale_code',
    ),
    'indexes' => array(
      'drupal_locale_code' => array(
        'drupal_locale_code',
      ),
    ),
  );
  $schema['globallink_field_config'] = array(
    'description' => 'GlobalLink Field Config Table',
    'fields' => array(
      'fid' => array(
        'description' => 'The row ID',
        'type' => 'serial',
        'unsigned' => FALSE,
        'not null' => TRUE,
      ),
      'content_type' => array(
        'description' => 'The content type for the field',
        'type' => 'varchar',
        'length' => 32,
        'not null' => TRUE,
      ),
      'entity_type' => array(
        'description' => 'The entity type for the field',
        'type' => 'varchar',
        'length' => 255,
        'not null' => TRUE,
      ),
      'bundle' => array(
        'description' => 'The node type for this field',
        'type' => 'varchar',
        'length' => 255,
        'not null' => TRUE,
      ),
      'field_name' => array(
        'description' => 'The field_name for this field',
        'type' => 'varchar',
        'length' => 255,
        'not null' => TRUE,
      ),
      'field_type' => array(
        'description' => 'The field_type for this field',
        'type' => 'varchar',
        'length' => 255,
        'not null' => TRUE,
      ),
      'field_label' => array(
        'description' => 'The field_label for this field',
        'type' => 'varchar',
        'length' => 255,
        'not null' => FALSE,
      ),
      'field_format' => array(
        'description' => 'The field_format for this field',
        'type' => 'varchar',
        'length' => 255,
        'not null' => FALSE,
      ),
      'translatable' => array(
        'description' => 'Is this field translatable?',
        'type' => 'int',
        'length' => 1,
        'unsigned' => TRUE,
        'not null' => TRUE,
        'default' => 0,
      ),
    ),
    'primary key' => array(
      'fid',
    ),
    'indexes' => array(
      'field_name' => array(
        'field_name',
      ),
    ),
  );
  return $schema;
}

/**
 * Implements hook_install().
 */
function globallink_install() {
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'aa',
    'locale_desc' => 'Afar',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'aa_DJ',
    'locale_desc' => 'Afar, Djibouti',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'aa_ER',
    'locale_desc' => 'Afar, Eritrea',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'aa_ET',
    'locale_desc' => 'Afar, Ethiopia',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ab_GE',
    'locale_desc' => 'Abkhazian, Georgia',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ae_ES',
    'locale_desc' => 'Spain, Aranese',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'af',
    'locale_desc' => 'Afrikaans',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'af_NA',
    'locale_desc' => 'Afrikaans, Namibia',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'af_ZA',
    'locale_desc' => 'Afrikaans, South Africa',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'am',
    'locale_desc' => 'Amharic',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'am_ET',
    'locale_desc' => 'Amharic, Ethiopia',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'an',
    'locale_desc' => 'Aragonese',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'an_ES',
    'locale_desc' => 'Aragonese, Spain',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ar',
    'locale_desc' => 'Arabic',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ar_AE',
    'locale_desc' => 'Arabic, United Arab Emirates',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ar_BH',
    'locale_desc' => 'Arabic, Bahrain',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ar_DZ',
    'locale_desc' => 'Arabic, Algeria',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ar_EG',
    'locale_desc' => 'Arabic, Egypt',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ar_IQ',
    'locale_desc' => 'Arabic, Iraq',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ar_JO',
    'locale_desc' => 'Arabic, Jordan',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ar_KW',
    'locale_desc' => 'Arabic, Kuwait',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ar_LB',
    'locale_desc' => 'Arabic, Lebanon',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ar_LY',
    'locale_desc' => 'Arabic, Libya',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ar_MA',
    'locale_desc' => 'Arabic, Morocco',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ar_OM',
    'locale_desc' => 'Arabic, Oman',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ar_QA',
    'locale_desc' => 'Arabic, Qatar',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ar_SA',
    'locale_desc' => 'Arabic, Saudi Arabia',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ar_SD',
    'locale_desc' => 'Arabic, Sudan',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ar_SY',
    'locale_desc' => 'Arabic, Syria',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ar_TN',
    'locale_desc' => 'Arabic, Tunisia',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ar_YE',
    'locale_desc' => 'Arabic, Yemen',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'as',
    'locale_desc' => 'Assamese',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'as_IN',
    'locale_desc' => 'Assamese, India',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ay',
    'locale_desc' => 'Aymara',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ay_BO',
    'locale_desc' => 'Aymara, Bolivia',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ay_PE',
    'locale_desc' => 'Aymara, Peru',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'az',
    'locale_desc' => 'Azerbaijani',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'az_AZ',
    'locale_desc' => 'Azerbaijani, Azerbaijan',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'az-XC',
    'locale_desc' => 'Azerbaijani-Cyrillic',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'az-XE',
    'locale_desc' => 'Azerbaijani-Latin',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ba',
    'locale_desc' => 'Bashkir',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ba_RU',
    'locale_desc' => 'Bashkir, Russia',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'bd_ID',
    'locale_desc' => 'Bahasa, Indonesia',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'bd_MY',
    'locale_desc' => 'Bahasa, Malaysia',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'be',
    'locale_desc' => 'Belarusian',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'be_BY',
    'locale_desc' => 'Byelorussian, Byelorussia',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'bg',
    'locale_desc' => 'Bulgarian',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'bg_BG',
    'locale_desc' => 'Bulgarian, Bulgaria',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'bh',
    'locale_desc' => 'Bihari',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'bi',
    'locale_desc' => 'Bislama',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'bn',
    'locale_desc' => 'Bengali',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'bn_BD',
    'locale_desc' => 'Bengali, Bangladesh',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'bn_IN',
    'locale_desc' => 'Bengali, India',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'bo_CN',
    'locale_desc' => 'Tibetan, China',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'br',
    'locale_desc' => 'Breton',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'bs',
    'locale_desc' => 'Bosnian',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'bs-BA',
    'locale_desc' => 'Bosnian, Bosnien und Herzegowina',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ca',
    'locale_desc' => 'Catalan',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ca_ES',
    'locale_desc' => 'Catalan, Spain',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'cb',
    'locale_desc' => 'Cebuano',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'cb_PH',
    'locale_desc' => 'Cebuano, Philippines',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ce',
    'locale_desc' => 'Chechen',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ch',
    'locale_desc' => 'Chamorro',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'co',
    'locale_desc' => 'Corsican',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'cs',
    'locale_desc' => 'Czech',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'cs_CZ',
    'locale_desc' => 'Czech, Czech Republic',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'cy',
    'locale_desc' => 'Welsh',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'cy_GB',
    'locale_desc' => 'Welsh, United Kingdom',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'da',
    'locale_desc' => 'Danish',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'da_DK',
    'locale_desc' => 'Danish, Denmark',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'de',
    'locale_desc' => 'German',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'de_AT',
    'locale_desc' => 'German, Austria',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'de_CH',
    'locale_desc' => 'German, Switzerland',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'de_DE',
    'locale_desc' => 'German, Germany',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'de_LI',
    'locale_desc' => 'German, Liechtenstein',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'de_LU',
    'locale_desc' => 'German, Luxembourg',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'dz',
    'locale_desc' => 'Dzongkha',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'el',
    'locale_desc' => 'Greek',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'el_CY',
    'locale_desc' => 'Greek, Cyprus',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'el_GR',
    'locale_desc' => 'Greek, Greece',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'en',
    'locale_desc' => 'English',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'en_AU',
    'locale_desc' => 'English, Australia',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'en_BZ',
    'locale_desc' => 'English, Belize',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'en_CA',
    'locale_desc' => 'English, Canada',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'en_CB',
    'locale_desc' => 'English, Caribbean',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'en_GB',
    'locale_desc' => 'English, United Kingdom',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'en_ID',
    'locale_desc' => 'English, Indonesia',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'en_IE',
    'locale_desc' => 'English, Ireland',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'en_IN',
    'locale_desc' => 'English, India',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'en_JM',
    'locale_desc' => 'English, Jamaica',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'en_MT',
    'locale_desc' => 'English, Malta',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'en_NZ',
    'locale_desc' => 'English, New Zealand',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'en_PH',
    'locale_desc' => 'English, Philippines',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'en_RH',
    'locale_desc' => 'English, Zimbabwe',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'en_SG',
    'locale_desc' => 'English, Singapore',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'en_TT',
    'locale_desc' => 'English, Trinidad and Tobago',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'en_US',
    'locale_desc' => 'English, United States',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'en_ZA',
    'locale_desc' => 'English, South Africa',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'es',
    'locale_desc' => 'Spanish',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'es_AR',
    'locale_desc' => 'Spanish, Argentina',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'es_BO',
    'locale_desc' => 'Spanish, Bolivia',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'es_CL',
    'locale_desc' => 'Spanish, Chile',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'es_CO',
    'locale_desc' => 'Spanish, Colombia',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'es_CR',
    'locale_desc' => 'Spanish, Costa Rica',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'es_DO',
    'locale_desc' => 'Spanish, Dominican Republic',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'es_EC',
    'locale_desc' => 'Spanish, Ecuador',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'es_ES',
    'locale_desc' => 'Spanish, Spain',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'es_GT',
    'locale_desc' => 'Spanish, Guatemala',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'es_HN',
    'locale_desc' => 'Spanish, Honduras',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'es_LA',
    'locale_desc' => 'Spanish, Latin America',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'es_MX',
    'locale_desc' => 'Spanish, Mexico',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'es_NI',
    'locale_desc' => 'Spanish, Nicaragua',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'es_PA',
    'locale_desc' => 'Spanish, Panama',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'es_PE',
    'locale_desc' => 'Spanish, Peru',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'es_PR',
    'locale_desc' => 'Spanish, Puerto Rico',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'es_PY',
    'locale_desc' => 'Spanish, Paraguay',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'es_SV',
    'locale_desc' => 'Spanish, El Salvador',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'es_US',
    'locale_desc' => 'Spanish, United States',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'es_UY',
    'locale_desc' => 'Spanish, Uruguay',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'es_VE',
    'locale_desc' => 'Spanish, Venezuela',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'et',
    'locale_desc' => 'Estonian',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'et_EE',
    'locale_desc' => 'Estonian, Estonia',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'eu',
    'locale_desc' => 'Basque',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'eu_ES',
    'locale_desc' => 'Basque, Spain',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'fa',
    'locale_desc' => 'Persian',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'fa_AF',
    'locale_desc' => 'Persian-Dari, Afghanistan',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'fa_IR',
    'locale_desc' => 'Farsi, Iran',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'fi',
    'locale_desc' => 'Finnish',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'fi_FI',
    'locale_desc' => 'Finnish, Finland',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'fj',
    'locale_desc' => 'Fijian',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'fj_FJ',
    'locale_desc' => 'Fijian, Fiji',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'fj_PH',
    'locale_desc' => 'Fijian, Philippines',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'fo',
    'locale_desc' => 'Faroese',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'fo_FO',
    'locale_desc' => 'Faroese, Faroe Islands',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'fr',
    'locale_desc' => 'French',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'fr_BE',
    'locale_desc' => 'French, Belgium',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'fr_CA',
    'locale_desc' => 'French, Canada',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'fr_CH',
    'locale_desc' => 'French, Switzerland',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'fr_FR',
    'locale_desc' => 'French, France',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'fr_LU',
    'locale_desc' => 'French, Luxembourg',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'fr_MC',
    'locale_desc' => 'French, Monaco',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'fr_NC',
    'locale_desc' => 'French, New Caledonia',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'fr_PF',
    'locale_desc' => 'French, French Polynesia',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'fy',
    'locale_desc' => 'Frisian',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'fy_NL',
    'locale_desc' => 'Frisian, Netherlands',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ga',
    'locale_desc' => 'Irish',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ga_IE',
    'locale_desc' => 'Irish, Ireland',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'gd',
    'locale_desc' => 'Scottish Gaelic',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'gd_GB',
    'locale_desc' => 'Scottish Gaelic, United Kingdom',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'gl',
    'locale_desc' => 'Galician',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'gl_ES',
    'locale_desc' => 'Galician, Spain',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'gn',
    'locale_desc' => 'Guaraní',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'gs_ES',
    'locale_desc' => 'Gascon, Spain',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'gu',
    'locale_desc' => 'Gujarati',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'gu_IN',
    'locale_desc' => 'Gujarati, India',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ha',
    'locale_desc' => 'Hausa',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'he',
    'locale_desc' => 'Hebrew',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'he_IL',
    'locale_desc' => 'Hebrew, Israel',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'hi',
    'locale_desc' => 'Hindi',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'hi_IN',
    'locale_desc' => 'Hindi, India',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'hm',
    'locale_desc' => 'Hmong',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'hr',
    'locale_desc' => 'Croatian',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'hr_HR',
    'locale_desc' => 'Croatian, Croatia',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ht',
    'locale_desc' => 'Haitian',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'hu',
    'locale_desc' => 'Hungarian',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'hu_HU',
    'locale_desc' => 'Hungarian, Hungary',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'hy',
    'locale_desc' => 'Armenian',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'hy_AM',
    'locale_desc' => 'Armenian, Armenia',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ia',
    'locale_desc' => 'Interlingua',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'id',
    'locale_desc' => 'Indonesian',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'id_ID',
    'locale_desc' => 'Indonesian, Indonesia',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ie',
    'locale_desc' => 'Interlingue',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ik',
    'locale_desc' => 'Inupiaq',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'il',
    'locale_desc' => 'Ilonggo',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'is',
    'locale_desc' => 'Icelandic',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'is_IS',
    'locale_desc' => 'Icelandic, Iceland',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'it',
    'locale_desc' => 'Italian',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'it_CH',
    'locale_desc' => 'Italian, Switzerland',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'it_IT',
    'locale_desc' => 'Italian, Italy',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'iu',
    'locale_desc' => 'Inuktitut',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ja',
    'locale_desc' => 'Japanese',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ja_JP',
    'locale_desc' => 'Japanese, Japan',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'jv',
    'locale_desc' => 'Javanese',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ka_GE',
    'locale_desc' => 'Georgian, Georgia',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'kk_KZ',
    'locale_desc' => 'Kazakh, Kazakhstan',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'kl',
    'locale_desc' => 'Kalaallisut',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'km_KH',
    'locale_desc' => 'Khmer, Cambodia',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'kn_IN',
    'locale_desc' => 'Kannada, India',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ko',
    'locale_desc' => 'Korean',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ko_KR',
    'locale_desc' => 'Korean, South Korea',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ko_KP',
    'locale_desc' => 'Korean, North Korea',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ks',
    'locale_desc' => 'Kashmiri',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ku',
    'locale_desc' => 'Kurdish',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ku_TR',
    'locale_desc' => 'Kurdish, Turkey',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ky_KG',
    'locale_desc' => 'Kirghiz, Kyrgyzstan',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'la',
    'locale_desc' => 'Latin',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'lb_LU',
    'locale_desc' => 'Luxembourgish, Luxembourg',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ln',
    'locale_desc' => 'Lingala',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ln_CD',
    'locale_desc' => 'Lingala, The Democratic Republic Of Congo',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'lo_LA',
    'locale_desc' => 'Lao, Laos',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'lt',
    'locale_desc' => 'Lithuanian',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'lt_LT',
    'locale_desc' => 'Lithuanian, Lithuania',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'lv',
    'locale_desc' => 'Latvian',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'lv_LV',
    'locale_desc' => 'Latvian, Latvia',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'mg',
    'locale_desc' => 'Malagasy',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'mg_MG',
    'locale_desc' => 'Malagasy, Madagascar',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'mi',
    'locale_desc' => 'Maori',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'mk',
    'locale_desc' => 'Macedonian',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'mk_MK',
    'locale_desc' => 'Macedonian, Macedonia',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ml',
    'locale_desc' => 'Malayalam',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ml_IN',
    'locale_desc' => 'Malayalam, India',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'mn',
    'locale_desc' => 'Mongolian',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'mn_MN',
    'locale_desc' => 'Mongolian, Mongolia',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'mo',
    'locale_desc' => 'Moldavian',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'mo_MD',
    'locale_desc' => 'Moldovan, Moldova',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'mr',
    'locale_desc' => 'Marathi',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'mr_IN',
    'locale_desc' => 'Marathi, India',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ms',
    'locale_desc' => 'Malay',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ms_SG',
    'locale_desc' => 'Malay, Singapore',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ms_BX',
    'locale_desc' => 'Malay, Brunei Darussalam',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ms_MY',
    'locale_desc' => 'Malay, Malaysia',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'mt',
    'locale_desc' => 'Maltese',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'mt_MT',
    'locale_desc' => 'Maltese, Malta',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'my_MM',
    'locale_desc' => 'Burmese, MyanMar (Burma)',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'na',
    'locale_desc' => 'Nauru',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'nb_NO',
    'locale_desc' => 'Norwegian Bokmal, Norway',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'nd_ZA',
    'locale_desc' => 'North Ndebele, South Africa',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ne',
    'locale_desc' => 'Nepali',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ne_NP',
    'locale_desc' => 'Nepali, Nepal',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'nl',
    'locale_desc' => 'Dutch',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'nl_BE',
    'locale_desc' => 'Dutch, Belgium',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'nl_NL',
    'locale_desc' => 'Dutch, Netherlands',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'no',
    'locale_desc' => 'Norwegian',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'no_NO',
    'locale_desc' => 'Norwegian (Nynorsk), Norway',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'nr_ZA',
    'locale_desc' => 'South Ndebele, South Africa',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ns_ZA',
    'locale_desc' => 'Nothern Sotho, South Africa',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ny_MW',
    'locale_desc' => 'Nyanja, Malawi',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'oc',
    'locale_desc' => 'Occitan',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'oc_FR',
    'locale_desc' => 'Occitan, France',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'om',
    'locale_desc' => 'Oromo',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'om_ET',
    'locale_desc' => 'Oromo, Ethiopia',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'or',
    'locale_desc' => 'Oriya',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'or_IN',
    'locale_desc' => 'Oriya, India',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'pa',
    'locale_desc' => 'Punjabi',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'pa_IN',
    'locale_desc' => 'Punjabi (Gurmukha), India',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'pa_PK',
    'locale_desc' => 'Punjabi (Shahmukhi), Pakistan',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'pl',
    'locale_desc' => 'Polish',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'pl_PL',
    'locale_desc' => 'Polish, Poland',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ps_AF',
    'locale_desc' => 'Pashto, Afghanistan',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'pt',
    'locale_desc' => 'Portuguese',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'pt_BR',
    'locale_desc' => 'Portuguese, Brazil',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'pt_PT',
    'locale_desc' => 'Portuguese, Portugal',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'qu',
    'locale_desc' => 'Quechua',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'qu_BO',
    'locale_desc' => 'Quechua, Bolivia',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'qu_EU',
    'locale_desc' => 'Quechua, Ecuador',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'rm',
    'locale_desc' => 'Romansh',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'rn',
    'locale_desc' => 'Kirundi',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ro',
    'locale_desc' => 'Romanian',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ro_RO',
    'locale_desc' => 'Romanian, Romania',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ru',
    'locale_desc' => 'Russian',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ru_KZ',
    'locale_desc' => 'Russian, Kazakhstan',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ru_KG',
    'locale_desc' => 'Russian, Kyrgyzstan',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ru_UA',
    'locale_desc' => 'Russian, Ukraine',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ru_BY',
    'locale_desc' => 'Russian, Belarus',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ru_RU',
    'locale_desc' => 'Russian, Russia',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'rw',
    'locale_desc' => 'Kinyarwanda',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'rw_RW',
    'locale_desc' => 'Kinyarwanda, Rwanda',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'sa',
    'locale_desc' => 'Sanskrit',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'sd',
    'locale_desc' => 'Sindhi',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'sg',
    'locale_desc' => 'Sango',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'sh_YU',
    'locale_desc' => 'Serbo_Croatian, Yugoslavia',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'si_LK',
    'locale_desc' => 'Sinhalese, Sri Lanka',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'sk',
    'locale_desc' => 'Slovak',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'sk_SK',
    'locale_desc' => 'Slovak, Slovakia',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'sl',
    'locale_desc' => 'Slovenian',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'sl_SL',
    'locale_desc' => 'Slovenian, Slovenia',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'sm',
    'locale_desc' => 'Samoan',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'sn',
    'locale_desc' => 'Shona',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'so_SO',
    'locale_desc' => 'Somali, Somalia',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'sq',
    'locale_desc' => 'Albanian',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'sq_AL',
    'locale_desc' => 'Albanian, Albania',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'sr',
    'locale_desc' => 'Serbian',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'sr_BA',
    'locale_desc' => 'Serbian, Bosnia and Herzegovina',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'sr_CS',
    'locale_desc' => 'Serbian, Serbia and Montenegro',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'sr-ME',
    'locale_desc' => 'Serbian, Montenegro',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'sr_YU',
    'locale_desc' => 'Serbian (Cyrillic), Yugoslavia',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ss',
    'locale_desc' => 'Swati',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ss_ZA',
    'locale_desc' => 'Swati, South Africa',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'st',
    'locale_desc' => 'Southern Sotho',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'st_ZA',
    'locale_desc' => 'Southern Sotho, South Africa',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'su_SU',
    'locale_desc' => 'Sudanese, Sudan',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'sv',
    'locale_desc' => 'Swedish',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'sv_FI',
    'locale_desc' => 'Swedish, Finland',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'sv_SE',
    'locale_desc' => 'Swedish, Sweden',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'sw',
    'locale_desc' => 'Swahili',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'sw_KE',
    'locale_desc' => 'Swahili, Kenya',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'sz',
    'locale_desc' => 'Sami',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'tg_TJ',
    'locale_desc' => 'Tajik, Tajikistan',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'th_TH',
    'locale_desc' => 'Thai, Thailand',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ta',
    'locale_desc' => 'Tamil',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ta_IN',
    'locale_desc' => 'Tamil, India',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'te',
    'locale_desc' => 'Telugu',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ti',
    'locale_desc' => 'Tigrinya',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'tk',
    'locale_desc' => 'Turkmen',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'tl',
    'locale_desc' => 'Tagalog',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'tl_PH',
    'locale_desc' => 'Tagalog, Philippines',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'tn',
    'locale_desc' => 'Tswana',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'tn_ZA',
    'locale_desc' => 'Tswana, South Africa',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'to',
    'locale_desc' => 'Tonga',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'tr',
    'locale_desc' => 'Turkish',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'tr_TR',
    'locale_desc' => 'Turkish, Turkey',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ts',
    'locale_desc' => 'Tsonga',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ts_ZA',
    'locale_desc' => 'Tsonga, South Africa',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'tt',
    'locale_desc' => 'Tatar',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'tw',
    'locale_desc' => 'Twi',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ug',
    'locale_desc' => 'Uighur',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'uk',
    'locale_desc' => 'Ukrainian',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'uk_UA',
    'locale_desc' => 'Ukrainian, Ukraine',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ur',
    'locale_desc' => 'Urdu',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ur_PK',
    'locale_desc' => 'Urdu (Pakistan), Pakistan',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 've_ZA',
    'locale_desc' => 'Venda, South Africa',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'vi',
    'locale_desc' => 'Vietnamese',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'vi-US',
    'locale_desc' => 'Vietnamese, United States',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'vi_VN',
    'locale_desc' => 'Vietnamese, Vietnam',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'vo',
    'locale_desc' => 'Volapük',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'uz_UZ',
    'locale_desc' => 'Uzbek, Uzbekistan',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'xh',
    'locale_desc' => 'Xhosa',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'xh_ZA',
    'locale_desc' => 'Xhosa, South Africa',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'yi',
    'locale_desc' => 'Yiddish',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'yo',
    'locale_desc' => 'Yoruba',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'za',
    'locale_desc' => 'Zhuang',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'zh',
    'locale_desc' => 'Chinese',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'zh_CN',
    'locale_desc' => 'Chinese (Simplified), China',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'zh_HK',
    'locale_desc' => 'Chinese, Hong Kong',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'zh_SG',
    'locale_desc' => 'Chinese (Simplified), Singapore',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'zh_TW',
    'locale_desc' => 'Chinese (Traditional), Taiwan',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'zh_XM',
    'locale_desc' => 'Chinese, Macau',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'zu',
    'locale_desc' => 'Zulu',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'zu_ZA',
    'locale_desc' => 'Zulu, South Africa',
  ))
    ->execute();
  variable_set('globallink_publish_node', 0);
  variable_set('globallink_cron_type', 0);
  variable_set('globallink_pager_limit', 10);
  variable_set('globallink_implementation_type', 0);
  variable_set('globallink_enable_preview', 1);
  variable_set('globallink_pd_max_target', 99999);
  $node_types = node_type_get_types();
  foreach ($node_types as $node_type) {
    if (!translation_supported_type($node_type->type)) {
      continue;
    }
    $field_arr = field_info_instances('node', $node_type->type);
    $keys = array_keys($field_arr);
    db_insert('globallink_field_config')
      ->fields(array(
      'content_type' => $node_type->type,
      'entity_type' => 'node',
      'bundle' => $node_type->type,
      'field_name' => 'title',
      'field_type' => 'text',
      'field_label' => 'Title',
      'translatable' => 1,
    ))
      ->execute();
    if (module_exists('metatag')) {
      db_insert('globallink_field_config')
        ->fields(array(
        'content_type' => $node_type->type,
        'entity_type' => 'node',
        'bundle' => $node_type->type,
        'field_name' => 'metatags',
        'field_type' => 'text',
        'field_label' => 'Meta tags',
        'translatable' => 1,
      ))
        ->execute();
    }
    foreach ($keys as $field_name) {
      $field = field_info_field($field_name);
      switch ($field['type']) {
        case 'list_boolean':
        case 'image':
        case 'file':
        case 'taxonomy_term_reference':
        case 'field_collection':
          break;
        default:
          $translatable = 0;
          db_insert('globallink_field_config')
            ->fields(array(
            'content_type' => $node_type->type,
            'entity_type' => 'node',
            'bundle' => $node_type->type,
            'field_name' => $field_name,
            'field_type' => $field['type'],
            'field_label' => $field_arr[$field_name]['label'],
            'translatable' => $translatable,
          ))
            ->execute();
      }
    }
    if (module_exists('field_collection')) {
      globallink_insert_field_collections($node_type->type);
    }
  }
}

/**
 * Implements hook_uninstall().
 */
function globallink_uninstall() {
  variable_del('globallink_publish_node');
  variable_del('globallink_cron_type');
  variable_del('globallink_pager_limit');
  variable_del('globallink_pd_url');
  variable_del('globallink_pd_username');
  variable_del('globallink_pd_password');
  variable_del('globallink_pd_projectid');
  variable_del('globallink_pd_submissionprefix');
  variable_del('globallink_pd_classifier');
  variable_del('globallink_pd_max_target');
  variable_del('globallink_implementation_type');
  $keys = array_keys($_SESSION);
  foreach ($keys as $key) {
    if (stristr($key, 'globallink') !== FALSE) {
      unset($_SESSION[$key]);
    }
  }
}

/**
 * Implements hook_update_N().
 *
 * Version 2.0 updates.
 */
function globallink_update_7200() {
  variable_set('globallink_pd_max_target', 99999);
  $keys = array_keys($_SESSION);
  foreach ($keys as $key) {
    if (stristr($key, 'globallink') !== FALSE) {
      unset($_SESSION[$key]);
    }
  }
  $last_modified = array(
    'description' => 'Last Modified Date for Source Node',
    'type' => 'int',
    'length' => 14,
    'unsigned' => TRUE,
    'not null' => FALSE,
  );
  db_add_field('globallink_core', 'last_modified', $last_modified);
  $changed = array(
    'description' => 'Boolean Flag indicating whether source node has changed',
    'type' => 'int',
    'length' => 1,
    'unsigned' => TRUE,
    'not null' => TRUE,
    'default' => 0,
  );
  db_add_field('globallink_core', 'changed', $changed);
  $schema = array();
  $schema['globallink_field_config'] = array(
    'description' => 'GlobalLink Field Config Table',
    'fields' => array(
      'fid' => array(
        'description' => 'The row ID',
        'type' => 'serial',
        'unsigned' => FALSE,
        'not null' => TRUE,
      ),
      'content_type' => array(
        'description' => 'The content type for the field',
        'type' => 'varchar',
        'length' => 32,
        'not null' => TRUE,
      ),
      'entity_type' => array(
        'description' => 'The entity type for the field',
        'type' => 'varchar',
        'length' => 255,
        'not null' => TRUE,
      ),
      'bundle' => array(
        'description' => 'The node type for this field',
        'type' => 'varchar',
        'length' => 255,
        'not null' => TRUE,
      ),
      'field_name' => array(
        'description' => 'The field_name for this field',
        'type' => 'varchar',
        'length' => 255,
        'not null' => TRUE,
      ),
      'field_type' => array(
        'description' => 'The field_type for this field',
        'type' => 'varchar',
        'length' => 255,
        'not null' => TRUE,
      ),
      'field_label' => array(
        'description' => 'The field_label for this field',
        'type' => 'varchar',
        'length' => 255,
        'not null' => FALSE,
      ),
      'field_format' => array(
        'description' => 'The field_format for this field',
        'type' => 'varchar',
        'length' => 255,
        'not null' => FALSE,
      ),
      'translatable' => array(
        'description' => 'Is this field translatable?',
        'type' => 'int',
        'length' => 1,
        'unsigned' => TRUE,
        'not null' => TRUE,
        'default' => 0,
      ),
    ),
    'primary key' => array(
      'fid',
    ),
    'indexes' => array(
      'field_name' => array(
        'field_name',
      ),
    ),
  );
  db_create_table('globallink_field_config', $schema['globallink_field_config']);
  $node_types = node_type_get_types();
  foreach ($node_types as $node_type) {
    if (!translation_supported_type($node_type->type)) {
      continue;
    }
    $field_arr = field_info_instances('node', $node_type->type);
    $keys = array_keys($field_arr);
    db_insert('globallink_field_config')
      ->fields(array(
      'content_type' => $node_type->type,
      'entity_type' => 'node',
      'bundle' => $node_type->type,
      'field_name' => 'title',
      'field_type' => 'text',
      'field_label' => 'Title',
      'translatable' => 1,
    ))
      ->execute();
    if (module_exists('metatag')) {
      db_insert('globallink_field_config')
        ->fields(array(
        'content_type' => $node_type->type,
        'entity_type' => 'node',
        'bundle' => $node_type->type,
        'field_name' => 'metatags',
        'field_type' => 'text',
        'field_label' => 'Meta tags',
        'translatable' => 1,
      ))
        ->execute();
    }
    foreach ($keys as $field_name) {
      $field = field_info_field($field_name);
      switch ($field['type']) {
        case 'list_boolean':
        case 'image':
        case 'file':
        case 'taxonomy_term_reference':
          break;
        case 'field_collection':
          if (!module_exists('field_collection')) {
            break;
          }
          db_insert('globallink_field_config')
            ->fields(array(
            'content_type' => $node_type->type,
            'entity_type' => 'node',
            'bundle' => $node_type->type,
            'field_name' => $field_name,
            'field_type' => $field['type'],
            'field_label' => $field_arr[$field_name]['label'],
            'translatable' => 1,
          ))
            ->execute();
          $field_info = field_info_instances('field_collection_item');
          if (!isset($field_info) || !isset($field_info[$field_name])) {
            break;
          }
          $fc_item = $field_info[$field_name];
          foreach ($fc_item as $fc_name => $fc) {
            $fc_info = field_info_field($fc_name);
            switch ($fc_info['type']) {
              case 'list_boolean':
              case 'image':
              case 'file':
              case 'taxonomy_term_reference':
              case 'field_collection':
                break;
              default:
                db_insert('globallink_field_config')
                  ->fields(array(
                  'content_type' => $node_type->type,
                  'entity_type' => 'field_collection_item',
                  'bundle' => $fc['bundle'],
                  'field_name' => $fc_name,
                  'field_type' => $fc_info['type'],
                  'field_label' => $fc['label'],
                  'translatable' => 1,
                ))
                  ->execute();
            }
          }
          break;
        default:
          db_insert('globallink_field_config')
            ->fields(array(
            'content_type' => $node_type->type,
            'entity_type' => 'node',
            'bundle' => $node_type->type,
            'field_name' => $field_name,
            'field_type' => $field['type'],
            'field_label' => $field_arr[$field_name]['label'],
            'translatable' => 1,
          ))
            ->execute();
          break;
      }
    }
  }
  return t('GlobalLink module has been successfully upgraded to version 2.0');
}

/**
 * Implements hook_update_N().
 *
 * Version 2.0.1 updates.
 */
function globallink_update_7201() {
  $keys = array_keys($_SESSION);
  foreach ($keys as $key) {
    if (stristr($key, 'globallink') !== FALSE) {
      unset($_SESSION[$key]);
    }
  }
  if (!module_exists('field_collection')) {
    return;
  }
  db_truncate('globallink_field_config')
    ->execute();
  $node_types = node_type_get_types();
  foreach ($node_types as $node_type) {
    if (!translation_supported_type($node_type->type)) {
      continue;
    }
    $field_arr = field_info_instances('node', $node_type->type);
    $keys = array_keys($field_arr);
    db_insert('globallink_field_config')
      ->fields(array(
      'content_type' => $node_type->type,
      'entity_type' => 'node',
      'bundle' => $node_type->type,
      'field_name' => 'title',
      'field_type' => 'text',
      'field_label' => 'Title',
      'translatable' => 1,
    ))
      ->execute();
    if (module_exists('metatag')) {
      db_insert('globallink_field_config')
        ->fields(array(
        'content_type' => $node_type->type,
        'entity_type' => 'node',
        'bundle' => $node_type->type,
        'field_name' => 'metatags',
        'field_type' => 'text',
        'field_label' => 'Meta tags',
        'translatable' => 1,
      ))
        ->execute();
    }
    foreach ($keys as $field_name) {
      $field = field_info_field($field_name);
      switch ($field['type']) {
        case 'list_boolean':
        case 'image':
        case 'file':
        case 'taxonomy_term_reference':
        case 'field_collection':
          break;
        default:
          $translatable = 1;
          db_insert('globallink_field_config')
            ->fields(array(
            'content_type' => $node_type->type,
            'entity_type' => 'node',
            'bundle' => $node_type->type,
            'field_name' => $field_name,
            'field_type' => $field['type'],
            'field_label' => $field_arr[$field_name]['label'],
            'translatable' => $translatable,
          ))
            ->execute();
      }
    }
    if (module_exists('field_collection')) {
      globallink_insert_field_collections($node_type->type);
    }
  }
  return t('GlobalLink module has been successfully upgraded to version 2.0.1');
}

/**
 * Inserts field collections.
 *
 * @param string $node_type
 *   The content type.
 */
function globallink_insert_field_collections($node_type) {
  $field_arr = field_info_instances('node', $node_type);
  $keys = array_keys($field_arr);
  foreach ($keys as $field_name) {
    $field_info = field_info_field($field_name);
    if ($field_info['type'] != 'field_collection') {
      continue;
    }
    db_insert('globallink_field_config')
      ->fields(array(
      'content_type' => $node_type,
      'entity_type' => 'node',
      'bundle' => $node_type,
      'field_name' => $field_name,
      'field_type' => $field_info['type'],
      'field_label' => $field_arr[$field_name]['label'],
      'translatable' => 0,
    ))
      ->execute();
    $fc_field_infos = field_info_instances('field_collection_item');
    if (isset($fc_field_infos) && isset($fc_field_infos[$field_name]) && is_array($fc_field_infos[$field_name])) {
      $fc_items = array_keys($fc_field_infos[$field_name]);
      foreach ($fc_items as $fc_item) {
        globallink_insert_field_collection_items($node_type, $field_name, $fc_item);
      }
    }
  }
}

/**
 * Inserts field collection items.
 *
 * @param string $content_type
 *   The content type.
 * @param string $parent_field_name
 *   The parent's field name.
 * @param string $field_name
 *   The field name.
 */
function globallink_insert_field_collection_items($content_type, $parent_field_name, $field_name) {
  $fc_field_info = field_info_field($field_name);
  $fc_field_instance = field_info_instance('field_collection_item', $field_name, $parent_field_name);
  switch ($fc_field_info['type']) {
    case 'list_boolean':
    case 'image':
    case 'file':
    case 'taxonomy_term_reference':
      break;
    case 'field_collection':
      db_insert('globallink_field_config')
        ->fields(array(
        'content_type' => $content_type,
        'entity_type' => 'field_collection_item',
        'bundle' => $parent_field_name,
        'field_name' => $field_name,
        'field_type' => $fc_field_info['type'],
        'field_label' => $fc_field_instance['label'],
        'translatable' => 0,
      ))
        ->execute();
      $fc_field_infos = field_info_instances('field_collection_item');
      if (isset($fc_field_infos) && isset($fc_field_infos[$field_name]) && is_array($fc_field_infos[$field_name])) {
        $fc_items = array_keys($fc_field_infos[$field_name]);
        foreach ($fc_items as $fc_item) {
          globallink_insert_field_collection_items($content_type, $field_name, $fc_item);
        }
      }
      break;
    default:
      $translatable = 1;
      db_insert('globallink_field_config')
        ->fields(array(
        'content_type' => $content_type,
        'entity_type' => 'field_collection_item',
        'bundle' => $parent_field_name,
        'field_name' => $field_name,
        'field_type' => $fc_field_info['type'],
        'field_label' => $fc_field_instance['label'],
        'translatable' => $translatable,
      ))
        ->execute();
  }
}

/**
 * Implements hook_update_N().
 *
 * Version 2.1.0 updates.
 */
function globallink_update_7210() {
  $keys = array_keys($_SESSION);
  foreach ($keys as $key) {
    if (stristr($key, 'globallink') !== FALSE) {
      unset($_SESSION[$key]);
    }
  }
  db_update('globallink_core')
    ->fields(array(
    'status' => 'Source Deleted',
  ))
    ->condition('status', 'Node Deleted', '=')
    ->execute();
}

/**
 * Implements hook_update_N().
 *
 * Version 2.3.0 updates.
 */
function globallink_update_7230() {
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'aa',
    'locale_desc' => 'Afar',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'af',
    'locale_desc' => 'Afrikaans',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'am',
    'locale_desc' => 'Amharic',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'an',
    'locale_desc' => 'Aragonese',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ar',
    'locale_desc' => 'Arabic',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'as',
    'locale_desc' => 'Assamese',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ay',
    'locale_desc' => 'Aymara',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'az',
    'locale_desc' => 'Azerbaijani',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'az-XC',
    'locale_desc' => 'Azerbaijani-Cyrillic',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'az-XE',
    'locale_desc' => 'Azerbaijani-Latin',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ba',
    'locale_desc' => 'Bashkir',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'be',
    'locale_desc' => 'Belarusian',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'bg',
    'locale_desc' => 'Bulgarian',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'bh',
    'locale_desc' => 'Bihari',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'bi',
    'locale_desc' => 'Bislama',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'bn',
    'locale_desc' => 'Bengali',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'br',
    'locale_desc' => 'Breton',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'bs',
    'locale_desc' => 'Bosnian',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'bs-BA',
    'locale_desc' => 'Bosnian, Bosnien und Herzegowina',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ca',
    'locale_desc' => 'Catalan',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'cb',
    'locale_desc' => 'Cebuano',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ce',
    'locale_desc' => 'Chechen',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ch',
    'locale_desc' => 'Chamorro',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'co',
    'locale_desc' => 'Corsican',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'cs',
    'locale_desc' => 'Czech',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'cy',
    'locale_desc' => 'Welsh',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'da',
    'locale_desc' => 'Danish',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'de',
    'locale_desc' => 'German',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'dz',
    'locale_desc' => 'Dzongkha',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'el',
    'locale_desc' => 'Greek',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'en',
    'locale_desc' => 'English',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'es',
    'locale_desc' => 'Spanish',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'et',
    'locale_desc' => 'Estonian',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'eu',
    'locale_desc' => 'Basque',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'fa',
    'locale_desc' => 'Persian',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'fi',
    'locale_desc' => 'Finnish',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'fj',
    'locale_desc' => 'Fijian',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'fo',
    'locale_desc' => 'Faroese',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'fr',
    'locale_desc' => 'French',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'fy',
    'locale_desc' => 'Frisian',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ga',
    'locale_desc' => 'Irish',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'gd',
    'locale_desc' => 'Scottish Gaelic',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'gl',
    'locale_desc' => 'Galician',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'gn',
    'locale_desc' => 'Guaraní',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'gu',
    'locale_desc' => 'Gujarati',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ha',
    'locale_desc' => 'Hausa',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'he',
    'locale_desc' => 'Hebrew',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'hi',
    'locale_desc' => 'Hindi',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'hm',
    'locale_desc' => 'Hmong',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'hr',
    'locale_desc' => 'Croatian',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ht',
    'locale_desc' => 'Haitian',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'hu',
    'locale_desc' => 'Hungarian',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'hy',
    'locale_desc' => 'Armenian',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ia',
    'locale_desc' => 'Interlingua',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'id',
    'locale_desc' => 'Indonesian',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ie',
    'locale_desc' => 'Interlingue',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ik',
    'locale_desc' => 'Inupiaq',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'il',
    'locale_desc' => 'Ilonggo',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'is',
    'locale_desc' => 'Icelandic',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'it',
    'locale_desc' => 'Italian',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'iu',
    'locale_desc' => 'Inuktitut',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ja',
    'locale_desc' => 'Japanese',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'jv',
    'locale_desc' => 'Javanese',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'kl',
    'locale_desc' => 'Kalaallisut',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ko',
    'locale_desc' => 'Korean',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ks',
    'locale_desc' => 'Kashmiri',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ku',
    'locale_desc' => 'Kurdish',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'la',
    'locale_desc' => 'Latin',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ln',
    'locale_desc' => 'Lingala',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'lt',
    'locale_desc' => 'Lithuanian',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'lv',
    'locale_desc' => 'Latvian',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'mg',
    'locale_desc' => 'Malagasy',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'mi',
    'locale_desc' => 'Maori',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'mk',
    'locale_desc' => 'Macedonian',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ml',
    'locale_desc' => 'Malayalam',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'mn',
    'locale_desc' => 'Mongolian',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'mo',
    'locale_desc' => 'Moldavian',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'mr',
    'locale_desc' => 'Marathi',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ms',
    'locale_desc' => 'Malay',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'mt',
    'locale_desc' => 'Maltese',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'na',
    'locale_desc' => 'Nauru',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ne',
    'locale_desc' => 'Nepali',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'nl',
    'locale_desc' => 'Dutch',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'no',
    'locale_desc' => 'Norwegian',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'oc',
    'locale_desc' => 'Occitan',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'om',
    'locale_desc' => 'Oromo',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'or',
    'locale_desc' => 'Oriya',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'pa',
    'locale_desc' => 'Punjabi',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'pl',
    'locale_desc' => 'Polish',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'pt',
    'locale_desc' => 'Portuguese',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'qu',
    'locale_desc' => 'Quechua',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'rm',
    'locale_desc' => 'Romansh',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'rn',
    'locale_desc' => 'Kirundi',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ro',
    'locale_desc' => 'Romanian',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ru',
    'locale_desc' => 'Russian',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'rw',
    'locale_desc' => 'Kinyarwanda',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'sa',
    'locale_desc' => 'Sanskrit',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'sd',
    'locale_desc' => 'Sindhi',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'sg',
    'locale_desc' => 'Sango',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'sk',
    'locale_desc' => 'Slovak',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'sl',
    'locale_desc' => 'Slovenian',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'sm',
    'locale_desc' => 'Samoan',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'sn',
    'locale_desc' => 'Shona',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'sq',
    'locale_desc' => 'Albanian',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'sr',
    'locale_desc' => 'Serbian',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ss',
    'locale_desc' => 'Swati',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'st',
    'locale_desc' => 'Southern Sotho',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'sv',
    'locale_desc' => 'Swedish',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'sw',
    'locale_desc' => 'Swahili',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'sz',
    'locale_desc' => 'Sami',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ta',
    'locale_desc' => 'Tamil',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'te',
    'locale_desc' => 'Telugu',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ti',
    'locale_desc' => 'Tigrinya',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'tk',
    'locale_desc' => 'Turkmen',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'tl',
    'locale_desc' => 'Tagalog',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'tn',
    'locale_desc' => 'Tswana',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'to',
    'locale_desc' => 'Tonga',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'tr',
    'locale_desc' => 'Turkish',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ts',
    'locale_desc' => 'Tsonga',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'tt',
    'locale_desc' => 'Tatar',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'tw',
    'locale_desc' => 'Twi',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ug',
    'locale_desc' => 'Uighur',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'uk',
    'locale_desc' => 'Ukrainian',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'ur',
    'locale_desc' => 'Urdu',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'vi',
    'locale_desc' => 'Vietnamese',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'vi-US',
    'locale_desc' => 'Vietnamese, United States',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'vo',
    'locale_desc' => 'Volapük',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'xh',
    'locale_desc' => 'Xhosa',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'yi',
    'locale_desc' => 'Yiddish',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'yo',
    'locale_desc' => 'Yoruba',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'za',
    'locale_desc' => 'Zhuang',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'zh',
    'locale_desc' => 'Chinese',
  ))
    ->execute();
  db_insert('globallink_locale')
    ->fields(array(
    'locale_code' => 'zu',
    'locale_desc' => 'Zulu',
  ))
    ->execute();
}

/**
 * Implements hook_update_N().
 *
 * Version 2.6.0 updates.
 */
function globallink_update_7260() {
  db_add_field('globallink_core', 'project_code', array(
    'description' => 'PD Project Code.',
    'type' => 'varchar',
    'not null' => TRUE,
    'default' => '',
    'length' => 255,
  ));
}
function globallink_update_7310() {
  $schema['globallink_log'] = array(
    'description' => 'GlobalLink Logs Table',
    'fields' => array(
      'lid' => array(
        'description' => 'Unique Log ID',
        'type' => 'serial',
        'unsigned' => FALSE,
        'not null' => TRUE,
      ),
      'severity' => array(
        'type' => 'varchar',
        'length' => 255,
        'not null' => TRUE,
        'default' => 'Info',
        'description' => 'The severity level of the event.',
      ),
      'type' => array(
        'type' => 'varchar',
        'length' => 255,
        'not null' => TRUE,
        'default' => '',
        'description' => 'Type of Content - Content, Blocks, Menus etc.',
      ),
      'message' => array(
        'type' => 'text',
        'not null' => TRUE,
        'size' => 'big',
        'description' => 'Text of log message.',
      ),
      'timestamp' => array(
        'description' => 'The timestamp',
        'type' => 'int',
        'length' => 14,
        'unsigned' => TRUE,
        'not null' => TRUE,
      ),
    ),
    'primary key' => array(
      'lid',
    ),
    'indexes' => array(
      'severity' => array(
        'severity',
      ),
    ),
  );
  db_create_table('globallink_log', $schema['globallink_log']);
}
function globallink_update_7670() {
  $delete_field_types = [
    'paragraphs',
    'entityreference',
    'list_integer',
    'list_text',
    'taxonomy_term_reference',
    'list_boolean',
    'boolean',
    'list_float',
  ];
  db_delete('globallink_field_config')
    ->condition('field_type', $delete_field_types, 'IN')
    ->execute();
}

Functions

Name	Description
globallink_insert_field_collections	Inserts field collections.
globallink_insert_field_collection_items	Inserts field collection items.
globallink_install	Implements hook_install().
globallink_schema	Implements hook_schema().
globallink_uninstall	Implements hook_uninstall().
globallink_update_7200	Implements hook_update_N().
globallink_update_7201	Implements hook_update_N().
globallink_update_7210	Implements hook_update_N().
globallink_update_7230	Implements hook_update_N().
globallink_update_7260	Implements hook_update_N().
globallink_update_7310
globallink_update_7670