rem
rem $Header: /s/rw/994/spam/precious/files/ACTIVE/srw20130.sql,v 1.1 1998/11/03 06:57:50 yxia Exp $
rem
rem  Copyright (c) Oracle Corporation 1991.  All Rights Reserved, Worldwide.
rem
rem  srw20130.sql:
rem
rem     o Adds column to srw2__display_tag

rem  +-----------------------------+
rem  |  Update to SRW2_DISPLAY_TAG |
rem  +-----------------------------+

drop view srw2_display_tag;
drop index srw2_display_tag_idx;
drop public synonym srw2_display_tag;


alter table srw2__display_tag add 
( 
  add_flags     decimal(10)     /* Additional flags for image info  */
);

create unique index srw2_display_tag_idx on srw2__display_tag
(
  owner, modid, itemid
);

create view srw2_display_tag as
  select * from srw2__display_tag
  where owner = user or modid in
  (select modid from tool_accessible where product='SQL*ReportWriter')
  with check option;

create public synonym srw2_display_tag for system.srw2_display_tag;

commit;

