CREATE TABLE CARDS (
CARDID VARCHAR(10) NOT NULL,
BARCODE VARCHAR(13),
CARDON SMALLINT,
CRDDATEON VARCHAR(255),
CRDDATEOFF VARCHAR(255),
CARDTYPE INTEGER,
CLIENT INTEGER,
SUMALL NUMERIC(16,2),
STAT INTEGER,
ID BIGINT DEFAULT 0 NOT NULL,
UPDATE_DATE D_DATETIME DEFAULT '30-DEC-1899' NOT NULL,
FIO VARCHAR(150),
TEL VARCHAR(50),
TELHOME VARCHAR(50),
CORRECTION INTEGER DEFAULT 0 NOT NULL,
RATING INTEGER DEFAULT 0 NOT NULL
);

ALTER TABLE CARDS ADD CONSTRAINT PK_CARDS PRIMARY KEY (CARDID);
CREATE INDEX CARDS_BARCODE_IDX ON CARDS (BARCODE);
CREATE INDEX CARDS_IDX ON CARDS (ID);
CREATE INDEX CARDS_IDX1 ON CARDS (STAT, BARCODE);
CREATE INDEX CARDS_UPDATE_DATE_IDX ON CARDS (UPDATE_DATE);

CREATE TABLE "##CARDS4_LOAD" EXTERNAL 'CARDS4_LOAD.DAT' (
ID D_IDENTITY NOT NULL,
CARDID VARCHAR(10) NOT NULL,
BARCODE D_BARCODE,
CARDON D_BOOLEAN,
CRDDATEON D_DATETIME,
CRDDATEOFF D_DATETIME,
CARDTYPE INTEGER NOT NULL,
CLIENT INTEGER,
SUMALL D_MONEY,
STAT INTEGER,
FIO VARCHAR(150),
TEL VARCHAR(50),
TELHOME VARCHAR(50),
CORRECTION INTEGER,
RATING INTEGER,
EOL CHAR(2) CHARACTER SET OCTETS
);