drupal-6.locale.database.php

<?php


/**
 * Database additions for locale tests.
 */
db_create_table('languages', array(
    'fields' => array(
        'language' => array(
            'type' => 'varchar',
            'length' => 12,
            'not null' => TRUE,
            'default' => '',
        ),
        'name' => array(
            'type' => 'varchar',
            'length' => 64,
            'not null' => TRUE,
            'default' => '',
        ),
        'native' => array(
            'type' => 'varchar',
            'length' => 64,
            'not null' => TRUE,
            'default' => '',
        ),
        'direction' => array(
            'type' => 'int',
            'not null' => TRUE,
            'default' => 0,
        ),
        'enabled' => array(
            'type' => 'int',
            'not null' => TRUE,
            'default' => 0,
        ),
        'plurals' => array(
            'type' => 'int',
            'not null' => TRUE,
            'default' => 0,
        ),
        'formula' => array(
            'type' => 'varchar',
            'length' => 128,
            'not null' => TRUE,
            'default' => '',
        ),
        'domain' => array(
            'type' => 'varchar',
            'length' => 128,
            'not null' => TRUE,
            'default' => '',
        ),
        'prefix' => array(
            'type' => 'varchar',
            'length' => 128,
            'not null' => TRUE,
            'default' => '',
        ),
        'weight' => array(
            'type' => 'int',
            'not null' => TRUE,
            'default' => 0,
        ),
        'javascript' => array(
            'type' => 'varchar',
            'length' => 32,
            'not null' => TRUE,
            'default' => '',
        ),
    ),
    'primary key' => array(
        'language',
    ),
    'indexes' => array(
        'list' => array(
            'weight',
            'name',
        ),
    ),
    'module' => 'locale',
    'name' => 'languages',
));
db_insert('languages')->fields(array(
    'language',
    'name',
    'native',
    'direction',
    'enabled',
    'plurals',
    'formula',
    'domain',
    'prefix',
    'weight',
    'javascript',
))
    ->values(array(
    'language' => 'en',
    'name' => 'English',
    'native' => 'English',
    'direction' => '0',
    'enabled' => '1',
    'plurals' => '0',
    'formula' => '',
    'domain' => 'http://en.example.com',
    'prefix' => 'en',
    'weight' => '0',
    'javascript' => '',
))
    ->values(array(
    'language' => 'fr',
    'name' => 'French',
    'native' => 'Français',
    'direction' => '0',
    'enabled' => '1',
    'plurals' => '2',
    'formula' => '($n>1)',
    'domain' => '',
    'prefix' => 'fr',
    'weight' => '-3',
    'javascript' => '51e92dcfe1491f4595b9df7f3b287753',
))
    ->execute();
db_create_table('locales_source', array(
    'fields' => array(
        'lid' => array(
            'type' => 'serial',
            'not null' => TRUE,
        ),
        'location' => array(
            'type' => 'varchar',
            'length' => 255,
            'not null' => TRUE,
            'default' => '',
        ),
        'textgroup' => array(
            'type' => 'varchar',
            'length' => 255,
            'not null' => TRUE,
            'default' => 'default',
        ),
        'source' => array(
            'type' => 'text',
            'mysql_type' => 'blob',
            'not null' => TRUE,
        ),
        'version' => array(
            'type' => 'varchar',
            'length' => 20,
            'not null' => TRUE,
            'default' => 'none',
        ),
    ),
    'primary key' => array(
        'lid',
    ),
    'indexes' => array(
        'source' => array(
            array(
                'source',
                30,
            ),
        ),
    ),
    'module' => 'locale',
    'name' => 'locales_source',
));
db_create_table('locales_target', array(
    'fields' => array(
        'lid' => array(
            'type' => 'int',
            'not null' => TRUE,
            'default' => 0,
        ),
        'translation' => array(
            'type' => 'text',
            'mysql_type' => 'blob',
            'not null' => TRUE,
        ),
        'language' => array(
            'type' => 'varchar',
            'length' => 12,
            'not null' => TRUE,
            'default' => '',
        ),
        'plid' => array(
            'type' => 'int',
            'not null' => TRUE,
            'default' => 0,
        ),
        'plural' => array(
            'type' => 'int',
            'not null' => TRUE,
            'default' => 0,
        ),
    ),
    'primary key' => array(
        'language',
        'lid',
        'plural',
    ),
    'indexes' => array(
        'lid' => array(
            'lid',
        ),
        'plid' => array(
            'plid',
        ),
        'plural' => array(
            'plural',
        ),
    ),
    'module' => 'locale',
    'name' => 'locales_target',
));
// Enable the locale module.
db_update('system')->fields(array(
    'status' => 1,
    'schema_version' => '6006',
))
    ->condition('type', 'module')
    ->condition('name', 'locale')
    ->execute();
// Set the default language.
db_insert('variable')->fields(array(
    'name',
    'value',
))
    ->values(array(
    'name' => 'language_default',
    'value' => 'O:8:"stdClass":11:{s:8:"language";s:2:"fr";s:4:"name";s:6:"French";s:6:"native";s:9:"Français";s:9:"direction";s:1:"0";s:7:"enabled";i:1;s:7:"plurals";s:1:"2";s:7:"formula";s:6:"($n>1)";s:6:"domain";s:0:"";s:6:"prefix";s:0:"";s:6:"weight";s:2:"-3";s:10:"javascript";s:32:"51e92dcfe1491f4595b9df7f3b287753";}',
))
    ->values(array(
    'name' => 'language_count',
    'value' => 'i:2;',
))
    ->values(array(
    'name' => 'language_negotiation',
    'value' => 'i:0;',
))
    ->execute();
// Add the language switcher block in the left region.
db_insert('blocks')->fields(array(
    'module',
    'delta',
    'theme',
    'status',
    'weight',
    'region',
    'custom',
    'throttle',
    'visibility',
    'pages',
    'title',
    'cache',
))
    ->values(array(
    'module' => 'locale',
    'delta' => '0',
    'theme' => 'garland',
    'status' => '1',
    'weight' => '0',
    'region' => 'left',
    'custom' => '0',
    'throttle' => '0',
    'visibility' => '0',
    'pages' => '',
    'title' => '',
    'cache' => '-1',
))
    ->execute();