------------------------------------------------------------
-- 1. Create target table
------------------------------------------------------------
DROP TABLE IF EXISTS LNKFiles;

CREATE TABLE LNKFiles (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    shortcut_name TEXT,
    target_path TEXT,
    unc_path TEXT,
    removable_drive TEXT,
    notes TEXT
);

------------------------------------------------------------
-- 2. Insert rows directly using standard SQL
------------------------------------------------------------
INSERT INTO LNKFiles (shortcut_name, target_path, unc_path, removable_drive, notes) VALUES
('FinanceWallet', 'C:\Users\Public\wallet.dat', '\\CORP-FS01\finance\wallets\', 'E:\wallet.dat', 'Internal finance shortcut'),
('POS_Main', 'C:\Program Files\pcAmerica\pos.exe', '\\POS-SRV01\apps\pcAmerica\', 'F:\pos.exe', 'POS terminal launcher'),
('POS_BackOffice', 'C:\POS\backoffice.exe', '\\POS-SRV02\backoffice\', 'E:\backoffice.exe', 'Back office mgmt'),
('NVR_Console', 'C:\Program Files\NVR\nvr.exe', '\\NVR-SRV01\console\', '-', 'CCTV console link'),
('NVR_Archive', 'C:\NVR\archive_viewer.exe', '\\NVR-SRV02\archive\', '-', 'Archive viewer'),
('HeartlandGateway', 'C:\Heartland\gateway.exe', '\\MERCHANT-SRV01\gateway\', 'G:\gateway.exe', 'Merchant processing'),
('HeartlandTerminal', 'C:\Heartland\terminal.exe', '\\MERCHANT-SRV02\terminal\', '-', 'Secure terminal'),
('LSNB_Submit', 'C:\Bank\submit.exe', '\\BANK-SUB01\lsnb\upload\', '-', 'LSNB batch submission'),
('LSNB_Audit', 'C:\Bank\audit.exe', '\\BANK-SUB02\lsnb\audit\', '-', 'Audit review'),
('StateID_Scanner', 'C:\IDScan\scanner.exe', '\\IDSCAN-SRV01\scanner\', '-', 'ID verification'),
('StateID_DBClient', 'C:\IDScan\dbclient.exe', '\\IDSCAN-SRV02\db\', '-', 'DB client'),
('OpsDashboard', 'C:\Ops\dashboard.exe', '\\OPS-SRV01\dashboard\', '-', 'Ops monitoring'),
('OpsFailover', 'C:\Ops\failover.exe', '\\OPS-SRV02\failover\', '-', 'Failover node'),
('DevTools', 'C:\Dev\tools.exe', '\\DEV-SRV01\tools\', 'H:\tools.exe', 'Dev environment'),
('QAConsole', 'C:\QA\console.exe', '\\DEV-SRV02\qa\', '-', 'QA testing'),
('ColdStorageViewer', 'C:\Backup\viewer.exe', '\\BACKUP-SRV01\coldstore\', '-', 'Cold storage viewer'),
('OffsiteSync', 'C:\Backup\sync.exe', '\\BACKUP-SRV02\offsite\', '-', 'Offsite replication'),
('SecurityAuditTool', 'C:\Security\audit.exe', '\\SEC-SRV01\audit\', '-', 'Security audit'),
('ComplianceCheck', 'C:\Compliance\check.exe', '\\COMP-SRV01\checks\', '-', 'Compliance system'),
('WalletBackup', 'C:\Backup\wallet_backup.exe', '\\CORP-FS02\wallets\backup\', 'E:\wallet_backup.exe', 'Wallet backup utility');

------------------------------------------------------------
-- 3. Verify import
------------------------------------------------------------
SELECT * FROM LNKFiles;