SQLite format 3@ - = n   iz=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])}))5tableManualSequenceManualSequenceCREATE TABLE [ManualSequence]([Key] TEXT PRIMARY KEY NOT NULL, [Value] INT NOT NULL);O)indexsqlite_autoindex_ManualSequence_1ManualSequencectableMetadataMetadataCREATE TABLE [Metadata]([Key] TEXT PRIMARY KEY NOT NULL, [Value] TEXT)/Cindexsqlite_autoindex_Metadata_1Metadata =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) ##tableAppSettingsAppSettingsCREATE TABLE [AppSettings]([AppId] TEXT PRIMARY KEY NOT NULL, [SettingsPropertyBag] BLOB, [AppTitle] TEXT, [Logo4141] TEXT)5I#indexsqlite_autoindex_AppSettings_1AppSettings| =/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])///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)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])atableActivityActivityCREATE 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)/Cindexsqlite_autoindex_Activity_1Activity                     Activity   Activityx

Windows NT KPTV 6.2 build 9200 (Windows Server 2012 Datacenter Edition) i586