CREATE TABLE IF NOT EXISTS `def_constants` (
`ConstantName` char(255) DEFAULT NULL,
`Value` text,
`Package` char(255) DEFAULT NULL,
`Module` VARCHAR(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE={collation};
CREATE TABLE IF NOT EXISTS `def_text` (
`text_id` int(11) NOT NULL AUTO_INCREMENT,
`textname` varchar(255) DEFAULT NULL,
`textvalue` text,
`Param1` text,
`Param2` text,
`Param3` text,
`Param4` text,
`Param5` text,
`Param6` text,
`Param7` text,
PRIMARY KEY (`text_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE={collation};
SELECT text_id, textname, textvalue
FROM def_text
WHERE textname = '{textname}';