CREATE TABLE `data_documentfile` (
`Docname` varchar(200) NOT NULL,
`Context` varchar(200) NOT NULL DEFAULT '',
`Context2` varchar(150) NOT NULL DEFAULT '',
`Package` varchar(100) NOT NULL DEFAULT '',
`Guid` char(255) DEFAULT '',
`ReferenceGuid` char(255) DEFAULT '',
`SourceGuid` char(255) DEFAULT '',
`OriginalFilename` char(255) DEFAULT '',
`SystemFileName` char(255) DEFAULT '',
`UploadFileName` char(255) DEFAULT '',
`FileName` char(255) DEFAULT '',
`BuildName` char(255) DEFAULT '',
`BuildVersion` char(255) DEFAULT '',
`BuildVendor` char(255) DEFAULT '',
`FileType` char(255) DEFAULT '',
`Width` int(11) DEFAULT 0,
`Height` int(11) DEFAULT 0,
`FileSize` bigint(20) DEFAULT 0,
`Size` int(11) DEFAULT 0,
`Pages` int(11) DEFAULT 0,
`Title` char(255) DEFAULT '',
`Name` char(255) DEFAULT '',
`MediaLanguage` char(255) DEFAULT 'en-ZA',
`MediaType` char(255) DEFAULT '',
`FormatType` char(255) DEFAULT '',
`EncodingType` char(255) DEFAULT '',
`MediaDuration` int(11) DEFAULT NULL,
`MediaStartTime` datetime DEFAULT NULL,
`BitsPerSample` int(11) DEFAULT NULL,
`BitsPerSecond` int(11) DEFAULT NULL,
`BytesPerSecond` int(11) DEFAULT NULL,
`SamplesPerSecond` char(255) DEFAULT '',
`Channels` char(255) DEFAULT '',
`MediaRecorder` char(255) DEFAULT '',
`IconName` char(255) DEFAULT '',
`IconWidth` int(11) DEFAULT 0,
`IconHeight` int(11) DEFAULT 0,
`IconSize` int(11) DEFAULT 0,
`PreviewName` char(255) DEFAULT '',
`PreviewWidth` int(11) DEFAULT 0,
`PreviewHeight` int(11) DEFAULT 0,
`PreviewSize` int(11) DEFAULT 0,
`CreateTime` datetime DEFAULT NULL,
`CreatedTime` datetime DEFAULT NULL,
`Downloads` int(11) DEFAULT 0,
`OcrContents` text DEFAULT NULL,
`DownloadUrl` char(255) DEFAULT '',
`IsMirrored` char(1) NOT NULL DEFAULT 'N',
`MirroredAt` datetime DEFAULT NULL,
`MirrorFolder` varchar(512) DEFAULT NULL,
`IsArchived` char(1) NOT NULL DEFAULT 'N',
`ArchivedAt` datetime DEFAULT NULL,
`ArchiveFolder` varchar(512) DEFAULT NULL,
`DoEnhance` char(1) NOT NULL DEFAULT 'N',
`EnhancedAt` datetime DEFAULT NULL,
`AiSummary` longtext DEFAULT NULL,
`IsDeleted` char(1) NOT NULL DEFAULT 'N',
`DeletedAt` datetime DEFAULT NULL,
PRIMARY KEY (`Docname`, `Context`, `Context2`, `Package`),
KEY `idx_guid` (`Guid`),
KEY `idx_sourceguid` (`SourceGuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE={collation};
SELECT *
FROM def_document
WHERE docname LIKE '{doc_name}'
AND Package IN ('{package}','{archetype}','ALL','SYSTEM')
SELECT *
FROM data_documentfile
WHERE DocName LIKE '{doc_name}'
AND Context LIKE '{context}'
AND Context2 LIKE '{context2}'
AND Package IN ('{package}','{archetype}')
INSERT IGNORE INTO data_documentfile (DocName, Context, Context2, Package)
VALUES ('{doc_name}','{context}','{context2}','{package}')
SELECT Docname
FROM data_documentfile
WHERE (Guid = '{guid}' OR Context = '{guid}')
AND Package IN ('{package}','{archetype}')
INSERT IGNORE INTO data_documentfile
(Docname, Context, Context2, Guid,
CreateTime, Package, ReferenceGuid)
VALUES
('{doc_name}','{context}','{context2}','{guid}',now(),'{package}','{reference_guid}')
SELECT Parameter, ParameterMap, ValueType
FROM def_document_parameters
WHERE Docname LIKE '{doc_name}'
AND Package IN ('{package}', '{archetype}', 'ALL', 'SYSTEM')
SELECT Contexttable, ContextField
FROM def_Document
WHERE DocName = '{doc_name}'
AND Package IN ('{package}', '{archetype}', 'ALL', 'SYSTEM')
INSERT INTO `{table}` (`{context_field}`, `Package`) VALUES ('{guid}', '{package}')
SELECT SimpleUpload
FROM def_document
WHERE docname = '{doc_name}'
AND Package IN ('{package}', 'REFERENCE')
SELECT Datatable
FROM def_Webhook
WHERE Documentmedia = '{doc_name}'
SELECT DocumentMediaPrefix
FROM def_Webhook
WHERE Documentmedia = '{doc_name}'
INSERT INTO {datatable} (Guid) VALUES ('{guid}')
UPDATE {datatable} SET
{dataprefix}_Formattype = '{format_type}',
{dataprefix}_Encodingtype = '{encoding_type}',
{dataprefix}_Channels = '{channels}',
{dataprefix}_Samplespersecond = '{samples_per_second}',
{dataprefix}_Bitspersample = '{bits_per_sample}',
{dataprefix}_Bitspersecond = '{bits_per_second}'
WHERE Guid = '{guid}'
UPDATE `{meta_table}` as D
LEFT JOIN {context_table} as C
ON D.Guid = C.{context_field}
SET {set_clause}
WHERE D.{context_field} = '{guid}'