DDL/******************************************************************************/
/*** Generated by IBExpert 25.08.2021 13:54:16 ***/
/******************************************************************************/

/******************************************************************************/
/*** Following SET SQL DIALECT is just for the Database Comparer ***/
/******************************************************************************/
SET SQL DIALECT 3;



/******************************************************************************/
/*** Tables ***/
/******************************************************************************/



CREATE TABLE PARAM (
PARID INTEGER NOT NULL,
PARLIBMP VARCHAR(1024),
PARLIBUNIT VARCHAR(1024),
PARDISC BOOL /* BOOL = SMALLINT DEFAULT NULL CHECK (VALUE IN (0,1) OR VALUE IS NULL) */,
PARVALMIN FLOAT,
PARVALMAX FLOAT,
PARNAME VARCHAR(64),
PARAIDE VARCHAR(1024),
PARFORMAT VARCHAR(5),
PARIDCONF SMALLINT,
PARAIDEVAL VARCHAR(1024),
PARAIDEMODE TPMAIDEMODETYPE /* TPMAIDEMODETYPE = VARCHAR(16) DEFAULT NULL CHECK (VALUE IN ('ONSCREEN', 'POPUP', 'XMLFILE') OR VALUE IS NULL) */,
PARAIDEFILE VARCHAR(32),
PARGRAPHICDISPLAY BOOL /* BOOL = SMALLINT DEFAULT NULL CHECK (VALUE IN (0,1) OR VALUE IS NULL) */,
PARFORMATMATCH VARCHAR(128),
PARFORMATREPLACE VARCHAR(128),
PARFORMATTYPE VARCHAR(32)
);




/******************************************************************************/
/*** Primary keys ***/
/******************************************************************************/

ALTER TABLE PARAM ADD CONSTRAINT PK_PARAM PRIMARY KEY (PARID);


/******************************************************************************/
/*** Indices ***/
/******************************************************************************/

CREATE INDEX IX_PARAM_PARNAME ON PARAM (PARNAME);


/******************************************************************************/
/*** Privileges ***/
/******************************************************************************/