function legal_update_6003 in Legal 6.8
Add version, revision, and language fields.
File
- ./
legal.install, line 131 - Installation and update functions for the Legal module.
Code
function legal_update_6003() {
$ret = array();
db_add_field($ret, 'legal_conditions', 'version', array(
'type' => 'int',
'unsigned' => TRUE,
'not null' => TRUE,
'default' => 0,
));
db_add_field($ret, 'legal_conditions', 'revision', array(
'type' => 'int',
'unsigned' => TRUE,
'not null' => TRUE,
'default' => 0,
));
db_add_field($ret, 'legal_conditions', 'language', array(
'type' => 'varchar',
'length' => '12',
'not null' => TRUE,
'default' => '',
));
db_add_field($ret, 'legal_accepted', 'version', array(
'type' => 'int',
'unsigned' => TRUE,
'not null' => TRUE,
'default' => 0,
));
db_add_field($ret, 'legal_accepted', 'revision', array(
'type' => 'int',
'unsigned' => TRUE,
'not null' => TRUE,
'default' => 0,
));
db_add_field($ret, 'legal_accepted', 'language', array(
'type' => 'varchar',
'length' => '12',
'not null' => TRUE,
'default' => '',
));
if (module_exists('locale')) {
$language = language_default('language');
}
else {
$language = 'en';
}
$ret[] = update_sql('UPDATE {legal_conditions} SET version = tc_id');
$ret[] = update_sql('UPDATE {legal_conditions} SET revision = 1');
$ret[] = update_sql("UPDATE {legal_conditions} SET language = '{$language}'");
$ret[] = update_sql('UPDATE {legal_accepted} SET version = tc_id');
$ret[] = update_sql('UPDATE {legal_accepted} SET revision = 1');
$ret[] = update_sql("UPDATE {legal_accepted} SET language = '{$language}'");
db_drop_field($ret, 'legal_accepted', 'tc_id');
return $ret;
}