{'Guid': 'VARCHAR(64) NOT NULL PRIMARY KEY', 'Package': "VARCHAR(255) NOT NULL DEFAULT ''", 'NotifTimestamp': 'DATETIME', 'Device': 'VARCHAR(64)', 'App': 'VARCHAR(128)', 'Message': 'TEXT', 'Category': 'VARCHAR(32)', 'Subcategory': 'VARCHAR(64)', 'Priority': 'VARCHAR(16)', 'Action': 'VARCHAR(64)', 'CreateTime': 'DATETIME DEFAULT CURRENT_TIMESTAMP', 'Module': 'VARCHAR(255)'}
{'Package': 'VARCHAR(255) NOT NULL', 'Device': 'VARCHAR(64) NOT NULL', 'LastLine': 'INT DEFAULT 0', 'UpdateTime': 'DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP', 'PRIMARY_KEY': 'Package, Device'}
SELECT LastLine FROM data_notification_marker WHERE Package = '{package}'
AND Device = '{device}'
INSERT INTO data_notification_marker
(Package, Device, LastLine)
VALUES
('{package}', '{device}', {last_line})
ON DUPLICATE KEY UPDATE
LastLine = {last_line}
INSERT INTO data_notification
(Guid, Package, NotifTimestamp, Device, App,
Message, Category, Subcategory,
Priority, Action, Module)
VALUES
('{guid}', '{package}', '{notif_ts}',
'{device}', '{app}', '{message}',
'{category}', '{subcategory}',
'{priority}', '{action}',
'ObjServiceNotification')