| 1 |
<?php
|
| 2 |
// $Id: i18n.install,v 1.14 2008/02/17 13:13:17 jareyero Exp $
|
| 3 |
/**
|
| 4 |
* Implementation of hook_schema().
|
| 5 |
*/
|
| 6 |
function i18n_schema() {
|
| 7 |
$schema['i18n_variable'] = array(
|
| 8 |
'description' => t('Multilingual variables.'),
|
| 9 |
'fields' => array(
|
| 10 |
'name' => array(
|
| 11 |
'description' => t('The name of the variable.'),
|
| 12 |
'type' => 'varchar',
|
| 13 |
'length' => 128,
|
| 14 |
'not null' => TRUE,
|
| 15 |
'default' => ''),
|
| 16 |
'language' => array(
|
| 17 |
'description' => t('The language of the variable.'),
|
| 18 |
'type' => 'varchar',
|
| 19 |
'length' => 12,
|
| 20 |
'not null' => TRUE,
|
| 21 |
'default' => ''),
|
| 22 |
'value' => array(
|
| 23 |
'description' => t('The value of the variable.'),
|
| 24 |
'type' => 'text',
|
| 25 |
'not null' => TRUE,
|
| 26 |
'size' => 'big'),
|
| 27 |
),
|
| 28 |
'primary key' => array('name', 'language'),
|
| 29 |
);
|
| 30 |
return $schema;
|
| 31 |
}
|
| 32 |
|
| 33 |
/**
|
| 34 |
* Set language field in its own table
|
| 35 |
* Do not drop node.language now, just in case
|
| 36 |
* TO-DO: Drop old tables, fields
|
| 37 |
*/
|
| 38 |
function i18n_install() {
|
| 39 |
// Create database tables
|
| 40 |
drupal_install_schema('i18n');
|
| 41 |
// Set module weight for it to run after core modules
|
| 42 |
db_query("UPDATE {system} SET weight = 10 WHERE name = 'i18n' AND type = 'module'");
|
| 43 |
}
|
| 44 |
|
| 45 |
/**
|
| 46 |
* Drupal 4.7 updates
|
| 47 |
**/
|
| 48 |
function i18n_update_1() {
|
| 49 |
$items = array();
|
| 50 |
$items[] = update_sql("ALTER TABLE {i18n_node} ADD language VARCHAR(12)");
|
| 51 |
$items[] = update_sql("UPDATE {i18n_node} i INNER JOIN {node} n ON i.nid = n.nid SET i.language = n.language ");
|
| 52 |
$items[] = update_sql("INSERT INTO {i18n_node}(nid,language) SELECT n.nid, n.language FROM {node} n LEFT JOIN {i18n_node} i ON n.nid = i.nid WHERE n.language != '' AND i.nid IS NULL");
|
| 53 |
return $items;
|
| 54 |
}
|
| 55 |
|
| 56 |
function i18n_update_2() {
|
| 57 |
$items = array();
|
| 58 |
$items[] = update_sql("ALTER TABLE {term_data} ADD trid int(10) unsigned NOT NULL default '0'");
|
| 59 |
$items[] = update_sql("UPDATE {term_data} t INNER JOIN {i18n_taxonomy_term} i ON i.tid = t.tid SET t.trid = i.trid");
|
| 60 |
return $items;
|
| 61 |
}
|
| 62 |
|
| 63 |
function i18n_update_3(){
|
| 64 |
$items = array();
|
| 65 |
$items[] = update_sql("ALTER TABLE {i18n_node} MODIFY COLUMN trid INTEGER UNSIGNED NOT NULL default '0', DROP PRIMARY KEY, ADD PRIMARY KEY(nid)");
|
| 66 |
$items[] = update_sql("ALTER TABLE {term_data} MODIFY COLUMN trid INTEGER UNSIGNED NOT NULL default '0', DROP PRIMARY KEY, ADD PRIMARY KEY(tid)");
|
| 67 |
return $items;
|
| 68 |
}
|
| 69 |
|
| 70 |
function i18n_update_4(){
|
| 71 |
$items[] = update_sql("CREATE TABLE {i18n_variable} (
|
| 72 |
name varchar(48) NOT NULL default '',
|
| 73 |
language varchar(12) NOT NULL default '',
|
| 74 |
value longtext NOT NULL,
|
| 75 |
PRIMARY KEY (name, language)
|
| 76 |
)");
|
| 77 |
return $items;
|
| 78 |
}
|
| 79 |
|
| 80 |
/**
|
| 81 |
* Drupal 5 updates
|
| 82 |
*/
|
| 83 |
// Multilingual menu items
|
| 84 |
function i18n_update_5(){
|
| 85 |
$items[] = update_sql("ALTER TABLE {menu} ADD language VARCHAR(12) NOT NULL default ''");
|
| 86 |
return $items;
|
| 87 |
}
|
| 88 |
// Module weithgts
|
| 89 |
function i18n_update_6(){
|
| 90 |
// Old module weights. Caused some trouble with other modules.
|
| 91 |
}
|
| 92 |
// Redefinition of module weights
|
| 93 |
function i18n_update_7(){
|
| 94 |
$items[] = update_sql("UPDATE {system} SET weight = -10 WHERE name = 'i18n' AND type = 'module'");
|
| 95 |
$items[] = update_sql("UPDATE {system} SET weight = 10 WHERE name = 'translation' AND type = 'module'");
|
| 96 |
return $items;
|
| 97 |
}
|
| 98 |
// Update tables to utf8
|
| 99 |
function i18n_update_8(){
|
| 100 |
return _system_update_utf8(array('i18n_variable'));
|
| 101 |
}
|
| 102 |
|
| 103 |
/**
|
| 104 |
* Drupal 6 updates
|
| 105 |
*/
|
| 106 |
function i18n_update_9() {
|
| 107 |
// Update content type settings
|
| 108 |
foreach (array_keys(node_get_types()) as $type) {
|
| 109 |
if (variable_get('i18n_node_'.$type, 0)) {
|
| 110 |
variable_set('language_content_type_'.$type, TRANSLATION_ENABLED);
|
| 111 |
}
|
| 112 |
}
|
| 113 |
// General language settings
|
| 114 |
if (variable_get('i18n_browser', 0)) {
|
| 115 |
variable_set('language_negotiation', LANGUAGE_NEGOTIATION_PATH);
|
| 116 |
} else {
|
| 117 |
variable_set('language_negotiation', LANGUAGE_NEGOTIATION_PATH_DEFAULT);
|
| 118 |
}
|
| 119 |
// Set module weight for it to run after core modules
|
| 120 |
$items[] = update_sql("UPDATE {system} SET weight = 10 WHERE name = 'i18n' AND type = 'module'");
|
| 121 |
// Move node language and trid into node table
|
| 122 |
$items[] = update_sql("UPDATE {node} n INNER JOIN {i18n_node} i ON n.nid = i.nid SET n.language = i.language, n.tnid = i.trid");
|
| 123 |
|
| 124 |
return $items;
|
| 125 |
}
|
| 126 |
|
| 127 |
/**
|
| 128 |
* Drupal 6 clean up. To uncomment after making sure all previous updates work
|
| 129 |
*/
|
| 130 |
/*
|
| 131 |
function i18n_update_10() {
|
| 132 |
// Drop old tables
|
| 133 |
$items[] = update_sql("DROP TABLE {i18n_node}");
|
| 134 |
|
| 135 |
// Delete variables. Most settings will be now handled by Drupal core.
|
| 136 |
variable_del('i18n_allow');
|
| 137 |
variable_del('i18n_browser');
|
| 138 |
variable_del('i18n_content');
|
| 139 |
variable_del('i18n_keep');
|
| 140 |
variable_del('i18n_multi');
|
| 141 |
variable_del('i18n_interface');
|
| 142 |
variable_del('i18n_default');
|
| 143 |
variable_del('i18n_supported_langs');
|
| 144 |
variable_del('i18n_translation_links');
|
| 145 |
variable_del('i18n_translation_node_links');
|
| 146 |
return $items;
|
| 147 |
}
|
| 148 |
*/
|
Parent Directory
| 
Revision Log
| 
Revision Graph