>>>>> 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
