Home Explore Help
Register Sign In
WEP
/
SQL
3
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Tree: af02dc3153
Branches Tags
SQL
/
WE_2024
/
20240614_We_App_AddNewData.sql

20240614_We_App_AddNewData.sql 8.0 KB
History Raw

1234567891011121314151617181920212223242526272829303132333435363738 
  1. 

  2. USE [We_AppDb_V2.2_Dev]
    3. 

  3. 

  4. INSERT INTO [dbo].[Bs_TrainingRoles] ([Id], [RoleName], [Description], [IsDeleted], [DeleterUserId], [DeletionTime], [LastModificationTime], [LastModifierUserId], [CreationTime], [CreatorUserId]) VALUES (N'JY2011000020002', N'相关省市公司', N'相关省市公司', '0', NULL, NULL, NULL, NULL, '2024-06-14 13:27:27.213', 3);
    5. 

  5. INSERT INTO [dbo].[Bs_TrainingRoles] ([Id], [RoleName], [Description], [IsDeleted], [DeleterUserId], [DeletionTime], [LastModificationTime], [LastModifierUserId], [CreationTime], [CreatorUserId]) VALUES (N'JY2011000020003', N'相关事发单位', N'相关事发单位
    6. 

  6. ', '0', NULL, NULL, NULL, NULL, '2024-06-14 13:29:01.353', 3);
    7. 

  7. INSERT INTO [dbo].[Bs_TrainingRoles] ([Id], [RoleName], [Description], [IsDeleted], [DeleterUserId], [DeletionTime], [LastModificationTime], [LastModifierUserId], [CreationTime], [CreatorUserId]) VALUES (N'JY2011000020004', N'调控中心', N'调控中心', '0', NULL, NULL, NULL, NULL, '2024-06-14 13:29:12.283', 3);
    8. 

  8. INSERT INTO [dbo].[Bs_TrainingRoles] ([Id], [RoleName], [Description], [IsDeleted], [DeleterUserId], [DeletionTime], [LastModificationTime], [LastModifierUserId], [CreationTime], [CreatorUserId]) VALUES (N'JY2011000020005', N'党建部', N'党建部', '0', NULL, NULL, NULL, NULL, '2024-06-14 13:29:43.543', 3);
    9. 

  9. INSERT INTO [dbo].[Bs_TrainingRoles] ([Id], [RoleName], [Description], [IsDeleted], [DeleterUserId], [DeletionTime], [LastModificationTime], [LastModifierUserId], [CreationTime], [CreatorUserId]) VALUES (N'JY2011000020006', N'大面积停电应急办（安监部）', N'大面积停电应急办（安监部）', '0', NULL, NULL, NULL, NULL, '2024-06-14 13:29:52.567', 3);
    10. 

  10. INSERT INTO [dbo].[Bs_TrainingRoles] ([Id], [RoleName], [Description], [IsDeleted], [DeleterUserId], [DeletionTime], [LastModificationTime], [LastModifierUserId], [CreationTime], [CreatorUserId]) VALUES (N'JY2011000020007', N'分部安监部', N'分部安监部', '0', NULL, NULL, NULL, NULL, '2024-06-14 13:30:03.460', 3);
    11. 

  11. INSERT INTO [dbo].[Bs_TrainingRoles] ([Id], [RoleName], [Description], [IsDeleted], [DeleterUserId], [DeletionTime], [LastModificationTime], [LastModifierUserId], [CreationTime], [CreatorUserId]) VALUES (N'JY2011000020008', N'生技部', N'生技部', '0', NULL, NULL, NULL, NULL, '2024-06-14 13:30:14.080', 3);
    12. 

  12. INSERT INTO [dbo].[Bs_TrainingRoles] ([Id], [RoleName], [Description], [IsDeleted], [DeleterUserId], [DeletionTime], [LastModificationTime], [LastModifierUserId], [CreationTime], [CreatorUserId]) VALUES (N'JY2011000020009', N'指挥长', N'指挥长', '0', NULL, NULL, NULL, NULL, '2024-06-14 13:30:24.277', 3);
    13. 

  13. INSERT INTO [dbo].[Bs_TrainingRoles] ([Id], [RoleName], [Description], [IsDeleted], [DeleterUserId], [DeletionTime], [LastModificationTime], [LastModifierUserId], [CreationTime], [CreatorUserId]) VALUES (N'JY2011000020010', N'总指挥', N'总指挥', '0', NULL, NULL, NULL, NULL, '2024-06-14 13:30:32.213', 3);
    14. 

  14. INSERT INTO [dbo].[Bs_TrainingRoles] ([Id], [RoleName], [Description], [IsDeleted], [DeleterUserId], [DeletionTime], [LastModificationTime], [LastModifierUserId], [CreationTime], [CreatorUserId]) VALUES (N'JY2011000020011', N'大面积停电应急领导小组', N'大面积停电应急领导小组', '0', NULL, NULL, NULL, NULL, '2024-06-14 13:30:45.753', 3);
    15. 

  15. INSERT INTO [dbo].[Bs_TrainingRoles] ([Id], [RoleName], [Description], [IsDeleted], [DeleterUserId], [DeletionTime], [LastModificationTime], [LastModifierUserId], [CreationTime], [CreatorUserId]) VALUES (N'JY2011000020012', N'电网调控组（调控中心）', N'电网调控组（调控中心）', '0', NULL, NULL, NULL, NULL, '2024-06-14 13:30:54.827', 3);
    16. 

  16. INSERT INTO [dbo].[Bs_TrainingRoles] ([Id], [RoleName], [Description], [IsDeleted], [DeleterUserId], [DeletionTime], [LastModificationTime], [LastModifierUserId], [CreationTime], [CreatorUserId]) VALUES (N'JY2011000020013', N'生产技术组（生技部）', N'生产技术组（生技部）', '0', NULL, NULL, NULL, NULL, '2024-06-14 13:31:05.303', 3);
    17. 

  17. INSERT INTO [dbo].[Bs_TrainingRoles] ([Id], [RoleName], [Description], [IsDeleted], [DeleterUserId], [DeletionTime], [LastModificationTime], [LastModifierUserId], [CreationTime], [CreatorUserId]) VALUES (N'JY2011000020014', N'综合协调组（安监部）', N'综合协调组（安监部）', '0', NULL, NULL, NULL, NULL, '2024-06-14 13:31:14.320', 3);
    18. 

  18. INSERT INTO [dbo].[Bs_TrainingRoles] ([Id], [RoleName], [Description], [IsDeleted], [DeleterUserId], [DeletionTime], [LastModificationTime], [LastModifierUserId], [CreationTime], [CreatorUserId]) VALUES (N'JY2011000020015', N'舆情处置组（党建部）', N'舆情处置组（党建部）', '0', NULL, NULL, NULL, NULL, '2024-06-14 13:31:23.470', 3);
    19. 

  19. 

  20. 

  21. INSERT INTO [dbo].[Bs_TrainingRoleGroups] ([Id], [RoleGroupName], [Roles], [Description], [IsDeleted], [DeleterUserId], [DeletionTime], [LastModificationTime], [LastModifierUserId], [CreationTime], [CreatorUserId]) VALUES (N'JY2012000020001', N'HD大面积停电', N'JY2011000020002,JY2011000020003,JY2011000020004,JY2011000020005,JY2011000020006,JY2011000020007,JY2011000020008,JY2011000020009,JY2011000020010,JY2011000020011,JY2011000020012,JY2011000020013,JY2011000020014,JY2011000020015', N'HD大面积停电', '0', NULL, NULL, NULL, NULL, '2024-06-14 13:34:57.060', 3);
    22. 

  22. 

  23. SET IDENTITY_INSERT [dbo].[Bs_TrainingGroupRelateRoles] ON 
    24. 

  24. INSERT INTO [dbo].[Bs_TrainingGroupRelateRoles] ([Id], [RoleGroupNo], [TrainRoleNo], [CreationTime], [CreatorUserId]) VALUES (63, N'JY2012000020001', N'JY2011000020002', '2024-06-14 13:34:57.023', 3);
    25. 

  25. INSERT INTO [dbo].[Bs_TrainingGroupRelateRoles] ([Id], [RoleGroupNo], [TrainRoleNo], [CreationTime], [CreatorUserId]) VALUES (64, N'JY2012000020001', N'JY2011000020003', '2024-06-14 13:34:57.037', 3);
    26. 

  26. INSERT INTO [dbo].[Bs_TrainingGroupRelateRoles] ([Id], [RoleGroupNo], [TrainRoleNo], [CreationTime], [CreatorUserId]) VALUES (65, N'JY2012000020001', N'JY2011000020004', '2024-06-14 13:34:57.037', 3);
    27. 

  27. INSERT INTO [dbo].[Bs_TrainingGroupRelateRoles] ([Id], [RoleGroupNo], [TrainRoleNo], [CreationTime], [CreatorUserId]) VALUES (66, N'JY2012000020001', N'JY2011000020005', '2024-06-14 13:34:57.040', 3);
    28. 

  28. INSERT INTO [dbo].[Bs_TrainingGroupRelateRoles] ([Id], [RoleGroupNo], [TrainRoleNo], [CreationTime], [CreatorUserId]) VALUES (67, N'JY2012000020001', N'JY2011000020006', '2024-06-14 13:34:57.040', 3);
    29. 

  29. INSERT INTO [dbo].[Bs_TrainingGroupRelateRoles] ([Id], [RoleGroupNo], [TrainRoleNo], [CreationTime], [CreatorUserId]) VALUES (68, N'JY2012000020001', N'JY2011000020007', '2024-06-14 13:34:57.040', 3);
    30. 

  30. INSERT INTO [dbo].[Bs_TrainingGroupRelateRoles] ([Id], [RoleGroupNo], [TrainRoleNo], [CreationTime], [CreatorUserId]) VALUES (69, N'JY2012000020001', N'JY2011000020008', '2024-06-14 13:34:57.040', 3);
    31. 

  31. INSERT INTO [dbo].[Bs_TrainingGroupRelateRoles] ([Id], [RoleGroupNo], [TrainRoleNo], [CreationTime], [CreatorUserId]) VALUES (70, N'JY2012000020001', N'JY2011000020009', '2024-06-14 13:34:57.040', 3);
    32. 

  32. INSERT INTO [dbo].[Bs_TrainingGroupRelateRoles] ([Id], [RoleGroupNo], [TrainRoleNo], [CreationTime], [CreatorUserId]) VALUES (71, N'JY2012000020001', N'JY2011000020010', '2024-06-14 13:34:57.040', 3);
    33. 

  33. INSERT INTO [dbo].[Bs_TrainingGroupRelateRoles] ([Id], [RoleGroupNo], [TrainRoleNo], [CreationTime], [CreatorUserId]) VALUES (72, N'JY2012000020001', N'JY2011000020011', '2024-06-14 13:34:57.040', 3);
    34. 

  34. INSERT INTO [dbo].[Bs_TrainingGroupRelateRoles] ([Id], [RoleGroupNo], [TrainRoleNo], [CreationTime], [CreatorUserId]) VALUES (73, N'JY2012000020001', N'JY2011000020012', '2024-06-14 13:34:57.040', 3);
    35. 

  35. INSERT INTO [dbo].[Bs_TrainingGroupRelateRoles] ([Id], [RoleGroupNo], [TrainRoleNo], [CreationTime], [CreatorUserId]) VALUES (74, N'JY2012000020001', N'JY2011000020013', '2024-06-14 13:34:57.040', 3);
    36. 

  36. INSERT INTO [dbo].[Bs_TrainingGroupRelateRoles] ([Id], [RoleGroupNo], [TrainRoleNo], [CreationTime], [CreatorUserId]) VALUES (75, N'JY2012000020001', N'JY2011000020014', '2024-06-14 13:34:57.040', 3);
    37. 

  37. INSERT INTO [dbo].[Bs_TrainingGroupRelateRoles] ([Id], [RoleGroupNo], [TrainRoleNo], [CreationTime], [CreatorUserId]) VALUES (76, N'JY2012000020001', N'JY2011000020015', '2024-06-14 13:34:57.043', 3);
    38. 

  38. SET IDENTITY_INSERT [dbo].[Bs_TrainingGroupRelateRoles] OFF 
    39.