-- -------------------------------------------
-- Add non-existent flag to um_tcode for
-- tcodes that are explicitly mentioned in 
-- roles, but which do not exist.
-- -------------------------------------------

ALTER TABLE `um_tcode`
  ADD COLUMN `nonexistent` CHAR(1) NOT NULL DEFAULT '' AFTER `description`;
