/******************************************************************************/
/****      Expertize 2008 V3.0.0.0       ****/
/******************************************************************************/


SET SQL DIALECT 3;

SET NAMES NONE;


/******************************************************************************/
/****                                Tables                                ****/
/******************************************************************************/



CREATE TABLE MGINVFIS_INEXISTENTES (
    INEX_ID       INTEGER NOT NULL,
    CLAVE         VARCHAR(20),
    LOCALIZACION  VARCHAR(3),
    RESPONSABLE   VARCHAR(3),
    CONTEO1       NUMERIC(18,2),
    CONTEO2       NUMERIC(18,2),
    CONTEO3       NUMERIC(18,2),
    DESCR         VARCHAR(100)
);


CREATE TABLE MGINVFIS_INVENTARIO (
    INVFIS_ID     INTEGER NOT NULL,
    ARTICULO_ID   INTEGER NOT NULL,
    CLAVE         VARCHAR(20),
    LOCALIZACION  VARCHAR(3) DEFAULT '' NOT NULL,
    RESPONSABLE   VARCHAR(3),
    CONTEO1       NUMERIC(18,2),
    CONTEO2       NUMERIC(18,2),
    CONTEO3       NUMERIC(18,2),
    RESULTADO     NUMERIC(18,2),
    DESCR         VARCHAR(100),
    CALCULADO     CHAR(1) DEFAULT 'N'
);


CREATE TABLE MGINVFIS_PARAMETROS (
    PARAMETRO_ID       INTEGER NOT NULL,
    POR_LINEA          CHAR(1) DEFAULT 'N',
    LINEA_ARTICULO_ID  INTEGER,
    ENVIAR_A_CERO      CHAR(1) DEFAULT 'N',
    PASS               VARCHAR(20),
    CONTEO1_CERRADO    CHAR(1) DEFAULT 'N',
    CONTEO2_CERRADO    CHAR(1) DEFAULT 'N',
    SCONTEO1           CHAR(1),
    SCONTEO2           VARCHAR(1),
    SINICIALIZAR       VARCHAR(1),
    SGENINV            CHAR(1),
    PASSHABILITADO     CHAR(1),
    MODOREPORTEADOR    CHAR(1)
);




/******************************************************************************/
/****                             Primary Keys                             ****/
/******************************************************************************/

ALTER TABLE MGINVFIS_INVENTARIO ADD CONSTRAINT PK_ART_INVFIS2 PRIMARY KEY (INVFIS_ID);
ALTER TABLE MGINVFIS_PARAMETROS ADD CONSTRAINT PK_PARAMETROS PRIMARY KEY (PARAMETRO_ID);


/******************************************************************************/
/****                               Indices                                ****/
/******************************************************************************/

CREATE UNIQUE INDEX MGINVFIS_INVENTARIO_IDX1 ON MGINVFIS_INVENTARIO (ARTICULO_ID, LOCALIZACION);


/******************************************************************************/
/****                               Triggers                               ****/
/******************************************************************************/


SET TERM ^ ;


/******************************************************************************/
/****                         Triggers for tables                          ****/
/******************************************************************************/



/* Trigger: MGINVFIS_INEXISTENTES_BI */
CREATE TRIGGER MGINVFIS_INEXISTENTES_BI FOR MGINVFIS_INEXISTENTES
ACTIVE BEFORE INSERT POSITION 0
AS
BEGIN
  IF (NEW.INEX_ID = -1) THEN
    NEW.INEX_ID = GEN_ID(ID_DOCTOS,1);
END
^


/* Trigger: MGINVFIS_INVENTARIO_BI */
CREATE TRIGGER MGINVFIS_INVENTARIO_BI FOR MGINVFIS_INVENTARIO
ACTIVE BEFORE INSERT POSITION 0
AS
BEGIN
  IF (NEW.INVFIS_ID = -1) THEN
    NEW.INVFIS_ID = GEN_ID(ID_DOCTOS,1);
END
^


SET TERM ; ^


