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

Версия 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 ***/ /******************************************************************************/