-- ------------------------------------------------
-- Add system and client to sod_functionalities
-- Created 20140821
-- ------------------------------------------------

ALTER TABLE `sod_functionalities` 
  ADD COLUMN `system` VARCHAR(8) NULL AFTER `group_id`,
  ADD COLUMN `client` VARCHAR(3) NULL AFTER `system`,
  DROP INDEX `name_UNIQUE`, 
  ADD UNIQUE INDEX `name_UNIQUE` (`name` ASC, `system` ASC, `client` ASC);
