e382a3246e
- Fix dualpath PC propagation direction (Equipment->PC) in api.asp and db_helpers.asp - Fix early exit in CreatePCMachineRelationship preventing propagation - Fix getShopfloorPCs to filter machinetypeid IN (33,34,35) instead of >= 33 - Fix getShopfloorPCs to show equipment numbers via GROUP_CONCAT subquery - Add detailed PropagateDP logging for dualpath debugging - Default "Show on Shopfloor Dashboard" checkbox to checked in addnotification.asp - Add USB label batch printing, single USB labels, and USB history pages - Add printer supplies tracking and toner report enhancements - Add uptime map visualization page - Add dashboard/lobby display SQL migration - Update CLAUDE.md with IIS 401 workaround documentation - Update TODO.md Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
23 lines
1.1 KiB
SQL
23 lines
1.1 KiB
SQL
-- ============================================================
|
|
-- Add Dashboard and Lobby Display PC Types and Applications
|
|
-- Run against production database
|
|
-- Date: 2026-01-14
|
|
-- ============================================================
|
|
|
|
-- Add new PC types
|
|
INSERT INTO pctype (typename, description, functionalaccountid, isactive, displayorder) VALUES
|
|
('Dashboard', 'Shopfloor dashboard display PC', 3, '1', 10),
|
|
('Lobby Display', 'Lobby/TV dashboard display PC', 3, '1', 11);
|
|
|
|
-- Add new applications
|
|
INSERT INTO applications (appname, appdescription, supportteamid, isinstallable, isactive, ishidden) VALUES
|
|
('GE Aerospace Dashboard', 'Shopfloor dashboard kiosk display application', 1, b'1', b'1', b'0'),
|
|
('GE Aerospace Lobby Display', 'Lobby/TV dashboard kiosk display application', 1, b'1', b'1', b'0');
|
|
|
|
-- Verify insertions
|
|
SELECT 'PC Types Added:' AS '';
|
|
SELECT pctypeid, typename, description FROM pctype WHERE typename IN ('Dashboard', 'Lobby Display');
|
|
|
|
SELECT 'Applications Added:' AS '';
|
|
SELECT appid, appname, appdescription FROM applications WHERE appname LIKE 'GE Aerospace Dashboard' OR appname LIKE 'GE Aerospace Lobby Display';
|