1 files changed, 132 insertions, 0 deletions
diff --git a/models/migrations/v147.go b/models/migrations/v147.go
new file mode 100644
index 0000000000..9716d6e83b
--- /dev/null
+++ b/models/migrations/v147.go
@@ -0,0 +1,132 @@
+// Copyright 2020 The Gitea Authors. All rights reserved.
+// Use of this source code is governed by a MIT-style
+// license that can be found in the LICENSE file.
+
+package migrations
+
+import (
+	"code.gitea.io/gitea/modules/timeutil"
+
+	"xorm.io/xorm"
+)
+
+func createReviewsForCodeComments(x *xorm.Engine) error {
+	// Review
+	type Review struct {
+		ID               int64 `xorm:"pk autoincr"`
+		Type             int
+		ReviewerID       int64 `xorm:"index"`
+		OriginalAuthor   string
+		OriginalAuthorID int64
+		IssueID          int64  `xorm:"index"`
+		Content          string `xorm:"TEXT"`
+		// Official is a review made by an assigned approver (counts towards approval)
+		Official bool   `xorm:"NOT NULL DEFAULT false"`
+		CommitID string `xorm:"VARCHAR(40)"`
+		Stale    bool   `xorm:"NOT NULL DEFAULT false"`
+
+		CreatedUnix timeutil.TimeStamp `xorm:"INDEX created"`
+		UpdatedUnix timeutil.TimeStamp `xorm:"INDEX updated"`
+	}
+
+	const ReviewTypeComment = 2
+
+	// Comment represents a comment in commit and issue page.
+	type Comment struct {
+		ID               int64 `xorm:"pk autoincr"`
+		Type             int   `xorm:"INDEX"`
+		PosterID         int64 `xorm:"INDEX"`
+		OriginalAuthor   string
+		OriginalAuthorID int64
+		IssueID          int64 `xorm:"INDEX"`
+		LabelID          int64
+		OldProjectID     int64
+		ProjectID        int64
+		OldMilestoneID   int64
+		MilestoneID      int64
+		AssigneeID       int64
+		RemovedAssignee  bool
+		ResolveDoerID    int64
+		OldTitle         string
+		NewTitle         string
+		OldRef           string
+		NewRef           string
+		DependentIssueID int64
+
+		CommitID int64
+		Line     int64 // - previous line / + proposed line
+		TreePath string
+		Content  string `xorm:"TEXT"`
+
+		// Path represents the 4 lines of code cemented by this comment
+		PatchQuoted string `xorm:"TEXT patch"`
+
+		CreatedUnix timeutil.TimeStamp `xorm:"INDEX created"`
+		UpdatedUnix timeutil.TimeStamp `xorm:"INDEX updated"`
+
+		// Reference issue in commit message
+		CommitSHA string `xorm:"VARCHAR(40)"`
+
+		ReviewID    int64 `xorm:"index"`
+		Invalidated bool
+
+		// Reference an issue or pull from another comment, issue or PR
+		// All information is about the origin of the reference
+		RefRepoID    int64 `xorm:"index"` // Repo where the referencing
+		RefIssueID   int64 `xorm:"index"`
+		RefCommentID int64 `xorm:"index"`    // 0 if origin is Issue title or content (or PR's)
+		RefAction    int   `xorm:"SMALLINT"` // What hapens if RefIssueID resolves
+		RefIsPull    bool
+	}
+
+	if err := x.Sync2(new(Review), new(Comment)); err != nil {
+		return err
+	}
+	sess := x.NewSession()
+	defer sess.Close()
+	if err := sess.Begin(); err != nil {
+		return err
+	}
+	if err := sess.Where("review_id = 0 and type = 21").Iterate(new(Comment), func(idx int, bean interface{}) error {
+		comment := bean.(*Comment)
+
+		review := &Review{
+			Type:             ReviewTypeComment,
+			ReviewerID:       comment.PosterID,
+			IssueID:          comment.IssueID,
+			Official:         false,
+			CommitID:         comment.CommitSHA,
+			Stale:            comment.Invalidated,
+			OriginalAuthor:   comment.OriginalAuthor,
+			OriginalAuthorID: comment.OriginalAuthorID,
+			CreatedUnix:      comment.CreatedUnix,
+			UpdatedUnix:      comment.CreatedUnix,
+		}
+		if _, err := sess.NoAutoTime().Insert(review); err != nil {
+			return err
+		}
+
+		reviewComment := &Comment{
+			Type:             22,
+			PosterID:         comment.PosterID,
+			Content:          "",
+			IssueID:          comment.IssueID,
+			ReviewID:         review.ID,
+			OriginalAuthor:   comment.OriginalAuthor,
+			OriginalAuthorID: comment.OriginalAuthorID,
+			CreatedUnix:      comment.CreatedUnix,
+			UpdatedUnix:      comment.CreatedUnix,
+		}
+		if _, err := sess.NoAutoTime().Insert(reviewComment); err != nil {
+			return err
+		}
+
+		comment.ReviewID = review.ID
+		_, err := sess.ID(comment.ID).Cols("review_id").NoAutoTime().Update(comment)
+		return err
+	}); err != nil {
+		return err
+	}
+
+	return sess.Commit()
+}