You are here

Home » API reference » Notifications 6.3 » notifications.install

function notifications_update_2 in Notifications 6.3

Same name and namespace in other branches
  1. 5 notifications.install \notifications_update_2()
  2. 6.4 notifications.install \notifications_update_2()
  3. 6 notifications.install \notifications_update_2()
  4. 6.2 notifications.install \notifications_update_2()

Update:

  • Remove unused table and fields
  • Add conditions field for mysql4 compatibility
  • Updated variable name

File

./notifications.install, line 254

Code

function notifications_update_2() {
  $ret = array();
  $ret[] = update_sql("DROP TABLE {notifications_user}");
  $ret[] = update_sql("ALTER TABLE {notifications_queue} DROP COLUMN `name`;");
  $ret[] = update_sql("ALTER TABLE {notifications_queue} DROP COLUMN `field`;");
  $ret[] = update_sql("ALTER TABLE {notifications_queue} DROP COLUMN `value`;");
  $ret[] = update_sql("ALTER TABLE {notifications_queue} DROP COLUMN `author`;");
  $ret[] = update_sql("ALTER TABLE {notifications_queue} ADD COLUMN `conditions` INTEGER UNSIGNED NOT NULL DEFAULT 0 AFTER `cron`");
  variable_set('notifications_default_auto', variable_get('notifications_autoset', 0));
  variable_del('notifications_autoset');
  return $ret;
}