File: interbase.create.sh

package info (click to toggle)
sqlrelay 1%3A0.37.1-3.1
  • links: PTS
  • area: main
  • in suites: etch, etch-m68k
  • size: 13,084 kB
  • ctags: 6,691
  • sloc: cpp: 48,136; python: 10,118; ansic: 9,673; java: 9,195; php: 8,839; perl: 8,827; sh: 8,554; ruby: 8,516; tcl: 5,039; makefile: 3,665
file content (7 lines) | stat: -rw-r--r-- 425 bytes parent folder | download | duplicates (2) 
1
2
3
4
5
6
7
 
#!/bin/sh

echo "create table testtable (testinteger integer, testsmallint smallint, testdecimal decimal(10,2), testnumeric numeric(10,2), testfloat float, testdouble double precision, testdate date, testtime time, testchar char(50), testvarchar varchar(50), testtimestamp timestamp);" > createscript.sql

/opt/firebird/bin/isql -u testuser -p testpassword '/opt/firebird/testdb.gdb' -i createscript.sql

rm createscript.sql