{'Guid': 'VARCHAR(64) NOT NULL PRIMARY KEY', 'Package': "VARCHAR(255) NOT NULL DEFAULT ''", 'TileUuid': 'VARCHAR(128)', 'TileName': 'VARCHAR(128)', 'TileKind': 'VARCHAR(64)', 'TileArchetype': 'VARCHAR(64)', 'Lat': 'DECIMAL(10,7) DEFAULT 0', 'Lng': 'DECIMAL(10,7) DEFAULT 0', 'Altitude': 'DECIMAL(8,1) DEFAULT 0', 'Accuracy': 'DECIMAL(8,1) DEFAULT 0', 'LastTs': 'BIGINT DEFAULT 0', 'LostTs': 'BIGINT DEFAULT 0', 'IsLost': 'TINYINT(1) DEFAULT 0', 'IsDead': 'TINYINT(1) DEFAULT 0', 'Visible': 'TINYINT(1) DEFAULT 1', 'CreateTime': 'DATETIME DEFAULT CURRENT_TIMESTAMP', 'Module': 'VARCHAR(255)'}
INSERT INTO data_tile_location
(Guid, Package, TileUuid, TileName,
TileKind, TileArchetype,
Lat, Lng, Altitude, Accuracy,
LastTs, LostTs,
IsLost, IsDead, Visible, Module)
VALUES
('{guid}', '{package}', '{tile_uuid}',
'{tile_name}', '{tile_kind}', '{tile_archetype}',
{lat}, {lng}, {altitude}, {accuracy},
{last_ts}, {lost_ts},
{is_lost}, {is_dead}, {visible},
'ObjServiceTile')
SELECT TileName, TileKind, Lat, Lng,
Accuracy, IsLost, IsDead, CreateTime
FROM data_tile_location WHERE Package = '{package}'
AND TileUuid = '{tile_uuid}'
ORDER BY CreateTime DESC LIMIT 1
SELECT t1.TileName, t1.TileKind, t1.TileArchetype,
t1.Lat, t1.Lng, t1.Accuracy,
t1.IsLost, t1.IsDead, t1.CreateTime
FROM data_tile_location t1 INNER JOIN (
SELECT TileUuid, MAX(CreateTime) AS MaxTime
FROM data_tile_location
WHERE Package = '{package}'
GROUP BY TileUuid
) t2 ON t1.TileUuid = t2.TileUuid
AND t1.CreateTime = t2.MaxTime
ORDER BY t1.TileName