You are here

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;
}