From: Eric Bollengier <eric AT eb.homelinux.org>

This patch allow you to use Batch insert mode with all database.
It have tested this with postgresql 8.1 and mysql 4.1 and sqlite.
You have to add to src/baconfig.h
#define HAVE_BATCH_FILE_INSERT 1

and you MUST change some indexes.

mysql)

ALTER TABLE Filename DROP INDEX Name;
ALTER TABLE Filename ADD UNIQUE (Name(255));

ALTER TABLE Path DROP INDEX Path;
ALTER TABLE Path ADD  UNIQUE (Path(255));

postgresql)

DROP INDEX filename_name_idx;
CREATE UNIQUE INDEX filename_name_idx on filename (name);

DROP INDEX path_name_idx;
CREATE UNIQUE INDEX path_name_idx on path (path);

sqlite)

drop index inx2;   
drop index inx1;   
CREATE UNIQUE INDEX path_name_idx on path (path);
CREATE UNIQUE INDEX filename_name_idx on filename (name);

$Log$
Revision 1.2  2007/01/01 16:52:05  ricozz
ebl  add #define in readme
ebl  works with 2.0.0

Revision 1.1  2006/12/20 18:47:42  ricozz
ebl  works with 1.39.30