rem
rem $Header: /s/rw/994/spam/precious/files/ACTIVE/srw20140.sql,v 1.1 1998/11/03 06:57:52 yxia Exp $
rem
rem  Copyright (c) Oracle Corporation 1991.  All Rights Reserved, Worldwide.
rem
rem  srw20140.sql
rem

rem  +-----------------------------+
rem  |  Update to SRW2_COLUMN      |
rem  +-----------------------------+

drop view srw2_column;
drop index srw2_column_idx;
drop public synonym srw2_column;


alter table srw2__column add
(
  odata_type decimal(4)      /* Oracle datatype */
);

create unique index srw2_column_idx on srw2__column
(
  owner, modid, itemid
);

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

create public synonym srw2_column for system.srw2_column;


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
(
  odata_type decimal(4)      /* Oracle datatype */
);

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;






commit;

