From 20d0aee3f0bf987eb7e8999977bb25577df7b2d3 Mon Sep 17 00:00:00 2001
From: FChannel <>
Date: Thu, 13 May 2021 22:15:52 -0700
Subject: moved creating database schema into main program

---
 main.go | 12 +++++++++++-
 1 file changed, 11 insertions(+), 1 deletion(-)

(limited to 'main.go')

diff --git a/main.go b/main.go
index c5229dc..37fdd0c 100644
--- a/main.go
+++ b/main.go
@@ -48,6 +48,8 @@ func main() {
 
 	defer db.Close()
 
+	RunDatabaseSchema(db)
+	
 	go MakeCaptchas(db, 100)
 
 	*Key = CreateClientKey()
@@ -55,7 +57,7 @@ func main() {
 	FollowingBoards = GetActorFollowingDB(db, Domain)
 	
 	Boards = GetBoardCollection(db)
-	
+
 	// root actor is used to follow remote feeds that are not local
 	//name, prefname, summary, auth requirements, restricted
 	if GetConfigValue("instancename") != "" {
@@ -2015,3 +2017,11 @@ func remoteShort(url string) string {
 
 		return "f" + actorname + "-" + id
 }
+
+func RunDatabaseSchema(db *sql.DB) {
+	query, err := ioutil.ReadFile("databaseschema.psql")
+	CheckError(err, "could not read databaseschema.psql file")
+	if _, err := db.Exec(string(query)); err != nil {
+		CheckError(err, "could not exec databaseschema.psql")		
+	}
+}
-- 
cgit v1.2.3