-- Create table
create table fco_pi_pens_proc
(
    compania char(4) NOT NULL,
    anio number NOT NULL,
    mes number NOT NULL,
    sucursal char(10) NOT NULL,
    procesar number(1) NOT NULL
)
tablespace TS_ADAMDATOS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
-- Create/Recreate primary, unique and foreign key constraints 
alter table fco_pi_pens_proc
  add constraint PK_fco_pi_pens_proc primary key (compania, anio, mes, sucursal)
  using index 
  tablespace TS_ADAMINDICES
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
