-- Create table
create table SALVAGE_IMAGES
(
  vin     VARCHAR2(20) not null,
  dateadd TIMESTAMP(6) not null,
  ipath   VARCHAR2(500) not null,
  fn      NUMBER(1) default 0 not null
)
tablespace USERS
  pctfree 0
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  )
compress;
-- Create/Recreate indexes 
create unique index VIB_DATEADD_IDX on SALVAGE_IMAGES (VIN, DATEADD)
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  )
  compress 1;
-- Grant/Revoke object privileges 
grant read on SALVAGE_IMAGES to SALVAGEBOT;
