3 INSERT INTO config.upgrade_log (version) VALUES ('0209');
5 CREATE INDEX metabib_title_field_entry_value_idx ON metabib.title_field_entry (SUBSTRING(value,1,1024));
6 CREATE INDEX metabib_author_field_entry_value_idx ON metabib.author_field_entry (SUBSTRING(value,1,1024));
7 CREATE INDEX metabib_subject_field_entry_value_idx ON metabib.subject_field_entry (SUBSTRING(value,1,1024));
8 CREATE INDEX metabib_keyword_field_entry_value_idx ON metabib.keyword_field_entry (SUBSTRING(value,1,1024));
9 CREATE INDEX metabib_series_field_entry_value_idx ON metabib.series_field_entry (SUBSTRING(value,1,1024));
11 CREATE INDEX metabib_author_field_entry_source_idx ON metabib.author_field_entry (source);
12 CREATE INDEX metabib_keyword_field_entry_source_idx ON metabib.keyword_field_entry (source);
13 CREATE INDEX metabib_title_field_entry_source_idx ON metabib.title_field_entry (source);
14 CREATE INDEX metabib_series_field_entry_source_idx ON metabib.series_field_entry (source);