SQLite format 3 @ .[3 � ��K
� ��Q��RJ �$W-�QindexSymbolDefinition_DefiningFileId_IndexSymbolDefinitionCREATE INDEX [SymbolDefinition_DefiningFileId_Index]
ON [SymbolDefinition] ([DefiningFileId])�
C-�GindexSymbolDefinition_Name_IndexSymbolDefinitionCREATE INDEX [SymbolDefinition_Name_Index]
ON [SymbolDefinition] ([Name] COLLATE NOCASE)�=--�-tableSymbolDefinitionSymbolDefinition
CREATE TABLE [SymbolDefinition]
(
[SymbolDefinitionId] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
[ProviderId] INTEGER NOT NULL
REFERENCES [ProviderEntity]([ProviderId])
ON UPDATE CASCADE
ON DELETE CASCADE,
[Name] NVARCHAR(255) NOT NULL COLLATE NOCASE,
[FullyQualifiedName] NVARCHAR(255) COLLATE NOCASE,
[Kind] INTEGER NOT NULL,
[Accessibility] INTEGER NOT NULL,
[DefiningFileId] INTEGER NOT NULL
REFERENCES [FileSystemEntity]([FileSystemEntityId])
ON UPDATE CASCADE
ON DELETE CASCADE,
[LocationRow] INTEGER NOT NULL,
[LocationColumn] INTEGER NOT NULL
)�/_-�_indexFileScannerCache_FileSystemEntityId_IndexFileScannerCacheCREATE INDEX [FileScannerCache_FileSystemEntityId_Index]
ON [FileScannerCache]([FileSystemEntityId])�U
--�]tableFileScannerCacheFileScannerCacheCREATE TABLE [FileScannerCache]
(
[FileScannerCacheId] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
[FileSystemEntityId] INTEGER NOT NULL REFERENCES [FileSystemEntity]([FileSystemEntityId])
ON UPDATE CASCADE
ON DELETE CASCADE,
[ProviderId] INTEGER NOT NULL REFERENCES [ProviderEntity]([ProviderId])
ON DELETE CASCADE,
[Type] INTEGER NOT NULL,
[Timestamp] DATETIME NULL
)�- /)�indexProviderType_TypeProviderEntity
CREATE UNIQUE INDEX [ProviderType_Type]
ON [ProviderEntity] ([ProviderType] COLLATE NOCASE,[ProviderVersion] COLLATE NOCASE)� ))�;tableProviderEntityProviderEntity CREATE TABLE [ProviderEntity]
(
[ProviderId] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
[ProviderType] NVARCHAR(20) NOT NULL COLLATE NOCASE,
[ProviderVersion] NVARCHAR(20) NOT NULL COLLATE NOCASE
)�:E-�indexFileSystemEntity_Parent_NameFileSystemEntityCREATE UNIQUE INDEX [FileSystemEntity_Parent_Name]
ON [FileSystemEntity] ([Name] COLLATE NOCASE, [ParentFileSystemEntityId])�Bk-�yindexFileSystemEntity_ParentFileSystemEntityId_IndexFileSystemEntityCREATE INDEX [FileSystemEntity_ParentFileSystemEntityId_Index]
ON [FileSystemEntity] ([ParentFileSystemEntityId])�C-�GindexFileSystemEntity_Name_IndexFileSystemEntityCREATE INDEX [FileSystemEntity_Name_Index]
ON [FileSystemEntity] ([Name] COLLATE NOCASE)�H--�CtableFileSystemEntityFileSystemEntityCREATE TABLE [FileSystemEntity]
(
[FileSystemEntityId] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
[Name] NVARCHAR(255) NOT NULL COLLATE NOCASE,
[ParentFileSystemEntityId] INTEGER NULL
REFERENCES [FileSystemEntity]([FileSystemEntityId])
ON UPDATE CASCADE
ON DELETE CASCADE,
[IsFile] BIT NOT NULL,
[LastObserved] DATETIME NOT NULL DEFAULT current_timestamp
)o1�indexSetting_Name_IndexSettingCREATE INDEX [Setting_Name_Index]
ON [Setting] ([Name] COLLATE NOCASE)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)�G�etableSettingSettingCREATE TABLE [Setting]
(
[SettingId] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
[Name] NVARCHAR(255) NOT NULL COLLATE NOCASE,
[Value] NVARCHAR(255) NU
&