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 functions.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