1 From: Eric Bollengier <eric AT eb.homelinux.org>
3 This patch allow you to use Batch insert mode with all database.
4 It have tested this with postgresql 8.1 and mysql 4.1 and sqlite.
5 You have to add to src/baconfig.h
6 #define HAVE_BATCH_FILE_INSERT 1
8 and you MUST change some indexes.
12 ALTER TABLE Filename DROP INDEX Name;
13 ALTER TABLE Filename ADD UNIQUE (Name(255));
15 ALTER TABLE Path DROP INDEX Path;
16 ALTER TABLE Path ADD UNIQUE (Path(255));
20 DROP INDEX filename_name_idx;
21 CREATE UNIQUE INDEX filename_name_idx on filename (name);
23 DROP INDEX path_name_idx;
24 CREATE UNIQUE INDEX path_name_idx on path (path);
28 Revision 1.2 2007/01/01 16:52:05 ricozz
29 ebl add #define in readme
32 Revision 1.1 2006/12/20 18:47:42 ricozz
33 ebl works with 1.39.30