text: /*
      FileLibray Files Table
      -----------------------------------
  
      @tablename _proj_PROJECTNAME_library_files
      @version 2.2.0
  */
  CREATE TABLE _proj_PROJECTNAME_library_files (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `folder` int(10) unsigned NOT NULL,
    `filename` text NOT NULL DEFAULT '',
    `filenamehash` varchar(40) NOT NULL DEFAULT '',
    `hash` varchar(64) NOT NULL DEFAULT '',
    `mime` varchar(255) NOT NULL DEFAULT '',
    `filesize` int(10) unsigned NOT NULL DEFAULT 0,
    `lastmod` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    `width` int(10) unsigned DEFAULT NULL,
    `height` int(10) unsigned DEFAULT NULL,
    `displayAspectRatio` float unsigned DEFAULT NULL,
    `duration` float unsigned DEFAULT NULL,
    `artist` text DEFAULT '',
    `album` text DEFAULT '',
    `title` text DEFAULT '',
    `copyright` text DEFAULT '',
    `description` text DEFAULT '',
    `keywords` text DEFAULT '',
    `customKeywords` text DEFAULT '',
    PRIMARY KEY (`id`),
    UNIQUE KEY `folderFilename`(`folder`,`filenamehash`),
    KEY `filename`(`filename`),
    KEY `info`(`hash`,`mime`,`filesize`,`lastmod`),
    FULLTEXT KEY `metadata` (`artist`,`album`,`title`,`copyright`,`description`,`keywords`,`customKeywords`)
  ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;
  
  /*
      @version 2.2.0.1
  */
  ALTER TABLE _proj_PROJECTNAME_library_files ADD COLUMN `centerX` TINYINT DEFAULT NULL AFTER height, ADD COLUMN `centerY` TINYINT DEFAULT NULL AFTER centerX;
  
  UPDATE _proj_PROJECTNAME_library_files SET centerX = 50, centerY = 50 WHERE mime LIKE 'image/%';
  