>>>>> On Sat, 11 Apr 2009 14:39:04 +0800, Craig Ringer said:
> 
> The same schema definition was used for all tests; the only change was
> appending "ENGINE=MyISAM" or "ENGINE=InnoDB" for the MySQL tests. The
> schema was:
> 
> CREATE TABLE file (
>     fileid bigint NOT NULL,
>     fileindex integer DEFAULT 0 NOT NULL,
>     jobid integer NOT NULL,
>     pathid integer NOT NULL,
>     filenameid integer NOT NULL,
>     markid integer DEFAULT 0 NOT NULL,
>     lstat text NOT NULL,
>     md5 text NOT NULL
> );

The schema you used for the native types would be useful to know too...

__Martin

------------------------------------------------------------------------------
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users