diff options
Diffstat (limited to 'examples/gui/interbasetest/mkdb')
| -rw-r--r-- | examples/gui/interbasetest/mkdb | 53 |
1 files changed, 53 insertions, 0 deletions
diff --git a/examples/gui/interbasetest/mkdb b/examples/gui/interbasetest/mkdb new file mode 100644 index 00000000..b4142314 --- /dev/null +++ b/examples/gui/interbasetest/mkdb @@ -0,0 +1,53 @@ +#!/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') +# +# Collect the database +DATABASE=test.gdb +# Choose one of the following: +# ISQL=isql +ISQL=/opt/interbase/bin/isql +# +# Don't edit after this. +# +echo -n "Creating and filling table FPdev in database $DATABASE..." +# >/dev/null 2>&1 +${ISQL} << EOF +set sql dialect 3; +CREATE DATABASE "$DATABASE"; +create table FPDEV ( +id INT NOT NULL, +UserName varchar(50), +InstEmail CHAR(50), +PRIMARY KEY (id)); +insert into FPdev values ('1','Michael Van Canneyt','Michael@tfdec1.fys.kuleuven.ac.be'); +insert into FPdev values ('2','Florian Klaempfl','ba2395@fen.baynet.de'); +insert into FPdev values ('3','Carl-Eric Codere','codc01@gel.usherb.ca'); +insert into FPdev values ('4','Daniel Mantione','d.s.p.mantione@twi.tudelft.nl'); +insert into FPdev values ('5','Pierre Muller','muller@europe.u-strasbg.fr'); +insert into FPdev values ('6','Jonas Maebe','jmaebe@mail.dma.be'); +insert into FPdev values ('7','Peter Vreman','pfv@worldonline.nl'); +insert into FPdev values ('8','Gerry Dubois','gerry@webworks.ml.org'); +insert into FPdev values ('9','name9','mail9'); +insert into FPdev values ('10','name10','mail10'); +insert into FPdev values ('11','name11','mail11'); +insert into FPdev values ('12','name12','mail12'); +create table test ( +timestamp_fld timestamp, +smallint_fld smallint, +integer_fld integer, +float_fld float, +double_fld double precision, +char_fld char(10), +varchar_fld varchar(50)); +insert into test values ('12.1.2000 00:30',10,70000,12.5,20.5,'testchar','testvarchar'); +commit; +EOF +if [ ! $? = 0 ]; then + echo "Failed." +else + echo "Done." +fi +# Ready |