DarkMasterramses88,

Редактор таблиц - вкладка Скрипт в IBExpert

SET SQL DIALECT 3;
SET NAMES WIN1251;
CREATE TABLE GOODS (
CODE INTEGER NOT NULL,
NAME VARCHAR(32),
BAR VARCHAR(13),
PRICE DECIMAL(15,4),
TAX_A VARCHAR(1),
TAX_B VARCHAR(1),
TAX_C VARCHAR(1),
TAX_D VARCHAR(1),
TAX_E VARCHAR(1),
TAX_F VARCHAR(1),
TAX_G VARCHAR(1),
TAX_H VARCHAR(1),
DATE_TIME TIMESTAMP,
DEPARTMENT INTEGER,
"TYPE" VARCHAR(1),
INVOICE INTEGER,
ARTICUL INTEGER,
"GROUP" INTEGER,
REPORT VARCHAR(1),
PRICE_INV DECIMAL(15,4),
NUMBER DECIMAL(15,3),
GID INTEGER,
CODE_BP INTEGER,
ALLOW_BP INTEGER
);

/*** Primary Keys ***/

ALTER TABLE GOODS ADD CONSTRAINT PK_GOODS PRIMARY KEY (CODE);

/*** Triggers ***/

SET TERM ^ ;

/*** Triggers for tables ***/

/* Trigger: GOODS_BI */
CREATE TRIGGER GOODS_BI FOR GOODS
ACTIVE BEFORE INSERT POSITION 0
as begin
NEW.GID=gen_id(GEN_GID, 1);
end
^
Это оно?

SET TERM ; ^