18 lines
313 B
PowerShell
18 lines
313 B
PowerShell
$DBFile = Join-Path $env:USERPROFILE -ChildPath "z.db"
|
|
$sConnectionString = "Data Source=$DBFile"
|
|
|
|
if (!(Test-Path $DBFile)) {
|
|
# File not exists
|
|
[System.Data.SQLite.SQLiteConnection]::CreateFile($DBFile)
|
|
}
|
|
|
|
$SchemaSQL = @"
|
|
CREATE TABLE location (
|
|
id int,
|
|
path text,
|
|
factor int,
|
|
update_time int
|
|
);
|
|
"@
|
|
|