Changeset 8b6791f for src/FinkiChattery/FinkiChattery.Database/dbo/Tables/Question/Question.Debug.Seed.sql

Timestamp:

10/22/21 21:47:17 (3 years ago)

Author:

Стојков Марко <mst@…>

Branches:

dev

Children:

466d1ac, 5ad5988

Parents:

81c2e6f (diff), 70e04f1 (diff)
Note: this is a merge changeset, the changes displayed below correspond to the merge itself.
Use the (diff) links above to see all the changes relative to each parent.

Message:

Merged feature/preview-questions-and-search into dev

File:

• src/FinkiChattery/FinkiChattery.Database/dbo/Tables/Question/Question.Debug.Seed.sql (modified) (3 diffs)

src/FinkiChattery/FinkiChattery.Database/dbo/Tables/Question/Question.Debug.Seed.sql

@@ -9 +9 @@
         VALUES
             (1, N'aee193c3-9d36-4ed8-81b2-15eb4ff305f1', N'Question 1', 'Question 1 text', 1, GETUTCDATE(), NULL, 0,
-             GETUTCDATE()
+             GETUTCDATE(), 2
             ),
             (2, N'bee193c3-9d36-4ed8-81b2-15eb4ff305f1', N'Question 2', 'Question 2 text', 1, GETUTCDATE(), NULL, 0,
-             GETUTCDATE()
+             GETUTCDATE(), 2
             )
-    ) AS temp ([ID], [Uid], [Title], [Text], [StudentFk], [CreatedOn], [TeamFk], [Views], [LastActiveOn])
+    ) AS temp ([ID], [Uid], [Title], [Text], [StudentFk], [CreatedOn], [TeamFk], [Views], [LastActiveOn], [AnswersCount])
     ) AS S
     ON T.[ID] = S.[ID]
@@ -25 +25 @@
                    T.[TeamFk] = S.[TeamFk],
                    T.[Views] = S.[Views],
-                   T.[LastActiveOn] = S.[LastActiveOn]
+                   T.[LastActiveOn] = S.[LastActiveOn],
+                   T.[AnswersCount] = S.[AnswersCount]
     WHEN NOT MATCHED THEN
         INSERT
@@ -37 +38 @@
             [TeamFk],
             [Views],
-            [LastActiveOn]
+            [LastActiveOn],
+            [AnswersCount]
         )
         VALUES
-        (S.[ID], S.[Uid], S.[Title], S.[Text], S.[StudentFk], S.[CreatedOn], S.[TeamFk], S.[Views], S.[LastActiveOn]);
+        (S.[ID], S.[Uid], S.[Title], S.[Text], S.[StudentFk], S.[CreatedOn], S.[TeamFk], S.[Views], S.[LastActiveOn], S.[AnswersCount]);
     SET IDENTITY_INSERT [dbo].[Question] OFF
 END