webmaster@1: <?php
webmaster@1: // $Id: locale.install,v 1.27 2008/01/10 14:35:24 goba Exp $
webmaster@1: 
webmaster@1: /**
webmaster@1:  * Implementation of hook_install().
webmaster@1:  */
webmaster@1: function locale_install() {
webmaster@1:   // locales_source.source and locales_target.target are not used as binary
webmaster@1:   // fields; non-MySQL database servers need to ensure the field type is text
webmaster@1:   // and that LIKE produces a case-sensitive comparison.
webmaster@1: 
webmaster@1:   // Create tables.
webmaster@1:   drupal_install_schema('locale');
webmaster@1: 
webmaster@1:   db_query("INSERT INTO {languages} (language, name, native, direction, enabled, weight, javascript) VALUES ('en', 'English', 'English', '0', '1', '0', '')");
webmaster@1: }
webmaster@1: 
webmaster@1: /**
webmaster@1:  * @defgroup updates-5.x-to-6.x Locale updates from 5.x to 6.x
webmaster@1:  * @{
webmaster@1:  */
webmaster@1: 
webmaster@1: /**
webmaster@1:  * {locales_meta} table became {languages}.
webmaster@1:  */
webmaster@1: function locale_update_6000() {
webmaster@1:   $ret = array();
webmaster@1: 
webmaster@1:   $schema['languages'] = array(
webmaster@1:     'fields' => array(
webmaster@1:       'language' => array(
webmaster@1:         'type' => 'varchar',
webmaster@1:         'length' => 12,
webmaster@1:         'not null' => TRUE,
webmaster@1:         'default' => '',
webmaster@1:       ),
webmaster@1:       'name' => array(
webmaster@1:         'type' => 'varchar',
webmaster@1:         'length' => 64,
webmaster@1:         'not null' => TRUE,
webmaster@1:         'default' => '',
webmaster@1:       ),
webmaster@1:       'native' => array(
webmaster@1:         'type' => 'varchar',
webmaster@1:         'length' => 64,
webmaster@1:         'not null' => TRUE,
webmaster@1:         'default' => '',
webmaster@1:       ),
webmaster@1:       'direction' => array(
webmaster@1:         'type' => 'int',
webmaster@1:         'not null' => TRUE,
webmaster@1:         'default' => 0,
webmaster@1:       ),
webmaster@1:       'enabled' => array(
webmaster@1:         'type' => 'int',
webmaster@1:         'not null' => TRUE,
webmaster@1:         'default' => 0,
webmaster@1:       ),
webmaster@1:       'plurals' => array(
webmaster@1:         'type' => 'int',
webmaster@1:         'not null' => TRUE,
webmaster@1:         'default' => 0,
webmaster@1:       ),
webmaster@1:       'formula' => array(
webmaster@1:         'type' => 'varchar',
webmaster@1:         'length' => 128,
webmaster@1:         'not null' => TRUE,
webmaster@1:         'default' => '',
webmaster@1:       ),
webmaster@1:       'domain' => array(
webmaster@1:         'type' => 'varchar',
webmaster@1:         'length' => 128,
webmaster@1:         'not null' => TRUE,
webmaster@1:         'default' => '',
webmaster@1:       ),
webmaster@1:       'prefix' => array(
webmaster@1:         'type' => 'varchar',
webmaster@1:         'length' => 128,
webmaster@1:         'not null' => TRUE,
webmaster@1:         'default' => '',
webmaster@1:       ),
webmaster@1:       'weight' => array(
webmaster@1:         'type' => 'int',
webmaster@1:         'not null' => TRUE,
webmaster@1:         'default' => 0,
webmaster@1:       ),
webmaster@1:       'javascript' => array( //Adds a column to store the filename of the JavaScript translation file.
webmaster@1:         'type' => 'varchar',
webmaster@1:         'length' => 32,
webmaster@1:         'not null' => TRUE,
webmaster@1:         'default' => '',
webmaster@1:       ),
webmaster@1:     ),
webmaster@1:     'primary key' => array('language'),
webmaster@1:     'indexes' => array(
webmaster@1:       'list' => array('weight', 'name'),
webmaster@1:     ),
webmaster@1:   );
webmaster@1: 
webmaster@1:   db_create_table($ret, 'languages', $schema['languages']);
webmaster@1: 
webmaster@1:   // Save the languages
webmaster@1:   $ret[] = update_sql("INSERT INTO {languages} (language, name, native, direction, enabled, plurals, formula, domain, prefix, weight) SELECT locale, name, name, 0, enabled, plurals, formula, '', locale, 0 FROM {locales_meta}");
webmaster@1: 
webmaster@1:   // Save the language count in the variable table
webmaster@1:   $count = db_result(db_query('SELECT COUNT(*) FROM {languages} WHERE enabled = 1'));
webmaster@1:   variable_set('language_count', $count);
webmaster@1: 
webmaster@1:   // Save the default language in the variable table
webmaster@1:   $default = db_fetch_object(db_query('SELECT * FROM {locales_meta} WHERE isdefault = 1'));
webmaster@1:   variable_set('language_default', (object) array('language' => $default->locale, 'name' => $default->name, 'native' => '', 'direction' => 0, 'enabled' => 1, 'plurals' => $default->plurals, 'formula' => $default->formula, 'domain' => '', 'prefix' => $default->locale, 'weight' => 0));
webmaster@1: 
webmaster@1:   $ret[] = update_sql("DROP TABLE {locales_meta}");
webmaster@1:   return $ret;
webmaster@1: }
webmaster@1: 
webmaster@1: /**
webmaster@1:  * Change locale column to language. The language column is added by
webmaster@1:  * update_fix_d6_requirements() in update.php to avoid a large number
webmaster@1:  * of error messages from update.php.  All we need to do here is copy
webmaster@1:  * locale to language and then drop locale.
webmaster@1:  */
webmaster@1: function locale_update_6001() {
webmaster@1:   $ret = array();
webmaster@1:   $ret[] = update_sql('UPDATE {locales_target} SET language = locale');
webmaster@1:   db_drop_field($ret, 'locales_target', 'locale');
webmaster@1:   return $ret;
webmaster@1: }
webmaster@1: 
webmaster@1: /**
webmaster@1:  * Remove empty translations, we don't need these anymore.
webmaster@1:  */
webmaster@1: function locale_update_6002() {
webmaster@1:   $ret = array();
webmaster@1:   $ret[] = update_sql("DELETE FROM {locales_target} WHERE translation = ''");
webmaster@1:   return $ret;
webmaster@1: }
webmaster@1: 
webmaster@1: /**
webmaster@1:  * Prune strings with no translations (will be automatically re-registered if still in use)
webmaster@1:  */
webmaster@1: function locale_update_6003() {
webmaster@1:   $ret = array();
webmaster@1:   $ret[] = update_sql("DELETE FROM {locales_source} WHERE lid NOT IN (SELECT lid FROM {locales_target})");
webmaster@1:   return $ret;
webmaster@1: }
webmaster@1: 
webmaster@1: /**
webmaster@1:  * Fix remaining inconsistent indexes.
webmaster@1:  */
webmaster@1: function locale_update_6004() {
webmaster@1:   $ret = array();
webmaster@1:   db_add_index($ret, 'locales_target', 'language', array('language'));
webmaster@1: 
webmaster@1:   switch ($GLOBALS['db_type']) {
webmaster@1:     case 'pgsql':
webmaster@1:       db_drop_index($ret, 'locales_source', 'source');
webmaster@1:       db_add_index($ret, 'locales_source', 'source', array(array('source', 30)));
webmaster@1:       break;
webmaster@1:   }
webmaster@1: 
webmaster@1:   return $ret;
webmaster@1: }
webmaster@1: 
webmaster@1: /**
webmaster@1:  * Change language setting variable of content types.
webmaster@1:  * 
webmaster@1:  * Use language_content_type_<content_type> instead of language_<content_type>
webmaster@1:  * so content types such as 'default', 'count' or 'negotiation' will not
webmaster@1:  * interfere with language variables.
webmaster@1:  */
webmaster@1: function locale_update_6005() {
webmaster@1:   foreach (node_get_types() as $type => $content_type) {
webmaster@1:     // Default to NULL, so we can skip dealing with non-existent settings.
webmaster@1:     $setting = variable_get('language_'. $type, NULL);
webmaster@1:     if ($type == 'default' && is_numeric($setting)) {
webmaster@1:       // language_default was overwritten with the content type setting,
webmaster@1:       // so reset the default language and save the content type setting.
webmaster@1:       variable_set('language_content_type_default', $setting);
webmaster@1:       variable_del('language_default');
webmaster@1:       drupal_set_message('The default language setting has been reset to its default value. Check the '. l('language configuration page', 'admin/settings/language') .' to configure it correctly.');
webmaster@1:     }
webmaster@1:     elseif ($type == 'negotiation') {
webmaster@1:       // language_content_type_negotiation is an integer either if it is
webmaster@1:       // the negotiation setting or the content type setting.
webmaster@1:       // The language_negotiation setting is not reset, but
webmaster@1:       // the user is alerted that this setting possibly was overwritten
webmaster@1:       variable_set('language_content_type_negotiation', $setting);
webmaster@1:       drupal_set_message('The language negotiation setting was possibly overwritten by a content type of the same name. Check the '. l('language configuration page', 'admin/settings/language/configure') .' and the '. l('<em>'. $content_type->name ."</em> content type's multilingual support settings", 'admin/content/types/negotiation', array('html' => TRUE)) .' to configure them correctly.');
webmaster@1:     }
webmaster@1:     elseif (!is_null($setting)) {
webmaster@1:       // Change the language setting variable for any other content type.
webmaster@1:       // Do not worry about language_count, it will be updated below.
webmaster@1:       variable_set('language_content_type_'. $type, $setting);
webmaster@1:       variable_del('language_'. $type);
webmaster@1:     }
webmaster@1:   }
webmaster@1:   // Update language count variable that might be overwritten.
webmaster@1:   $count = db_result(db_query('SELECT COUNT(*) FROM {languages} WHERE enabled = 1'));
webmaster@1:   variable_set('language_count', $count);
webmaster@1:   return array();
webmaster@1: }
webmaster@1: 
webmaster@1: /**
webmaster@1:  * @} End of "defgroup updates-5.x-to-6.x"
webmaster@1:  */
webmaster@1: 
webmaster@1: /**
webmaster@1:  * Implementation of hook_uninstall().
webmaster@1:  */
webmaster@1: function locale_uninstall() {
webmaster@1:   // Delete all JavaScript translation files
webmaster@1:   $files = db_query('SELECT javascript FROM {languages}');
webmaster@1:   while ($file = db_fetch_object($files)) {
webmaster@1:     if (!empty($file)) {
webmaster@1:       file_delete(file_create_path($file->javascript));
webmaster@1:     }
webmaster@1:   }
webmaster@1: 
webmaster@1:   // Remove tables.
webmaster@1:   drupal_uninstall_schema('locale');
webmaster@1: }
webmaster@1: 
webmaster@1: /**
webmaster@1:  * Implementation of hook_schema().
webmaster@1:  */
webmaster@1: function locale_schema() {
webmaster@1:   $schema['languages'] = array(
webmaster@1:     'description' => t('List of all available languages in the system.'),
webmaster@1:     'fields' => array(
webmaster@1:       'language' => array(
webmaster@1:         'type' => 'varchar',
webmaster@1:         'length' => 12,
webmaster@1:         'not null' => TRUE,
webmaster@1:         'default' => '',
webmaster@1:         'description' => t("Language code, e.g. 'de' or 'en-US'."),
webmaster@1:       ),
webmaster@1:       'name' => array(
webmaster@1:         'type' => 'varchar',
webmaster@1:         'length' => 64,
webmaster@1:         'not null' => TRUE,
webmaster@1:         'default' => '',
webmaster@1:         'description' => t('Language name in English.'),
webmaster@1:       ),
webmaster@1:       'native' => array(
webmaster@1:         'type' => 'varchar',
webmaster@1:         'length' => 64,
webmaster@1:         'not null' => TRUE,
webmaster@1:         'default' => '',
webmaster@1:         'description' => t('Native language name.'),
webmaster@1:       ),
webmaster@1:       'direction' => array(
webmaster@1:         'type' => 'int',
webmaster@1:         'not null' => TRUE,
webmaster@1:         'default' => 0,
webmaster@1:         'description' => t('Direction of language (Left-to-Right = 0, Right-to-Left = 1).'),
webmaster@1:       ),
webmaster@1:       'enabled' => array(
webmaster@1:         'type' => 'int',
webmaster@1:         'not null' => TRUE,
webmaster@1:         'default' => 0,
webmaster@1:         'description' => t('Enabled flag (1 = Enabled, 0 = Disabled).'),
webmaster@1:       ),
webmaster@1:       'plurals' => array(
webmaster@1:         'type' => 'int',
webmaster@1:         'not null' => TRUE,
webmaster@1:         'default' => 0,
webmaster@1:         'description' => t('Number of plural indexes in this language.'),
webmaster@1:       ),
webmaster@1:       'formula' => array(
webmaster@1:         'type' => 'varchar',
webmaster@1:         'length' => 128,
webmaster@1:         'not null' => TRUE,
webmaster@1:         'default' => '',
webmaster@1:         'description' => t('Plural formula in PHP code to evaluate to get plural indexes.'),
webmaster@1:       ),
webmaster@1:       'domain' => array(
webmaster@1:         'type' => 'varchar',
webmaster@1:         'length' => 128,
webmaster@1:         'not null' => TRUE,
webmaster@1:         'default' => '',
webmaster@1:         'description' => t('Domain to use for this language.'),
webmaster@1:       ),
webmaster@1:       'prefix' => array(
webmaster@1:         'type' => 'varchar',
webmaster@1:         'length' => 128,
webmaster@1:         'not null' => TRUE,
webmaster@1:         'default' => '',
webmaster@1:         'description' => t('Path prefix to use for this language.'),
webmaster@1:       ),
webmaster@1:       'weight' => array(
webmaster@1:         'type' => 'int',
webmaster@1:         'not null' => TRUE,
webmaster@1:         'default' => 0,
webmaster@1:         'description' => t('Weight, used in lists of languages.'),
webmaster@1:       ),
webmaster@1:       'javascript' => array(
webmaster@1:         'type' => 'varchar',
webmaster@1:         'length' => 32,
webmaster@1:         'not null' => TRUE,
webmaster@1:         'default' => '',
webmaster@1:         'description' => t('Location of JavaScript translation file.'),
webmaster@1:       ),
webmaster@1:     ),
webmaster@1:     'primary key' => array('language'),
webmaster@1:     'indexes' => array(
webmaster@1:       'list' => array('weight', 'name'),
webmaster@1:     ),
webmaster@1:   );
webmaster@1: 
webmaster@1:   $schema['locales_source'] = array(
webmaster@1:     'description' => t('List of English source strings.'),
webmaster@1:     'fields' => array(
webmaster@1:       'lid' => array(
webmaster@1:         'type' => 'serial',
webmaster@1:         'not null' => TRUE,
webmaster@1:         'description' => t('Unique identifier of this string.'),
webmaster@1:       ),
webmaster@1:       'location' => array(
webmaster@1:         'type' => 'varchar',
webmaster@1:         'length' => 255,
webmaster@1:         'not null' => TRUE,
webmaster@1:         'default' => '',
webmaster@1:         'description' => t('Drupal path in case of online discovered translations or file path in case of imported strings.'),
webmaster@1:       ),
webmaster@1:       'textgroup' => array(
webmaster@1:         'type' => 'varchar',
webmaster@1:         'length' => 255,
webmaster@1:         'not null' => TRUE,
webmaster@1:         'default' => 'default',
webmaster@1:         'description' => t('A module defined group of translations, see hook_locale().'),
webmaster@1:       ),
webmaster@1:       'source' => array(
webmaster@1:         'type' => 'text',
webmaster@1:         'mysql_type' => 'blob',
webmaster@1:         'not null' => TRUE,
webmaster@1:         'description' => t('The original string in English.'),
webmaster@1:       ),
webmaster@1:       'version' => array(
webmaster@1:         'type' => 'varchar',
webmaster@1:         'length' => 20,
webmaster@1:         'not null' => TRUE,
webmaster@1:         'default' => 'none',
webmaster@1:         'description' => t('Version of Drupal, where the string was last used (for locales optimization).'),
webmaster@1:       ),
webmaster@1:     ),
webmaster@1:     'primary key' => array('lid'),
webmaster@1:     'indexes' => array(
webmaster@1:       'source' => array(array('source', 30)),
webmaster@1:     ),
webmaster@1:   );
webmaster@1: 
webmaster@1:   $schema['locales_target'] = array(
webmaster@1:     'description' => t('Stores translated versions of strings.'),
webmaster@1:     'fields' => array(
webmaster@1:       'lid' => array(
webmaster@1:         'type' => 'int',
webmaster@1:         'not null' => TRUE,
webmaster@1:         'default' => 0,
webmaster@1:         'description' => t('Source string ID. References {locales_source}.lid.'),
webmaster@1:       ),
webmaster@1:       'translation' => array(
webmaster@1:         'type' => 'text',
webmaster@1:         'mysql_type' => 'blob',
webmaster@1:         'not null' => TRUE,
webmaster@1:         'description' => t('Translation string value in this language.'),
webmaster@1:       ),
webmaster@1:       'language' => array(
webmaster@1:         'type' => 'varchar',
webmaster@1:         'length' => 12,
webmaster@1:         'not null' => TRUE,
webmaster@1:         'default' => '',
webmaster@1:         'description' => t('Language code. References {languages}.language.'),
webmaster@1:       ),
webmaster@1:       'plid' => array(
webmaster@1:         'type' => 'int',
webmaster@1:         'not null' => TRUE, // This should be NULL for no referenced string, not zero.
webmaster@1:         'default' => 0,
webmaster@1:         'description' => t('Parent lid (lid of the previous string in the plural chain) in case of plural strings. References {locales_source}.lid.'),
webmaster@1:       ),
webmaster@1:       'plural' => array(
webmaster@1:         'type' => 'int',
webmaster@1:         'not null' => TRUE,
webmaster@1:         'default' => 0,
webmaster@1:         'description' => t('Plural index number in case of plural strings.'),
webmaster@1:       ),
webmaster@1:     ),
webmaster@1:     'primary key' => array('language', 'lid', 'plural'),
webmaster@1:     'indexes' => array(
webmaster@1:       'lid'      => array('lid'),
webmaster@1:       'plid'     => array('plid'),
webmaster@1:       'plural'   => array('plural'),
webmaster@1:     ),
webmaster@1:   );
webmaster@1: 
webmaster@1:   return $schema;
webmaster@1: }
webmaster@1: