File: C:/Users/fred/AppData/Local/Microsoft/Windows/Notifications/wpndatabase.db
SQLite format 3 @ 8 � � 8 .�� � W�
�A ��:
�
? � G�Z����ST�� � �'%%�tableNotificationNotificationCREATE TABLE [Notification]( [Order] INTEGER NOT NULL PRIMARY KEY, [Id] INTEGER NOT NULL, [HandlerId] INTEGER CONSTRAINT[NotificationToHandler] REFERENCES[NotificationHandler]([RecordId]) ON DELETE CASCADE ON UPDATE CASCADE, [ActivityId] GUID,[Type] TEXT NOT NULL, [Payload] BLOB, [Tag] TEXT, [Group] TEXT, [ExpiryTime] INT64, [ArrivalTime] INT64, [DataVersion] INT64 DEFAULT '0', [PayloadType] TEXT NOT NULL, [BootId] INT64 DEFAULT '0', [ExpiresOnReboot] BOOLEAN DEFAULT 'FALSE', UNIQUE([Id]) ON CONFLICT REPLACE)�9''�1tableHandlerAssetsHandlerAssetsCREATE TABLE [HandlerAssets]( [HandlerId] INTEGER CONSTRAINT[AssetsToHandler] REFERENCES[NotificationHandler]([RecordId]) ON DELETE CASCADE ON UPDATE CASCADE, [AssetKey] TEXT NOT NULL, [AssetValue] TEXT, CONSTRAINT[] PRIMARY KEY([AssetKey], [HandlerId]) ON CONFLICT REPLACE)9M' indexsqlite_autoindex_HandlerAssets_1HandlerAssets�3--�tableNotificationDataNotificationDataCREATE TABLE [NotificationData]( [NotificationId] INTEGER CONSTRAINT[DataToNotification] REFERENCES[Notification]([Id]) ON DELETE CASCADE ON UPDATE CASCADE, [Key] TEXT NOT NULL, [Value] TEXT, CONSTRAINT[] PRIMARY KEY([Key], [NotificationId]) ON CONFLICT REPLACE)?S- indexsqlite_autoindex_NotificationData_1NotificationData��]tableMetadataMetadataCREATE TABLE [Metadata]( [Key] TEXT, [Value] INT64, CONSTRAINT[] PRIMARY KEY([Key]) ON CONFLICT REPLACE)/C indexsqlite_autoindex_Metadata_1Metadatan))�indexchannelExpiredWNSPushChannelCREATE INDEX [channelExpired] ON [WNSPushChannel] ([ExpiryTime] DESC)d%)�indexchannelByAppWNSPushChannelCREATE INDEX [channelByApp] ON [WNSPushChannel] ([HandlerId])�7))�)tableWNSPushChannelWNSPushChannelCREATE TABLE [WNSPushChannel]( [ChannelId] TEXT NOT NULL, [HandlerId] INTEGER REFERENCES[NotificationHandler]([RecordId]) ON DELETE CASCADE ON UPDATE CASCADE, [Uri] TEXT, [ExpiryTime] INT64, [CreatedTime] INT64, CONSTRAINT[] PRIMARY KEY([ChannelId]) ON CONFLICT REPLACE);O) indexsqlite_autoindex_WNSPushChannel_1WNSPushChannelt3%�indexnotificationExpiredNotificationCREATE INDEX [notificationExpired] ON [Notification] ([ExpiryTime] DESC)g
1%�indexnotificationByTypeNotificationCREATE INDEX [notificationByType] ON [Notification] ([Type])�9%�GindexnotificationByTagGroupNotification
CREATE INDEX [notificationByTagGroup] ON [Notification] ([HandlerId], [Type], [Group], [Tag])~;%�)indexnotificationByAppByTypeNotificationCREATE INDEX [notificationByAppByType] ON [Notification] ([HandlerId], [Type])y
=%�indexnotificationByActivityIdNotificationCREATE INDEX [notificationByActivityId] ON [Notification] ([ActivityId])j /%�
indexnotificationByAppNotification
CREATE INDEX [notificationByApp] ON [Notification] ([HandlerId])`-%}indexnotificationByIdNotification CREATE INDEX [notificationById] ON [Notification] ([Id])7K% indexsqlite_autoindex_Notification_1Notificationi+�indexbySettingHandlerSettingsCREATE INDEX [bySetting] ON[HandlerSettings] ([SettingKey], [Value])�?++�5tableHandlerSettingsHandlerSettingsCREATE TABLE [HandlerSettings]( [HandlerId] INTEGER CONSTRAINT[SettingsToHandler] REFERENCES[NotificationHandler]([RecordId]) ON DELETE CASCADE ON UPDATE CASCADE, [SettingKey] TEXT NOT NULL, [Value] INT, CONSTRAINT[] PRIMARY KEY([SettingKey], [HandlerId]) ON CONFLICT REPLACE)=Q+ indexsqlite_autoindex_HandlerSettings_1HandlerSettingsw'3�!indexbyHandlerNameNotificationHandlerCREATE UNIQUE INDEX [byHandlerName] ON [NotificationHandler] ([PrimaryId])�W33�UtableNotificationHandlerNotificationHandlerCREATE TABLE [NotificationHandler] ( [RecordId] INTEGER PRIMARY KEY, [PrimaryId] TEXT NOT NULL COLLATE NOCASE, [WNSId] TEXT COLLATE NOCASE, [HandlerType] TEXT, [WNFEventName] INT64, [SystemDataPropertySet] BLOB, [CreatedTime] DATETIME, [ModifiedTime] DATETIME, [ParentId] TEXT COLLATE NO V
� t������u�H
�
}
� `��,�X��/�k�I�|�B��"