vpx_beheer_update_59

Versions

mediamosa-174

vpx_beheer_update_59()

Code

vpx_beheer/vpx_beheer.install, line 948

<?php
function vpx_beheer_update_59() {
  $ret = array();

  db_set_active('data');

  $ret[] = update_sql("
    CREATE TABLE IF NOT EXISTS asset_delete (
      asset_id varchar(32) character set latin1 collate latin1_general_cs NOT NULL,
      app_id int(10) unsigned default NULL,
      videotimestampmodified timestamp NULL default NULL,
      PRIMARY KEY  (asset_id),
      KEY idx_asset_app (app_id),
      KEY idx_asset_app_videotimestampm (app_id,videotimestampmodified)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT
  ");

  db_set_active();

  return $ret;
}
?>