Add commenting system

2 files changed, 20 insertions, 0 deletions

diff --git a/internal/dbmigrations.go b/internal/dbmigrations.go
index fcbaaaf..41180c7 100644
--- a/internal/dbmigrations.go
+++ b/internal/dbmigrations.go
@@ -56,4 +56,12 @@ func Migrate(db *sql.DB, webmaster string, passOne string, passTwo string) {
 			fmt.Fprintf(os.Stderr, "Unable to create cookies table: %v\n", err)
 		}
 	}
+
+	_, table_check = db.Query("SELECT * FROM comments;")
+	if table_check != nil {
+		_, err := db.Exec("CREATE TABLE comments (id SERIAL PRIMARY KEY, verified BOOLEAN NOT NULL, time TIMESTAMP DEFAULT CURRENT_TIMESTAMP, name TEXT NOT NULL, post_id INTEGER REFERENCES posts(id), content TEXT NOT NULL);")
+		if err != nil {
+			fmt.Fprintf(os.Stderr, "Unable to create comments table: %v\n", err)
+		}
+	}
 }
diff --git a/internal/models/comment.go b/internal/models/comment.go
new file mode 100644
index 0000000..df27ca3
--- /dev/null
+++ b/internal/models/comment.go
@@ -0,0 +1,12 @@
+package models
+
+import "time"
+
+type Comment struct {
+	Id            int
+	IsVerified    bool
+	Time          time.Time
+	FormattedTime string
+	Name          string
+	Content       string
+}