Joseph Doherty
7b0b9c7365
Solution + 23 src projects + 26 test projects renamed; folders, csproj, namespaces, and ScadaLinkDbContext/ScadaBridgeDbContext class updated. ActorSystem "scadalink" → "scadabridge", Akka seed-node URLs migrated. SQL roles/logins, LDAP domains, CLI command name, and CLI config dir (~/.scadalink → ~/.scadabridge) also renamed. Build green; 5 Host.Tests fail awaiting SQL login rename in next commit. Pre-existing StaleTagMonitor timing flakes unchanged. Rename script committed at tools/rename-to-scadabridge.sh.
32 lines
1.0 KiB
Transact-SQL
32 lines
1.0 KiB
Transact-SQL
-- ScadaBridge env2 database setup
|
|
-- Creates env2 logical databases on an existing scadabridge-mssql instance.
|
|
-- Idempotent: re-runs are no-ops. Assumes setup.sql has already run
|
|
-- (i.e. the scadabridge_app login already exists).
|
|
|
|
-- Create env2 databases
|
|
IF NOT EXISTS (SELECT name FROM sys.databases WHERE name = 'ScadaBridgeConfig2')
|
|
CREATE DATABASE ScadaBridgeConfig2;
|
|
GO
|
|
|
|
IF NOT EXISTS (SELECT name FROM sys.databases WHERE name = 'ScadaBridgeMachineData2')
|
|
CREATE DATABASE ScadaBridgeMachineData2;
|
|
GO
|
|
|
|
-- Grant db_owner on ScadaBridgeConfig2
|
|
USE ScadaBridgeConfig2;
|
|
GO
|
|
IF NOT EXISTS (SELECT name FROM sys.database_principals WHERE name = 'scadabridge_app')
|
|
CREATE USER scadabridge_app FOR LOGIN scadabridge_app;
|
|
GO
|
|
ALTER ROLE db_owner ADD MEMBER scadabridge_app;
|
|
GO
|
|
|
|
-- Grant db_owner on ScadaBridgeMachineData2
|
|
USE ScadaBridgeMachineData2;
|
|
GO
|
|
IF NOT EXISTS (SELECT name FROM sys.database_principals WHERE name = 'scadabridge_app')
|
|
CREATE USER scadabridge_app FOR LOGIN scadabridge_app;
|
|
GO
|
|
ALTER ROLE db_owner ADD MEMBER scadabridge_app;
|
|
GO
|