blob: 0802fa6f8cb4b14a1a57af2f558efc5dc6bbbf7e (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
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
|