[2024-12-29 09:38:47.285] [info] Executing (default): SELECT 1+1 AS result [2024-12-29 09:38:48.934] [info] Executing (default): SELECT name FROM sqlite_master WHERE type='table' AND name='SequelizeMeta'; [2024-12-29 09:38:48.940] [info] Executing (default): CREATE TABLE IF NOT EXISTS `SequelizeMeta` (`name` VARCHAR(255) NOT NULL UNIQUE PRIMARY KEY); [2024-12-29 09:38:50.812] [info] Executing (default): PRAGMA INDEX_LIST(`SequelizeMeta`) [2024-12-29 09:38:50.831] [info] Executing (default): PRAGMA INDEX_INFO(`sqlite_autoindex_SequelizeMeta_1`) [2024-12-29 09:38:50.833] [info] Executing (default): SELECT `name` FROM `SequelizeMeta` AS `SequelizeMeta` ORDER BY `SequelizeMeta`.`name` ASC; [2024-12-29 09:38:50.839] [info] Executing (default): SELECT name FROM sqlite_master WHERE type='table' AND name='SequelizeMeta'; [2024-12-29 09:38:50.841] [info] Executing (default): PRAGMA INDEX_LIST(`SequelizeMeta`) [2024-12-29 09:38:50.842] [info] Executing (default): PRAGMA INDEX_INFO(`sqlite_autoindex_SequelizeMeta_1`) [2024-12-29 09:38:50.844] [info] Executing (default): SELECT `name` FROM `SequelizeMeta` AS `SequelizeMeta` ORDER BY `SequelizeMeta`.`name` ASC; [2024-12-29 09:38:50.848] [info] Executing (default): SELECT name FROM sqlite_master WHERE type='table' AND name='Videos'; [2024-12-29 09:38:50.852] [info] Executing (default): CREATE TABLE IF NOT EXISTS `Videos` (`FolderId` UUID REFERENCES `Folders` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, `title` VARCHAR(255), `description` VARCHAR(255), `onlineStoryboard` JSON, `thumbnailUrl` VARCHAR(255), `imported` TINYINT(1) DEFAULT 0, `sourceType` VARCHAR(255), `sourcePath` VARCHAR(255), `sourceUrl` VARCHAR(255), `proxyPath` VARCHAR(255), `audioPath` VARCHAR(255), `version` VARCHAR(255) NOT NULL DEFAULT 'free', `status` VARCHAR(255) NOT NULL DEFAULT 'Queued', `progress` INTEGER DEFAULT 0, `errorMessage` VARCHAR(255), `logs` TEXT, `sensitivity` INTEGER DEFAULT 5, `minimumShotFrames` INTEGER DEFAULT 10, `forcedCuts` JSON, `merges` JSON, `sourceMetadata` JSON, `mediaTracks` JSON, `frames` JSON, `shots` JSON, `frameMetadata` JSON, `transcriptionId` VARCHAR(255) DEFAULT NULL, `transcriptionStatus` VARCHAR(255) DEFAULT NULL, `transcript` JSON, `id` INTEGER PRIMARY KEY AUTOINCREMENT, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL, `deletedAt` DATETIME); [2024-12-29 09:38:50.863] [info] Executing (default): PRAGMA INDEX_LIST(`Videos`) [2024-12-29 09:38:50.865] [info] Executing (default): SELECT name FROM sqlite_master WHERE type='table' AND name='Folders'; [2024-12-29 09:38:50.866] [info] Executing (default): CREATE TABLE IF NOT EXISTS `Folders` (`title` VARCHAR(255) DEFAULT 'New Folder', `FolderId` UUID REFERENCES `Folders` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, `id` INTEGER PRIMARY KEY AUTOINCREMENT, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL, `deletedAt` DATETIME); [2024-12-29 09:38:50.877] [info] Executing (default): PRAGMA INDEX_LIST(`Folders`) [2024-12-29 09:38:50.879] [info] Executing (default): SELECT name FROM sqlite_master WHERE type='table' AND name='ExportJobs'; [2024-12-29 09:38:50.882] [info] Executing (default): CREATE TABLE IF NOT EXISTS `ExportJobs` (`VideoId` UUID NOT NULL REFERENCES `Videos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, `location` VARCHAR(255), `clips` JSON, `metadataFields` JSON, `visualEffects` JSON, `filters` JSON, `images` JSON, `onlineStoryboard` JSON, `storyboard` JSON, `timecode` JSON, `script` JSON, `progress` INTEGER DEFAULT 0, `activeTask` VARCHAR(255) DEFAULT NULL, `cancelled` TINYINT(1) NOT NULL DEFAULT 0, `userIsAuthorized` TINYINT(1) NOT NULL, `id` INTEGER PRIMARY KEY AUTOINCREMENT, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL, `deletedAt` DATETIME); [2024-12-29 09:38:50.893] [info] Executing (default): PRAGMA INDEX_LIST(`ExportJobs`) [2024-12-29 09:38:50.896] [info] Executing (default): SELECT name FROM sqlite_master WHERE type='table' AND name='Activations'; [2024-12-29 09:38:50.898] [info] Executing (default): CREATE TABLE IF NOT EXISTS `Activations` (`license` TEXT NOT NULL, `id` INTEGER PRIMARY KEY AUTOINCREMENT, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL, `deletedAt` DATETIME); [2024-12-29 09:38:50.910] [info] Executing (default): PRAGMA INDEX_LIST(`Activations`) [2024-12-29 09:38:50.912] [info] Executing (default): SELECT name FROM sqlite_master WHERE type='table' AND name='MetadataCategories'; [2024-12-29 09:38:50.914] [info] Executing (default): CREATE TABLE IF NOT EXISTS `MetadataCategories` (`title` VARCHAR(255) DEFAULT 'Metadata Category', `order` INTEGER, `id` INTEGER PRIMARY KEY AUTOINCREMENT, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL, `deletedAt` DATETIME); [2024-12-29 09:38:50.926] [info] Executing (default): PRAGMA INDEX_LIST(`MetadataCategories`) [2024-12-29 09:38:50.928] [info] Executing (default): SELECT name FROM sqlite_master WHERE type='table' AND name='MetadataFields'; [2024-12-29 09:38:50.930] [info] Executing (default): CREATE TABLE IF NOT EXISTS `MetadataFields` (`MetadataCategoryId` UUID NOT NULL REFERENCES `MetadataCategories` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, `title` VARCHAR(255) DEFAULT 'Field name', `description` VARCHAR(255), `legacyName` VARCHAR(255), `options` JSON, `type` TEXT, `order` INTEGER DEFAULT 0, `id` INTEGER PRIMARY KEY AUTOINCREMENT, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL, `deletedAt` DATETIME); [2024-12-29 09:38:50.942] [info] Executing (default): PRAGMA INDEX_LIST(`MetadataFields`) [2024-12-29 09:38:50.945] [info] Executing (default): SELECT name FROM sqlite_master WHERE type='table' AND name='SequelizeMeta'; [2024-12-29 09:38:50.947] [info] Executing (default): PRAGMA INDEX_LIST(`SequelizeMeta`) [2024-12-29 09:38:50.948] [info] Executing (default): PRAGMA INDEX_INFO(`sqlite_autoindex_SequelizeMeta_1`) [2024-12-29 09:38:50.953] [info] Executing (default): INSERT INTO `SequelizeMeta` (`name`) VALUES ($1); [2024-12-29 09:38:50.966] [info] Executing (default): SELECT name FROM sqlite_master WHERE type='table' AND name='SequelizeMeta'; [2024-12-29 09:38:50.967] [info] Executing (default): PRAGMA INDEX_LIST(`SequelizeMeta`) [2024-12-29 09:38:50.969] [info] Executing (default): PRAGMA INDEX_INFO(`sqlite_autoindex_SequelizeMeta_1`) [2024-12-29 09:38:50.972] [info] Executing (default): SELECT `name` FROM `SequelizeMeta` AS `SequelizeMeta` ORDER BY `SequelizeMeta`.`name` ASC; [2024-12-29 09:38:50.977] [info] Executing (default): SELECT name FROM sqlite_master WHERE type='table' AND name='Folders'; [2024-12-29 09:38:50.979] [info] Executing (default): PRAGMA INDEX_LIST(`Folders`) [2024-12-29 09:38:50.980] [info] Executing (default): PRAGMA TABLE_INFO(`Videos`); [2024-12-29 09:38:50.982] [info] Executing (default): PRAGMA INDEX_LIST(`Videos`) [2024-12-29 09:38:50.983] [info] Executing (default): PRAGMA foreign_key_list(`Videos`) [2024-12-29 09:38:50.994] [info] Executing (default): PRAGMA TABLE_INFO(`Videos`); [2024-12-29 09:38:50.996] [info] Executing (default): PRAGMA INDEX_LIST(`Videos`) [2024-12-29 09:38:50.998] [info] Executing (default): PRAGMA foreign_key_list(`Videos`) [2024-12-29 09:38:51.000] [info] Executing (default): PRAGMA TABLE_INFO(`Videos`); [2024-12-29 09:38:51.002] [info] Executing (default): PRAGMA INDEX_LIST(`Videos`) [2024-12-29 09:38:51.004] [info] Executing (default): PRAGMA foreign_key_list(`Videos`) [2024-12-29 09:38:51.006] [info] Executing (default): PRAGMA TABLE_INFO(`Activations`); [2024-12-29 09:38:51.007] [info] Executing (default): PRAGMA INDEX_LIST(`Activations`) [2024-12-29 09:38:51.008] [info] Executing (default): PRAGMA foreign_key_list(`Activations`) [2024-12-29 09:38:51.008] [info] Executing (default): PRAGMA TABLE_INFO(`ExportJobs`); [2024-12-29 09:38:51.009] [info] Executing (default): PRAGMA INDEX_LIST(`ExportJobs`) [2024-12-29 09:38:51.010] [info] Executing (default): PRAGMA foreign_key_list(`ExportJobs`) [2024-12-29 09:38:51.011] [info] Executing (default): SELECT name FROM sqlite_master WHERE type='table' AND name='SequelizeMeta'; [2024-12-29 09:38:51.012] [info] Executing (default): PRAGMA INDEX_LIST(`SequelizeMeta`) [2024-12-29 09:38:51.013] [info] Executing (default): PRAGMA INDEX_INFO(`sqlite_autoindex_SequelizeMeta_1`) [2024-12-29 09:38:51.016] [info] Executing (default): INSERT INTO `SequelizeMeta` (`name`) VALUES ($1); [2024-12-29 09:38:51.029] [info] Executing (default): SELECT name FROM sqlite_master WHERE type='table' AND name='SequelizeMeta'; [2024-12-29 09:38:51.030] [info] Executing (default): PRAGMA INDEX_LIST(`SequelizeMeta`) [2024-12-29 09:38:51.032] [info] Executing (default): PRAGMA INDEX_INFO(`sqlite_autoindex_SequelizeMeta_1`) [2024-12-29 09:38:51.034] [info] Executing (default): SELECT `name` FROM `SequelizeMeta` AS `SequelizeMeta` ORDER BY `SequelizeMeta`.`name` ASC; [2024-12-29 09:38:51.041] [info] Executing (default): SELECT name FROM sqlite_master WHERE type='table' AND name='MetadataCategories'; [2024-12-29 09:38:51.043] [info] Executing (default): PRAGMA INDEX_LIST(`MetadataCategories`) [2024-12-29 09:38:51.044] [info] Executing (default): SELECT name FROM sqlite_master WHERE type='table' AND name='MetadataFields'; [2024-12-29 09:38:51.045] [info] Executing (default): PRAGMA INDEX_LIST(`MetadataFields`) [2024-12-29 09:38:51.046] [info] Executing (default): PRAGMA TABLE_INFO(`MetadataFields`); [2024-12-29 09:38:51.047] [info] Executing (default): PRAGMA INDEX_LIST(`MetadataFields`) [2024-12-29 09:38:51.048] [info] Executing (default): PRAGMA foreign_key_list(`MetadataFields`) [2024-12-29 09:38:51.050] [info] Executing (default): PRAGMA TABLE_INFO(`videos`); [2024-12-29 09:38:51.052] [info] Executing (default): PRAGMA INDEX_LIST(`videos`) [2024-12-29 09:38:51.053] [info] Executing (default): PRAGMA foreign_key_list(`videos`) [2024-12-29 09:38:51.056] [info] Executing (default): PRAGMA TABLE_INFO(`exportjobs`); [2024-12-29 09:38:51.059] [info] Executing (default): PRAGMA INDEX_LIST(`exportjobs`) [2024-12-29 09:38:51.060] [info] Executing (default): PRAGMA foreign_key_list(`exportjobs`) [2024-12-29 09:38:51.066] [info] Executing (default): SELECT `FolderId`, `title`, `description`, `onlineStoryboard`, `thumbnailUrl`, `imported`, `sourceType`, `sourcePath`, `sourceUrl`, `proxyPath`, `audioPath`, `version`, `status`, `progress`, `errorMessage`, `logs`, `sensitivity`, `minimumShotFrames`, `forcedCuts`, `merges`, `sourceMetadata`, `mediaTracks`, `frames`, `shots`, `frameMetadata`, `transcriptionId`, `transcriptionStatus`, `transcript`, `id`, `createdAt`, `updatedAt`, `deletedAt` FROM `Videos` AS `Video` WHERE (`Video`.`deletedAt` IS NULL); [2024-12-29 09:38:51.074] [info] Executing (default): INSERT INTO `MetadataCategories` (`title`,`order`,`id`,`createdAt`,`updatedAt`) VALUES ($1,$2,NULL,$3,$4); [2024-12-29 09:38:51.089] [info] Executing (default): INSERT INTO `MetadataFields` (`MetadataCategoryId`,`title`,`type`,`order`,`id`,`createdAt`,`updatedAt`) VALUES ($1,$2,$3,$4,NULL,$5,$6); [2024-12-29 09:38:51.103] [info] Executing (default): INSERT INTO `MetadataFields` (`MetadataCategoryId`,`title`,`options`,`type`,`order`,`id`,`createdAt`,`updatedAt`) VALUES ($1,$2,$3,$4,$5,NULL,$6,$7); [2024-12-29 09:38:51.118] [info] Executing (default): INSERT INTO `MetadataFields` (`MetadataCategoryId`,`title`,`options`,`type`,`order`,`id`,`createdAt`,`updatedAt`) VALUES ($1,$2,$3,$4,$5,NULL,$6,$7); [2024-12-29 09:38:51.132] [info] Executing (default): INSERT INTO `MetadataFields` (`MetadataCategoryId`,`title`,`options`,`type`,`order`,`id`,`createdAt`,`updatedAt`) VALUES ($1,$2,$3,$4,$5,NULL,$6,$7); [2024-12-29 09:38:51.150] [info] Executing (default): INSERT INTO `MetadataFields` (`MetadataCategoryId`,`title`,`type`,`order`,`id`,`createdAt`,`updatedAt`) VALUES ($1,$2,$3,$4,NULL,$5,$6); [2024-12-29 09:38:51.161] [info] Executing (default): SELECT `MetadataCategoryId`, `title`, `description`, `legacyName`, `options`, `type`, `order`, `id`, `createdAt`, `updatedAt`, `deletedAt` FROM `MetadataFields` AS `MetadataField` WHERE (`MetadataField`.`deletedAt` IS NULL); [2024-12-29 09:38:51.164] [info] Executing (default): SELECT name FROM sqlite_master WHERE type='table' AND name='SequelizeMeta'; [2024-12-29 09:38:51.166] [info] Executing (default): PRAGMA INDEX_LIST(`SequelizeMeta`) [2024-12-29 09:38:51.167] [info] Executing (default): PRAGMA INDEX_INFO(`sqlite_autoindex_SequelizeMeta_1`) [2024-12-29 09:38:51.169] [info] Executing (default): INSERT INTO `SequelizeMeta` (`name`) VALUES ($1); [2024-12-29 09:38:51.180] [info] Executing (default): SELECT name FROM sqlite_master WHERE type='table' AND name='SequelizeMeta'; [2024-12-29 09:38:51.181] [info] Executing (default): PRAGMA INDEX_LIST(`SequelizeMeta`) [2024-12-29 09:38:51.182] [info] Executing (default): PRAGMA INDEX_INFO(`sqlite_autoindex_SequelizeMeta_1`) [2024-12-29 09:38:51.184] [info] Executing (default): SELECT `name` FROM `SequelizeMeta` AS `SequelizeMeta` ORDER BY `SequelizeMeta`.`name` ASC; [2024-12-29 09:38:51.189] [info] Executing (default): PRAGMA TABLE_INFO(`MetadataFields`); [2024-12-29 09:38:51.190] [info] Executing (default): PRAGMA INDEX_LIST(`MetadataFields`) [2024-12-29 09:38:51.193] [info] Executing (default): PRAGMA foreign_key_list(`MetadataFields`) [2024-12-29 09:38:51.196] [info] Executing (default): SELECT `title`, `order`, `id`, `createdAt`, `updatedAt`, `deletedAt` FROM `MetadataCategories` AS `MetadataCategory` WHERE (`MetadataCategory`.`deletedAt` IS NULL AND `MetadataCategory`.`title` = 'Demo Category') LIMIT 1; [2024-12-29 09:38:51.200] [info] Executing (default): UPDATE `MetadataCategories` SET `title`=$1,`updatedAt`=$2 WHERE `id` = $3 [2024-12-29 09:38:51.212] [info] Executing (default): SELECT `title`, `order`, `id`, `createdAt`, `updatedAt`, `deletedAt` FROM `MetadataCategories` AS `MetadataCategory` WHERE `MetadataCategory`.`id` = 1; [2024-12-29 09:38:51.216] [info] Executing (default): SELECT `MetadataCategoryId`, `title`, `description`, `legacyName`, `options`, `type`, `order`, `id`, `createdAt`, `updatedAt`, `deletedAt` FROM `MetadataFields` AS `MetadataField` WHERE (`MetadataField`.`deletedAt` IS NULL AND `MetadataField`.`MetadataCategoryId` = 1); [2024-12-29 09:38:51.222] [info] Executing (default): UPDATE `MetadataFields` SET `order`=$1,`updatedAt`=$2 WHERE `id` = $3 [2024-12-29 09:38:51.223] [info] Executing (default): UPDATE `MetadataFields` SET `order`=$1,`updatedAt`=$2 WHERE `id` = $3 [2024-12-29 09:38:51.223] [info] Executing (default): UPDATE `MetadataFields` SET `order`=$1,`updatedAt`=$2 WHERE `id` = $3 [2024-12-29 09:38:51.224] [info] Executing (default): UPDATE `MetadataFields` SET `order`=$1,`updatedAt`=$2 WHERE `id` = $3 [2024-12-29 09:38:51.224] [info] Executing (default): UPDATE `MetadataFields` SET `order`=$1,`updatedAt`=$2 WHERE `id` = $3 [2024-12-29 09:38:51.236] [info] Executing (default): SELECT `MetadataCategoryId`, `title`, `description`, `legacyName`, `options`, `type`, `order`, `id`, `createdAt`, `updatedAt`, `deletedAt` FROM `MetadataFields` AS `MetadataField` WHERE `MetadataField`.`id` = 1; [2024-12-29 09:38:51.250] [info] Executing (default): SELECT `MetadataCategoryId`, `title`, `description`, `legacyName`, `options`, `type`, `order`, `id`, `createdAt`, `updatedAt`, `deletedAt` FROM `MetadataFields` AS `MetadataField` WHERE `MetadataField`.`id` = 2; [2024-12-29 09:38:51.262] [info] Executing (default): SELECT `MetadataCategoryId`, `title`, `description`, `legacyName`, `options`, `type`, `order`, `id`, `createdAt`, `updatedAt`, `deletedAt` FROM `MetadataFields` AS `MetadataField` WHERE `MetadataField`.`id` = 3; [2024-12-29 09:38:51.274] [info] Executing (default): SELECT `MetadataCategoryId`, `title`, `description`, `legacyName`, `options`, `type`, `order`, `id`, `createdAt`, `updatedAt`, `deletedAt` FROM `MetadataFields` AS `MetadataField` WHERE `MetadataField`.`id` = 4; [2024-12-29 09:38:51.289] [info] Executing (default): SELECT `MetadataCategoryId`, `title`, `description`, `legacyName`, `options`, `type`, `order`, `id`, `createdAt`, `updatedAt`, `deletedAt` FROM `MetadataFields` AS `MetadataField` WHERE `MetadataField`.`id` = 5; [2024-12-29 09:38:51.303] [info] Executing (default): INSERT INTO `MetadataFields` (`MetadataCategoryId`,`title`,`description`,`type`,`order`,`id`,`createdAt`,`updatedAt`) VALUES ($1,$2,$3,$4,$5,NULL,$6,$7); [2024-12-29 09:38:51.303] [info] Executing (default): INSERT INTO `MetadataFields` (`MetadataCategoryId`,`title`,`description`,`type`,`order`,`id`,`createdAt`,`updatedAt`) VALUES ($1,$2,$3,$4,$5,NULL,$6,$7); [2024-12-29 09:38:51.304] [info] Executing (default): INSERT INTO `MetadataFields` (`MetadataCategoryId`,`title`,`description`,`type`,`order`,`id`,`createdAt`,`updatedAt`) VALUES ($1,$2,$3,$4,$5,NULL,$6,$7); [2024-12-29 09:38:51.304] [info] Executing (default): INSERT INTO `MetadataFields` (`MetadataCategoryId`,`title`,`description`,`type`,`order`,`id`,`createdAt`,`updatedAt`) VALUES ($1,$2,$3,$4,$5,NULL,$6,$7); [2024-12-29 09:38:51.305] [info] Executing (default): INSERT INTO `MetadataFields` (`MetadataCategoryId`,`title`,`description`,`type`,`order`,`id`,`createdAt`,`updatedAt`) VALUES ($1,$2,$3,$4,$5,NULL,$6,$7); [2024-12-29 09:38:51.305] [info] Executing (default): INSERT INTO `MetadataFields` (`MetadataCategoryId`,`title`,`description`,`type`,`order`,`id`,`createdAt`,`updatedAt`) VALUES ($1,$2,$3,$4,$5,NULL,$6,$7); [2024-12-29 09:38:51.306] [info] Executing (default): INSERT INTO `MetadataFields` (`MetadataCategoryId`,`title`,`description`,`type`,`order`,`id`,`createdAt`,`updatedAt`) VALUES ($1,$2,$3,$4,$5,NULL,$6,$7); [2024-12-29 09:38:51.306] [info] Executing (default): INSERT INTO `MetadataFields` (`MetadataCategoryId`,`title`,`description`,`type`,`order`,`id`,`createdAt`,`updatedAt`) VALUES ($1,$2,$3,$4,$5,NULL,$6,$7); [2024-12-29 09:38:51.306] [info] Executing (default): INSERT INTO `MetadataFields` (`MetadataCategoryId`,`title`,`description`,`type`,`order`,`id`,`createdAt`,`updatedAt`) VALUES ($1,$2,$3,$4,$5,NULL,$6,$7); [2024-12-29 09:38:51.307] [info] Executing (default): INSERT INTO `MetadataFields` (`MetadataCategoryId`,`title`,`description`,`type`,`order`,`id`,`createdAt`,`updatedAt`) VALUES ($1,$2,$3,$4,$5,NULL,$6,$7); [2024-12-29 09:38:51.308] [info] Executing (default): INSERT INTO `MetadataFields` (`MetadataCategoryId`,`title`,`description`,`type`,`order`,`id`,`createdAt`,`updatedAt`) VALUES ($1,$2,$3,$4,$5,NULL,$6,$7); [2024-12-29 09:38:51.308] [info] Executing (default): INSERT INTO `MetadataFields` (`MetadataCategoryId`,`title`,`description`,`type`,`order`,`id`,`createdAt`,`updatedAt`) VALUES ($1,$2,$3,$4,$5,NULL,$6,$7); [2024-12-29 09:38:51.445] [info] Executing (default): SELECT name FROM sqlite_master WHERE type='table' AND name='SequelizeMeta'; [2024-12-29 09:38:51.446] [info] Executing (default): PRAGMA INDEX_LIST(`SequelizeMeta`) [2024-12-29 09:38:51.447] [info] Executing (default): PRAGMA INDEX_INFO(`sqlite_autoindex_SequelizeMeta_1`) [2024-12-29 09:38:51.448] [info] Executing (default): INSERT INTO `SequelizeMeta` (`name`) VALUES ($1); [2024-12-29 09:38:51.459] [info] Executing (default): SELECT name FROM sqlite_master WHERE type='table' AND name='SequelizeMeta'; [2024-12-29 09:38:51.461] [info] Executing (default): PRAGMA INDEX_LIST(`SequelizeMeta`) [2024-12-29 09:38:51.462] [info] Executing (default): PRAGMA INDEX_INFO(`sqlite_autoindex_SequelizeMeta_1`) [2024-12-29 09:38:51.463] [info] Executing (default): SELECT `name` FROM `SequelizeMeta` AS `SequelizeMeta` ORDER BY `SequelizeMeta`.`name` ASC; [2024-12-29 09:38:51.467] [info] Executing (default): DROP TABLE IF EXISTS `ExportJobs`; [2024-12-29 09:38:51.478] [info] Executing (default): SELECT name FROM sqlite_master WHERE type='table' AND name='ExportJobs'; [2024-12-29 09:38:51.480] [info] Executing (default): CREATE TABLE IF NOT EXISTS `ExportJobs` (`VideoId` UUID NOT NULL REFERENCES `Videos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, `location` VARCHAR(255), `clips` JSON, `metadataFields` JSON, `visualEffects` JSON, `filters` JSON, `images` JSON, `onlineStoryboard` JSON, `storyboard` JSON, `timecode` JSON, `script` JSON, `progress` INTEGER DEFAULT 0, `activeTask` VARCHAR(255) DEFAULT NULL, `cancelled` TINYINT(1) NOT NULL DEFAULT 0, `userIsAuthorized` TINYINT(1) NOT NULL, `id` INTEGER PRIMARY KEY AUTOINCREMENT, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL, `deletedAt` DATETIME); [2024-12-29 09:38:51.491] [info] Executing (default): PRAGMA INDEX_LIST(`ExportJobs`) [2024-12-29 09:38:51.492] [info] Executing (default): SELECT name FROM sqlite_master WHERE type='table' AND name='SequelizeMeta'; [2024-12-29 09:38:51.493] [info] Executing (default): PRAGMA INDEX_LIST(`SequelizeMeta`) [2024-12-29 09:38:51.494] [info] Executing (default): PRAGMA INDEX_INFO(`sqlite_autoindex_SequelizeMeta_1`) [2024-12-29 09:38:51.496] [info] Executing (default): INSERT INTO `SequelizeMeta` (`name`) VALUES ($1); [2024-12-29 09:38:51.548] [info] Executing (default): UPDATE `Videos` SET `status`=$1,`updatedAt`=$2 WHERE (`deletedAt` IS NULL AND `status` NOT IN ('Complete', 'Error')) [2024-12-29 09:38:52.156] [info] Executing (default): SELECT `license`, `id`, `createdAt`, `updatedAt`, `deletedAt` FROM `Activations` AS `Activation` WHERE (`Activation`.`deletedAt` IS NULL) LIMIT 1; [2024-12-29 09:38:55.817] [info] Executing (default): SELECT `license`, `id`, `createdAt`, `updatedAt`, `deletedAt` FROM `Activations` AS `Activation` WHERE (`Activation`.`deletedAt` IS NULL) LIMIT 1; [2024-12-29 09:38:55.821] [info] Executing (default): SELECT `license`, `id`, `createdAt`, `updatedAt`, `deletedAt` FROM `Activations` AS `Activation` WHERE (`Activation`.`deletedAt` IS NULL) LIMIT 1; [2024-12-29 09:38:55.837] [info] Executing (default): SELECT `FolderId`, `title`, `description`, `onlineStoryboard`, `thumbnailUrl`, `imported`, `sourceType`, `sourcePath`, `sourceUrl`, `proxyPath`, `audioPath`, `version`, `status`, `progress`, `errorMessage`, `logs`, `sensitivity`, `minimumShotFrames`, `forcedCuts`, `merges`, `sourceMetadata`, `mediaTracks`, `frames`, `shots`, `frameMetadata`, `transcriptionId`, `transcriptionStatus`, `transcript`, `id`, `createdAt`, `updatedAt`, `deletedAt` FROM `Videos` AS `Video`; [2024-12-29 09:38:55.865] [info] Executing (default): SELECT `license`, `id`, `createdAt`, `updatedAt`, `deletedAt` FROM `Activations` AS `Activation` WHERE (`Activation`.`deletedAt` IS NULL) LIMIT 1; [2024-12-29 09:38:55.872] [info] Executing (default): SELECT `license`, `id`, `createdAt`, `updatedAt`, `deletedAt` FROM `Activations` AS `Activation` WHERE (`Activation`.`deletedAt` IS NULL) LIMIT 1; [2024-12-29 09:38:55.892] [info] Executing (default): SELECT `FolderId`, `title`, `description`, `onlineStoryboard`, `thumbnailUrl`, `imported`, `sourceType`, `sourcePath`, `sourceUrl`, `proxyPath`, `audioPath`, `version`, `status`, `progress`, `errorMessage`, `logs`, `sensitivity`, `minimumShotFrames`, `forcedCuts`, `merges`, `sourceMetadata`, `mediaTracks`, `frames`, `shots`, `frameMetadata`, `transcriptionId`, `transcriptionStatus`, `transcript`, `id`, `createdAt`, `updatedAt`, `deletedAt` FROM `Videos` AS `Video`; [2024-12-29 09:43:55.236] [info] Executing (default): SELECT `title`, `order`, `id`, `createdAt`, `updatedAt`, `deletedAt` FROM `MetadataCategories` AS `MetadataCategory`; [2024-12-29 09:43:55.238] [info] Executing (default): SELECT `MetadataCategoryId`, `title`, `description`, `legacyName`, `options`, `type`, `order`, `id`, `createdAt`, `updatedAt`, `deletedAt` FROM `MetadataFields` AS `MetadataField`; [2024-12-29 09:44:35.065] [info] Executing (default): SELECT `license`, `id`, `createdAt`, `updatedAt`, `deletedAt` FROM `Activations` AS `Activation` WHERE (`Activation`.`deletedAt` IS NULL) LIMIT 1; [2024-12-29 09:44:35.084] [info] Executing (default): SELECT `license`, `id`, `createdAt`, `updatedAt`, `deletedAt` FROM `Activations` AS `Activation` WHERE (`Activation`.`deletedAt` IS NULL) LIMIT 1; [2024-12-29 09:44:35.093] [info] Executing (default): SELECT `license`, `id`, `createdAt`, `updatedAt`, `deletedAt` FROM `Activations` AS `Activation` WHERE (`Activation`.`deletedAt` IS NULL) LIMIT 1; [2024-12-31 08:46:43.510] [info] Executing (default): SELECT 1+1 AS result [2024-12-31 08:46:46.874] [info] Executing (default): SELECT name FROM sqlite_master WHERE type='table' AND name='SequelizeMeta'; [2024-12-31 08:46:46.879] [info] Executing (default): PRAGMA INDEX_LIST(`SequelizeMeta`) [2024-12-31 08:46:46.886] [info] Executing (default): PRAGMA INDEX_INFO(`sqlite_autoindex_SequelizeMeta_1`) [2024-12-31 08:46:46.888] [info] Executing (default): SELECT `name` FROM `SequelizeMeta` AS `SequelizeMeta` ORDER BY `SequelizeMeta`.`name` ASC; [2024-12-31 08:46:46.920] [info] Executing (default): UPDATE `Videos` SET `status`=$1,`updatedAt`=$2 WHERE (`deletedAt` IS NULL AND `status` NOT IN ('Complete', 'Error')) [2024-12-31 08:46:47.405] [info] Executing (default): SELECT `license`, `id`, `createdAt`, `updatedAt`, `deletedAt` FROM `Activations` AS `Activation` WHERE (`Activation`.`deletedAt` IS NULL) LIMIT 1; [2024-12-31 08:46:51.878] [info] Executing (default): SELECT `license`, `id`, `createdAt`, `updatedAt`, `deletedAt` FROM `Activations` AS `Activation` WHERE (`Activation`.`deletedAt` IS NULL) LIMIT 1; [2024-12-31 08:46:51.881] [info] Executing (default): SELECT `license`, `id`, `createdAt`, `updatedAt`, `deletedAt` FROM `Activations` AS `Activation` WHERE (`Activation`.`deletedAt` IS NULL) LIMIT 1; [2024-12-31 08:46:51.902] [info] Executing (default): SELECT `FolderId`, `title`, `description`, `onlineStoryboard`, `thumbnailUrl`, `imported`, `sourceType`, `sourcePath`, `sourceUrl`, `proxyPath`, `audioPath`, `version`, `status`, `progress`, `errorMessage`, `logs`, `sensitivity`, `minimumShotFrames`, `forcedCuts`, `merges`, `sourceMetadata`, `mediaTracks`, `frames`, `shots`, `frameMetadata`, `transcriptionId`, `transcriptionStatus`, `transcript`, `id`, `createdAt`, `updatedAt`, `deletedAt` FROM `Videos` AS `Video`; [2024-12-31 08:46:51.927] [info] Executing (default): SELECT `license`, `id`, `createdAt`, `updatedAt`, `deletedAt` FROM `Activations` AS `Activation` WHERE (`Activation`.`deletedAt` IS NULL) LIMIT 1; [2024-12-31 08:46:51.934] [info] Executing (default): SELECT `license`, `id`, `createdAt`, `updatedAt`, `deletedAt` FROM `Activations` AS `Activation` WHERE (`Activation`.`deletedAt` IS NULL) LIMIT 1; [2024-12-31 08:46:51.966] [info] Executing (default): SELECT `FolderId`, `title`, `description`, `onlineStoryboard`, `thumbnailUrl`, `imported`, `sourceType`, `sourcePath`, `sourceUrl`, `proxyPath`, `audioPath`, `version`, `status`, `progress`, `errorMessage`, `logs`, `sensitivity`, `minimumShotFrames`, `forcedCuts`, `merges`, `sourceMetadata`, `mediaTracks`, `frames`, `shots`, `frameMetadata`, `transcriptionId`, `transcriptionStatus`, `transcript`, `id`, `createdAt`, `updatedAt`, `deletedAt` FROM `Videos` AS `Video`;