API tools faq
paste
Guest User

Untitled

a guest
Jun 25th, 2024
34
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 26.31 KB | None | 0 0
raw download clone embed print report
  1. /****** Object:  Table [dbo].[relay_category_task]    Script Date: 6/25/2024 10:37:07 AM ******/
  2. SET ANSI_NULLS ON
  3. GO
  4. SET QUOTED_IDENTIFIER ON
  5. GO
  6. CREATE TABLE [dbo].[relay_category_task](
  7.     [RelayCategoryTaskID] [int] IDENTITY(1,1) NOT NULL,
  8.     [RelayCategoryTaskGUID] [uniqueidentifier] NOT NULL,
  9.     [RelayCategoryAssociationID] [int] NOT NULL,
  10.     [Name] [nvarchar](50) NULL,
  11.     [PercentComplete] [float] NOT NULL,
  12.     [StartDate] [date] NOT NULL,
  13.     [EndDate] [date] NULL,
  14.     [Deadline] [date] NULL,
  15.     [DurationDays] [int] NOT NULL,
  16.     [Constraint] [int] NOT NULL,
  17.     [ConstraintDate] [date] NULL,
  18.     [IsMilestone] [bit] NOT NULL,
  19.     [Notes] [nvarchar](4000) NULL,
  20.     [ParentRelayCategoryTaskID] [int] NULL,
  21.     [CompletedDate] [date] NULL,
  22.     [CreateUserID] [nvarchar](36) NOT NULL,
  23.     [CreateTimestamp] [datetime2](7) NOT NULL,
  24.     [LastUpdateUserID] [nvarchar](36) NOT NULL,
  25.     [LastUpdateTimestamp] [datetime2](7) NOT NULL,
  26. PRIMARY KEY CLUSTERED
  27. (
  28.     [RelayCategoryTaskID] ASC
  29. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
  30. ) ON [PRIMARY]
  31. GO
  32. SET IDENTITY_INSERT [dbo].[relay_category_task] ON
  33. GO
  34. INSERT [dbo].[relay_category_task] ([RelayCategoryTaskID], [RelayCategoryTaskGUID], [RelayCategoryAssociationID], [Name], [PercentComplete], [StartDate], [EndDate], [Deadline], [DurationDays], [Constraint], [ConstraintDate], [IsMilestone], [Notes], [ParentRelayCategoryTaskID], [CompletedDate], [CreateUserID], [CreateTimestamp], [LastUpdateUserID], [LastUpdateTimestamp]) VALUES (1, N'7d533fbd-7ae6-ee11-9fc2-f875a42879af', 1, N'Kickoff', 0, CAST(N'2024-03-20' AS Date), NULL, NULL, 0, 7, CAST(N'2024-03-20' AS Date), 1, N'Relay kick-off.', NULL, NULL, N'DOMAIN\user', CAST(N'2024-03-20T00:28:54.0700000' AS DateTime2), N'DOMAIN\user', CAST(N'2024-06-21T23:15:31.2800000' AS DateTime2))
  35. GO
  36. INSERT [dbo].[relay_category_task] ([RelayCategoryTaskID], [RelayCategoryTaskGUID], [RelayCategoryAssociationID], [Name], [PercentComplete], [StartDate], [EndDate], [Deadline], [DurationDays], [Constraint], [ConstraintDate], [IsMilestone], [Notes], [ParentRelayCategoryTaskID], [CompletedDate], [CreateUserID], [CreateTimestamp], [LastUpdateUserID], [LastUpdateTimestamp]) VALUES (2, N'7e533fbd-7ae6-ee11-9fc2-f875a42879af', 1, N'Turn-in', 0, CAST(N'2024-04-25' AS Date), NULL, CAST(N'2024-04-26' AS Date), 1, 3, CAST(N'2024-04-26' AS Date), 1, N'Complete relay turn-in.', NULL, NULL, N'DOMAIN\user', CAST(N'2024-03-20T00:28:54.0866667' AS DateTime2), N'DOMAIN\user', CAST(N'2024-06-21T23:15:31.3300000' AS DateTime2))
  37. GO
  38. INSERT [dbo].[relay_category_task] ([RelayCategoryTaskID], [RelayCategoryTaskGUID], [RelayCategoryAssociationID], [Name], [PercentComplete], [StartDate], [EndDate], [Deadline], [DurationDays], [Constraint], [ConstraintDate], [IsMilestone], [Notes], [ParentRelayCategoryTaskID], [CompletedDate], [CreateUserID], [CreateTimestamp], [LastUpdateUserID], [LastUpdateTimestamp]) VALUES (11, N'ad6f21e5-7be8-ee11-9fc2-f875a42879af', 6, N'Kickoff', 0, CAST(N'2024-03-22' AS Date), NULL, NULL, 0, 7, CAST(N'2024-03-22' AS Date), 1, N'Relay kick-off.', NULL, NULL, N'DOMAIN\user', CAST(N'2024-03-22T13:42:12.8266667' AS DateTime2), N'DOMAIN\user', CAST(N'2024-06-21T23:15:32.4066667' AS DateTime2))
  39. GO
  40. INSERT [dbo].[relay_category_task] ([RelayCategoryTaskID], [RelayCategoryTaskGUID], [RelayCategoryAssociationID], [Name], [PercentComplete], [StartDate], [EndDate], [Deadline], [DurationDays], [Constraint], [ConstraintDate], [IsMilestone], [Notes], [ParentRelayCategoryTaskID], [CompletedDate], [CreateUserID], [CreateTimestamp], [LastUpdateUserID], [LastUpdateTimestamp]) VALUES (12, N'ae6f21e5-7be8-ee11-9fc2-f875a42879af', 6, N'Turn-in', 0, CAST(N'2024-04-26' AS Date), NULL, CAST(N'2024-04-26' AS Date), 1, 3, CAST(N'2024-04-26' AS Date), 1, N'Complete relay turn-in.', NULL, NULL, N'DOMAIN\user', CAST(N'2024-03-22T13:42:12.8600000' AS DateTime2), N'DOMAIN\user', CAST(N'2024-06-21T23:15:32.4566667' AS DateTime2))
  41. GO
  42. INSERT [dbo].[relay_category_task] ([RelayCategoryTaskID], [RelayCategoryTaskGUID], [RelayCategoryAssociationID], [Name], [PercentComplete], [StartDate], [EndDate], [Deadline], [DurationDays], [Constraint], [ConstraintDate], [IsMilestone], [Notes], [ParentRelayCategoryTaskID], [CompletedDate], [CreateUserID], [CreateTimestamp], [LastUpdateUserID], [LastUpdateTimestamp]) VALUES (17, N'91d65d99-d9eb-ee11-9fc2-f875a42879af', 9, N'Kickoff', 0, CAST(N'2024-03-26' AS Date), NULL, NULL, 0, 7, CAST(N'2024-03-26' AS Date), 1, N'Relay kick-off.', NULL, NULL, N'DOMAIN\user', CAST(N'2024-03-26T20:30:31.9366667' AS DateTime2), N'DOMAIN\user', CAST(N'2024-06-21T23:32:06.1633333' AS DateTime2))
  43. GO
  44. INSERT [dbo].[relay_category_task] ([RelayCategoryTaskID], [RelayCategoryTaskGUID], [RelayCategoryAssociationID], [Name], [PercentComplete], [StartDate], [EndDate], [Deadline], [DurationDays], [Constraint], [ConstraintDate], [IsMilestone], [Notes], [ParentRelayCategoryTaskID], [CompletedDate], [CreateUserID], [CreateTimestamp], [LastUpdateUserID], [LastUpdateTimestamp]) VALUES (18, N'92d65d99-d9eb-ee11-9fc2-f875a42879af', 9, N'Turn-in', 0, CAST(N'2024-04-19' AS Date), NULL, CAST(N'2024-04-20' AS Date), 1, 3, CAST(N'2024-04-20' AS Date), 1, N'Complete relay turn-in.', NULL, NULL, N'DOMAIN\user', CAST(N'2024-03-26T20:30:31.9466667' AS DateTime2), N'DOMAIN\user', CAST(N'2024-06-21T23:32:06.2166667' AS DateTime2))
  45. GO
  46. INSERT [dbo].[relay_category_task] ([RelayCategoryTaskID], [RelayCategoryTaskGUID], [RelayCategoryAssociationID], [Name], [PercentComplete], [StartDate], [EndDate], [Deadline], [DurationDays], [Constraint], [ConstraintDate], [IsMilestone], [Notes], [ParentRelayCategoryTaskID], [CompletedDate], [CreateUserID], [CreateTimestamp], [LastUpdateUserID], [LastUpdateTimestamp]) VALUES (19, N'972ec391-7cec-ee11-9fc2-f875a42879af', 10, N'Kickoff', 0, CAST(N'2024-03-27' AS Date), NULL, NULL, 0, 7, CAST(N'2024-03-27' AS Date), 1, N'Relay kick-off.', NULL, NULL, N'DOMAIN\mprophet', CAST(N'2024-03-27T15:57:07.1166667' AS DateTime2), N'DOMAIN\user', CAST(N'2024-06-21T23:12:12.4200000' AS DateTime2))
  47. GO
  48. INSERT [dbo].[relay_category_task] ([RelayCategoryTaskID], [RelayCategoryTaskGUID], [RelayCategoryAssociationID], [Name], [PercentComplete], [StartDate], [EndDate], [Deadline], [DurationDays], [Constraint], [ConstraintDate], [IsMilestone], [Notes], [ParentRelayCategoryTaskID], [CompletedDate], [CreateUserID], [CreateTimestamp], [LastUpdateUserID], [LastUpdateTimestamp]) VALUES (20, N'982ec391-7cec-ee11-9fc2-f875a42879af', 10, N'Turn-in', 0, CAST(N'2024-04-12' AS Date), NULL, CAST(N'2024-04-12' AS Date), 1, 3, CAST(N'2024-04-12' AS Date), 1, N'Complete relay turn-in.', NULL, NULL, N'DOMAIN\mprophet', CAST(N'2024-03-27T15:57:07.1300000' AS DateTime2), N'DOMAIN\user', CAST(N'2024-06-21T23:12:12.4666667' AS DateTime2))
  49. GO
  50. INSERT [dbo].[relay_category_task] ([RelayCategoryTaskID], [RelayCategoryTaskGUID], [RelayCategoryAssociationID], [Name], [PercentComplete], [StartDate], [EndDate], [Deadline], [DurationDays], [Constraint], [ConstraintDate], [IsMilestone], [Notes], [ParentRelayCategoryTaskID], [CompletedDate], [CreateUserID], [CreateTimestamp], [LastUpdateUserID], [LastUpdateTimestamp]) VALUES (21, N'3bcb7f12-93ce-4d1c-bc5e-fb18c9a477d2', 10, N'Data Collection', 0, CAST(N'2024-03-27' AS Date), NULL, NULL, 3, 1, CAST(N'2024-03-27' AS Date), 0, N'', NULL, NULL, N'DOMAIN\mprophet', CAST(N'2024-03-27T16:00:40.5833333' AS DateTime2), N'DOMAIN\user', CAST(N'2024-06-21T23:12:12.5200000' AS DateTime2))
  51. GO
  52. INSERT [dbo].[relay_category_task] ([RelayCategoryTaskID], [RelayCategoryTaskGUID], [RelayCategoryAssociationID], [Name], [PercentComplete], [StartDate], [EndDate], [Deadline], [DurationDays], [Constraint], [ConstraintDate], [IsMilestone], [Notes], [ParentRelayCategoryTaskID], [CompletedDate], [CreateUserID], [CreateTimestamp], [LastUpdateUserID], [LastUpdateTimestamp]) VALUES (23, N'44f394cc-81db-40f3-a170-183b9fe5bac7', 9, N'Buyer Meeting', 100, CAST(N'2024-03-29' AS Date), NULL, NULL, 1, 6, CAST(N'2024-03-29' AS Date), 0, N'', NULL, NULL, N'DOMAIN\user', CAST(N'2024-04-02T00:13:07.3266667' AS DateTime2), N'DOMAIN\user', CAST(N'2024-06-21T23:32:06.2666667' AS DateTime2))
  53. GO
  54. INSERT [dbo].[relay_category_task] ([RelayCategoryTaskID], [RelayCategoryTaskGUID], [RelayCategoryAssociationID], [Name], [PercentComplete], [StartDate], [EndDate], [Deadline], [DurationDays], [Constraint], [ConstraintDate], [IsMilestone], [Notes], [ParentRelayCategoryTaskID], [CompletedDate], [CreateUserID], [CreateTimestamp], [LastUpdateUserID], [LastUpdateTimestamp]) VALUES (24, N'45f997f3-0230-4824-9f5e-24c521ea4b30', 9, N'Pull data', 100, CAST(N'2024-04-01' AS Date), NULL, NULL, 1, 6, CAST(N'2024-04-01' AS Date), 0, N'', NULL, NULL, N'DOMAIN\user', CAST(N'2024-04-02T00:14:19.8933333' AS DateTime2), N'DOMAIN\user', CAST(N'2024-06-21T23:32:06.3300000' AS DateTime2))
  55. GO
  56. INSERT [dbo].[relay_category_task] ([RelayCategoryTaskID], [RelayCategoryTaskGUID], [RelayCategoryAssociationID], [Name], [PercentComplete], [StartDate], [EndDate], [Deadline], [DurationDays], [Constraint], [ConstraintDate], [IsMilestone], [Notes], [ParentRelayCategoryTaskID], [CompletedDate], [CreateUserID], [CreateTimestamp], [LastUpdateUserID], [LastUpdateTimestamp]) VALUES (25, N'498a1ce8-7f96-4161-bbee-cb2d81c80f38', 9, N'Draw', 0, CAST(N'2024-04-02' AS Date), NULL, NULL, 17, 1, CAST(N'2024-04-02' AS Date), 0, N'', NULL, NULL, N'DOMAIN\user', CAST(N'2024-04-02T00:14:56.2666667' AS DateTime2), N'DOMAIN\user', CAST(N'2024-06-21T23:32:06.3866667' AS DateTime2))
  57. GO
  58. INSERT [dbo].[relay_category_task] ([RelayCategoryTaskID], [RelayCategoryTaskGUID], [RelayCategoryAssociationID], [Name], [PercentComplete], [StartDate], [EndDate], [Deadline], [DurationDays], [Constraint], [ConstraintDate], [IsMilestone], [Notes], [ParentRelayCategoryTaskID], [CompletedDate], [CreateUserID], [CreateTimestamp], [LastUpdateUserID], [LastUpdateTimestamp]) VALUES (26, N'7025c677-f665-456d-9cb2-f4c665bd420e', 9, N'submit', 0, CAST(N'2024-04-19' AS Date), NULL, NULL, 1, 6, CAST(N'2024-04-05' AS Date), 0, N'', NULL, NULL, N'DOMAIN\user', CAST(N'2024-04-02T00:15:52.3300000' AS DateTime2), N'DOMAIN\user', CAST(N'2024-06-21T23:32:06.4366667' AS DateTime2))
  59. GO
  60. INSERT [dbo].[relay_category_task] ([RelayCategoryTaskID], [RelayCategoryTaskGUID], [RelayCategoryAssociationID], [Name], [PercentComplete], [StartDate], [EndDate], [Deadline], [DurationDays], [Constraint], [ConstraintDate], [IsMilestone], [Notes], [ParentRelayCategoryTaskID], [CompletedDate], [CreateUserID], [CreateTimestamp], [LastUpdateUserID], [LastUpdateTimestamp]) VALUES (27, N'ca15946e-380e-4626-b6e6-f6630090b82e', 9, N'Adds & Deletes', 0, CAST(N'2024-04-03' AS Date), NULL, NULL, 3, 6, CAST(N'2024-04-03' AS Date), 0, N'', 25, NULL, N'DOMAIN\user', CAST(N'2024-04-02T00:46:06.5366667' AS DateTime2), N'DOMAIN\user', CAST(N'2024-06-21T23:32:06.5000000' AS DateTime2))
  61. GO
  62. INSERT [dbo].[relay_category_task] ([RelayCategoryTaskID], [RelayCategoryTaskGUID], [RelayCategoryAssociationID], [Name], [PercentComplete], [StartDate], [EndDate], [Deadline], [DurationDays], [Constraint], [ConstraintDate], [IsMilestone], [Notes], [ParentRelayCategoryTaskID], [CompletedDate], [CreateUserID], [CreateTimestamp], [LastUpdateUserID], [LastUpdateTimestamp]) VALUES (28, N'c8486aa1-04c2-492a-9497-f5a372c59bcf', 9, N'Populate performance data', 0, CAST(N'2024-04-02' AS Date), NULL, NULL, 1, 6, CAST(N'2024-04-02' AS Date), 0, N'', 25, NULL, N'DOMAIN\user', CAST(N'2024-04-02T00:46:41.9500000' AS DateTime2), N'DOMAIN\user', CAST(N'2024-06-21T23:32:06.5566667' AS DateTime2))
  63. GO
  64. INSERT [dbo].[relay_category_task] ([RelayCategoryTaskID], [RelayCategoryTaskGUID], [RelayCategoryAssociationID], [Name], [PercentComplete], [StartDate], [EndDate], [Deadline], [DurationDays], [Constraint], [ConstraintDate], [IsMilestone], [Notes], [ParentRelayCategoryTaskID], [CompletedDate], [CreateUserID], [CreateTimestamp], [LastUpdateUserID], [LastUpdateTimestamp]) VALUES (1022, N'1ea8a66b-0bf1-ee11-9fc4-f875a42879af', 11, N'Kickoff', 0, CAST(N'2024-04-02' AS Date), NULL, NULL, 0, 7, CAST(N'2024-04-02' AS Date), 1, N'Relay kick-off.', NULL, NULL, N'DOMAIN\user', CAST(N'2024-04-02T11:09:45.8400000' AS DateTime2), N'DOMAIN\user', CAST(N'2024-06-21T23:32:07.4700000' AS DateTime2))
  65. GO
  66. INSERT [dbo].[relay_category_task] ([RelayCategoryTaskID], [RelayCategoryTaskGUID], [RelayCategoryAssociationID], [Name], [PercentComplete], [StartDate], [EndDate], [Deadline], [DurationDays], [Constraint], [ConstraintDate], [IsMilestone], [Notes], [ParentRelayCategoryTaskID], [CompletedDate], [CreateUserID], [CreateTimestamp], [LastUpdateUserID], [LastUpdateTimestamp]) VALUES (1023, N'1fa8a66b-0bf1-ee11-9fc4-f875a42879af', 11, N'Turn-in', 0, CAST(N'2024-05-11' AS Date), NULL, CAST(N'2024-05-12' AS Date), 1, 3, CAST(N'2024-05-12' AS Date), 1, N'Complete relay turn-in.', NULL, NULL, N'DOMAIN\user', CAST(N'2024-04-02T11:09:45.8500000' AS DateTime2), N'DOMAIN\user', CAST(N'2024-06-21T23:32:07.5266667' AS DateTime2))
  67. GO
  68. INSERT [dbo].[relay_category_task] ([RelayCategoryTaskID], [RelayCategoryTaskGUID], [RelayCategoryAssociationID], [Name], [PercentComplete], [StartDate], [EndDate], [Deadline], [DurationDays], [Constraint], [ConstraintDate], [IsMilestone], [Notes], [ParentRelayCategoryTaskID], [CompletedDate], [CreateUserID], [CreateTimestamp], [LastUpdateUserID], [LastUpdateTimestamp]) VALUES (1024, N'5459084a-e2fe-49c5-9633-998205ab35b1', 9, N'Buyer changes', 0, CAST(N'2024-04-08' AS Date), NULL, NULL, 3, 6, CAST(N'2024-04-08' AS Date), 0, N'', 25, NULL, N'DOMAIN\user', CAST(N'2024-04-02T13:00:17.8000000' AS DateTime2), N'DOMAIN\user', CAST(N'2024-06-21T23:32:06.6100000' AS DateTime2))
  69. GO
  70. INSERT [dbo].[relay_category_task] ([RelayCategoryTaskID], [RelayCategoryTaskGUID], [RelayCategoryAssociationID], [Name], [PercentComplete], [StartDate], [EndDate], [Deadline], [DurationDays], [Constraint], [ConstraintDate], [IsMilestone], [Notes], [ParentRelayCategoryTaskID], [CompletedDate], [CreateUserID], [CreateTimestamp], [LastUpdateUserID], [LastUpdateTimestamp]) VALUES (1026, N'8e0307be-540d-437c-8c46-f79ac3608ac5', 9, N'Prep data', 0, CAST(N'2024-04-03' AS Date), NULL, NULL, 1, 6, CAST(N'2024-04-03' AS Date), 0, N'', 27, NULL, N'DOMAIN\user', CAST(N'2024-04-02T13:03:21.5133333' AS DateTime2), N'DOMAIN\user', CAST(N'2024-06-21T23:32:06.6633333' AS DateTime2))
  71. GO
  72. INSERT [dbo].[relay_category_task] ([RelayCategoryTaskID], [RelayCategoryTaskGUID], [RelayCategoryAssociationID], [Name], [PercentComplete], [StartDate], [EndDate], [Deadline], [DurationDays], [Constraint], [ConstraintDate], [IsMilestone], [Notes], [ParentRelayCategoryTaskID], [CompletedDate], [CreateUserID], [CreateTimestamp], [LastUpdateUserID], [LastUpdateTimestamp]) VALUES (1027, N'd24a90b5-f8eb-4cc5-9d98-74aa23186740', 9, N'drawing changes', 0, CAST(N'2024-04-04' AS Date), NULL, NULL, 1, 6, CAST(N'2024-04-04' AS Date), 0, N'', 27, NULL, N'DOMAIN\user', CAST(N'2024-04-02T13:03:54.4566667' AS DateTime2), N'DOMAIN\user', CAST(N'2024-06-21T23:32:06.7133333' AS DateTime2))
  73. GO
  74. INSERT [dbo].[relay_category_task] ([RelayCategoryTaskID], [RelayCategoryTaskGUID], [RelayCategoryAssociationID], [Name], [PercentComplete], [StartDate], [EndDate], [Deadline], [DurationDays], [Constraint], [ConstraintDate], [IsMilestone], [Notes], [ParentRelayCategoryTaskID], [CompletedDate], [CreateUserID], [CreateTimestamp], [LastUpdateUserID], [LastUpdateTimestamp]) VALUES (1028, N'6d31ccbd-0005-4282-b0d5-67451f0bee64', 9, N'Buyer review', 0, CAST(N'2024-04-05' AS Date), NULL, NULL, 1, 6, CAST(N'2024-04-05' AS Date), 0, N'', 27, NULL, N'DOMAIN\user', CAST(N'2024-04-02T13:04:15.5333333' AS DateTime2), N'DOMAIN\user', CAST(N'2024-06-21T23:32:06.7766667' AS DateTime2))
  75. GO
  76. INSERT [dbo].[relay_category_task] ([RelayCategoryTaskID], [RelayCategoryTaskGUID], [RelayCategoryAssociationID], [Name], [PercentComplete], [StartDate], [EndDate], [Deadline], [DurationDays], [Constraint], [ConstraintDate], [IsMilestone], [Notes], [ParentRelayCategoryTaskID], [CompletedDate], [CreateUserID], [CreateTimestamp], [LastUpdateUserID], [LastUpdateTimestamp]) VALUES (1029, N'7cb0939b-5c64-4ba8-a940-83b954b9869f', 9, N'Prep data', 0, CAST(N'2024-04-08' AS Date), NULL, NULL, 1, 6, CAST(N'2024-04-08' AS Date), 0, N'', 1024, NULL, N'DOMAIN\user', CAST(N'2024-04-02T13:05:15.7166667' AS DateTime2), N'DOMAIN\user', CAST(N'2024-06-21T23:32:06.8300000' AS DateTime2))
  77. GO
  78. INSERT [dbo].[relay_category_task] ([RelayCategoryTaskID], [RelayCategoryTaskGUID], [RelayCategoryAssociationID], [Name], [PercentComplete], [StartDate], [EndDate], [Deadline], [DurationDays], [Constraint], [ConstraintDate], [IsMilestone], [Notes], [ParentRelayCategoryTaskID], [CompletedDate], [CreateUserID], [CreateTimestamp], [LastUpdateUserID], [LastUpdateTimestamp]) VALUES (1030, N'62127655-8be6-45f6-83a2-7a74c64faf8c', 9, N'Make changes', 0, CAST(N'2024-04-09' AS Date), NULL, NULL, 1, 6, CAST(N'2024-04-09' AS Date), 0, N'', 1024, NULL, N'DOMAIN\user', CAST(N'2024-04-02T13:05:32.3300000' AS DateTime2), N'DOMAIN\user', CAST(N'2024-06-21T23:32:06.8866667' AS DateTime2))
  79. GO
  80. INSERT [dbo].[relay_category_task] ([RelayCategoryTaskID], [RelayCategoryTaskGUID], [RelayCategoryAssociationID], [Name], [PercentComplete], [StartDate], [EndDate], [Deadline], [DurationDays], [Constraint], [ConstraintDate], [IsMilestone], [Notes], [ParentRelayCategoryTaskID], [CompletedDate], [CreateUserID], [CreateTimestamp], [LastUpdateUserID], [LastUpdateTimestamp]) VALUES (1031, N'8a9921ee-8f68-41dd-8c94-63f5901f7651', 9, N'Buyer review', 0, CAST(N'2024-04-10' AS Date), NULL, NULL, 1, 6, CAST(N'2024-04-10' AS Date), 0, N'', 1024, NULL, N'DOMAIN\user', CAST(N'2024-04-02T13:06:01.0666667' AS DateTime2), N'DOMAIN\user', CAST(N'2024-06-21T23:32:06.9500000' AS DateTime2))
  81. GO
  82. INSERT [dbo].[relay_category_task] ([RelayCategoryTaskID], [RelayCategoryTaskGUID], [RelayCategoryAssociationID], [Name], [PercentComplete], [StartDate], [EndDate], [Deadline], [DurationDays], [Constraint], [ConstraintDate], [IsMilestone], [Notes], [ParentRelayCategoryTaskID], [CompletedDate], [CreateUserID], [CreateTimestamp], [LastUpdateUserID], [LastUpdateTimestamp]) VALUES (1032, N'46d76dbe-fe6a-4fdb-8451-d0cea314cabf', 9, N'Validations', 0, CAST(N'2024-04-11' AS Date), NULL, NULL, 5, 6, CAST(N'2024-04-02' AS Date), 0, N'', 25, NULL, N'DOMAIN\user', CAST(N'2024-04-02T13:44:01.5800000' AS DateTime2), N'DOMAIN\user', CAST(N'2024-06-21T23:32:07.0066667' AS DateTime2))
  83. GO
  84. INSERT [dbo].[relay_category_task] ([RelayCategoryTaskID], [RelayCategoryTaskGUID], [RelayCategoryAssociationID], [Name], [PercentComplete], [StartDate], [EndDate], [Deadline], [DurationDays], [Constraint], [ConstraintDate], [IsMilestone], [Notes], [ParentRelayCategoryTaskID], [CompletedDate], [CreateUserID], [CreateTimestamp], [LastUpdateUserID], [LastUpdateTimestamp]) VALUES (1034, N'74f025e5-c45e-40e3-91a8-3ced6744baaf', 9, N'Critical mass', 0, CAST(N'2024-04-11' AS Date), NULL, NULL, 1, 6, CAST(N'2024-04-02' AS Date), 0, N'', 1032, NULL, N'DOMAIN\user', CAST(N'2024-04-02T13:44:17.9266667' AS DateTime2), N'DOMAIN\user', CAST(N'2024-06-21T23:32:07.0533333' AS DateTime2))
  85. GO
  86. INSERT [dbo].[relay_category_task] ([RelayCategoryTaskID], [RelayCategoryTaskGUID], [RelayCategoryAssociationID], [Name], [PercentComplete], [StartDate], [EndDate], [Deadline], [DurationDays], [Constraint], [ConstraintDate], [IsMilestone], [Notes], [ParentRelayCategoryTaskID], [CompletedDate], [CreateUserID], [CreateTimestamp], [LastUpdateUserID], [LastUpdateTimestamp]) VALUES (1035, N'15eadc1c-52dd-4f47-b3fd-9428bc1aed24', 9, N'required mod changes', 0, CAST(N'2024-04-12' AS Date), NULL, NULL, 4, 6, CAST(N'2024-04-12' AS Date), 0, N'', 1032, NULL, N'DOMAIN\user', CAST(N'2024-04-02T13:45:23.2366667' AS DateTime2), N'DOMAIN\user', CAST(N'2024-06-21T23:32:07.1066667' AS DateTime2))
  87. GO
  88. INSERT [dbo].[relay_category_task] ([RelayCategoryTaskID], [RelayCategoryTaskGUID], [RelayCategoryAssociationID], [Name], [PercentComplete], [StartDate], [EndDate], [Deadline], [DurationDays], [Constraint], [ConstraintDate], [IsMilestone], [Notes], [ParentRelayCategoryTaskID], [CompletedDate], [CreateUserID], [CreateTimestamp], [LastUpdateUserID], [LastUpdateTimestamp]) VALUES (1036, N'8d0c7746-42f1-40fb-87c9-477292c64739', 9, N'Submission', 0, CAST(N'2024-04-16' AS Date), NULL, NULL, 3, 1, CAST(N'2024-04-02' AS Date), 0, N'', 25, NULL, N'DOMAIN\user', CAST(N'2024-04-02T13:46:13.6933333' AS DateTime2), N'DOMAIN\user', CAST(N'2024-06-21T23:32:07.1700000' AS DateTime2))
  89. GO
  90. INSERT [dbo].[relay_category_task] ([RelayCategoryTaskID], [RelayCategoryTaskGUID], [RelayCategoryAssociationID], [Name], [PercentComplete], [StartDate], [EndDate], [Deadline], [DurationDays], [Constraint], [ConstraintDate], [IsMilestone], [Notes], [ParentRelayCategoryTaskID], [CompletedDate], [CreateUserID], [CreateTimestamp], [LastUpdateUserID], [LastUpdateTimestamp]) VALUES (1037, N'86e4bca8-b0f4-44f5-803e-01472e5e13bc', 9, N'Validate product data matches retailer', 0, CAST(N'2024-04-16' AS Date), NULL, NULL, 1, 6, CAST(N'2024-04-02' AS Date), 0, N'', 1036, NULL, N'DOMAIN\user', CAST(N'2024-04-02T13:46:25.1266667' AS DateTime2), N'DOMAIN\user', CAST(N'2024-06-21T23:32:07.2266667' AS DateTime2))
  91. GO
  92. INSERT [dbo].[relay_category_task] ([RelayCategoryTaskID], [RelayCategoryTaskGUID], [RelayCategoryAssociationID], [Name], [PercentComplete], [StartDate], [EndDate], [Deadline], [DurationDays], [Constraint], [ConstraintDate], [IsMilestone], [Notes], [ParentRelayCategoryTaskID], [CompletedDate], [CreateUserID], [CreateTimestamp], [LastUpdateUserID], [LastUpdateTimestamp]) VALUES (1038, N'442e332c-56f7-47a8-ac35-ca6ffe4fed50', 9, N'Test submission', 0, CAST(N'2024-04-17' AS Date), NULL, NULL, 1, 6, CAST(N'2024-04-17' AS Date), 0, N'', 1036, NULL, N'DOMAIN\user', CAST(N'2024-04-02T14:00:46.4500000' AS DateTime2), N'DOMAIN\user', CAST(N'2024-06-21T23:32:07.2833333' AS DateTime2))
  93. GO
  94. INSERT [dbo].[relay_category_task] ([RelayCategoryTaskID], [RelayCategoryTaskGUID], [RelayCategoryAssociationID], [Name], [PercentComplete], [StartDate], [EndDate], [Deadline], [DurationDays], [Constraint], [ConstraintDate], [IsMilestone], [Notes], [ParentRelayCategoryTaskID], [CompletedDate], [CreateUserID], [CreateTimestamp], [LastUpdateUserID], [LastUpdateTimestamp]) VALUES (1039, N'ff664dec-2e54-4d96-aae4-da7b7abdac74', 9, N'Submit', 0, CAST(N'2024-04-18' AS Date), NULL, NULL, 1, 6, CAST(N'2024-04-16' AS Date), 0, N'', 1036, NULL, N'DOMAIN\user', CAST(N'2024-04-02T14:19:24.0566667' AS DateTime2), N'DOMAIN\user', CAST(N'2024-06-21T23:32:07.3433333' AS DateTime2))
  95. GO
  96. INSERT [dbo].[relay_category_task] ([RelayCategoryTaskID], [RelayCategoryTaskGUID], [RelayCategoryAssociationID], [Name], [PercentComplete], [StartDate], [EndDate], [Deadline], [DurationDays], [Constraint], [ConstraintDate], [IsMilestone], [Notes], [ParentRelayCategoryTaskID], [CompletedDate], [CreateUserID], [CreateTimestamp], [LastUpdateUserID], [LastUpdateTimestamp]) VALUES (1040, N'1211c86c-24e1-4fbf-8eec-7446c120b718', 9, N'Buyer Review', 0, CAST(N'2024-04-26' AS Date), NULL, NULL, 1, 6, CAST(N'2024-04-26' AS Date), 0, N'', NULL, NULL, N'DOMAIN\user', CAST(N'2024-04-02T15:56:15.4000000' AS DateTime2), N'DOMAIN\user', CAST(N'2024-06-21T23:32:07.4033333' AS DateTime2))
  97. GO
  98. INSERT [dbo].[relay_category_task] ([RelayCategoryTaskID], [RelayCategoryTaskGUID], [RelayCategoryAssociationID], [Name], [PercentComplete], [StartDate], [EndDate], [Deadline], [DurationDays], [Constraint], [ConstraintDate], [IsMilestone], [Notes], [ParentRelayCategoryTaskID], [CompletedDate], [CreateUserID], [CreateTimestamp], [LastUpdateUserID], [LastUpdateTimestamp]) VALUES (1052, N'00f96465-b4ca-42e7-87e4-b56f6a5d62af', 11, N'New Task', 0, CAST(N'2024-04-17' AS Date), NULL, NULL, 1, 6, CAST(N'2024-04-17' AS Date), 0, N'', NULL, NULL, N'DOMAIN\user', CAST(N'2024-04-12T19:56:57.6800000' AS DateTime2), N'DOMAIN\user', CAST(N'2024-06-21T23:32:07.5733333' AS DateTime2))
  99. GO
  100. INSERT [dbo].[relay_category_task] ([RelayCategoryTaskID], [RelayCategoryTaskGUID], [RelayCategoryAssociationID], [Name], [PercentComplete], [StartDate], [EndDate], [Deadline], [DurationDays], [Constraint], [ConstraintDate], [IsMilestone], [Notes], [ParentRelayCategoryTaskID], [CompletedDate], [CreateUserID], [CreateTimestamp], [LastUpdateUserID], [LastUpdateTimestamp]) VALUES (1053, N'a0e9df3a-f58a-45a4-bf3b-ac1a01746467', 11, N'New Task', 0, CAST(N'2024-04-19' AS Date), NULL, NULL, 1, 6, CAST(N'2024-04-19' AS Date), 0, N'', NULL, NULL, N'DOMAIN\user', CAST(N'2024-04-12T19:57:06.3600000' AS DateTime2), N'DOMAIN\user', CAST(N'2024-06-21T23:32:07.6266667' AS DateTime2))
  101. GO
  102. INSERT [dbo].[relay_category_task] ([RelayCategoryTaskID], [RelayCategoryTaskGUID], [RelayCategoryAssociationID], [Name], [PercentComplete], [StartDate], [EndDate], [Deadline], [DurationDays], [Constraint], [ConstraintDate], [IsMilestone], [Notes], [ParentRelayCategoryTaskID], [CompletedDate], [CreateUserID], [CreateTimestamp], [LastUpdateUserID], [LastUpdateTimestamp]) VALUES (1054, N'dd738968-91b9-4a06-9a68-4b69beff829a', 11, N'New Task', 0, CAST(N'2024-04-22' AS Date), NULL, NULL, 1, 6, CAST(N'2024-04-22' AS Date), 0, N'', NULL, NULL, N'DOMAIN\user', CAST(N'2024-04-12T20:05:26.0066667' AS DateTime2), N'DOMAIN\user', CAST(N'2024-06-21T23:32:07.6800000' AS DateTime2))
  103. GO
  104. SET IDENTITY_INSERT [dbo].[relay_category_task] OFF
  105. GO
  106. /****** Object:  Index [relay_category_task_UNCIX1]    Script Date: 6/25/2024 10:37:08 AM ******/
  107. CREATE UNIQUE NONCLUSTERED INDEX [relay_category_task_UNCIX1] ON [dbo].[relay_category_task]
  108. (
  109.     [RelayCategoryTaskGUID] ASC
  110. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
  111. GO
  112. ALTER TABLE [dbo].[relay_category_task] ADD  DEFAULT (newsequentialid()) FOR [RelayCategoryTaskGUID]
  113. GO
  114. ALTER TABLE [dbo].[relay_category_task] ADD  DEFAULT ((0)) FOR [PercentComplete]
  115. GO
  116. ALTER TABLE [dbo].[relay_category_task] ADD  DEFAULT ((1)) FOR [DurationDays]
  117. GO
  118. ALTER TABLE [dbo].[relay_category_task] ADD  DEFAULT ((0)) FOR [IsMilestone]
  119. GO
  120. ALTER TABLE [dbo].[relay_category_task] ADD  DEFAULT (suser_sname()) FOR [CreateUserID]
  121. GO
  122. ALTER TABLE [dbo].[relay_category_task] ADD  DEFAULT (getdate()) FOR [CreateTimestamp]
  123. GO
  124. ALTER TABLE [dbo].[relay_category_task] ADD  DEFAULT (suser_sname()) FOR [LastUpdateUserID]
  125. GO
  126. ALTER TABLE [dbo].[relay_category_task] ADD  DEFAULT (getdate()) FOR [LastUpdateTimestamp]
  127. GO
  128. ALTER TABLE [dbo].[relay_category_task]  WITH CHECK ADD CHECK  (([DurationDays]>=(0)))
  129. GO
  130. ALTER TABLE [dbo].[relay_category_task]  WITH CHECK ADD CHECK  (([PercentComplete]>=(0) AND [PercentComplete]<=(100)))
  131. GO
  132.  
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!