From 25b6b8926d8cb3c4cabc8e7764e613d3bb4e4ed7 Mon Sep 17 00:00:00 2001
From: lonkaars <loek@pipeframe.xyz>
Date: Mon, 8 May 2023 12:39:19 +0200
Subject: add database init sql scripts

---
 db/makefile | 35 +++++++++++++++++++++++++++++++++++
 1 file changed, 35 insertions(+)
 create mode 100644 db/makefile

(limited to 'db/makefile')

diff --git a/db/makefile b/db/makefile
new file mode 100644
index 0000000..0802fa6
--- /dev/null
+++ b/db/makefile
@@ -0,0 +1,35 @@
+SQL = mysql
+USER = $(shell id -un)
+HOST = localhost
+
+.PHONY: clean permissions base data full
+
+all: full
+
+# delete old tables and create new tables
+base: base.sql
+	$(SQL) < $<
+
+# fill tables with data
+data: data.sql
+	$(SQL) < $<
+
+# do everything
+full: full.sql
+	$(SQL) < $<
+
+base.sql: reset.sql init.sql
+	cat $^ > $@
+
+full.sql: base.sql data.sql
+	cat $^ > $@
+
+# grant all database permissions to current user (development only)
+permissions:
+	echo "grant all privileges on webs.* to '$(USER)'@'$(HOST)';" | sudo $(SQL)
+# echo "grant file on *.* to '$(USER)'@'$(HOST)';" | sudo $(SQL)
+
+# delete generated sql files
+clean:
+	$(RM) full.sql base.sql
+
-- 
cgit v1.2.3