-- ------------------------------------------------
-- Deletion marks on um tables.
-- Created 20121115
-- ------------------------------------------------

ALTER TABLE `um_user` 
  ADD COLUMN `um_delete` TINYINT NOT NULL DEFAULT 0 AFTER `locked`
, ADD INDEX `um_del` (`um_delete` ASC) ;

ALTER TABLE `um_role` 
  ADD COLUMN `um_delete` TINYINT NOT NULL DEFAULT 0 AFTER `description`
, ADD INDEX `um_del` (`um_delete` ASC) ;

ALTER TABLE `um_tcode` 
  ADD COLUMN `um_delete` TINYINT NOT NULL DEFAULT 0 AFTER `description`
, ADD INDEX `um_del` (`um_delete` ASC) ;
