vpx_beheer_update_22

Versions

mediamosa-174

vpx_beheer_update_22()

Code

vpx_beheer/vpx_beheer.install, line 154

<?php
function vpx_beheer_update_22() { // 21 jul 2008
  // Remove this restcall, not allowed anymore...
  $ret[] = update_sql("DELETE FROM {madrest} WHERE function_call = 'client_applications_update_used_quota'");

  // Delete obsolete table....
  db_set_active('data');
  $ret[] = update_sql("DROP TABLE realmdomain_group");
  $ret[] = update_sql("ALTER TABLE {job} CHANGE COLUMN owner `owner` varchar(255) character set latin1 collate latin1_general_cs NOT NULL");

  // Add the new create_still column to job table
  $ret[] = update_sql("ALTER TABLE {upload_job} ADD COLUMN create_still ENUM('FALSE', 'TRUE') DEFAULT 'FALSE'");
  $ret[] = update_sql("ALTER TABLE {job} ADD COLUMN create_still ENUM('FALSE', 'TRUE') DEFAULT 'FALSE'");

  $ret[] = update_sql("ALTER TABLE {asset} ADD COLUMN is_unappropiate ENUM('FALSE', 'TRUE') DEFAULT 'FALSE'");

  db_set_active();

  return $ret;
}
?>