Remove t() from all schema descriptions

It should be clean.

replace also multiline (in simpletest.install) :

        'description' => t('Primary Key: Unique simpletest ID used to group test results together. Each time a set of tests
                            are run a new test ID is used.'),

Errors in color.install - where t() shouldn't be removed , this is for the requirements, nothing todo with schema iirc

undo color.install.

Undo two wrong replacements in book.install and forum.install.

while we're at it, php install and color install use t() but they should rather use $t = get_t() like other modules do I think. Can someone else confirm that ?

Reroll.

Looks good. Committed to CVS HEAD. We should document this on the module upgrade page. After it has been documented, please mark this 'fixed'. Thanks!

I haven't permission for edit page http://drupal.org/node/224333.

1. Schema descriptions are no longer translated

Schema descriptions are no longer translated

(Issue) To reduce the strings to translate, descriptions of the schema database (tables and fields) in module.install no longer need to be translated.

6.x:

function forum_schema() {
  $schema['forum'] = array(
    'description' => t('Stores the relationship of nodes to forum terms.'),
    'fields' => array(
      'nid' => array(
        'description' => t('The {node}.nid of the node.'),
      ),
    ),
  );
  return $schema;
}

7.x:

function forum_schema() {
  $schema['forum'] = array(
    'description' => 'Stores the relationship of nodes to forum terms.',
    'fields' => array(
      'nid' => array(
        'description' => 'The {node}.nid of the node.',
      ),
    ),
  );
  return $schema;
}

Thx.

block.install still needs some love - Let's look at others too. Noticed this thanks to #337794: PostgreSQL surge #1: make simpletest works again

You're right.

Actually the schema descriptions are all translated for D6, and also translated for contributed modules (which are translated already).

I agree, that translating these strings is meaningless. My question (1) is can I file issues for D6 contributed modules to remove t() from schema descriptions? That would make module translation much more easier, and if we translate D6 modules, then removing this option in D7 just does not seem right.

And also (2) can I file an issue for potx module, to not extract scheme descriptions from D6 and D6 modules?

answer on (2) #338409: Do not extract schema descriptions

so, it seems like we will have to backport this patch to D6 (read the potx issue)

I can only guess how many hours I've spend on the German translation of schema translation in D& and now all this translations are going to be lost.

I've translated most of the Hungarian schema strings just to see that the translation is 100%, not to say that it will be ever read, or that it would not go against storing the descriptions in the database as table comments. I am in support of a backport.

Summarizing reasons to remove t() for hass, since he does not yet get it (see http://drupal.org/node/338409#comment-1131476):

- the functionality behind t() is not available when the schema hooks are invoked in the installer, up until locale module is enabled, so the t() calls always return the same string in installation time
- this text is documenting the code, and therefore is similar to code comments, which are not translated either
- this is technical text, and many of the translation teams such as the Hungarian team translates it just to see 100% completed translations, not because it will ever show on the interface
- if t() is not used on these strings, Drupal can actually add the descriptions to the tables and fields themselves in the database (for those backends where this is supported, for example MySQL - http://dev.mysql.com/doc/refman/5.1/en/create-table.html), so more powerful database tools can operate with those, show and help database admins to work with the tables

You missed to say that Schema module shows the translated strings in UI.

It does not need to.

Schema field descriptions possible used in views, isn't it?
If no, suppose, t() for schema in 6x is useless.

Another opinions to remove t()
- less runtime memory usage
- faster serialize|unserialize for locale cache

because most of descriptions less then 75 chars so they stored in locale cache but useless in production env

Every *.install in modules checked and cleared hook_schema t()

Chasing 6-dev

Code applies cleanly, Codewise also good and tested on dev machine with all core modules enabled.

Committed to Drupal 6, thanks!

Also updated docs at http://drupal.org/node/322731 to say:

One notable case in installer code is hook_schema(), which runs at install time, but Drupal core (up until Drupal 6.9) and contributed modules alike used t() for descriptions of tables and fields. The reason for that is that the Drupal installer itself does not use these strings, so it is not bothered with it not being translated while used in the installer. The contributed schema module uses these strings to help you understand the database structure. Drupal 7 changed this practice to not use t() at all in schema descriptions for various reasons (see http://drupal.org/node/332123 for more information). Therefore to save translators from pouring work into something they will entirely loose later (and help website performance as well as other good reasons), Drupal 6.9 does not use t() on these strings anymore. You should include schema strings as verbatim strings without wrapping them in localization code.

/**
 * Implementation of hook_schema() to demonstrate that t() is not used.
 */
function example_schema() {
  $schema['example_table'] = array(
    'description' => 'This table stores example stuff.',
    'fields' => array(
      'eid' => array(
        'description' => 'Example identifier.',
        'type' => 'serial',
        'not null' => TRUE,
      ),
      'value' => array(
        'description' => 'Value of the example. Can be a string or a serialized array.',
        'type' => 'text',
        'not null' => TRUE
      )
    ),
    'primary key' => array('eid'),
  );
  return $schema;
}

Yay! This was really frustrating to translate.

We need to update more documentation on this. All the examples of hook_schema still include this code.

http://api.drupal.org/api/function/hook_schema
http://drupal.org/node/146843

I changed http://drupal.org/node/146862 - didn't find any other examples of descriptions in that section of the handbook.
http://api.drupal.org/api/function/hook_schema is still wrong, including the D7 version

Could we get this committed to HEAD? Then we can do the same to the D6 version (which is still in contrib, so I can get it).

Fixed in D6 http://drupal.org/cvs?commit=214280

Thanks webchick!