-- Identify native-app analytics explicitly and keep the latest visible screen on each active session.
ALTER TABLE `AnalyticsSession`
    ADD COLUMN `clientType` VARCHAR(191) NOT NULL DEFAULT 'web',
    ADD COLUMN `appVersion` VARCHAR(191) NULL,
    ADD COLUMN `currentPath` VARCHAR(191) NULL,
    ADD COLUMN `currentTitle` VARCHAR(191) NULL;

ALTER TABLE `AnalyticsPageView`
    ADD COLUMN `clientType` VARCHAR(191) NOT NULL DEFAULT 'web',
    ADD COLUMN `appVersion` VARCHAR(191) NULL;

CREATE INDEX `AnalyticsSession_clientType_lastSeenAt_idx`
    ON `AnalyticsSession`(`clientType`, `lastSeenAt`);

CREATE INDEX `AnalyticsPageView_clientType_createdAt_idx`
    ON `AnalyticsPageView`(`clientType`, `createdAt`);