# QFQ tables: Filename has to start with 'qfq' and end with '.sql'
#
# Used for comments.
CREATE TABLE IF NOT EXISTS `Comment`
(
    `id`                    INT(11)             NOT NULL AUTO_INCREMENT,
    `isId`                  INT(11)             NOT NULL DEFAULT 0,
    `pIdCreator`            INT(11)             NOT NULL DEFAULT 0,
    `comment`               TEXT                NOT NULL DEFAULT '',
    `accessContact`         ENUM ('yes','no')   NOT NULL DEFAULT 'yes',
    `mailNotificationSet`   VARCHAR(1024)       NOT NULL DEFAULT '',
    `mailNotification`      DATETIME            NOT NULL DEFAULT '0000-00-00 00:00:00',
    `deleted`               ENUM('yes','no')    NOT NULL DEFAULT 'no',
    `modified`              DATETIME            NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
    `created`               DATETIME            NOT NULL DEFAULT current_timestamp(),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB
  DEFAULT CHARSET = utf8;