Ускорение режима все партии — различия между версиями

Версия 17:15, 4 марта 2016

/******************************************************************************/
/***               Generated by IBExpert 04.03.2016 16:16:39                ***/
/******************************************************************************/

/******************************************************************************/
/***      Following SET SQL DIALECT is just for the Database Comparer       ***/
/******************************************************************************/
SET SQL DIALECT 3;



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



CREATE TABLE WAREBASEPARTS (
    PART_ID         BIGINT NOT NULL,
    WARE_ID         CHAR(36) NOT NULL,
    SNAME           VARCHAR(250),
    SIZG            VARCHAR(250),
    SCOUNTRY        VARCHAR(250),
    ORIG_CODE       VARCHAR(250),
    SORIG_NAME      VARCHAR(250),
    SORIG_IZG       VARCHAR(250),
    SORIG_COUNTRY   VARCHAR(250),
    BCODE_IZG       VARCHAR(250),
    PRICE           DOUBLE PRECISION,
    PRICE_O         DOUBLE PRECISION,
    PRICE_Z         DOUBLE PRECISION,
    PRICE_R         DOUBLE PRECISION,
    QUANT           DOUBLE PRECISION,
    BARCODE         VARCHAR(250),
    BARCODE1        VARCHAR(250),
    DEP             BIGINT,
    KRITK           BIGINT,
    GODENDO         TIMESTAMP,
    SERIA           VARCHAR(250),
    SUM_NDSO        DOUBLE PRECISION,
    SERT            VARCHAR(250),
    DATESERT        TIMESTAMP,
    KEMVSERT        VARCHAR(250),
    SDSERT          TIMESTAMP,
    REGN            VARCHAR(250),
    NGTD            VARCHAR(250),
    EDIZM           VARCHAR(250),
    DOC_ID          BIGINT,
    DOCNUM          VARCHAR(250),
    DOCDATE         TIMESTAMP,
    DOCCAPTION      VARCHAR(250),
    DOCAGENT        VARCHAR(250),
    DOCVNUM         BIGINT,
    DOCVSHIFT       BIGINT,
    INSERTDT        TIMESTAMP,
    UPDATEDT        TIMESTAMP,
    ENDDT           TIMESTAMP,
    NDS             DOUBLE PRECISION,
    REALQUANT       DOUBLE PRECISION,
    PART_PARENT_ID  BIGINT,
    NAME_ID         CHAR(36),
    IZG_ID          CHAR(36),
    COUNTRY_ID      CHAR(36),
    NAC             DOUBLE PRECISION,
    BLOCK_QUANT     DOUBLE PRECISION,
    BLOCK_COUNT     INTEGER,
    MMBSH           VARCHAR(1024),
    PART_TYPE       INTEGER,
    BASE_AGENT_ID   BIGINT,
    SBASE_AGENT_ID  VARCHAR(250),
    CONTRACT_ID     BIGINT,
    SCONTRACT_ID    VARCHAR(250),
    GROUP_ID        BIGINT,
    ISFOLDER        INTEGER,
    MNN             VARCHAR(250)
);




/******************************************************************************/
/***                               Privileges                               ***/
/******************************************************************************/