# QFQ tables: Filename has to start with 'qfq' and end with '.sql'
#
CREATE TABLE IF NOT EXISTS `Glue`
(
    `id`       INT(11)  NOT NULL AUTO_INCREMENT,
    `grId`     INT(11)  NOT NULL,
    `xId`      INT(11)  NOT NULL,
    `xId2`     INT(11)  NOT NULL,
    `pId`      INT(11)  NOT NULL,
    `pId2`     INT(11)  NOT NULL,
    `modified` DATETIME NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
    `created`  DATETIME NOT NULL DEFAULT current_timestamp(),

    PRIMARY KEY (`id`),
    KEY `grIdxIdpId` (`grId`, `xId`, `pId`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_unicode_ci;