set sql_log_bin=0;
set autocommit=0;

START TRANSACTION;

USE kamailio;

-- table: active_watchers
ALTER TABLE active_watchers
  DROP COLUMN flags;
ALTER TABLE active_watchers
  DROP COLUMN user_agent;
REPLACE INTO version (`table_name`, `table_version`) VALUES ('active_watchers','11');

-- table: trusted
ALTER TABLE trusted
  DROP COLUMN priority;
ALTER TABLE trusted
  DROP COLUMN ruri_pattern;
REPLACE INTO version (`table_name`, `table_version`) VALUES ('trusted','5');

COMMIT;
