iBase.ru Forum

Код: Выделить всё

CREATE TABLE LUACCOM (
    LUID                  INTEGER NOT NULL,
    SUPPID                INTEGER,
    BROKERID              INTEGER,
    ARRDATE               DATE,
    ENDDATE               DATE,
    BUILDID               INTEGER,
    BUILDINGNAME          CHAR(35),
    RESORT                INTEGER,
    RESORTNAME            CHAR(35),
    RATING                CHAR(5),
    ROOMTYPECODE          CHAR(10),
    BOARDTYPECODE         CHAR(10),
    CONTRACTTYPE          CHAR(10),
    UPDATED               DATE,
    MAXOCC                CHAR(100),
    MINOCC                CHAR(100),
    REQUESTIFFULL         CHAR(1),
    FIXMARGINS            CHAR(1),
    CONTRACTORID          INTEGER,
    CODING                CHAR(36) [1:750,1:30],
    NOROOMS               INTEGER,
    ANYINCTRANS           CHAR(1),
    PRICES                DOUBLE PRECISION [1:750,1:210],
    BROCHUREPRICING       CHAR(1),
    BOARDTYPESET          CHAR(20),
    REQUESTINSIDERELEASE  CHAR(1)
);

ALTER TABLE LUACCOM ADD PRIMARY KEY (LUID);