# QFQ tables: Filename has to start with 'qfq' and end with '.sql'
#
# Used for projects.
CREATE TABLE IF NOT EXISTS `Project`
(
    `id`            INT(11)         NOT NULL AUTO_INCREMENT,
    `prId`          INT(11)         NOT NULL DEFAULT 0,
    `name`          VARCHAR(255)    NOT NULL DEFAULT '',
    `description`   VARCHAR(255)    NOT NULL DEFAULT '',
    `reference`     VARCHAR(255)    NULL,
    `modified`      DATETIME        NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
    `created`       DATETIME        NOT NULL DEFAULT current_timestamp(),
    PRIMARY KEY (`id`),
    UNIQUE `reference` (`reference`)
) ENGINE=InnoDB
  DEFAULT CHARSET = utf8;