From 5080c566ac31ec622986c04f1812a1e88c88210e Mon Sep 17 00:00:00 2001
From: Lizzy Hunt <lizzy.hunt@usu.edu>
Date: Fri, 29 Mar 2024 16:35:04 -0600
Subject: guestbook!

---
 database/migrate.go | 19 +++++++++++++++++++
 1 file changed, 19 insertions(+)

(limited to 'database/migrate.go')

diff --git a/database/migrate.go b/database/migrate.go
index de1db4c..1609bc2 100644
--- a/database/migrate.go
+++ b/database/migrate.go
@@ -102,6 +102,24 @@ func MigrateUserSessions(dbConn *sql.DB) (*sql.DB, error) {
 	return dbConn, nil
 }
 
+func MigrateGuestBook(dbConn *sql.DB) (*sql.DB, error) {
+	log.Println("migrating guest_book table")
+
+	_, err := dbConn.Exec(`CREATE TABLE IF NOT EXISTS guest_book (
+		id TEXT PRIMARY KEY,
+		name TEXT NOT NULL,
+		message TEXT NOT NULL,
+		created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
+	);`)
+	if err != nil {
+		return dbConn, err
+	}
+
+	_, err = dbConn.Exec(`CREATE INDEX IF NOT EXISTS idx_guest_book_created_at ON guest_book (created_at);`)
+
+	return dbConn, nil
+}
+
 func Migrate(dbConn *sql.DB) (*sql.DB, error) {
 	log.Println("migrating database")
 
@@ -111,6 +129,7 @@ func Migrate(dbConn *sql.DB) (*sql.DB, error) {
 		MigrateApiKeys,
 		MigrateDomainOwners,
 		MigrateDNSRecords,
+		MigrateGuestBook,
 	}
 
 	for _, migration := range migrations {
-- 
cgit v1.2.3-70-g09d2