From c804c2c158ea5b785311d0f453e717b33208b866 Mon Sep 17 00:00:00 2001
From: lonkaars <loek@pipeframe.xyz>
Date: Sun, 9 Apr 2023 13:12:55 +0200
Subject: update schema

---
 dbinit/makefile | 16 ++++++----------
 1 file changed, 6 insertions(+), 10 deletions(-)

(limited to 'dbinit/makefile')

diff --git a/dbinit/makefile b/dbinit/makefile
index f2dcd75..d20ebd2 100644
--- a/dbinit/makefile
+++ b/dbinit/makefile
@@ -2,35 +2,31 @@ SQL = mysql
 USER = $(shell id -un)
 HOST = localhost
 
-.PHONY: clean permissions init data procedures full
+.PHONY: clean permissions base data full
 
 all: full
 
 # delete old tables and create new tables
-init: base.sql
+base: base.sql
 	$(SQL) < $<
 
 # fill tables with data
 data: data.sql
 	$(SQL) < $<
 
-# add procedures/sql functions
-procedures: procedures.sql
-	$(SQL) < $<
-
-# do all of the above in one go
+# do everything
 full: full.sql
 	$(SQL) < $<
 
 base.sql: reset.sql init.sql
 	cat $^ > $@
 
-full.sql: reset.sql init.sql demo.sql views.sql functions.sql procedures.sql triggers.sql
-	cat $^ > $@
-
 data.sql:
 	./import.py > $@
 
+full.sql: base.sql data.sql views.sql functions.sql procedures.sql triggers.sql update.sql
+	cat $^ > $@
+
 # grant all database permissions (development only)
 permissions:
 	echo "grant all privileges on formula1.* to '$(USER)'@'$(HOST)';" | sudo $(SQL)
-- 
cgit v1.2.3