drop table vbcategoria;
create table vbcategoria
(cia         char(3) not null,
 bodega      char(3) not null,
 categoria   char(1) not null,
 descripcion varchar2(30) not null,
 lote        varchar2(15) not null,
 descuento   number(5,2) not null,
 constraint vbcategoria_pk 
    primary key (cia, bodega, categoria)
);

drop table genimpbarras;
create table genimpbarras
(CIA          CHAR(3) NOT NULL,
 SESION       NUMBER(5) NOT NULL,
 ARTICULO     VARCHAR2(25) NOT NULL,
 BODEGA       CHAR(3) NOT NULL,
 CATEGORIA    CHAR(1) NOT NULL,
 CANTIDAD     NUMBER(5) NOT NULL,
 CANMTS       NUMBER(5,2),
 constraint genimpbarras 
    primary key (cia, sesion, bodega, articulo, categoria)
);

grant all on vbcategoria to llobet_general;
grant all on genimpbarras to llobet_general;

create public synonym vbcategoria for llobet.vbcategoria;
create public synonym genimpbarras for llobet.genimpbarras;