include ../Makefile.conf

createdb: createdb_$(DBVARIANT)

dropdb: dropdb_$(DBVARIANT)

# ----------------------------------------------------------------------
# PostgreSql
# ----------------------------------------------------------------------

createdb_pg:
	createdb wtimer
	psql -f wtimerdb_pg.sql wtimer

dropdb_pg: 
	dropdb wtimer

# ----------------------------------------------------------------------
# MySQL
# ----------------------------------------------------------------------

MY_OPTIONS = --password

createdb_my:
	mysql $(MY_OPTIONS) -e 'create database wtimer'
	mysql $(MY_OPTIONS) wtimer <wtimerdb_my.sql

dropdb_my:
	mysql $(MY_OPTIONS) -e 'drop database wtimer'