WHENEVER SQLERROR EXIT FAILURE ROLLBACK;
WHENEVER OSERROR  EXIT FAILURE ROLLBACK;

spool SYS_ROLE_FUNCTION_EXCLUDE_ITEM.log

prompt
prompt Creating table SYS_ROLE_FUNCTION_EXCLUDE_ITEM
prompt =============================================
prompt
whenever sqlerror continue
drop table SYS_ROLE_FUNCTION_EXCLUDE_ITEM;
whenever sqlerror exit failure rollback

create table SYS_ROLE_FUNCTION_EXCLUDE_ITEM
(
  ROLE_ID           NUMBER not null,
  FUNCTION_GROUP_ID NUMBER not null,
  FUNCTION_ID       NUMBER not null,
  CREATED_BY        NUMBER not null,
  CREATION_DATE     DATE not null,
  LAST_UPDATED_BY   NUMBER not null,
  LAST_UPDATE_DATE  DATE not null
);

alter table SYS_ROLE_FUNCTION_EXCLUDE_ITEM
  add constraint SYS_ROLE_FUNC_EXCLUDE_ITEM_PK primary key (ROLE_ID,FUNCTION_GROUP_ID,FUNCTION_ID);


spool off

exit
