FIREBIRD SETUP - AndreyPootMay/backend-firebird-tasks GitHub Wiki

Docker image pull

docker run --name fb_tasks -d -e ISC_PASSWORD=password -e FIREBIRD_DATABASE=tasks.db -e EnableLegacyClientAuth=true -p 3050:3050 jacobalberty/firebird

Table DDL

CREATE TABLE TASKS (
	ID INTEGER NOT NULL,
	NAME VARCHAR(100) NOT NULL,
	DESCRIPTION VARCHAR(255) NOT NULL,
	DONE BOOLEAN DEFAULT false NOT NULL,
	ACTIVE BOOLEAN DEFAULT true NOT NULL,
	CREATED_AT TIMESTAMP NOT NULL,
	UPDATED_AT TIMESTAMP NOT NULL
);

CREATE UNIQUE INDEX TASKS_ID_IDX ON TASKS (ID);

For setting auto incremental trigger into Firebird DB Table will use the next snippet:

CREATE SEQUENCE tasks_id_sequence;

SET term !! ;
CREATE TRIGGER TASKS_AUTOINCREMENT FOR TASKS
ACTIVE BEFORE INSERT POSITION 0
AS
BEGIN
  NEW.ID = next value FOR tasks_id_sequence;
END!!
SET term ; !!