freepascal.compiler/packages/mysql/scripts/mkdb

#!/bin/sh
#
# Script to create a table 'FPdev' and to fill it with data.
# The script accepts an optional argument : 
# A database to connect to. (default 'testdb')
echo -n "Creating and filling table FPdev in database ${1-testdb}..."
mysql ${1-testdb} << EOF >/dev/null
create table FPdev ( 
id INT NOT NULL,
UserName CHAR(255),
InstEmail CHAR(255),
PRIMARY KEY (id),
INDEX (id) );
insert into FPdev values ('1','Michael Van Canneyt','[email protected]');
insert into FPdev values ('2','Florian Klaempfl','[email protected]');
insert into FPdev values ('3','Carl-Eric Codere','[email protected]');
insert into FPdev values ('4','Daniel Mantione','[email protected]');
insert into FPdev values ('5','Pierre Muller','[email protected]');
insert into FPdev values ('6','Jonas Maebe','[email protected]');
insert into FPdev values ('7','Peter Vreman','[email protected]');
insert into FPdev values ('8','Gerry Dubois','[email protected]');
EOF
if [ ! $? = 0 ]; then
  echo "Failed."
else
  echo "Done."
fi
# Ready