90 lines
3.5 KiB
SQL
90 lines
3.5 KiB
SQL
LOCK TABLES `MarcoBMS100`.`Employees` WRITE;
|
|
LOCK TABLES `MarcoBMS100`.`AspNetUsers` WRITE;
|
|
|
|
INSERT INTO `MarcoBMS100`.`AspNetUsers`
|
|
(`Id`,
|
|
`Discriminator`,`Role`,`TenantId`,`IsRootUser`,`UserName`,`NormalizedUserName`,`Email`,
|
|
`NormalizedEmail`,`EmailConfirmed`,`PasswordHash`,`SecurityStamp`,`ConcurrencyStamp`,
|
|
`PhoneNumber`,`PhoneNumberConfirmed`,`TwoFactorEnabled`,`LockoutEnd`,`LockoutEnabled`,
|
|
`AccessFailedCount`,`IsActive`)
|
|
VALUES ('4f76679f-8ca8-4617-a06c-56dc77da765c',
|
|
'ApplicationUser', null, 1,1,'admin@marcoaiot.com','ADMIN@MARCOAIOT.COM','admin@marcoaiot.com',
|
|
'ADMIN@MARCOAIOT.COM',1,'AQAAAAIAAYagAAAAEMdGnHFjPDuAoVtGv39uB7N/c75DcnaohPzauGIFNJt+ABbhTDfFoznz9ZkCH9tWbQ==',
|
|
'5A3H274HR7FBB3LXDXZIKCMBELHL3AZK',
|
|
'61022498-4b1f-405d-b0eb-7ea62a1d5caf',NULL,0,0,NULL,1,0,1);
|
|
|
|
INSERT INTO `MarcoBMS100`.`JobRoles`
|
|
(`Id`,
|
|
`Name`,
|
|
`Description`,
|
|
`TenantId`)
|
|
VALUES
|
|
(null,
|
|
'Admin',
|
|
'Admin',
|
|
1);
|
|
|
|
INSERT INTO `MarcoBMS100`.`Employees` (FirstName , LastName ,MiddleName , Gender , BirthDate,CurrentAddress ,
|
|
PhoneNumber , EmergencyPhoneNumber , AadharNumber , PanNumber , Photo , ApplicationUserId ,
|
|
TenantId , Email , JobRoleId , RoleId,EmergencyContactPerson , IsActive ,JoiningDate ,
|
|
PermanentAddress )
|
|
VALUES ('Administrator','Marco-AIOT',NULL,'Male','2000-02-14',
|
|
'Pune','8776544236','1234567890','1234567890',NULL,NULL,
|
|
'4f76679f-8ca8-4617-a06c-56dc77da765c',1,'admin@marcoaiot.com',
|
|
1,'00000000-0000-0000-0000-000000000000','Manager',1,'2025-03-04','Pune');
|
|
|
|
INSERT INTO `MarcoBMS100`.`ApplicationRoles`
|
|
(`Id`,
|
|
`Role`,
|
|
`Description`,
|
|
`TenantId`)
|
|
VALUES
|
|
(
|
|
'08dd4761-393c-49ed-8851-3d2489a3e90d',
|
|
'Super User',
|
|
'A Super User is a highly privileged user with unrestricted access to all features',
|
|
1);
|
|
|
|
INSERT INTO `MarcoBMS100`.`EmployeeRoleMappings`
|
|
(`Id`,
|
|
`EmployeeId`,
|
|
`RoleId`,
|
|
`IsEnabled`,
|
|
`TenantId`)
|
|
VALUES (
|
|
'2fadab1f-4ad5-4c8c-987a-a4bd068393b9',
|
|
8,
|
|
'08dd4761-393c-49ed-8851-3d2489a3e90d',
|
|
1,
|
|
1);
|
|
|
|
|
|
|
|
INSERT INTO `MarcoBMS100`.`RolePermissionMappings` (`ApplicationRoleId`, `FeaturePermissionId`)
|
|
VALUES ('08dd4761-393c-49ed-8851-3d2489a3e90d','08752f33-3b29-4816-b76b-ea8a968ed3c5'),
|
|
('08dd4761-393c-49ed-8851-3d2489a3e90d','172fc9b6-755b-4f62-ab26-55c34a330614'),
|
|
('08dd4761-393c-49ed-8851-3d2489a3e90d','57802c4a-00aa-4a1f-a048-fd2f70dd44b6'),
|
|
('08dd4761-393c-49ed-8851-3d2489a3e90d','588a8824-f924-4955-82d8-fc51956cf323'),
|
|
('08dd4761-393c-49ed-8851-3d2489a3e90d','5ffbafe0-7ab0-48b1-bb50-c1bf76b65f9d'),
|
|
('08dd4761-393c-49ed-8851-3d2489a3e90d','6b1a6d97-a951-4de5-9b19-709bac7c4f18'),
|
|
('08dd4761-393c-49ed-8851-3d2489a3e90d','6ea44136-987e-44ba-9e5d-1cf8f5837ebc'),
|
|
('08dd4761-393c-49ed-8851-3d2489a3e90d','915e6bff-65f6-4e3f-aea8-3fd217d3ea9e'),
|
|
('08dd4761-393c-49ed-8851-3d2489a3e90d','9fcc5f87-25e3-4846-90ac-67a71ab92e3c'),
|
|
('08dd4761-393c-49ed-8851-3d2489a3e90d','a97d366a-c2bb-448d-be93-402bd2324566'),
|
|
('08dd4761-393c-49ed-8851-3d2489a3e90d','b82d2b7e-0d52-45f3-997b-c008ea460e7f'),
|
|
('08dd4761-393c-49ed-8851-3d2489a3e90d','b94802ce-0689-4643-9e1d-11c86950c35b'),
|
|
('08dd4761-393c-49ed-8851-3d2489a3e90d','c7b68e33-72f0-474f-bd96-77636427ecc8'),
|
|
('08dd4761-393c-49ed-8851-3d2489a3e90d','cb8ec407-46d4-4467-930c-69127cda6dec'),
|
|
('08dd4761-393c-49ed-8851-3d2489a3e90d','d135a4b0-4f9a-4903-ab9c-4843839ebdee'),
|
|
('08dd4761-393c-49ed-8851-3d2489a3e90d','ed99ecd4-1bed-42e1-b7b3-d64c04493823'),
|
|
('08dd4761-393c-49ed-8851-3d2489a3e90d','f2aee20a-b754-4537-8166-f9507b44585b'),
|
|
('08dd4761-393c-49ed-8851-3d2489a3e90d','fbd213e0-0250-46f1-9f5f-4b2a1e6e76a3');
|
|
|
|
|
|
update `MarcoBMS100`.`Projects` set StartDate = '2025-03-23', EndDate = '2029-03-23'
|
|
where Id in ( 1,2,3);
|
|
|
|
|
|
UNLOCK TABLES;
|
|
|