{'Guid': 'VARCHAR(64) NOT NULL PRIMARY KEY', 'Package': 'VARCHAR(255) NOT NULL', 'Provider': "VARCHAR(32) NOT NULL DEFAULT 'google'", 'SourceTable': 'VARCHAR(128) NOT NULL', 'SourceKey': 'VARCHAR(128) NOT NULL', 'ExternalId': 'VARCHAR(128) NOT NULL', 'ExternalType': "VARCHAR(32) NOT NULL DEFAULT 'file'", 'SyncStatus': "VARCHAR(32) DEFAULT 'synced'", 'SyncedAt': 'DATETIME DEFAULT CURRENT_TIMESTAMP', 'CreateTime': 'DATETIME DEFAULT CURRENT_TIMESTAMP', 'UpdateTime': 'DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP'}
INSERT INTO def_integration_sync
(Guid, Package, Provider, SourceTable,
SourceKey, ExternalId, ExternalType,
SyncStatus, SyncedAt)
VALUES
('{guid}', '{package}', '{provider}',
'{source_table}', '{source_key}',
'{external_id}', '{external_type}',
'synced', NOW())
ON DUPLICATE KEY UPDATE
ExternalId = VALUES(ExternalId),
ExternalType = VALUES(ExternalType),
SyncStatus = VALUES(SyncStatus),
SyncedAt = NOW()
SELECT ExternalId FROM def_integration_sync WHERE Package = '{package}'
AND Provider = 'google'
AND SourceTable = '{source_table}'
AND SourceKey = '{source_key}'
LIMIT 1
SELECT SourceKey FROM def_integration_sync WHERE Package = '{package}'
AND Provider = 'google'
AND ExternalId = '{external_id}'
LIMIT 1
SELECT SourceTable, SourceKey,
ExternalId, ExternalType,
SyncStatus, SyncedAt
FROM def_integration_sync WHERE Package = '{package}'
AND Provider = 'google'
ORDER BY SyncedAt DESC
SELECT SourceKey, ExternalId,
ExternalType, SyncStatus, SyncedAt
FROM def_integration_sync WHERE Package = '{package}'
AND Provider = 'google'
AND SourceTable = '{source_table}'
ORDER BY SyncedAt DESC