DELETE FROM ThemeSettings;
DELETE FROM Themes;
DELETE FROM Rules;
DELETE FROM Timers;
DELETE FROM IR_Remote;
DELETE FROM IR_Model;
DELETE FROM Resources;
DELETE FROM Devices;
DELETE FROM Spaces;
DELETE FROM Sites;
DELETE FROM Users;
INSERT INTO Users (ID, Email, FirstName, LastName, PasswordHash, CreatedOn, phone_number) VALUES ('343', 'Ibwasti77@gmail.com', 'Ibrahim', 'Wasti', '4C22F642F7E89B0D5051B7D7DF6484449D693BA0', '2022-11-01 12:29:10', '+923224968445');
INSERT INTO Sites (ID, Title, Description, UserID, CreatedOn) VALUES (186, 'Smart Home', 'dsfds', 343, '2022-11-01 12:30:36');
INSERT INTO Spaces (ID, Title, Description, SiteID, CreatedOn) VALUES (446, 'Living Room', 'abc', 186, '2022-11-01 12:31:10');
DELETE FROM Spaces WHERE ID = 446;
DELETE FROM ThemeSettings;
DELETE FROM Themes;
DELETE FROM Rules;
DELETE FROM Timers;
DELETE FROM IR_Remote;
DELETE FROM IR_Model;
DELETE FROM Resources;
DELETE FROM Devices;
DELETE FROM Spaces;
DELETE FROM Sites;
DELETE FROM Users;
INSERT INTO Users (ID, Email, FirstName, LastName, PasswordHash, CreatedOn, phone_number) VALUES ('342', 'Ibrahim.wasti1122@gmail.com', 'Ibrahim', 'Wasti', '4C22F642F7E89B0D5051B7D7DF6484449D693BA0', '2022-11-01 10:30:10', '+923224968445');
INSERT INTO Sites (ID, Title, Description, UserID, CreatedOn) VALUES (188, 'Smart Home ', 'dsfds', 342, '2022-11-01 17:21:24');
INSERT INTO Spaces (ID, Title, Description, SiteID, CreatedOn) VALUES (447, 'Living Room', 'abc', 188, '2022-11-01 17:21:54');
INSERT INTO Devices (ID, Title, Description, SpaceID, CategoryID, RegisteredOn, ModelID) VALUES (4587, '6 gang 4587', 'Abc', 447, 2, '2022-11-01 17:22:24', '47');
INSERT INTO Resources (ID, Title, DeviceID, AccessoryID, ApplianceType, CurrentStatus, IsFavorite, ApplianceWatt) VALUES (55220, 'Switch 1', 4587, 1, 0, 0, 0, 0);
INSERT INTO Resources (ID, Title, DeviceID, AccessoryID, ApplianceType, CurrentStatus, IsFavorite, ApplianceWatt) VALUES (55221, 'Switch 2', 4587, 2, 0, 0, 0, 0);
INSERT INTO Resources (ID, Title, DeviceID, AccessoryID, ApplianceType, CurrentStatus, IsFavorite, ApplianceWatt) VALUES (55222, 'Switch 3', 4587, 3, 0, 0, 0, 0);
INSERT INTO Resources (ID, Title, DeviceID, AccessoryID, ApplianceType, CurrentStatus, IsFavorite, ApplianceWatt) VALUES (55223, 'Switch 4', 4587, 4, 0, 0, 0, 0);
INSERT INTO Resources (ID, Title, DeviceID, AccessoryID, ApplianceType, CurrentStatus, IsFavorite, ApplianceWatt) VALUES (55224, 'Switch 5', 4587, 5, 0, 0, 0, 0);
INSERT INTO Resources (ID, Title, DeviceID, AccessoryID, ApplianceType, CurrentStatus, IsFavorite, ApplianceWatt) VALUES (55225, 'Dimmer 1', 4587, 6, 0, 0, 0, 0);
UPDATE Resources SET Title = 'Switch 1', ApplianceType = 1, ApplianceWatt = 10 WHERE ID = 55220;
UPDATE Resources SET Title = 'Switch 1', ApplianceType = 1, ApplianceWatt = 10 WHERE ID = 55220;
UPDATE Resources SET Title = 'Switch 2', ApplianceType = 2, ApplianceWatt = 12 WHERE ID = 55221;
UPDATE Resources SET Title = 'Switch 1', ApplianceType = 1, ApplianceWatt = 10 WHERE ID = 55220;
UPDATE Resources SET Title = 'Switch 2', ApplianceType = 2, ApplianceWatt = 12 WHERE ID = 55221;
UPDATE Resources SET Title = 'Switch 3', ApplianceType = 3, ApplianceWatt = 22 WHERE ID = 55222;
UPDATE Resources SET Title = 'Switch 1', ApplianceType = 1, ApplianceWatt = 10 WHERE ID = 55220;
UPDATE Resources SET Title = 'Switch 2', ApplianceType = 2, ApplianceWatt = 12 WHERE ID = 55221;
UPDATE Resources SET Title = 'Switch 3', ApplianceType = 3, ApplianceWatt = 22 WHERE ID = 55222;
UPDATE Resources SET Title = 'Switch 4', ApplianceType = 3, ApplianceWatt = 11 WHERE ID = 55223;
UPDATE Resources SET Title = 'Switch 1', ApplianceType = 1, ApplianceWatt = 10 WHERE ID = 55220;
UPDATE Resources SET Title = 'Switch 2', ApplianceType = 2, ApplianceWatt = 12 WHERE ID = 55221;
UPDATE Resources SET Title = 'Switch 3', ApplianceType = 3, ApplianceWatt = 22 WHERE ID = 55222;
UPDATE Resources SET Title = 'Switch 4', ApplianceType = 3, ApplianceWatt = 11 WHERE ID = 55223;
UPDATE Resources SET Title = 'Switch 5', ApplianceType = 2, ApplianceWatt = 12 WHERE ID = 55224;
UPDATE Resources SET Title = 'Switch 1', ApplianceType = 1, ApplianceWatt = 10 WHERE ID = 55220;
UPDATE Resources SET Title = 'Switch 2', ApplianceType = 2, ApplianceWatt = 12 WHERE ID = 55221;
UPDATE Resources SET Title = 'Switch 3', ApplianceType = 3, ApplianceWatt = 22 WHERE ID = 55222;
UPDATE Resources SET Title = 'Switch 4', ApplianceType = 3, ApplianceWatt = 11 WHERE ID = 55223;
UPDATE Resources SET Title = 'Switch 5', ApplianceType = 2, ApplianceWatt = 12 WHERE ID = 55224;
UPDATE Resources SET Title = 'Dimmer 1', ApplianceType = 4, ApplianceWatt = 11 WHERE ID = 55225;
UPDATE `Users` SET `FirstName` = 'Ibrahim', `LastName` = 'Wastii', `phone_number` = '+923224968445'
WHERE `ID` = 342;
UPDATE `Users` SET `FirstName` = 'Ibrahim', `LastName` = 'Wastii', `phone_number` = '+923224968446'
WHERE `ID` = 342;
UPDATE `Users` SET `PasswordHash` = 'DF5C474EFA3FDFBE0094F71ABFE68113447F6AD6'
WHERE `ID` = 342;
UPDATE Resources SET IsFavorite = 1 WHERE ID = 55223;
UPDATE `Users` SET `FirstName` = 'Ibrahim', `LastName` = 'Wastii', `phone_number` = '92 3224968446'
WHERE `ID` = 342;
