{'Client': 'VARCHAR(255)', 'Folder': 'VARCHAR(512) NOT NULL', 'Filename': 'VARCHAR(255) NOT NULL', 'DocType': 'VARCHAR(16)', 'Loadtime': 'DATETIME DEFAULT CURRENT_TIMESTAMP', 'Content': 'LONGTEXT', 'ContentSentence': 'LONGTEXT', 'ContentTokens': 'LONGTEXT', 'Module': 'VARCHAR(255)', 'PRIMARY_KEY': 'Folder(191), Filename(191), DocType'}
SELECT DocType FROM bloom_filefeed WHERE Folder = '{folder}'
AND Filename = '{filename}'
AND DocType = '{doc_type}'
REPLACE INTO bloom_filefeed
(Client, Folder, Filename, DocType,
Loadtime, Content, Module)
VALUES
('{client}', '{folder}', '{filename}',
'{doc_type}', NOW(), '{content}',
'ObjServiceFilefeed')
UPDATE bloom_filefeed SET ContentSentence = '{sentences}',
ContentTokens = '{tags}'
WHERE Folder = '{folder}'
AND Filename = '{filename}'
AND DocType = '{doc_type}'
SELECT Content, ContentSentence, ContentTokens FROM bloom_filefeed WHERE Folder = '{folder}'
AND Filename = '{filename}'
SELECT Client, Folder, Filename, DocType, Loadtime FROM bloom_filefeed WHERE Client = '{client}' ORDER BY Loadtime DESC
SELECT Client, Folder, Filename, DocType, Loadtime FROM bloom_filefeed ORDER BY Loadtime DESC LIMIT {limit}