-- ------------------------------------------------
-- APM-246 Column DB
--  - remove UM tables from row DB
--  - refactor reports -> tasks
-- Created 20120502
-- ------------------------------------------------

DROP VIEW `prd_trace_view`;

DROP TABLE `um_user_role_tcode`;

ALTER TABLE `queue_report` 
  ADD COLUMN `type` TINYINT(4) NOT NULL DEFAULT 0  AFTER `id`, 
  ADD INDEX `type` (`type` ASC), 
  RENAME TO `queue_task` ;
