SQLite format 3 @ -ýq û û v r
|
ÄìVrÍ ã Û
g 33utableFileSystemReferenceFileSystemReferenceCREATE TABLE [FileSystemReference]
|
(
|
[FileSystemReferenceEntityId] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
|
[ProviderId] INTEGER NOT NULL REFERENCES [ProviderEntity]([ProviderId])
|
ON DELETE CASCADE,
|
[DependantFileId] INTEGER NOT NULL REFERENCES [FileSystemEntity]([FileSystemEntityId])
|
ON UPDATE CASCADE
|
ON DELETE CASCADE,
|
[ReferenceFileId] INTEGER NULL REFERENCES [FileSystemEntity]([FileSystemEntityId])
|
ON UPDATE CASCADE
|
ON DELETE CASCADE,
|
[ReferenceFilePath] TEXT NULL COLLATE NOCASE,
|
[Target] NVARCHAR(255) NULL COLLATE NOCASE,
|
[Context] NVARCHAR(255) NULL COLLATE NOCASE,
|
[Type] INTEGER NULL
|
)" W-MindexSymbolDefinition_DefiningFileId_IndexSymbolDefinition CREATE INDEX [SymbolDefinition_DefiningFileId_Index]
|
ON [SymbolDefinition] ([DefiningFileId]) C-CindexSymbolDefinition_Name_IndexSymbolDefinition CREATE INDEX [SymbolDefinition_Name_Index]
|
ON [SymbolDefinition] ([Name] COLLATE NOCASE)
|
--StableSymbolDefinitionSymbolDefinition CREATE TABLE [SymbolDefinition]
|
(
|
[SymbolDefinitionId] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
|
[ProviderId] INTEGER NOT NULL REFERENCES [ProviderEntity]([ProviderId])
|
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
|
)8 E- indexFileSystemEntity_Parent_NameFileSystemEntity
|
CREATE UNIQUE INDEX [FileSystemEntity_Parent_Name]
|
ON [FileSystemEntity] ([Name] COLLATE NOCASE, [ParentFileSystemEntityId])C-CindexFileSystemEntity_Name_IndexFileSystemEntity CREATE INDEX [FileSystemEntity_Name_Index]
|
ON [FileSystemEntity] ([Name] COLLATE NOCASE)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_TypeProviderEntityCREATE UNIQUE INDEX [ProviderType_Type]
|
ON [ProviderEntity] ([ProviderType] COLLATE NOCASE,[ProviderVersion] COLLATE NOCASE)))=tableProviderEntityProviderEntityCREATE TABLE [ProviderEntity]
|
(
|
[ProviderId] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
|
[ProviderType] NVARCHAR(20) NOT NULL COLLATE NOCASE,
|
[ProviderVersion] NVARCHAR(20) NOT NULL COLLATE NOCASE
|
)y--%tableFileSystemEntityFileSystemEntityCREATE TABLE [FileSystemEntity]
|
(
|
[FileSystemEntityId] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
|
[Name] NVARCHAR(255) NOT NULL COLLATE NOCASE,
|
[ParentFileSystemEntityId] INTEGER NULL,
|
[IsFile] BIT NOT NULL,
|
[LastObserved] DATETIME NOT NULL DEFAULT current_timestamp,
|
FOREIGN KEY ([ParentFileSystemEntityId])
|
REFERENCES [FileSystemEntity]([FileSystemEntityId])
|
ON UPDATE CASCADE
|
ON DELETE CASCADE
|
)o1 indexSetting_Name_IndexSettingCREATE INDEX [Setting_Name_Index]
|
ON [Setting] ([Name] COLLATE NOCASE)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)HgtableSettingSettingCREATE TABLE [Setting]
|
(
|
[SettingId] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
|
[Name] NVARCHAR(255) NOT NULL COLLATE NOCASE,
|
[Value] NVARCHAR(255) NU
|
¾ 迧¾ f ;!LastIndexSymbolScanners00000000-0000-0000-0000-000000000000-0a1d9874-b448-11d9-bd50-000d93b6e43c-17994ec8-6b1d-11d9-ac3a-000d93589af6-1ba72668-707c-11d9-a928-000d93589af6-25066dc2-6b1d-11d9-9d5b-000d93589af6-26251b18-6b1d-11d9-afdb-000d93589af6-2b449df6-6b1d-11d9-94ec-000d93589af6-3eec062c-1463-4780-a3cd-e651e09576e3-4b32c687-281c-4c6d-a2a1-3d874bfa2d4d-5b520980-a7d5-4e10-8582-1a4c889a8de5-69aa0917-b7bb-11d9-a7e2-000d93c8be28-6a87759f-f746-4e84-b788-965b46363202-77dc23b6-8a90-11d9-baa4-000a9584ec8c-7aed2d59-22d9-41c8-ba9e-4f178191e380-7b3bd5d3-8362-427d-89a4-742f2e2256c2-7f9c9343-d48e-4e7d-bfe8-f680714dcd3e-805375ec-d614-41f5-8993-5843fe63ea82-8f97457b-516e-48ce-83c7-08ae12fb327a-9343d324-75a1-4733-a5c0-5d1d4b6182d0-93e017cc-6f27-11d9-90eb-000d93589af7-9bf89b9c-e9dc-4073-a236-3e7b278f51c7-a39d8795-59d2-49af-aa00-fe74ee29576e-b0c44228-4f1f-11da-aff2-000a95af0064-b2e6b78d-6e70-11d9-a369-000d93b3a10e-b3a64888-ebbb-4436-8d9e-f1169c5d7613-b545774b-6d11-4f08-bb0a-e64cccc9528c-c49120ac-6ecc-11d9-acc8-000d93589af6-c62867cc-67a8-49c6-a9d0-2bef369d8bf7-cbf48547-0be6-4cd2-832c-c12df35dee99-d3c4e6da-6b1c-11d9-8cc2-000d93589af6-d9212c5d-975a-49e6-a753-2f586bfbf077-db8033a1-6d8e-4d80-b8a2-8768aac6125d-dd867abf-1ec6-415d-b047-687f550a1d51-ddeea3ed-6b1c-11d9-8b10-000d93589af6-dfc75919-8da2-4b4c-bd45-165d2bcf6f61-e00b62ac-6b1c-11d9-9b1f-000d93589af6-e07ec438-7b75-4437-8aa1-da94c1e6eacc-e685440c-0e20-4424-9693-864d5240a269-ed814497-3055-46c1-9fe0-586cc9530310-edbfe125-6b1c-11d9-9189-000d93589af6-eee6ba25-6ac2-4f7e-9c70-cddf2bd3448b-ef98eb90-bf9b-11e4-bb52-0800200c9a66-f23db5b2-7d08-11d9-a709-000d93b6e43c-f7de61e2-bdde-4e2a-a139-8221b179584e-f85cc716-6b1c-11d9-9a20-000d93589af6-f8f5ffb0-503e-11df-9879-0800200c9a66-ff1825e8-6b1c-11d9-b883-000d93589af6 /IndexProcessCount1' -3CreatedOrUpdated09/21/2017 00:38:48 'SchemaVersion1.3.4 óÝ³Ç -SymbolDefinition>)ProviderEntity-FileScannerCache -FileSystemEntity Setting
|
¨ ÚĨï ;LastIndexSymbolScanners/IndexProcessCount-CreatedOrUpdated' SchemaVersion æ̱tX?+ ëˤfC & = npm-debug.log.2437637916Õ ÄöZpy! 1 test_weekofyear.shÕ ÃÕyT"! 1 test_weekofyear.jsÕ ÃÕyT" !weekofyear Õ ÃÕyT"% 9 test_isoutcdatetime.js Õ ÃÕyT" + test_formats.js Õ ÃÕyT" / test_dayofweek.js Õ ÃÕyT"
|
' dateformat.jsÕ ÃÕyT" testÕ ÃÕyT" Readme.mdÕ ÃÕyT" % package.jsonÕ ÃÕyT" LICENSEÕ ÃÕyT" libÕ ÃÕyT" .vsÕ ÃÕyT" # .travis.ymlÕ ÃÕyT" ! .npmignoreÕ ÃÕyT" ! .gitignoreÕ ÃÕyT" ÷ Ëa,÷ 3 U#ddeea3ed-6b1c-11d9-8b10-000d93589af61.1.70630.13 U#805375ec-d614-41f5-8993-5843fe63ea821.1.70630.13 U#0a1d9874-b448-11d9-bd50-000d93b6e43c1.1.70630.13 U#8f97457b-516e-48ce-83c7-08ae12fb327a1.1.70630.13 U#b0c44228-4f1f-11da-aff2-000a95af00641.1.70630.1
|
ø b-Ìø 4U#ddeea3ed-6b1c-11d9-8b10-000d93589af61.1.70630.14U#805375ec-d614-41f5-8993-5843fe63ea821.1.70630.14U#0a1d9874-b448-11d9-bd50-000d93b6e43c1.1.70630.14U#8f97457b-516e-48ce-83c7-08ae12fb327a1.1.70630.13U# b0c44228-4f1f-11da-aff2-000a95af00641.1.70630.1 V îÛȵ¢|iV Õ ÃÖ.ë Õ ÃÖ)q Õ ÃÖ&SX Õ ÃÖ&SX
|
Õ ÃÖ¸O Õ ÃÖUû Õ ÃÕáí Õ Äû§q Õ ÃÕÂvF
|
Þ òãÓË}÷ަgS8û) =npm-debug.log.24376379161test_weekofyear.sh1test_weekofyear.js!weekofyear9test_isoutcdatetime.js +test_formats.js /test_dayofweek.js 'dateformat.js
|
test Readme.md%package.json LICENSElib.vs#.travis.yml!.npmignore ! .gitignore
|
Æ ñáÐÇr¾±ÆZD'ýä = npm-debug.log.24376379161test_weekofyear.sh1test_weekofyear.js!weekofyear 9test_isoutcdatetime.js +test_formats.js /test_dayofweek.js 'dateformat.js
|
test Readme.md% package.json LICENSE lib .vs# .travis.yml! .npmignore! .gitignore >Ì à˲fM0 ḡs\E. é Ñ ° o V = û Ñ º { [ = ã ¼ £ f O (
|
û
|
Ô
|
½
|
¦
|
|
m
|
X
|
?
|
ë Ä x _ J 1 åÌ >
|
donedone J%=
|
##strictEqualstrictEqual I #<
|
!!dateFormatdateFormat G;
|
DateDate E:
|
itit D9
|
donedone A%8
|
##strictEqualstrictEqual @#7
|
!!dateFormatdateFormat ?%6
|
##toISOStringtoISOString = %5
|
##parseOffsetparseOffset :+4
|
))timezoneOffsettimezoneOffset 53
|
DateDate 42
|
itit 31
|
eacheach 2 0
|
describedescribe 1/
|
padpad ./.
|
padpad .%-
|
##parseOffsetparseOffset -+,
|
))timezoneOffsettimezoneOffset ,
|
%+
|
##parseOffsetparseOffset
|
*
|
padpad
|
#)
|
!!dateFormatdateFormat (
|
DateDate"'
|
donedone %&
|
##strictEqualstrictEqual #%
|
!!dateFormatdateFormat $
|
itit #
|
describedescribe "
|
definedefine
|
Ý !
|
isArrayisArray
|
Ò
|
kindOfkindOf
|
Å
|
|
{String}{String}
|
Ã
|
{*}{*}
|
 (
|
%%getDayOfWeekgetDayOfWeek
|
¸
|
|
{Number}{Number}
|
¶
|
{Object}{Object}
|
µ
|
DateDate
|
£
|
DateDate
|
|
getWeekgetWeek
|
|
|
{Number}{Number}
|
|
{Object}{Object}
|
|
padpad
|
|
|
padpad
|
\'
|
padpad
|
V
|
padpad
|
U
|
padpad
|
T
|
padpad
|
R
|
padpad
|
P
|
padpad
|
N
|
padpad
|
H
|
padpad
|
D'
|
%%getDayOfWeekgetDayOfWeek
|
A
|
|
getWeekgetWeek
|
@
|
DateDate
|
#
|
DateDate
|
|
kindOfkindOf
|
'
|
donedone %
|
##strictEqualstrictEqual #
|
!!dateFormatdateFormat
|
|
DateDate
|
itit
|
describedescribe
|
> @ ä¨úS Ó hÕuD Yô ì¼\ x @ ãÏ £í Ü q±¯zrjbZRJB:2< ù, °Åe I À Çà%íº done>#strictEqual=!dateFormat<Date;it:done9#strictEqual8!dateFormat7#toISOString6#parseOffset5)timezoneOffset4Date3it2each1 describe0pad/pad.#parseOffset-)timezoneOffset,#parseOffset+pad*!dateFormat)Date(done'#strictEqual&!dateFormat%it$ describe#
|
define" isArray!
|
kindOf {String} {*} %getDayOfWeek {Number} {Object}DateDate getWeek {Number} {Object}padpadpadpadpadpadpadpadpad pad %getDayOfWeek getWeek
|
Date Date
|
kindOfdone#strictEqual!dateFormatDateit describe
|
> ×ÑËÅ¿¹³§¡}wqke_YSMGA;5ûõïéãÝÿùóíçáÛÕÏÉý·±«¥/)# > = < ; : 9 8 7 6 5 4 3 2 1 0 / . - , + *)( ' & % $ #
|
"
|
!
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
5ãr v r
|
ÄìVrÍ ã Û
g 33
g 33utableFileSystemReferenceFileSystemReferenceCREATE TABLE [FileSystemReference]
|
(
|
[FileSystemReferenceEntityId] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
|
[ProviderId] INTEGER NOT NULL REFERENCES [ProviderEntity]([ProviderId])
|
ON DELETE CASCADE,
|
[DependantFileId] INTEGER NOT NULL REFERENCES [FileSystemEntity]([FileSystemEntityId])
|
ON UPDATE CASCADE
|
ON DELETE CASCADE,
|
[ReferenceFileId] INTEGER NULL REFERENCES [FileSystemEntity]([FileSystemEntityId])
|
ON UPDATE CASCADE
|
ON DELETE CASCADE,
|
[ReferenceFilePath] TEXT NULL COLLATE NOCASE,
|
[Target] NVARCHAR(255) NULL COLLATE NOCASE,
|
[Context] NVARCHAR(255) NULL COLLATE NOCASE,
|
[Type] INTEGER NULL
|
)" W-MindexSymbolDefinition_DefiningFileId_IndexSymbolDefinition CREATE INDEX [SymbolDefinition_DefiningFileId_Index]
|
ON [SymbolDefinition] ([DefiningFileId]) C-CindexSymbolDefinition_Name_IndexSymbolDefinition CREATE INDEX [SymbolDefinition_Name_Index]
|
ON [SymbolDefinition] ([Name] COLLATE NOCASE)
|
--StableSymbolDefinitionSymbolDefinition CREATE TABLE [SymbolDefinition]
|
(
|
[SymbolDefinitionId] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
|
[ProviderId] INTEGER NOT NULL REFERENCES [ProviderEntity]([ProviderId])
|
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
|
)8 E- indexFileSystemEntity_Parent_NameFileSystemEntity
|
CREATE UNIQUE INDEX [FileSystemEntity_Parent_Name]
|
ON [FileSystemEntity] ([Name] COLLATE NOCASE, [ParentFileSystemEntityId])C-CindexFileSystemEntity_Name_IndexFileSystemEntity CREATE INDEX [FileSystemEntity_Name_Index]
|
ON [FileSystemEntity] ([Name] COLLATE NOCASE)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_TypeProviderEntityCREATE UNIQUE INDEX [ProviderType_Type]
|
ON [ProviderEntity] ([ProviderType] COLLATE NOCASE,[ProviderVersion] COLLATE NOCASE)))=tableProviderEntityProviderEntityCREATE TABLE [ProviderEntity]
|
(
|
[ProviderId] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
|
[ProviderType] NVARCHAR(20) NOT NULL COLLATE NOCASE,
|
[ProviderVersion] NVARCHAR(20) NOT NULL COLLATE NOCASE
|
)y--%tableFileSystemEntityFileSystemEntityCREATE TABLE [FileSystemEntity]
|
(
|
[FileSystemEntityId] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
|
[Name] NVARCHAR(255) NOT NULL COLLATE NOCASE,
|
[ParentFileSystemEntityId] INTEGER NULL,
|
[IsFile] BIT NOT NULL,
|
[LastObserved] DATETIME NOT NULL DEFAULT current_timestamp,
|
FOREIGN KEY ([ParentFileSystemEntityId])
|
REFERENCES [FileSystemEntity]([FileSystemEntityId])
|
ON UPDATE CASCADE
|
ON DELETE CASCADE
|
)o1 indexSetting_Name_IndexSettingCREATE INDEX [Setting_Name_Index]
|
ON [Setting] ([Name] COLLATE NOCASE)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)HgtableSettingSettingCREATE TABLE [Setting]
|
(
|
[SettingId] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
|
[Name] NVARCHAR(255) NOT NULL COLLATE NOCASE,
|
[Value] NVARCHAR(255) NULL
|
) § jÅ Û hº§ --WviewFullPathEntitiesFullPathEntitiesCREATE VIEW FullPathEntities as
|
WITH RECURSIVE FullPathEntities AS(
|
SELECT FileSystemEntityId AS BaseSystemEntityId, ParentFileSystemEntityId AS CurrentParentEntityId, Name AS CurrentPath FROM FileSystemEntity
|
UNION
|
SELECT
|
P.BaseSystemEntityId,
|
FS.ParentFileSystemEntityId AS CurrentParentEntityId,
|
FS.Name || '\' || P.CurrentPath AS CurrentPath
|
FROM FullPathEntities AS P
|
INNER JOIN FileSystemEntity AS FS ON
|
FS.FileSystemEntityId = P.CurrentParentEntityId
|
)
|
SELECT FS.*,P.CurrentPath As FullPath
|
FROM FullPathEntities AS P
|
INNER JOIN FileSystemEntity AS FS ON FS.FileSystemEntityId = P.BaseSystemEntityId
|
WHERE CurrentParentEntityId IS NULL+Y)aindexFileSystemData_FileSystemEntityId_TypeFileSystemDataCREATE INDEX [FileSystemData_FileSystemEntityId_Type]
|
ON [FileSystemData] ([FileSystemEntityId],[Type])p))tableFileSystemDataFileSystemDataCREATE TABLE [FileSystemData]
|
(
|
[FileSystemDataId] 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] NVARCHAR(20) NOT NULL COLLATE NOCASE,
|
[Name] NVARCHAR(255) NOT NULL COLLATE NOCASE,
|
[Value] TEXT NULL,
|
[Target] NVARCHAR(255) NULL COLLATE NOCASE,
|
[Context] NVARCHAR(255) NULL COLLATE NOCASE
|
)
g 33utableFileSystemReferenceFileSystemReferenceCREATE TABLE [FileSystemReference]
|
(
|
[FileSystemReferenceEntityId] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
|
[ProviderId] INTEGER NOT NULL REFERENCES [ProviderEntity]([ProviderId])
|
ON DELETE CASCADE,
|
[DependantFileId] INTEGER NOT NULL REFERENCES [FileSystemEntity]([FileSystemEntityId])
|
ON UPDATE CASCADE
|
ON DELETE CASCADE,
|
[ReferenceFileId] INTEGER NULL REFERENCES [FileSystemEntity]([FileSystemEntityId])
|
ON UPDATE CASCADE
|
ON DELETE CASCADE,
|
[ReferenceFilePath] TEXT NULL COLLATE NOCASE,
|
[Target] NVARCHAR(255) NULL COLLATE NOCASE,
|
[Context] NVARCHAR(255) NULL COLLATE NOCASE,
|
[Type] INTEGER NULL
|
)" W-MindexSymbolDefinition_DefiningFileId_IndexSymbolDefinition CREATE INDEX [SymbolDefinition_DefiningFileId_Index]
|
ON [SymbolDefinition] ([DefiningFileId]) C-CindexSymbolDefinition_Name_IndexSymbolDefinition CREATE INDEX [SymbolDefinition_Name_Index]
|
ON [SymbolDefinition] ([Name] COLLATE NOCASE)
|
|
