Initialize-WOLDatabase.ps1
|
<# Create WOL Database #> $DBDesign = @( 'CREATE TABLE Computers ( Computer TEXT COLLATE NOCASE UNIQUE, MAC TEXT COLLATE NOCASE UNIQUE );' ) If ((Test-Path $env:ALLUSERSPROFILE\PSWakeOnLAN) -eq $False) { New-Item -Path $env:ALLUSERSPROFILE\PSWakeOnLAN -ItemType Directory -Force | Out-Null } If ((Test-Path $env:ALLUSERSPROFILE\PSWakeOnLAN\WOLDatabase.db3) -eq $False) { Add-Type -Path $PSScriptRoot\System.Data.SQLite.dll $DBConnect = New-Object -TypeName System.Data.SQLite.SQLiteConnection $DBConnect.ConnectionString = "Data Source = $env:ALLUSERSPROFILE\PSWakeOnLAN\WOLDatabase.db3" $DBConnect.Open() $SQL = $DBConnect.CreateCommand() $SQL.CommandText = $DBDesign $SQL.ExecuteNonQuery() | Out-Null $SQL.Dispose() $DBConnect.Close() } |