LegalServiceV1/Doc/Legal_Clear.sql



  TRUNCATE TABLE  [ContractServiceDb].[dbo].[Cs_StaffRelateInfos]  
  TRUNCATE TABLE  [ContractServiceDb].[dbo].[Ls_LawyerRelatedInfos]
  DELETE FROM  [ContractServiceDb].[dbo].[Cs_ClientStaffs]
  DELETE FROM  [ContractServiceDb].[dbo].[Ls_Lawyers]
  DELETE FROM  [ContractServiceDb].[dbo].[Cs_ClientOrganizations]  
  DELETE FROM  [ContractServiceDb].[dbo].[Cs_ClientCompanies]
  DELETE FROM  [ContractServiceDb].[dbo].[Ls_LawFirms]
  DELETE FROM  [ContractServiceDb].[dbo].[Ls_LegalContractContents]
  DELETE FROM  [ContractServiceDb].[dbo].[Ls_LegalContractNotes]
  DELETE FROM  [ContractServiceDb].[dbo].[Ls_LegalContractSupplements]
  DELETE FROM  [ContractServiceDb].[dbo].[Ls_LegalContractKeyPoints]
  DELETE FROM  [ContractServiceDb].[dbo].[Ls_LegalContracts]
  DELETE FROM  [ContractServiceDb].[dbo].[Ls_LegalCaseNotes]
  DELETE FROM  [ContractServiceDb].[dbo].[Ls_LegalCases]
  DELETE FROM  [ContractServiceDb].[dbo].[Sys_QueryInfos]

  DELETE FROM  [ContractServiceDb].[dbo].[Sys_NotificationUsers]
  DELETE FROM  [ContractServiceDb].[dbo].[Sys_NotificationTenants]
  DELETE FROM  [ContractServiceDb].[dbo].[Sys_Notifications]
  DELETE FROM  [ContractServiceDb].[dbo].[Sys_NotificationSubscriptions]

  TRUNCATE TABLE  [ContractServiceDb].[dbo].[Sys_AuditLogs]
  TRUNCATE TABLE  [ContractServiceDb].[dbo].[Sys_AttachFiles]
  TRUNCATE TABLE  [ContractServiceDb].[dbo].[Sys_UserAccounts]
  TRUNCATE TABLE  [ContractServiceDb].[dbo].[Sys_UserClaims]
  TRUNCATE TABLE  [ContractServiceDb].[dbo].[Sys_UserLoginAttempts]
  TRUNCATE TABLE  [ContractServiceDb].[dbo].[Sys_UserLogins]
  TRUNCATE TABLE  [ContractServiceDb].[dbo].[Sys_UserRoles]

  INSERT INTO [dbo].[Sys_UserRoles] ([TenantId],[UserId],[RoleId],[CreationTime],[CreatorUserId]) VALUES (1,4,2,2021-02-04,3)
  INSERT INTO [dbo].[Sys_UserRoles] ([TenantId],[UserId],[RoleId],[CreationTime],[CreatorUserId]) VALUES (1,5,5,2021-02-04,3)
  INSERT INTO [dbo].[Sys_UserRoles] ([TenantId],[UserId],[RoleId],[CreationTime],[CreatorUserId]) VALUES (1,15,4,2021-02-04,3)
  INSERT INTO [dbo].[Sys_UserRoles] ([TenantId],[UserId],[RoleId],[CreationTime],[CreatorUserId]) VALUES (1,25,3,2021-02-04,3)
  INSERT INTO [dbo].[Sys_UserRoles] ([TenantId],[UserId],[RoleId],[CreationTime],[CreatorUserId]) VALUES (1,26,3,2021-02-04,3)
  INSERT INTO [dbo].[Sys_UserRoles] ([TenantId],[UserId],[RoleId],[CreationTime],[CreatorUserId]) VALUES (1,27,3,2021-02-04,3)
  INSERT INTO [dbo].[Sys_UserRoles] ([TenantId],[UserId],[RoleId],[CreationTime],[CreatorUserId]) VALUES (1,28,3,2021-02-04,3)
  INSERT INTO [dbo].[Sys_UserRoles] ([TenantId],[UserId],[RoleId],[CreationTime],[CreatorUserId]) VALUES (1,29,3,2021-02-04,3)

  DELETE FROM  [ContractServiceDb].[dbo].[Sys_AttachFiles]
  DELETE FROM  [ContractServiceDb].[dbo].[Sys_QueryInfos]