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
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
|
## ----------------------------------------------------------------------------
## --
## GNADE : GNu Ada Database Environment --
## --
## Filename : $Source: /var/cvs/gnuada/gnade/samples/sample_db/Makefile.mysql,v $
## Description : Makefile for the PostgreSQL sample database
## Author : Juergen Pfeifer <juergen.pfeifer@gmx.net>
## Created On : 03-Jan-2001
## Last Modified By: $Author: jp $
## Last Modified On: $Date: 2001/05/06 18:03:15 $
## Status : $State: Exp $
##
## Copyright (C) 2000-2001
##
## GNADE is copyrighted by the persons and institutions enumerated in the --
## AUTHORS file. This file is located in the root directory of the --
## GNADE distribution. --
## --
## GNADE is free software; you can redistribute it and/or modify it under --
## terms of the GNU General Public License as published by the Free Soft- --
## ware Foundation; either version 2, or (at your option) any later ver- --
## sion. GNAT is distributed in the hope that it will be useful, but WITH- --
## OUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY --
## or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License --
## for more details. You should have received a copy of the GNU General --
## Public License distributed with GNAT; see file COPYING. If not, write --
## to the Free Software Foundation, 59 Temple Place - Suite 330, Boston, --
## MA 02111-1307, USA. --
## --
## As a special exception, if other files instantiate generics from --
## GNADE Ada units, or you link GNADE Ada units or libraries with other --
## files to produce an executable, these units or libraries do not by --
## itself cause the resulting executable to be covered by the GNU --
## General Public License. This exception does not however invalidate --
## any other reasons why the executable file might be covered by the --
## GNU Public License. --
## --
## GNADE is implemented to work with GNAT, the GNU Ada compiler. --
## --
## ----------------------------------------------------------------------------
##
## Functional Description
## ======================
## This makefile creates the PostgreSQL sample database used in the
## various GNADE samples and tests. The database is populated with
## sample data.
##
## Restrictions
## ============
## The user running this makefile must have proper PostgreSQL rights to be
## able to delete the database, create a new one and to create the demo
## user. The demo user has username="gnade" and password="gnade".
##
## References
## ==========
##
sinclude ../conf.local
sinclude ../../make.conf
##
## Create a user in the mysql data base.
##
createuser ::
mysql -f -u root < create_user.mysql.sql
removeuser:
mysql -f -u root < remove_user.mysql.sql
##
## Create a data base
##
createdb :: .database
.database: $(SAMPLEDB).mysql.sql
-mysqladmin -u root -f drop $(SAMPLEDB)
mysqladmin -u root create $(SAMPLEDB)
mysql $(SAMPLEDB) < $(SAMPLEDB).mysql.sql
touch .database
##
## remove the database
##
removedb:
-mysqladmin -u root -f drop $(SAMPLEDB)
rm -f .database
|
