rem
rem
rem  Copyright (c) Oracle Corporation 1991.  All Rights Reserved, Worldwide.
rem
rem  srw2530.sql
rem


rem  +--------------------------+
rem  |  Update to SRW2_ELEMENT  |
rem  +--------------------------+

drop view srw2_element;
drop index srw2_element_idx;
drop public synonym srw2_element;


alter table srw2__element add 
( 
  reloplst   decimal(10)     /*  */  	
);

create unique index srw2_element_idx on srw2__element
(
  owner, modid, itemid
);

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

create public synonym srw2_element for system.srw2_element;


rem  +-----------------------+
rem  |  Update to SRW2_LISTS  |
rem  +-----------------------+

drop view srw2_lists;
drop index srw2_lists_idx;
drop public synonym srw2_lists;


alter table srw2__lists add 
( 
  position	decimal(10)     /* oredr of the item in its list */	
);

create index srw2_lists_idx on srw2__lists
(
  owner, modid, listid
);

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

create public synonym srw2_lists for system.srw2_lists;


rem  +-------------------------+
rem  |  Commit                 |
rem  +-------------------------+

commit;
