SET SQL DIALECT 3;

CREATE TABLE TBL_SPRSCANCOD (
    ID         INTEGER NOT NULL,
    SCANCOD    INTEGER NOT NULL,
    CODTVR     INTEGER NOT NULL,
    ZAKAZ      VARCHAR(30) CHARACTER SET WIN1251,
    ORGZAKAZ   INTEGER,
    VESC       NUMERIC(3,3),
    VESV       NUMERIC(3,3),
    VESP       NUMERIC(3,3),
    VESU       NUMERIC(3,3),
    VSTDETAIL  VARCHAR(255) CHARACTER SET WIN1251,
    RAZMER     NUMERIC(3,2),
    DATEIZD    DATE NOT NULL,
    NAMUSER    VARCHAR(50) CHARACTER SET WIN1251,
    ISDEL      VARCHAR(50) CHARACTER SET WIN1251
);

ALTER TABLE TBL_SPRSCANCOD ADD CONSTRAINT UNQ1_TBL_SPRSCANCOD UNIQUE (SCANCOD);

ALTER TABLE TBL_SPRSCANCOD ADD CONSTRAINT PK_TBL_SPRSCANCOD PRIMARY KEY (ID);

ALTER TABLE TBL_SPRSCANCOD ADD CONSTRAINT FK_TBL_SPRSCANCOD_1 FOREIGN KEY (CODTVR) REFERENCES SPTVR (CODTVR);

CREATE INDEX TBL_SPRSCANCOD_IDX1 ON TBL_SPRSCANCOD (SCANCOD);
CREATE INDEX TBL_SPRSCANCOD_IDX2 ON TBL_SPRSCANCOD (ZAKAZ);
CREATE INDEX TBL_SPRSCANCOD_IDX3 ON TBL_SPRSCANCOD (CODTVR);
CREATE INDEX TBL_SPR_SCANCODIDX3 ON TBL_SPRSCANCOD (ORGZAKAZ);