3
# Script to create a table 'FPdev' and to fill it with data.
4
# The script accepts an optional argument :
5
# A database to connect to. (default 'testdb')
9
# Choose one of the following:
11
ISQL=/opt/interbase/bin/isql
13
# Don't edit after this.
15
echo -n "Creating and filling table FPdev in database $DATABASE..."
19
CREATE DATABASE "$DATABASE";
25
insert into FPdev values ('1','Michael Van Canneyt','Michael@tfdec1.fys.kuleuven.ac.be');
26
insert into FPdev values ('2','Florian Klaempfl','ba2395@fen.baynet.de');
27
insert into FPdev values ('3','Carl-Eric Codere','codc01@gel.usherb.ca');
28
insert into FPdev values ('4','Daniel Mantione','d.s.p.mantione@twi.tudelft.nl');
29
insert into FPdev values ('5','Pierre Muller','muller@europe.u-strasbg.fr');
30
insert into FPdev values ('6','Jonas Maebe','jmaebe@mail.dma.be');
31
insert into FPdev values ('7','Peter Vreman','pfv@worldonline.nl');
32
insert into FPdev values ('8','Gerry Dubois','gerry@webworks.ml.org');
34
timestamp_fld timestamp,
35
smallint_fld smallint,
38
double_fld double precision,
40
varchar_fld varchar(50));
41
insert into test values ('12.1.2000 00:30',10,70000,12.5,20.5,'testchar','testvarchar');