UPDATE Devices SET Title = 'Plug 4640', SpaceID = 435 WHERE ID = 4640;
UPDATE Devices SET Title = 'PowerPlug', SpaceID = 437 WHERE ID = 4641;
UPDATE Devices SET Title = 'Plug 4640', SpaceID = 437 WHERE ID = 4640;
UPDATE Devices SET Title = 'PowerPlug', SpaceID = 435 WHERE ID = 4641;
DELETE FROM Resources WHERE DeviceID  = 4596;
DELETE FROM Devices WHERE ID = 4596;
DELETE FROM Resources WHERE DeviceID  = 4641;
DELETE FROM Devices WHERE ID = 4641;
DELETE FROM Resources WHERE DeviceID  = 4640;
DELETE FROM Devices WHERE ID = 4640;
DELETE FROM Resources WHERE DeviceID  = 4760;
DELETE FROM Devices WHERE ID = 4760;
DELETE FROM IR_Remote  WHERE User_ID = 336 AND dev_id = 4762;
DELETE FROM Resources WHERE DeviceID  = 4762;
DELETE FROM Devices WHERE ID = 4762;
INSERT INTO Devices (ID, Title, Description, SpaceID, CategoryID, RegisteredOn, ModelID) VALUES (4596, '6 gang device ', 'Abc', 435, 2, '2022-10-24 14:25:43', '47');
INSERT INTO Resources (ID, Title, DeviceID, AccessoryID, ApplianceType, CurrentStatus, IsFavorite, ApplianceWatt) VALUES (55256, 'Switch 1', 4596, 1, 0, 0, 0, 0);
INSERT INTO Resources (ID, Title, DeviceID, AccessoryID, ApplianceType, CurrentStatus, IsFavorite, ApplianceWatt) VALUES (55257, 'Switch 2', 4596, 2, 0, 0, 0, 0);
INSERT INTO Resources (ID, Title, DeviceID, AccessoryID, ApplianceType, CurrentStatus, IsFavorite, ApplianceWatt) VALUES (55258, 'Switch 3', 4596, 3, 0, 0, 0, 0);
INSERT INTO Resources (ID, Title, DeviceID, AccessoryID, ApplianceType, CurrentStatus, IsFavorite, ApplianceWatt) VALUES (55259, 'Switch 4', 4596, 4, 0, 0, 0, 0);
INSERT INTO Resources (ID, Title, DeviceID, AccessoryID, ApplianceType, CurrentStatus, IsFavorite, ApplianceWatt) VALUES (55260, 'Switch 5', 4596, 5, 0, 0, 0, 0);
INSERT INTO Resources (ID, Title, DeviceID, AccessoryID, ApplianceType, CurrentStatus, IsFavorite, ApplianceWatt) VALUES (55261, 'Dimmer 1', 4596, 6, 0, 0, 0, 0);
UPDATE Resources SET Title = 'Switch 1', ApplianceType = 1, ApplianceWatt = 200 WHERE ID = 55256;
UPDATE Resources SET Title = 'Switch 1', ApplianceType = 1, ApplianceWatt = 200 WHERE ID = 55256;
UPDATE Resources SET Title = 'Switch 2', ApplianceType = 2, ApplianceWatt = 200 WHERE ID = 55257;
UPDATE Resources SET Title = 'Switch 1', ApplianceType = 1, ApplianceWatt = 200 WHERE ID = 55256;
UPDATE Resources SET Title = 'Switch 2', ApplianceType = 2, ApplianceWatt = 200 WHERE ID = 55257;
UPDATE Resources SET Title = 'Switch 3', ApplianceType = 3, ApplianceWatt = 11 WHERE ID = 55258;
UPDATE Resources SET Title = 'Switch 1', ApplianceType = 1, ApplianceWatt = 200 WHERE ID = 55256;
UPDATE Resources SET Title = 'Switch 2', ApplianceType = 2, ApplianceWatt = 200 WHERE ID = 55257;
UPDATE Resources SET Title = 'Switch 3', ApplianceType = 3, ApplianceWatt = 11 WHERE ID = 55258;
UPDATE Resources SET Title = 'Switch 4', ApplianceType = 3, ApplianceWatt = 22 WHERE ID = 55259;
UPDATE Resources SET Title = 'Switch 1', ApplianceType = 1, ApplianceWatt = 200 WHERE ID = 55256;
UPDATE Resources SET Title = 'Switch 2', ApplianceType = 2, ApplianceWatt = 200 WHERE ID = 55257;
UPDATE Resources SET Title = 'Switch 3', ApplianceType = 3, ApplianceWatt = 11 WHERE ID = 55258;
UPDATE Resources SET Title = 'Switch 4', ApplianceType = 3, ApplianceWatt = 22 WHERE ID = 55259;
UPDATE Resources SET Title = 'Switch 5', ApplianceType = 1, ApplianceWatt = 11 WHERE ID = 55260;
UPDATE Resources SET Title = 'Switch 1', ApplianceType = 1, ApplianceWatt = 200 WHERE ID = 55256;
UPDATE Resources SET Title = 'Switch 2', ApplianceType = 2, ApplianceWatt = 200 WHERE ID = 55257;
UPDATE Resources SET Title = 'Switch 3', ApplianceType = 3, ApplianceWatt = 11 WHERE ID = 55258;
UPDATE Resources SET Title = 'Switch 4', ApplianceType = 3, ApplianceWatt = 22 WHERE ID = 55259;
UPDATE Resources SET Title = 'Switch 5', ApplianceType = 1, ApplianceWatt = 11 WHERE ID = 55260;
UPDATE Resources SET Title = 'Dimmer 1', ApplianceType = 4, ApplianceWatt = 21 WHERE ID = 55261;
DELETE FROM Resources WHERE DeviceID  = 4596;
DELETE FROM Devices WHERE ID = 4596;
