SQLite format 3@ & .Z   Y : j//etableActivityOperationActivityOperationCREATE TABLE [ActivityOperation]([OperationOrder] INTEGER PRIMARY KEY ASC NOT NULL, [Id] GUID NOT NULL, [OperationType] INT NOT NULL, [AppId] TEXT NOT NULL, [ActivityType] INT NOT NULL, [ParentActivityId] GUID, [Tag] TEXT, [Group] TEXT, [MatchId] TEXT, [LastModifiedTime] DATETIME NOT NULL, [ExpirationTime] DATETIME, [Payload] BLOB, [Priority] INT, [OriginatingDevice] TEXT, [CreatedTime] DATETIME, [Attachments] TEXT, [PlatformDeviceId] TEXT, [ETag] INT NOT NULL, [CreatedInCloud] DATETIME)q##-viewSmartLookupSmartLookupCREATE VIEW [SmartLookup] AS SELECT [O].[Id], [O].[AppId], [O].[ActivityType], [O].[ParentActivityId], [O].[Tag], [O].[Group], [O].[MatchId], [O].[LastModifiedTime], [O].[ExpirationTime], [O].[Payload], [O].[Priority], [O].[OriginatingDevice], [A].[IsLocalOnly], [A].[PlatformDeviceId], [O].[ETag] FROM [ActivityOperation] AS [O] LEFT OUTER JOIN [Activity] AS [A] ON [O].[Id] = [A].[Id] WHERE [O].[OperationType] <> 3 UNION SELECT [Id], [AppId], [ActivityType], [ParentActivityId], [Tag], [Group], [MatchId], [LastModifiedTime], [ExpirationTime], [Payload], [Priority], [OriginatingDevice], [IsLocalOnly], [PlatformDeviceId], [ETag] FROM [Activity] WHERE [Id] NOT IN (SELECT [Id] FROM [ActivityOperation]);O)indexsqlite_autoindex_ManualSequence_1ManualSequence}))5tableManualSequenceManualSequenceCREATE TABLE [ManualSequence]([Key] TEXT PRIMARY KEY NOT NULL, [Value] INT NOT NULL)/Cindexsqlite_autoindex_Metadata_1MetadatactableMetadataMetadataCREATE TABLE [Metadata]([Key] TEXT PRIMARY KEY NOT NULL, [Value] TEXT) =15indexAssetCache_PerAppPerHashActivityAssetCacheCREATE INDEX [AssetCache_PerAppPerHash]ON [ActivityAssetCache]([AppId], [AssetHash])P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq) 11ktableActivityAssetCacheActivityAssetCacheCREATE TABLE [ActivityAssetCache]([ResourceId] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, [AppId] TEXT NOT NULL, [AssetHash] TEXT NOT NULL, [TimeToLive] DATETIME NOT NULL, [AssetUri] TEXT, [AssetId] TEXT, [AssetKey] TEXT, [Contents] BLOB)5I#indexsqlite_autoindex_AppSettings_1AppSettings ##tableAppSettingsAppSettingsCREATE TABLE [AppSettings]([AppId] TEXT PRIMARY KEY NOT NULL, [SettingsPropertyBag] BLOB, [AppTitle] TEXT, [Logo4141] TEXT)| =/indexActivityOperation_PerAppActivityOperation CREATE INDEX [ActivityOperation_PerApp]ON [ActivityOperation]([AppId]) I/5indexActivityOperation_PerOperationActivityOperation CREATE INDEX [ActivityOperation_PerOperation]ON [ActivityOperation]([OperationType]) K/GindexActivityOperation_PerAppPerTypeActivityOperation CREATE INDEX [ActivityOperation_PerAppPerType]ON [ActivityOperation]([AppId], [ActivityType])w ;/indexActivityOpeartion_PerIdActivityOperation CREATE INDEX [ActivityOpeartion_PerId]ON [ActivityOperation]([Id])?/)indexActivityOperation_PerTypeActivityOperation CREATE INDEX [ActivityOperation_PerType]ON [ActivityOperation]([ActivityType])v9#indexActivity_PerAppPerTypeActivityCREATE INDEX [Activity_PerAppPerType]ON [Activity]([AppId], [ActivityType])W+uindexActivity_PerAppActivityCREATE INDEX [Activity_PerApp]ON [Activity]([AppId])a-indexActivity_PerTypeActivityCREATE INDEX [Activity_PerType]ON [Activity]([ActivityType])j1indexActivity_PerDeviceActivityCREATE INDEX [Activity_PerDevice]ON [Activity]([OriginatingDevice])/Cindexsqlite_autoindex_Activity_1ActivitytableActivityActivityCREATE TABLE [Activity]([Id] GUID PRIMARY KEY NOT NULL, [AppId] TEXT NOT NULL, [ActivityType] INT NOT NULL, [ParentActivityId] GUID, [Tag] TEXT, [Group] TEXT, [MatchId] TEXT, [LastModifiedTime] DATETIME NOT NULL, [ExpirationTime] DATETIME, [Payload] BLOB, [Priority] INT, [OriginatingDevice] TEXT, [IsLocalOnly] INT, [PlatformDeviceId] TEXT, [ETag] INT NOT NULL, [CreatedInCloud] DATE                 D+qCurrentSettings{"ActivityTypes":[4,3,2,1,0],"Environment":"prod"} + CurrentSettings  Activity   Activity   I      N[*nzz1//tableActivityOperationActivityOperationCREATE TABLE [ActivityOperation]([OperationOrder] INTEGER PRIMARY KEY ASC NOT NULL, [Id] GUID NOT NULL, [OperationType] INT NOT NULL, [AppId] TEXT NOT NULL, [ActivityType] INT NOT NULL, [ParentActivityId] GUID, [Tag] TEXT, [Group] TEXT, [MatchId] TEXT, [LastModifiedTime] DATETIME NOT NULL, [ExpirationTime] DATETIME, [Payload] BLOB, [Priority] INT, [OriginatingDevice] TEXT, [CreatedTime] DATETIME, [Attachments] TEXT, [PlatformDeviceId] TEXT, [ETag] INT NOT NULL, [CreatedInCloud] DATETIME, [AppActivityId] TEXT)q##-viewSmartLookupSmartLookupCREATE VIEW [SmartLookup] AS SELECT [O].[Id], [O].[AppId], [O].[ActivityType], [O].[ParentActivityId//[tableActivityOperationActivityOperationCREATE TABLE [ActivityOperation]([OperationOrder] INTEGER PRIMARY KEY ASC NOT NULL, [Id] GUID NOT NULL, [OperationType] INT NOT NULL, [AppId] TEXT NOT NULL, [ActivityType] INT NOT NULL, [ParentActivityId] GUID, [Tag] TEXT, [Group] TEXT, [MatchId] TEXT, [LastModifiedTime] DATETIME NOT NULL, [ExpirationTime] DATETIME, [Payload] BLOB, [Priority] INT, [OriginatingDevice] TEXT, [CreatedTime] DATETIME, [Attachments] TEXT, [PlatformDeviceId] TEXT, [ETag] INT NOT NULL, [CreatedInCloud] DATETIME, [AppActivityId] TEXT, [StartTime] DATETIME, [EndTime] DATETIME, [CorrelationVector] TEXT, [LastModifiedOnClient] DATETIME)YtableActivityActivityCREATE TABLE [Activity]([Id] GUID PRIMARY KEY NOT NULL, [AppId] TEXT NOT NULL, [ActivityType] INT NOT NULL, [ParentActivityId] GUID, [Tag] TEXT, [Group] TEXT, [MatchId] TEXT, [LastModifiedTime] DATETIME NOT NULL, [ExpirationTime] DATETIME, [Payload] BLOB, [Priority] INT, [OriginatingDevice] TEXT, [IsLocalOnly] INT, [PlatformDeviceId] TEXT, [ETag] INT NOT NULL, [CreatedInCloud] DATETIME, [AppActivityId] TEXT, [StartTime] DATETIME, [EndTime] DATETIME, [LastModifiedOnClient] DATETIME) x//tableActivityOperationActivityOperationCREATE TABLE [ActivityOperation]([OperationOrder] INTEGER PRIMARY KEY ASC NOT NULL, [Id] GUID NOT NULL, [OperationType] INT NOT NULL, [AppId] TEXT NOT NULL, [ActivityType] INT NOT NULL, [ParentActivityId] GUID, [Tag] TEXT, [Group] TEXT, [MatchId] TEXT, [LastModifiedTime] DATETIME NOT NULL, [ExpirationTime] DATETIME, [Payload] BLOB, [Priority] INT, [OriginatingDevice] TEXT, [CreatedTime] DATETIME, [Attachments] TEXT, [PlatformDeviceId] TEXT, [ETag] INT NOT NULL, [CreatedInCloud] DATETIME, [AppActivityId] TEXT, [StartTime] DATETIME, [EndTime] DATETIME, [CorrelationVector] TEXT) I/5indexActivityOperation_PerOperationActivityOperation CREATE INDEX [ActivityOperation_PerOperation]ON [ActivityOperation]([OperationType]) K/GindexActivityOperation_PerAppPerTypeActivityOperation CREATE INDEX [ActivityOperation_PerAppPerType]ON [ActivityOperation]([AppId], [ActivityType])w ;/indexActivityOpeartion_PerIdActivityOperation CREATE INDEX [ActivityOpeartion_PerId]ON [ActivityOperation]([Id]) ~Y?/)indexActivityOperation_PerTypeActivityOperation CREATE INDEX [ActivityOperation_PerType]ON [ActivityOperation]([ActivityType]) ~9#indexActivity_PerAppPerTypeActivityCREATE INDEX [Activity_PerAppPerType]ON [Activity]([AppId], [ActivityType]) ~Y+uindexActivity_PerAppActivityCREATE INDEX [Activity_PerApp]ON [Activity]([AppId])a-indexActivity_PerTypeActivityCREATE INDEX [Activity_PerType]ON [Activity]([ActivityType])l1indexActivity_PerDeviceActivityCREATE INDEX [Activity_PerDevice]ON [Activity]([OriginatingDevice])/Cindexsqlite_autoindex_Activity_1ActivitytableActivityActivityCREATE TABLE [Activity]([Id] GUID PRIMARY KEY NOT NULL, [AppId] TEXT NOT NULL, [ActivityType] INT NOT NULL, [ParentActivityId] GUID, [Tag] TEXT, [Group] TEXT, [MatchId] TEXT, [LastModifiedTime] DATETIME NOT NULL, [ExpirationTime] DATETIME, [Payload] BLOB, [Priority] INT, [OriginatingDevice] TEXT, [IsLocalOnly] INT, [PlatformDeviceId] TEXT, [ETag] INT NOT NULL, [CreatedInCloud] DATETIME, [AppActivityId] TEXT, [StartTime] DATETIME, [EndTime] DATETIME) a  5 B  U)##viewSmartLookupSmartLookupCREATE VIEW [SmartLookup] AS SELECT [O].[Id], [O].[AppId], [O].[AppActivityId], [O].[ActivityType], [O].[ParentActivityId], [O].[Tag], [O].[Group], [O].[MatchId], [O].[LastModifiedTime], [O].[ExpirationTime], [O].[Payload], [O].[Priority], [O].[OriginatingDevice], [A].[IsLocalOnly], [A].[PlatformDeviceId], [A].[CreatedInCloud], [O].[StartTime], [O].[EndTime], [O].[LastModifiedOnClient], [O].[ETag] FROM [ActivityOperation] AS [O] LEFT OUTER JOIN [Activity] AS [A] ON [O].[Id] = [A].[Id] WHERE [O].[OperationType] <> 3 UNION SELECT [Id], [AppId], [AppActivityId], [ActivityType], [ParentActivityId], [Tag], [Group], [MatchId], [LastModifiedTime], [ExpirationTime], [Payload], [Priority], [OriginatingDevice], [IsLocalOnly], [PlatformDeviceId], [CreatedInCloud], [StartTime], [EndTime], [LastModifiedOnClient], [ETag] FROM [Activity] WHERE [Id] NOT IN (SELECT [Id] FROM [ActivityOperation])"GmindexActivity_PerActivityIdPerTypeActivityCREATE INDEX [Activity_PerActivityIdPerType] ON [Activity]( [AppActivityId], [ActivityType])##-viewSmartLookupSmartLookupCREATE VIEW [SmartLookup] AS SELECT [O].[Id], [O].[AppId], [O].[ActivityType], [O].[ParentActivityId], [O].[Tag], [O].[Group], [O].[MatchId], [O].[LastModifiedTime], [O].[ExpirationTime], [O].[Payload], [O].[Priority], [O].[OriginatingDevice], [A].[IsLocalOnly], [A].[PlatformDeviceId], [O].[ETag] FROM [ActivityOperation] AS [O] LEFT OUTER JOIN [Activity] AS [A] ON [O].[Id] = [A].[Id] WHERE [O].[OperationType] <> 3 UNION SELECT [Id], [AppId], [ActivityType], [ParentActivityId], [Tag], [Group], [MatchId], [LastModifiedTime], [ExpirationTime], [Payload], [Priority], [OriginatingDevice], [IsLocalOnly], [PlatformDeviceId], [ETag] FROM [Activity] WHERE [Id] NOT IN (SELECT [Id] FROM [ActivityOpe;O)indexsqlite_autoindex_ManualSequence_1ManualSequence}))5tableManualSequenceManualSequenceCREATE TABLE [ManualSequence]([Key] TEXT PRIMARY KEY NOT NULL, [Value] INT NOT NULL)/Cindexsqlite_autoindex_Metadata_1MetadatactableMetadataMetadataCREATE TABLE [Metadata]([Key] TEXT PRIMARY KEY NOT NULL, [Value] TEXT) =15indexAssetCache_PerAppPerHashActivityAssetCacheCREATE INDEX [AssetCache_PerAppPerHash]ON [ActivityAssetCache]([AppId], [AssetHash])P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq) 11ktableActivityAssetCacheActivityAssetCacheCREATE TABLE [ActivityAssetCache]([ResourceId] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, [AppId] TEXT NOT NULL, [AssetHash] TEXT NOT NULL, [TimeToLive] DATETIME NOT NULL, [AssetUri] TEXT, [AssetId] TEXT, [AssetKey] TEXT, [Contents] BLOB)5I#indexsqlite_autoindex_AppSettings_1AppSettings ##tableAppSettingsAppSettingsCREATE TABLE [AppSettings]([AppId] TEXT PRIMARY KEY NOT NULL, [SettingsPropertyBag] BLOB, [AppTitle] TEXT, [Logo4141] TEXT)=w3+indexActivity_ExpirationActivityCREATE INDEX [Activity_Expiration] ON [Activity]( [ExpirationTime])