-- Create table
create table SYS_PRODGROUP_PRODTYPE
(
  PRODGROUPPROD_KEY NUMBER(20) not null,
  PRODGROUP_ID      NUMBER(10) not null,
  COMPANY_ID        NUMBER(10) not null,
  PRODUCT_TYPE      VARCHAR2(40) not null,
  ISVALID           VARCHAR2(1),
  UPDATEDATE        DATE,
  UPDATEBYUSER_CODE VARCHAR2(20)
)
tablespace SYSINFO
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
-- Create/Recreate indexes 
create index IDX_SYS_PRODGROUP_PRODTYPE_1 on SYS_PRODGROUP_PRODTYPE (PRODGROUP_ID, ISVALID)
  tablespace SYSINFO
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );