SCRIPT
BEGIN
 EXECUTE IMMEDIATE 'CREATE TABLE "trMateri"
(
"CodigoLog" INTEGER GENERATED ALWAYS AS IDENTITY (START WITH 0,
INCREMENT BY 1) NOT NULL DESCRIPTION ''Código interno'',
"Codigo" INTEGER NOT NULL DESCRIPTION ''Código Cecome'',
"Nombre" VARCHAR(20) COLLATE "ESP_CI_AI" NOT NULL,
"ScanCode" SMALLINT,
"Comentario" CLOB COLLATE "ESP",
"Favorito" BOOLEAN DEFAULT False     NOT NULL,
"UnidadesDefecto" INTEGER DEFAULT 0   NOT NULL,
CONSTRAINT "ixPrimary" PRIMARY KEY ("CodigoLog"),
CONSTRAINT "Unique_Codigo" UNIQUE ("Codigo"),
CONSTRAINT "Unique_ScanCode" UNIQUE ("ScanCode") --> Here is the problem
)
DESCRIPTION ''Materiales tanto de entrada como salida''
VERSION 1
UNENCRYPTED
INDEX PAGE SIZE 4096
BLOB BLOCK SIZE 512
PUBLISH BLOCK SIZE 512
PUBLISH COMPRESSION 0
MAX ROW BUFFER SIZE 32768
MAX INDEX BUFFER SIZE 65536
MAX BLOB BUFFER SIZE 32768
MAX PUBLISH BUFFER SIZE 32768';
END