> > What I need to do is install a test Firebird and Postgres server so I > can subject them to the unit testing, but in lieu of that at least we > have your real application to test. >
I was trying to setup firebird yesterday. one tip: the cli client isn't in the server package, it is in: http://packages.ubuntu.com/edgy/misc/firebird2-utils-classic and it is called isql-fb. (i think.) Uwe - can you give us the steps (script would be best) to create a db? Something like the bash script below would be great. Carl K # mkdb.sh # makes a database on MySql # it requires the daboadmin user be setup using the following command: # mysql -u root --execute "create user daboadmin; grant ALL PRIVILEGES on *.* to daboadmin identified by 'dabo0' with grant option;" mysql -u daboadmin <<EOF DROP DATABASE IF EXISTS dabotest3; CREATE DATABASE dabotest3; GRANT ALL ON dabotest3.* TO dabouser IDENTIFIED BY 'dabo1'; use dabotest3; -- -- Table structure for table all_types -- DROP TABLE IF EXISTS All_types; CREATE TABLE All_types ( kAll_types_pk int auto_increment primary key, xbit bit(1) NOT NULL, xtinyint tinyint(4) NOT NULL, xutinyint tinyint(4) unsigned NOT NULL, xboolean tinyint(1) NOT NULL, xsmallint smallint(6) NOT NULL, xusmallint smallint(6) unsigned NOT NULL, xmediumint mediumint(9) NOT NULL, xumediumint mediumint(9) unsigned NOT NULL, xint int(11) NOT NULL, xuint int(11) unsigned NOT NULL, xbigint bigint(20) NOT NULL, xubigint bigint(20) unsigned NOT NULL, xfloat float NOT NULL, xdouble double NOT NULL, xdecimal decimal(10,0) NOT NULL, xdate date NOT NULL, xdatetime datetime NOT NULL, xtimestamp timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, xtime time NOT NULL, xyear year(4) NOT NULL, xchar char(10) NOT NULL, xvarchar varchar(100) NOT NULL, xnchar char(10) character set utf8 NOT NULL, xnvarchar varchar(100) character set utf8 NOT NULL, xbinary binary(10) NOT NULL, xvarbinary varbinary(100) NOT NULL, xtinyblob tinyblob NOT NULL, xtinytext tinytext NOT NULL, xblob blob NOT NULL, xtext text NOT NULL, xmediumblob mediumblob NOT NULL, xmediumtext mediumtext NOT NULL, xlongblob longblob NOT NULL, xlongtext longtext NOT NULL, xenum enum('a','b','c') NOT NULL, xset set('james','john','sally') NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; INSERT INTO All_types VALUES (0, 0,1,1,1,2,2,2,2,2,2,2,2,3,3,'3','2006-11-07','2006-11-07 04:17:22','2006-11-07 11:22:19','12:32:00',2006,'ccc','vcvc','ncnc','nvnv','bbb\0\0\0\0\0\0\0','vbvb','tbtb','tttt','bbb','ttt','mbmb','mtmt','lblb','ltlt','a','james'); create table TableBit ( kTableBit_pk int auto_increment primary key, xFid1 Bit ) ; create table TableChar10 ( kTableChar10_pk int auto_increment primary key, xFid1 Char(10) ) ; create table TableFloat ( kTableFloat_pk int auto_increment primary key, xFid1 Float ) ; create table TableNumeric4 ( kTableNumeric4_pk int auto_increment primary key, xFid1 Numeric(4) ) ; create table TableDecimal42 ( kTableDecimal42_pk int auto_increment primary key, xFid1 Decimal(4,2) ) ; insert into TableDecimal42 (xFid1) values (1) EOF _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
