There are few tables needed to be created to run Enterprise plugin.
But some field names in this tables are forbidden in FireBird SQL table field names.
CREATE TABLE fpQueue(
queueID INT NOT NULL,
workgroupID INT NOT NULL,
name VARCHAR(50) NOT NULL,
description VARCHAR(255),
priority INT NOT NULL,
maxchats INT NOT NULL,
minchats INT NOT NULL,
overflow INT NOT NULL, <<<<<<<<<<<< First One
backupQueue INT,
CONSTRAINT fpQueue_pk PRIMARY KEY (workgroupID,queueID)
);
CREATE TABLE fpChatSetting (
workgroupNode VARCHAR(100),
type INT, <<<<<<<<<<<< Second error
label VARCHAR(100),
description VARCHAR(255),
name VARCHAR(100),
value VARCHAR(256), <<<<<<<<<<<< Third Error
defaultValue VARCHAR(256)
);
CREATE TABLE fpSetting (
workgroupName VARCHAR(100) NOT NULL,
name VARCHAR(100) NOT NULL,
namespace VARCHAR(245) NOT NULL,
value VARCHAR(4096) NOT NULL, <<<<<<<<<<<< Fourth Error
CONSTRAINT fpSetting_pk PRIMARY KEY (workgroupName, name, namespace)
);
Please, change field names in plugin and scripts.
Thanks!!!